Hello, @rosieposie123.
I can help you determine whether you need to go back to the beginning of October 2021 to redo your reconciliation in QuickBooks Desktop (QBDT).
If you're still off by 90k after reconciling 2023, you can consider unreconciling the previous months until October 2021. However, please know that this would be a time-consuming process.
Alternatively, you can consider investigating where the discrepancies are so you won't need to redo the entire reconciliation. For this, I recommend retrieving your bank statements from when you started reconciling and checking if the beginning balance for each month is the same as what you have in QBDT.
If the beginning and ending balances of your bank statement doesn't match your record for the month, proceed to unreconcile the previous month and reconcile moving forward. However, if it matches, you'll only need to address issues with missing or duplicate transactions of the month you're reconciling. To help in this task, you can run the previous reconciliation report. Here's how:
- Go to the Reports menu. Hover over Banking and select Previous Reconciliation.
- From the Account drop-down menu, select the account you reconciled.
- In the Statement Ending Date section, select the reconciliation period you want to review.
- Select the Detailed report type.
- Select which transactions you want to see on the report:
a. Transactions cleared at the time of reconciliation: This gives you a snapshot. It only shows transactions in the account at the time of the reconciliation.
b. Transactions cleared plus any changes made to those transactions: This shows transactions in the account at the time of reconciliation. It also shows where they currently are in your accounts.
- When you're ready to run the report, select Display.
I also encourage collaborating with your accountant or company owner while fixing your reconciliation. They can assess the feasibility and risks of starting over from 2021 compared to other options like reconciling by section or identifying specific errors. They can recommend the most efficient and accurate approach based on your situation.
After this, let me add this article to check out available reports to track your cash flow in QBDT: Track your cash flow in QuickBooks Desktop.
Let me also add this link to check out available reports to gain insights about your business' performance: QBDT Reports.
We'll be here in the Community if you need further assistance fixing your reconciliation ending balance in QBDT. We're committed to offering ongoing support. Take care.
