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.