Skip to main content
February 9, 2024
Question

Reconciliation

  • February 9, 2024
  • 1 reply
  • 0 views

Hello!

 

I just started working at a new company. 
The reconciliation is off by 300k.  I unreconciled 2023, and I’m still off by 90k.  I would like to go back to the beginning which is October of 2021.  Does anyone suggest that?  

Thank you!

1 reply

AlverMarkT
February 9, 2024

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:

 

  1. Go to the Reports menu. Hover over Banking and select Previous Reconciliation.
  2. From the Account drop-down menu, select the account you reconciled.
  3. In the Statement Ending Date section, select the reconciliation period you want to review.
  4. Select the Detailed report type.
  5. 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.
  6. 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. 

February 10, 2024

Hello!

 

Thank you so much for the quick response.  So helpful. I think I will start with the idea of checking the bank statements beginning and ending balances.  However, I have a question, before I started to unreconcile 2023, I had to do a back up. Can I open that backup and some how start using it again?  I am new to QB, as you can see. Or just start to reconcile 2023 again?  Does this make sense? 

Thank you!!!

 

February 10, 2024

You’re right, rosie. It’s important to create a backup before you start making changes to your company file. Let me elaborate on why and show you the complete guidelines for doing so.

 

A backup company file is used to save your previous accounting data to revert whatever unnecessary changes you have made. Or, to restore your previous accounting state if ever you run into problems. Therefore, you can use this to reinstate your previous reconciliation if you need to.

 

Moreover, please refer to this article to create a backup of QuickBooks Desktop (QBDT) to start saving a point of your accounting data: Back up your QuickBooks Desktop company file. Then, use these steps to restore it:

 

  1. Go to the File menu, and choose Open or Restore Company.
  2. Select Restore a backup copy, and click Next.
  3. Hit the Local Backup and press Next.
  4. Browse your computer for your backup company file. It should look like this: [Your company name].qbb.
  5. Choose a folder where you want to save your restored company file. Then select Open.
  6. When you're ready, select Save. If you see any messages about possibly overwriting your data, select the option that best fits your needs. Don't overwrite anything unless you know you want to.

 

Since you’ll be reconciling your account, I’ll leave you this resource for reference if you encounter issues after reconciliation: Fix issues when you're reconciling in QuickBooks Desktop.

 

Feel free to tap me in this forum if you have further questions about reconciliation and managing your company file. I’ve always got your back. Take care!