Creating accounts
- On the navigation bar, select the Accounting tab and Chart of Accounts menu.
- On this page, to the right, please click the Add Account button.
- Complete the account creation form and click Save.
Creating a bank account in COA
When creating a bank account, the bank account number (from the bank) input is mandatory to import bank statement or to set up bank feed.
Importing accounts
đź’ˇ There are two ways to create your Chart of Accounts:
Method 1: Select from a list of templates by Industry
Method 2: Create your own Chart of Accounts
Method 1 - Select from a list of templates by Industry
- Select from the following folder a template that is close to your industry (there are 42 main templates that represent 98% of the Industries)
- The currency is set to SGD for all accounts. Set that value to the ISO code of your reporting currency (ex USD, EUR, JPY)
- Save the file as a CSV
- On the navigation bar, select the Accounting tab and Chart of Accounts menu.
- On this page, to the right, please click the Import CSV button
- Import the CSV using the same interface.
- Refer to the template if you receive error message.
Method 2 - Create your own Chart of Account import file
- On the navigation bar, select the Accounting tab and Chart of Accounts menu.
- Download the template and then complete your own CSV.
- On this page, to the right, please click the Import CSV button
- Import the CSV using the same interface.
- Refer to the template if you receive error message.
đź’ˇ Tip : Use only numbers for your account code (and in sequence) so that the code can be auto generated for the next account created.
Example:
- If your account code is in this sequence 1-001-002, 1-001-003, we are able to auto generate the next account code as 1-001-004.
- If your account code is not in sequence 1-001-002, 1-001-005, we are not able to auto generate the next account code.
- If your account code contains alphabets, we are not able to auto generate the next account code.
Assigning a category to expense accounts
- At the Charts of Accounts account list, select the account you would like to assign an Expense Category to.
*Note: You can also assign an expense category when creating an account or using the CSV template and import. - On the Expense Category dropdown, select the category.
- Click Save to finish assigning the category.
Create a contacts account
- Go to Contacts on the navigation bar and select Employee / Customer / Vendor.
- On this page, to the right, please click the Add Account button.
- Complete the account creation form and click Save to create a contact account.
Importing contacts
- Go to Contacts on the navigation bar and select any of the Employee / Customer / Vendor tabs.
- On this page, to the right, please click the Import CSV button.
- Download the template and complete it.
- Upload the CSV file using the same screen.
In case there are errors, we'll generate an error report. You can download the report and fix the errors in your import CSV file. To fix the errors, please refer to this document.
