Trial balance software gives an accounting firm its own copy of each client's balances, separate from the client's books. It should import a trial balance from any file, map accounts to statement lines, record adjusting entries, roll forward to next year, build lead sheets and export to Excel. A firm needs it once spreadsheets stop scaling.
What trial balance software does that the client's books do not
Trial balance software holds the firm's version of a client's balances, apart from the client's QuickBooks or Xero file. The client's books record transactions as they happen. The firm's trial balance records where those balances stood at period end, what the firm changed, and how each account rolls into the statements and the return.
Keeping the two apart solves several problems at once.
The firm's adjustments stay the firm's. An accountant's year-end entries for depreciation, accruals and reclassifications can live in the firm's file without the client's bookkeeper seeing a half-finished set. The client posts them once they are final. How those entries change the balances is covered in the post on adjusting journal entries and the trial balance.
Prior years stay fixed. Clients can edit old transactions. A firm that pulls last year's balances from the client's live file can find they no longer match the statements it issued. A separate trial balance keeps the as-issued figures.
Every client looks the same inside the firm. One client's chart of accounts has 40 accounts and another's has 400. Mapping each client's accounts to a standard set of statement lines lets the firm use the same statement layout, lead sheets and checks for all of them.
Not every client has software the firm can open. Some send a trial balance from an older desktop package, some send a spreadsheet, and some send a printed general ledger. The firm needs one place to put all of those.
A spreadsheet can do every one of these jobs. The question is how many clients and engagements a firm can run that way before the spreadsheets themselves need managing.
Trial balance software features accountants should test
Trial balance software for accounting firms should be tested on six features: import, mapping, adjusting entries, rollforward, lead sheets and report output. A demo with the vendor's sample company proves little. The test that counts is a real client file from last season, run through each feature by the person who will use it.
Pick a test client with some mess in it: a few hundred accounts, a mid-year account renumbering, a handful of year-end entries and last year's issued statements to compare against. Run it through the checklist below.
| Feature | What it should do | Test with a real client file |
|---|---|---|
| Import | Read a trial balance from Excel, CSV and the client's accounting software export | Import last year's year-end export as it came from the client, without cleaning it first. Count accounts in and out, and confirm the total is zero. |
| Account mapping | Assign each client account to a statement line or tax line, and remember it next year | Map the test client fully and time it. Then import a second client with a different chart and see how much of the mapping carries over. |
| Adjusting entries | Record numbered entries with descriptions, show unadjusted, adjustment and adjusted columns, and flag entries to reverse | Re-enter last year's actual entries. The adjusted balances must match the issued statements to the dollar. |
| Prior-year rollforward | Carry adjusted balances to next year's prior-year column and keep the mapping | Roll the test client forward. Check that retained earnings opens at last year's retained earnings plus last year's net income, and income accounts open at zero. |
| Lead sheets and workpapers | Group accounts by statement area, with room for references and notes | Build the cash and receivables lead sheets and check each total against the trial balance. |
| Statements and export | Produce draft statements and export every grid to Excel without losing columns | Export the adjusted trial balance and one lead sheet. Open them and confirm the numbers are numbers, not text, and that totals recompute. |
Mapping deserves the most time in the test, because it is where most of the setup cost sits. The concepts behind it, and what a good map looks like, have their own post: what trial balance mapping is for.
Watch who does the test. A partner will judge the statements; the staff accountant who imports and maps forty clients in February will judge everything else. Both views matter.
Does a small firm need trial balance software or Excel?
A small firm can run trial balances in Excel when it has few engagements that need adjusted figures, one or two people touching each workbook, and a layout it reuses every year. Trial balance software starts to pay when the firm has many clients needing statements, several staff sharing files, or review engagements with standard workpapers.
There is no client count at which the switch becomes obvious. These signs are more useful than a number:
- The template drifts. Each client's workbook started as the same template, but formulas have been patched, columns inserted and tabs renamed. Nobody is sure which version is current.
- Rollforward takes a day. Copying adjusted balances to the prior-year column, clearing entries and checking links eats hours per client.
- Two people need the same file. A preparer and a reviewer working on one workbook in parallel tend to end up with two copies and a merge job.
- Errors are found late. Sorted ranges, typed-over formulas and broken links surface at review or after the statements go out.
- The same mapping is rebuilt. Each workbook has its own grouping of accounts into statement lines, and changes to the firm's statement layout must be made in every file.
A firm that sees none of these can keep its spreadsheets and improve them. The post on building a trial balance in Excel for review engagements lays out a workbook with signed balances, lead sheet codes and formula-driven lead sheets that avoids most of the common breakages.
A firm that sees several should test software on its messiest client before the next busy season, not during it.
How should trial balance software handle a prior-year rollforward?
A prior-year rollforward in trial balance software should copy every adjusted balance to the new year's prior-year column, keep each account's mapping and lead sheet assignment, and start the new year with no adjusting entries except reversals the firm chose. Balance sheet accounts carry forward; income and expense accounts start the year at zero.
The things that should carry forward:
- Adjusted ending balances as next year's comparative column, locked against edits.
- Account mapping to statement lines and tax lines, so a returning client needs mapping only for new accounts.
- Lead sheet groupings and workpaper structure.
- Notes the firm marked as permanent, such as a loan's terms or a depreciation schedule's method.
- Reversing entries for accruals the firm flagged to reverse, dated the first day of the new year.
The things that should reset:
- Current-year balances, which wait for the new import.
- Adjusting entries other than the reversals.
- Tickmarks, sign-offs and review notes, so last year's checks do not look like this year's.
One test catches most rollforward problems. After rolling a fictional client, Example Landscaping LLC, from 2026 to 2027, compare the software's 2027 prior-year column with the issued 2026 statements. If the 2026 adjusted retained earnings was $84,000 and net income was $21,000, the 2027 opening retained earnings must be $105,000, before any 2027 activity. All figures here are examples.
Ask how the software handles a client who changed charts of accounts between years. If the client merged two expense accounts or renumbered its cash accounts, the rollforward should let the firm map last year's accounts to this year's without retyping balances.
When trial balance programs create more work than they save
Trial balance programs create more work than they save when setup and mapping cost more hours than the engagements recover. That happens with firms that have few clients needing adjusted statements, clients whose charts change every year, or engagements where the client's own reports are already what the firm delivers.
Setup costs are front-loaded. Each new client needs its trial balance imported and every account mapped. A 300-account client can take hours the first time. That time comes back only in later years, when the mapping carries forward and the rollforward is a button instead of a morning.
Some patterns where the time does not come back:
- One-off engagements. A client the firm sees once, for a single year's statements, pays the full setup cost and none of the rollforward savings.
- Tax-only clients. If the firm needs balances only to prepare a return, and the tax software already maps the trial balance, a second mapping in trial balance software is duplicate work.
- Unstable charts. A client who restructures accounts every year breaks the mapping each time.
- Double entry of adjustments. If the firm records adjusting entries in its software and then retypes them into the client's books, every entry is keyed twice. Ask whether the software can produce an entry list the client can import or post directly.
The same question applies to any software a firm adds: does it remove a step, or move it? The post on accounting firm automation software works through that question across a firm's tools.
Questions to ask a trial balance software vendor
Questions to ask a trial balance software vendor should cover what goes in, what comes out, and who owns the data. Import formats decide how much cleaning each client's file needs. Export formats decide whether the firm can leave. Data ownership decides what happens to years of workpapers if the firm cancels.
On what goes in:
- Which file formats does the import accept, and does it read a trial balance export as the client's accounting software produces it, header rows and all?
- Does it accept separate debit and credit columns as well as a single signed column?
- What happens to accounts in the import that are not in last year's mapping? Are they flagged or dropped?
- Can it import a general ledger, or only a trial balance?
On what comes out:
- Can every grid, including the adjusted trial balance, lead sheets and adjusting entry list, be exported to Excel with numbers as numbers?
- Can the adjusting entries be exported in a form the client's bookkeeper can post?
- Can the firm export all clients and all years at once, in a format another program can read?
On ownership and continuity:
- If the firm cancels, how long does it keep access to past years, and in what format can it take them?
- Who at the firm can delete a client, an entry or a year, and is there a record of who changed what?
- How does pricing change as the firm adds clients or staff?
Ask for the answers in writing, then confirm the export answers with the test client from the checklist above. An export that works in the demo but drops columns on a real 300-account file is worth finding before the contract is signed.
Before any of this, the client's trial balance has to reach the firm. It often arrives as a PDF or spreadsheet mixed in with bank statements and tax forms. Schema CPA reads trial balances and general ledgers in that pile and exports the figures to Excel or CSV for whatever tool the firm uses next; the homepage shows the full list of documents Schema CPA reads.