cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
vivienneyeo-zulu
Level 2

How to edit Bank Reconciliation opening balance without affecting Balance Sheet accounts? I am migrating to QB Cloud with a cut off at old accounting software.

I am migrating to QB Cloud with a cut off from old accounting software. The Bank Statement balance is not equal to the Book Balance due to unreconciled deposits and outstanding payments. For the first bank rec I want to do in QB Cloud, how can I edit the opening balance without affecting my opening balance moved from the old software?
1 Comment 1
ChristineJoieR
QuickBooks Team

How to edit Bank Reconciliation opening balance without affecting Balance Sheet accounts? I am migrating to QB Cloud with a cut off at old accounting software.

Welcome to QuickBooks Online, @vivienneyeo.

 

I'm glad to provide details on how to edit the opening balance in QuickBooks Online.

 

The starting total balance should correspond to the amount on your bank statement for the start date. With that, you can correct the opening balance by entering the balance of your real bank account.

 

Follow the steps below: 

 

  1. Go to Settings ⚙ and select Chart of accounts.
  2. Locate the tab and choose View register.
  3. Find the opening balance entry. Tip: Sort the date column to show the oldest entries first. 
  4. Select the opening balance entry.
  5. Edit the date, then the amount. If needed, select Edit to make your changes. 
  6. Select Save

 

Please note that we need to review and adjust the discrepancies when we change opening balances. You may get some insight in this article on how to fix issues you've reconciled in the past. Furthermore, is this the first time you managed your account in QuickBooks Online? See this article for your guide: Fix issues the first time you reconcile your book in QuickBooks Online.

 

Did you notice the feature difference between QuickBooks Desktop and Online? We can read this article about the lists we can move to QuickBooks Online: Move your lists to QuickBooks Online.

 

Do you have any challenges while migrating to an online version of QuickBooks? Please let us know in the Comment section. The Community is your backup.