Bank Statement in Excel Format: Free Sample and Template
A bank statement in Excel format puts transactions into rows and columns so you can sort, filter, and calculate totals. Download the free workbook below to see a worked example or use the blank sheet for your own records.
Download the sample and blank template
One .xlsx file contains a fictional October 2026 example in GBP and a blank worksheet with 100 transaction rows. Both include running balance formulas and a comparison with the statement closing balance. No account is needed to download it.
Download free Excel sample and template (.xlsx)The sample is fictional. The template is a personal recordkeeping worksheet; it is not a bank-issued statement.
Already have a PDF statement? Use the PDF bank statement to Excel converter to extract its transaction data instead of entering every row by hand.
What does a bank statement look like in Excel?
A useful transaction sheet keeps one transaction per row, with separate columns for dates, descriptions, and amounts. The preview below shows the first three transactions from the downloadable sample. It begins with an opening balance of £1,000.
| Date | Description | Money in (£) | Money out (£) | Balance (£) |
|---|---|---|---|---|
| 2026-10-01 | Salary | 2,500.00 | — | 3,500.00 |
| 2026-10-02 | Rent | — | 900.00 | 2,600.00 |
| 2026-10-04 | Groceries | — | 65.50 | 2,534.50 |
- Date
- The date shown on the statement. Keep transaction dates and posting dates distinct if your bank provides both.
- Description
- The bank's transaction text, including useful payment references. Keep the original wording so you can trace the entry.
- Money in and money out
- Deposits and withdrawals in separate columns, entered as positive numbers. In this deposit-account template, money in increases the balance and money out reduces it.
- Running balance
- The opening balance plus all money in so far, minus all money out so far. The workbook calculates this column.
- Category
- An optional field for your own labels, such as rent or groceries. It is separate from the original description.
There is no single layout used by every bank. Some statements use a signed amount column, while others separate debits and credits. Keep the account, currency, and statement period identifiable, and adapt the layout to the source document.
How to use the blank Excel template
- Save a copy of the workbook for one account and statement period, then open the Blank template sheet.
- Enter the account label, period, and currency in the context line. Enter the opening balance in B4 and the closing balance printed on your statement in B5. Enter zero explicitly when that is the actual balance.
- Enter dates, descriptions, and positive money-in or money-out values in columns A–D, rows 13–112. Amber cells are editable inputs. Paste values only so you preserve the workbook formatting.
- Keep column E for the running balance formulas. Add optional categories in column F. Keep the statement's original order when reviewing running balances.
- Compare the calculated closing balance in E4 with the statement balance. E5 shows the difference once both opening and closing balances are entered.
The formulas cover 100 transactions. For more rows, extend the running balance formulas and the summary SUM ranges together. Avoid sorting this worksheet while reconciling: its running balances follow the row order. Use a separate copy for analysis after checking the original sequence.
Understand the balance check
The fictional sample starts at £1,000, receives £2,525, and pays out £1,195. Its calculated closing balance is £2,330. The difference from the sample's entered closing balance is £0.00.
Opening balance + total money in − total money out = calculated closing balance. This convention suits a deposit account. Credit card statements may use a different balance convention, so follow your statement's definitions.
A zero difference checks the net movement, but it cannot prove that every transaction is correct. Two mistakes may cancel each other out. Compare individual rows, statement totals, dates, and references with the original PDF. Keep different currencies separate.
Get your own bank statement into Excel format
Check your online banking download options first. If your bank offers an Excel or CSV export for the required period, you may be able to use that directly. Confirm its date range and fields match your needs; a transaction export may differ from the monthly statement.
If you have a PDF, our PDF-to-Excel converter produces an XLSX workbook from the uploaded document. Conversion requires an account and sufficient page credits. Review the extracted data before using it. The downloadable template on this page is a separate resource and does not automatically import a PDF.
For the full upload process and troubleshooting, read how to convert bank statements to Excel. Once the data is checked, follow our Excel organization guide to group and analyze transactions.
Frequently asked questions
Is an Excel worksheet an official bank statement?
An editable workbook is useful for analysis and recordkeeping. Keep the original bank-issued document when you need evidence of the statement. Our sample and blank template do not replace that document.
Can I use a CSV file in Excel?
Yes. CSV stores a plain-text table. Check date interpretation, separators, and numeric columns when importing it. Save a working copy as XLSX if you want to keep workbook formatting, multiple sheets, or formulas.
Why are some template cells blank?
The blank sheet leaves opening and closing balances for you to enter. The closing-balance comparison stays blank until both are numeric, and a row's running balance stays blank until it has a date and an opening balance. This prevents missing balances from appearing as completed checks.
Ready to work with your own transactions?
Convert your PDF bank statement to Excel