> ## Documentation Index
> Fetch the complete documentation index at: https://docs.denari.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Create or Update a Trial Balance

> Import trial balances from QBO, CSV, or Excel.

You can create a trial balance by either:

1. Going to the **Trial balance** tab for new projects
2. 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.

<Steps>
  <Step title="Click Sync">
    On the trial balance tab, click the **Sync** button.
  </Step>

  <Step title="Connect to QuickBooks">
    Click the **Connect to QuickBooks** button and authorize the connection.
  </Step>
</Steps>

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:

<Steps>
  <Step title="Upload your file">
    Upload your CSV or Excel (.xlsx) file.
  </Step>

  <Step title="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.
  </Step>

  <Step title="Exclude rows">
    Click the checkbox next to any rows you want to exclude.
  </Step>

  <Step title="Choose balance type">
    Select either **Debit-based** or **Account-based** headers depending on your trial balance format.
  </Step>
</Steps>

### 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.