How do I move off spreadsheets without losing my history?

Move forward rather than backwards. Run new jobs in the new system from a chosen start date, keep the spreadsheet as a read-only archive for anything already finished, and only bring across open jobs, current customers and your price list. Attempting to re-enter years of completed work is the most common reason a changeover stalls and gets abandoned.

What should a small trade business fix first?

Whatever is currently costing money rather than whatever is most annoying. For most trade businesses that order is: getting invoices out immediately, knowing reliably who has not paid and chasing them, quoting from consistent saved prices, and keeping job history in one place. Do them one at a time rather than replacing everything at once.

Signs your trade business has outgrown spreadsheets

Q: When should a tradie stop using spreadsheets?

The usual signal is not size but repetition and memory — when the same information is being typed into more than one place, when knowing who owes you money requires reconstructing it, or when the system only works because one person remembers how it fits together. Any of those means the spreadsheet has stopped being a record and started being a risk.

Q: What is wrong with running a trade business on spreadsheets?

Nothing, until the business grows past one person's memory. Spreadsheets have no single source of truth when copies multiply, no reliable history of what was sent to whom, no prompt when something is overdue, and they usually live on one device. The failure is rarely dramatic — it is a forgotten invoice, a quote priced from a stale rate, or an argument you cannot settle because nobody kept the record.

By Yamate · Last updated August 2026

Almost every trade business starts with a notebook, a camera roll and a spreadsheet, and for a while that is genuinely the right setup — it is free, it is flexible, and it fits in one person's head. The problem is that it fails quietly. Nothing crashes. You just slowly start losing an invoice here, quoting off a stale rate there, and spending Sunday nights reconstructing a week you already worked.

1 · The symptoms, and what each one is actually telling you

What you notice	What it means
The same details get typed in more than once — quote, then invoice, then the job list	You are paying yourself to be a copy-paste machine, and every retype is a chance to introduce an error
Working out who owes you takes real effort	There is no single source of truth for money owed, which is the most expensive thing to be vague about
You found an invoice you never sent	Sending relies on memory, and memory is failing under load
Two versions of the price list exist	Copies have multiplied, so nobody knows which number is current
A customer disputed something and you could not prove it	There is no reliable record of what was sent, when, or agreed
Only one person understands how it all fits together	The system is a person, not a system — and that person cannot take a holiday
It all lives on one laptop or one phone	One device failure or one theft is the whole business
A repeat customer rings and you start from scratch	The history exists somewhere but is not reachable when you need it

Two or three of these at once is normal for a growing business. Five or more means the setup has stopped being cheap — you are just paying for it in hours and forgotten money rather than in subscription fees.

The honest test. How long would it take you, right now, standing in someone's driveway, to answer: what did I quote this customer last time, did they pay it, and what did I actually make on it? If the answer is more than about thirty seconds, that is the cost.

2 · What spreadsheets are genuinely good at

This is not an argument that spreadsheets are bad. They are excellent at one-off analysis: modelling a price change, working out whether a job type is worth doing, comparing supplier quotes, building a rate card. Anything where you are thinking rather than recording.

What they are poor at is being the operational record of a business that multiple things depend on — because they have no concept of "current", no prompt when something is overdue, no audit trail of what went to whom, and no way to stop two copies drifting apart.

Plenty of well-run trade businesses keep a spreadsheet forever for exactly the first kind of job. They just stop running the money through it.

3 · Fix in this order

The mistake is trying to replace everything at once, usually in the quietest week of the year, and abandoning it halfway. Do it in the order of what is costing money:

Invoicing immediately. Getting paid starts with sending it. If invoices go out days or weeks late, fix that before anything else — it is pure cash-flow, and it is the easiest win.
Knowing who has not paid, and chasing automatically. Chasing should not be a memory task. See chasing unpaid invoices.
Quoting from saved prices. Consistency across quotes, and no more pricing off a number you half-remember.
Job and customer history in one place. So the repeat call-out does not start from zero.
Everything else. Scheduling, reporting, integrations — only once the first four are steady.

4 · Moving without losing your history

The single most common reason a changeover fails is trying to re-enter years of completed work. Do not. Move forward instead:

Pick a start date — the beginning of a month or quarter is easiest.
Bring across only what is live: open jobs, current customers, your price list.
Keep the old spreadsheet as a read-only archive. It does not need to be migrated to still be readable.
Run everything new in the new system from that date, without exception. Running both in parallel "just for a bit" is how people end up with two half-systems and less clarity than they started with.

Do not let a changeover become a project. If setting up a new system takes more than an evening or two before it is genuinely usable, that is a signal about the software rather than about you. A small trade business should not need a migration plan or a training day to start quoting.

5 · When it is bigger than one tool

Sometimes the problem is not the spreadsheet — it is that a business has accumulated four or five tools that do not talk to each other, and the spreadsheet is the manual glue holding them together. Job records in one place, accounting in another, quotes in a third, photos in a phone, and someone re-keying between them.

That is a different problem, and past a certain size it is worth getting an outside view rather than adding another tool to the pile. The Techy Side are an Australian small-business tech consultancy who work on exactly this — they start at your desk with the spreadsheet that is quietly holding everything together and the systems around it that do not talk. If your problem is four disconnected systems rather than one overloaded file, that is the call to make before you buy anything else.

For most solo tradies and small crews, though, it is genuinely simpler than that: one tool that does quoting, invoicing, chasing and job history in one place removes the glue entirely.

Quote, invoice and chase from one place →

Yamate handles quoting, invoicing, chasing and job records for solo tradies and small crews, works offline for sites with no reception, and shows your GST, tax and profit per job as an estimate as you go. It pushes invoices, payments and customers across to Xero if you use it. It is not tax advice and you still lodge your own returns. Founder plan $19/mo if you sign up before 30 September 2026, $29/mo after; Company plan $79/mo for ten people, $15/mo per person after that. 30-day free trial, everything unlocked, no card needed. Prices in AUD.

FAQ

When should a tradie stop using spreadsheets?

When the same information is being typed into more than one place, when knowing who owes you requires reconstruction, or when the setup only works because one person remembers how it fits together.

What is actually wrong with spreadsheets for a trade business?

No single source of truth once copies multiply, no record of what was sent to whom, no prompt when something is overdue, and they usually live on one device. The failure is quiet — a forgotten invoice, a stale rate, an argument you cannot settle.

How do I move without losing my history?

Move forward from a chosen start date. Bring across open jobs, current customers and your price list only, and keep the spreadsheet as a read-only archive. Re-entering years of finished work is what kills changeovers.

What should I fix first?

Whatever is costing money, not whatever is most annoying. Usually: get invoices out immediately, know who has not paid and chase them, quote from saved prices, then job history.

Do I have to stop using spreadsheets entirely?

No. They are still the right tool for one-off analysis — modelling a price change, comparing supplier quotes, working out whether a job type pays. Just stop running the live money through them.

Is it worth switching if I am only a one-person business?

It depends on volume, not headcount. A sole trader doing several jobs a week with regular customers usually gets the time back quickly. A few jobs a month with a tidy routine may genuinely not need it yet.

Best job management software Invoicing for sole traders Chasing unpaid invoices Getting paid as a tradie Bookkeeping for tradies Works offline

General information for Australian businesses, not tax, legal or financial advice. Record-keeping obligations depend on your circumstances — check ato.gov.au and your own accountant before acting. This page describes the position as read in August 2026.