I talk to people almost every day who report that a bunch of paid vendor bills or paid customer invoices have spontaneously become unpaid. This throws off balances for AR and/or AP, and it makes vendor or customer balances and agings incorrect.
The payments are still in the file, but they are no longer being correctly applied to the original transactions.
This problem is tough because it is usually not easily fixable. There are two solutions:
- Restore the last good backup that was made before the paid transactions became unpaid. Then run the Verify Data command on the company. If it verifies OK, then rekey from there to get caught up. If verify fails, then get your data repaired, and then rekey transactions to get caught up.
- For each bill or invoice that has gotten unpaid, edit each of the associated payments. Uncheck the bill or invoice that the payment is being applied to and save. Then edit the payment again and check the bill or invoice. Save. See if the bill or invoice shows as paid. If not, then delete the payment and reenter it from scratch. This technique can be effective if there are not too many transactions to fix.
CAUSE: This problem is caused when there is link damage in the file. But then the problem gets worse — paid transactions get unpaid — when the Rebuild Data command is run. It also happens sometimes when people upgrade a damaged QuickBooks file to a newer version.
ACTION POINT: When you upgrade to a new version, or if you have to run the Rebuild Data command on your company, make sure you look at a before-and-after version of your AR and AP aging reports. Make sure they are the same before and after. That’s the easiest way I know to detect when paid transactions incorrectly become unpaid.
If the problem occurs during a version upgrade or during Rebuild Data, contact us to see if the file can be repaired. Note: We can only repair a pre-rebuilt copy of the file. Once the Rebuild Data command has further corrupted the file, we can no longer repair it.
Have you ever seen this problem? How did you recover from it?