This free bank statement template is designed for small businesses to maintain personal statements for reconciliation. It has automated balance calculations and self-updating summaries.
It is designed with a simple yet professional layout with auto calculations and totals on the header and at the end of the statement. We have frozen the headers to give you an overview of the statement when entering the numbers and to also print the header for the new pages when the statement exceeds one page. Always insert new rows at least before the last “total” balance row of the sheet to maintain the formulas and calculations.
Header and Business Information
Enter your business’s identifying details in this section. Include your business’s contact details, such as phone number and email. There are also placeholders for customer service information for the associated bank account.
Business Details
This is where you enter the account number, your business’s legal name and address, account type. Select the account type from a dropdown menu, which is linked to the configuration sheet.
Statement Summary
- Card Type: This is added to identify the card type associated with this account. i.e., Visa, Master, etc.
- Opening Balance: This figure is the starting point for the statement period and serves as the baseline for calculations.
- Total Credit and Debit: These fields automatically calculate the total credits and debits using Excel’s SUM() function. They update as new data is entered.
- Net Balance: This is calculated by subtracting total debits from total credits.
Transaction Details
- Date: Use Excel’s date picker to ensure consistent and uniform date formatting.
- Description: This field helps you describe transactions clearly. You can use this information to search for specific transactions.
- Credit and Debit: These cells are formatted as currency, and Excel automatically calculates running totals.
- Balance: This field automatically updates the running balance after each transaction entry, helping you track your business’s liquidity over time.
This template is available in formats like Excel (.xlsx), OpenDocument Spreadsheet (.ods), and Excel Template (.xltx).
