All articles

From Excel to accounting software: when switching pays off

When does switching from Excel to accounting software pay off? Five clear signs, what the switch really costs and how to do it without losing data.

·4 min read·by Achim Grolimund
Time to retire the spreadsheet, five signs that switching to accounting software pays off
Contents

Saldio exists because I was in this situation myself. As a sole proprietor with fluctuating revenue, I paid the same amount for my accounting software every month, no matter whether the month went well or badly. I switched to a cheaper solution, and suddenly there was an Excel file next to it again: for open invoices, for the budget, for checking VAT. Nobody wanted to maintain it, and yet everything depended on it.

Excel is not the problem. Excel is an excellent tool for calculating. It just isn’t a tool that remembers what happened. And that is exactly what bookkeeping needs.

Five signs Excel is no longer enough

  1. You go looking for payments. Money comes in and you don’t immediately know which invoice it belongs to.
  2. You enter the same figure several times. Once in the invoice, once in the list, once in the VAT sheet.
  3. The VAT return takes a whole day. Because you have to look at every receipt again.
  4. Only you understand the file. If you are out, the bookkeeping stops.
  5. Your fiduciary sends it back. Or bills you for the hours it takes to clean it up.

If two of these sound familiar, the spreadsheet costs you more time than it saves.

Saldio dashboard with income, expenses and result for the current year, monthly trend, expenses by category and invoices by status
Instead of a spreadsheet on the side: income, expenses and open invoices come straight from the bookings.

What the switch really costs

The software itself is rarely the big item. Saldio starts at CHF 5 per month for bookkeeping only, CHF 15 with invoicing, the plans are listed on the pricing page. The larger effort is a one-off: taking over customers, suppliers, chart of accounts and opening balances. Expect half a day to a day if your data is reasonably clean.

On the other side is the time you save every month on matching and searching. If you issue invoices with a QR reference and import the bank statement, you no longer have to hunt for payments. The article How to create a QR-bill shows how.

The best time to switch

The easiest moment is the start of a financial year or a VAT period. You start with clean opening balances and don’t have to catch up on half a period. If you decide now in autumn, you have enough time for a test run before 1 January.

How to go about it

  1. Test while the old solution is still running. Enter a few real invoices in parallel.
  2. Choose a chart of accounts. The setup wizard creates the chart of accounts based on legal form, industry and scope: around 20 accounts for the essentials or the full Swiss SME chart of accounts. Accounts you don’t need can be set to inactive.
  3. Import master data. Import customers and suppliers as CSV from your Excel list, Saldio validates the data on import.
  4. Enter opening balances. From the last balance sheet, including open receivables and payables. Take over fixed assets at their residual value, as described in Taking over fixed assets cleanly.
  5. Archive the Excel file. Don’t delete it. The ten-year retention obligation also applies to the old file.
Saldio setup wizard with the steps plan, company, documents, accounting and review and start
The setup wizard guides you through company details, bank details, chart of accounts, financial year, VAT and opening balances.
Chart of accounts in Saldio with asset accounts, active and inactive accounts marked and an opening balance on the bank account
Keep only the accounts active that you really need. Opening balances are entered directly in the chart of accounts.

Conclusion

If two of the five signs sound familiar, it’s time to switch. Not because Excel is bad, but because you need your time for your customers. The accounting features show what Saldio covers. Try Saldio with all features for 7 days.

Frequently asked questions

Can a sole proprietorship keep its books in Excel?
Yes. Sole proprietorships with less than CHF 500,000 in revenue in the last financial year may keep simplified accounts of income, expenses and financial position. You still have to keep the receipts for ten years.
Will I lose my old data?
No. You take over the opening balances and archive the old file. The history stays traceable in Excel.
Can I leave at any time?
Yes. Saldio can be cancelled monthly and you can download your data as a backup at any time.

Sources

  1. Swiss Code of Obligations, Art. 957 (fedlex) — Duty to keep accounts and exemption for small sole proprietorships.
  2. Swiss Code of Obligations, Art. 958f (fedlex) — Ten-year retention of business records.
Image view