If QuickBooks Online shows a beginning balance that does not match your last completed reconciliation, stop before checking off transactions from the new bank statement. The first question is not “How do I make the difference reach zero?” It is “Where did the balance first stop matching the records?”
That distinction matters. A mismatch at the start of a reconciliation usually points backward to a previously reconciled transaction. A correct beginning balance shifts the investigation forward to the current statement.
Key takeaways
- Compare the new beginning balance with the ending balance on the most recent completed reconciliation report.
- If they differ, search for changes to transactions from an already reconciled period.
- Use the exact discrepancy amount as a search filter, not as a reason to create a new transaction.
- A first-time reconciliation requires checking the opening-balance entry instead of a prior reconciliation.
- If the beginning balance agrees, verify the current statement’s ending date and ending balance before editing transactions.
Start with three balance checkpoints
Gather the prior bank statement, the current bank statement, and the most recent completed reconciliation report. Confirm that all three belong to the same QuickBooks account.
| Checkpoint | What to compare | What it tells you |
|---|---|---|
| Prior completed period | Reconciliation report ending balance vs. prior bank statement | Whether the last completed period matched the bank record |
| New reconciliation start | QuickBooks beginning balance vs. prior reconciliation ending balance | Whether to investigate a historical change |
| Current statement close | Entered ending date and balance vs. current bank statement | Whether the problem is in the current period |
QuickBooks says the beginning balance should match the ending balance from the last reconciliation. If those two figures do not match before you select any current transactions, the current statement probably is not where your search should begin.
Example: a $125.42 beginning-balance mismatch
Reconstructed example—not a client account: A service company is preparing its August checking reconciliation. Its completed July reconciliation report ended at $6,875.42, and the July bank statement shows the same ending balance. QuickBooks, however, starts the August reconciliation at $6,750.00.
| July completed reconciliation | $6,875.42 |
|---|---|
| August QuickBooks beginning balance | $6,750.00 |
| Difference to investigate | $125.42 |
The math is $6,875.42 − $6,750.00 = $125.42. That amount is a search filter, not a correction. A deleted $125.42 deposit from the reconciled period would be consistent with the beginning balance becoming $125.42 lower. Several historical changes that net to $125.42 could produce the same result.
A deleted $125.42 payment would generally move the balance in the opposite direction, so it would not explain this specific downward gap. Always confirm the transaction type and direction instead of matching by amount alone.
Do not create a new transaction or journal entry simply to force the reconciliation difference to zero. Find and document the transaction or group of changes that caused the mismatch.
If the beginning balance does not match
Work backward from the most recently completed reconciliation. In QuickBooks Online, review the Reconcile Discrepancy Report and, when needed, the Audit Log or account register.
- Open the reconciliation report for the latest completed period.
- Confirm its ending balance agrees with the bank statement for that period.
- Calculate the exact difference between that ending balance and the new beginning balance.
- Review previously reconciled transactions that were edited, deleted, voided, moved to another account, or changed to an unreconciled status.
- Compare the transaction date, amount, payee or customer, account, and reconciliation status with the bank statement and supporting document.
- Correct a transaction only when your records establish what the original entry should have been.
The discrepancy report can show what changed and how the change affected the balance. The Audit Log may be necessary when a transaction was deleted or voided. The account register can help identify a transaction whose reconciliation status was changed outside the normal reconciliation workflow.
The first-reconciliation exception
A first reconciliation follows a different path because there is no prior completed QuickBooks reconciliation. QuickBooks Online commonly records the opening balance as an entry in the account register.
Locate the opening-balance entry and compare its date and amount with the bank record for the same date. Do not compare an opening balance from one date with a much later statement ending balance; that can create a false mismatch. If the correct opening date or amount is uncertain, consult the person responsible for the books before changing the account’s opening history.
If the beginning balance matches
When the beginning balance agrees with the last reconciliation, keep the investigation inside the current statement period. Check the entered statement information before changing individual transactions.
- Confirm that the statement ending date and ending balance came from the same bank statement.
- Look for bank-statement transactions missing from QuickBooks, but confirm the correct account before entering them.
- Check for duplicate entries before deleting anything.
- Leave out transactions that cleared after the statement ending date.
- Compare grouped deposits when the bank combines payments that QuickBooks records separately.
- Review bank fees, deposits, checks, payments, and transfers for small amount differences.
A reconciliation difference of zero means the selected QuickBooks transactions agree with the statement figures entered for that reconciliation. It does not prove that every category, invoice, tax treatment, or earlier accounting decision is correct.
When to stop and get help
Pause when the prior reconciliation report does not match the prior bank statement, a historical change has no supporting document, or a correction would alter a period already used for a tax return, lender report, payroll filing, or management decision. A qualified bookkeeper or accountant can help determine whether the entry should be restored, corrected, or documented another way.
QuickBooks beginning-balance checklist
- Confirm the correct QuickBooks account.
- Open the last completed reconciliation report.
- Compare its ending balance with the new beginning balance.
- Calculate and record the exact difference.
- Review the discrepancy report, Audit Log, and register as appropriate.
- Verify every correction against a statement or source document.
- If the beginning balance agrees, review the current statement instead.
Related Small Business Tool Lab resources
Frequently asked questions
Why did my QuickBooks beginning balance change?
A transaction from an already reconciled period may have been edited, deleted, voided, moved to another account, or changed from reconciled to unreconciled. Compare the new beginning balance with the last completed reconciliation and review the discrepancy report.
Should I enter an adjustment to make the difference zero?
Not simply because the amount is inconvenient. First identify the transaction or documented accounting reason behind the difference. An unsupported adjustment may hide the original problem and make later reviews more difficult.
What if this is the account’s first QuickBooks reconciliation?
Check the opening-balance entry in the account register and compare it with the bank record for the same date. A first reconciliation does not have a prior completed reconciliation to use as its starting checkpoint.
What should I check when the beginning balance is correct?
Verify the current statement ending date and ending balance, then check for missing, duplicate, uncleared, or grouped transactions within the current statement period.
Sources
- Intuit QuickBooks: Fix issues for accounts reconciled in the past
- Intuit QuickBooks: Fix issues at the end of a reconciliation
- Intuit QuickBooks: Fix issues the first time you reconcile an account
Small Business Tool Lab creates practical guides and calculators for small-business accounting, payments, marketing, and automation decisions. This article explains a troubleshooting workflow and does not replace advice from a qualified accounting or tax professional familiar with your records.