How to Reconcile Your Donor CRM With Your Accounting System

Your donor database says you raised $482,000. Your ledger says $471,300. Both can be right. The two systems measure different things, and the gap between them is made of specific, identifiable items rather than error. Knowing which differences are legitimate and which are mistakes is the whole job, and it needs doing well before your annual return is filed.

Why do your donor database and your ledger disagree?

Because one tracks what donors gave and the other tracks what money arrived, and those are not the same number.

Your donor system exists to manage relationships and issue receipts. It records gifts by donor and by campaign, on the date the donor made the gift. Most systems hold several amounts per gift, commonly the gross amount received, any advantage, and the eligible amount shown on the receipt. Establish which field you are pulling before you compare anything, because reconciling a gross total against an eligible total will never balance.

Your accounting system exists to record financial position. It records cash by date received and revenue according to your organization's accounting basis, which may be accrual or cash. The T3010 accommodates both.

Neither is wrong. But if nobody reconciles them, you have two donation totals and no basis for choosing between them, and one of them is going on your annual return.

What are you actually reconciling?

Three totals, not one, and confusing them is why this feels harder than it is.

The first is total receipted gifts: the eligible amount of gifts for which you issued or will issue official donation receipts. This comes from your donor system and it feeds directly onto your return.

The second is total donation revenue in your ledger, which includes gifts you did not receipt and excludes items your donor system counts but your accounting does not.

The third is cash received, which differs from both because of timing and processing.

Start by agreeing the first two, and treat the third as a separate exercise handled through your bank and processor reconciliations.

What causes the most common differences?

Seven items, and six of them are legitimate.

‍

‍

The last row is the point of the exercise. Everything above it is reconciling. Only the last one needs fixing.

Processing fees are deliberately not on this list. Where your charity is the donee and the gift is correctly recorded gross, the fee is an expense and does not create a difference between the donor system and donation revenue. It creates a difference between your ledger and your bank, which is a bank reconciliation matter rather than a donor reconciliation one.

Split receipting is worth understanding, because it produces a difference every single time. Where a donor receives something in return, the receipt shows the eligible amount after deducting the advantage, while the ledger records what was actually received. A $200 gala ticket with a $70 dinner is $200 of revenue and a $130 receipt.

How do you run the reconciliation?

Five steps, and the order matters.

Pull a gift total from your donor system for the period, filtered to gifts actually received rather than pledges.

Pull donation revenue from your ledger for the same period.

List the known reconciling items from the table above: timing differences, in-kind gifts, split receipting advantages, non-receipted gifts and any gifts receipted by a third-party platform.

Apply them and see whether the two totals agree. They should, to the dollar.

Investigate whatever is left. A residual difference means a gift exists in one system and not the other, and you need to know which.

Document the reconciliation and keep it. It is a supporting record for your donation revenue figure, and your records need to support what you report. Our guide to keeping proper books and records covers the obligation.

When should you do this, and why not just at year-end?

Monthly, or quarterly at an absolute minimum. Not annually.

The practical reason is that a difference found in February can be traced. The person who entered the gift is available, the deposit is recent, the donor correspondence is findable. The same difference found the following November is archaeology.

The compliance reason is that your total receipted gifts figure goes on your annual return, and the duplicate receipts behind it have to exist. That figure covers receipts your charity issued. Gifts made through a platform that is itself the donee and issues its own receipt, CanadaHelps being the common example, do not belong in it. Those are reported separately as amounts received from another registered charity. Mixing the two overstates receipts you cannot support. Our guide to the T3010 covers the return.

There is a donor-facing reason too. A gift missing from your donor system means someone who gave did not get a receipt, and did not get acknowledged. That is a fundraising problem before it is an accounting one.

Who does what?

Your bookkeeper reconciles the totals. Your charity maintains the donor system. These are separate jobs and the boundary is worth stating clearly, because it is where expectations most often diverge.

A bookkeeping engagement reconciles the totals your donor system reports against the ledger, identifies differences and records the accounting entries. It does not normally include entering donations into your donor database, maintaining donor records, or issuing year-end acknowledgements to donors. Our scope of service page sets out where that line sits.

What your bookkeeper needs from you each period is a small, fixed set: a gift total for the period from your donor system, a breakdown of receipted against non-receipted gifts, a list of in-kind gifts with values, and details of any split receipting. Supply those four consistently and the reconciliation takes minutes. Supply them at year-end only and it takes days.

If your donor and accounting systems have never been reconciled, our charity bookkeeping service page sets out how this runs inside a monthly cycle, and our guide to recording charitable donations in QuickBooks covers the accounting side.

Frequently Asked Questions

Why does our donor database show more than our accounting system?

Usually pledges. Most donor systems record a promised gift as soon as it is committed, while your ledger records revenue when it is received or earned. Timing differences at period end and in-kind gifts valued differently in the two systems are the other common causes.

How often should we reconcile the two systems?

Monthly is best, quarterly is the minimum. Annual reconciliation means differences surface eleven months after they occurred, when the supporting information and the people who remember it are both much harder to reach.

Which number goes on our T3010?

The total eligible amount of gifts for which your charity issued official receipts, which normally comes from your donor system. It has to be supported by the duplicate receipts you are required to keep, and it should be reconciled to your ledger before filing. Exclude gifts receipted by a third-party platform that was itself the donee, because those are reported on a separate line.

Does our bookkeeper enter donations into our donor system?

Normally no. Entering donations into a donor database, maintaining donor records and issuing acknowledgements sit outside a typical bookkeeping engagement. Your bookkeeper reconciles the totals your donor system produces against the ledger. Confirm the boundary with your provider before you assume either way.

What if we find a gift in the ledger with no donor record?

Trace it to the deposit and the source document to identify the donor. If the gift is genuinely anonymous, record it as a non-receipted gift, because a receipt cannot be issued to an unknown donor. If the donor is identifiable, add the gift to the donor system and issue a receipt if the gift qualifies and your charity's receipting policy calls for one. Charities are not obliged to receipt every qualifying gift, so follow your own policy consistently.

This article provides general information about bookkeeping practice and Canadian charity compliance. It is not accounting, tax or legal advice. Speak with a qualified adviser about your organization's circumstances.

‍