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:
- AP tool open bills to the AP control account
- Card platform statement to the card liability account
- Payment clearing account to zero, or to a listed timing item
- Reimbursement tool to the employee payable account
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):
- Pulling each tool's export on its cutoff day
- Applying the mapping and flagging any unmapped vendor, account or department
- Tying each tool to its control account
- Cross-tool duplicate and double-coding checks
- Building the exception queue with reason codes and ages
Keep with a person:
- Owning the master lists and approving changes to them
- Setting sync cutoffs and deciding what may bypass a tool
- Clearing each exception with a decision
- Signing off the tie-outs before review
Controls and Audit Trail
- Signed tie-outs. Each tie-out shows preparer, reviewer and date.
- Logged mapping changes. Who changed a mapping, when, and why.
- Locked periods. Close each tool's period after its cutoff, where the tool allows it.
- A queue that can't be edited away. Items close only with a decision and a name.
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