Skip to main content
R
rawpwr101
February 21, 2025
Question

Old Reconciled Transactions Showing Up When Reconciling

  • February 21, 2025
  • 2 replies
  • 0 views

I had everything reconciled to date and old items keep showing up when I try to reconcile the new month. If I remove the item, I get an error that an old reconciliation is now out of balance, so I have to put it back and mark it clear in the register, so it won't have a prior month out of balance, but the transaction is still showing up when I try to reconcile the current month. Where can I find what is going wrong within the system? Everything looks correctly deposited and applied from my end.

    2 replies

    Rainflurry
    Rainflurry
    February 21, 2025

    @rawpwr101 

     

    What do you mean by "If I remove the item" and "I have to put it back and mark it clear in the register"? 

     

    When you reconcile, you can't remove a transaction, you can only mark it cleared.  Why are you marking anything in the register?  

    R
    rawpwr101Author
    February 24, 2025

    What I meant was un-match it and the exclude it from the reconciliation. Its showing as unreconciled, like it can be selected towards the reconciliation, but the item is already reconciled. If I go into bank transactions and unmatch it, so it doesn't show as something waiting to be reconciled, and then go back to finish reconciling, it tells me that an old reconciliation is now out of balance. So I have to re-match it to the transaction. Then I have to go into the register and mark it as reconciled, which makes it so the old reconciliation is now in balance and I can continue reconciling, but its showing as an unreconciled item again. I'm not understanding where in QB its going wrong because if its reconciled in a prior month, why would it still be showing up as an outstanding item?

    K
    Kurt_M
    February 24, 2025

    I appreciate you getting back here in the thread, @rawpwr101. I'll provide troubleshooting to help you address a reconciled transaction that appears unreconciled in QuickBooks Online (QBO).

     

    Before anything else, I'd like to share a few reasons why this occurs on your end. The unreconciled transactions showing in your account are due to the following:

     

    • Someone undid the last reconciliation.
    • Someone modified 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.

     

    You'll want to undo the prior reconciliation and re-reconcile it to address this situation promptly. However, since only an accountant can undo a complete reconciliation, I suggest collaborating with an accountant to assist you in navigating this situation. If you don't have an accountant, I can help you find one. Feel free to visit this page: Find a QuickBooks ProAdvisor.

     

    In addition, you run a financial report to help you keep track of all your recordings in QBO. Check out this article to get started: Run a report in QuickBooks Online.

     

    I'll be around to help you ensure this is taken care of. You can continue to communicate with me below so I can provide the necessary information to help resolve QuickBooks-related inquiries. Stay safe. 

    K
    Kurt_M
    February 21, 2025

    Thank you for reaching out, @rawpwr101. I can help you address the transactions so you can proceed to reconcile your current month and ensure your books stay accurate in QuickBooks Online (QBO).

     

    Before anything else, please know that it's essential to determine the letters that appear when reconciling an account in QBO. When you click the blank in the Checkmark, then the R reflects. It means you've reconciled the transaction. While C means you've cleared it from the account register, and Empty or blank means it's been unreconciled from the bank register. For more details, please see this article:

     

    Since you're reconciling a new month, you'll want to ensure that it shows R and not C. Otherwise, it'll cause issues with the period you're reconciling. I recommend utilizing a reconciliation report to verify which transactions require reconciling. You'll then double-check the transaction's amount to see if it changed while ensuring the reconciliation report matches your transactions in the account register. These are the steps:

     

    1. Access your QuickBooks Online company.
    2. On the left navigational bar, click the Reports tab.
    3. In the Search bar, enter Reconciliation report.
    4. Click on the result and then filter it to show specific date.
    5. Once done, click the Run report button.

     

    For visual reference, see the image below. 


    Once you've determined the transaction, proceed to continue reconciling the account. Refer to this page for further guidelines:  Reconcile an account in QuickBooks Online.

    QuickBooks Live Expert Assisted is now available and that they can lend a helping hand in reconciling your accounts in QBO. Feel free to check them out to streamline your reconciliation process.

    Moreover, I'm providing this article in case you'd like to print or export a copy of your reconciliation report in QBO: How do I view, print, or export a reconciliation report?

     

    Please let me know in the comment section if you require further assistance reconciling an account or handling bank transactions in QuickBooks. As always, I'll be here to respond and help you again. Keep safe.

    Terms & ConditionsAccessibility statement