The tax trial balance only exists on binders created with the Tax type.
For everything else a Tax binder unlocks, see What a Tax binder
adds. If you need it on an
existing CAS binder, roll the binder to
tax rather than recreating it.
The columns
Search filters the sheet and counts the accounts that matched.
How it’s organized
The sheet reads category → tax mapping → account, and mappings can nest beneath one another, so a custom Other Deductions sub-line sits under its parent line with its own accounts below it. The Schedule M lines are pulled out of the categories they would otherwise sit in and given their own sections:- M-1 Adjustments, the book-to-tax income reconciliation
- M-2 Adjustments, the capital and retained earnings roll-forward
- M-3 Temporary, timing differences that reverse
- M-3 Permanent, differences that never reverse
Every M-3 line carries a separate temporary and permanent code. An M-3 mapping
with no treatment picked stays where it is in its category rather than
moving into a Schedule M section. If a line you expected under M-3 Temporary
or Permanent is still sitting in Income or Expenses, that is why: choose the
Temporary or Permanent variant of the mapping.
The bottom of the sheet
Difference should be zero in every column. If it isn’t, the accounting equation doesn’t hold after tax adjustments, and something above it needs attention before the numbers go anywhere.
Prior years
A tax return is read against what came before it, so the tax trial balance carries prior years alongside the current one. Populate from prior year carries each account’s adjusted tax balance from a previous return into this binder’s Prior year column, matched by account. It overwrites any prior-year values already there, so it is a deliberate action rather than something that happens quietly on import. You can carry more than one year. Each year you bring across gets its own Prior year column, labelled with its year. Only the most recent is shown by default; the rest are there in Display when you want them. Two prompts appear in the toolbar when something needs doing:
Update following years runs the same thing in the other direction. When later returns use this one as a prior year and your figures have since changed, it refreshes this year’s Prior year column in each of them, leaving their other prior years alone.
Classes and consolidations
Where the entity uses classes, the tax trial balance can be read per class, and Net Income is broken out per class rather than landing in one lump. Where the entity has subsidiaries, consolidation is part of this view rather than a separate sheet. Pick the consolidation scope and the sheet shows the group, with the entity and class detail available underneath each line. Use eliminating journal entries to remove intercompany balances.Eliminating entries cannot take a tax mapping as their target. An elimination
removes an intercompany balance; it is not a book-to-tax difference, and
mapping one to a return line would double-count it.
Tax mappings
A tax mapping ties an account to a specific line of a specific return: a form, a section, and a line, carrying a tax code. It is what turns a trial balance into something you can hand to tax software. Assign mappings from the Chart of Accounts page, using the tax mapping combobox on the account, or in bulk by selecting several accounts at once. Mappings are scoped, so the right set is offered for the engagement in front of you:Mappings your firm creates itself are not year-filtered. A custom mapping
stays available on every tax year, so you set it up once rather than per
season. Only Denari’s published sets are versioned by year.
The tax mapping is not the same field as Account Mapping on the trial
balance. Account Mapping is your firm’s own map number, used for mapped
financials. One is for your statements, the other is
for the return.
Export to UltraTax CS
Once accounts are mapped, Export to UltraTax on the tax trial balance produces a CSV ready to import, one row per account:
The file is named
{period end} {entity} - UltraTax TB.csv.
Unmapped accounts are skipped, and Denari tells you how many: “3 unmapped accounts skipped (no UltraTax tax code).” Read that number. It’s the count of accounts that silently won’t reach the return.
If nothing is mapped at all you get Nothing to export, pointing you back to the Chart of Accounts.