Why we're (still) talking about Excel

According to a FIDUCIAIRE|SUISSE survey in 2024, over 40% of Swiss sole proprietorships still manage their accounting with Excel or Google Sheets. The reason is simple: it's already installed, costs nothing and "works". But the real cost of Excel isn't the licence — it's the time you lose, the errors you don't see and the non-compliance you accumulate without realising it.

The Code of Obligations (art. 957 ff. CO), the Ordinance on the keeping and retention of business books (Olc) and the new Federal Act on Data Protection (nFADP) impose requirements that a spreadsheet simply cannot meet: audit trail, immutable archiving, personal data protection, full traceability.

In this guide we analyse the 7 concrete reasons why Excel is no longer sufficient and show you how to switch to modern accounting software — like AccountEX — in a single day, without losing a single record.

The 5 hidden costs of Excel

Excel is only free in appearance. Here are the costs you don't see on an invoice but pay every week:

Data entry time

Manually recording invoices, payments and bank transactions takes an average of 8–12 minutes per entry. With 30 invoices a month, that's 4–6 hours lost just on data entry — hours you could spend on your clients.

Error correction

Academic studies (Raytheon/Panko, 2008) estimate an error rate of 5–8% in complex spreadsheets. Each error takes time to find and fix — and some only surface during a tax audit.

No automatic backup

An Excel file on a local disk is a single point of failure. A broken drive, ransomware or an accidental overwrite can erase months of work. 21% of Swiss SMEs experienced data loss in the last 3 years (ICTswitzerland).

No built-in compliance

Excel doesn't generate audit trails, doesn't archive immutably, doesn't calculate VAT automatically and doesn't produce financial statements using the Swiss chart of accounts (Kontenrahmen KMU). Every legal obligation requires additional manual work.

No real-time visibility

With Excel, data is only as current as your last entry. No dashboard, no real-time cash flow, no alerts on overdue invoices. You're flying blind — and that leads to poor decisions.

Error risk: Excel vs software compared

Spreadsheets are flexible, but flexibility is also their Achilles' heel: no validation, no constraints, no automatic cross-checks. Here's a realistic comparison:

Metric	Excel	Accounting software
Error rate	5–8%	< 1%
Time per invoice	8–12 min	1–2 min (OCR)
Audit readiness	Days of preparation	Instant export
Data loss risk	High (local file)	Minimal (cloud + backup)

The compliance gaps Excel cannot fill

Swiss law demands standards that a spreadsheet was never designed to meet. Here are the four critical areas:

Audit trail (CO art. 957a)

The Code of Obligations requires every entry to be traceable and unalterable without leaving a record. Excel lets you overwrite any cell without a log: during an audit, the auditor cannot verify the modification history.

Data protection (nFADP)

The new Federal Act on Data Protection requires technical measures to protect the personal data of clients and suppliers. An Excel file offers no native encryption, no access control and no access logs — fundamental requirements since 1 September 2023.

Compliant archiving (Olc, art. 958f CO)

Accounting documents must be retained for 10 years in an immutable format. Excel does not guarantee immutability: anyone with file access can modify it, rendering the data devoid of evidentiary value.

VAT compliance (LTVA art. 70)

The Federal Tax Administration accepts digital supporting documents only if they are legible, complete and archived in compliance. Excel formulas do not produce valid VAT returns or export formats accepted by the FTA (eCH-0217).

Warning: in a tax audit, the absence of an audit trail and compliant archiving can lead to the rejection of VAT deductions and fines of up to CHF 10,000 for breach of accounting obligations (CO art. 325).

How much time you lose every week with Excel

We estimated the weekly time for a sole proprietorship handling about 20–40 invoices per month, comparing Excel management with modern accounting software:

Weekly task	With Excel	With software
Invoice recording	3.0 h	0.5 h
Bank reconciliation	1.5 h	0.2 h
VAT preparation	1.0 h	0.1 h
Reports and financial overview	1.0 h	0.1 h
Document filing	0.5 h	0.1 h
Year-end closing preparation	1.0 h	0.2 h
Weekly total	8.0 h	1.2 h

6 things accounting software does better than Excel

Modern accounting software isn't simply a "prettier Excel". It's a system designed for Swiss accounting, with capabilities a spreadsheet cannot replicate:

Automatic invoice capture (OCR)

Snap a photo or upload the invoice: the system recognises the amount, date, supplier, VAT rate and invoice number in seconds. No more manual entry — 95–99% accuracy on structured documents.

Bank connection and reconciliation

Bank transactions are imported automatically via API or CAMT.053. AI matches each transaction to the corresponding invoice — reconciliation that used to take hours is reduced to minutes.

Real-time financial dashboard

Revenue, costs, margin, cash flow, overdue invoices: everything updated in real time on a single screen. Decisions based on current data, not a spreadsheet updated "last week".

Automatic VAT calculation

The software automatically applies the correct VAT rates (8.1%, 2.6%, exempt) based on the account category and generates the VAT return ready for the FTA — no manual formulas or separate sheets.

Legally compliant archiving

Every document is archived in the cloud with a cryptographic hash, access logs and guaranteed immutability for 10 years. Compliant with the Olc and art. 958f CO — no need to manually manage folders and backups.

Multi-device access

Work from your laptop, tablet or phone: data is always synced in the cloud. Ideal for those working on-site, travelling or at their fiduciary — all you need is an internet connection.

From Excel to AccountEX in one day

The switch isn't as complicated as you think. Here are the 5 steps to migrate from Excel to modern accounting software in a single day:

Export your data from Excel (30 min)

Save your chart of accounts, opening balances and client/supplier list as CSV. If you use an accounting template in Excel, the structure is already there — you just need to export it.

Create your AccountEX account (5 min)

Sign up at app.accountex.ch, select the Swiss chart of accounts (Kontenrahmen KMU) and configure your business details: company name, address, VAT number, bank details.

Import chart of accounts and balances (30 min)

Upload the CSV with your customised accounts and opening balances. AccountEX automatically maps accounts to the standard Swiss chart and flags any discrepancies for review.

Connect your bank account (10 min)

Activate the bank connection via API or upload the CAMT.053 file. Transactions are imported and AI immediately starts proposing matches with already recorded invoices.

Scan your first invoices (15 min)

Snap a photo or upload outstanding invoices. OCR recognises them, AI categorises them and you approve with a tap. After 10 invoices, the system has already learned your allocation preferences.

7 tips for saying goodbye to Excel (with no regrets)

Don't wait for the year-end closing to migrate: the best time is the start of a new VAT quarter, so you begin with clean data aligned to the fiscal period
Keep your original Excel file as a historical archive — don't delete it. You'll need it as a reference for previous accounting periods and for any retroactive tax audits
Spend 15 minutes a day reviewing automatic entries during the first 2 weeks: the AI system improves with your corrections and after a few days will be 95%+ reliable
Activate the automatic bank connection right away: it's the single feature that saves the most time and makes reconciliation virtually instant
Take advantage of pre-configured VAT rates in the software: 8.1% (standard), 2.6% (reduced), 3.8% (accommodation), exempt. No more remembering or manually calculating percentages
If your fiduciary uses different software, ask if they accept exports in CSV or structured PDF format — AccountEX generates both, making collaboration easy without changing their workflow
Try AccountEX for free: record your first 20 invoices and compare the time spent with what you used to spend in Excel. The difference will convince you in less than an hour

Simplify your Swiss accounting

AccountEX handles VAT, QR-invoices and bookings with AI. Start for free.

Start Free