Reconciling event and donation receipts together

How do I tell a reversal from a refund in a deposit report?

Check the gift’s Deposited At column and its refund date. Do not decide from the gift date or the date the customer requested a refund.

• Matching deposit and refund dates: reversal. For a fully refunded gift with matching deposit and refund dates, the gift does not count as either a positive or a negative in the deposit total. Its effect on that deposit is zero. Do not add the original amount as money still owed to the school or subtract it again as an additional deduction.
• Previously deposited gift refunded later: refund. The original positive amount was already included in an earlier deposit. In the deposit report accounting for its refund, the refunded amount counts only as a negative and lowers the total deposit amount. An older refund date does not make the original gift a new positive deposit; check which deposit includes the refund recovery.

A row can still display the original gift amount even when it contributes zero or a negative amount to the deposit being reconciled. A positive amount shown on the row is not, by itself, another bank deposit due to the school.

For GiveCampus reporting.

Online Giving and Events have separate deposit-report generators, so the standard export is not one combined donation-and-registration report. Download the corresponding gift and event deposit reports for the same settlement period and processor account, then reconcile them together by deposit/payment IDs in a combined workbook. Keep their source/product columns and refunds/reversals. Event integrated gifts can also produce contribution records; use payment/gift IDs to avoid counting the same money twice. A donation activity date report is not a substitute for a payout/deposit reconciliation report.