IN THIS SECTION
Overview
The chart of accounts is a listing of all accounts used in the general ledger of an organisation and is a cornerstone of any financial system. Joiin reports on the balance of accounts at a certain period of time and therefore a list of accounts from the source system (Xero, QuickBooks, Sage or manual) has to be maintained to ensure accurate reporting.
The Chart of Accounts tab on the Settings page allows you to view and manage those accounts.
Chart of Accounts
You access the Chart of Accounts by selecting Settings from the top right menu (cog icon) and select the Chart of Accounts tab. The Chart of Accounts page displays a list of all the consolidated Accounts from the Chart of Accounts of all the Companies you've connected to. When you connect to new companies or remove old ones and whenever a data refresh occurs (either manually or automatically each day) the list of accounts will be updated.
List of Accounts
A list of all accounts is displayed. Accounts with the same type, code and name (depending on your configuration) will be merged into a single account name in the same way that occurs when you run the Joiin reports. The list has the following columns.
| Column | Description |
|---|---|
| Account | Name/Code of Account |
| Type | Joiin Account Type. See the Chart of Accounts Mappings article for more information on account mapping. |
| Companies | List of the Companies that account is included in (if there are a lot of companies you can click on the See More link to view them all) |
| Status | The status of the account: Active, Inactive or Mixed. Mixed means the account is in more than one company and is Active in some and Inactive others. To see more detail on the status per company, see the exporting section below. |
Filtering List of Accounts
The list of accounts can be filtered by entering text in the filters at the top. Accounts can be filtered by account name/code, type, company and status.
Exporting Chart of Accounts
You can export your Chart of Accounts to a CSV file by clicking on the CSV download button.
The downloaded file will include the accounts that are appearing on screen - so if you have applied any filters they will also apply to the downloaded file. This is helpful, for example, to get a list of accounts for a single entity.
The download will include a column for each Company with the status of the account for that company - if the company does not have this account "Not found" will be displayed.
The download also displays whether the accounts has been Eliminated.