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.