If you have a Chart of Accounts (COA) and do not want to create it manually in Request Accounting, you can upload a CSV file of your Chart of Accounts, and Request Accounting will import the accounts instantly.
To import your CoA to Request Accounting, please follow the steps below:
Navigate to Accounting → Chart of Accounts
Click on Import Accounts
Next, get your template here to start preparing the CSV file.
Fill in the CSV template. Refer to the table below to understand what you need to provide.
Finally, drag and drop the CSV into the drop zone to upload. Request Accounting will read the CSV and import your COA.
Field Name | Description |
Account Type | The primary account category for your COA. It should be one of Asset, Revenue, Liability, Equity and Expense. |
Account Name | The name of your debit or credit account. It should belong to any one of the five primary account types. |
If you have any sub-accounts under one of these Account names, you can mention the Account Name in the Account Type column, and mention the sub-account in the Account Name column.
Request Accounting identifies duplicate COAs if the same file is uploaded twice. This is handy when you frequently update your COAs, as you don’t have to delete your already uploaded COAs from the CSV.
You can have the same Account Name listed under different Account Types, but it is not advised to create sub-accounts for these Account Names.
Example: I have Accounts Receivable listed under both Revenue and Asset. If I wish to create a sub-account Crypto AR under Accounts Receivable, the system will not be able to recognize if this sub-account belongs to Accounts Receivable under Revenue or Asset. It is recommended to input these sub-accounts manually in Request Accounting.