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?
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:
Choose Window then Close All.
Verify Data. Choose File then Utilities. Select Verify Data.
Once done, you can now Rebuild Data:
Go to File, Utilities then Rebuild Data.
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.
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.