Skip to main content

Chart of accounts

Trevor avatar
Written by Trevor
Updated this week

The Chart of accounts serves as your financial hub in Dubsado, providing a centralized repository for managing your revenue categories, expense categories, and tax categories. Here you can track collected and uncollected amounts, create new categories, and export financial data for your records.


Accessing the Chart of accounts

To access your Chart of accounts:

  1. Navigate to Home.

  2. Click Finance Reports.

  3. Click Chart of Accounts on the lower half of the page.


Revenue categories

The top section of the Chart of accounts displays all of your revenue categories. Each entry shows:

  • Category name: The name of the revenue category

  • Type: The classification of the category (Sales, Services, or Non-operating)

  • Total collected: The total amount collected for this category within the selected date range

  • Total uncollectible: The total amount marked as uncollectible for this category

Sorting revenue categories

You can sort your revenue categories using the arrows at the top of the each column:

  • Sort category names alphabetically

  • Sort by category type

  • Sort by total collected (highest to lowest or lowest to highest)

Editing revenue categories

To edit an existing revenue category, click on its row within the chart. From there, you can update the category name and type. You can also click the trashcan icon to delete the category.

Viewing associated transactions

Click the arrow icon on the far right side of any row to view all transactions associated with that revenue category.


Expense and tax categories

The bottom section of the Chart of accounts contains both your expense categories and tax categories.

Tax categories

Tax categories can be customized with:

  • A custom name

  • A custom percentage

Expense categories

Expense categories include:

  • Category name: The name of the expense category

  • Type: The classification of the category (Cost of goods, Operating, or Non-operating)

  • Total collected: The total amount recorded for this category within the selected date range

Editing expense and tax categories

Click on any row within the chart to edit or delete that category. You can also click the arrow icon on the far right side of any row to view all transactions associated with that category.


Net profit calculation

At the very bottom of the page, your net profit is displayed. This calculation represents your total revenue minus your total expenses for the selected time period.


Adjusting the date range

The Chart of Accounts displays data based on the date range selected at the top of the page. By default, the page shows the last 30 days of data.

If you're not seeing the data you expect, verify that your date range is set correctly. To adjust the date range:

  1. Click the date selector at the top of the page.

  2. Choose from preset options including:

    • Last 7 days

    • Last 14 days

    • Last 30 days

    • Last 60 days

    • Last 6 months

    • Last 12 months

    • Month to date

    • Quarter to date

    • Year to date

  3. Alternatively, select Custom to enter a specific date range.


Creating a new category

To create a new category:

  1. Click New category in the top right corner of the page.

  2. Select the type of category you want to create:

    • Revenue category

    • Expense category

    • Tax category

  3. Enter a name for the category.

  4. Select the category type, if applicable.

  5. Click Save.

You can always edit the category after it has been created.


Exporting your data

To export your financial data, click Export CSV at the top of the page.

The exported file will include only the data currently displayed based on your selected date range—so make sure your date range is set correctly before exporting.


FAQ

Why am I not seeing any data in my Chart of accounts?

The Chart of accounts displays data based on the date range selected at the top of the page. By default, the page shows the last 30 days of data. If you're not seeing the data you expect, adjust your date range by clicking the date selector and choosing a preset option or entering a custom range.

What happens if I delete a category that has transactions associated with it?

Deleting a category does not affect the transactions themselves—the category association is simply removed from those transactions. Your transaction history remains intact.

What's the difference between the category types?

Category types (such as Sales, Services, and Non-operating for revenue categories, or Cost of goods, Operating, and Non-operating for expense categories) are organizational labels to help you classify your finances. Each type within a category group functions identically, so choose whichever type best describes the category for your own record-keeping purposes.

Did this answer your question?