"Chart of accounts" import/export format for Accounts file - Knowledge Base Office Maker / BiblioMaker

This is the predefined "Chart of accounts" import and export format.

The import/export file is in text format, with a tab mark between fields and a line feed between records. The character table can be UTF-8, Windows or macOS.

To import data into the software, the most common method is to prepare the file to be imported with a spreadsheet program such as Microsoft Excel or LibreOffice Calc, which make it easy to define the order of fields by moving columns. To this end, the first column in the table below contains the letter of the column in which the item is to appear.

The fields order is predefined :

Column	Field	Remark
A	Account number
B	Name
C	Short name
D	Kind	Number : 1 = Balance Sheet, 2 = Income statement, 3 = Profit & Loss, 4 = Non balance sheet
E	Position	Number : 1 = Debit, 2 = Credit
F	Counterpart
G	Title	0 = no, 1 = yes
H	Totalizer	0 = no, 1 = yes
I	Level	Numeric value between 1 and 15, otherwise extraction of the level in the Account number when it contains a /.
J	Complete index
K	Currency code
L	VAT code
M	Profit/cost center	Only in PRO version (empty with Light and Standard versions)
N	Consolidation	Only in PRO version (empty with Light and Standard versions)
O	Analytical	Only in PRO version (empty with Light and Standard versions) 1 = free, 2 = required, 3 = forbidden By default value 1
P	For balance	Only in PRO version (empty with Light and Standard versions) 0 = no, 1 = yes
Q	Reconciliation	Only in PRO version (empty with Light and Standard versions) 0 = no, 1 = yes
R	Reserved for imports	0 = no, 1 = yes
S	Reserved for VAT	0 = no, 1 = yes