How to Reconcile Payment Processor Payouts Against Invoices

BLANK WORKSHEET
PROCESSOR PAYOUT RECONCILIATION
Payout ID / provider / currency / report period: [details]
Bank amount / posting date / reference: [details]
Transaction ID | type | gross | fee | signed adjustment | net | invoice or approval reference
[rows]
Confirmed gross receipt total: [amount]
Reported fees / refunds / other signed adjustments: [amounts]
Calculated net / actual payout / difference: [amounts]
Gross invoice allocations verified: [references]
Unexplained difference / owner / next check: [details]
Failed, pending or FX records (separate): [details]
Reviewed by / date / report evidence: [details]

FILLED EXAMPLE (fictional)
Fictional PAYOUT-42 in USD: gross receipts 1,000 and 500; reported fees 45.50; authorized refund 100; no other adjustments. Net 1,354.50 matches the bank payout. Receipt allocations remain gross and the refund links to its own approved record.

BEFORE USE
Replace every bracketed field. Examples are illustrative. Confirm your agreement, local invoice requirements, and applicable tax treatment separately. This download does not send an invoice or update a billing record.

Source page: https://www.getinvoiceagent.com/guides/reconcile-payment-processor-payouts
Reviewed: 2026-10-02