Zero or Wrong Opening Balance in QuickBooks Desktop Reconciliation

A quiet frustration keeps surfacing among QuickBooks Desktop users: the reconcile window opens showing a beginning balance of zero, or a figure that no longer matches the last statement. We see the complaint reported regularly. The causes are few, and most of the fixes take minutes rather than hours.

The symptom at the first screen

You select an account to reconcile, and the beginning balance field should carry the ending balance from your previous session. Instead it reads zero, or it sits at a figure you cannot explain. Four causes cover nearly every case, and the right fix depends on which one fits.

• The account was never set up with a balance, or with the correct one.
• Transactions that were already cleared and reconciled were later voided, deleted, or edited.
• The company file was converted from another version of QuickBooks.
• The data inside the company file is damaged.

A zero balance on a first reconciliation

The simplest case is the first attempt at reconciling an account. No opening balance exists on record, so you create one and then reconcile it. Two steps settle the matter.

Step one: create the journal entry

Open the Company menu and choose Make General Journal Entries. Set the date to the statement date that matches the balance you want on screen. Select your account from the Account dropdown. Enter the correct opening amount in the Debit column, or the Credit column for a credit card. On the second line, select Opening Balance Equity, then save the entry.

Step two: reconcile the entry

From the Banking menu, choose Reconcile, then select the same account. Enter a statement date and an ending balance that match the journal entry, and select Continue. In the Deposits and Other Credits list, place a checkmark beside the journal entry. The Difference figure should now read zero. Select Reconcile Now, and the account has its baseline going forward.

A balance that is wrong rather than zero

A wrong figure means something changed after your last reconciliation. An edit, a deletion, or a void applied to an already cleared transaction moves the beginning balance by exactly that amount. Three built-in reports exist to find it.

• Reconciliation Discrepancy, under Reports and then Banking. Select your account and the report lists every transaction changed since the last reconciliation. Note the transaction date and the last modified date, because the second tells you when the change occurred.
• Audit Trail, in the accounting reports area. It records every addition, edit, and deletion, with dates and the user responsible.
• Previous Reconciliation, also under Reports and Banking. It reproduces your most recent reconciliation, so you can compare it against the register line by line.

Once you spot the offending transaction, correct it or re-enter it, then reconcile normally. Where several changes appear, work through them in date order and watch the difference shrink as you go.

Data damage as the remaining suspect

Sometimes all three reports come back clean and the balance is still wrong. The company file itself then becomes the suspect, and Desktop ships maintenance utilities for exactly this. From the File menu, choose Utilities and then Verify Data, which examines the file for structural damage. If verification reports a problem, return to Utilities and run Rebuild Data; the tool offers to create a backup before it begins. Verify once more afterward to confirm the repair. Persistent trouble calls for restoring a backup from before the imbalance appeared.

Converted files arrive with limits

A company file brought over from another version, or from the online edition, does not always carry its reconciliation history across intact. The register can look correct while the beginning balance reads zero or oddly. Treat this like a first-time reconciliation: set the balance with a journal entry, reconcile that entry, and continue from there. It is a known limit of conversion, not a fault in your bookkeeping.

How do you keep it from happening again?

Most recurrences trace back to one habit: touching transactions that are already reconciled. Any later edit, void, or deletion moves the next beginning balance by that amount, which is why the field drifts. Make corrections through the register only when necessary, and expect the discrepancy report to flag them. A quick look at the Reconciliation Discrepancy report before each session catches trouble while it is still small. We consider that habit the cheapest insurance this corner of the software offers.