Small Business Bookkeeping in Google Sheets: The Complete Setup Guide
If you run a small service business — trades, freelancing, cleaning, consulting — you don't need accounting software. You need a system you'll actually use: one place where every dollar in and every dollar out gets logged, and where profit calculates itself. Google Sheets does this beautifully, for free. Here's the full setup.
Why a spreadsheet beats software for most small businesses
Accounting platforms are built for businesses with payroll, inventory, and accrual accounting. A solo operator's books are simpler: money in, money out, categorized. A spreadsheet gives you that with zero monthly fee, no learning curve, and total control — and when tax time comes, your accountant will be happier with a clean spreadsheet than a half-configured software account.
Step 1: Set up your two logs
Create two tabs: Income and Expenses.
Income log columns
- Date — when the money arrived (not when you invoiced)
- Client / Source — who paid you
- Description — what the payment was for
- Amount
Expense log columns
- Date, Vendor, Description, Amount
- Category — this is the important one (next step)
Step 2: Pick 8–12 expense categories and stop there
Too many categories is the #1 reason bookkeeping systems die. Start from this list and cut what doesn't apply:
| Category | Typical examples |
|---|---|
| Materials & supplies | Parts, consumables, job materials |
| Equipment & tools | Anything durable you buy to do the work |
| Vehicle | Fuel, maintenance, parking |
| Software & subscriptions | Design tools, booking apps, phone plan share |
| Insurance | Liability, equipment |
| Marketing | Ads, business cards, website |
| Professional services | Accountant, legal |
| Fees | Bank, payment processing, marketplace fees |
Use a dropdown for the category column (Data → Data validation in Sheets) so every entry is consistent — a typo like "Suplies" quietly breaks your totals.
Step 3: The three formulas that run everything
On a Dashboard tab:
- Total income:
=SUM(Income!D:D) - Total expenses:
=SUM(Expenses!D:D) - Profit: subtract one from the other. Add
=SUMIF(Expenses!E:E,"Vehicle",Expenses!D:D)per category to see where money actually goes.
That's genuinely it. Everything else — charts, monthly views, margins — is decoration on top of those three numbers.
Step 4: The habit that makes it work
Books die from backlog, not from bad formulas. Two rules:
- Log it the day it happens. A 30-second entry beats a three-hour catch-up session.
- Do a 10-minute Friday review. Scan the week, fix categories, glance at profit.
The best bookkeeping system is the one that's always current — and that's about a low-friction logging habit, not features.
Common mistakes to avoid
- Mixing personal and business money — open a separate account, even a free one.
- Logging invoices as income — log money when it arrives; unpaid invoices belong in an invoice tracker, not your income log.
- Skipping small expenses — $12 here and $18 there is often 10%+ of real costs.
Want the whole back office in one download — bookkeeping plus invoices, mileage, a client CRM, and expense reports? That's the Small Business Owner's Toolkit. And if you drive for work, pair it with the mileage log guide.