Skip to main content
D
DStru
February 16, 2025
Solved

Help to correct old credit card account payments that were accidentally deleted...

  • February 16, 2025
  • 1 reply
  • 0 views

Hello - several old (previously reconciled) payments made to my credit card account were accidentally deleted in quickbooks desktop.  Now, when I try to reconcile the cc account, the balance is incorrect.  Of course, I'm not really sure how this happened.  Can anyone give me the steps necessary to correct this type of error?  Since it's a payment transaction, I'm not finding clear instructions on how to correct it.  Thank you, - Donna

Best answer by GenmarieM

I'd be glad to help you re-enter your deleted credit card payments to reconcile your credit card account in QuickBooks Desktop (QBDT), DStru.

 

First off, you'll need to run an Audit Trail report to find details of the deleted transactions. You can customize and filter the report to locate the specific payment transaction you're looking for.

 

Here's how:

 

  1. Click Reports at the top menu bar and choose Account & Taxes.
  2. Select Audit Trail.

  3. On the report screen, click Customize Report.
  4. Go to the Filter tab and search for Transaction Type.
  5. Choose Credit Card and hit OK.

 

Next, re-enter the payment transactions by carefully using the details from the audit trail. Ensure that all relevant details, such as transaction amounts, dates, and payee information, are verified to secure accuracy. Once you have accurately re-entered all transactions, proceed to do a mini reconciliation.

 

Additionally, you can visit this article for your reference if you want to get a report from your previous reconciliation: Get reports for previous reconciliations in QuickBooks Desktop.

 

Let us know if you have other concerns regarding your deleted credit card payment transactions in QBDT. We'll get back to lend a helping hand.

1 reply

G
GenmarieMAnswer
February 17, 2025

I'd be glad to help you re-enter your deleted credit card payments to reconcile your credit card account in QuickBooks Desktop (QBDT), DStru.

 

First off, you'll need to run an Audit Trail report to find details of the deleted transactions. You can customize and filter the report to locate the specific payment transaction you're looking for.

 

Here's how:

 

  1. Click Reports at the top menu bar and choose Account & Taxes.
  2. Select Audit Trail.

  3. On the report screen, click Customize Report.
  4. Go to the Filter tab and search for Transaction Type.
  5. Choose Credit Card and hit OK.

 

Next, re-enter the payment transactions by carefully using the details from the audit trail. Ensure that all relevant details, such as transaction amounts, dates, and payee information, are verified to secure accuracy. Once you have accurately re-entered all transactions, proceed to do a mini reconciliation.

 

Additionally, you can visit this article for your reference if you want to get a report from your previous reconciliation: Get reports for previous reconciliations in QuickBooks Desktop.

 

Let us know if you have other concerns regarding your deleted credit card payment transactions in QBDT. We'll get back to lend a helping hand.

    D
    DStruAuthor
    February 17, 2025

    Thank you for your response.  I'm afraid that undoing my last reconciliation would not help in this situation.  The transactions deleted were very old and previously reconciled.  They will need to be added back without causing additional unintended errors.  Apparently, the transactions were deleted because, even though completed, they remained visible on the reconcile page.  So to "clean up", I thought they could just be deleted. I understand now that this was not the correct way to fix the problem.  😞

     

    I have attached a 2-page pdf showing the Reconcile Discrepancy Report and the Audit Trail.  Are you able to review it and recommend a strategy for correcting the 6 deletion errors?  Thank you again for your assistance.

    S
    Sherrie_F
    February 17, 2025

    I deeply appreciate the effort you've taken to provide all the necessary information, @DStru. I get how unsettling it can be when previous reconciliations are disrupted by unexpected deletions. It's clear from your update that these transactions were crucial in maintaining the accuracy of your financial records, and their deletion wasn't anticipated. Let's work together to address this issue and restore the integrity of your records.

     

    In QuickBooks Desktop (QBDT), we can perform a mini reconciliation to ensure that the re-entered transactions align perfectly with your past statements and that your books are balanced.

     

    To do so, here's how:

     

    1. On the upper navigational panel, look for the Banking tab.
    2. Select Reconcile.
    3. Choose the credit card account with the transactions you need to reconcile.
    4. In the Statement Date field, enter the date for an "off-cycle reconciliation." This date can be between your last reconciliation and the next scheduled one. Note: 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 they follow.
    5. Enter the balance of your last successful reconciliation in the Ending Balance field. Then, select Continue.
    6. In the Reconcile window, check off the transactions you are fixing and re-reconciling.
    7. Ensure the Difference field shows $0.00.
    8. When everything looks good, click Reconcile Now.

     

    Once you select Reconcile Now, QuickBooks asks if you want to Create a Payment Check or a Bill to Pay Later:

     

    1. Select Create a Bill to Pay later.
    2. If you need to, print your Reconciliation Report for your records.
    3. After you print the report, a bill appears on the screen. The bill amount will be the balance you just reconciled.
    4. Click Clear to remove all info from the bill.
    5. Close the bill

     

    By following these steps, QuickBooks won't create a bill, so your credit card balance isn't affected. This process will also be able to amend the discrepancies caused by deleted transactions and strengthen your financial processes against similar incidents.

     

    For more details about the process, you can check this out: Reconcile previously deleted and re-entered checking or credit card transactions.

     

    Additionally, to make sure that your transactions are correct, you can browse through this article to check your accounts and get them ready for the end of the year: Year-end guide for QuickBooks Desktop.

     

    It is my priority to assist you in this time of need, @DStru. Keeping your accounts in perfect alignment is crucial, and I'm here to ensure that happens. Please feel free to reach out if you require further details on any of the steps or need additional assistance. Your diligence in maintaining accurate financial records is commendable, and I'm committed to supporting you in resolving this issue effectively and efficiently.

      Terms & ConditionsAccessibility statement