Skip to main content
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/95779390.e43594db-9c8c-41c8-9276-8544e39b4373-156c6d3d-df78-4edd-90db-735109d3526e/image1_bankreconciliation300.png

Bank Reconciliation Checker

by OpenSlot LLC

Bank and book balances from your workbook, each brought up to date and compared to the cent.

Run a bank reconciliation from four sheets of your workbook. The statement ending balance and the book balance for the same date are each brought up to date, and the adjusted bank balance and the adjusted book balance are compared to the cent, with the difference shown.

What it does

  • Reads four sheets by name: Reconciliation, Outstanding checks, Deposits in transit, and Adjustments. No other sheet is read.
  • On the Reconciliation sheet you type the statement ending balance and the book balance beside their labels. The other three sheets are lists: one row per outstanding check, per deposit in transit, and per bank correction or book adjustment. On the Adjustments sheet each row says Bank or Book, and Add or Subtract. Every amount is typed as a positive number.
  • Works out the adjusted bank balance (statement ending balance plus deposits in transit, minus outstanding checks, plus bank corrections added, minus bank corrections subtracted) and the adjusted book balance (book balance plus book adjustments added, minus book adjustments subtracted).
  • Writes a statement sheet: both sides line by line, the difference, and the three lists with their totals.
  • Writes a Certificate sheet listing every check as passed or failed.
  • Creates the four starter sheets if you do not have them.

Checks on every run

  • The adjusted bank balance equals the adjusted book balance. When the two differ, the difference is shown and the check fails.
  • Each adjusted balance is worked out a second time, row by row from its starting balance, and the difference shown is compared with that second calculation.
  • Outstanding checks, deposits in transit, bank corrections, and book adjustments are each added again and equal the totals shown.
  • Every filled row on the three list sheets was read. A row that cannot be read is named with its sheet and row number, and the result is not verified. An amount with a fraction of a cent is never rounded.
  • A total, an adjusted balance, or a difference you wrote by hand on the Reconciliation sheet is compared with the calculated one.
  • Two warnings that do not fail the result: a check number listed twice, and a list row with an amount of zero.

If a check fails, the add-in says "Not verified", lists what failed, and marks the sheets it writes UNVERIFIED in the first row and in the tab name. Your four sheets are never changed.

The add-in adds, subtracts, and compares the figures on your sheets. It does not read a bank statement file, and it does not say what a difference means or what any rule or standard requires.

Your data stays in your workbook

The add-in runs inside Excel. It does not upload your workbook, and it has no analytics. Results are written into the same workbook, which is stored wherever you keep it: on your computer, or with Microsoft when you use Excel on the web, AutoSave, or OneDrive.

Free and paid use

Free: 3 runs per day; a run that does not verify is not counted. A Mathproven subscription removes the limit; subscribers paste an add-in key from their account page. Additional purchase may be required for unlimited use.

This add-in calculates and verifies. It does not give legal, tax, or accounting advice.

App capabilities

When this app is used, it
  • Can read and make changes to your document
  • Can send data over the Internet

At a glance

https://catalogartifact.azureedge.net/publicartifacts/95779390.e43594db-9c8c-41c8-9276-8544e39b4373-156c6d3d-df78-4edd-90db-735109d3526e/image0_bankreconciliation1.png
https://catalogartifact.azureedge.net/publicartifacts/95779390.e43594db-9c8c-41c8-9276-8544e39b4373-156c6d3d-df78-4edd-90db-735109d3526e/image2_bankreconciliation2.png
https://catalogartifact.azureedge.net/publicartifacts/95779390.e43594db-9c8c-41c8-9276-8544e39b4373-156c6d3d-df78-4edd-90db-735109d3526e/image3_bankreconciliation3.png
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies