At some point every treasurer inherits the same job: a year, or three, of giving that lived in a spreadsheet, a shoebox of deposit slips, or the outgoing treasurer's memory, and none of it in the system that is supposed to produce this January's statements. Entering it by hand feels like the boring part of switching software. It is also the part most likely to quietly wreck a total if you rush it.
The good news is that backfilling a year of contributions is not hard. It is just unforgiving of order. Enter things in the wrong sequence — people before households, gifts before funds, corrections after statements — and you end up chasing a number that is off by forty dollars for reasons nobody can reconstruct. Do it in the right order and it is simply a long, quiet afternoon.
Get the people right before you touch a single gift
The most common cause of a wrong year-end statement is not a mistyped amount. It is a gift attached to the wrong person or the wrong household. Before you enter one dollar of history, make sure every giver from the year you are backfilling already has a profile, and that the household groupings match how the church actually wants to receive a statement — one letter per envelope number, one letter per couple, whatever your church's convention is. If a couple gives jointly but you have them as two separate individuals, every gift you enter this afternoon will need to be re-pointed later. Fixing the person comes first; see households versus individuals if you are not sure which unit a given family should be.
Decide your unit of entry before you start typing
Pick, in advance, whether you are entering every individual gift or a monthly total per giver per fund, and hold that decision for the entire year you are backfilling. Switching partway — a line per gift for January through March, then monthly totals for the rest — is how two givers end up with statements that look like they were prepared by two different people, because they were, in effect. If any giver has ever asked for a list of individual gifts, or is likely to, enter at that level for everyone. It costs more time now and saves an awkward phone call in December.
Work fund by fund, not month by month
It is tempting to open the checkbook or the spreadsheet and enter January, then February, then March, moving straight through the calendar. Resist it. Work one giving fund at a time instead — general fund for the whole year, then building fund for the whole year, then any designated funds — and total each one against your own records before moving to the next. A fund-by-fund pass surfaces a missing month immediately, because the fund total for the year will not match what you know it should be. A month-by-month pass hides the same gap inside a total you will not check until the statement is already printed.
Keep undesignated gifts undesignated
Do not assign a fund to a gift just to make the entry feel more complete. If the original record does not say which fund a gift was for, enter it as general or undesignated giving and leave it there. A guessed fund assignment is a small dishonesty that compounds: it changes a fund total a treasurer might later report to the board, and it is exactly the kind of error that is invisible until someone asks why the building fund total does not match the deposit log.
Enter the date the gift was received, not the date you are entering it
Every gift needs the date it actually came in, not today's date. This sounds obvious and is the single most common slip in a backfill session, because the software will happily default to today unless you change it, and after the fortieth entry in a row it is easy to stop checking. A gift dated wrong does not just misplace itself on a chart — it can push a December gift into the wrong tax year on a giver's statement, which is the kind of mistake a faithful giver notices immediately and a treasurer hears about by phone.
Reconcile before you move to the next fund, not at the end
After each fund, stop and compare your running total in the system against whatever record you trust most — the bank deposit log is usually the soundest source, better than the original giving spreadsheet, because a deposit either happened or it did not. If the two totals do not match, find the difference before you move on. A forty-dollar gap discovered after general fund is a five-minute fix. The same gap discovered after you have entered five funds for a full year is an afternoon of re-checking everything, because you no longer know which fund or which month it came from.
Do a full-year sanity check before you generate anything
Once a fund is fully entered and reconciled, pull the giver-level total for the whole year — not just the fund total — and sanity check it against anyone with an unusually large or unusually small number. A household that shows one gift for the entire year, when you know they gave weekly, usually means most of their entries landed under a different spelling of their name or a separate, duplicate profile. Catching that here, before year-end statements are generated, is a ten-minute fix. Catching it because a giver calls to say their statement looks low is a much worse conversation, and it is the reason this whole process is worth doing slowly.
Fixing a mistake is easier before the statement goes out
You will find at least one error in a year-long backfill — a gift entered twice, a fund swapped with another, an amount transposed. Do not treat this as a sign you did the entry badly; it is a sign you checked closely enough to find it. What matters is fixing it the moment you spot it rather than making a mental note to come back to it. Contributions can be edited or deleted after entry, so there is no reason to leave a known error in place while you keep typing — the running total you are about to reconcile against the next fund depends on this one being right first.
The riskier version of this mistake is the one you find after a statement has already gone out. If a giver calls to say their number looks wrong, correct the record the same day, and be straightforward with them about what changed and why. A corrected statement, sent with a plain explanation, costs a church almost nothing in trust. A giver who has to ask twice, or who is told the number is probably fine, loses confidence in the whole system — not just that one figure.
One entry session, not several, if you can manage it
Where possible, do the whole backfill in one sitting per fund rather than a little at a time over several weeks. The reconciliation habit described above works best when the reference numbers — the deposit log, the outgoing treasurer's spreadsheet — are open in front of you the entire time. Coming back to it after a two-week gap means re-finding your place, re-checking what you already reconciled in case you second-guess it, and a higher chance that the last few entries get rushed because the job has started to feel endless. A long afternoon, done once, beats a month of ten-minute sessions that each start with “where was I.”
What backfilling well actually buys you
None of this is about impressing anyone with process. It is about the moment in January when a giver opens an envelope expecting a number that matches what they remember giving, and it does. That quiet confirmation is most of what a giving statement is for. If the history behind it was entered fast and unreconciled, the odds of that moment going wrong climb every year you do not go back and fix it. SundayBridge will hold the year of history you enter and generate the statement from it, but the software has no way to know your spreadsheet had a duplicate row or your deposit log had a typo — that check only happens the afternoon you do the entry carefully. Treat the backfill as the real work and the statement as the easy part, and the trust a giver places in your record-keeping gets repaid in full.
If this is happening alongside a broader move off spreadsheets rather than as a one-time cleanup, it is worth reading moving your church off spreadsheets first — giving history is usually the most sensitive piece of a larger migration, and it goes more smoothly once the rest of the directory is already settled.