Skip to content
Back to help center

Data migration

Bring your data over from another system

Check import files, map fields and take over records in controlled steps.

5 min readLast reviewed: 23.10.2026
Open in SoPasst

Before the import

Create a full export in your previous program and keep an unchanged copy. SoPasst takes over data from KingBill, sevDesk and Invoice Ninja. From other programs you bring over customers, suppliers or products with a CSV file.

Use the import centre

Data migration in SoPasst with source selection and a controlled import flow
The data source is chosen on purpose before upload, field mapping and dry run.

A dry run does not change your data. You can discard it and start again. The import creates all valid records in one step and cannot be undone. It skips invalid rows; SoPasst shows them afterwards with the reason, and you enter them yourself if needed. The Komet plan includes one import; dry runs do not count. Files from sevDesk and Invoice Ninja and the connection with an API token are available from Planet.

  1. Open Settings › Data migration (the gear at the bottom of the sidebar).
  2. Choose your previous program or the SoPasst CSV template.
  3. Upload the export files. For KingBill, also upload the original PDFs of issued invoices. Instead of files, you can also connect sevDesk and Invoice Ninja with an API token.
  4. For a CSV file, map the columns to the SoPasst fields and start the dry run.
  5. Read the summary: valid, invalid, already present and notices. Rows with a notice are valid and will be imported.
  6. Choose Review import and then Import now. This works as soon as the dry run has at least one valid row.

Quality check

  • Are names, addresses and UID numbers right?
  • Were decimal separators and date formats recognised correctly?
  • Are invoice numbers, amounts and payment status right?
  • Are there duplicate customers because they already existed in SoPasst?

Important

After the import

Imported invoices count as issued and can no longer be edited. Recurring templates arrive paused; check them before you resume them. Recurring vouchers from sevDesk become paused fixed costs under Expenses, not single expenses: end them in sevDesk, then resume them in SoPasst, so nothing is booked twice. Confirm your next invoice number under Settings › Document design. Until you do, you cannot issue a new invoice.

Expected result

SoPasst shows how many records were imported and skipped. Spot checks in customers, products and invoices match the summary you confirmed.

Common problems

Required fields, duplicate invoice numbers, unclear date or number formats and missing original PDFs lead to invalid rows.

Paid invoices need a payment date: the “Bezahlt am” (paid on) column or a payments file. SoPasst records the paid amount as a payment received on that day, so that the EÜR and the Ist-UVA count it in the right period. If the file has no date, “Review import” lists these invoices with their count and amount. Enter one date for all of them or one date per invoice; it cannot be before the invoice date or in the future. Only then can you start the import. SoPasst never sets a date by itself.

Carry on safely

The dry run names every invalid row with its line number and the reason. Correct the source file or the column mapping and start a new dry run. SoPasst recognises records that were already imported and skips them. If an imported record looks different in the new file, the dry run names the row and leaves the record unchanged; you correct an imported invoice with a cancellation invoice (Storno) or a credit note (Gutschrift).

Country names (“France”) and country codes (“FR”) are recognised. If SoPasst does not know a country entry, choose the country once under “Assign unknown countries”; it applies to every row with that value, and those rows are checked again. An invalid UID number is a notice, not an error: the contact is imported with the UID as given and marked “Check UID”; reverse charge only works once the UID is valid. If the UID column holds a Firmenbuchnummer (company register number), it goes into the Firmenbuchnummer field. The dry run rejects an invoice without an amount. “Review import” lists customers that already exist with the same name or the same UID, so you can check them. Payments from a payments file and credit notes that name their invoice reduce the open amount of that invoice.