Skip to main content
F
faf07
January 5, 2021
Solved

Fixing uncleared transaction from 4 years ago

  • January 5, 2021
  • 2 replies
  • 0 views

Trying to reconcile my account and it's saying I have an uncleared(that was previously cleared) transaction from 4 years ago. I have tried manually clearing it in the register but it is not changing anything. Do I have to unreconcile back 4 years?

    Best answer by ReymondO

    Hi there, @faf07.

     

    Let me help you fix your reconciled accounts so you can close your books. I've got an idea of why you're getting this issue and how to fix it. 

     

    There may be times when transactions you already reconciled show up as unreconciled. Here are a few reasons why:

     

    • Someone changed or deleted the reconciled transactions.
    • Cleared transactions were unchecked (uncleared) in the account register.
    • Someone undid the last reconciliation.
    • Funds were transferred from a previously reconciled bank account to a sub-account.

     

    However, we can perform a mini reconciliation in QuickBooks Desktop (QBDT) to create changes in your reconciled accounts. This special method uses an "off-cycle" reconciliation date to make a correction. This also assumes you know the ending balance from the most recent reconciliation. Get this information before you start.

     

    To fix transactions in a bank account, follow these steps:

     

    1. Go to the Banking menu and select Reconcile.
    2. Choose the bank account with the transactions you need to reconcile.
    3. In the Date of Statement field, enter the date for an "off-cycle reconciliation." Please take note that when you enter an "off-cycle" date, QuickBooks will remind you that you're doing a mini reconciliation. This puts previously unreconciled transactions back without affecting the "cycle" that they follow.
    4. In the Ending Balance field, enter the balance of your last successful reconciliation and select Continue.
    5. From the Reconcile window, check off the transactions you are fixing and re-reconciling.
    6. Make sure the Difference field shows $0.00.
    7. When everything looks good, select Reconcile Now.

     

    If you're a credit card account, follow these steps to clear your transactions: How to fix transactions in a credit card account.

     

    You can also 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. 

     

    I'm just a reply away if you have other questions with the QuickBooks Desktop. Just add the details of your concerns in this thread and I'll help you out. Keep safe!

    2 replies

    R
    ReymondOAnswer
    January 5, 2021

    Hi there, @faf07.

     

    Let me help you fix your reconciled accounts so you can close your books. I've got an idea of why you're getting this issue and how to fix it. 

     

    There may be times when transactions you already reconciled show up as unreconciled. Here are a few reasons why:

     

    • Someone changed or deleted the reconciled transactions.
    • Cleared transactions were unchecked (uncleared) in the account register.
    • Someone undid the last reconciliation.
    • Funds were transferred from a previously reconciled bank account to a sub-account.

     

    However, we can perform a mini reconciliation in QuickBooks Desktop (QBDT) to create changes in your reconciled accounts. This special method uses an "off-cycle" reconciliation date to make a correction. This also assumes you know the ending balance from the most recent reconciliation. Get this information before you start.

     

    To fix transactions in a bank account, follow these steps:

     

    1. Go to the Banking menu and select Reconcile.
    2. Choose the bank account with the transactions you need to reconcile.
    3. In the Date of Statement field, enter the date for an "off-cycle reconciliation." Please take note that when you enter an "off-cycle" date, QuickBooks will remind you that you're doing a mini reconciliation. This puts previously unreconciled transactions back without affecting the "cycle" that they follow.
    4. In the Ending Balance field, enter the balance of your last successful reconciliation and select Continue.
    5. From the Reconcile window, check off the transactions you are fixing and re-reconciling.
    6. Make sure the Difference field shows $0.00.
    7. When everything looks good, select Reconcile Now.

     

    If you're a credit card account, follow these steps to clear your transactions: How to fix transactions in a credit card account.

     

    You can also 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. 

     

    I'm just a reply away if you have other questions with the QuickBooks Desktop. Just add the details of your concerns in this thread and I'll help you out. Keep safe!

      F
      faf07Author
      January 14, 2021

      Thank so much! I didn't get any messages about off cycle but I continued and it worked. Phew. =)

      N
      Nick_M
      January 14, 2021

      Hi there, faf07.

       

      Thank you for posting here in the Community. I'm so glad that my colleague was able to assist you! If you have any other questions, feel free to post here anytime.

       

      Thank you and have a lovely day.

      K
      Karl ValleyMission
      January 11, 2024

      Did NOT work. The uncleared transactions, which have all been reconciled previously, are all expenses that go back to 2021!

      The bank account balance we know is correct, but why do some of these random charges reappear? This happesn also in my other personal business account. Anytime I try to 'correct' it, it throws my reconciliation off.

      PLEASE HELP!!!!

      J
      juliea9
      January 11, 2024

      I would ask your accountant for help - you will likely need to do journal entries to clear the old transactions. Thats what I had to do. 

      C
      ChristieAnn 11
      January 11, 2024

      Hello there, Karl.

       

      I understand that things have been challenging for you with the random charges reappearing after they have been reconciled. I can also see how important it is to have accurate reconciliation data on your end. I've got steps to ensure you can view this correctly and route you to the right team to assist you further on this matter.

       

      As mentioned above, there may be times when entries like expenses you already reconciled show up as unreconciled or reappear on the Reconciliation page. Below may be a few reasons for this:

       

      • Someone undid the last reconciliation.
      • Someone changed or deleted the reconciled transactions.
      • Cleared transactions were unchecked (uncleared) in the account register.
      • Funds were transferred from a previously reconciled bank account to a sub-account.
      • Company file conversions can cause issues (from QuickBooks for Mac to Windows or QuickBooks Online to Desktop) (US only).
      • The transactions were never reconciled in the company file. This might be because the file was restored from a backup, which can overwrite data and reconciliations.

       

      To fix this, you can perform a special reconciliation, also sometimes called a "mini reconciliation". This method uses an "off-cycle" reconciliation date to make a correction. Beforehand, you have to run and customize a report so you can review your reconciliation data. This allows you to see which entries are shown unreconciled in the program.

       

      Then, here's how to fix transactions in a bank account.

       

      1. Go to the Banking menu at the top and choose Reconcile.
      2. Select the bank account with the transactions you need to reconcile.
      3. From the Date of Statement field, enter the date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
      4. In the Ending Balance field, enter the balance of your last successful reconciliation. Then click Continue.
      5. From the Reconcile window, check off the entries you are fixing and re-reconciling.
      6. Make sure the Difference field shows $0.00. Then, select Reconcile Now when everything looks good.

       

      For additional information, you can refer to this article: Reconcile previously deleted and re-entered checking or credit card transactions.

       

      If the problem persists, I recommend clicking this article to see what else can be done to fix the issue: Fix issues when you're reconciling in QuickBooks Desktop.

       

      In case the problem continues to occur, I suggest contacting our QuickBooks Desktop Support Team. They have the tools to pull up your account details in a secure environment and the best ones to talk to regarding the next steps you need to take to fix the issue.

       

      Lastly, you can read this article if you need more guidelines to help you fix any reconciliation issues that you might encounter: Learn the reconcile workflow in QuickBooks.

       

      Feel free to post here in the Community if you have any concerns about reconciling your accounts in QuickBooks. I want to make sure you're taken care of, and I'm here to help you anytime, Karl. Take care always.

      Terms & ConditionsAccessibility statement