Skip to Content

Import format "Simple entries" in OM Finance

2504  Entries

Here's a description of the predefined "Simple entries" import format for the Entries file.

The import 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 order of fields is predefined:

Column Field Remark
A Date Format DD.MM.YYYY (followed by the # character is the entry is transitory)
B Label  
C Voucher No.  
D Journal code  
E Account Can be followed by the ! character and then by the Profit/Cost center
F Counterpart Can be followed by the ! character and then by the Profit/Cost center
G Amount  

The file to be imported must not contain any column headers.

Each line corresponds to an entry in Finance.

The decimal separator for amounts can be the point or the comma. No thousands separator.

The end of line is either Carriage Return or Carriage Return + Line Feed (Carriage Return=ASCII 13, Line Feed=ASCII 10).

During this import, OM Finance creates non-existent Account, Counterpart, Journal and Profit/Cost Center records.

Imports of accounts in currencies other than the base currency (CHF) are not permitted.

For importing currency amounts, please use the "Standard " format. This format is more complete, containing (at least) 2 lines per entry (debit, credit).
Import format "Simple entries" in OM Finance