First bank reconciliation after converting to QuickBooks Online

Moving from another accounting system into QuickBooks Online often feels smooth until the first bank reconciliation. You import your year-to-date activity, connect your bank feed, and enter an opening balance that matches your actual bank statement. Then the reconciliation screen shows a beginning balance that is off by exactly the amount of that opening balance entry.

This is a known side effect of how QuickBooks Online seeds a converted company file. The software creates an opening balance equity transaction to carry your starting bank balance forward. That same amount then appears again as the beginning balance on your first reconciliation. The result is a double-count that blocks a clean reconciliation.

What causes the double-count

QuickBooks Online builds a new company file around a start date you choose. When you supply an opening bank balance, the software records an opening balance equity entry dated on or just before that start date. The bank feed then begins importing transactions from that same date forward.

During reconciliation, QuickBooks uses the balance of all cleared transactions as the beginning balance. Because the opening balance equity entry is marked cleared by default, its amount is counted twice. Once as the equity entry and once as the beginning balance figure the software expects you to confirm.

How to clear the opening balance equity entry

The cleanest fix is to leave the opening balance equity transaction uncleared in the register, then manually enter the correct beginning balance on the reconciliation screen. Here is the sequence:

1. Open the bank account register and locate the opening balance equity entry.
2. Click the checkmark in the cleared column to mark it uncleared.
3. Start a new reconciliation.
4. When the beginning balance appears, overwrite it with the actual balance from your last statement before the QBO start date.
5. Continue reconciling as normal.

This approach keeps the equity entry in place for reporting purposes while letting the reconciliation begin from the true prior balance.

Why you should not delete the entry

Deleting the opening balance equity transaction may seem simpler, but it removes the audit trail that ties your QBO file to the real-world starting point. Future reports and tax preparations rely on that anchor. Leaving the entry uncleared preserves the history without distorting the reconciliation math.

What to do with future reconciliations

Once the first reconciliation clears with the manual beginning balance, subsequent reconciliations return to normal. The uncleared opening balance equity entry stays in the register but no longer interferes, because each new reconciliation starts from the ending balance of the previous one.

If you prefer a fully clean register, you can create a journal entry that moves the opening balance equity amount into retained earnings or another appropriate equity account. Do this only after the first reconciliation completes, and consult your accountant to confirm the proper offsetting account for your situation.

When the beginning balance still looks wrong

Sometimes the beginning balance on the reconciliation screen does not match your paper statement even after adjusting the opening balance equity entry. This usually means one or more pre-start-date transactions imported from the old system were marked cleared. Review the register for any stray cleared entries dated before your QBO start date and mark them uncleared. Then restart the reconciliation.

The goal of the first reconciliation after a conversion is to establish a trustworthy baseline. Once that baseline holds, QuickBooks Online handles the ongoing matching between your books and your bank feed without further intervention.