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.
Part of the month-end close guide.
| Symptom | A bill shows open in AP; the payment already cleared the bank |
|---|---|
| Root cause | Payment record didn't sync back after the bill sync succeeded |
| Common triggers | Expired connection, changed vendor mapping, duplicate record conflict |
| Where to check | AP 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.
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
Sources
Related
Topic
Month-End Close
Month-end close is the set of accounting tasks a company runs after a calendar month ends to turn raw transactions into a finished, trustworthy set of financial statements: reconciling subledgers, boo…
Read moreDiagnostic
What causes a currency delta that won't eliminate in intercompany close?
Almost always, currency revaluation either didn't run before elimination, used a stale exchange rate, or the elimination subsidiary's consolidated exchange rate isn't set to 1 relative to its direct parent. Any of these leaves the two sides of an intercompany balance valued at different rates, so they can't net to exactly zero.
Read moreDiagnostic
How do I shorten the close when AP reconciliation is the bottleneck?
Move AP-to-bank reconciliation to a rolling, weekly cadence instead of a single close-week event, so most of the matching work is already done by the time the period ends. Most AP bottlenecks at close aren't caused by close-week work itself — they're a backlog of sync gaps and unmatched payments that accumulated all month and only get discovered when someone finally looks.
Read more