Home / Blog / Business From a Spreadsheet
How-to · 2026

How to Run Your Business From a Spreadsheet

Thousands of real businesses — including some doing well over six figures — run on a single Google Sheet or Excel file. The question isn't whether a spreadsheet can do it. It's whether yours is structured to hold up as the data grows.

By the Quiriz Team · Published July 31, 2026 · 6 min read

A Reddit thread in r/smallbusiness said it best: "My entire business (£70k/month) is basically run on one huge Google Sheet — am I doing this wrong?" The top answer: no. The follow-up answers: it depends on how the sheet is structured. Here is how to structure it so it holds up.

1. One sheet for raw data — no summaries, no formatting

Create a sheet called Transactions or Data. Every row is one event: a sale, a payment, an expense. Columns are: Date, Type, Description, Client or Vendor, Category, Amount. Never put a running total or a formatted header in this sheet. Raw data stays raw. This is the most important structural decision you can make — everything else depends on it.

2. A separate sheet for summaries

Add a Summary or Dashboard sheet. Every number here comes from a formula, never from manual entry. Use SUMIFS to pull totals:

=SUMIFS(Data[Amount], Data[Type], "Revenue", Data[Date], ">="&DATE(2026,7,1), Data[Date], "<"&DATE(2026,8,1))

This gives you July revenue without touching the data. Change the month and it recalculates. Add a row per month and you have a running P&L.

3. Date-aware formulas that update automatically

Hard-coded date ranges break the moment the month changes. Use TODAY() to keep ranges rolling:

Drop these in your Summary sheet and they stay current without touching them.

4. Conditional formatting to spot problems

On your Summary sheet, add a column for "Target" next to each category total. Then use conditional formatting — Home → Conditional Formatting → New Rule → Use a formula — to flag rows where actual is below target. Red means below, green means above. One glance replaces ten minutes of checking.

5. The one signal it's time to go further

A well-structured spreadsheet can carry a business a long way. The moment it can't is specific: when someone asks a reasonable question — "how much did client X pay us in Q1?" or "what's our margin on product Y?" — and the answer takes more than two minutes to find. That's not a data problem. It's a query problem. The data is there; it's just not easy to reach.

That's the moment to add a query layer on top of the spreadsheet rather than switching systems entirely. You keep your data where it is, and ask questions of it in plain English instead of building a new SUMIFS formula every time.

The structural rules here also apply to Google Sheets. SUMIFS, date formulas, and conditional formatting all work identically in Sheets — and the raw-data-separate-from-summaries rule matters even more, since Sheets files are often shared with multiple editors.

Ask questions about your business spreadsheet

Connect your Google Sheet or upload your Excel file, ask a question in plain English, and get the answer in seconds. No new formulas, no pivot tables. Free to start.

Try Quiriz free →

Frequently asked questions

Is running a business from a spreadsheet a bad idea?
No. Spreadsheets are free, flexible, and genuinely capable — most small businesses do not need dedicated accounting or CRM software until they're well into six figures of revenue. The risk isn't the tool, it's an unstructured sheet that turns into a mess of manual totals and merged cells.
What should I track in a business spreadsheet?
At minimum: revenue (date, client, amount, category), expenses (date, vendor, amount, category), and invoices outstanding. For product businesses, add inventory. For service businesses, add project status. Keep every row as one transaction — no running totals in the raw data.
When should I switch from a spreadsheet to accounting software?
The clearest signal is time: when looking up a single answer takes five or more minutes, or when you're copying data between files. That's when the overhead of the spreadsheet exceeds the convenience. Most small businesses can go 18–24 months on a well-structured sheet before needing QuickBooks or Xero.
What is the biggest mistake people make with business spreadsheets?
Mixing raw data with summaries in the same sheet. When totals live next to transactions, the sheet becomes fragile — every new row risks breaking a formula, and sorting the data breaks the layout. Keep data in one sheet and summaries in another.