Zoho Analytics Consultant in Switzerland

Francs, euros and the rate behind every margin

A Swiss company selling into the EU may price in euros, buy in euros or dollars and report in francs. When rates move, margin by product or customer changes without anything changing in the business. If each report converts at a different rate, management argues about numbers instead of decisions.

In Zoho Analytics I separate the rate questions:

• Transaction currency. Every sale and purchase keeps its original currency and amount.
• Booking rate. The rate used in the ledger, as your accounting system recorded it, for figures that must match the accounts.
• Reporting rate. A fixed monthly or budget rate for comparisons that should ignore currency swings.
• Rate source. One table of rates, with its origin shown on the dashboard and maintained by finance.

Dashboards then show both views where it matters: margin as booked, and margin at constant rates. That lets a sales director see whether a customer became less profitable or the euro simply moved. Currency design across systems is discussed in more depth under ERP for multi-currency, and the ledger side on my Zoho Books Switzerland page.

Swiss accounting packages, Zoho apps and other sources

Swiss companies run on a range of finance systems: Zoho Books for some, a Swiss package such as Abacus or Bexio for others, the fiduciary's system for many, and an ERP in larger firms. Zoho Analytics reads Zoho apps out of the box and can reach a long list of external applications, databases and files. Before the design depends on it, get Zoho to confirm that a connector exists for your accounting package and is included in your plan.

For each source I document:

• Route. Built-in connector, a database link, an export on a timetable, or a staging store in between.
• Join keys. Customer, article, project and entity identifiers, and which system owns them.
• Refresh timing and what users should expect from it.
• Control total checked after each load against the source system.

Where the fiduciary keeps the books, a monthly balance export may be all that is available. That supports summary financial reporting but not invoice-level analysis, and I tell you what depth each option allows before you commit. CRM, project and service data from Zoho then add the operational detail; the overall Zoho landscape for Swiss firms is set out in my Zoho consultant Switzerland page.

Groups across the border and management consolidation

Swiss companies are often part of cross-border structures: a Swiss parent with EU subsidiaries, the Swiss arm of a foreign group, or a holding with operating companies in several cantons. Each may report in a different currency and system.

The model provides:

• An entity key on every financial and commercial table, so views can isolate or combine companies.
• Intercompany sales, management fees and loans flagged at source, so combined figures exclude them.
• A common account grouping, so personnel cost or external services mean the same thing in a Swiss and a German subsidiary.
• Group figures translated into francs or the parent's currency under a rule finance owns.

These are management views. Statutory consolidation under Swiss law or the parent's accounting framework is prepared by the fiduciary, the auditor or group finance, outside Zoho Analytics, and combined dashboards are labeled to make that plain. Should the group want eliminations performed in the accounting system itself, that is an ERP selection matter; see ERP for multi-company. Transfer pricing between entities is a tax matter for your advisor, but the dashboards can show margins with and without intercompany charges.

Access by region, the revised FADP and data location

A Swiss company organized by language region or canton often wants regional managers to see their own figures only. Zoho Analytics supports sharing permissions and row-level filters, so the same dashboard shows each user their scope. I map users to regions, entities and roles, test the rules with real accounts and restrict exports, which bypass on-screen filters.

Personal data appears in reports more often than expected: sales by representative, tickets by agent, hours by employee. The revised FADP, and GDPR where EU data subjects are involved, set expectations your legal advisor interprets. I document which reports contain personal data, who sees them and why.

Data location deserves an early answer. Zoho hosts organizations in several regions including the EU, and the region cannot casually be changed after sign-up. Put the question of available regions to Zoho in writing, and check whether your client contracts require hosting in Switzerland. Zoho has also offered an on-premise edition of Zoho Analytics; whether it is available and sensible for you is a question for Zoho and your IT team, and it shifts maintenance work onto your side.

Limits of a reporting layer, and alternatives to Zoho Analytics

Zoho Analytics shows what the source systems contain. If items are coded differently in each entity, if CRM stages are applied loosely, or if the fiduciary posts revenue to accounts that match no management category, the dashboards inherit those problems. Correcting them means work on processes and master data, the subject of my business process consulting, or of an ERP health check when the ERP setup is at fault.

I recommend a different reporting tool when:

• Finance already runs Business Central alongside Power BI; see Business Central in Switzerland.
• Data volumes and transformations need a dedicated data platform, leaving Zoho Analytics, if used at all, to display the results.
• The parent group has standardized on another BI platform for every subsidiary.
• Hosting requirements rule out the regions available to you.

For the product overview, see Zoho Analytics. Dashboard design as a business problem is covered under ERP for management dashboards, while platform choices more broadly sit with ERP consulting in Switzerland and the Switzerland overview.