What is trial balance software for tax preparation?

It takes a client trial balance out of their accounting system, lets you map every account to the right line of the tax return, post adjusting, reclassifying and tax journal entries, and then produces a file your tax software imports. The point is that nobody retypes balances between the books and the return, and that the mapping and the entries are documented rather than remembered.

Do I need it if I already use Lacerte, Drake or UltraTax CS?

Check what you already own first. Lacerte ships a trial balance utility, Drake imports a trial balance through a spreadsheet template, and UltraTax CS connects natively to Accounting CS and Workpapers CS. Firms usually buy a separate tool because the built in option solves the import step but not the mapping, the adjusting entries or the review trail that come before it.

Which trial balance software exports to Drake, Lacerte or UltraTax CS?

Ledger IQ exports to all three, which together are about 55 percent of the profession by the AICPA 2025 survey. Tallyfor also covers all three, plus CCH Axcess and ProConnect. Ten Key ATB covers UltraTax and Lacerte but not Drake. BalanceWare covers UltraTax, Drake and the Lacerte trial balance utility. regroupTAX and CCH Engagement Essentials export only to CCH packages, so neither is a candidate for a Drake, Lacerte or UltraTax firm.

Which ones import from QuickBooks Online and Xero?

Tallyfor, Ten Key ATB, regroupTAX and CCH Engagement Essentials all connect to QuickBooks Online and Xero. BalanceWare imports QuickBooks data and Excel. Ledger IQ takes an Excel or CSV trial balance from any system, which covers QuickBooks Online, QuickBooks Desktop, Xero, Sage and anything else that exports a file.

How much does trial balance software cost?

Three of the seven publish rates. Ledger IQ charges per return, from 25 dollars down to 10 as you buy more, or 1,200 dollars for unlimited returns through the end of 2027, with the first return free and no card. Tallyfor charges per binder, 40 dollars each from 25 to 99 binders and falling to 20 dollars above 1,000, with a 25 binder minimum. Ten Key ATB lists 500 dollars a year for 5 users and 250 clients, 900 for 10 users and 500 clients, and 1,500 for 20 users and 1,000 clients. BalanceWare, Quick Trial Balance Pro, regroupTAX and CCH Engagement Essentials are quoted.

What do these tools cost you that you will not use?

This is the question buyers skip. Tallyfor prices per binder, and most firms already run a binder or document system they are not going to replace, so the binder becomes a second place to store workpapers at 40 dollars a client. Ten Key ATB carries audit features, analytical procedures, ratio comparisons and consolidations, which a tax only practice pays for in every renewal and never opens. BalanceWare carries write up breadth for firms that do no write up. Price the capability you will actually use, not the feature list.

What is the difference between trial balance software and tax workpaper software?

Mostly emphasis. Trial balance software starts from the ledger and ends at a tax software import file. Workpaper software starts from the documents and ends at a reviewable file, with the trial balance as one component. Several products here do both, which is why the useful question is not the category label but whether it exports to the tax package you actually file in.

How long does it take to get value out of one of these?

The first client takes longer than doing it by hand, because you are mapping the chart of accounts. The return after that is faster, and the second season is where the saving really lands, since any tool worth buying carries mappings forward so you are reviewing changes rather than starting again. Products with a free trial let you test that on a real client rather than a demo file.

Trial Balance Software for Tax Preparation: 7 Options Compared

Trial balance software for tax preparation does one job: it turns a client's general ledger into mapped, tax ready balances and hands them to your tax software, without anyone retyping a number.

Seven products do that for US firms. They differ on which tax packages they can actually feed, what they charge before you have prepared anything, and what you end up paying for that your firm does not need. This page compares them on all three, with every claim taken from each vendor's published material in October 2026.

Disclosure: we build Ledger IQ. We think it is the right answer for most tax focused firms, the comparison below says why, and it also says where it is not.

Product	Strongest at	The catch	Entry cost
Ledger IQ	Business returns end to end: AI mapping you approve, AJEs, RJEs and TJEs, return tie out, exports to Drake, Lacerte and UltraTax CS	Built for 1065, 1120 and 1120S, and does not export to CCH or ProConnect	First return free, then 25 dollars down to 10
Tallyfor	The widest export list, including CCH Axcess and ProConnect	Priced per binder, a document layer most firms already own and would be paying for twice	25 binder minimum at 40 dollars each, about 1,000 dollars
ATB, Ten Key	Audit style depth: consolidations, analytical procedures, ratio comparisons	No Drake export, and tax only firms pay for audit features they never open	500 dollars a year, 5 users
BalanceWare	Write up breadth: bank reconciliation, amortisation, SSARS engagement letters	Desktop first, so installs, updates and remote access become your problem	Not published
Quick Trial Balance Pro	Simplicity and a very short learning curve	No tax software export stated, which leaves you keying the return by hand	Not published
regroupTAX	Tax return ordered workpapers, claims 1.3 hours saved per return	Exports only to CCH Axcess and ProSystem fx	Not published
CCH Engagement Essentials	Native inside CCH Axcess, no export step at all	Only useful if you file in CCH Axcess Tax, and you are buying a platform	Not published

Trial balance software for tax preparation, compared on what each is best at, where each falls short, and what it costs to start. From published vendor material, October 2026.

The short version, if you are shortlisting today

Which tax software do you file in? That alone removes most of the list. In the AICPA's 2025 survey of 2,011 members, UltraTax CS, Drake and Lacerte together were 55 percent of the profession. Ledger IQ exports to all three. ATB covers two of them and not Drake. regroupTAX and Engagement Essentials cover neither, because both are built for CCH.

What do you pay before preparing a single return? Tallyfor starts at a 25 binder minimum. ATB starts at 500 dollars a year. Ledger IQ starts at nothing, because the first return is free, and the smallest purchase after that is 250 dollars.

How fast can you find out whether it works? Run a real client through Ledger IQ today, free, with no card and no demo call.

The options, one by one

Ledger IQ

Built for one job: taking a business client's trial balance to a filed 1065, 1120 or 1120S.

Upload an Excel or CSV trial balance from any system, QuickBooks Online, QuickBooks Desktop, Xero, Sage or anything else that exports a file. Parentheses, negative signs, subaccounts and account codes are read as they come. The Working Trial Balance shows debits, credits and a totals row, so a file that does not foot is caught before any tax work starts.

Every account maps to a named return line, Schedule L line 16 rather than a code you look up, with AI suggested mappings you review and approve. Nothing exports until every account has been mapped and reviewed, so Opening Balance Equity, Undeposited Funds and Ask My Accountant become questions for the client rather than surprises on the balance sheet. Mapping memory carries forward, so the second season is a review of what changed rather than a rebuild.

Adjusting, reclassifying and tax entries are numbered, described and visible beside the unadjusted balance. Tax entries move the tax column without touching the book figures, which is how a book to tax difference ends up documented on Schedule M-1 instead of plugged. Then the import file for Drake, Lacerte or UltraTax CS, and the return tie out: key the as filed figures back in and any line that disagrees with your workpaper is flagged before the return goes out.

Pricing is published and starts at nothing. First return free with no card, then per return from 25 dollars down to 10 as you buy more, or 1,200 dollars for unlimited returns through the end of 2027. The pricing calculator runs your own numbers.

Where it is not the answer: if you file in CCH Axcess or ProConnect, or your trial balance work is audit rather than tax, keep reading.

Tallyfor

The closest competitor on shape: browser based, imports from QuickBooks Online, Xero or a spreadsheet, keeps book, reclass and tax entries side by side, persists mappings year over year, and exports to the widest list here, CCH Axcess, Drake, Lacerte, ProConnect and UltraTax. If you file in CCH and want a modern tool, it is the strongest option on this page.

The catch is the pricing model. Tallyfor charges per binder: 40 dollars each from 25 to 99 binders, then 36, 32, 28, 24 and 20 as volume passes 100, 300, 500, 750 and 1,000.

Two things follow. There is a floor: the base plan starts at 25 binders, so the entry ticket is about 1,000 dollars before you have prepared anything, where a per return model lets you pay for the eleven returns you actually file.

And you are paying for binders. Most firms already have a binder strategy, whether that is SafeSend, SPbinder, a document management system or a disciplined folder structure, and few will abandon it for a binder that only holds trial balance workpapers. Paying per binder for a second binder system is paying twice for something you already own. If the binder genuinely becomes your workpaper system, the price is fair. If it does not, it is 40 dollars a client for a feature nobody opens.

At 40 business returns that is 1,600 dollars, against 825 on a per return model.

ATB from Ten Key

The veteran, and the feature set shows it: consolidations, analytical procedures with ratio comparisons, a financial statement editor, version history, account grouping and document attachments. It imports from QuickBooks and Xero, and it publishes its price: 500 dollars a year for 5 users and 250 clients, 900 for 10 users and 500 clients, 1,500 for 20 users and 1,000 clients.

Two catches for a tax focused firm. It links trial balances to UltraTax, ProSeries, ProSystem fx, Axcess Tax and Lacerte. Drake is not on that list, and Drake is 16.3 percent of the profession, so for a large slice of firms the single most important feature is the missing one.

And the depth that makes it strong is audit depth. Analytical procedures, ratio comparisons and consolidations are review and audit features, so a tax only practice pays for them in every renewal and never opens them. If you do audit and review work alongside tax, that calculation reverses and ATB earns its place.

BalanceWare

Reaches further into general accounting than anything else here: bank reconciliation, cleared check imports, loan amortisation, pro forma modelling, SSARS support with engagement letters, general ledger pivot analysis in Excel. The export list is good too, covering UltraTax, Drake, the Lacerte trial balance utility, ProSystem fx Engagement and Workpaper Manager.

The catch is the deployment. It is a desktop product with optional cloud storage, which is not the same as a browser tool. Installs, version updates, network or remote setup for multiple preparers, and a file that lives on a machine rather than in an account. For a firm with staff in three locations, that is an IT project attached to a trial balance tool. Pricing is not published, so evaluating it starts with a call.

Quick Trial Balance Pro

Deliberately simple: desktop for Windows and Mac, unlimited journal entries, lead schedules, custom financial statements, imports from QuickBooks, Excel, ATB and Workpapers Plus, and an explicit promise of a very slight learning curve. For a sole practitioner who wants a better spreadsheet, that is a fair description of the need.

The catch is the last mile. The features page does not state a tax software export. Without an import file at the end, the software has tidied your trial balance and left you keying the return by hand, which is the part that actually costs the hours. Confirm it before buying, because it is the difference between a workpaper tool and a tax preparation tool.

regroupTAX

Narrow and opinionated in a good way: a cloud workpaper tool that organises financial data in tax return order, with book to tax reconciliation, QuickBooks Online and Xero integrations, and the only published benchmark on this page, an average of 1.3 hours saved per business return.

The catch is the export list. It produces an Excel file built for CCH Axcess and CCH ProSystem fx. If you file in Drake, Lacerte or UltraTax, which is most of the profession, it is not a candidate however good the workpapers are.

CCH Axcess Engagement Essentials

Produces trial balances for business tax engagements inside CCH Axcess, with QuickBooks Online and Xero integration. For a firm already on CCH Axcess Tax, buying the trial balance step from the same vendor removes the export entirely, which is a genuine advantage.

The catch is the lock in. It is only useful if you file in CCH Axcess Tax, so the decision is not really about trial balance software. You are choosing a platform, at platform pricing, quoted rather than published.

What you may already own

Check your tax software before buying anything. Lacerte ships a trial balance utility most Lacerte firms never switch on, covered in using the trial balance utility in Lacerte. Drake imports through a spreadsheet template, covered in entering a trial balance in Drake Tax. UltraTax CS connects natively to Accounting CS and Workpapers CS, covered in importing a trial balance into UltraTax CS.

Firms buy a separate tool anyway because the built in option solves the import and not the mapping, the adjusting entries or the review trail that come before it.

Excel

Still the most used trial balance tool in the profession, and for a handful of returns it is defensible. What it does not do is remember. Every February the mapping is rebuilt, and the only record of last year's decisions is a tab named Final v3. The limits are in modern trial balance software vs Excel.

What it replaces, and what that is worth

The process all of these target looks the same in most firms. The client trial balance arrives as a spreadsheet. Somebody rebuilds it in Excel, decides which account belongs on which line of the return, posts adjusting entries in a second tab, then keys the result into the tax software one balance at a time. Next February it happens again from scratch.

Two costs come out of that. Time: at one to two hours of mapping and data entry per business return, a hundred return book is 75 to 100 hours a season, about two working weeks. And accuracy: retyping is where transpositions enter a return, and a transposed figure that still balances is the kind nobody finds until a notice arrives.

At 40 business returns with an associate at 40 dollars an hour and two hours each, the manual route costs 3,200 dollars in staff time. The same 40 returns in Ledger IQ is 825 dollars, and nothing is retyped.

What actually matters when you choose

Does it export to the tax software you actually file in? This removes more candidates than everything else combined. Check it first.

Does the mapping carry forward? The work is not mapping 180 accounts once, it is mapping them again next year because nothing remembered. Season two is where a tool pays for itself or quietly stops being used.

Can you post adjusting, reclassifying and tax entries separately? Book to tax differences belong in their own column rather than merged into the client's books, or the workpaper cannot show what you changed.

Is there a review trail? Numbered entries with descriptions, visible beside the unadjusted balance.

Can you see the price without a call? Three of the seven publish rates: Ledger IQ, Tallyfor and ATB. The rest need a sales cycle a firm shortlisting in October may not have.

What are you paying for that you will not use? Binders you already have elsewhere, audit analytics in a tax only practice, write up breadth in a firm that does no write up. Every one of those sits in somebody's subscription on this page.

Can you try it on a real client before paying? A demo file never contains Opening Balance Equity, four renamed accounts and a bookkeeper's guess. A free trial does.

The recommendation

Tax focused firm filing in Drake, Lacerte or UltraTax CS: Ledger IQ. It exports to all three, the pricing is published and starts at nothing, mapping memory and the return tie out are built around the business return, and you can prove it on a live client this afternoon. Start free.

Filing in CCH Axcess or ProConnect: Tallyfor, or Engagement Essentials if you want it inside the platform. Our export list does not cover you, and pretending otherwise would waste your time.

Audit and review work alongside tax: ATB. The analytical procedures and consolidations are real and the price is published.

Desktop firm doing write up as well as tax: BalanceWare.

Two or three business returns a year: Excel, honestly. Revisit when the second season starts costing you.

The part every one of these tools exists for

In the Journal of Accountancy's 2025 tax software survey of 2,011 AICPA members, integration with accounting software was the lowest rated dimension of any measured, averaging 3.3 out of 5, below ease of use, support and reliability.

That gap is not inside your tax software and it does not improve by switching tax packages. It sits between the client's books and the return, which is why this category exists at all.

Ledger IQ supports Forms 1065, 1120S and 1120, with exports for Drake, Lacerte and UltraTax CS. Your first return is free, so you can try it at portal.ledgeriq.ai on a live client without a credit card.