Spreadsheets

ServiceYak vs spreadsheets and paper

Most trade businesses start on a spreadsheet, a docket book and a phone full of photos, and plenty run well that way for years. Here's what actually changes when the job moves into one app — and where the spreadsheet still wins.

The spreadsheet is not the enemy

Almost every trade business in the country started with a spreadsheet, a docket book, a shared calendar and a phone full of job photos. It works. It's free, it's already on your laptop, and it does precisely what you tell it — which is more than can be said for most software.

The reason people move isn't that spreadsheets are bad. It's that a spreadsheet holds a record of the work and doesn't do any of it. It won't send the quote, won't remind the customer, won't tell your apprentice which address to be at, won't raise the invoice, and won't chase it when it goes past 30 days. Every one of those things stays on you, and they're the ones that go missing on a busy week.

This page is about the point where that trade stops being worth it — and it isn't the same point for everybody.

Where the spreadsheet leaks

Not in the spreadsheet itself. In the gaps between the spreadsheet and everything else you're running.

  • The quote that never got sent. It's half-built in a tab, it needs the pricing checked, and by the time you get to it on Sunday night the customer has taken the one that arrived Thursday.
  • The variation nobody wrote down. Agreed in a doorway, remembered by one person, and gone by invoicing.
  • The invoice that went out late. Not because you forgot the job — because raising it means opening three files and retyping what's already in two of them.
  • The overdue invoice nobody chased. Chasing is a job somebody has to remember to do. It's the single easiest thing to automate and the single most common thing to skip.
  • The photos. Four hundred of them, in the camera roll, in date order, with no idea which job any of them belong to — until there's a warranty claim.

None of those is a spreadsheet failure. They're all the same failure: the record and the action live in different places, and joining them up is manual work that happens after hours.

What actually changes

The useful mental model is that the quote becomes the job becomes the invoice, and nothing gets retyped in between.

  • Quote on site, from saved rates. Five steps from the quote list to a sent quote: create it, pick the client and address, add your lines from your price list, send. The customer has the PDF before you're off the driveway, and you can see when they open it.
  • The accepted quote becomes the job. Same lines, same client, same address, nothing retyped. Schedule it, assign it, and your crew gets a push notification with the address on their phone.
  • Photos, notes and checklists land on the job, not in a camera roll — so two years later the warranty conversation has evidence attached to it.
  • The job becomes the invoice, and it chases itself. Quote and invoice reminders go out by email and SMS on their own.
  • It syncs to Xero or QuickBooks so your bookkeeper isn't retyping the same figures a third time.
  • Sixteen reports tell you which jobs made money, which customers are slow payers, and where the labour actually went — the questions a spreadsheet can answer only if you built it to, and maintained it.

Where the spreadsheet still wins

Two things, and neither is a technicality.

  • It's free, and it's already there. ServiceYak is $37 per user per month ex GST. A spreadsheet is $0 on top of software you're almost certainly already paying for. If money is genuinely tight this quarter, that is a real answer and not a bad one.
  • It works with no signal. A spreadsheet on your phone doesn't need reception. ServiceYak does — there's no offline mode and that's a settled product decision, not something coming later. If you work in basements, roof cavities, switchboard rooms or out past the edge of coverage, that's a real limitation on our side and you should weigh it properly.

There's a third, softer one: a spreadsheet does exactly what you built it to do and never changes underneath you. Software has opinions. If yours has been tuned over five years and fits your business precisely, moving is a real cost and "it's more modern" is not a good enough reason on its own.

The honest test isn't whether the spreadsheet works — it's whether the admin around it is still fitting into the day. If you're doing paperwork after dinner most nights, or if there's a quote sitting unsent right now, that's the signal. If it's all under control, stay where you are and spend the money on something else.

If you do move, move once

The common mistake is running both — jobs in the app, quotes still in the spreadsheet, invoices still in the accounting package by hand. That's more work than either system alone and it's why plenty of first attempts get abandoned in week three.

Pick a start date, do every new job in the one place from that date, and let the old jobs finish where they are. Don't migrate history — it's rarely worth the day it takes. There's a longer version of this in our guide on rolling out job management software, and a straight comparison in job software vs a spreadsheet.

Feature comparison

FeatureServiceYakA spreadsheetWhy it matters
Cost$37/user/mo ex GST$0Free is a real advantage and we're not going to pretend otherwise.
Works with no signal✗ — no offline modeA spreadsheet on your phone doesn't need reception. We do.
Sends the quoteFive steps from the quote list to a sent PDFYou write it, format it, attach it and email itThe quote that wins is usually the one that arrived first.
Tells you it was openedQuote and invoice open trackingKnowing they read it changes when and how you follow up.
Chases an overdue invoiceAutomatic reminders, email and SMSYou remember, or you don'tThis is the one that costs the most and takes the least effort to fix.
Tells the crew where to beAssign the job, push notification with the addressA text, a phone call, or a whiteboardTwo people at the wrong address is a whole morning.
Photos and notes against the jobAttached to the job, kept with itCamera roll, in date orderA warranty claim two years on needs evidence, not a scroll.
Timesheets and labour costClock on/off against the job, per-person ratesA column you fill in later, if you rememberLabour is most of your cost and the easiest to under-record.
Feeds the accountantXero and QuickBooks syncRetyping, or a CSV and some hopeEvery retype is a chance to get a figure wrong.
Reporting16 reports across four suitesWhatever you built, maintained by youA spreadsheet can do this — if someone keeps it alive.
If the laptop diesIt's in the cloud, on every deviceDepends entirely on your backupsMost people find out which it is at the worst moment.

Rows marked A spreadsheet wins are the ones where they beat us outright.

What it costs, and how to think about it

ServiceYak is $37 per user per month ex GST, or $370 per user per year — $30.83 a month. Every feature is in it, there are no caps on quotes, jobs or invoices, the trial is 30 days with no credit card, and there's no lock-in. A spreadsheet is free.

We're not going to tell you it saves you six hours a week, because we don't know that and nobody who tells you a number like that does either. What we'd suggest instead is running the arithmetic on your own figures, which only takes a minute:

  • Work out your real charge-out rate if you haven't — our guide on working out your charge-out rate walks through it.
  • Count the admin hours you actually spend in a week on quoting, invoicing and chasing. Be honest; most people undercount.
  • Add the leaks. One quote a month that goes unsent, or one invoice a quarter that goes unchased, is usually worth more than the subscription on its own.

If that maths doesn't clear $37 a month, the spreadsheet is the right answer for now and we'd rather you kept it. The 30-day trial is there precisely so you can find out on real jobs instead of on a page written by us.

Moving off the spreadsheet

The whole thing takes an afternoon if you resist the urge to bring everything with you.

  1. Load your price list first. This is the part that pays for itself. Get your common line items and labour rates in as kits and templates before you quote anything — every quote after that is minutes rather than an evening.
  2. Bring your clients across, not your history. A client list imports easily. Five years of completed jobs almost never justifies the effort of migrating — keep the old spreadsheet as an archive and start clean.
  3. Pick a start date and hold it. Every new job goes in the app from that date. Old jobs finish where they started. Running both properly for a fortnight is the difference between this sticking and being abandoned.
  4. Connect Xero or QuickBooks early. Do it in the first week and run one real invoice all the way through, so your bookkeeper sees it working before there's a month of them.
  5. Get the crew on it in week one. If the people on site aren't using it, the data stops arriving and the whole thing degrades into a more expensive spreadsheet. Put a real job in front of them on day one.
Common questions

Spreadsheets and ServiceYak, answered.

For plenty of businesses, yes — particularly sole traders with a steady handful of jobs, long lead times and customers who pay on time. It's free, it's flexible, and it works with no signal. The point at which it stops being good enough is usually about admin load rather than size: when quoting and invoicing have moved into the evenings, or when things start slipping through, the spreadsheet has stopped being the cheap option.

Nothing to run, and whatever the leaks are worth. The costs that don't show up anywhere are the unsent quote, the unwritten variation, the late invoice and the unchased debtor. We can't tell you what those come to in your business — but you can, and it's worth an hour with your own numbers before you spend anything on software.

No, and it isn't planned — it needs a connection, and that's a settled decision rather than a gap. A spreadsheet on your phone doesn't. If a meaningful part of your work happens out of reception, that's a genuine mark against us and you should factor it in.

No, and we'd suggest you don't. Bring your client list and your price list — those are the two things that make the app useful immediately. Keep the old spreadsheet as a read-only archive and start fresh from a date you pick. Migrating job history is a lot of work for something you'll rarely open.

You can send a real quote the same day. The part worth spending time on is loading your rates and common line items, because that's what makes every quote after it fast. Most people have that done in an afternoon.

Then you've lost nothing. The trial is 30 days, needs no credit card, and includes every feature — nothing is charged unless you enter billing details at the end. If you do subscribe and later change your mind, there's no lock-in: cancel any time and take your data with you.