I recently acquired a client that has no computerized books. They were all pen/paper for YEARS. I started by entering/reconciling 2024 beginning January 1, 2024. I entered the bank balance on that day for the Opening Balance. After that, I entered transactions forward to current. Therefore, the current reconciled period is October 31, 2024.
However, now I need to go backwards and enter the prior years transactions and reconcile them. I opted to start with December 2023 and go month by month backwards eventually ending at January 2023. Then begin that process again with 2022, and so on. My issue is I can't figure out how to bypass the last reconciled period. I already updated the Opening Balance to that on the statement on December 1, 2023. However, the reconciliation screen is pulling the beginning balance from the end of October 2024. Obviously, that won't match the beginning balance for December 2023. How do I bypass this? Should I start with January 2023 and move forward?
The Reconcile feature in QuickBooks Online (QBO) uses an automated system that builds upon previously completed reconciliations, steelecolumbinebooks. Allow me to share details to help with your questions about reconciling older periods.
Please note that QBO will automatically set the Beginning balance from the Ending balance of your most recent reconciliation. This feature is designed to maintain continuity in your financial records.
Currently, there is no option to bypass or manually adjust the amount if you need to reconcile an older period. The system is designed to maintain reconciliations in chronological order.
It's best to reverse the entire reconciliation history up to the point where modifications are necessary. This method allows you to begin anew from the correct starting point, ensuring the accuracy of balances throughout your reconciliation timeline.
If you're using QuickBooks Online for Accountants, you can use a special tool to undo several past reconciliations. Here's how:
Here's an article about this feature for more details: Undo a client’s reconciliation in QuickBooks Online Accountant.
If you're using a regular version of QBO, use these steps instead:
You can also read more details about this here: Undo or remove transactions from reconciliations in QuickBooks Online.
After that, you can start reconciling the bank from the oldest period that you want. Go straight to the Step 2: Start a reconciliation part of this article in case you need guidance on this: Reconcile an account in QuickBooks Online.
Let me share these articles that can provide additional guidance during the reconciliation process:
Feel free to reply or post any additional questions you have about reconciliations, running financial reports, or any other tasks for your clients in QuickBooks Online. We would be more than happy to assist you 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.
For more information visit our Security Center or to report suspicious websites you can contact us here