Spreadsheet or software for agency finance: an honest decision guide

There is no single right answer to "spreadsheet or software". A spreadsheet template is the better tool for some agencies and a poor fit for others. The same is true of agency-management software and accounting add-ons.

The deciding questions are practical. How often do you need the answer? How many people touch the data? Where does the data already live? This guide goes through both sides, shows what each costs over three years, and ends with a checklist you can run in a few minutes.

One note before you start: bookkeeping, invoicing, sales tax and payroll belong in accounting software in either case. This guide is about the layer above that: knowing which clients, projects and retainers pay for the work.

When a spreadsheet template is the right tool

You own the file. It sits on your drive, opens without a login, and keeps working if you stop paying for anything. Old months stay exactly as you closed them.

There is no subscription. You pay once. The cost doesn't grow when you hire, and nobody needs a seat to read a report.

Every figure is traceable. You can click a cell and see the formula behind it. When a number looks wrong, you can follow it back to the row that caused it. That matters when you are about to reprice a client based on the result.

Your review is monthly. If you look at client contribution once a month, after the hours and invoices are in, you don't need a live feed. You need correct totals and a clear view of the month.

You have fewer than about 30 active clients. This is a guide, not a hard limit. Below that size, one person can usually enter or paste a month of data in a sitting. Above it, the entry time and the chance of a missed row both grow.

One or two people maintain it. Spreadsheets have no real permissions or change history. That's fine when the owner or one operations lead is the only editor.

When software earns its fee

You need the answer during the month, not after it. Time tracking as you work, live project budgets and alerts when a project hits 80% of its hours are things software does well. A spreadsheet only knows what you last entered.

Many people enter data every day. Once a team of ten logs time daily, a shared tool with a mobile app beats asking everyone to send hours to one person.

You need permissions and an audit trail. Software can limit who sees cost rates, record who changed what, and lock closed periods. A spreadsheet can't do this reliably.

You need integrations. If tracked time should turn into invoices, and invoices should flow into your accounting system, connected tools save the copying and the errors that come with it.

You schedule a larger team. Seeing who is free next week across 15 people and 40 projects is a scheduling problem. Scheduling tools are built for it.

Your accounting system already covers part of it. Many accounting systems offer project or tracking-category features, either in the plan or through add-ons. Check what your current plan includes before buying anything. These features often track fees and direct costs well, but may not cost staff hours at an internal rate.

The setup many small agencies end up with

In practice, it's often both. A time-tracking or scheduling tool handles daily entry. Accounting software handles the books. A spreadsheet takes the month's exported totals and answers one question: what did each client contribute after delivery costs?

This works because each tool does one job. The spreadsheet doesn't try to track time, and the time-tracking tool doesn't have to model your cost rates.

What each option costs over three years

The table uses a six-person agency, US-dollar list prices on annual billing, before tax. Prices were checked on Sep 28, 2026, and may change. Each tool does a different job, so this compares the cost of each kind of tool, not features.

Option	What it covers	Listed price	Year 1	3 years
Spreadsheet template (Client Profitability Tracker)	Monthly contribution review by client	US$49 one-time	US$49	US$49
Desktop Excel for one editor, if you don't have it (Microsoft 365 Business Standard)	Office apps, including desktop Excel	US$14.00 per user/month, paid yearly	US$168	US$504
Time tracking and invoicing (Harvest Teams)	Time tracking, expenses and invoicing	US$9 per seat/month, billed annually (US$108 per seat/year)	US$648	US$1,944
Resource scheduling (Float Starter)	Scheduling and capacity	US$84 per scheduled person/year	US$504	US$1,512
Scheduling with time tracking (Float Pro)	Scheduling, capacity and actuals	US$144 per scheduled person/year	US$864	US$2,592

The three-year figures assume the listed price stays the same, which it may not. Taxes, setup, training and add-on modules are not included.

Count your time, not only the subscription

Subscription price is the smaller cost for most small agencies. The larger one is time.

Illustration. If monthly entry and review take you two hours at an internal cost of US$60 an hour, that's US$1,440 a year and US$4,320 over three years. That is more than any subscription in the table. Software doesn't remove this cost; it moves it. Someone still logs time, fixes mislabeled entries and reads the reports.

So compare three things: the price, the hours each option takes each month, and who spends those hours.

A checklist you can run now

A spreadsheet template is likely enough if most of these are true:

• You review client numbers monthly, after the month closes.
• One or two people enter or paste the data.
• You have fewer than about 30 active clients.
• You want to see and check every formula behind a result.
• You'd rather own a file than add another subscription.
• Your hours and costs already come out of other tools as monthly totals.

Software is likely worth it if most of these are true:

• You need budget and hours status during the month, not after it.
• More than a handful of people enter time every day.
• You need permissions, a change history or locked periods.
• Tracked time should become invoices without retyping.
• You schedule ten or more people across many projects.
• You copy the same data between systems every week.

If your answers are split, the combined setup above is usually the safer choice.

What to check before you trust any template

A template earns its place only if the numbers are right. Before you rely on one, from any seller, check:

• Inputs are marked. You can tell at a glance which cells you type in.
• There are check cells. Missing, duplicate or invalid rows are flagged, not silently counted.
• There are no macros, if you plan to open it in Excel for the web or on a Mac.
• It says where it has been tested, with versions and dates, and where it hasn't.
• There is a version number and a changelog, so you know what changed between releases.
• There is a worked example with demo data you can compare your results against.

How Metricvalley tests its workbooks

Every Metricvalley release is tested against written acceptance cases in desktop Excel before it ships, and the results are published. Version 1.1.0-rc1 of the Client Profitability Tracker passed 18 of 18.

The cases include hard ones on purpose: 251 rows added through the table, 31 clients, and missing, duplicate and wrong-month exchange rates. Each environment is marked "tested" or "not yet tested", with the version and date. Today that means Excel 365 on Windows desktop is tested, and Excel for the web, Mac, mobile, LibreOffice and Apple Numbers are not yet tested.

Read the full method on the Testing Standard page.

Where to start

If the spreadsheet list fits your agency, the Client Profitability Tracker shows contribution before overhead by client, project and month, in one of 10 report currencies. It is US$49, one-time, with a 30-day money-back guarantee. You can try the calculations first in the live demo. A free lite edition for businesses working in one currency is planned, with no release date yet.

For the method behind the numbers, read client profitability: contribution before overhead. For the two checks agencies most often do in a spreadsheet, see how to tell when a retainer is underwater and how to price a project so it still pays.

Sources

Prices checked on Sep 28, 2026. US-dollar list prices, annual billing, before tax.

• Harvest pricing, Teams plan: US$108 per seat/year, billed annually (US$9 per seat/month). getharvest.com/pricing
• Float pricing, Starter plan US$84 and Pro plan US$144 per scheduled person/year. float.com/pricing
• Microsoft 365 Business Standard: US$14.00 per user/month paid yearly, or US$16.80 per user/month on a monthly subscription. microsoft.com: Microsoft 365 Business Standard