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
- Open Exports, then Import data.
- Choose what you are importing: Chart of accounts, Third parties or Entries.
- If needed, click Download a template.
- Click Choose a file.
- 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. |