Import "Text file with columns header"

The Banana import format is "Text file with column headers".

  • Fields and column names must be separated by the tab character "\t".
  • Each line (after a "\n") is a new record.
  • Character encoding should preferably be UTF-8; otherwise, use the local encoding.

  • The first line contains the column header names.

    • You can use any column name available in the table.
    • Column names are case-sensitive and must correspond to the Banana NameXml (English) of the column. You can find the NameXml of a column by clicking its header and selecting Settings, as shown in the example:

    XmlName

  • From line 2 onward, the file contains the data to be imported.
    • The format for Date fields is yyyy-mm-dd.
    • Use a decimal point "." as the decimal separator.
    • Amounts should not contain a thousands separator.

Example file format:

Date	Doc	Description	AccountDebit	AccountCredit	Amount

2023-10-12	1	Description 01	1020	2800	2000.00
2023-10-19	2	Description 02	6580	1000	300.00
2023-10-12	3	Description 03	1000	2800	3240.00
2023-10-19	4	Description 04	6570	1020	700.00