Balance Sheet Reconciliation Software: Automated Balance Sheet Reconciliation and Account Substantiation
Reconciler connects your bank accounts, corporate cards, payment processors, and ledger read-only, then substantiates the balance sheet accounts that move the most: cash, credit cards, clearing, suspense, and processor receivables. You get a supported balance and a short list of what does not tie, with a reason on every line.
Read-only ยท Never moves money
In short
Balance sheet reconciliation software substantiates each balance sheet account during the close: it proves that the balance in the general ledger is supported by real detail rather than simply carried forward. The software pulls the supporting source, such as a bank statement, card feed, processor payout file, or subledger, matches it against the ledger balance, and surfaces the unexplained difference. Reconciler does this for the transaction-backed accounts that generate most of the work: cash, corporate cards, clearing and suspense, undeposited funds, and processor receivables. It connects read-only, explains every match in plain English, never posts a journal entry, and never moves money. Pricing starts at $49 per month.
Last updated July 2026
Substantiates against the ledger you already run
What it does
What balance sheet reconciliation software has to prove
A supported balance, not just a number
The point of a balance sheet reconciliation is evidence. For every account it covers, Reconciler shows the ledger balance, the supporting activity behind it, and the difference between them, with each matched item traceable back to the source line it came from. A reviewer can see what the balance is made of instead of taking the total on faith.
Clearing and suspense accounts
Clearing accounts are where balance sheets quietly go wrong. They are supposed to return to zero and they rarely do, because one side of a pair posted and the other did not. Matching both sides of the clearing account surfaces the orphaned entries by name and date, which is the difference between a five minute fix and a quarter of accumulated residue.
Processor receivables and undeposited funds
Stripe, PayPal, and Square pay out net of fees and refunds, days after the sale. That gap sits on your balance sheet as a receivable or in undeposited funds, and it is one of the hardest balances to prove. Reconciler breaks the payout into its gross activity and ties it to the ledger so the balance has a real composition behind it.
Aging on the reconciling items
A reconciling item is only acceptable while it is young. Reconciler tracks how long each unreconciled item has been sitting, so a stale outstanding check or a six month old clearing entry shows its age instead of being copied into next month's workpaper the way a spreadsheet lets you do without noticing.
Prepared once, reviewable by someone else
Because every match carries a plain-English reason, a second person can review the reconciliation without redoing it. That matters for the control itself. A reconciliation that only the preparer can understand is not really reviewed, and it is the first thing an auditor probes when they ask who signed off and on what basis.
Read-only, and it never posts
Reconciler connects to your banks, cards, processors, and ledger read-only. It cannot move money, and it does not write journal entries. Corrections are made by a person, in the ledger, where they belong. The record of what was matched and why stays attached to the period you closed.
Be honest about it
Which balance sheet accounts automate, and which still need a person
Reconciler is a matching engine, so it earns its keep on the accounts with transaction volume behind them. Schedule-driven accounts are still a human job, and any vendor telling you otherwise has not closed a set of books.
| Balance sheet account | Supporting source | With Reconciler | Why |
|---|---|---|---|
| Cash and operating bank accounts | Bank statement or feed | Automated | High volume, unambiguous matching. This is the clearest win. |
| Corporate and credit cards | Card feed and statement | Automated | Same shape as cash, plus coding questions on the expense side. |
| Clearing and suspense accounts | Both sides of the ledger | Automated | Should net to zero. Matching finds the entry whose pair never posted. |
| Undeposited funds | Deposit batches and bank credits | Automated | Usually the batch grouping, not the amounts, that breaks it. |
| Processor receivables (Stripe, PayPal, Square) | Payout and transaction files | Automated | Requires splitting a net payout into gross, fees, and refunds. |
| Accounts receivable and accounts payable | AR and AP subledger | Partly automated | The subledger to ledger tie is mechanical. The aging judgment is not. |
| Prepaid expenses and accruals | Amortization or accrual schedule | Manual schedule | A rollforward driven by policy. Reconciler does not build it for you. |
| Fixed assets and accumulated depreciation | Fixed asset register | Manual schedule | Register-driven. Belongs in a fixed asset system, not a matching engine. |
| Equity, debt, and deferred revenue | Agreements and amortization schedules | Manual schedule | Document-driven balances that a person has to interpret. |
If what you need is a certification workflow across every account on the balance sheet, with rollforward schedules and a formal sign-off matrix, that is close-management territory. Compare those platforms on our best account reconciliation software roundup, or read how we stack up against Trintech, BlackLine, and HighRadius.
How it works
From connected sources to a substantiated balance
Connect the accounts and the ledger
Link bank accounts, corporate cards, and payment processors alongside QuickBooks, Xero, NetSuite, Sage Intacct, or Business Central. Nothing migrates and nothing changes about how you post. You are connecting sources, not rebuilding your chart of accounts.
Pick the accounts to substantiate
Choose the balance sheet accounts you want covered: operating cash, corporate cards, clearing and suspense, undeposited funds, processor receivables. These are the accounts with transaction volume behind them, which is where automated matching earns its keep.
Let it match and expose the difference
Reconciler pulls the supporting activity and the ledger side for the period and matches them. What comes back is the ledger balance, the supported portion, and the unexplained difference broken into named items rather than one number you have to go hunting inside.
Review, correct, and close
A reviewer works the exception list, decides what each item is, and posts any corrections in the ledger. Once the difference is explained or cleared, the account is substantiated and the evidence for it stays with the period.
The actual work
What a balance sheet reconciliation is really proving
Balance sheet reconciliation vs bank reconciliation
A bank reconciliation compares one account, your cash balance in the ledger, against one external source, the bank statement. A balance sheet reconciliation is the wider discipline: every account on the balance sheet gets tied to whatever supports it, which might be a statement, a subledger, an amortization schedule, a contract, or a physical count. Bank reconciliation is one line item inside that program, and it is usually the first one a team automates because it has the most transactions and the least judgment. The accounts that cause real trouble are the ones nobody assigned to anyone: the clearing account, the old suspense balance, the payroll liability that has been slightly off since a system migration.
Substantiation means evidence, not agreement with another number
Two systems agreeing is not proof. A balance is substantiated when you can show what it is composed of and why each component belongs there. A prepaid balance of $48,000 is substantiated by a schedule listing each policy, its term, and the unamortized portion, not by the fact that the number matches last month plus the entry you made. This distinction is what auditors test, and it is why reconciliation software that only reports a match percentage is not enough on its own. The useful output is the composition of the balance and a named reason for every item that does not fit.
Which accounts to reconcile, and how often
Frequency should follow risk and volume rather than habit. High-volume accounts where errors hide easily, cash, cards, clearing, suspense, and processor receivables, deserve at least monthly attention and are worth doing weekly once matching is automated. Subledger accounts like AR and AP tie out monthly. Schedule-driven accounts such as prepaids, accruals, debt, and fixed assets can be quarterly if the underlying policy is stable and nothing unusual happened. The mistake is treating every account with the same cadence, which spends the same effort on a dormant equity account as on the clearing account that eats an afternoon.
Clearing and suspense: where the balance sheet actually breaks
A clearing account exists to hold one half of a transaction while the other half catches up, which means a healthy one returns to zero. When it does not, some entry went in and its counterpart never arrived, usually because an integration failed silently or a batch posted twice. The balance looks small and stable, so it survives review after review, and by the time someone investigates it is a year of unrelated items stacked on top of each other. Matching both sides against each other, rather than eyeballing the ending balance, is what separates the items and shows the date each one landed. Worth knowing the distinction too: a clearing account holds a transaction you expect to clear a specific way, while a suspense account holds one nobody has classified yet, and they fail for different reasons and get fixed differently.
Preparer and reviewer are supposed to be different people
The control value of a reconciliation comes from someone independent checking it. In practice, in a small finance team, the person who prepared the reconciliation is often the person who approves it, which quietly removes the control the process was there to provide. Software does not solve segregation of duties by itself, but it does make an independent review affordable: when every match carries the reason it was made, a reviewer can check the logic in minutes rather than re-performing the whole tie-out, and the review is recorded rather than remembered.
Where the Excel template stops working
A balance sheet reconciliation template in Excel is a perfectly good starting point, and plenty of businesses never need more than that. It starts failing on three fronts. Volume, because ticking a thousand transactions a month by hand is not a use of an accountant. Carry-forward, because last month's workpaper gets copied and the stale items ride along invisibly. And evidence, because a spreadsheet preserves the answer but not the reasoning, so when someone asks in October why the September balance was accepted, nobody can reconstruct it. Software is worth buying at the point where those three problems cost more than the license.
For the manual process account by account, see our guide to balance sheet reconciliation. Cash specifically is covered on our bank reconciliation software page, and the wider ledger tie-out in general ledger reconciliation. If a specific account will not tie, common causes of reconciliation discrepancies works through them one at a time, and the month end close checklist puts the reconciliations in sequence with the rest of the close. The two accounts that cause the most trouble here get their own guide: clearing account vs suspense account covers why a clearing account never zeroes out and how to reconcile one without an external statement to agree it to. If you are pricing this work, account reconciliation software pricing compares what every vendor in the category publishes.
Who buys it
Teams that reach for balance sheet reconciliation software
Questions people ask
Balance sheet reconciliation, answered
What is balance sheet reconciliation?
Balance sheet reconciliation is the process of proving that each balance sheet account in the general ledger is supported by real detail. You compare the ledger balance to its supporting source, such as a bank statement, subledger, or amortization schedule, then explain or correct any difference. It is normally done as part of the month-end close.
What is balance sheet reconciliation software?
Balance sheet reconciliation software automates the comparison between a ledger balance and its supporting detail. It pulls the source data, matches it against the ledger, tracks the age of unreconciled items, and records who prepared and reviewed each account. The result is a substantiated balance with a short exception list instead of a spreadsheet workpaper.
What is the difference between balance sheet reconciliation and bank reconciliation?
Bank reconciliation covers one account, cash, against one source, the bank statement. Balance sheet reconciliation covers every account on the balance sheet against whatever supports it, including subledgers, schedules, and contracts. Bank reconciliation is a single component of a balance sheet reconciliation program, and usually the first one a team automates.
Which balance sheet accounts should be reconciled monthly?
Reconcile monthly anything with transaction volume or error risk: cash, corporate cards, clearing and suspense accounts, undeposited funds, processor receivables, AR, AP, and payroll liabilities. Schedule-driven accounts such as prepaids, accruals, fixed assets, and debt can often move to quarterly if the underlying policy is stable and nothing unusual happened in the period.
What is account substantiation?
Account substantiation is showing what a balance is made of, not just showing that it matches another figure. A substantiated balance comes with the detail behind it: the individual items, their dates, and why each belongs in the account. Auditors test substantiation because two systems agreeing can still both be wrong in the same way.
How do you do a balance sheet reconciliation in Excel?
List the ledger balance at the top, list the supporting detail below it, and reconcile the two with named adjusting items so the difference lands at zero. Keep one tab per account, date every reconciling item, and record who reviewed it. The method works. It stops scaling once transaction volume makes manual ticking the bottleneck.
Why does the balance sheet not match the bank reconciliation?
Usually because the reconciliation was completed but the adjusting entries were never posted, so the ledger still carries the old balance. The other common causes are a transaction posted to the wrong cash account, a deposit recorded in undeposited funds and never cleared, or a reconciliation run against a different date range than the balance sheet you are reading.
What are balance sheet reconciliation best practices?
Assign a named owner to every account, set frequency by risk rather than uniformly, require the preparer and reviewer to be different people, date and age every reconciling item so nothing carries forward silently, and keep the evidence with the period. Automate the transaction-heavy accounts first, since that is where manual effort concentrates.
How the matching works
Substantiate against your ledger
Prove the balance, not just the total
Connect your banks, cards, processors, and ledger read-only, then see how much of each account substantiates itself before anyone opens a spreadsheet. Reconciler explains every match and never posts an entry.