How to Export DynaTax AI Data to Drake Tax Software

Where the Export Lives

Tax-software exports are part of the professional workspace. In the pro portal, open Clients → select a client → Bookkeeping → Export. The export screen offers six formats: TXF (Tax Exchange Format), Drake Trial Balance, ProSeries CSV, Lacerte CSV, UltraTax CSV, and a Generic CSV.

Drake Trial Balance (Business Entities)

For business entities, DynaTax AI generates a Trial Balance CSV bundle: a main trial-balance file with GL account totals mapped to Drake import references, plus up to five supporting detail files (other income, other expenses, other costs, charitable contributions, and non-deductible expenses — each capped at 30 line items).

Supported Entity Types

• Form 1120-S: S-Corporation returns
• Form 1065: Partnership returns
• Form 1120: C-Corporation returns
• Schedule C (sole proprietors): not supported by the Trial Balance bundle — use the transaction-level CSV or TXF export instead (next section)

How Accounts Are Mapped

Each GL account row carries a Drake import reference telling you exactly where the amount belongs, written out in full — for example L, line 1, col d for a Schedule L balance-sheet line or DED, line 11for a page-1 deduction line. Enter the totals into Drake's trial-balance import (or key them directly onto the referenced lines).

Export Steps

1. Open the client's Bookkeeping → Export screen.
2. Select the tax year and confirm the entity type.
3. Choose the Drake Trial Balance card and click Export to DRAKE.
4. The status message confirms how many accounts were exported and whether the trial balance is balanced — resolve any imbalance before importing.
5. Import the main CSV into Drake, then use the detail files for supporting statements.

Schedule C Export (CSV)

For Schedule C clients, the export is a transaction-level CSV. The file starts with a short metadata block (TAX EXPORT METADATA: tax year, entity type, EIN, export date) followed by a blank row, a TRANSACTION DATA marker, and then the 13-column data table — including the Schedule C line for each transaction plus reference columns for Form 1120-S and Form 1065 lines.

Confidence Checks Before Export

Every AI-categorized transaction carries a confidence score, and the export enforces it:

• Below 60% average confidence: the export is blocked until low-confidence transactions are reviewed. Firm owners and admins can bypass the block after confirming.
• 60–80%: the export proceeds with a warning — spot-check the flagged categories.
• Above 80%: the export runs clean.

Frequently Asked Questions