Exact Financials (v3)

Connectivity Manual - Finance

Finance

Import screen Finance

CSV path

Specify the path where the csv-file can be found. By default this is taken from the system settings.

Separator

Enter the separator used in the csv file. This can be a comma (,) or a semi-colon (;)

Data process

Here you can select whether you want to import or export data. The option 'Data conversion' is only for advanced users.

Version

If a version number is stated in the import table, you should select the right version when importing.

Options

Enable 'Read test' to test whether the file to import is a real csv file. If you want to print the error file, you should enable the option 'Print error file'. When you enable the option 'Company number' the first field of the csv-file should always be filled with the company number. If this option is not enabled the data will be imported in the current company.

Packages

Select whether you want to import Finance master data or Finance transactions.

Files

Select the file you want to import.

Formats

Master data

• Main classifications
• Sub classifications
• General ledgers
• Creditor categories
• Creditor master data
• Debtor categories
• Debtor master data
• Cost centers
• Cost units
• Countries
• Journals
• Languages
• Multi dimensions
• Payment conditions
• Titles
• VAT codes
• Currencies
• Collection arrangements

Entries

• Exchange rates
• Commitments
• Financial entries
• Financial entries (Exact Financials C/S format)

Connectivity Manual - Contents > Data import > Finance