Unapplied Payments After a QuickBooks Rebuild: The Right Backup to Restore

A Rebuild can leave QuickBooks payments unapplied while invoices and bills reopen; here is how to get every payment link back intact.

A Rebuild is supposed to repair a damaged company file. Sometimes it leaves a new problem behind: payments that were applied to invoices and bills now sit as credits, and the documents they settled show open balances again. Our engineers see this pattern often. The payments usually survive inside the file. What breaks is the link between a payment and the invoice or bill it paid. The backup you choose next decides whether that linking comes back.

Why do payments come off their invoices after a Rebuild?

Rebuild rewrites transaction chains it judges to be damaged. When it cannot reconstruct the tie between a payment and the document it settled, it keeps both records and drops the tie. The books still balance. The reports are what lie.

An Open Invoices report lists invoices you know were paid. An unpaid bills report shows balances on bills whose payments cleared long ago. Receivable and payable totals inflate, because the unapplied payments sit on the other side of each date.

Open one of the payments from its register. The amount and date are intact. The invoice is there too, carrying a balance. Nothing was deleted; the two records simply no longer point at each other. That is also why running Rebuild again rarely helps. The tool that dropped the link is the one you would be asking to restore it.

The copy that matters is the one made before the Rebuild ran, not the newest one. QuickBooks asks you to back up before a Rebuild starts, and that copy captures the file while every payment was still applied. A backup taken afterwards preserves the broken state, because the missing links are now part of the data.

To find it, compare the dates and times on your backup files with the day the Rebuild ran. Check the folder QuickBooks uses for scheduled backups, copies on a server or with an outside provider, and any copy your accountant holds. Also look for the QuickBooks Auto Data Recovery folder beside the company file, which can hold an automatic copy from before the trouble began. The backup you want is the newest one stamped before the Rebuild.

How do you confirm the backup is the right one?

Set the groundwork first. Put a copy of the current company file, its .TLG transaction log, and every backup candidate somewhere safe. Work only on copies, and open QuickBooks in single-user mode while you test. That way nobody posts entries into a file you may discard. Hold off on further Rebuild attempts until the question is settled.

  1. Restore the candidate backup into a new folder, under a working name you will recognize. Never let it overwrite the live file.
  2. Open the restored copy in single-user mode.
  3. Run the Open Invoices report under Customers and Receivables, dated to the last day before the Rebuild. Invoices you know were paid should not appear.
  4. Run the Unpaid Bills Detail report under Vendors and Payables with the same date. Settled bills should be absent as well.
  5. Open a payment in the Receive Payments window and confirm it shows applied to its invoice. Repeat the check in the Pay Bills window for a bill payment.
  6. Compare receivable and payable balances on the balance sheet with your most recent month-end reports. The totals should agree.

What if no pre-Rebuild backup exists?

Then the company file and its .TLG transaction log become the recovery pair. The log file sits beside the company file and records its transaction activity. Paired with the most recent usable backup, it gives a repair engineer raw material that no after-the-fact copy contains. Keep the two files together from now on. Copy them as a set, rename neither, and stop opening and closing the damaged file while you decide. Our QuickBooks TLG transaction log recovery service covers what that route can rebuild.

The limits of this recovery

Restoring the pre-Rebuild backup returns the books to the moment that copy was made. Anything entered between the backup and the Rebuild has to be re-entered by hand. The gap is usually hours or days rather than months, but count it before you commit.

Recovery from the file and log depends on what the log captured and how deep the original damage ran. If the corruption that triggered the Rebuild sat below the payment links, repair may have to restore to a point before the damage began. That cutoff is weighed before work starts, not after. Our engineers treat repeated Verify and Rebuild failures as a whole-chain problem rather than a linking one; see the QuickBooks Verify and Rebuild repair service page for that scenario.

The Open Invoices report lists only invoices that are genuinely open. Bill payments show as applied in the Pay Bills window. Customer and vendor balances in their centers match your statements. Receivable and payable totals agree with the period-end reports you closed before the Rebuild. When all four checks pass on the restored copy, move the books onto it, then re-enter the gap.

Keep going

Your Desktop doesn’t have to end when Intuit says so.

Start with the master survival guide, or jump straight to the fix you need.