Skip to main content

PennyWise

Calendly Book a Meeting
Email

info@pennywiseusa.com

Short answer: reconcile a backlog in QuickBooks Online one statement at a time, starting with the oldest unreconciled month. For each statement, enter the statement end date and ending balance, tick off only the transactions that appear on that statement, and finish when the difference is zero. Never reconcile several months against one balance, and never force a difference to zero with an adjustment unless you know exactly what it is.

Before you start

  • Have every statement for the account, in order, with no gaps
  • Make sure the transactions for those months are already in QuickBooks (from the bank feed or uploaded statement files) and categorized
  • Find the last statement that was reconciled correctly. That is your starting point

Step-by-step: reconciling one month

  1. Open the reconcile screen in QuickBooks Online (in the Settings gear menu, or under the bookkeeping or banking area depending on your QuickBooks navigation).
  2. Choose the account to reconcile.
  3. Check that the beginning balance QuickBooks shows matches the opening balance on the statement. If it does not, stop and see the section below.
  4. Enter the ending date and ending balance exactly as shown on the statement.
  5. Tick each transaction that appears on the statement. Leave anything that cleared in a later month unticked.
  6. When the difference reads 0.00, finish the reconciliation. Then move to the next month’s statement.

New to the reconcile screen? Our guide to reconciling bank accounts in QuickBooks Online walks through it with the basics.

What if the beginning balance does not match the statement?

This is the most common problem in a backlog. It means something that was already reconciled has changed since: a reconciled transaction was edited, deleted or recategorized into a different account, or a reconciliation was done with the wrong ending balance. To find it:

  • Open the reconciliation history for the account and compare the last good reconciliation with the transactions in QuickBooks today
  • Look for reconciled transactions dated in that period that were changed or deleted
  • Check that the very first reconciliation started from the correct opening balance

Fix the cause first. Reconciling later months on top of a broken beginning balance only moves the problem forward.

Mistakes that break later months

  • Reconciling to the current balance instead of the statement. Always use the statement’s ending balance and date.
  • Ticking transactions that are not on the statement just to make the difference zero.
  • Letting QuickBooks add an adjustment to close a difference you have not explained. That puts an unknown amount into your books.
  • Skipping a month. Every statement has to be reconciled in order.
  • Duplicates from uploads. When you upload old statements, check you are not adding transactions that were already entered by hand.

How long does it take?

It depends on volume. A quiet account with a few dozen transactions a month can take minutes per statement once everything is categorized. A busy account, or one with a beginning balance problem, can take far longer. Multiply that by every account and every month you are behind, and you have your real time cost.

When to get help

If you are more than a few months behind, have several accounts, or keep hitting beginning balance differences, a bookkeeper will usually finish faster and cheaper than the time it costs you. Read our step-by-step catch-up plan or see what a QuickBooks cleanup costs.

Want a second pair of eyes first? Our free QuickBooks Health Check tells you which accounts are unreconciled, whether your opening balances are off, and how far behind you are, in a written report within 2 business days. If you need the work done, our cleanup and catch-up service is priced as a fixed quote before we start.

Leave a Reply

Your email address will not be published. Required fields are marked *