Have you experienced seeing reconciled items from the previous month appearing as an unreconciled item in the following month?

Hi nmaguinaldo,

Welcome to Community!  QuickBooks Online provides the features you need to reconcile your accounts with confidence.  Noting unreconciled transactions that have been previously reconciled, is definitely concerning.  I would be happy to assist!

Initially, I suggest reviewing the Beginning balance, the Ending balance and Ending date as they appear on your bank or credit card statement.  If you still see unreconciled transactions that were previously reconciled, ensure that duplicate transactions have not been downloaded, or manually entered. If the statement indicates duplicate transactions, your automatic upload to QuickBooks was accurate and aligned with your bank. However, if no duplicates are found, you'll want to remove the duplicate entries from your bank feed in QuickBooks Online. Here's how;

1. From the For Review tab, checkmark the box beside all duplicated entries

2. Select Exclude 

Note: You can permanently delete the transactions from the Excluded tab by selecting all items and then hit Delete. Please be advised that this process is irreversible and any transactions deleted in error will need to be recreated manually.

Should the issue persist, please don't hesitate to contact us outside of Community. It would be our pleasure to work with you in real time and review the issue in more depth, so it can be escalated it for further investigation if necessary.

If you have any other questions or concerns, feel free to reach back out. We would be happy to help!

When reconciled transactions appear as unreconciled items in QuickBooks (QB), it can be frustrating and confusing. Here are some common reasons why this might happen:

1. Manual Changes:

   • Editing a Reconciled Transaction: If a reconciled transaction is edited, it can become unreconciled. Changes to the date, amount, or account can impact its reconciliation status.
   • Deleting a Reconciled Transaction: If a reconciled transaction is deleted and then re-entered, it will appear as unreconciled.

2. Duplicate Entries:

   • Duplicate Transactions: Sometimes, transactions can be entered more than once. If a duplicate entry is not marked as reconciled, it can cause confusion.

3. Bank Feeds and Imports:

   • Imported Transactions: When transactions are imported from bank feeds or external sources, discrepancies can occur, causing reconciled transactions to appear as unreconciled.
   • Bank Feed Rules: Automatic categorization rules can sometimes create transactions that don't match exactly with those that were manually entered and reconciled.

4. Errors During Reconciliation:

   • Errors in Reconciliation Process: Mistakes during the reconciliation process can cause previously reconciled transactions to appear as unreconciled.
   • Unmarking Transactions: If transactions were accidentally unchecked during reconciliation, they would appear as unreconciled.

5. Account Changes:

   • Changing Accounts: Moving a transaction from one account to another can affect its reconciliation status.

6. Software Bugs and Sync Issues:

   • QuickBooks Bugs: Occasionally, software bugs or glitches within QuickBooks can cause reconciliation issues.
   • Sync Issues: Problems with synchronization between QuickBooks Online and bank accounts or other financial tools can lead to reconciliation discrepancies.

Troubleshooting Steps

1. Review Reconciliation Reports:

   • Go to the reconciliation report for the period in question and review the transactions. Look for any discrepancies or edits.

2. Check Audit Log:

   • Use the Audit Log feature in QuickBooks to track changes to transactions. This can help identify if and when a reconciled transaction was edited or deleted.

3. Match and Categorize Transactions:

   • Ensure that all transactions are correctly matched and categorized, especially if using bank feeds or imported data.

4. Reconcile Again:

   • Sometimes, simply going through the reconciliation process again can resolve the issue. This involves checking off the transactions as reconciled once more.

5. Consult QuickBooks Support:

   • If the issue persists, consider reaching out to QuickBooks Support for assistance [scam phone number removed] . They can help diagnose and resolve more complex problems.

By carefully reviewing transactions and ensuring accuracy during data entry and reconciliation, you can minimize the occurrence of reconciled transactions appearing as unreconciled in QuickBooks.