Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have imported transactions via my online banking which I have linked to QB online. I have used sage in the past but this is my first time using QB.
The problem I have is that the opening balance shown when I go to reconcile the bank account does not relate to the opening balance on my bank statement. When I downloaded it I stated the last 30 days in the criteria as this was the closest to the option of my start date of the partnership company we now have.
Really just want to run and reconcile from the new financial year (6th April) but doesn;t seem that easy.
Any suggestions would be greatly appreciated.
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.
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
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.