Why so many still use Excel — and why to change
In Switzerland thousands of SMEs, sole proprietors and professional practices still keep accounts in Excel or Google Sheets: zero upfront cost, maximum flexibility, templates everywhere. It works until invoices grow, VAT applies, staff join or audits arrive — then the spreadsheet becomes a bottleneck.
Swiss accounting software is not «Excel with a nicer UI»: it integrates the KMU chart of accounts, updated VAT rates, QR-invoices, bank reconciliation, Olc-compliant archiving and reports ready for the FTA and audit. The switch is planned in days, not months — especially if you start from a structured file.
This guide is for those who want to stop typing entries manually and move to a tool suited to Swiss regulation: Excel limits, selection criteria, data export, operational migration and the first weeks on the new system.
Excel limits for accounting in Switzerland
Excel is great for analysis and budgets; for legal accounting it has structural gaps:
No audit trail
Any cell can be changed without a log. The CO (Art. 957a) requires traceable entries: in audit or review, an Excel file cannot show who changed what and when.
Manual VAT and QR-invoices
Rates, codes and quarterly returns depend on formulas you must update yourself. QR-invoices (ISO 20022) are not generated from a sheet without external tools — risk of errors and delayed collections.
Slow bank reconciliation
You download CAMT or CSV from the bank and paste row by row. With dozens of movements per month you lose hours and increase duplicate or unmatched items.
Non-compliant archiving
Files on disk, email or Drive do not guarantee 10-year immutability (Olc, Art. 958f CO). An editable document does not have the same probative value as certified storage.
Warning: «it has worked for years» does not mean «it is compliant». Many issues appear only at the first VAT check, when the auditor asks questions or when the file corrupts without backup.
What Swiss accounting software must offer
Before choosing, verify the solution covers these local requirements:
KMU chart of accounts
Preconfigured Kontenrahmen KMU, customisable, classes 1–9 with linked VAT accounts. Opening balance import from CSV.
Integrated Swiss VAT
Rates 8.1%, 2.6%, 3.8%, exemptions; automatic calculation; export or submission data for FTA quarterly returns.
QR-invoice and billing
Compliant QR invoices, sequential numbering, FTA UID, customer and supplier management.
Banking, OCR and archiving
CAMT.053/054 import or API connection, payment-invoice matching, expense OCR, Swiss cloud archive with 10-year retention.
Generic foreign software often needs manual tweaks for CH VAT and QR-invoices — evaluate solutions built for the Swiss market.
How to choose the right software
Beyond price, compare these criteria to your reality (invoice volume, VAT, fiduciary, team):
Size and complexity
Sole proprietorship with simplified accounts: lightweight tool, few clicks. SME with inventory, payroll or multiple accounts: need G/L, fixed assets and advanced reporting.
Collaboration with your fiduciary
Multi-user access, exports for the advisor, shared mandate. Avoid double entry: you record, the fiduciary reviews in the same environment.
Support and language
IT/DE/FR interface, Swiss support, documentation on cantonal and federal deadlines.
Migration and trial
CSV import from Excel, included migration assistance, trial period to compare real time vs spreadsheet.
Prepare the move from Excel
Before importing into new software, tidy your Excel file:
Pick the timing
Ideal: start of VAT quarter or new fiscal year (1 January). Avoid year-end close week if the fiduciary is still working on the old file.
Clean the file
One sheet for chart of accounts, one for balances, one for customers/suppliers. Dates as YYYY-MM-DD, numeric amounts without formulas in exported cells, no blank rows.
Backup and freeze period
Save a «closed» Excel copy on the last day of the old system. Do not delete it: needed for history and retroactive checks.
List documents to upload
Open invoices, unrecorded expenses, last month bank statements. Priority: open items and bank balances at 31.12 or switch date.
What to export from Excel
Minimum viable export for migration without gaps:
| Data | Format | Notes |
|---|---|---|
| Chart of accounts | CSV | Account number, description, type (asset/liability/revenue/expense) |
| Opening balances | CSV | Balance per account at migration date; assets = liabilities |
| Customers and suppliers | CSV | Name, address, UID/VAT if any, IBAN |
| Open items | CSV | Unpaid sales and purchase invoices |
| Current-year entries (opt.) | CSV | Only if you want history in the new tool; otherwise start from balances |
The 5 migration steps
From Excel to Swiss software in one focused working day (plus verification in following weeks):
Create account and mandate (15 min)
Register, enter company name, UID, address, bank account. Select Kontenrahmen KMU and fiscal year.
Import chart and balances (30–45 min)
Upload CSVs; system flags unmapped accounts or out-of-balance totals. Fix before proceeding.
Connect the bank (10 min)
Bank API or CAMT.053 upload. Movements feed automatic reconciliation.
Upload invoices and receipts (30 min)
OCR on PDFs and photos: amounts, dates, VAT recognised. Review first 10–20 entries to train categories.
First trial VAT return (15 min)
Generate draft quarterly report and compare with what you would have filed from Excel. Fix discrepancies before the real deadline.
The first weeks on the new software
The change does not end at import — build these routines:
Daily recording
15 minutes a day: approve bank matches, scan expenses, issue invoices. Better than piling everything at month-end.
Parallel accounting (optional)
For one quarter, the fiduciary can compare Excel vs software totals. Then drop the sheet for current operations.
Minimal training
One 1–2 hour session for data entry staff: invoices, expenses, reconciliation. Document 3–5 internal procedures.
Review with fiduciary
After first closed month, align categories and VAT accounts. Avoid surprises at year-end.
Practical tips
- Do not wait for December chaos: migrate at quarter start with clean balances
- Keep historical Excel as readonly archive — not as an operational tool
- Balance assets/liabilities on opening balances before importing hundreds of movements
- Enable bank and OCR immediately: that is where Excel time is recovered
- If you have a fiduciary, involve them in software choice — they work in the same environment
- Compare one real week: time Excel vs software; numbers convince more than brochures
- Try AccountEX with CSV import and migration support: move from spreadsheet to Swiss accounting without rebuilding everything by hand
Related guides
Explore digitalisation, VAT and sole proprietorship accounting:
Simplify your Swiss accounting
AccountEX handles VAT, QR-invoices and bookings with AI. Start for free.
Start Free