Event transaction dates versus deposit report dates

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.

The event deposit export selects deposits within the requested deposit-date range, then their linked event payments, refunds and reversals. It is not a list of every registration checked out before a universal afternoon cutoff. Checkout, capture, deposit and refund are separate timestamp columns.

Reconcile by deposit/payment identifiers and the relevant timestamp rather than deleting rows using an assumed 4 p.m. or 8 p.m. boundary. Confirm the timezone of the specific export; report formats can differ. A registration transaction can exist before it belongs to a reconciled deposit, so use registration/transaction reporting for earlier operational work and deposit reporting for payout reconciliation. The selection does not confirm a fixed two- or four-day settlement/report-availability promise; support must inspect delayed specific deposits and processor reconciliation.