wrong opening balance from imported bank account

Hey there janegoodlad,

I'm here to make sure you'll be able to match the QuickBooks opening balance with your bank statement.

Since you need to correct the opening balance discrepancy in before you reconcile, I can show you some troubleshooting steps. I've attached an article that'll show you how to fix an incorrect beginning balance:

My reconcile opening balance is wrong. How do I make it match my statement?.

After following the steps in the article, you'll be able to correct the opening balance and reconcile the bank account successfully.

Please stay in touch if there's anything else that you need and I'll be sure to help you out. Wishing you all the best.

Hi Jane,

QuickBooks automatically pulls in an opening balance when you connect your bank account which isn't always correct. 

If you navigate to the accounting tab on the left hand side navigation menu and find your bank account within this list. Click on account history (which is a blue hyperlink). You will see in here somewhere (depending on how many transactions you have) an 'Opening balance' entry. This is the automatic entry QuickBooks enters. Click into this and change the figure to what the balance should be.

I hope this makes sense.

Kind Regards,

Emily

Hi Jane,

If you would like to edit your opening balance for the account to match the date and balance of your account when you started using QuickBooks Online, have a look at the below steps.

• Choose the Gear icon > Chart of Accounts.
• Locate the account and click on Account history in the Action column.
• Go to the top of the register to the Opening Balance entry and
• Click on the transaction line to edit the amount.
• Click SAVE.  The change will not be saved if you navigate away from the register without saving.

If you connected the bank feed, the opening balance transaction will already be marked with an R which signifies that the transaction is reconciled.  When you change this balance, the transaction will be unreconciled.

To make your first reconciliation easier, you can change this status to Reconciled so that this will be your starting amount when you first reconcile your account. Here's how to do it

• Within the Account History, find the transaction that needs to be reconciled.
• Go to the reconcile status column (indicated by a check mark), and select the top line of the transaction.You can continually click the box in the status column to achieve the status desired for this transaction. For example, if it was originally blank, click once and it will display a C, if you click again an R will appear to reconcile the transactions.
• Remember to click on Save to save the changes.

Now when you go to the Reconcile function, your starting balance should match your bank statement starting balance and you will be able to successfully reconcile the account.

Let me know if you need anything further.