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

Partial Credit Card Payments

OK, here's a messy one.  I took over the bookkeeping and inherited this situation:

 

American Express bill was reconciled in Dec 2014, and a Bill was created for $5,738.37.  (Clearly, this is the start of the situation.  I know not to create a Bill to pay a credit card.)

 

Subsequently, 4 payments were made on that bill in 2015, and the balance on the bill is zero.  Each of those 4 payments was reconciled individually on the bank statements and the credit card statements.  But now, in April 2020, the Bill for $5,738.37 remains uncleared in the AmEx reconciliation.   How do I resolve this?

 

Thanks!

Ann

1 Comment 1
Joseph_A
QuickBooks Team

Partial Credit Card Payments

I'm here to help you out, @NumbersByNelson.

 

Your bill should not be showing on the reconciliation page, It might be a possible data damage on your company file. You can run verify and rebuild data in QuickBooks Desktop.

 

Here's how to Verify Data:

  1. Choose Window then Close All.
  2. Verify Data. Choose File then Utilities. Select Verify Data.

Once done, you can now Rebuild Data:

  1. Go to FileUtilities then Rebuild Data.
  2. A warning message will pop up, press OK. Rebuild requires a company file backup beforehand because in rare cases the process may need to delete transactions or list entries to fix the file.  A backup of your company file will ensure you have a secured copy of your company file before any changes are made to it.
    1. Select where you want to save your backup, then select OK at the bottom of the QuickBooks Desktop Backup window.
      • If a message asks if you want to replace another backup file, select NO. Enter a new name in the File name field and click Save.
      • If the backup fails, select Cancel at the Rebuild prompt and contact Payroll Support for additional assistance.
    2. The Rebuild Data utility starts as soon as the backup is finished.
    3. Click OK when you get the message "Rebuild has completed".

Let me share this article for your guide: Verify and Rebuild Data in QuickBooks Desktop.

 

You can also fix data damage on your QuickBooks Desktop company file.

 

Community is always open for you, take care!

Need to get in touch?

Contact us