Donation reconciliation for events and trips: a worked gift-tracking guide

Donation reconciliation means matching each gift to its confirmation evidence, allocation, and any refund, then explaining differences between the donation records, provider activity, and bank deposits. A campaign total and a bank balance answer different questions. Keep gifts separate from ticket purchases, participant payments, and sponsor agreements throughout the review.

The fictional example below follows six gifts for an event or trip. The amounts and identifiers are invented to demonstrate the method; they are not ADGEvents customer results or provider fee quotations. Download the ungated reconciliation worksheet and replace the sample rows with appropriately restricted records.

Decide what counts before comparing totals

Use a written definition for each status. A submitted form is not a confirmed payment. A checkout return page is not independent payment evidence. A promise to give next month is not money received today. A refund request is not a completed refund.

For this operating example, a confirmed online gift has a provider-confirmed payment reference. An offline cash or check gift has the evidence required by the organization's handling process and a staff-recorded receipt. A later deposit is matched separately. Keep unverified receipts in an exception queue rather than changing their status to make the totals agree.

The National Council of Nonprofits' internal-controls guidance recommends defined responsibilities and checks on financial activity. In practice, name the recorder, the person reviewing confirmation evidence, and the person who resolves exceptions. Where staffing allows, separate receipt handling from review.

Reconcile a small batch, one gift at a time

Here is our fictional batch, expressed entirely in USD. The references are examples, not real transaction identifiers. “Confirmed net” means confirmed gift value less confirmed refunds; it does not mean the amount deposited after processing fees.

Confirmed gross gifts are $930. Confirmed refunds are $20. Confirmed net raised is $910. The unconfirmed attempt contributes zero. The $200 pledge receipt is already in the $910; do not add the original promise on top.

Participant A's $250 is also inside the $910. An allocation report may show it again to explain who the gift supports, but that is not another receipt. Investigate an allocation error using the original gift reference and the organization's approved correction process. ADGEvents preserves the allocation on an existing gift; this is not an instruction to edit a paid gift or create a duplicate.

Explain why provider totals and bank deposits differ

The online part of this example is $630 gross, less the $20 refund: $610 before any fees or other provider adjustments. The $300 check is outside that online provider batch. Even if the campaign correctly shows $910 net raised, a single provider payout should not be expected to equal $910.

Match provider activity using transaction and payout references, not only matching amounts or donor names. Record which transactions belong to a payout and which remain unsettled. Compare the payout to the bank entry using the provider's actual records, including fees, reserves, currency conversion, or other adjustments where applicable. Do not estimate a universal fee percentage to force a match.

Our $300 check still needs its own deposit match. An organization may have received and recorded it before it appears on a bank statement. That timing difference belongs in the review notes with an owner and next action. It should not be hidden by deleting the gift or pretending the deposit has happened.

Keep currencies separate. A USD campaign total and a EUR bank entry need an explained conversion and source record before comparison. This worksheet is an operational control, not a replacement for the organization's accounting records or professional accounting advice.

Give common exceptions a specific next action

Same provider reference appears twice. Check whether two displays refer to one underlying gift. Do not record another manual gift to compensate for a delayed notification. Investigate the duplicate identifier and preserve the evidence used to decide which record is authoritative.

Provider says paid; application says pending. Capture the gift reference, provider reference, amount, currency, and time. Ask the payment administrator to review the provider notification and reconciliation path. Keep the exception open until the application reflects verified evidence; do not treat a donor screenshot alone as a completed reconciliation.

An offline gift looks duplicated. Compare receipt evidence, donor, date, method, amount, and allocation. Two equal gifts can be legitimate. A name-and-amount match is a clue, not proof. Have the reviewer approve any correction under the organization's process.

Refund requested but total unchanged. Check whether the provider completed it. Keep the request and the confirmed refund distinct. Once confirmed, match it to the original gift and verify both campaign and participant views use the reduced net amount.

A payment is actually a ticket, participant balance, or sponsorship. Move the investigation to the correct operational records. Do not turn a participant payment into a donation merely to reach the fundraising goal. Sponsor deliverables and donor acknowledgments also need their own handling.

Keep donor detail out of broadly shared reports

Most committee updates need totals, open exceptions, and assigned actions, not donor emails, addresses, or private messages. Share the minimum detail needed for the task. Store the full reconciliation file only where authorized finance and fundraising staff can access it, and define retention with the organization.

That approach follows the FTC's guidance to minimize collection and limit access. An exported CSV does not retain the application's access controls once downloaded; its storage and sharing become part of your review process. The public worksheet contains fictional references and no donor contact details for that reason.

Close the review with evidence

• Every confirmed gift has the required confirmation or offline receipt evidence.
• Refunds are matched to the original gift and reduce net raised once.
• Participant allocations explain the campaign total without increasing it.
• Pledges and matching commitments stay separate from their received gifts.
• Ticket, participant-payment, and sponsor records are excluded from donation totals.
• Provider payouts and bank entries have their own matches and timing notes.
• Unresolved differences have an owner, due date, and supporting references.
• A reviewer has checked the batch and approved any corrections.

ADGEvents' Donations area separates confirmed gifts, refunds, pledges, matching support, and in-kind records. Its fundraising reports label gross gifts, refunded amounts, and net raised; detailed CSV exports support staff review. It does not replace bank reconciliation or prove that a payout has arrived. Online payment confirmation depends on the organization's configured provider and verified notifications. See the event and trip fundraising workflow for the supported campaign, gift-record, and reporting tools.

Download the donation reconciliation worksheet. Use the mission-trip fundraising plan for campaign decisions, or explore ADGEvents for nonprofits for the surrounding event and trip workflow.