Skip to main content

How do I reconcile a phantom AP liability from a broken Bill.com sync?

Compare open bills in your AP aging against actual disbursements on the bank statement. A phantom liability shows up as a bill still open in AP with a matching payment already visible on the bank side, which means the payment posted in Bill.com but its corresponding payment record never synced back to the accounting system, leaving the original bill looking unpaid.

Zuny FesterBy Zuny Fester, Head of Operations and Marketing
Reviewed by Zuny Fester
Published Last reviewed Editorial policy

Part of the month-end close guide.

SymptomA bill shows open in AP; the payment already cleared the bank
Root causePayment record didn't sync back after the bill sync succeeded
Common triggersExpired connection, changed vendor mapping, duplicate record conflict
Where to checkAP aging vs. bank disbursements, reconciled monthly at minimum

How the phantom liability forms

Bill.com and similar AP automation tools record a bill and process its payment, then sync both the bill and the payment back to the accounting system as separate events. If the bill syncs successfully but the payment sync fails — because of an expired connection, a changed vendor mapping, or a duplicate-record conflict — the accounting system only ever receives half the transaction. The bill sits open, showing a liability that's already been paid, and nothing about the vendor relationship looks unusual day to day, because the vendor has, in fact, been paid.

Why this hides until close

Nothing about a phantom liability is visible from the vendor's side or from Bill.com's own records, which show the payment as completed. It only surfaces when someone reconciles the AP subledger against actual bank disbursements — comparing what accounting thinks is still owed against what's actually left the bank account — which for many teams only happens at month-end close rather than continuously.

How to find and fix it

Pull the AP aging report and the bank statement for the same period side by side. For any bill still showing open in AP, check whether a payment to that same vendor, for that same amount, already cleared the bank. If it has, the fix is to manually post the missing payment against the bill in the accounting system, then investigate why the sync failed for that specific record before assuming it won't happen again — a mapping issue that caused one phantom liability will keep causing more until it's corrected at the source.

Next step

Map the finance workflow with the most exposure and prove the automation path.

Bring the invoice, contract, payment reconciliation, or customer finance workflow you have to defend at audit. Loopfour can map the trigger, controls, integrations, and approval loop.

Book a workflow review

Worked example

A $4,200 bill that looks unpaid but isn't

Bill.com processes a $4,200 payment to a vendor on the 15th of the month; the bank statement shows a $4,200 ACH debit that same week. But the accounting system's AP aging still lists the original $4,200 bill as open, because the payment-sync half of that transaction never arrived — a vendor record mapping had changed the week before, and the sync silently failed for any bill tied to that vendor from that point forward. The fix at close: post the missing payment manually against the bill, correct the vendor mapping so future syncs succeed, and specifically check every other bill for that same vendor for the same gap, since a mapping break rarely affects only one transaction.

Frequently Asked Questions

Run the full AP-aging-versus-bank-disbursement comparison across every vendor, not just the one you already found a problem with — a sync configuration change often affects a group of records at once, not a single bill.

No — the bill itself is usually correct; it's the missing payment record that needs to be posted. Deleting the bill would remove a legitimate transaction from your books rather than completing it.

Monthly at minimum, ideally more often for higher AP volume — the longer a phantom liability sits, the more it can compound into month-end close delays.

Sources

Related