Create or Update a Trial Balance

You can create a trial balance by either:

Going to the Trial balance tab for new projects
Going to the Settings tab for projects that already have a trial balance

QBO import

The QBO import feature allows you to import a client’s trial balance instantly by connecting directly to their QBO account.

Click Sync

On the trial balance tab, click the Sync button.

Connect to QuickBooks

Click the Connect to QuickBooks button and authorize the connection.

QBO imports also automatically bring in prior year data, which is included when exporting the financials PDF.

CSV or Excel import

You can also import trial balances from CSV or Excel files:

Upload your file

Upload your CSV or Excel (.xlsx) file.

Map columns

Columns will automatically be mapped if they have standard names (e.g., “Category Name”, “Account Type”, “Type”). You can also manually map columns and select columns to ignore.

Exclude rows

Click the checkbox next to any rows you want to exclude.

Choose balance type

Select either Debit-based or Account-based headers depending on your trial balance format.

Auto categorization with Denari AI

If you upload a CSV or Excel without account types/categories already defined, Denari AI will automatically categorize them for you. Automatically categorized accounts are highlighted in purple. If Denari AI miscategorizes an account, you can manually override it with the correct category.

Cash Basis and Accrual Basis

When setting up a project and choosing Cash or Accrual Basis, the proper values will be pulled from QBO based on the Denari project basis setting.

Display columns

Use the Display button on the trial balance to toggle which columns are visible. The following columns can be shown or hidden:

Column	Description
Total Adjustments	Sum of all adjustments for the account
Adj bal	Adjusted balance after adjustments
Total Tax Adjustments	Sum of tax adjustments (tax projects only)
Tax Adj bal	Tax adjusted balance (tax projects only)
Reviewed	Whether the line has been reviewed
Account Mapping	Firm account mapping number
W/P balance	Workpaper balance from reconciliation
Variance	Variance between prelim and workpaper balance
Difference	Reconciliation difference
CP bal	Current period preliminary balance
PCP bal	Previous current period balance
PYCP bal	Previous year current period balance

The following columns are always visible and cannot be hidden:

Account name
Prelim balance
Reclassifications
Ending balance
Status
Tick marks
Workpaper name
Previous period balance

Your column visibility preferences persist across sessions per project.

Hide zero balance accounts

Your preference to hide or show zero balance accounts is remembered per project. Parent accounts with a zero balance but non-zero child accounts will still show when hiding zero balance accounts.

​QBO import

​CSV or Excel import

​Auto categorization with Denari AI

​Cash Basis and Accrual Basis

​Display columns

​Hide zero balance accounts