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:

  1. 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.
  2. 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?

Please follow and like us:

4 thoughts on “Help! Some Paid Bills and Invoices Have Gotten Unpaid!

  1. This solution is ok if you are using Quickbooks Desktop which I use to have before migrating to Quickbooks Online. One of the major worries about QB Online is there is no option for a backup. It would be useful to be able to back up onto my local hard disk just in case there is an outage online, or to provide such a restore should the need arise.

    • Hi David,

      Yes, the whole thing is different in QB Online. The problem that my blog post describes shouldn’t ever happen in QB Online — the coding is all different and there is not much association between problems in Desktop and Online. In a sense, your data in QB Online is always being backed up. That is transparent to the user. The downside (to me, anyway) is that you can’t roll back to a prior version of your data. All you’ve got is your current stuff.

      Thanks for your comment.

  2. David and Shannon, the lack of backup, or rollback, as Shannon called it, is one of my pet peeves with QBO. I brought this up a few times with Intuit and their big supporters, and they never seemed to understand what my issue was. However, I believe that there is a third party app now that can give you this capacity.


Leave a reply

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>