Bank reconciliation without access to the client's accounting system
A full month of books can be reconciled from three exported files — a bank statement, a credit-card statement, and a ledger export — with no login, no OAuth, and no integration. The workflow matches entries in both directions, reports every item that did not match and why, and proves both accounts tie to zero once the flagged adjustments are made. It flags; it never silently fixes.
Why "no access" is the point, not a limitation
Most bookkeeping tools open the relationship by asking for live account access. For a prospect who has not worked with you yet, that is a large trust request to make before any value has been demonstrated — and for a CPA evaluating a tool against client data, it is often the reason the evaluation stops.
Starting from exports inverts that. Three files in, a reconciliation out. The client emails what they already have. Nothing is connected, nothing is granted, and the work speaks before any access is negotiated.
What you need
- Bank statement for the period
- Credit-card statement for the same period
- A ledger export covering both
How the matching works
The matching is deterministic, not a language-model guess. Ledger entries are matched to statement lines on amount and date, and the check runs in both directions — ledger to statement and statement to ledger. A one-way match finds entries you recorded that the bank never saw; the reverse pass finds bank activity that never reached your books. You need both to explain a difference.
The exceptions are the deliverable
Matched items are the boring part. What you are paying for is the list of what did not match, sorted into categories that tell you what to do:
- Deposits in transit — recorded, not yet cleared
- Ledger entries missing from the bank — recorded, never happened, or happened differently
- Bank fees nobody booked — happened, never recorded
It doesn't fix your books behind your back — it hands you the fix list. That distinction is the whole trust model. An automated reconciliation that quietly adjusts entries is not a time-saver, it's an unreviewed journal entry with extra steps.
The tie-out
After the flagged adjustments, both the checking and credit-card summaries land on $0.00. Every number traces back to a source line, so the reconciliation is reviewable by someone who was not in the room when it ran — which is the actual standard for workpaper-grade output.
Does this hold up on real work?
It is already the proof point in live engagements. One construction client reconciliation ran 93 ledger checks with same-day turnaround — the recon delivered before the follow-up call, from files sent that morning.
Common questions
Can you reconcile a bank account without access to QuickBooks?
Yes. The reconciliation runs on three exported files: a bank statement, a credit-card statement, and a ledger export. No login, no OAuth connection, and no integration with the accounting system is required. This matters because most bookkeeping tools begin by asking for live account access, which is a high-trust request to make of a new client before any work has been proven.
What files do you need to run a bank reconciliation?
Three: the bank statement, the credit-card statement, and a ledger export covering the same period. All three are things a client can send by email in a few minutes. Nothing else is needed, and no credentials change hands.
Does the AI fix my books automatically?
No. It flags, it never silently fixes. The output is a list of exceptions — deposits in transit, ledger entries missing from the bank, fees nobody booked — with each one explained. You decide what gets adjusted. Nothing is written back to the accounting system by the workflow itself.
How does the reconciliation handle deposits in transit and outstanding items?
They are surfaced as named exceptions rather than treated as errors. The workflow matches ledger entries to statement lines in both directions on amount and date, then reports what did not match and why. Deposits in transit, unbooked bank fees, and ledger entries with no bank counterpart each appear as their own category, so the difference between the raw balances is fully explained before you adjust anything.
Want to test this on your own close?
Send three files from a month you have already closed and compare the exception list to what you found by hand. Scoped, fixed-fee, and you own what gets built.
Book a call