Industry Use Cases

How to Match Nonprofit Donations to Processor Payouts

Your donor system shows $8,400 raised this week. The bank deposits show a lower figure. Finance needs to know what settled, what is pending and which differences still need support.

What to pull

Use Excel gift, payout and bank tabs or export gift transactions from fundraising software, settlement detail from the processor and deposits from banking. Keep references, currency, fees and refunds.

How to check it

Link gifts to processor transactions and group by payout ID. Reconcile net deposits. Keep off-platform gifts and outstanding settlements separate.

Select the relevant sheets in Jolene.pro and run this check.

Which gifts or adjustments explain the payout difference? Show outstanding items and source rows.

What to do with the result

Send finance the unmatched deposit or transaction references. Post confirmed fees and refunds to the appropriate accounts under your normal process.

Sample figures. Use approved accounting treatment and verify against original statements.

Try Jolene.pro ยท Follow Jolene.pro on LinkedIn

Leave a comment