cancel
Showing results for 
Search instead for 
Did you mean: 
kelper62
Level 3

OLD TRANSACTIONS SHOWING WHEN RECONCILATION OF CREDIT CARD

I have several old credit card charges that are showing unreconciled.  The charges are from 2019 & 2021.  I do not know how these became "unreconciled".  How do I make them quit showing up under the reconciliations?

 

Thank you in advance! 

3 Comments 3
Erika_K
QuickBooks Team

OLD TRANSACTIONS SHOWING WHEN RECONCILATION OF CREDIT CARD

I'm here to ensure you can stop the reconciled transaction from showing under the reconciliation, kelper62. I appreciate the screenshot you've provided, and we'll tackle this challenge together as a team. I am committed to providing you with support throughout the entire process of resolving this matter. 

 

Oftentimes, reconciled transactions become unreconciled due to the following reasons:

 

  • 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.

 

For us to fix this, we can perform a mini reconciliation. This process involves an off-cycle reconciliation date to make a correction. This assumes you know the ending balance from the most recent reconciliation. Get this information before you start.

 

I'll show you how:

 

  1. Go to the Banking menu and hit Reconcile
  2. Select the credit card account with the transactions you need to reconcile.
  3. In the Date of Statement field, enter date for an off-cycle reconciliation. This date can be any date between your last reconciliation and the next scheduled one.
  4. From the Ending Balance field, enter the balance of your last successful reconciliation. Then select Continue.
  5. In 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, click Reconcile Now.


I've added this article for more info: Reconcile previously deleted and re-entered checking or credit card transactions
 

I'm still all ears if you have additional questions about correcting credit card transactions in QuickBooks Desktop (QBDT), kelper62. Please feel free to leave a comment if you have any specific inquiries, and I'll do my best to provide helpful guidance. I'm here to support you in ensuring your books are configured accurately within the QBDT.

kelper62
Level 3

OLD TRANSACTIONS SHOWING WHEN RECONCILATION OF CREDIT CARD

Thank you for the step-by-step instructions.  However when I did this I got a balance discrepancy message box.  I have attached a screen shot of the message.  Do you have other suggestions?  

 

As always I greatly appreciate any direction you can point me to.

CamelleT
QuickBooks Team

OLD TRANSACTIONS SHOWING WHEN RECONCILATION OF CREDIT CARD

Welcome back to the thread. Thank you for taking the time to provide me with a screenshot of the discrepancy message box. With the information you've given me, I'll be able to guide you step by step through the process of resolving this issue and getting past it smoothly. Let's tackle this together, kelper62.

 

First, we can run an Audit Trail or Reconcile Discrepancy report to locate the transactions causing the difference. Here's how:

 

  1. Go to the Reports tab and choose Banking.
  2. Select Reconciliation Discrepancy.

    report.PNG

  3. Pick the Account and hit OK. You'll have a list of transactions that changed since your last reconciliation. Use this report to identify the transaction(s) causing the issue.
  4. If you find a discrepancy, note the transaction date and the Entered/Last Modified, which will tell you when the change occurred.

 

To fix the discrepancy, you may need to reenter or edit the transactions again. Based on the prompt message you received, choose between:

 

 

  1. Click Return to Reconcile.

    return to reconcile.PNG

  2. Ensure to back up your company file.
  3. Select Undo Last Reconciliation.

    Undo recon.PNG

  4. Tap Continue, then OK.

 

 

Select Enter Adjustment to complete the reconciliation process. QuickBooks will automatically create a Journal Entry under a special expense account called Reconciliation Discrepancies. You can check and edit it from your Chart of Accounts.

enter adjustment.PNG

 

The steps I've outlined above are designed to assist you in overcoming the problem in your reconciliation process effectively. By following these instructions carefully, you should be able to navigate through the issue and resolve it with confidence. If you encounter any difficulties along the way or if you have any additional questions related to this matter, please tag me in the comment section below. Your success in resolving this is important, kelper62.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us