Skip to main content
T
tim14
February 5, 2019
Question

How do I correct uncleared transactions in the reconciliation report. Many of these transactions have cleared yet must have had double entries.

  • February 5, 2019
  • 5 replies
  • 0 views
Original commenter did not share additional details

    5 replies

    Regina_Lend_A_Hand_Accounting
    Regina_Lend_A_Hand_Accounting
    February 5, 2019

    While duplicate transactions do occur, it is also possible that transactions were not "matched" properly within the bank feed before adding them to the account register. If there is no green square under the "C" (Cleared) reference in your check register the transaction has not been "matched" within the bank feed to a manually entered transaction. You can "undo" the "Add" of transactions that were not properly matched and find the match and Add them back.

    M
    minie123
    March 18, 2019

    I like your solution of this problem but, what if reconciliation is done already, still can go to Undo from REVIEWED and change it and ADD them back?

    Thanks

    C
    Catherine_B
    March 18, 2019

    Hi minie123, 

     

    If these transactions are relevant yet uncleared, you'll have to wait until it will get cleared from the bank. You'll include this transaction on when it was cleared from the bank. On the other hand, if it is a duplicate or unnecessary, you can delete it the bank's register. 

     

    You can read through this article for more details in troubleshooting reconciliations: 

    Reach out to me if you have other questions. 

    C
    cfwnole
    April 13, 2020

    I'm bad & wasn't reconciling each month; therefore I have transactions

    from March let's say, not cleared until April.

    As me accountant will be swamped, how do I fix this, especially since I know it's cleared? Then I can finally get on with it? TY!!

    IntuitLily
    IntuitLily
    April 13, 2020

    Welcome back to the Community, @cfwnole.

     

    I'd like to share some insights about clearing the transactions from the previous month. 

     

    If these transactions weren't reconciled yet, you can go to your bank register and manually clear the transactions from there. Otherwise, you may need to undo it before you proceed with this month's reconciliation.

     

    Here's how to manually clear bank transactions in QuickBooks:

     

    1. Go to the Gear icon, then choose Chart of Accounts.
    2. Locate the account of the transaction.
    3. Select View Register from the Action column.
    4. Identify the transaction to clear.
    5. Under the reconcile status column, select C for Cleared. You can also manually reconcile by selecting R or you can leave it as blank if they aren't cleared or reconciled.
    6. Select Save.

    For other reconciliation resources you can check, please click this guide: Learn the reconcile workflow in QuickBooks.

     

    Should you have any additional questions or concerns, the Community will have you covered. Thanks for reaching out, best wishes.

    C
    christianallen
    October 4, 2020

    Hi IntuitLily,

     

    This was super helpful, however I am still stuck.  When I reconcile, I have a long list of transactions that are listed as uncleared, however we do not manually add any transactions in QB, everything comes in via bank feeds.  Additionally, I followed your instructions and went to the relevant account's register and found a couple of transactions that are listed as "uncleared" on the Reconciliation Report and they are listed as "cleared" in the account register.  Any thoughts?

     

    Thanks!

    P
    PerfCarBuilder
    May 20, 2020

    I have a question.....I have debits out there from 2019 sitting in my bank reconciliation.  I just need to get rid of them. Is making a journal entry the only way as I don't want to mess up my books from last year. Thanks for any help!!

    MaryLandT
    MaryLandT
    May 20, 2020

    Thanks for joining this thread, PerfCarBuilder,

     

    You'll want to delete uncleared transactions from your bank if those are duplicates. It will help clear those transactions on your bank reconciliation page.

     

    Let me show you how:

    1. Click Accounting from the left navigation bar, then Chart of Accounts.
    2. Look for the bank account, then click View register.
    3. Locate the transaction, then open it.
    4. Click Delete and choose Yes to confirm the action.

    You can also create a journal entry to clear them. However, I highly suggest consulting your accountant for advice about this process. He/she will can provide an option that suits your company setup.

     

    Feel free to leave a comment below if you have follow-up questions. I'm always glad to help.

    P
    PerfCarBuilder
    May 20, 2020

    Last year is closed. I can not get into last year and delete things without changing my year end Cost of Goods Sold (which is what these were mostly categorized as) numbers. Those debits and credits were considered at year end 2019.

    D
    Djay0542
    September 9, 2021

    I am having problems with duplicates.

    reconciliation should show one check entry for each check.  Severera are showing the original entry twice?

    A
    AileneA
    September 9, 2021

    Hello, Djay0542. 

     

    Let's isolate this case by perform basic browser troubleshooting by clearing the cache to fix the issue.    

     

    There are times that the browser is full of frequently accessed page resources, causing some unusual responses. We can start by accessing your account in a private browser. This mode doesn't save your searches, visited pages, log-in details, and cookies.    

     

    You can use the shortcut keys that I've listed below.  

     

    • Ctrl + Shift + P (Firefox) 
    • Command + Shift + N (Safari) 
    • Ctrl+ Shift + N (Google Chrome    

     

    If it works, then you can go back to your original browser and clear the cache. Alternatively, you can use other compatible browsers. It could be that the one you're currently working on has a temporary issue with QuickBooks.   

     

    Here's a step-by-step guide in reconciling your account in QuickBooks Online: Reconcile an account in QuickBooks Online.


    Also, learn what to do if your account in QuickBooks Online doesn't match your bank statement at the end of reconciliation: Fix issues when you're reconciling accounts in QuickBooks Online.

     

    Feel free to ask questions if you need clarification. I'll be happy to assist you further. have a great day and stay safe!

    S
    Sllopez
    June 1, 2023

    jumping in on this conversation, but with a twist. My client just migrated from desktop to online yesterday.  She just hired me to clean-up.  We have uncleared transactions (29K) dating back to 2015!  Yet, she says they have no bills outstanding, no old invoices outstanding & she is all reconciled.  There are just all these unreconciled transactions (she assumes are all mis-entered duplicates from manual entries).  Can I just get rid of them?  There's no way I can try to figure out undoing & recreating?  PLEASE HELP!!

    DivinaMercy_N
    DivinaMercy_N
    June 1, 2023

    Hello there, @Sllopez. I got here steps to ensure you'll fix the uncleared transactions in the reconciliation report after the migration.

     

    When migrating the data from QuickBooks Desktop (QBDT) to QuickBooks Online (IQBO), certain features, information, and transactions don't migrate and may create changes in your books. To know more, check this article: Learn how features and data move from QuickBooks Desktop to QuickBooks Online. 

     

    In your QBO account, you can clear the transactions manually in the bank registers. Before doing this, I highly recommend consulting your accounting professional to further review and guide you with the best possible method in clearing these items. This will help us ensure your books are accurate since these are old entries from previous years. 

     

    You can also run reports to view your previous reconciliation in QBO. This will show you the beginning and ending balances of the account as well as those cleared and uncleared transactions.

     

    If you have other concerns about managing your account, please don't hesitate to leave a reply below. Have a great week ahead, and stay safe.

    Terms & ConditionsAccessibility statement