Accolent ERP data Import Template Instructions provide field-by-field information on the data needed to fill out the CSV templates. Always review these instructions before populating a CSV import template.
| Field Name | Required Field? | Field Data Instructions | Sample Data |
| GL ACCOUNT CODE | Required | Enter GL Account number composed of digits and dashes | 185-00 |
| GL ACCOUNT DESCRIPTION | Required | Enter GL Acct description. 30 character maximum. No spaces. Use only standard ASCII characters (no *,/, etc.). | Cash in Bank |
| ACCOUNT TYPE | Required | Select from: A – Asset, L – Liability – C- Capital, I – Income or E – Expense | A |
| ACCOUNT SUB-TYPE | Required | Account Sub-Types have positional significance on the financial Statements. Select from the following Account Sub-Types: Balance Sheet. CA (Current Assets), OCA (Other Current Assets), FA (Fixed Assets), PPE (Property Plant & Equip), OA (Other Assets), CL (Current Liabilitiess), OCL (Other Current Liabilities), LTL (Long-Term Liabilities), OL (Other Liabilities), EQ (Common Stock), APIC (Add’l Paid-In Capital), RE (Retained Earnings). Income Stmnt. SA (Sales), OR (Other Revenue), COGS (Cost of Sales), OE (Operating Expenses), DA (Depr & Amort), INT (Interest), TA (Taxes), OIE (other Income/Expense). |
CA |
| STATEMENT LABEL | User defined description for a pre-set Account Sub-Type | Current Assets | |
| ACCOUNT GROUP | Required | User defined Account Group under an Account Sub-Type and consisting of of one or more GL Accounts that will be aggregated under the Account Group | Inventory |
| ACCOUNT GROUP NO | Required | Sequential sort order determinig position of Account Group under Account Sub-Type | 2 |
| 1099 REPORT | Enter Y or N, Entering Y marks this GL Account to be considered on the 1099 report | N | |
| ACTIVE? | Required | Enter Y or N | Y |