Free spreadsheet resources
Free Bank Transaction Spreadsheet Template
Reviewed 12 September 2026
Short answer
Short answer
Use one row per transaction with Date, Description, Debit, Credit, Balance, Category, Account and Source File columns. Keep a separate reconciliation sheet for the statement period, opening balance, total debits, total credits, calculated closing balance and printed closing balance. Download both templates free without entering an email address.
The template is deliberately plain. It gives you clean source data that can feed filters, SUMIFS, PivotTables or your accountant's own workbook.
What belongs in the transaction table
Date, Description and amount direction are the minimum working fields. Balance helps with checking. Category supports analysis. Account and Source File preserve traceability when several statements are combined.
Do not add subtotals, merged cells or blank separator rows inside the transaction table. Put summaries on a separate sheet so Excel can filter, sort and refresh the source rows reliably.
Step by step
- 01
Download the templates
Save the transaction CSV and reconciliation CSV locally. No signup is required.
- 02
Create one file per account
Do not mix transaction histories from separate bank or card accounts.
- 03
Paste clean rows
Keep one header and one transaction per row, with numeric debit and credit fields.
- 04
Record statement controls
Enter the period and printed balances in the reconciliation template.
- 05
Analyse a checked table
Only build formulas or PivotTables after the transaction movement reconciles.
Checks before you rely on the spreadsheet
- No merged cells inside the transaction table.
- One row represents one transaction.
- Account and source file remain populated.
- Summary formulas sit outside the source table.
Download the templates
Free CSV files. No email address or account required.
Questions people ask
Is the spreadsheet template really free?
Yes. Both CSV templates can be downloaded without an email address or account.
Can I open the template in Google Sheets or Numbers?
Yes. CSV is portable and opens in Excel, Google Sheets and Apple Numbers.
Can AussieBankStatements fill the transaction rows?
Yes. Convert a supported Australian PDF statement and download CSV with the core transaction columns and rule-based categories already populated.