From spreadsheet chaos to pipeline: a fiduciary office adopts its first CRM

Your first CRM rollout in a fiduciary office succeeds not because of the biggest tool, but because of a clear pipeline and clean data. Replace scattered spreadsheets with one lean process and you gain an overview of mandates, quotes and deadlines – with no IT project, and without your data ever leaving Switzerland. In this article we follow a fictional fiduciary office in Zurich from its first spreadsheet to a working pipeline.

The goal is modest, and that is exactly why it is achievable: less daily friction, and more clarity about which mandates need attention right now. Software removes the tedious work; the relationship stays human.

Why do fiduciary offices end up in spreadsheet chaos?

Fiduciary offices are masters of diligence – in year-end accounts, tax and payroll. Yet for their own sales and mandate management, they often reach for the same tools they use for bookkeeping: spreadsheets and email. That works surprisingly well, right up until it suddenly does not.

You may recognise some of these symptoms:

• Three contact spreadsheets that contradict each other.
• Quotes that vanish into email folders and never get followed up.
• Filing deadlines that live only in one person's head.
• Nobody can say off the top of their head how many new mandates arrived this year.

This is not a failure – it is a natural growth threshold. Above a certain number of mandates and enquiries, you need a shared view of the data. This is exactly where a CRM (Customer Relationship Management, a system for managing customer relationships) comes in.

What is a pipeline – and why does it help a fiduciary office?

A pipeline is simply a visible sequence of steps that an enquiry passes through until it becomes a mandate. Instead of filing quotes somewhere, you see at a glance which stage every enquiry is in.

For a fiduciary office, a simple pipeline might look like this:

1. Enquiry: A prospect gets in touch via the contact form or a referral.
2. First call: Needs clarified, documents requested.
3. Quote: A fixed fee or hourly rate offered.
4. Follow-up: A friendly reminder after seven to ten days.
5. Won / Lost: Mandate signed, or politely declined.

The value lies not in complexity but in visibility. When everyone in the office sees the same five stages, the question “Who is actually handling Mrs Keller's enquiry?” simply disappears.

What does the switch look like in practice? An example from Zurich

Take a fiduciary office in Zurich with four staff and around 120 mandates. The owner manages new enquiries in a spreadsheet, the senior partner in his inbox, the two mandate managers each in their own notes. On average, eight enquiries come in per month.

Before the change, it went like this: of those eight enquiries, only about five were consistently followed up. On realistic estimates, two to three possible mandates per month were simply forgotten – not lost to a competitor, but to internal disorder.

Let us work through the numbers. An average mandate brings in around CHF 3'500.00 in recurring annual revenue. If two enquiries are needlessly lost per month and every second one would have become a mandate, that is twelve missed mandates per year:

• 12 missed mandates × CHF 3'500.00 = CHF 42'000.00 in lost annual revenue.

A lean pipeline that makes every enquiry visible and reminds you automatically to follow up recovers a large share of that – at a cost that is tiny by comparison.

What does the rollout really cost? An honest CHF calculation

Direct software costs are rarely the problem. A lean CRM for a small team costs roughly CHF 20.00 to CHF 40.00 per person per month, depending on the provider. For our Zurich office of four people, that is about:

• 4 people × CHF 30.00 × 12 months = CHF 1'440.00 per year.
• One-off internal setup: roughly two working days, so around CHF 1'200.00 in time.

Set that against the CHF 42'000.00 in lost revenue calculated above. Even if the pipeline recovers only a quarter of it, the ratio is clear. The real investment is not the money but the discipline of using the system consistently.

If you want to dig deeper into how to build up sales on a small budget, our piece on a lean GTM strategy on a low budget helps. GTM stands for Go-to-Market, the plan for how an offering reaches customers.

Step by step: how to roll out your first CRM

You do not have to do everything at once. The following order has proven itself and can be done on the side, without disrupting daily operations.

1. Consolidate your data: Gather all contact lists in one place and remove duplicates. This is the least pleasant but most important hour.
2. Define the pipeline: Set the five to six stages that fit your office. Less is more.
3. Decide on required fields: Name, company, mandate type, source of the enquiry. You need no more than that at the start.
4. Clarify ownership: Who handles which enquiry? One person per enquiry, no overlap.
5. Turn on reminders: Set up automatic follow-up reminders after seven days.
6. Test for a week: Enter new enquiries in parallel before you switch off the spreadsheet entirely.
7. Archive the spreadsheet: Only once the CRM has run smoothly for a week does the old file go into the archive.

Before you start, it pays to look clearly at your target group. Who are the mandates that genuinely fit you? Our guide to defining your go-to-market for Swiss SMEs sets the wider context, and you can also explore the functions that make daily mandate management simpler.

A second example: a fiduciary office in the countryside

Not every office sits in the city. Take a two-person office in a suburban area, mainly serving farms and small tradespeople. Here only three to four enquiries come in per month, but the relationships are long-standing and personal.

For this office, the pipeline is less a sales tool than a memory. When does which tax return start? Which client wanted to discuss succession planning in the autumn? Here the pipeline becomes a deadline list with a human face.

The numbers differ, but the principle stays the same: with two people and costs of around CHF 720.00 per year, it is enough to avoid forgetting a single larger mandate for the system to pay for itself several times over. Data security matters especially here – sensitive tax data belongs on Swiss servers, not just anywhere.

Do you need a large platform like HubSpot?

In short: usually not. Large platforms like HubSpot are excellently built and well suited to growing sales and marketing teams. For a fiduciary office of two to five people, though, they are often oversized – many features go unused while the learning curve and the cost climb.

The overview below helps with the decision:

If you want to compare the different approaches systematically, our article on GTM models compared gives a solid basis, and the pricing page shows what a lean CRM actually costs. The honest answer is: most Swiss SMEs need a lean CRM and a few focused channels, not a whole platform.

Common mistakes in a first CRM rollout

Most mistakes are human and avoidable. Knowing them makes them easy to sidestep.

• Too many fields: Create 25 required fields and you will maintain none of them. Start minimal.
• Too many stages: Eight or ten pipeline stages feel thorough but actually paralyse. Five almost always suffice.
• Keeping the spreadsheet going in parallel: Maintain both systems and you maintain neither properly. Set a clear cut-off date.
• Nobody is responsible: A CRM without clear ownership is abandoned within weeks.
• Ignoring where data lives: Sensitive mandate data belongs on Swiss infrastructure, not on the nearest available server.
• Forgetting the follow-up: The CRM reminds you – but only if you actually use the reminders.

How do you keep the CRM clean over time?

A CRM is like a filing cabinet: it stays tidy only if it is maintained. Three simple habits are enough.

• A weekly look: Spend five minutes once a week going through the pipeline.
• Capture immediately: Enter new enquiries straight away, not “later”.
• Tidy up quarterly: Close dead enquiries so the pipeline stays honest.

Connecting your CRM to the tools you already use keeps everything in one flow; the available integrations show how email and other systems fit together with the pipeline.

Frequently asked questions

How long does it take to roll out a CRM in a small fiduciary office?

For an office of two to five people, one to two working days is realistic. Most of that time goes into consolidating the existing spreadsheets, not the software itself. A lean CRM is deliberately built so you are ready to go without any consulting.

Do we have to put our mandate data in the cloud?

Cloud does not automatically mean abroad. Make sure your provider stores the data in Switzerland. Sensitive tax and mandate data should fall under Swiss infrastructure and Swiss data protection – that matters more when choosing than the feature list does.

Is a CRM worth it even with only a few mandates?

Yes, because the value lies not in volume but in reliability. Even at three enquiries a month, a pipeline ensures none is forgotten and that deadlines stay visible. With long-standing relationships in particular, the system's memory is valuable.

What happens to our existing spreadsheets?

Most CRM systems import spreadsheet or CSV files directly, so you lose nothing. The important thing is to clean up duplicates before the import, so you do not simply carry the chaos into a new system.

Does the CRM replace our accounting software?

No. A CRM manages relationships, enquiries and the pipeline – not the bookkeeping. The two systems complement each other. The CRM handles the phase before the mandate and the care of the relationship; the accounting software handles the numbers afterwards.

How do we convince the team to use the new system?

Make the benefit visible, not the obligation. Once each person notices that they search less, forget nothing and no longer handle enquiries twice, acceptance comes by itself. Start small and celebrate the first month without a forgotten enquiry.

Ready for the first step?

Moving from spreadsheet chaos to a pipeline is not a major IT project but a series of small, doable steps. You need no big budget and no technical team – just the will to make every enquiry visible.

You can start for free at advanzo.app – no credit card, with your data in Switzerland and a deliberately simple CRM that does exactly what a fiduciary office needs. Try it with your next five enquiries and see for yourself how much calmer the day becomes.