FluxWorkflowsArticlesContact us
Reconciliations

AP Automation, Expense Cards and an AI Add-On: Why the Close Still Doesn't Tie Out

Flux Team · Updated 2026-11-03 · Workflow: Reconciliations

Because each tool reconciles itself, and nobody reconciles the tools to each other. The AP tool agrees with its bills. The card platform agrees with its statement. The AI add-on agrees with whatever it was shown. One close that ties out takes four pieces of plumbing: defined handoffs, one mapping, a tie-out per control account, and one exception queue.

Doesn't Each Tool Already Reconcile?

Inside its own walls, yes.

BILL syncs each payment into what it calls "a special account," the Bill.com Money Out Clearing account. That account nets to zero once the lump-sum bank withdrawal posts (BILL). Ramp's reconciliation report for QuickBooks Online compares Ramp's totals with your QBO balance. It flags transactions not synced and QBO entries with no match in Ramp (Ramp).

Both are useful. Each answers one question: does this tool agree with the ledger? The cross-tool questions are still yours. Was the vendor paid through AP also paid on a card? We made the case for why another tool won't fix that in Why ChatGPT Plus Another Close Tool Won't Shorten Your Close. This piece is about the fix.

How Much Does the Number of Systems Matter?

A lot. Vena, an FP&A software vendor, surveyed 624 US finance and accounting professionals in August 2026 (Vena).

Systems the close pulls from Had to correct numbers after the close, past year Half or more of the close spent on manual consolidation
1 to 2 57% Not reported
3 to 4 Not reported 15%
7 to 8 92% 52%

The same survey found 37% of teams still source data from email or shared documents. It's a vendor survey, but the direction is clear. Every tool you add is another handoff to check.

What Does Each Tool Hand the Close?

The last column is our view, not a vendor claim.

Tool What it hands the close What it can't see
AP automation Approved bills, payment runs, a clearing account Card spend, goods received but not billed, bills keyed straight into the ledger
Expense card platform Coded charges, receipts, the statement AP bills to the same vendor, accruals
AI add-on (coding, matching or chat) Suggested codes, proposed matches, summaries Anything outside the tool it runs in
Ledger The trial balance Why any balance is what it is

What Does Joining Them Into One Close Take?

Four layers, built in this order.

1. Define the Handoffs

For each tool, write down what posts to the ledger, when, to which accounts, and under which date. Three dates matter: the transaction date, the sync date and the accounting date. If they differ, cutoff moves items between months.

Ramp's report shows the problem: a transaction recorded in one month but synced in another shows a placeholder in both months for review (Ramp).

Set a sync cutoff per tool. We suggest business day 2 for card sync, with the period locked after it. Decide whether anyone may key a bill straight into the ledger. If they may, it needs its own list.

2. Build One Mapping

Keep one master list each for vendors, GL accounts, departments and entities. Every tool maps to it. Here is what an unmapped stack looks like for one vendor.

Field AP tool Card platform Ledger What breaks
Vendor Northwind Freight Inc. NORTHWIND FRT*4471 Vendor 1042 and Vendor 1187 The duplicate check can't see both payments
GL account 5100 Freight In 6420 Shipping Both exist One cost split across two P&L lines
Department Ops Operations Class 200 The department P&L under-reports
Date used Invoice date Transaction date Sync date Cutoff shifts items between months

3. Tie Each Tool to Its Control Account

Before review, every month:

Then run the cross-tool checks. Same vendor and amount paid through AP and on a card. Same cost coded to two accounts. An accrual booked for a bill that AP already holds.

4. Run One Exception Queue

Every break from steps 1 to 3 lands in one list. Not five tools' notification feeds. Each line has a source tool, amount, reason code, owner and age.

Reason codes keep it honest: not synced, unmapped, timing, duplicate, entered outside the tool. Review works the queue oldest first.

What It Looks Like

Figures are illustrative.

A US$35M services company runs an AP tool, an expense card platform and QuickBooks Online. Here is its October tie-out before review.

Control account Should be (US$) GL shows (US$) Difference (US$) Cause Reason code
AP control 284,600 291,350 6,750 A bill keyed straight into the ledger, not in the AP tool Entered outside the tool
Card liability 48,220 46,980 1,240 Three October charges synced on November 2 Not synced
Payment clearing 0 3,900 credit 3,900 October 30 payment run; bank withdrawal posted November 2 Timing
Employee payable 615 0 615 Reimbursement approved, never synced Not synced

The cross-tool check adds one more line. Northwind Freight was paid US$2,180 through AP on October 9 and again on a card on October 12. It's the same invoice, under two vendor records.

Three of the five items change October's P&L: US$1,855 of missing expense and a US$2,180 duplicate. The US$6,750 bill is booked correctly but belongs in the AP tool too, or nothing will match it later. The clearing balance is timing, noted on the rec until November 2 clears it.

What to Automate vs Keep With a Person

Automate (calculate or flag):

Keep with a person:

Controls and Audit Trail

At year-end you hand the auditor four signed tie-outs instead of rebuilding them in January.

How Flux Runs This

We embed with your team and learn how your tools really hand off to each other, including what nobody wrote down. Which bills get keyed straight into the ledger. Which vendor only takes a card. Which day the sync actually runs.

Then we run your bank, card and balance sheet recs every period, including clearing accounts and AP against its aging. Matching and balances are calculated in code, and every rec ties to its GL balance and the trial balance before any words are written. AI reads bank memos and card descriptions to propose matches and coding. It never does the math, and it never clears a break.

Anything the files can't explain becomes a flagged question, with a note on what we checked. "US$6,750 bill in the ledger but not in the AP tool" goes to a person. It doesn't get netted away.

Your team reviews, signs off and makes the coding calls. Every correction is kept, so a break explained once doesn't come back next month.

We work from files you export, with no system access. A mutual NDA is signed before any files are shared. It gets cheaper for us each month, and you see that as a close that ties the first time.

FAQ

Why doesn't our AP automation tie to the general ledger? Look for two causes first: bills keyed straight into the ledger, and syncs that landed in a different period. Tie the tool's open bills to AP control monthly and list every difference.

What is a clearing account in AP automation? A holding account for individual payments until the lump-sum bank withdrawal posts. It should net to zero. BILL's is called Bill.com Money Out Clearing.

Do we need an integration platform to connect our tools? Not to start. Exports on a fixed day, one mapping table, a tie-out per control account and one exception queue can get a close to tie out.

Who should own the exception queue? One person owns the queue and every line has its own owner. The queue owner makes sure nothing ages without a decision.

If your tools all sync but the close still won't tie out, send us a period you've already closed. We'll run your bank, card and balance sheet recs free, with every break in one list. Compare them line by line with your own. See how we run reconciliations.

Contact us