Account Import File Format

The account import function is provided to allow for the import of a chart of accounts from another software application.

Note

This file format is the same as the eFinancials Fixed Length file format used for Accounts Export. Account Import is able to use the file created from the export for an import; the file created allows the import into the system of the chart of accounts for existing EntitiesCompanies. eFinancials can import all formats that are created from Account Export—the Accounts.BCL file format as well as the eFinancials Fixed Length file format.

This file can be in fixed length (SDF) or comma separated (CSV) format. If using this file format for Job Cost, the CSV format must be used, not the SDF format.

Field	Field Name	Type	Length	Description
1	Entity IDCompany ID	Character	10	This field is required.
2	Account No	Character	20	This field is required.
3	Department ID	Character	10	This field is optional.
4	Account Description	Character	50	This field is required.
5	Dept Description	Character	50	This field is required if the department ID and department do not already exist in eFinancials.
6	Account Type	Character	1	A = Asset L = Liability C = Capital I = Income E = Expenses P = Profit
7	Record Type	Character	1	H = Header D = Detail T = Total
8	Post Flag	Character	1	Blank = Not Set N = Normal C = Closed
9	Cash Flow Code	Character	1	Blank = Not Set C = Cash P = Profit S = Source of Funds O = Other
10	Activate On	Character	10	Use the format mm/dd/yyyy.
11	Track Unit?	Character	1	Y = Yes N = No
12	Total From Account	Character	20	This field is required if record type is T. Note that the comma must still appear for comma separated.
13	Total Thru Account	Character	20	This field is required if record type is T. Note that the comma must still appear for comma separated.