Card settlement reconciliation worksheet
One fictional batch: payments captured on October 6 and a bank credit on October 8. Match the batch ID, currency and dates against the payment provider statement. These figures are not suggested provider rates.
A free Zawid worksheet
Worked example
| Item | Amount | Payout effect | Document |
|---|---|---|---|
| Captured payments | 2400 | Add | Batch statement |
| Refunds | 150 | Deduct | Refund record |
| Provider fee | 48 | Deduct | Fee statement |
| Dispute debit | 100 | Deduct | Dispute reference |
| Funds held by provider | 200 | Not paid out yet | Reserve statement |
| Expected bank payout | 1902 | 2400 less 150, 48, 100 and 200 | Payout reference |
| Closing provider balance | 200 | Not an expense | Provider balance statement |
With an opening balance of zero: 2400 − 150 − 48 − 100 − 1902 = 200 remaining with the provider. Do not subtract the held 200 again from that balance. An authorization-only amount of 600 is outside this captured batch.
Use your own records
Period:Currency:Reference:
| Item | Amount | Payout effect | Document |
|---|---|---|---|
Notes and differences to investigate: