If you've created a bank account with an incorrect opening date, is there a way to change that date? I linked a bank account during my QuickBooks Online account setup and it pulled in 90 days worth of transactions. I only wanted to pull in transactions since January 1.
I've tried to delete all the transactions prior to Jan 1, and changed the Opening Balance Equity transaction to Jan 1, 2022, but on the Business view, in the Overview page, when I choose the "Cash balance" on the "Cash flow" widget, it shows a cash balance starting in Nov:
However, I have zero transactions that are in any account register prior to Jan 1, 2022, as evidenced by this report:
My best guess is that somehow the Cashflow widget is checking my Opening Balance Equity account and pushing that amount out to Nov 15, 2021, when it thinks my first bank account was opened. So... is it possible to change that opening balance date? If so, how? And if that's not the issue, what's going on here?
Let me help you with incorrect opening date on your bank account, JoshBeall.
In QuickBooks Online (QBO) we can change the date by undoing the reconciled transactions. Please follow these steps:
To learn more about this one, see the Undo and remove transactions from reconciliations in QuickBooks Online article. Once done, you can now start the reconciliation again and enter the correct opening date. You can check the Reconcile an account in QuickBooks Online article for the steps and details. Just in case QBO doesn't match your bank statement at the end of reconciliation, follow the steps in the Fix issues when you're reconciling accounts in the QuickBooks Online article to troubleshoot the issue.
If the opening balance for one of your accounts is wrong, we can edit it through the View register for the account.
To edit a wrong opening balance:
If there isn't already an opening balance listed and you want to enter one, checkout this article: How to enter an opening balance for an existing account.
Feel free to visit our Banking page for more insights about managing your bank feeds and reconciling accounts.
I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Please reply to this post and I'll get back to you. Take care always.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here