Skip to main content
    NEW: UltraTax CS support is live

    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 or UltraTax CS. No more Excel workpaper wrangling.

    portal.ledgeriq.ai
    Xacme-corp-tb.xlsx

    Drop the client trial balance here

    Excel or CSV, straight from QuickBooks

    ✓ Parsed: 42 accounts, debits = credits

    Acme Corp · 1065 · Lacerte✓ Ties at $0.00
    Checking - Chase12,400CashCash
    Sales-512,400Gross receiptsGross receipts
    Payroll148,200Salaries & wagesSalaries & wages
    Rent36,000Rent expenseRent expense
    💡 4 suggested mappings to review✓ All mappings reviewed by youAccept all
    ⬇ Lacerte Import
    CSVacme-corp.csv mapped to tax lines
    Lacerte · UltraTax CSImported ✓
    1 Upload2 Accept mappings3 Import to tax software
    Exports toIntuit LacerteUltraTax CSNEWDrake · CCH Axcess · CCH ProSystem fxcoming soon
    Business returns1065 Partnership1120 C-Corp1120S S-Corp

    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
    What's New

    UltraTax CS Is Live, and Your Workpaper Got a Major Upgrade

    Ledger IQ now exports import-ready files for both Intuit Lacerte and Thomson Reuters UltraTax CS, and the new 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
    Working Trial Balance · Form 1120S · Tax Year 2025
    AccountUnadjustedAJE / RJEAdjustedTax Adj (TJE)Tax BalanceTax Line
    1010 · Cash - Operating84,210.0084,210.0084,210.00Sch L, Line 1 · Cash
    6250 · Depreciation Expense0.00AJE 2 · 45,300.0045,300.0045,300.00Line 14 · Depreciation
    6420 · Meals & Entertainment12,480.0012,480.00TJE 1 · (6,240.00)6,240.00Line 19 · Other Deductions
    1510 · Accumulated Depreciation(112,500.00)(45,300.00)(157,800.00)(157,800.00)Sch L, Line 10b
    Totals0.000.000.000.000.00TB ties
    Journal Entries
    AllAJERJETJE
    AJE 2Record current-year depreciation45,300.00
    RJE 1Reclass owner draws to distributions18,000.00
    TJE 150% meals disallowance6,240.00

    Journal Entry Register

    Numbered AJEs, RJEs, and TJEs with type filters and per-entry totals. Click any account in an entry to jump straight to it on the Working Trial Balance, then jump right back.

    Stop the Manual Madness

    Eliminate the bottlenecks that slow down tax season. Move from chaos to clarity.

    Before Ledger IQ
    • Excel workpaper wrangling every return
    • Re-keying numbers into the tax software
    • AJEs scattered across tabs that never tie
    After Ledger IQ
    • 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.

    Smart Trial Balance Import
    Drag and drop Excel or CSV exports from QuickBooks and other systems. It handles messy real-world files: varied headers, debit/credit or balance columns, accounting-style negatives. A column-mapping step lets you confirm before anything imports.
    AI Mapping, You Approve
    Tax line suggestions come from three layers: your firm's own mapping history, deterministic CPA rules, and AI classification. Every suggestion must be accepted or dismissed before export, so nothing reaches the return unreviewed.
    Journal Entries Built In
    AJEs and RJEs adjust balances. TJEs record book-tax modifications like the 50% meals disallowance on the workpaper's tax balance column without touching the export, since your tax software applies those limitations itself.
    Year-Over-Year Rollforward
    Next season, last year's mappings carry forward automatically and prior-year balances appear alongside current ones, with big swings flagged for review.
    Detail Preserved on the Return
    Multiple accounts on one tax line, like three bank accounts on Cash, stay itemized in your tax software's detail schedules instead of collapsing into one lump.
    Export Everything
    Tax software import file for Lacerte or UltraTax CS, adjusted trial balance in Excel or PDF, and journal entries in Excel or PDF. All of it binder-ready for review and archiving.
    Multi-Company Dashboard
    Manage every client entity from one dashboard with auto-save. Supports forms 1065, 1120, and 1120S.
    Built for Tie-Out
    The Working Trial Balance proves debits equal credits at every column, so your workpaper ties before the file ever leaves Ledger IQ.

    Three Steps to Done

    01

    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.

    02

    Review Mappings & Post Entries

    Accept or dismiss AI-suggested tax line mappings, then post your AJEs, RJEs, and TJEs on the Working Trial Balance.

    03

    Export to Your Tax Software

    Download an import-ready file for Lacerte or UltraTax CS, plus binder-ready workpapers in Excel or PDF.

    Free During Early Access. No Catch.

    The full platform is free to use right now. No credit card, no billing, no commitment. When paid plans eventually launch, continue if it's earning its keep, or walk away. No strings attached.

    Early Access
    $0during early access

    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 and UltraTax CS
    • 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.

    Frequently Asked Questions

    Using Drake or CCH? You’re Next.

    Lacerte and UltraTax CS are live today. Drake, 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.

    We’ll only contact you about product availability and early access. No spam.