The Chart of accounts is a list of all accounts available in the system. You can manage it in the Tools → Accounting → Chart of accounts tab.
If the integration has not been set up, the user can:
Upload the Chart of Accounts
To upload the Chart of accounts as an excel file - click the Choose file button (1). A preview will be displayed
Click the Apply button to upload the chart. Your existing chart of accounts will be overridden.
Download Template or Existing Chart of Accounts
You can also prepare the new chart of accounts based on the out-of-box template or on the existing chart. To do so, click the Download template (2) or Download chart of accounts (3) button. The .xlsx file will be save to your default download folder. You can then open it, edit and upload as described in the section above.
You can also use the list for any other purposes.
Add and Account to the Chart
It is also poss
Y
Field | Required | Type | Description | Comment |
|---|---|---|---|---|
Choose file | No | Button | Upload the Chart of Accounts from an excel file | Hidden if API import is set up |
Download template | No | Button | Excel template of the Chart of Accounts | |
Add | No | Button | Add new account | |
Download chart of account | No | Button | Download the current Chart of Accounts to the excel file | |
Sync accounts | No | Button | Receive Accounts via API | Hidden if API import is not set |
Hide all | No | Button | Make all accounts hidden | |
Search | - | Search | Search accounts by name or code | |
Save | No | Button | Save changes | |
Last update | Yes | Label string | Date/Time/Username of uploading Chart of account or receiving via API |
ё
"Chart of Accounts" grid
Field | Type | Required | Description | Comments |
|---|---|---|---|---|
Account code | Input string | Yes | Account code | for API not modifieble |
Account description | Input string | No | Account description | |
|
|
|
| |
Actions | Button | No | Edit, Delete
Once User presses Edit Button, the dialogue window opens. Once User presses Delete Button the confirmation window opens 'Do you really want to delete account <account code> - < account name>? | Hidden for API update |
Add | Button | No | Add new account | |
Hidden | Checkbox | No | if chosen, Account is not visible in the Journal settings > Account code dropdown | empty by default |
Hide deleted accounts | Button | No | Hide deleted accounts from UI |
"Add/Edit Account' Window
Field | Type | Required | Description | Comments |
|---|---|---|---|---|
Add account | Labe string | Header | only for Add Account window | |
Edit account | Labe string | Header | only for Edit Account window | |
Code | Input string | Yes | Account code | for API not modifieble |
Name | Input string | Yes | Account name | |
Description | Input string | No | Account description |
Excel Template:
Chart of account template.xlsx
Check Accounts of all Journals in the Created Batches
As mentioned, the batches are created in compliance with the settings of the Journals available in the "Journal settings" section. There might appear a situation when the Chart of accounts was edited after the Journal settings had been defined, and some of the account used in a journal were marked as deleted. Therefore,
When the account is deleted (User clicks 'Delete') warning message appears. 'Account is used in one or more journals. Are you sure you want to delete it?'
If Account has not been received by API or User chose "Override' and account is not in the Excel file or User chose to delete account in the case above, then Banner is shown in the Accounting and Journal settings tabs "One or more accounts used in the Journals were deleted". On the Journal settings tab , deleted account code, and Account description should be highlighted.
when a batch is being created, either manually or automatically for which account is missing, the batch is not created, Error message is displayed. Banner is shown on the Accounting page "One or more accounts used in the batch were deleted".