Summary
Enter statement details and balances. Formulas calculate money in, money out, net movement, row counts, open review rows, a balance check, and average confidence.
Free spreadsheet resource
Free bank statement Excel template
Organize reviewed statement data in a blank workbook with a formula-driven summary, transaction table, and a separate log for fields that need attention.
Workbook structure
Three worksheets for a reviewable handoff
A single flat transaction table is easy to move between systems, but it does not preserve the review trail. This workbook keeps the totals, rows, and unresolved questions separate so another person can understand what was checked.
Transactions
Use one row per transaction with date, description, money out, money in, balance, source page, confidence, and review status.
Review Flags
Record the affected row, issue, expected and extracted values, source page, severity, and whether the issue has been resolved.
Transaction columns
Keep source and review context beside each row
Enter amounts as numbers, not currency-formatted text. Leave Money Out or Money In blank when it does not apply, and compare uncertain values with the original read-only statement.
- Row
- A sequential reference generated when a date is entered.
- Date
- The transaction date in a sortable date cell.
- Description
- The reviewed statement description, including useful references.
- Money Out
- A debit, payment, fee, or other amount leaving the account.
- Money In
- A credit, deposit, refund, or other amount entering the account.
- Balance
- The running balance shown by the source statement, when available.
- Source Page
- The statement page used to verify the row.
- Confidence
- An optional review signal stored as a percentage.
- Review Status
- Not Set, Needs Review, or Passed.
Suggested workflow
Use the workbook after source review
- 1
Save an authorized working copy while keeping the original statement unchanged.
- 2
Enter the statement label, period, opening balance, and closing balance on Summary.
- 3
Copy one reviewed transaction per row and record the page used for verification.
- 4
Log unreadable, missing, duplicated, or corrected fields on Review Flags.
- 5
Investigate any balance-check difference instead of forcing totals to match.
Before sharing
Treat the workbook as sensitive financial data
Remove rows and identifiers that the recipient does not need.
Restrict access and use an approved secure delivery method.
Keep unresolved OCR or transcription issues visibly flagged.
Follow your organization’s retention and deletion policy.
Frequently asked questions
About the Excel template
Does the Excel template contain real bank data?
No. It is a blank workbook with labels, formulas, formatting, and empty data rows. It contains no customer, account, or transaction data.
Does the template extract transactions from a PDF?
No. The workbook organizes values that you enter or paste. RasterLift performs OCR separately when you upload a supported statement and review the extracted rows.
Which worksheets are included?
The workbook includes Summary, Transactions, and Review Flags. Those are also the three worksheets included in RasterLift Excel exports.
Can I use the template for currencies other than USD?
Yes. The money columns use plain numeric cells without a fixed currency symbol, so you can enter values in the statement currency and record the currency in the Summary sheet.
Convert a statement, then review before export
Upload a supported bank or credit card statement, compare flagged fields with the source, and export reviewed CSV or Excel data.