From Client Trial Balance to
Tax-Ready Import in Minutes
Upload the trial balance, review AI-suggested tax line mappings, post your adjusting entries, and export an import-ready file for Lacerte, UltraTax CS, or Drake Tax. No more Excel workpaper wrangling.
Drop the client trial balance here
Excel or CSV, straight from QuickBooks
✓ Parsed: 42 accounts, debits = credits
See how Ledger IQ takes you from trial balance to Lacerte in minutes.
Watch a full walkthrough of a complex return being prepared and mapped in record time.
- Import trial balances instantly
- Apply Adjusting Journal Entries (AJEs) in one place
- One-click Lacerte mapping without re-keying
Drake Tax Is Live, Joining Lacerte and UltraTax CS
Ledger IQ now exports import-ready files for Intuit Lacerte, Thomson Reuters UltraTax CS, and Drake Tax, and the Working Trial Balance turns your mapping into a true tax workpaper.
Working Trial Balance View
A true tax workpaper, not just a grid: Unadjusted → AJE/RJE Adjustments → Adjusted → Tax Adjustments → Tax Balance → Tax Line, with a totals row proving the TB ties.
- Click any adjustment to see the balance buildup
- Click any tax line to see every account flowing to that return line, with the total
| Account | Unadjusted | AJE / RJE | Adjusted | Tax Adj (TJE) | Tax Balance | Tax Line |
|---|---|---|---|---|---|---|
| 1010 · Cash - Operating | 84,210.00 | — | 84,210.00 | — | 84,210.00 | Sch L, Line 1 · Cash |
| 6250 · Depreciation Expense | 0.00 | AJE 2 · 45,300.00 | 45,300.00 | — | 45,300.00 | Line 14 · Depreciation |
| 6420 · Meals & Entertainment | 12,480.00 | — | 12,480.00 | TJE 1 · (6,240.00) | 6,240.00 | Line 19 · Other Deductions |
| 1510 · Accumulated Depreciation | (112,500.00) | (45,300.00) | (157,800.00) | — | (157,800.00) | Sch L, Line 10b |
| Totals | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | TB ties |
Stop the Manual Madness
Eliminate the bottlenecks that slow down tax season. Move from chaos to clarity.
- Excel workpaper wrangling every return
- Re-keying numbers into the tax software
- AJEs scattered across tabs that never tie
- Clean TB import in minutes, even from messy files
- AI-suggested tax line mapping, approved by you
- One workpaper that proves the TB ties, export-ready
Tax Workpaper Software That Speaks CPA
Trial balance, AJEs, tax lines, tie-out. Built by people who prepare returns, for the way firms actually work.
Three Steps to Done
Upload the Trial Balance
Drag and drop the client's Excel or CSV export from QuickBooks or anything else. Confirm the columns and you're in.
Review Mappings & Post Entries
Accept or dismiss AI-suggested tax line mappings, then post your AJEs, RJEs, and TJEs on the Working Trial Balance.
Export to Your Tax Software
Download an import-ready file for Lacerte, UltraTax CS, or Drake Tax, plus binder-ready workpapers in Excel or PDF.
Catch It Before It's Filed
Mapping a trial balance is the easy part. Proving the return actually agrees with it is where returns get amended. Ledger IQ does both.
Return Tie-Out
After you import, key the as-filed amount next to each tax line. Ledger IQ computes the difference and flags every line that does not tie, grouped by return area: Page 1, 1125-A, Schedule K, Schedule L.
This is how a missing beginning accumulated depreciation or a forgotten beginning retained earnings surfaces before the return goes out, instead of during review or after a notice.
| Tax Line | Per WTB | Per Return | Diff |
|---|---|---|---|
| Sch L Ln 1 · Cash | 23,200 | 23,200 | 0 |
| Sch L Ln 10b · Accum. depreciation | 148,500 CR | 96,000 CR | 52,500 |
| Sch L Ln 24 · Retained earnings | 81,140 CR | 81,140 CR | 0 |
| Page 1 Ln 1a · Gross receipts | 512,400 CR | 512,400 CR | 0 |
Net Income Proof
Net income is derived at every column of the workpaper: unadjusted, adjusted, and tax balance. The adjusted figure is net income per books, the number that has to tie to Schedule M-1 line 1.
If an account cannot be classified, Ledger IQ reports it with its balance instead of quietly leaving it out. You see exactly which dollars are unaccounted for rather than trusting a total.
Free Through September 15. No Catch.
The full platform is free through September 15, 2026, straight past the extension deadline. No credit card, no billing, no commitment.
Import at least one return before then and you lock in a founding-user discount for the 2027 filing season, when paid plans launch. Continue if it's earning its keep, or walk away.
Every feature. Every return. Free.
- Unlimited trial balance imports
- AI-assisted tax line mapping with mandatory review
- Working Trial Balance and journal entry register
- Unlimited AJEs, RJEs, and TJEs
- Exports to Lacerte, UltraTax CS, and Drake Tax
- Adjusted TB and journal entry exports (Excel/PDF)
- Multi-company dashboard for 1065, 1120, and 1120S
- Year-over-year rollforward
Sign up at portal.ledgeriq.ai and import your first trial balance in minutes.
Worried AI has your clients' data?
The Safest Client Data Is the Data We Never Have
Most software asks you to trust its security. Ledger IQ was built so there is far less to secure in the first place. Here is exactly what leaves your machine, and what never does.
Your client data never trains an AI model
We contract with our AI provider on terms that forbid training on anything sent through it, and your firm's mapping history is stored under your account alone. It sharpens your suggestions and no one else's. Nothing you map ever teaches another firm's software.
The AI never sees a dollar amount
Only the account name goes out for classification. Not the balance, not the client, not your firm. "Chase Checking" is the whole message. Every suggestion that comes back is checked against a fixed list of valid tax lines before you ever see it.
Nothing is connected to your systems
No QuickBooks integration. No bank feeds. No live link into client books. You upload a file and that is the only way data gets in, so there is no connection for an attacker to pivot through and nothing to revoke if you walk away.
There is no client identity to steal
Ledger IQ has no field for an SSN, EIN, address, or taxpayer name, because a trial balance does not need one to be mapped. The company name is a label you type. Call the client "1042" and the mapping works exactly the same.
Enterprise infrastructure on AWS
Ledger IQ runs on Amazon Web Services, the same infrastructure banks, hospital systems, and federal agencies trust with far more sensitive records. Data sits in Amazon Aurora, sign-in runs through AWS Cognito so we never hold your password, and everything in transit is encrypted with TLS 1.2 and 1.3. Not a rented box in a data center nobody audits.
The file itself is never stored
Your spreadsheet is read once and discarded. Only the parsed trial balance persists, scoped to your account, and every request is checked against your login before a single row is returned.
Questions from your IT or risk reviewer? Email privacy@ledgeriq.ai and we will answer them in writing.
Frequently Asked Questions
Using CCH? You’re Next.
Lacerte, UltraTax CS, and Drake Tax are live today. CCH Axcess and CCH ProSystem fx are on the roadmap.
Tell us what you use and we’ll notify you the moment your software is supported. We may also invite you to early access.