Skip to main content
January 1, 2022
Question

How do I clear unreconciled transactions from previous years after taxes have already been completed

  • January 1, 2022
  • 3 replies
  • 0 views

Prior accountant had access to our account and did not reconcile 2018 or 2020, but taxes are completed. Unreconciled transactions show up in reconcilie module.

3 replies

January 1, 2022

I can help you with this, 1 Learning.

 

You can reconcile your past transactions one year at a time. This way, all adjustments, service fees, and interest you enter during the reconciliation process will apply to the year in which those transactions occurred. It would also be best to consult with your accountant so you'd be advised of the best method for you to reconcile statements and transactions for multiple years. 

 

I'll show you how:

 

  1. Go to the Banking menu and select Reconcile.
  2. Select the Account drop-down then choose the account you want to reconcile.
  3. In the Statement Date field, choose the date from the financial statement you selected.
  4. In the Ending Balance field, enter the ending balance from your statement.
  5. Compare the amount shown in the Beginning Balance field with the opening balance on the oldest statement you need to reconcile.
  6. Enter the total Service Charge and Interest Earned.
  7. Follow the screen transaction to complete the process.

You can check this article for more detailed steps: Reconcile an account for multiple months or years of transactions and financial statements.

 

Also, you can check our Year-end checklist in QBDT. This will guide you through the process of completing your task in QuickBooks so you can close your previous year and prepare for the upcoming one. 

 

Keep me posted if you have other questions about reconciling your account. I'm always here to help.

January 24, 2022

Will this affect my current check register balance or just the years that need to be reconciled?

January 24, 2022

I appreciate you for coming back to the thread to add additional confirmation about your concern, 1 Learning. With this, I'll be sharing information on how reconciling past entries works. Then, ensure that you'll be routed to the right person to assist you further on this matter.

 

Once you start reconciling past ot previous transactions, the whole current reconciliation statement will be inaccurate. That said, it causes your account differences like ending and beginning balances. However, once you have already performed accurately in reconciling your monthly reconciliation, the entries that need to reconcile in the next years will match your bank and credit card statements and ensure that there are no discrepancies.

 

To ensure your records are in shipshape, I suggest consulting an accountant before performing the process of reconciling past transactions. They can provide suggestions on how to properly handle those entries to avoid any data issues.

 

You may refer to this article to view different OL and OLSU errors in QuickBooks Desktop and how to fix them: Fix OL and OLSU Bank Feeds errors in QuickBooks Desktop.

 

Feel free to add a comment below if you have additional questions or concerns about reconciliation. I’m more than happy to answer them for you. Wishing your business continued success.

February 22, 2022

Hi, I have the same question (I believe) and still not clear from the responses here. Basically, I am trying to reconcile an account starting in 2021 that has transactions going back to 2014. The accountant said I'm welcome to enter a balancing equity number to be able to start to reconcile 2021, but I'm not sure how to clear out all of the transactions from previous years. Please let me know if you have any suggestions. Thank you!

MarsStephanieL
February 22, 2022

Great to see you here in the Community, @mlbsauer. I'd be happy to share some details about clearing the transactions from the previous years in QuickBooks Desktop (QBDT).

 

Reconciling the transactions is the best way how to clear your past transactions. You may do it one year at a time to ensure that the other possible adjustments such as service fees, and interests will be applied on the correct year.

 

You can begin with creating a back up file and prepare your statements to enter the correct ending balance per year. I'd also recommend speaking with an accounting professional to help you manage your books.

 

I've got this article for more information about the steps to clear the previous transactions: Reconcile an account for multiple months or years of transactions and financial statements.

 

You can always comment below if you have other questions or concerns about QuickBooks. I'll be here to help. Take care always.

January 30, 2024

I have a checking account that has 2022 and 2023 reconciliations done. Now I need to enter in 2021. Can I enter those transactions in and still reconcile? Will it all work out or do I have to undo all the 2022 and 2023 reconciliations