Free bank statement Excel template
Organise your statement transactions in a ready-to-use Excel worksheet. Add debits and credits, compare the closing balance, and keep your review notes beside each row.
Start with one account and currency
Download the blank .xlsx workbook and save a copy for each account and statement period. Add an account label, change the currency from MYR if needed, and enter the opening and closing balances from your source statement. Changing the currency label does not convert amounts.
Add your transactions as values
The worksheet has 500 prepared transaction rows, from row 13 to row 512. Enter dates, descriptions, positive debit and credit amounts, and optional statement balances and categories. Paste values only so the template keeps its formatting. For a longer statement, use the converter's Excel export rather than entering data outside the prepared range.
Compare the totals with the PDF
The blue summary cells calculate total debits, total credits, and opening balance plus credits minus debits. Closing difference compares that result with the statement closing balance you entered, rounded to two decimal places. The comparison stays blank until both balance inputs are numbers; zero is a valid balance.
Review individual rows before using the file
A zero closing difference does not prove that every transaction is correct. Missing transactions or offsetting errors can still produce matching totals. Check dates, amounts and descriptions against the original statement, use the Reviewed dropdown, and record questions in Notes. Filters do not change the full-statement totals.
Is the template really free?
Yes. Download and use the worksheet without signing up, adding a card or buying a subscription. The PDF converter is a separate tool with its own free allowance and paid plans.
Does this template convert a PDF automatically?
The template is for entering or pasting transactions you already have. To extract rows from a PDF, use Statement Studio, review the results, and export an Excel file. You can then paste the values into this review worksheet if you want its balance comparison and review columns.
Can I use it for Malaysian bank statements?
Yes. MYR is the starting currency label and dates use day, month and year. You supply the transaction values, so the worksheet is not tied to one bank's PDF layout. Statement Studio also has dedicated extraction for selected Maybank and CIMB layouts.
Is this a replacement for a bank-issued statement?
No. This is an editable transaction review worksheet. Keep the original bank-issued PDF as your source record. The template does not certify reconciliation or provide a direct accounting-software import.
Are my entries uploaded to the website?
The downloaded workbook contains no macros or external data connections. Your entries stay wherever you save the file. If you open it in a cloud spreadsheet service, that service's storage and sharing settings apply.