The Online Donation Reached the Bank. Why Can the Teams Still Not Reconcile It?

The online donation has reached the bank account, so why can fundraising, finance and administration still not reconcile it? The bank normally receives one net settlement from a payment platform, not an itemised list of donations. Payments from many donors may be combined and reduced by fees, refunds, chargebacks or other adjustments. The bank proves how much the organisation received, but not automatically who gave each donation, which campaign it belongs to, whether a receipt should be issued or which difference remains unresolved.

A bank account may show HK$9,620 on Monday while the fundraising dashboard shows HK$10,000 for the weekend. Administration may already be issuing receipts and finance may still need to determine whether the HK$380 difference is fees, a refund or unsettled transactions. Each figure can be correct because it answers a different question.

Lingxi Insight believes reconciliation is not forcing two totals to match; it is making every donation traceable from donor to bank and back to the original transaction.

First separate six different records

Stripe's reconciliation documentation describes a payout as a settlement of payments and other transactions and distinguishes settled, pending and failed settlements. Names vary between platforms, but the transaction date, platform settlement date and bank deposit date can be three different dates.

Use one numerical example to locate the difference

A matching net total proves the arithmetic; a destination for every item proves traceability.

Suppose 20 online donations total HK$10,000 over a weekend: payment fees are HK$280, one refund is HK$100, and the net bank deposit is HK$9,620. The equation `10,000 - 280 - 100 = 9,620` balances, but reconciliation must still identify the original refunded transaction, any receipt cancellation, the accounting treatment for HK$280, transactions held for the next settlement, anonymous donations and donor designations.

A month-end spreadsheet line saying 'platform fee HK$380' may balance the total while breaking the audit trail. The team will have to reconstruct it again when a donor asks a question, a refund occurs or an audit begins.

Fundraising, finance and administration should not reconcile different versions of the same money

The three teams may see different fields, but they must work from the same transactions and exceptions.

Fundraising and donor relations: confirm who and why

Confirm the donor, campaign, channel, designation, anonymity choice, payment status and acknowledgement details. Check that platform transactions enter the donation records completely. Fundraising does not replace accounting, but it should not hand finance an unexplained total.

Finance: confirm how much and when it entered the bank

Reconcile settlement batches, fees, refunds, chargebacks, unsettled amounts and bank deposits, then confirm the accounting period and classification. Finance must be able to move from the bank's net amount to the batch and then to itemised transactions.

Administration and receipts: confirm how evidence is issued and corrected

Under the organisation's authority, manage receipt generation, review, issue, reissue, cancellation and correction. Receipt numbers should link back to the original donation and any exception. Hong Kong's Inland Revenue Department reminds donors to obtain and keep receipts as evidence for approved charitable-donation deductions.

Job titles may differ, and one person may cover several roles in a small NGO. The three layers of checking should still exist, with clear responsibility for preparation, review and exception approval.

The minimum viable reconciliation data chain

A few shared IDs often matter more than another month-end workaround spreadsheet.

Keep at least an organisation donation ID, payment-platform transaction ID, settlement-batch ID, bank date and amount, receipt number and status, and links between the original payment and any refund, chargeback or adjustment.

Preserve a monthly evidence pack containing itemised platform exports, settlement summaries, bank statements, exception lists, receipt corrections and reviewer details. Do not rely only on dashboard screens that later change, or leave the sole export permission in one colleague's account.

HSBC Hong Kong noted in 2022 that FPS, APIs, payment notifications and automated reconciliation can support NGO digital collections. Automation reduces repeated entry and surfaces differences earlier; it does not decide how a refund should be treated or take over finance's review responsibility.

Five common reasons the money arrived but the records do not match

• Combined settlement. Dozens of transactions reach the bank as one net amount.
• Timing difference. Donations that succeed at month end settle in the following month.
• Net deposit. Fees are deducted before settlement, so the bank never shows gross donations.
• Transaction reversal. A refund or chargeback appears after the donation and the receipt or accounts are not updated.
• Split access. Fundraising sees donors, finance sees payouts, but the bookkeeper cannot export itemised transactions.

Anonymous donations, identical donor names, corporate bulk payments, foreign-exchange differences and platform-issued receipts create further exceptions. Do not overwrite the original value when they occur; add a status and relationship that preserves how the record changed.

How can Lingxi support NGO collections and reconciliation?

Lingxi Hong Kong's online-fundraising page describes multiple payment methods, donation records and automatic electronic receipts. Its natural role is to bring post-payment donation data, campaigns and receipts into the same workflow earlier and reduce repeated manual transfer.

Every actual channel still requires verification: which itemised fields are available, how refunds and chargebacks return, whether settlement batches can be exported, how receipts are cancelled or corrected, and what evidence accounting still needs. No product should use the phrase 'automatic reconciliation' to skip these questions.

Practical next step: trace one settlement in both directions

Choose a recent settlement containing at least a fee or refund. Trace it from the bank to the platform batch and every donation, then take one donation and trace it through payment, batch, bank and receipt. Record each point where someone must be asked, another account opened, a date guessed or a spreadsheet added. Assign an owner, shared ID and evidence requirement to every break.

It is traceable only when both directions work. A matching total is merely the starting point.

FAQ