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
Navigate to Insights ➔ Chart of accounts in the sidebar.
You can also open it from Insights ➔ Finance reports: find the Chart of accounts section and click View all.
Overview
The Overview section summarizes your finances for the selected date range in three cards:
Revenue: Your total income, with a count of how many revenue categories it covers
Expenses: Your total expenses, with a count of how many expense categories it covers
Net profit: Revenue minus expenses, with your profit margin as a percentage. If no revenue is recorded in the range, this reads No revenue yet
Revenue and expense categories
Below the overview, your categories are listed in two sections: Revenue and Expenses. Both work the same way.
The Revenue table shows:
Category: The name of the 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 Uncollected: The total amount marked as uncollectible for this category
The Expenses table shows Category, Type (Cost of goods, Operating, or Non-operating), and Total collected. There is no uncollected column on expenses.
Sorting categories
Click any column header to sort that table by it. Click the same header again to reverse the direction. You can sort by category name, type, total collected, and, on the Revenue table, total uncollected.
Editing a category
Click a category row to open it. You can update its Name and Type, and tax categories also have a Percentage field. Click Delete within the same window to remove the category.
Viewing associated transactions
Click the View transactions button at the end of any row to see every transaction assigned to that category.
Tax categories
Tax categories are a category type rather than a separate list, so they appear alongside your other categories in the Revenue and Expenses tables, identified by their Type.
A tax category carries a custom name and a custom percentage, both of which you set when you create it and can change at any time by clicking its row.
Net profit
Your net profit appears in two places: as a card in the Overview section at the top of the page, and as a running Net Profit total at the end of the category tables. Both represent 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:
Click the date selector at the top of the page.
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
Alternatively, select Custom to enter a specific date range.
Creating a new category
To create a new category:
Click New category in the page header.
Select the type of category you want to create:
Revenue category
Expense category
Tax category
Enter a name for the category.
Select the category type, if applicable.
For a tax category, enter the percentage.
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 removed from those transactions, and 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.