Bank Statement Reconciliation Spreadsheet

A Google Sheet template designed to assist in bank-statement reconciliation.

bank statement reconciliation sheet

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.

Notable Replies

  1. Re: Statement Details add-on

    I just found this add-on today and love it - especially the Running Balance numbers. Is there a way for the “Unreconciled Transactions” to reference the last Statement Ending Balance to reflect an accurate Running Balance in the selected account?

    Row 9 shows the Statement name and record count for the last Reconciled Statement that I looked at, even when I am looking at the Unreconciled Transactions, so I am hoping that there is an easy way to grab the Ending Balance number from there and make the Running Balance number reflect the actual balance in the account.

    I have upcoming transactions manually entered that will eventually reconcile with downloaded transactions but knowing my cash balance on any given date is important to me.

    I am very new to Tiller in the last few days - giving up on Quicken as we move into 2020, so there a lot of features I have yet to explore and learn. There may already be something that does this and I just haven’t found it yet. Thank you for your help.

  2. Avatar for Blake Blake says:

    @martha.rudkin @randy

    Hi:

    I have not used Statements but it appears to me to be designed as an after-the-fact exercise, i.e., after the bank statement has been released.

    If you want to tightly track cash (I mean cash in bank, not cash in hand), try these:

    1. Balances tab…I believe this as part of the Foundations template.
    2. Net Worth Snapshot template…add via Tiller Labs add-on.
    3. Business Dashboard template (left side columns)…add via Tiller Labs add-on.
    4. Net Worth template…add via Tiller Labs add-on.

    All of these tools track your net worth (meaning balance sheet) so that means more than just bank accounts.

    From your other posts you understand manual posting of transactions to account for float so that is good.

    Please let me know if you have more questions. I am happy to help.

    Thanks,

    Blake

  3. Avatar for jono jono says:

    Yes @Blake, the Statements and Statement Details sheets are designed to work AFTER you get your statement.

    @martha.rudkin : We liked your suggestion to add the last statements balance to the running total when viewing Unreconciled Transactions. I’ve updated the sheet to include this feature. It’s available now in the Tiller Labs add-on. If you select Manage Solutions, you will be able to update the Statement Details sheet to the new version 1.02.

    Enjoy

  4. Thank you - that is exactly what I was hoping to see. I really appreciate all the quick responses and quick sheet updates too.

  5. I’ve been using the Statements Template for a little over a year, without any problems. Today I am having difficulties after adding some new lines. The Statements Template is not autogenerating the Name, Ending Balance, or last two Tiller Transactions columns. I tried pasting formats from lines above, which seems to work on the Statements Template–but when I go to the Transactions page the Statement Name is not showing as an option in the dropdown of the Statements column. Therefore, I’m not able to reconcile… What can I do to fix this? Thanks!

Continue the discussion at community.tillerhq.com

6 more replies

Participants

Avatar for randy Avatar for jono Avatar for Blake Avatar for Richard Avatar for lillytryon Avatar for martha.rudkin Avatar for dnlhflnd

Template FAQ

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.

Tiller is the only automated personal finance service for Google Sheets and Microsoft Excel. Tiller automatically imports 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 →

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.

This template for Google Sheets works best when installed in Tiller’s Foundation Template.

Visit the Tiller Community with any questions about this template.