Guide

Connecting your donor database to your accounting, so donations reconcile

18 min read

By . Published . Last updated . Reviewed by Mavrin Labs on . How this guide was researched and checked.

A card reading "Connecting your donor database to your accounting, so donations reconcile" beside the Mavrin Labs logo
The card that shows when this guide is shared or linked.

Your donor database, often called a CRM, is the program that records who gave, what each gift was for and who gets the thank-you, while your accounting system records the money. Connecting the two means each gift is entered once and both systems agree on it, so the board, the auditor and the donor all see the same gift.

The guide is written for the finance or operations lead of a nonprofit with paid staff, a board and an outside accountant or auditor. It covers why the two systems disagree, what to map, whether to integrate or reconcile, what a sync should do and what a person still checks. It is not tax, audit or legal advice.

Sources last checked Monday, November 16, 2026, or, where a citation says so, a later date. Mavrin Labs reviews this guide every quarter, and each source's own page always wins over it.

What is a donor database integration?

A donor database integration is a software link that posts each gift from the donor database into the accounting system by written mapping rules, so a gift is entered once and both systems agree on it. It replaces the retyping, not the monthly check.

It is one kind of link between a CRM and another system, which the page on what a CRM integration is defines in general.

Most links post one summary for each deposit batch rather than every single gift, and they stop at any code they do not recognize. Whether you need a link at all is a later question in this guide, because the monthly reconciliation comes first either way.

Why it matters: more gifts to match each month

Most charitable money in the U.S. comes from individuals, and a donor database is where those gifts are recorded.

Giving USA 2026 puts giving by individuals at $394.2 billion of the $617.20 billion given in 2025 (the Giving USA announcement, checked Monday, November 16, 2026). Each gift has to reach the books once, with the right fund, date and restriction.

Matching gifts by hand is clerical work, and the hours it takes are paid hours. A clean map and a monthly sheet save those hours for the questions that need a person.

Why do the donor database and the accounting system disagree?

The donor database and the accounting system disagree because they record different events for different jobs. The database records a gift when a donor makes it, and it credits the people connected to that gift. The books record money when it moves, and they follow accounting rules on promises and restrictions. Both can be right and still show different totals.

Six causes explain most of the gap: timing, pledges, fees, soft credits, returned gifts and restricted gifts (gifts a donor has limited to a purpose or a period). Each one below says what each system records and what to agree before anyone builds a link.

The donor givesTiming starts here: the gift dateThe donor database recordsthe giftPledges and soft credits enter hereThe payment processor paysout a batchFees come off, and the date movesThe bank receives the depositReturned or reversed gifts comeback hereThe books record the moneyRestrictions and the pledge rulesapply hereThe monthly sheet explainseach gapA person signs it
One gift's path from the donor to the books, with the point where each of the six causes of a gap comes in. The filled square is the monthly sheet a person signs.
  • When does each system record a gift?

    Each system records a gift on a different date, and the database should record the day the donor gave, which is the date the thank-you letter usually states. The bank records the deposit later, when the payment processor pays out a batch of gifts at once.

    The books follow the deposit date or the gift date, depending on your accounting method.

    The IRS treats the date of a gift as the day the donor gave it to the charity (its publication on charitable contributions). A gift made on the last day of a month can therefore sit in different months in the two systems. Write it on the monthly sheet as a timing item, so nobody chases it twice.

  • Why does a pledge look different in each system?

    A pledge looks different because the database and the books count promises in different ways. The database usually tracks a pledge as a commitment and counts each payment as it arrives. Under the accounting rules many nonprofits follow, the books may record an unconditional promise as revenue when it is made, well before the cash comes in.

    The Financial Accounting Standards Board (FASB) writes those rules. Its update on contributions received, issued in June 2018, says a promise is conditional only when the agreement holds both a barrier the nonprofit must get past and a right for the donor to take the money back or be released from paying.

    A conditional promise stays out of revenue until the barrier is met, while an unconditional one counts right away (the FASB update).

  • How the barrier test came about

    The test is fairly new. The update's own summary says nonprofits had long found it hard to tell a grant that is a gift from one that pays for a service, and to tell when a gift is conditional, with practice varying most for government grants (the update's summary, checked Wednesday, November 18, 2026).

    Before June 2018, a promise whose condition was judged remote counted as unconditional at once. The barrier test replaced that judgment with two features anyone can look for in the agreement.

  • Where do processing fees go?

    Processing fees go wherever your finance lead decides, and the sync has to follow that one rule every time. A donor who gives online is thanked for the full gift, but the payment processor deposits the gift minus its fee, often bundled with other gifts. So the database shows the full gift while the bank shows less.

    Recording the full gift and the fee as two lines keeps both visible in the books, while posting only the deposit hides the fee inside the gift. Some donors also choose to cover the fee, which raises the gift itself. Agree in writing how your books record each case.

  • Why do soft credits make totals look too high?

    Soft credits make totals look too high when a report adds them to the real gifts. A soft credit gives recognition for a gift to someone who did not pay it, such as a spouse, a board member who asked, or the person behind a donor-advised fund grant.

    The database counts it in that person's history, while the books record the money once, from whoever paid it.

    Year-end reporting depends on that difference.

    Under the general rule of its instructions, Schedule B of Form 990 (the annual information return most tax-exempt organizations file with the IRS) lists each contributor whose gifts in the year reach the amount that rule sets, with that contributor's gifts totaled, including gifts made indirectly (IRS instructions for Schedule B, checked Monday, November 16, 2026).

    Keep soft credits out of any total you compare with the books, and let your return preparer decide who counts as the contributor.

  • What happens when a gift is returned or reversed?

    A returned or reversed gift has to be undone in both systems, with a record of why, such as a check the bank returns or a card charge the donor takes back. Gifts of $250 or more also carry a written acknowledgment under IRS Publication 1771, which may need correcting (IRS Publication 1771, checked Wednesday, November 18, 2026).

    A gift can also go back to the donor at their request, and it is undone the same way.

    The bank takes the money back in the month it happens, which may be well after the month of the gift.

    Never delete the original gift in the database to make the totals match. Record a reversal linked to the original, so both systems show the gift and its undoing. If a thank-you letter has already gone out, decide whether the donor needs a corrected one.

    A corrected letter has to hold what the first one did. The IRS's page on written acknowledgments lists it: the charity's name, the amount of a cash gift, a description of any gift that is not cash, and whether the donor received anything in return, with a good-faith estimate of its value (IRS page on written acknowledgments).

  • How do restricted gifts differ between the two systems?

    Restricted gifts differ because the database stores what a donor asked for, while the books track whether the money is still bound by that request. A restricted gift is one the donor limited to a purpose or a time, such as one program.

    The database marks it with a fund code, and the books hold it as net assets with donor restrictions until the purpose is met or the time arrives. That class, and its partner without donor restrictions, come from FASB's August 2016 update on nonprofit statements (the FASB update on net assets).

    The same FASB update classes each unconditional contribution as either with or without donor restrictions (the update's summary). When the restriction is met, the books record a release from it, and the database never sees that step. Not every fund code is a restriction either, so the written map says which codes bind the organization.

What should you map between the two systems?

Map each code the donor database uses to exactly one place in the accounting system, and write the map down before anyone builds a sync. Three codes matter most. A fund says what a gift is for, and a campaign says why it came in, such as a spring appeal or a dinner.

A class is the tag the books use to report by program.

Each fund maps to one revenue account, one restriction status and one class. Campaigns usually stay in the database, because the books need only the kind of revenue. A gift with no mapping should wait for a person, never land in a catch-all account.

What should you map between the two systems?
Database code What it says Where it lands in the books Who signs off
Fund What the gift is for A revenue account, a restriction status and a class Finance lead
Campaign or appeal Why the gift came in The kind of revenue, such as gifts or event income Development lead and finance lead
Gift type Cash, stock, goods or services A separate account for gifts that are not cash Finance lead, with the auditor on values
Batch number Which deposit the gift belongs to The memo on the journal entry for that deposit Whoever posts the deposit

Event gifts need one more split. When a donor pays for a dinner ticket, part of the payment buys the meal and only the rest is a gift.

Above an amount the IRS sets, the charity must give the donor a written statement with a good-faith estimate of what the donor received. Record the two parts separately, and map each part to its own account.

Should you integrate the two systems or reconcile them each month?

Reconcile the two systems every month, whether or not software connects them. Reconciling means comparing the totals, explaining every difference and fixing the record that is wrong. Integration is a separate decision: an integration moves gifts into the books by software instead of by hand, and it earns its place only once the map has stopped changing.

Integration removes the typing, not the checking, because a sync can only repeat the rules it was given.

Reconciling by hand is enough while:

  • gifts are few, and most arrive by check;
  • fund and campaign codes still change often;
  • one person enters the gifts and can explain each one.

Integration earns its place once:

  • online gifts arrive in payout batches every week;
  • staff type the same gift into both systems;
  • the map has stayed the same through several month-ends;
  • your finance lead can write down every rule the sync must follow.

How do you reconcile donations with the books each month?

You reconcile donations with the books each month in five steps, from closing the month's gift batches to signing the sheet. One person prepares it and a second person reviews it, so nobody checks their own work. The steps stay the same every month, so the one-page sheet further down can be reused each time.

  1. Close the batches. Finish entering the month's gifts and close each deposit batch in the database.
  2. Total both sides. Total the database by fund and by batch, and the books by account and class, for the same dates.
  3. Match the deposits. Tie each batch to a bank deposit and to the journal entry that recorded it.
  4. Explain each gap. List every difference with its cause: timing, a pledge, a fee, a soft credit, a returned gift or a restriction.
  5. Fix at the source. Correct the wrong record in the system where it was first entered, then sign and date the sheet.

What should a sync do, and what should it never do?

A sync should move agreed totals from the database into the books, by the rules your finance lead wrote, and stop at anything it does not recognize. A sync is the software link that copies records from one system to another on a schedule.

Give the sync its own sign-in, with only the access its job needs. NIST calls this least privilege: each user or process gets the smallest set of permissions its task requires (the NIST glossary entry). A sync that signs in as a staff member can do anything that person can.

A sync should:

  • post one summary entry for each deposit batch, split by fund, account and class;
  • carry the batch number into both systems, so anyone can trace a deposit to its gifts;
  • hold any gift with an unmapped code in a queue for a person;
  • keep a log of what moved, what waited and who released it.

A sync should never:

  • create accounts, funds or classes in the books on its own;
  • post into a month your finance lead has closed;
  • change or delete a gift in the database to match the bank;
  • copy donor names and notes into the books when a summary will do;
  • send a thank-you or any other message before a person approves it.

What does a person still check?

A person still checks every difference the sync cannot explain, and every decision that needs judgment. Software can total, match and flag, but it cannot tell whether a gift was restricted or a pledge had a condition, so a person reads those cases before the month is closed.

Thank-you letters need the same care, because the letters come from the database and their amounts have to match the books.

A donor needs a written acknowledgment for any single gift of $250 or more, and the charity's statement gives the amount and says whether the donor received anything in return (IRS Publication 1771, checked Wednesday, November 18, 2026).

A payment of more than seventy-five dollars that is partly a gift, such as a dinner ticket, needs a written statement with a good-faith estimate of what the donor received (the same IRS publication).

Each month, the person checks:

  • that the unexplained line on the sheet reads zero;
  • any new fund or campaign code, before its first gift;
  • restricted gifts received, and releases when a restriction is met;
  • pledges and grants with conditions, against their payment schedule;
  • at year-end, contributor totals for Schedule B, taken from real gifts and not soft credits.

What does a one-page reconciliation sheet look like?

A one-page reconciliation sheet starts from the database total and ends at the bank deposits, with one line for each cause of difference. Copy the table below into your own spreadsheet, keep one sheet for each month, and file it with that month's bank statement.

If the same line appears month after month, fix its cause rather than explaining it again.

What does a one-page reconciliation sheet look like?
Line on the sheet What it shows
Gifts in the database The month's gifts by fund, from the database's own report
Soft credits Recognition that is not money, taken out of the total
Timing items Gifts made this month but deposited next month, and the reverse
Processing fees What the processor kept from each payout
Returned or reversed gifts Each one, with the date of the original gift
Event benefits The part of each ticket that bought something, recorded outside the gift
Deposits in the bank The month's deposits, which the lines above should reach
Pledges and restricted gifts New promises, payments, restrictions and releases, set beside the books
Unexplained difference What is left over, which should read zero
Sign-off Who prepared the sheet, who reviewed it and the dates

How can Mavrin Labs help connect the two systems?

Mavrin Labs helps by building the link between a donor database and an accounting system, as part of its CRM and systems integration service. A sync it builds follows the map your finance lead approves, holds any gift it cannot place and, by default, sends nothing to a donor until a person approves it.

Every engagement starts with a workflow assessment, and a build includes a written design plan and acceptance tests, so your finance lead can check the map before any link goes live.

A care plan covers monitoring, fixes and updates when a provider changes something. Mavrin Labs never uses client data to train AI models, and your organization owns all of its data.

Mavrin Labs gives no tax, audit or legal advice. The page on how a Mavrin Labs build treats your data sets out each data term in full.

Key takeaways

  • The two systems disagree for ordinary reasons: timing, pledges, fees, soft credits, returned gifts and restrictions.
  • Map every fund, campaign and class to one place in the books, and write the map down.
  • Reconcile every month, whether or not a sync connects the systems.
  • Let a sync move agreed totals, and leave every accounting decision to a person.
  • Keep one signed sheet a month, with the unexplained difference at zero.

Sources behind this guide

Every source in this guide was last checked on one of the two dates at the top of the page, and the guide is reviewed quarterly. The table below pairs each outside fact with its publisher.

Sources behind this guide
Fact Source
The date of a gift, what a thank-you letter states, and the statement for a payment that is partly a gift IRS publication on charitable contributions
When a promise counts as revenue, and gifts with or without donor restrictions FASB update on contributions received
Which contributors the annual return lists, and how their gifts are totaled IRS instructions for Schedule B
Each user or process gets only the access its task needs NIST glossary entry on least privilege
Giving in 2025, and the share from individuals Giving USA announcement
The two classes of net assets FASB update on nonprofit financial statements
What a written acknowledgment must hold IRS page on written acknowledgments

A processor's own payout schedule is the place to confirm when its batches reach the bank. This guide names no processor, so read your processor's help pages for the timing that applies to you.

Corrections and changes, newest first:

  • Wednesday, November 18, 2026: the IRS publication on charitable contributions was read again and its dated citations now give that date. A passage on why the contribution rules changed, a diagram of one gift's path, and two primary sources (the FASB update on net assets and the IRS page on written acknowledgments) were added.
  • Tuesday, November 17, 2026: the title and main heading changed to name reconciling donations, the paragraph pointing to the donor follow-up demo was removed with the demos, and the written-acknowledgment rule was added to the section on returned gifts.
  • Monday, November 16, 2026: the definition section and the section on why it matters were added with the Giving USA figures, and the paragraph on the IRS publication was split.

Where to go next

The page for nonprofits shows the workflows Mavrin Labs looks at first for nonprofits with paid staff. Systems integration explains how a link is mapped, tested and watched.

If the books are not the first fix, the six-question project finder asks where your team's hours go and points to the project to start with.

For duplicate records and failed messages, work through the integration checklist. If the same gift data feeds board and funder reports, data and reporting covers how those reports come together, and the guide to nonprofit grant reporting straight from the books shows how restricted gifts reach each funder's report.

If a link between the two systems is worth building, the guide to the technology grants for nonprofits Florida foundations offer locally sets out who might pay for part of it. To talk through one workflow, start a conversation.

Frequently asked questions

Should donor names go into the accounting system?

Donor names rarely need to go into the accounting system, because the books report money by fund, account and class rather than by person. One summary entry for each deposit keeps donor details in the database. Your finance lead and your auditor decide whether any gift needs a name in the books, such as a large grant with conditions.

Which system is right when the totals differ?

Neither system is right by default when the totals differ, because each one answers a different question. The bank statement settles how much money arrived. The database settles who gave and what each gift was for. The books settle what the organization reports. The monthly sheet explains the gap, and a person fixes the record that is wrong.

Do we need special software to reconcile each month?

You do not need special software to reconcile each month. A gift report from the database, the bank statement and the revenue report from the books are enough, set side by side on the one-page sheet in this guide. Software helps once matching gets slow, but the sign-off stays with a person.

Is this guide tax or audit advice?

Nothing in this guide is tax, audit or legal advice, and Mavrin Labs gives none. The guide explains in plain words what a few public sources say, and it links each one so you can read the source yourself. Your finance lead, your auditor and your counsel decide how your organization records and reports its gifts.

The Mavrin Labs mark

Who writes these guides

Client work at Mavrin Labs is delivered by a team in mixed roles, led by our founder. AI tools help with research and drafting, and a person at Mavrin Labs checks each fact against its named source before a guide is published.

Enquiry form

Start with one workflow

Tell Mavrin Labs what is stuck and which systems it touches. A person at the firm reads every enquiry and replies by email.

Start a conversation

Fields marked with an asterisk are the ones a reply needs.

So a reply can address you properly.

The address the reply goes to.

Optional. Give one only if you would rather talk than write; the reply goes by email either way.

Optional, and useful when it says what the work has to fit around.

The result you want, and when you would want it working. Two or three sentences are plenty.

The task as it actually happens, roughly how often it runs, and which systems it touches. Two links at most, please.

Optional.

What you send goes to the Mavrin Labs inbox and is used to answer you, and a phone number, if you give one, is used for the same thing and nothing else.

A person reads it and replies by email.

If the form does not send, write to info@mavrinlabs.com instead; it reaches the same inbox.

Which hours would you take back first?

Name the one workflow that eats the most of your week. Mavrin Labs reads it, and the reply comes from the people who would build the fix.

Start a conversation