Free Template
Payment Reconciliation Template
Match invoices to payments received. Flags DUPLICATE, MISSING, and MISMATCH (amount) statuses; shows aging days on overdue invoices.
excelgoogle-sheets
What’s Included
- Invoices — your invoice register (7 columns).
- Payments Received — the bank-side incoming batch.
- Reconciliation — joins invoices to payments on Invoice #; computes variance, aging, and status (OK / MISSING / MISMATCH / DUPLICATE).
How to Use
- Paste your invoices into Invoices.
- Paste the bank’s incoming CSV into Payments Received.
- Open Reconciliation — everything joins automatically.
- Investigate rows flagged DUPLICATE (red) and MISMATCH (amber) first.
Related Tutorials
- Reconcile Payments vs. Invoices (
/tutorials/reconcile-payments-vs-invoices) - Detect Duplicate or Missing Payments (
/tutorials/detect-duplicate-missing-payments)
Common Pitfalls
- Partial payments. One invoice can legitimately be paid in multiple wires. The MISMATCH check fires on any variance > $1 — tune to your tolerance.
- FX adjustments. If the bank converts currency, the reported USD often differs from the invoice USD. Capture FX as a separate row in Payments Received rather than adjusting the invoice.
Get New Templates
We release new templates regularly. Subscribe to get them in your inbox.