- 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.1
Click Sync
On the trial balance tab, click the Sync button.
2
Connect to QuickBooks
Click the Connect to QuickBooks button and authorize the connection.
CSV or Excel import
You can also import trial balances from CSV or Excel files:1
Upload your file
Upload your CSV or Excel (.xlsx) file.
2
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.
3
Exclude rows
Click the checkbox next to any rows you want to exclude.
4
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:
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