To import your chart of accounts into VersAccounts , use the csv file chart_of_accounts.csv. This file format is also used for importing trial balances which need additional columns called account_number, current_balance, period_end_date, imported_earlier. You can create one file for importing chart of accounts and trial balance.
The files have the following columns. The columns needed for importing trial balance will be ignored.
account_number: Account number. Not required if you do not use account number.
description: Description of the account. Can be blank.
gl_account_type: Account type
gl_account_subtype: Subtype in an account type if applicable.
currency_code: Currency of the account if the account is a cash type of account. Applicable if the account type is Asset and subtype is Cash.
default: Set this to TRUE if this account is a default account in VersAccounts. There are some accounts that are created by default in VersAccounts. Accounts such as Accounts Payable, Accounts Receivable, Inventory Asset accounts, Cost of Goods Sold. Such accounts do not need to be imported. But if you want to list them in the csv file for completeness, you can set the default column to TRUE which will cause import to skip this row.
gl_account_type is the account type and gl_account_subtype is the account subtype.
Allowable Account Types and Subtypes:
GL Account Types: Asset, Liability, Owner's Equity, Retained Earnings/Deficit, Revenue, Expense, Contra-Asset, Contra-Liability, Contra-Expense, Contra-Revenue.
GL Account Subtypes: Some account types have subtypes which are optional.
Only provide subtypes when needed to note special accounts. Keep subtype blank if you do not need it
For Asset accounts, there are Fixed Asset, Cash, Inventory, Inventory: Finished Goods, Inventory: WIP, Inventory: Raw Materials, Accounts Receivable, Undeposited Funds, Supplier Prepayments
For Liability accounts, there are Customer Deposits, Credit Card, Accounts Payable, Customer Deposits
For Expense accounts, there is Cost of Goods Sold
|Example Cash Account|
|Example Asset Account|
|Example Fixed-Asset Account|
|1720||Computer Software||Asset||Fixed Asset|
|Example Liability Accounts|
|2050||Line of Credit||Liability|
|2140||US $ exchange - CC||Liability||Credit Card||USD|
Comments and Suggestions
Article is closed for comments.