The complete guide · Start here

How to Run Your Small Business Finances in Google Sheets

You don't need accounting software to run the money side of a small or one-person business. A handful of well-built Google Sheets — logs for money in and money out, a dashboard that adds it up, an invoice tracker, a mileage log, and a tax set-aside — do the whole job for free, work on your phone, and hand your accountant a clean record in April. This is the complete system, start to finish, with a deep guide and a free calculator for every piece.

Why Google Sheets beats software for most small businesses

Accounting platforms like QuickBooks or Xero are built for companies with payroll, inventory, and accrual accounting. If you're a freelancer, contractor, solo service business, or side-hustler, your books are far simpler: money came in, money went out, sorted into categories. A spreadsheet models that perfectly — with no monthly fee, no learning curve, and total control. You own the file, it opens on any device, and when tax time comes your accountant is happier with a clean spreadsheet than a half-configured software account.

Google Sheets specifically wins on three things: it's free, it autosaves to the cloud so your books are never trapped on one laptop, and it's easy to share (view-only) with an accountant or partner. Excel does everything Sheets does and a bit more on large datasets — if you're deciding between them, we broke it down in Google Sheets vs. Excel for small business. Either works; the system below is identical in both.

The one thing a spreadsheet asks of you that software automates is data entry — you type the transactions in. That sounds like a downside, and it's actually the secret: the five seconds you spend logging a $40 supply run is also the moment you notice where your money goes. The businesses that stay profitable are the ones that feel their spending, not the ones that outsource that feeling to a bank feed they never read.

The core system: two logs and a dashboard

Everything starts here, and honestly, this is 80% of what most small businesses need. Three tabs:

• Income — Date, Client/Source, Description, Amount. Log money when it arrives, not when you invoice.
• Expenses — Date, Vendor, Description, Amount, and the important one: Category.
• Dashboard — where three formulas do the work: =SUM(Income!D:D) for total income, =SUM(Expenses!D:D) for total expenses, and the difference for profit. Add one =SUMIF(Expenses!E:E,"Vehicle",Expenses!D:D) per category to see exactly where money goes.

That's a complete bookkeeping system. Everything else — charts, monthly views, tax estimates — is built on top of those three numbers. We walk through the whole build, formulas and dashboard included, in the full guide to small business bookkeeping in Google Sheets, and there's an even leaner version in the income and expenses spreadsheet. Once your books produce a profit figure, turning it into a formal profit and loss statement is a copy-paste.

Expenses and the Schedule C categories that make tax time trivial

The single decision that makes or breaks a small-business bookkeeping system is your expense categories. Get them right and tax season is a copy-paste; get them wrong (too many, or inconsistent spelling) and your totals quietly break. Two rules: keep it to 8–12 categories, and match them to the IRS Schedule C buckets so your deductible total per category is always ready.

Use a data-validation dropdown for the category column so "Software" doesn't become "software" one day and "subscriptions" the next — consistent categories are what let a single SUMIF total each bucket. The full category list and what belongs in each is in small business expense categories explained, and the day-to-day method is in how to track business expenses for taxes.

Why it matters so much: your tax is calculated on your net income — revenue minus deductible expenses — so every category you track is money you don't overpay tax on. The full list of what solo businesses can legitimately deduct is in the self-employed tax deductions checklist. The most-missed one, every year, is driving — which gets its own system below.

Getting paid: invoicing and cash flow

Bookkeeping tells you what happened; invoicing is how you make the good things happen. A professional invoice — the word "Invoice," a unique number, your details and the client's, a real due date, itemized lines, the bold total, and how to pay — gets you paid faster and reads as a business, not a hobby. The full step-by-step, including how to chase late payers without the awkwardness, is in how to invoice as a freelancer.

The half everyone skips is tracking paid vs. owed. A running list with an invoice number, client, amount, due date, and a Paid? status — plus one =SUMIF(Status,"Unpaid",Amount) — tells you exactly how much money is owed to you right now. That number is the heartbeat of a freelance business, and keeping an eye on it is the core of tracking cash flow in a small business.

Before you can invoice a rate, you have to set one that covers your taxes and expenses. The free freelance hourly rate calculator works backward from the take-home you actually want.

Mileage and vehicle costs — the most-lost deduction

If you drive for work — client visits, job sites, supply runs — those miles are usually deductible and they add up fast. They're also the most commonly lost deduction, because the log either doesn't exist or wouldn't survive scrutiny. The fix is a four-column sheet — date, business purpose, start odometer, end odometer — with one formula for miles, filled in at the wheel (after you park) rather than reconstructed in April. The full standard is in how to keep a mileage log the IRS will accept.

Most solo businesses use the standard mileage rate: business miles × the IRS rate for the year, with fuel, maintenance, and depreciation baked in. See what your miles are actually worth with the free mileage deduction calculator — at a ~30% tax rate, every logged mile is real money back.

Taxes: set aside as you go, pay quarterly

The tax surprise that sinks first-year freelancers is entirely avoidable: set aside 25–30% of your net income the moment it lands, in a separate account, and the April bill is already covered. The exact percentage depends on your income and state — we show how to pick your number in how much to set aside for self-employed taxes.

Self-employed people generally also pay taxes four times a year, not once — the IRS wants estimated payments quarterly. Miss them and you can owe a penalty even if you pay in full in April. The schedule and how to calculate each payment is in quarterly estimated taxes for the self-employed. To turn your profit into an actual set-aside and quarterly figure in one shot, use the free self-employed tax calculator — it handles self-employment tax and income tax together.

Pricing and profit — so the work is worth doing

All the bookkeeping in the world won't save a business that prices below its costs. Two ideas do most of the work. First, margin is not markup: margin is profit as a percent of your price; markup is profit as a percent of your cost. A 50% markup is only a 33% margin. Price off margin, because margin is what's left to cover overhead and pay you. The free profit margin calculator shows both so you can't mix them up.

Second, price the whole job — materials, hours, overhead, and a real profit on top — not just your costs plus a guess. For trades and project work, how to price a job without losing money walks through it; for digital and handmade sellers, how to price your Etsy products covers fees and the margin that survives them.

The one habit that keeps the whole thing alive

Here's the truth no template can fix for you: books die from backlog, not from bad formulas. The best system is the one that's always current, and that's about a low-friction logging habit, not features. Two rules carry it:

1. Log it the day it happens. A 30-second entry beats a three-hour catch-up session, and you actually remember what a charge was for.
2. Do a 10-minute Friday review. Scan the week, fix any categories, glance at profit and your outstanding-invoice total. That's it.

Do those two things and every number in this guide stays true without ever becoming a chore. Skip them, and the fanciest dashboard in the world shows you last quarter's fiction.

Five mistakes that quietly break a spreadsheet system

Almost every failed set of books fails in one of these five ways. None are about formulas — they're about habits and structure, which is exactly why a template alone doesn't fix them:

1. Mixing personal and business money. When one account pays for groceries and job materials, every month starts with untangling. Open a separate business account — even a free one — and the sorting mostly does itself.
2. Too many expense categories. Thirty categories feels thorough and guarantees you'll stop sorting by March. Eight to twelve, matched to Schedule C, is the sweet spot.
3. Free-typing categories instead of a dropdown. "Supplies," "supplies," and "Suplies" are three different buckets to a SUMIF, and your totals silently drift. A data-validation dropdown fixes it permanently.
4. Logging invoices as income. Money you've billed isn't money you have. Log income when it arrives; unpaid invoices belong in the invoice tracker, not the income log — otherwise your profit and your bank balance tell different stories.
5. Skipping the small stuff. A $12 app here and an $18 supply run there is often 10%+ of real costs — and every skipped expense is a skipped deduction you pay tax on for no reason.

Notice the pattern: the failures are upstream of the math. Get the account, the categories, the dropdown, and the daily habit right, and the spreadsheet part is genuinely easy.

DIY vs. done-for-you

Every system on this page is something you can build yourself for free, and the guides above show you exactly how — that's genuinely the point. Some people would rather skip the building and start logging today, with the categories, formulas, and dashboard already wired up and tested. If that's you, two options:

Want the whole back office in one download — bookkeeping plus invoicing, mileage, a client CRM, and expense reports? That's the Small Business Owner's Toolkit. And every workbook we ship has its formulas verified in code before launch — a pretty dashboard with a wrong total is worse than none.

When a spreadsheet is enough — and the signs you've outgrown it

A spreadsheet is not a lesser version of accounting software; for a solo or micro business it is often the better tool — free, instant, private, and infinitely flexible. The whole system on this page runs on three functions and a logging habit, and it will carry most freelancers, contractors, and single-owner shops for years. The honest question isn't "spreadsheet or software," it's "which one matches where my business actually is right now."

A spreadsheet is genuinely enough when: you're a sole proprietor or single-member LLC; you bill cash-basis (money counts when it moves, not when it's invoiced); you have no payroll, or one or two contractors you pay by transfer; you don't carry inventory you need to value; and your monthly transaction count is in the dozens, not the hundreds. That describes the large majority of new small businesses, which is exactly why we build the templates.

The five signs you've outgrown it — and dedicated software (or a bookkeeper) starts earning its monthly fee:

1. Payroll. The moment you have real employees with withholding, a spreadsheet can't keep up with tax filings and pay runs — this is the clearest graduation line.
2. Inventory that must be valued. If cost-of-goods and stock levels drive your numbers, you want software that tracks them automatically.
3. Accrual accounting. When you need to recognize income when earned and expenses when incurred (not when cash moves) — often once you pass a revenue threshold or take on investors — accrual is hard to do reliably by hand.
4. Volume. Hundreds of transactions a month turns "log it the day it happens" into a part-time job; bank-feed automation pays for itself there.
5. Other people need in. An accountant, a partner, or a lender who wants standardized reports is easier to serve from software than from a personal sheet.

Notice that none of these is about the spreadsheet being "unprofessional" — they're about specific capabilities (payroll, inventory, accrual, automation, standardized reporting). Until you hit one, a well-built sheet is easier to keep current, and a system you actually keep current beats a powerful one you abandon. We lay out the full trade-off, honestly, in spreadsheet vs. accounting software — including the cases where we'd tell you to pay for the software.

The full guide library

Every piece of the system, in depth. Bookmark this page as your hub.

The trackers and calculators here are organizational tools to help you plan — not tax, financial, or legal advice. For anything tax-specific, confirm the details with a qualified professional.

Quick FAQ

Can you really run a small business's finances in Google Sheets?

Yes — for most solo and micro businesses it's simpler and cheaper than accounting software. Two logs (income and expenses) plus a dashboard give you live profit and per-category totals; separate sheets handle invoices and mileage. You outgrow it only once you add payroll, inventory, or accrual accounting.

What do I actually need to track?

Five things: income, expenses (categorized to IRS Schedule C), invoices (paid vs. owed), business mileage, and a running tax set-aside. Each has a dedicated guide and a free calculator linked above.

How much should I set aside for taxes?

A safe default is 25–30% of your net (after-expense) income, moved to a separate account as money comes in, with estimated payments made quarterly. Your exact percentage depends on income and state — the self-employed tax calculator estimates it for you.

Is Google Sheets or Excel better for this?

Both run the identical system. Google Sheets is free, autosaves to the cloud, and is easy to share; Excel has an edge on very large datasets. Pick whichever you already use — our templates come in both.

Do I need to be good at spreadsheets?

No. The whole system rests on three functions — SUM, SUMIF, and COUNTIF — and each guide gives you the exact formula to paste. If you can type a transaction into a row, you can run this.