Skip to content
Documentation
English
Open the app

Importing and exporting company file data

Take over a chart of accounts, third parties and entries from another software package as CSV or XLSX, and export a full company file.

To take over a company file from another software package, or to move it out of NovaFisko, each type of data has its own path.

What exists

Data Import Export
Chart of accounts CSV or XLSX, Exports › Import data PDF, XLSX, CSV, Exports tab
Third parties CSV or XLSX, Exports › Import data CSV, Third parties tab (⌘E)
Entries CSV or XLSX, Exports › Import data Books as PDF, Excel, CSV, Exports tab
Documents (UBL, PDF, images, ZIP) Document importer: 20 files per upload, 50 per ZIP, 25 MB per file ZIP of the selected documents, Documents tab
CODA statements Bank tab Export of a period, Bank tab
Full dossier No ZIP archive

Importing a file

  1. Open Exports, then Import data.
  2. Choose what you are importing: Chart of accounts, Third parties or Entries.
  3. If needed, click Download a template.
  4. Click Choose a file.
  5. Read the preview, then click Import.

Nothing is saved before the preview. Nothing is ever erased, and a file run again does not create duplicates.

Import in this order: first the chart of accounts, then the third parties, and finally the entries.

Expected columns

Type Required Optional
Chart of accounts Account, Label Type, Postable, Reconcilable, Purchase grid, VAT code
Third parties Name Type (customer or supplier), Code, VAT, Email, Phone, IBAN, Address, Postal code, City, Country
Entries Journal, Date, Document, Account, Label, Debit, Credit

An export of the chart of accounts can be imported again as it is. The Update the label of existing accounts option updates the labels. Without it, accounts that are already present are ignored.

For entries, each row is a movement and each document must balance. The import is all or nothing: if an error remains, nothing is saved. The journal, the accounts and the fiscal year must already exist.

Recognised formats

  • Files: CSV and XLSX, up to 20,000 rows and 20 MB.
  • Encodings: UTF-8, Windows-1252, UTF-16.
  • Separators: ;, ,, tab and |.
  • Amounts: Belgian format (1 234,56) or English format (1,234.56).
  • Titles and subheadings are ignored.

Possible errors

The preview indicates the row of each error:

Message What to do
invalid account number, account twice in the file Correct the chart of accounts.
missing label, missing name Fill in the column.
unknown journal, unknown account Create it or import the chart of accounts first.
unreadable date, unreadable amount Correct the format.
missing document number, document does not balance Correct the document in the file.

See also