All guides

Taking over a portfolio from Excel

5-page guide · free · no sign-up

Download the PDF

PDF in French

What this guide contains

  1. The essential columns
  2. The pitfalls of Swiss formats
  3. Preparation, in six steps
  4. What a spreadsheet cannot hold
  5. After the import: the three checks
  6. A word on assisted migration

An excerpt

The PDF guide is available in French.

Dates

Excel stores a date according to the computer’s settings. A file entered in French-speaking Switzerland and opened on an English-language computer can read 03.09.2026 as 9 March. Save dates as YYYY-MM-DD before exporting to avoid ambiguity.

The second check matters most

A correct premium total shows that amounts were read correctly. A difference of a few francs suggests rounding; a difference by a factor of one hundred points to a misread decimal separator.

Related questions

Get the newsletter

One letter a month on running a brokerage firm, commission statements and compliance. No advertising.

By signing up, you agree to receive the newsletter. Unsubscribe at any time. Data protection