Skip to content

Data takeover

Under Accounting → Data takeover you take over in one run what you need from your old program: chart of accounts, opening balance, contacts, items, open invoices and open supplier invoices. Kontor knows the exports of bexio, AbaNinja, Abacus and Banana Accounting; any other program works with Excel or CSV files (Other program). Users with the right Accounting see the page.

1. Source and cutoff date

Choose the old program and the cutoff date. The cutoff date is the first day in Kontor, usually 1 January (start of the fiscal year). When you switch during the year, take the first day after a quarter (1 April, 1 July, 1 October); the old program still files the VAT up to then. Kontor needs an open fiscal year for the cutoff date.

The takeover account is the counter account of the opening for receivables and payables. It is zero after the takeover; Kontor creates it if it is missing.

2. Upload files

Upload only what you want to take over. Excel (.xlsx) and CSV work. For each file Kontor shows where to find it in the old program:

File bexio AbaNinja Abacus Banana
Chart of accounts Accounting → Chart of accounts → Export as Excel Accounting → Chart of accounts → Export Financial accounting → chart of accounts as Excel report Table «Accounts» → File → Export to Excel
Trial balance Accounting → Reports → Trial balance on the day before the cutoff Accounting → Reports → Trial balance on the cutoff Financial accounting → balance list on the day before the cutoff Table «Accounts» of the closed year (column «Balance»)
Contacts Contacts → List → Export Addresses → Export Addresses → report to Excel Address book → Export to Excel
Items Items → List → Export Products → Export Products/services → report to Excel Table «Items» → Export to Excel
Open invoices Sales → Invoices, filter «open» Invoices, filter «open» Receivables → open item list on the cutoff Report «Customers» → open invoices
Open supplier invoices Purchases → Supplier invoices, filter «open» Receipts (payables), filter «open» Payables → open item list on the cutoff Report «Suppliers» → open invoices

Menu names can differ between versions. With Other program Kontor needs these columns:

  • Chart of accounts: account number and name (kind and VAT code, if there are any).
  • Trial balance on the day before the cutoff: account number and balance, or debit and credit.
  • Contacts: name, address, postcode, city and customer number.
  • Items: number, name and price.
  • Open invoices: number, customer (name or number), date, due date, open amount.
  • Open supplier invoices: number, supplier, date, due date, open amount, IBAN.

Kontor recognises the columns itself. Change the match under Columns; Recognise again resets it.

3. Match

Kontor takes over accounts with the same number directly and creates missing ones. Match accounts with an own number to a Kontor account, and the old VAT codes to a Kontor code (or no code).

Open items in a foreign currency are taken over with their original amount and booked at the rate of the cutoff date. Under Foreign currencies Kontor suggests the BAZG rate (Swiss customs); Save rate takes it over.

4. Check

Every area has a light:

Light Meaning
no file nothing uploaded for this area
fine the area is taken over as it is
note Kontor takes it over, but check the note (for example contacts that exist already)
to fix it cannot be taken over like this; the note says what is missing

Among other things Kontor checks that the trial balance balances, that the open items match the balance of receivables (1100) and payables (2000), and that the takeover account is zero afterwards. Rows with errors lists the file, row and reason. Below you see the opening entry with all its lines.

5. Take over

As soon as no area is red, Take over now takes over everything in one step. Kontor creates accounts, contacts and items, books the opening and the open items, and then deletes the uploaded files.

The protocol shows what was taken over. Protocol as PDF keeps it on file.

Undo takeover cancels every booking and invoice of the run and deletes or deactivates its contacts, items and accounts. This works as long as nothing was booked in Kontor after the takeover.

Moving to another program later

Import and export describes the way back.