Taking over a portfolio from Excel
5-page guide · free · no sign-up
What this guide contains
- The essential columns
- The pitfalls of Swiss formats
- Preparation, in six steps
- What a spreadsheet cannot hold
- After the import: the three checks
- A word on assisted migration
An excerpt
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.