Dubsado, HoneyBook, Moxie or Airtable? Answer a few questions about how you work and I’ll tell you which one fits, and what to set up first.
Turning hot mess operations into businesses that run without your constant attention... and loving every damn minute of it.
Year-end giving is when many small nonprofits send their biggest appeal of the year, and that appeal can only go as well as the donor list behind it. If your donors are split between a spreadsheet, a payment processor and somebody’s inbox, the most useful fundraising work you can do in November is a couple of weeks of donor database cleanup before the first letter or email goes out.
I’ve worked in and with nonprofits since 2014, first running programs and later building the systems behind them. The year-end problems I see most often come from the list itself:
All four get fixed in the donor list, before anyone writes a word of the appeal.
Everything you do in December depends on your donor database answering four questions quickly: who gave, how much, when, and who asked not to hear from you. When those answers are spread across different tools, every appeal list and every receipt means rebuilding them by hand, during the busiest weeks of your year. Fix the list once in November and December gets a lot quieter.
Steps 1 to 3 clean the list, step 4 sorts it, and steps 5 and 6 get the thank-yous ready:
Pull this year’s gifts from everywhere money comes in: your online giving page or payment processor, checks you deposited, event tickets and sponsorships, and any peer-to-peer or social media fundraisers. Pick one place to be the record, a donor CRM if you have one or a single spreadsheet or Airtable base if you don’t, and enter every gift there with the donor, the amount, the date and how it came in. The other tools can keep their own copies, but this is the one you trust when the numbers disagree.
Grants usually belong in their own tracker with their own deadlines. If that’s a mess too, How to Build a Grant Tracking System for a Small Nonprofit walks through setting one up, but leave it until after the appeal goes out.
The same person shows up twice when they give two different ways: once from the online form with their email address, and once from a check with their mailing address. Search for matching last names and street addresses, merge the records, and keep every gift attached to the merged donor. While you’re in there, decide whether you count gifts by person or by household. A couple who each gave separately should get one letter and one thank-you that names them both.
Fix the addresses on anything that came back as returned mail this year. Then add a do-not-contact flag, or separate do-not-mail and do-not-email flags, for anyone who asked to stop hearing from you, anyone who has died, and anyone who unsubscribed from your email list. Your email tool already skips its own unsubscribes, but a printed letter only skips someone if your donor list says so.
An appeal works better when it speaks to the relationship each donor actually has with you. Most small nonprofits only need five groups:
If your donor database can’t produce these five lists in a few minutes, steps 1 through 3 aren’t finished yet.
December gifts come in fast, and thank-yous written by hand in January show up weeks late. Write the receipt email and the receipt letter now, so every gift gets thanked the same week it comes in.
The IRS sets what the receipt needs for larger gifts. For any single gift of $250 or more, the donor needs a written acknowledgment from you to claim the deduction, generally by the time they file their taxes. It should include your organization’s name, the amount of a cash gift (or a description of a noncash gift, without its value), and a statement of whether you gave anything in return. When someone pays more than $75 and gets something back, like a gala dinner, you also owe them a statement of how much is deductible and a good faith estimate of what they received.
Most small nonprofits send the same receipt for every gift no matter the size, which keeps it simple and means you don’t have to check amounts before hitting send. In January, send a giving summary to anyone who gave more than once during the year, listing each gift, so they have one document for their taxes.
Gifts keep arriving between Christmas and New Year’s, often while the office is closed. Decide now who enters checks and online gifts that week, and how often, so a gift made on December 31 is recorded in the right year and its donor still gets thanked within days.
Wait until January. Switching in November means learning a new tool during your busiest weeks and moving giving history at the same time you’re receiving it. Clean what you have now, run the season on it, and move once the year-end receipts are out.
If you suspect the spreadsheet is the real problem, Signs Your Nonprofit Has Outgrown Its Spreadsheets will help you decide. For a small nonprofit whose donors, volunteers and programs all need to connect, an Airtable setup can keep donor records in the same base as everything else, so a volunteer who becomes a donor is one person instead of two.
First Fruits Farm is a nonprofit farm in North Carolina that grows produce for hunger relief. Volunteers, tour groups, partner organizations and sponsors were all writing into the same inbox, and every next step depended on someone remembering to send it. In their done-for-you Dubsado setup, each of those groups got its own path, from the first form they fill out to the last thank-you email. The setup has 74 workflow steps, and 70 of them run automatically, so the team spends more time in the field and less time answering email. You can read the First Fruits Farm case study for the full build.
That’s the same idea as step 5: decide once what the thank-you says and when it goes, and every donor gets it on time without anyone writing it again.
If this checklist took your team more than a couple of weeks, next year can start from a donor system where gifts, donors and thank-yous are connected from the beginning, so the November prep is a quick check of lists that are already right. That’s what I build on my nonprofit systems projects, usually starting with a Systems Blueprint Intensive so the build matches how your team actually works.
I won’t start a project without a discovery call, so that’s always the first step. Fill out the contact form and you can book one from there.
Start the donor database cleanup a couple of weeks before your first year-end appeal goes out, so there is time to merge duplicates and write the receipts. For an appeal that goes out in late November or early December, that means starting in early November.
For a single gift of $250 or more, the IRS says the written acknowledgment should include your organization’s name, the amount of a cash gift or a description of a noncash gift, and a statement of whether you provided anything in return. If you did, include a good faith estimate of its value. Many nonprofits send that same receipt for every gift.
LYBUNT stands for “last year but unfortunately not this year”: a donor who gave last year and hasn’t given yet this year. They’re worth their own version of your year-end appeal, because the letter can remind them what their last gift did.
Usually not. Clean the system you have, run your year-end appeal on it, and plan the move for January, after the year-end receipts and giving summaries have gone out.
Explore the services
Dubsado can run your whole client experience, from first inquiry to final invoice, when it’s built on a process someone actually mapped.
See the details →Airtable can hold your whole operation in one place: clients, projects, revenue, and the dashboards that show you what’s actually happening.
See the details →Systems built in the platform your business already runs on, or built custom from scratch. Mapped first, then built and connected.
See the details →Nonprofit systems in Airtable or the platform that fits, designed around how your organization really runs.
See the details →Ongoing COO-level support to maintain and refine your systems as the business grows so operations stay steady and decisions stop piling up on your plate.
Custom Dubsado, Airtable, and Moxie systems designed for capacity, not survival. Built around how your business actually runs so growth does not create more chaos.
Map, audit, or optimize the system that is slowing your business down. Workflows, offers, tech stacks, or the process that keeps living in your head instead of your business.
services
In this power-packed session, I show you how to connect Airtable + your CRM for smarter tracking, simplified workflows, and insights that actually move your business forward.
A step-by-step guide to setting up your new Dubsado account, area by area, so your trial ends with a system you can actually use.
© 0000 Cait Potter Creative, LLC
Privacy Statement and Terms & Conditions