Skip to content

Import and export

Import

You take over the chart of accounts, opening balance, contacts, items and open items from your old program under Accounting → Data takeover (see Data takeover). The former import under Sales → Import leads there.

Lists

You download the lists (contacts, articles, documents, supplier invoices, journal and others) as Excel or CSV, with the filters currently set.

Export for the accountant

Under Accounting → Export you choose a fiscal year or your own period and download a ZIP file with Download export:

File Content
journal.csv every booking of the period with account, VAT code, cost center and source
saldenliste.csv opening, debit, credit and balance per account
kontoblaetter.csv every booking per account with running balance
rechnungen.csv invoices and credit notes of the period
debitoren_offen.csv open invoices as of today
lieferantenrechnungen.csv supplier invoices of the period
kreditoren_offen.csv approved supplier invoices not yet paid
belege/ the files of the supplier invoices, when ticked

The files are CSV with semicolons, UTF-8 and a dot as decimal separator; Excel opens them directly.

Export to move to another program

When you move from Kontor to another program, choose the cutoff date (first day in the new program) under Accounting → Export and download a ZIP file with Download switch export:

File Content
kontenplan.csv accounts with kind, VAT code, currency and whether they are active
saldenliste.csv balance of every account before the cutoff (debit positive, credit negative)
kontakte.csv customers and suppliers with address, UID, VAT number and IBAN
artikel.csv items with price and VAT code
debitoren_offen.csv invoices booked before the cutoff and open on the cutoff date
kreditoren_offen.csv supplier invoices booked before the cutoff and open on the cutoff date
LIESMICH.txt what each file holds

The columns carry the common German names, so other Swiss programs read them without manual matching. The sum of the open invoices equals the balance of receivables (1100), the sum of the open supplier invoices the balance of payables (2000). Payments from the cutoff date on do not count; amounts in a foreign currency are in the invoice's currency. Your data in Kontor stays as it is.

Clients

As a fiduciary, have each company add you under Accounts and roles with the role Accounting. Clients then shows all companies with receivables, payables, lock date, last booking and what is open. One click switches to the company.