How to Change Beginning Balance in QuickBooks Online: Fix, Edit and Adjust It When Reconciliation Will Not Balance

Change the transactions underneath it, not the field itself. If this is your first reconciliation of the account, edit the opening balance entry in the account register. If you have reconciled before, run the Reconcile Discrepancy report and correct whatever changed since the last reconciliation. QuickBooks recalculates the beginning balance the moment the underlying entries are right.

That distinction decides everything about how long this takes. A first reconciliation with a wrong beginning balance is nearly always one bad number in one entry, and it is a five minute fix. A previously reconciled account that has drifted is a hunt for a specific changed transaction, and the report Intuit gives you names it directly. Work out which of the two you have before you touch anything, because the fix for one does nothing for the other.

Because it is a calculated total, not a stored value. QuickBooks adds up every transaction you have marked as reconciled in that account and shows the result as your beginning balance. There is no field to overwrite. If QuickBooks let you type over it, the register and the reconciliation would disagree permanently and the account would never tie out again.

This frustrates people who came from a spreadsheet, where a starting figure is just a cell you retype. It is worth making peace with the design, because it is the reason a QuickBooks reconciliation is evidence of anything. The number can only move when a real transaction moves, which means a matching beginning balance genuinely tells you the prior period is intact.

Four situations produce a beginning balance, and each one is fixed in a different place. Find your row before you start.

Edit the opening balance entry so it matches the closing balance on the statement immediately before the period you are reconciling. Intuit's own steps are short:

1. Select Settings (the gear icon), then Chart of accounts.
2. Find the bank or credit card account and select View register.
3. Scroll to the oldest entry, which is normally labeled Opening Balance and posts against Opening Balance Equity.
4. Select the entry to expand it, then select Edit.
5. Change the figure in the Deposit column so it matches your bank records for that date.
6. Select Save, then reopen the reconciliation.

The date matters as much as the amount, and it is where most first reconciliations actually go wrong. The opening balance has to sit one day before the first transaction you are bringing in, and it has to equal the statement's closing balance on that day. An opening balance dated in the middle of a month, or one taken from today's online banking balance instead of a statement closing balance, will produce a figure that looks almost right and never reconciles.

If there is no opening balance entry in the register at all, QuickBooks has started you at zero and there is nothing to edit. Create one instead: select New, then Journal entry, date it before the oldest transaction in the account, debit the bank account for the correct starting figure and credit Opening Balance Equity. The mechanics of that account, and how to clear it afterward, are covered in the guide to opening balance equity in QuickBooks.

Somebody changed a transaction you had already reconciled. QuickBooks flags it with a banner reading that your account is not ready to reconcile yet and that your beginning balance is off by a stated amount. Select the link in that banner that reads "We can help you fix it" and QuickBooks opens the Reconcile Discrepancy report, which lists every reconciled transaction that has been altered since.

Read that report as a list of suspects rather than a list of errors. Each line shows what changed and by how much, and the total difference will usually be explained by one or two of them. Four things put a transaction on it: someone edited the amount or the date, someone deleted it outright, someone moved it to a different account, or someone cleared the reconciled checkmark in the register. Fixing the transaction back to what the statement says removes it from the report and the beginning balance corrects itself.

Where the difference is not on that report, the cause is usually a transaction that never existed in QuickBooks rather than one that changed. That is the missing history case, and it is covered further down. The broader troubleshooting path, including differences that survive both checks, is in the guide to fixing a reconciliation discrepancy in QuickBooks.

In practice the causes fall into a short list, and knowing which one you are looking at saves the afternoon:

• An opening balance taken from the wrong date. Today's available balance instead of the statement closing balance is the single most common one.
• A reconciled transaction that was edited or deleted. Often by someone cleaning up duplicates months later without realizing the entries were reconciled.
• An accidental unreconcile. Clicking the R column in the register silently changes the reconciled status and no warning appears.
• A forced adjustment from a previous period. A prior preparer finished a reconciliation with a difference still showing, and QuickBooks posted a balancing journal entry that is now baked into every later beginning balance.
• Missing months. The bank feed reached back roughly 90 days on connection and everything older was never imported, so the register genuinely does not contain the transactions the statement is built from.
• Duplicate imports. The same month uploaded twice, which inflates the balance rather than shrinking it. The guide to duplicate bank transactions in QuickBooks covers removing them safely.

The principle is identical, but Desktop gives you better reports to find the culprit. Go to Reports, then Banking, then Reconciliation Discrepancy, choose the account and select OK. That report lists transactions changed since the last reconciliation. Reports, then Banking, then Previous Reconciliation shows what the account looked like when it last balanced.

When those two do not settle it, run the Audit Trail report and filter it to the account, with the entered or modified date range running from the date of the last reconciliation to today. That surfaces who touched what and when, which is often the fastest route in a file several people work in. Desktop also lets you undo the last reconciliation from Banking, then Reconcile, then Undo Last Reconciliation, then redo it once the underlying transactions are correct.

Then no amount of report reading will fix the beginning balance, because the transactions it should be calculated from are not in the file. This is the usual outcome when an account was connected partway through the year: bank feeds commonly reach back only about 90 days, and everything earlier has to come from statements.

Convert those statements and import them oldest month first, reconciling each one before moving on. A month that reconciles is a month you never revisit, and a discrepancy caught in February is far easier to trace than the same discrepancy found in November after nine more months have piled on top of it. Manual uploads carry no 90 day limit, which is exactly why this route works for a prior year when the feed cannot help. The full workflow is laid out in the guide to importing old bank statements into QuickBooks, and firms rebuilding a whole year should start with the catch-up bookkeeping workflow.

Only as a last resort, and only for a small unexplained difference you have genuinely investigated. Finishing a reconciliation with a difference still showing makes QuickBooks post a balancing journal entry, normally to an account called Reconciliation Discrepancies. It clears today's screen and leaves a permanent entry that misstates your books.

The real cost shows up later. That forced entry sits inside every future beginning balance, so the next person to reconcile the account inherits a figure that cannot be traced to any statement. Worse, if the underlying cause was missing transactions, the adjustment hides real income or real expenses from the profit and loss and from the tax return built on it. Investigate first, adjust only what you can still explain in twelve months' time, and write a note on the entry saying what it was for.

Enter it when you create the account, using the closing balance from the statement that ends the day before your start date. In the chart of accounts select New, choose the account type, then enter the balance and the as of date. QuickBooks posts the offsetting side to Opening Balance Equity, which you clear later against retained earnings or owner's equity.

Pick the start date deliberately, because it decides how much history you owe. The start of a fiscal year is the cleanest choice: everything before it is covered by the prior year's closing figures, and everything after it comes from statements you import. Starting mid-year is workable but means the year is split across two systems at tax time. More on choosing and entering that figure is in the guide to the QuickBooks opening balance.