What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/How to Change a Beginning Balance in QuickBooks
QuickBooks Online

How to Change the Beginning Balance in QuickBooks Online

QuickBooks uses "beginning balance" for two different numbers. One is the opening balance you gave a bank account when you set it up, and you can edit that. The other sits at the top of the Reconcile screen, and there's no box to type over it. Work out which one is wrong first.

Short answer

The account started from the wrong number? Open the account's register, click the opening balance entry (it posts against Opening Balance Equity), and change its date and amount to match your bank statement.

Chart of accounts View register Opening balance entry

The Reconcile screen shows the wrong beginning balance? That figure is the ending balance of your last reconciliation, recalculated. Find the reconciled transaction that was edited, deleted or added since, and put it back the way it cleared.

Changing a bank account's opening balance

Use this when the account itself was set up with the wrong starting figure or start date.

  1. 1

    Pick the start date and find the real balance

    Choose the day before the first transaction you want in QuickBooks. Take the balance for that day from your bank statement, not from the bank's live balance today.

  2. 2

    Open the register

    Chart of accounts View register

    Find the bank account in your chart of accounts and open its register. The opening balance entry is usually the oldest line, showing Opening Balance Equity as the account or payee.

  3. 3

    Edit the date and amount

    Click the entry, change the date to your start date and the amount to the statement figure, then save. Money in the account goes in the deposit column; a credit card or loan balance owed goes the other way.

    Watch for: an R in the reconcile column. If you've already reconciled past this entry, changing it shifts every reconciliation built on it. QuickBooks warns you before saving. If you see that warning, stop and check the next section first.

  4. 4

    No opening balance entry at all?

    Accounts created with a zero balance don't have one. Add a journal entry dated your start date: the bank account on one line, Opening Balance Equity on the other, for the statement amount.

  5. 5

    Look at Opening Balance Equity afterwards

    Every opening balance lands there. Once all your accounts are set up, that balance belongs in owner's equity or retained earnings. Ask your accountant to move it rather than guessing the split.

Why the Reconcile screen's number moved

QuickBooks rebuilds the beginning balance from every transaction it has marked reconciled. Touch one of those after the fact and the starting point for next month moves with it.

Example · checking account, April reconciliation
Ending balance you reconciled to in March (Matches the March statement) $12,400.00
Reconciled deposit later deleted as a "duplicate" (It was a real deposit) − $850.00
Reconciled check edited from $300 to $30 (A typo fix on the wrong line) + $270.00
Beginning balance QuickBooks now shows for April $11,820.00

Your April statement still opens at $12,400.00. The $580.00 gap is exactly those two edits, and no new entry will close it properly. Restoring them will.

Fixing a Reconcile screen beginning balance

  1. 1

    Start the reconciliation and read the warning

    Settings ⚙ Reconcile

    Pick the account. When the beginning balance doesn't match what you last reconciled, QuickBooks says so and offers to show what changed. Open it.

  2. 2

    Check each changed transaction against the old statement

    For every reconciled item that was edited, deleted or added, pull up the bank statement for the month it cleared. Match the amount, the date and whether it should exist at all.

  3. 3

    Put the transaction back the way it cleared

    Change an edited amount back. Re-enter a deleted one with its original date and amount, then mark it reconciled. If something new was dated into a closed month by mistake, move it to the right date.

  4. 4

    Reopen Reconcile

    The beginning balance recalculates as soon as the transactions are right. It should now equal your last statement's ending balance.

    Watch for: the urge to undo whole reconciliations. Accountant users can undo a reconciliation, but it unmarks every transaction in that month, so it's the last resort, not the first.

What usually caused it

Bank feed pulled in transactions older than the opening balance

How you'll know: Deposits and payments dated before the account's start date, and a balance that's off by roughly their total.

Fix: Either delete the transactions from before your start date, or move the opening balance entry earlier so its date and amount match the bank for that earlier day.

A duplicate was cleaned up after it was reconciled

How you'll know: The gap equals one deposit or payment, and the discrepancy list shows a deletion.

Fix: Check which copy was reconciled. If the reconciled one was deleted, re-enter it and delete the unreconciled twin instead.

Someone typed an adjustment to force the number

How you'll know: A journal entry or a reconciliation adjustment with no bank transaction behind it, often to Opening Balance Equity or an "adjustment" expense.

Fix: Reverse it once the real cause is fixed. Leaving it in means the error is still there, just hidden in another account.

The opening balance itself was edited on a reconciled account

How you'll know: Every reconciliation since setup is off by the same amount.

Fix: Change the opening balance back to the figure on the first statement you reconciled, then check Opening Balance Equity hasn't picked up a stray difference.

Questions people ask

Why is my beginning balance off in QuickBooks?

Nearly always because a transaction from an already-reconciled month was edited, deleted or added later. The beginning balance is rebuilt from reconciled items, so that one change carries forward. The warning on the Reconcile screen lists which transactions changed.

How do I enter a beginning balance for a new account in QuickBooks Online?

When you add the account in the chart of accounts, QuickBooks asks for a balance and the date it applies to, and posts it against Opening Balance Equity. Forgot, or got it wrong? Edit or add the opening balance entry in the account's register afterwards, as in the steps above.

Can I change the beginning balance shown when reconciling if I'm sure the statement is wrong?

No, and forcing it would hide a real problem. If you believe the bank's statement is wrong, take it up with the bank and get a corrected statement. QuickBooks should only ever match what the bank actually reports.

How do I fix a beginning balance discrepancy in QuickBooks Desktop?

Same cause, same fix. In Desktop, run the Reconciliation Discrepancy report from the Banking reports for that account. It lists reconciled transactions that were changed or deleted and the effect each change had on the balance.

Does changing the opening balance affect my profit and loss?

No. The other side of an opening balance entry is Opening Balance Equity, a balance sheet account, so income and expenses don't move. What it can change is every reconciliation that starts from that entry.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.