Excel template
Download a bank reconciliation Excel template for comparing statement transactions against book transactions.
| Date | Description | Statement Amount | Book Amount | Difference | Status |
|---|---|---|---|---|---|
| 2026-06-02 | Direct Deposit ACME Payroll | 4200.00 | 4200.00 | 0.00 | Matched |
| 2026-06-04 | Office Depot | -86.43 | -86.43 | 0.00 | Matched |
| 2026-06-07 | Stripe Payout | 912.18 | 912.18 | Needs review |
Paste statement rows into the statement amount column and book rows into the book amount column. The Difference column shows what still needs review.
This template is intentionally simple so it works in Excel, Google Sheets, Numbers, and LibreOffice.
Yes. Upload the XLSX file to Google Sheets and it will preserve the worksheet table.
Yes. Convert the bank statement PDF to Excel or CSV, then paste the extracted rows into the reconciliation sheet.
Upload the original PDF, statement, or accounting file and create your own export.