Bank Reconciliation

Match your books to your bank statement each month and find the difference fast.

Does the math for you
Works in Excel, Google Sheets and Numbers
Dashboard with pie and bar charts
Instant download

Made in the USA · Jacksonville, FL

$5.95

Excel spreadsheet

Buy now

Instant download · your files are ready the moment you pay Secure checkout · payments by Stripe; we never see your card numberReal people · Affluency, LLC, Jacksonville, FL · 904-362-7083

About Bank Reconciliation

Bank Reconciliation does the math for you: the formulas and charts are already built in, so you just type in your numbers.

It works in Microsoft Excel, Google Sheets and Apple Numbers. For Google Sheets: upload the file to Google Drive, then open it with Google Sheets. Tip: keep a blank copy of the original so you can start fresh next month or next year.

Questions

How do I get my files?

Your download is ready the moment you pay, and the link is emailed to you too, so you can download it again later.

Is anything shipped?

No. This is a digital download, so there's no shipping cost and no waiting.

Do I need Excel?

No. It also works in the free Google Sheets and in Apple Numbers.

Questions or trouble with a file?

Real people answer: call or text 904-362-7083 (Affluency, LLC, Jacksonville, FL), or reply to your download email. We'll help you get it working.

Catch mistakes before they cost you

Reconciling means checking your records against the bank statement, line by line, so you know your balance is right. It's how you catch a missed deposit, a duplicate charge, an outstanding check or a fee you didn't know about, before it turns into a bounced payment or a tax-time headache.

How it works:

Enter the ending balance from your bank statement
Enter your book balance from your own records
List outstanding checks and deposits in transit
The spreadsheet shows the difference. When it reaches zero, you're reconciled.

Do it once a month when the statement arrives. It takes about 15 minutes once you're in the habit. Accountants will ask whether your books are reconciled, and this gives you a clean record to hand over. It works for personal accounts too. Pair it with Profit and Loss Bookkeeping and Balance Sheet and Cash Flow, or get the full Bookkeeping and Accounting Bundle.