Create or update a trial balance

You can create a trial balance by either:

1. Going to the "Trial balance" tab for new projects

2. Or, going to the "Settings" tab for projects which 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. Simply click the "Sync" button:

And then click the "Connect to QuickBooks" button:

CSV or Excel import

You can also import trial balances from CSV or Excel files. To do so, simply upload your CSV or Excel file and follow the steps shown afterwards:

Exclude rows

To exclude rows on the upload of a trial balance, click the checkbox next to each row to exclude it.

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. You will be able to see that an account has been automatically categorized if the category select field is highlighted purple as shown below.

If Denari AI accidentally miscategorizes an account you can manually override with the correct category.