eFinancials Fixed Length format

Account Export — eFinancials Fixed Length File Format

The account export function exports accounts, GL actual balances, and budgets. This file format is for the chart of accounts.

Using eFinancials Fixed Length allows Account Import to use the file created from this export for an import, enabling the import of the chart of accounts for existing entitiescompanies into the system.

Note

It is also possible to perform a chart of accounts export using the Accounts.BCL file format.

This file can be in fixed length (SDF) or comma separated (CSV) format.

Field	Field Name	Type	Length	Description
1	EntityCompany 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.