User-defined File Formats

View - Accounting - User-defined bank file import

You can define your own file formats, which you can import into the journal entry for further processing. This might be useful if you save statements from your Internet bank as Excel-files, for example, and you would like to import the files to avoid having to register all of the transactions manually.

Before you can import files you need to define your own format. This is done in a wizard, which you initiate by clicking on the Search button next to the File type-field and then clicking on New. You then need to enter a Name for the file format and select the File type to be imported.

You also need to enter the settings for the file format you wish to be able to import.

Function

Remove unwanted characters: There may be characters in the import file that you do not wish to import. The most common example of this could be the character '. Text or descriptions in the file may often be given as e.g. 'xxxxxx'. By entering ' into the field here, this character will be removed during import.

Ignore (number of) start lines): Should you have lines at the top of the file that you do not want to include in the import, you can enter the number of lines to be removed. This might apply if the first line is a heading, for example.

All amounts to be divided by: By default this filed will contain the number 1, but this may be overwritten. You may want to overwrite this number if the totals for some files are displayed without a decimal separator, i.e. 100.00 is shown as 10000. In this case you can select to divide by 100.

Separator: If you import character delimited files you can decide whether the separator character should be a Tab, Zero/Null or a User-defined character.

Column setup

Under the column setup heading you can enter the column number for the columns of the file you wish to import. You can enter the column number when using file type Character delimited file or MS Excel. For example, for column numbers in Excel, column A = 1, B = 2, C = 2 and so on. So if the Pay date in Excel is in column C, you would enter a '3' into the Column field.

Be aware that you must enter a column number for Description. The text from this column in the import file will be used in the journal lines.

For file types Fixed column width you need to enter the position for the start column 'From' to end column 'To'.

Note! Which fields are displayed depends on the file format you have selected. Not all fields are available for every file types.