CYBER MONDAY SALE 70% OFF QuickBooks for 3 months*   Ends 12/5

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
DStru
Level 2

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

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

Solved
Best answer February 23, 2025

Best Answers
GenmarieM
QuickBooks Team

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

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.
    SS1.png
  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.
    SS2.png

 

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.

View solution in original post

Bryan_M
QuickBooks Team

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

I'm glad to hear that my colleague's suggestions worked perfectly on your end, @DStru. To clear the re-entered bill, you'll need to link it to the payment you reconciled. However, this will be based on how you recreate the payment transaction. Allow me to impart this information to you.

If you recreated the payment via check and performed a mini-reconciliation before re-entering the bill. You'll need to ensure that the account used is Accounts Payable below the Expenses.
 

After that, since you have already re-entered the bills indicating what item you paid to your vendor, you'll have to utilize the Pay Bills feature to apply for the credits/check/bill payment by clicking the Set Credits button shown below the Select Bills to be Paid window to offset what you reconcile and avoid discrepancies. Here's how:

  1. Choose Pay Bills from the Vendors tab.
  2. Tick the box beside the correct vendor and click the Set Credits tab below.
    3.png
  3. Select Done from the shown prompt.
    2.png
  4. After that, click on Pay Selected Bills to save the transaction.

Yet, if you recreated the payment transaction in different way, feel free to share it with us so we can provide the exact steps to clear the re-entered bills.

Moreover, you can visit this article to view your vendor and payables transactions by pulling up a report: Customize vendor reports.

Feel free to return here if you have additional questions about clearing the open bill in your account. We'll ensure to help you right away. Take care, and have a good one.

View solution in original post

7 Comments 7
GenmarieM
QuickBooks Team

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

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.
    SS1.png
  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.
    SS2.png

 

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.

DStru
Level 2

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

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.

Sherrie_F
QuickBooks Team

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

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.

DStru
Level 2

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

Hi GenmarieM and Sherrie_F. 

Adding back the deleted payment transactions and doing the mini reconciliation worked perfectly!  I was able to balance the account and then complete the next month's reconciliation without an issue! 

One last thing to ask...  The re-entered bills remain open in the 'Pay Bills' window (see the attached screen shot).  Is there any way to get rid of them?  I'm afraid to do anything that may cause new problems.  Let me know if there is a solution for removing these. 

 

Again, so grateful for your help with getting my account balanced!  Thank you,  DStru

Bryan_M
QuickBooks Team

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

I'm glad to hear that my colleague's suggestions worked perfectly on your end, @DStru. To clear the re-entered bill, you'll need to link it to the payment you reconciled. However, this will be based on how you recreate the payment transaction. Allow me to impart this information to you.

If you recreated the payment via check and performed a mini-reconciliation before re-entering the bill. You'll need to ensure that the account used is Accounts Payable below the Expenses.
 

After that, since you have already re-entered the bills indicating what item you paid to your vendor, you'll have to utilize the Pay Bills feature to apply for the credits/check/bill payment by clicking the Set Credits button shown below the Select Bills to be Paid window to offset what you reconcile and avoid discrepancies. Here's how:

  1. Choose Pay Bills from the Vendors tab.
  2. Tick the box beside the correct vendor and click the Set Credits tab below.
    3.png
  3. Select Done from the shown prompt.
    2.png
  4. After that, click on Pay Selected Bills to save the transaction.

Yet, if you recreated the payment transaction in different way, feel free to share it with us so we can provide the exact steps to clear the re-entered bills.

Moreover, you can visit this article to view your vendor and payables transactions by pulling up a report: Customize vendor reports.

Feel free to return here if you have additional questions about clearing the open bill in your account. We'll ensure to help you right away. Take care, and have a good one.
DStru
Level 2

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

Hi Bryan_M,

Sorry for the late response...  Thanks for helping me clean up the left-over issues from my mini-reconciliation. I was so glad to get the old bills re-entered and reconciled that I was ready to let them sit unresolved forever.  But your solution worked flawlessly and everything has been cleaned up!

I was panicking because I had no idea how to correct the old deleted payments.  I really can't tell you how much I appreciate the detailed assistance from you and your team!  Thank you so much! 

KayePe
QuickBooks Team

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

You're very much welcome, @DStru
 
We're delighted to see that the support provided by my colleague Brayn successfully resolved your mini-reconciliation issue. It gives us great pleasure to see our customers happy with our service.
 
Should you need additional assistance with clearing an open bill in your account, or if you have other concerns related to QuickBooks Desktop, please revisit the Community. We’re here to help. Wishing you well and looking forward to assisting you again!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us