Skip to content

Comparison

Excel and Word, or Solory: an honest comparison

Most Swiss sole proprietors running an Einzelfirma write their invoices in a spreadsheet and their contracts in Word. It is free, it is theirs, and for many people it is still the right answer. This page names what a spreadsheet cannot do - a compliant QR-bill, a signed contract archive, an MWST quarter you can defend, a reminder that goes out on its own.

  • CHF 0The Free plan, capped at 3 active clients
  • 60 daysAfter an MWST period ends, the return and its payment are due
  • 10 yearsRecords kept from the end of the financial year, OR Art. 958f
  • 5Languages an invoice can be printed in

What a spreadsheet gets right

Start with the case for staying, because it is a strong one.

A spreadsheet costs nothing, opens in seconds and does exactly what it is told. No seat, no renewal date, nobody standing between you and your own numbers.

  • It is free, and already on the machine.
  • It bends to any way of working, including one nobody else uses.
  • The file is the data: copy it, mail it, hand it to a Treuhänder.
  • A Word template gives you the page down to the millimetre.

None of that is in dispute. The question is only where a spreadsheet stops being a tool and starts being an exposure.

Spreadsheet and Word against Solory, side by side

The same jobs done two ways, with the gates and the gaps stated.

Job to be doneSpreadsheet plus WordSolory
What it costsNothing, and it is already installedFree plan, or CHF 19, 49 or 89 per month
Control of the layoutTotal, down to the millimetreThree templates - classic, modern, minimal - an accent colour and a logo
Swiss QR-billYou paste in an image and own every mistake inside itPayment part and receipt on their own page, with a QRR or SCOR reference
Invoice numbersA cell anybody can overwritePREFIX-YYYY-0001, allocated once per account, healed if the counter is rewound
The document's languageWhatever you translated by handEnglish, German, French, Italian or Hungarian, per invoice or from the client
Chasing a late paymentA note in your own calendarOff, approval or automatic reminders on Professional and Business
Matching payments to invoicesReading the bank statement by eyecamt.053 and camt.054 import on Business, exact references only
A signed contractA PDF in a folder and an email threadAdvanced electronic signature, audit trail, PDF archived byte for byte
Double-entry books, balance sheet, payrollNot this eitherNot built. That is a job for a Treuhänder or accounting software
Getting your data back outThe file is the dataCSV and JSON exports, plus a full account export as a ZIP
A compliant QR-bill (QR-Rechnung)
The payment part and its receipt are a fixed 210 x 105 mm page carrying a structured reference. On a QR-IBAN that must be a QRR; on an ordinary IBAN an ISO 11649 Creditor Reference.
A signed contract you can still prove in three years
A PDF in a folder proves the words. It does not prove which version was signed, by whom, or that nobody re-rendered it afterwards.
An MWST quarter you can defend
A part-paid invoice, a reverse-charge line, an invoice paid in the year after it was issued: each needs a rule, and in a spreadsheet the rule is whatever you did last time.
A reminder that goes out without you
A spreadsheet cannot mail anybody. Every chase is a decision taken again, on a day you are busy.

The QR-bill is where most spreadsheets break

You can paste a QR image into a spreadsheet. What it will not do is work out what belongs inside.

  • The payment part and receipt are appended as their own page, with a structured reference always attached: a QRR on a QR-IBAN, an ISO 11649 Creditor Reference on an ordinary IBAN.
  • The IBAN is checked against its ISO 7064 mod-97 check digits, so a typo skips the payment part rather than printing a broken one.
  • It prints in German, French, Italian or English, the four QR-bill languages, and is payable with TWINT and every Swiss banking app.

An MWST quarter you can defend

Registration is a line, not a feeling: CHF 100'000 of turnover over a rolling twelve months.

Solory watches that line against your issued invoices - sent, paid and overdue, never drafts - and warns from 80%. Foreign-currency invoices are left out rather than converted.

  1. Pick the method and the cadence

    The effective method files quarterly, the net tax rate method (Saldosteuersatz) twice a year. The return and its payment are due 60 days after the period ends.

  2. Let the money decide the year

    Revenue is recognised on the day the money arrived, read as a calendar date so a 31 December payment cannot slide into January. VAT is split across part payments in integer cents.

  3. Hand it over

    The report prints gross turnover, VAT collected and net revenue, because the MWST return and the Erfolgsrechnung ask for different ones. A Treuhänder fills in the MWST-Abrechnung from the CSV. The same report carries your Säule 3a ceiling and the AHV instalment date.

Records that outlive the file

Swiss records are kept ten years from the end of the financial year they belong to, under OR Art. 958f and the GeBüV.

A spreadsheet survives that easily. What it cannot do is tell you whether a row was quietly edited in year four.

  • Sealing is opt-in per invoice: a fingerprint of the content, from which the content cannot be reconstructed, and one of the archived PDF, after which database triggers make the invoice immutable. Only the payment status still moves.
  • A sealed invoice is corrected with a credit note, never by editing it.
  • The signed contract PDF is archived byte-exactly at signature and served back verbatim, because the client signed a typeset document.
  • A closed accounting period refuses any record dated inside it, by database trigger rather than by a screen.

Contracts and signing are on Professional and Business. What is captured is an advanced electronic signature with an audit trail - an emailed code, both parties, and a fingerprint of the exact text shown - and deliberately not a qualified one.

Getting paid without doing the chasing yourself

This is the part a spreadsheet cannot reach at all, because it cannot send mail.

  • Reminders have three modes per type - off, approval, automatic - all off by default. In approval mode each letter is written and parked until you release it.
  • The schedule is yours: by default a first reminder 7 days after the due date, then every 7, at most 3. Only what is still outstanding is chased, and a parked letter is re-checked before it goes.
  • The dunning ladder is guidance: payment reminder, first and second Mahnung, final reminder, with 5% default interest a year under OR Art. 104. Fees are not fixed by statute and are overridable.

Matching the money back is a file, not a bank connection: you import a camt.053 or camt.054 statement, and only an exact structured reference matches on its own.

When staying on Excel is the right call

Stated plainly, because a comparison that never says this is an advertisement.

  • You issue a handful of invoices a year, to clients who know how to pay you.
  • You are not registered for MWST and nowhere near the CHF 100'000 threshold.
  • Your clients pay to a plain IBAN and have never asked for a QR-bill.
  • A Treuhänder already takes your file once a year and is content with it.
  • You have never sent a payment reminder, because you have never needed to.

And do not arrive for the wrong thing: no double-entry bookkeeping, no balance sheet, no payroll, no multi-currency accounting, and expenses in Swiss francs only. If what you need is a set of books, that is a Treuhänder or accounting software.

If you do move, what the first hour looks like

Nothing here asks you to delete the spreadsheet.

  1. Bring the clients across

    A CSV import with column mapping, and a preview labelling every row New, No name or Duplicate before anything is written.

  2. Fill in what the document prints

    IBAN or QR-IBAN, address, UID and MWST numbers, the number prefix, the payment terms. The form names which of those a QR-bill still lacks.

  3. Issue one invoice and look at it

    The preview beside the form is the real PDF rendered from what you typed, page for page, not a picture of one.

  4. Keep the spreadsheet running alongside

    Reports export as CSV and JSON, and Settings, Privacy produces a ZIP of the whole account. Run both for a quarter.

The assistant behind the command bar drafts. It plans, shows exactly what it would change, and runs only after you confirm. Every invoice it creates is a draft, and it cannot send anything to a client.

Questions people ask

Can I put a Swiss QR-bill on an invoice I wrote in Excel?

Nothing stops you pasting a QR image onto a spreadsheet invoice. What a spreadsheet will not do is decide what belongs inside it: on a QR-IBAN the reference has to be a QRR, on an ordinary IBAN it has to be an ISO 11649 Creditor Reference, and the payment part and its receipt are a fixed 210 x 105 mm layout. Solory derives the reference from the invoice number, validates the IBAN with ISO 7064 mod-97 check digits, and appends the payment part as its own page so the payer can detach it.

Do I have to leave Excel once I register for MWST?

No. Registration is a duty, not a software requirement. What changes is that your figures now have to survive a question: the effective method files quarterly, the net tax rate method (Saldosteuersatz) twice a year, and the return and its payment are due 60 days after the period ends. Solory produces those figures and a tax report CSV a Treuhänder can fill the MWST-Abrechnung from; it does not file anything with the ESTV and does not generate the form itself.

When is a spreadsheet still the better answer?

When you issue a handful of invoices a year to clients who already know how to pay you, you are not registered for MWST, nobody has asked you for a QR-bill, and a Treuhänder is content with the file you hand over once a year. A spreadsheet is free, it bends to any way of working, and nobody can take it away from you. None of that stops being true because a subscription exists.

What happens to my figures when a client pays an invoice in instalments?

In a spreadsheet, whatever you decide, and usually something slightly different the following year. Solory recognises revenue on the day the money arrived, reads that day as a calendar date so a 31 December payment cannot slip into the next tax year, and splits the VAT across the part payments in integer cents so the shares add back up to the invoice's own tax exactly. An invoice paid across two quarters counts in both, and the report says so rather than quietly making a column add up.

Can I get my data back out and return to a spreadsheet?

Yes. Reports export as CSV and JSON, the tax report CSV is translated into all five languages, and Settings, Privacy produces a ZIP of the whole account holding one structured JSON document and a README. It is an archive rather than a handover file for accounting software: there is no DATEV, Banana or bexio export, and a section that could not be read is listed inside the archive instead of arriving as an empty list.

Does Solory replace a Treuhänder?

No, and it is not built to. There is no chart of accounts, no journal, no balance sheet and no payroll; it produces an Erfolgsrechnung and a tax report from cash and invoice data. The Swiss reference inside the product reports what a named authority published, with a link to that page and the date it was read, and it states on every screen that it is not legal or tax advice.

Is there an AI that does the work for me?

There is an assistant, and it drafts. It turns a request into a plan, shows exactly what it would change, and runs only after you confirm, re-validating that plan on the server rather than trusting what the browser sent back. Every invoice it creates is a draft, it cannot send an email or a reminder to a client, and it never computes a figure.

Try it against one real invoice

The Free plan costs nothing and holds three active clients, which is enough to issue one invoice with a real QR-bill and compare it with the one your spreadsheet produces. Keep the spreadsheet open next to it.