Tracking crypto-assets in a family office raises a structural choice: keep a manual approach (Excel, periodic exports) or rely on a dedicated platform. The question is not convenience: it is about the ability to produce a reliable consolidated view, reconstruct past calculations and prepare for the reporting obligations arriving with CARF. According to Deloitte, about 95% of crypto-asset management still relies on manual processes — which explains how often blind spots appear during volatile periods.
This content is informational and does not constitute tax or legal advice.
Criteria-by-criteria comparison
| Criteria | Manual approach (Excel, exports) | Dedicated platform |
|---|---|---|
| Real-time consolidated view | Rebuilt from exports of each wallet and platform; outdated as soon as produced | Continuous aggregation of wallets, exchanges and depositories in a single interface |
| Transaction history | Limited to available exports; heterogeneous formats across platforms | Every movement timestamped and documented when it occurs |
| Reproducible valuation | Manual recalculations prone to errors; methodology hard to enforce | Unified methodology applied automatically to all reporting dates |
| Multi-beneficiary management | Separate files per beneficiary; risk of mix-ups and omissions | Native separation of portfolios by beneficiary, with access rights |
| Reporting preparation (CARF, tax) | Manual compilation; risk of omissions at collection time | Structured transaction-by-transaction data, ready for collection from 2027 |
| Reconstructing a past calculation | A project of its own: locating files, obsolete formats, rebuilt calculation chains | A simple extraction: the continuous history preserves the calculation chain |
Selection criteria
Four questions decide the right tool:
- Complexity: how many wallets, platforms and beneficiaries must be consolidated? The more fragmentation grows, the more the manual approach accumulates delays and errors.
- Reporting requirements: recurring per-beneficiary reports or CARF preparation require a transaction-by-transaction history, hard to maintain by hand.
- Continuity: will the data still be auditable in five years? Will a 2027 Excel file still be readable — and its calculation chain reconstructable — in 2032?
- Error risk: manual reconciliations, copy-pasting between exports, recalculated valuations — every manual step is an opportunity for a silent error.
When the manual approach is still enough
- A few positions, one main wallet or platform, one beneficiary.
- A buy-and-hold strategy with no regular trading.
- No recurring consolidated reporting requirement.
In these cases, a well-kept spreadsheet remains readable and sufficient. A mainstream tax tool can automate data collection without changing the organisation.
The signals that it is time to move to a platform
- Positions are spread across several wallets and platforms that no one consolidates continuously.
- Per-beneficiary reports take days of manual reconstruction.
- CARF preparation (collection from 2027) requires a transaction-by-transaction history that does not exist yet.
- A past audit revealed valuation discrepancies between sources.
- The question "who will reconstruct this calculation in five years?" remains unanswered.
Case study: reconstructing a 2027 valuation in 2032
Scenario: in 2032, an auditor asks for the justification of a valuation set in 2027. The manager who produced it has left the structure. The data sits in an old Excel file, CSV exports in disparate formats and notes of off-platform transactions.
Without a history kept continuously, reconstruction becomes a project: locating files, reconciling formats, rebuilding the calculation chain — with a real risk of not reaching an auditable result. With a timestamped history kept from the start, the same question becomes an extraction: positions at the date, methodology applied, valuation recalculated identically.
That is the difference in nature between the two approaches: one produces periodic snapshots, the other preserves the flow.
Points of vigilance on the dedicated platform side
Choosing a platform is not neutral either. Three things to check:
- Reversibility: data must remain exportable — avoid any vendor lock-in.
- Documented methodology: the valuations produced must be explainable and reproducible, not a black box.
- Fit for context: a tool built for retail does not cover the multi-beneficiary needs of a family office.
How CIYL approaches this choice
CIYL is a tracking platform dedicated to professional structures: continuous consolidation of wallets, exchanges and depositories, transaction-by-transaction history, per-beneficiary views and reproducible valuations. It covers precisely the criteria in the table above — see the consolidated performance view and the family office solution.
FAQ
Can Excel be enough to prepare for CARF?
For a simple scope, partially. But CARF relies on data collected from activation (no earlier than 1 January 2027) — identities, asset natures, transactions. Keeping that history by hand over several years is costly and fragile; retrospective reconstruction is the main risk.
What does a dedicated platform provide that Excel cannot?
Continuity: aggregation in real time rather than periodic snapshots, timestamping of movements as they occur, and a valuation methodology applied identically at every date. Excel can reproduce each individual calculation, but not the continuity.
Should everything be migrated at once?
No. The pragmatic approach: connect current wallets and platforms to produce the history continuously, while keeping existing processes during the transition. Value is created from the first months — before CARF activation.
Sources
- Deloitte — manual processes in crypto-asset management (statistic cited in the CIYL corpus)
- SIF.admin.ch — CARF implementation in Switzerland
- OECD — Crypto-Asset Reporting Framework
Last updated: September 2026. This content is informational and does not constitute tax or legal advice.