Reconciling in QuickBooks Desktop When the Beginning Balance Moves

Reconciliation threads on the Canadian Desktop board follow a pattern. The opening post asks how to reconcile an account, Intuit’s accepted solution lays out the standard monthly routine, and the replies underneath circle one stubborn problem: a beginning balance that no longer matches the statement. The routine itself is simple. The drift behind that mismatch is where the real work sits.

The routine, in short

Reconciling means comparing the transactions you entered in QuickBooks against the ones on your bank or credit card statement, much like balancing a chequebook. When the two lists agree, your books match the bank. The guidance in the thread, and the habit repeated across the community, is to do this monthly for chequing, savings, and credit card accounts.

Three things belong on your desk before you start. Make a backup of the company file first. Have the statement at hand, with its beginning balance, ending balance, and end date. Confirm every transaction for the statement period is already entered. If this is the account’s first reconciliation, review the opening balance as well. The cleanest starting point is the first day of a bank statement, which makes that first pass far easier.

Start with the oldest statement

The entry point is the Banking menu, then Reconcile. Choose the account, and Desktop fills in a statement date, usually 30 or 31 days after the previous one. Check it against the end date printed on your statement. The beginning balance also fills automatically, carried over from the last reconciliation’s ending balance. Enter the statement’s ending balance, plus any service charge or interest earned that is not yet recorded, then continue into the reconciliation window.

Backlogged several months? Start with the oldest statement and clear one month at a time. Reconciling a merchant or payments account may prompt you to sign in first, so the account stays linked to a valid company file.

Why does the beginning balance stop matching?

Here is the cause the thread replies keep rediscovering. Desktop does not store the beginning balance as a number you typed. It sums the transactions already cleared in past reconciliations, every time. Change one of those items after its month is closed, and the next beginning balance moves by exactly that amount.

Picture a cheque for $62.40 written to a supplier in March, reconciled, then voided in May to fix a wrong payee name. June’s reconciliation now opens off by $62.40. The same happens when a duplicate bank fee is deleted from a closed period, or when a reconciled deposit is edited to a new amount. The difference shown in the window is your first clue, because it usually equals the item that was touched. Several changes stack into a sum, and that is when a report earns its keep.

What does the Locate Discrepancies report show?

When the beginning balance disagrees with the statement, stop before forcing the month closed. In the reconcile window, select Locate Discrepancies. The report lists reconciled transactions that were edited, deleted, or added since the last reconciliation, with their dates and amounts. It points you to the month that needs a second look.

Reprint the previous reconciliation report for that account and compare it against the register as it stands today. Small fixes are straightforward: re-enter a deleted transaction and clear it against the current statement. For larger changes, some editions offer an option in the same window to undo the most recent reconciliation and redo it cleanly. Undo is a blunt tool, so back up the file before using it.

Habits that keep the number steady

The pattern across the community is consistent. Accounts stay balanced when cleared transactions are treated as locked. Correct mistakes in the open period rather than editing a reconciled one. A duplicated fee discovered after the month closed is better adjusted in the current month than deleted from the last one. Back up before every session, reconcile each statement on its own, and keep the opening balance tied to the start of a statement.

None of this is complicated. The routine takes minutes once the history is clean, and the beginning balance takes care of itself when past reconciliations are left alone.