Bank Statement Reconciliation Spreadsheet
A Google Sheet template designed to assist in bank-statement reconciliation.
About the Bank Statement Reconciliation Sheet
One key to keeping your finances in sync is verifying that all the transactions that appear on your bank statement are also available in your Tiller transactions sheet. Reconciling your bank statements helps flag checks that haven’t been cashed (yet), unexpected charges, and human & machine errors.
Tiller Community Solutions has developed two templates that assist in bank-statement reconciliation:
- Statements: Use Statements to log, track and compare statements to grouped transactions in your Transactions sheet.
- Statement Details: Use Statement Details to review a single statement and its associated grouped transactions in line-item detail. (Statement Details requires the Statements template.)
Tiller Community Solutions FAQ
Is this template free?
This is a free template built by a member of the Tiller Community. While it’s free for anyone to use, it’s designed for spreadsheets automated by Tiller. Additionally, it’s recommended for use within the Foundation Template.
What is Tiller?
Tiller is the only automated personal finance service for Google Sheets and Microsoft Excel. Tiller automatically tracks your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place and manage your money, your way. Learn more →
What is the Tiller Community Solutions Add-on?
The Tiller Community Solutions add-on for Google Sheets is an easy way to install dozens of free, prebuilt sheets for tracking your budgets, debt payoff goals, net worth, savings, and more. It also includes several helpful spreadsheet utilities and CSV importers.
Does this template have any dependencies or special requirements?
This template for Google Sheets works best when installed in Tiller’s Foundation Template.
Have questions about this template?
Visit the Tiller Community with any questions about this template.