Statement lines file
The file Statement lines (statement_lines) gives the lines of the balance sheet and the income statement of a company. Each posting account of the chart goes to one line without lines under it.
Rules of the rows
- A line has 1 to 3 levels: a section, a group and a line. The level comes from the parent line. A line without a parent is a section (level 1).
- A line must be on the statement of its parent line.
- The parent of a line can be a line of the same file or a line of an earlier file of this company.
- The order of the lines under the same parent comes from
sort_order. Withoutsort_order, the order of the rows of the file is the order of the lines. - Caution: The first import of statement lines removes the standard chart of the company: its accounts, its posting accounts and its statement lines. Then import the chart of accounts and the posting accounts.
- The import is possible only while the company is Migrating and has no journal entry.
A second file
A line code that the company has already is an error. To change the lines of an earlier file, select Update rows that an import made. The second file can change the name and the order of a line. It cannot change the parent or the statement.
Rules of the file
- Row 1 has the column names. Do not change them. The data starts on row 2.
- Write the data on the sheet "statement_lines". The system reads the sheet "statement_lines", or else the first sheet.
- A column that is not necessary can stay empty. You can remove a column that is not necessary.
- A file can have at most 100,000 data rows and 20 MB. Put more data in more than one file.
- Codes and other text: write them as text. Excel keeps a code such as 001 only in a text cell.
- Y means yes and N means no. A list column takes more than one value, separated by ";".
- Do not write formulas. The system reads the values only.
Columns of the file (version 1)
| Column | Necessary | Type | Meaning | Values | Example |
|---|---|---|---|---|---|
line_code |
Yes | code, at most 16 characters | The code of the line. It must be different on each row. | BS-A-C |
|
line_name |
Yes | text, at most 200 characters | The name of the line on the statements. | Current assets |
|
parent_code |
No | code, at most 16 characters | The code of the line above this line. Keep it empty for a line at level 1 (a section). | BS-A |
|
statement |
Yes | one value of the list | balance_sheet or income_statement. It must be the statement of the parent line. | balance_sheet, income_statement |
balance_sheet |
sort_order |
No | whole number 0–99999999 | The place of the line among the lines under the same parent (a smaller number comes first). Empty: the order of the rows. | 20 |
|
source_note |
No | text, at most 100 characters | A note that identifies the row in your source. The system shows it in the messages, and it does not keep it. | chart:001 |
Example
A file with one row, in CSV format. Row 1 has the column names.
line_code,line_name,parent_code,statement,sort_order,source_note
BS-A-C,Current assets,BS-A,balance_sheet,20,chart:001