How to Build a Small Business Income and Expenses Spreadsheet
A small business income and expenses spreadsheet needs to do exactly three things: log money in, log money out, and show your profit updating itself as you type. Everything else is decoration. Here's the exact setup in Google Sheets (or Excel) — the tabs, the columns, and the three formulas that run it — so you can see whether you're actually making money this month, not next April.
Why a spreadsheet, not accounting software
If you're a solo operator or a small team — freelancing, trades, a shop, consulting — you don't have payroll runs and inventory accounting to manage. You have money coming in and money going out, and you need it categorized and totaled. A spreadsheet does that for free, with zero learning curve and total control, and it hands your accountant a clean file at tax time. Software earns its monthly fee only once your business is genuinely complex.
The structure: three tabs
Keep it to three tabs so the system stays simple enough to maintain:
- Income — every payment you receive
- Expenses — every dollar you spend on the business
- Dashboard — totals and profit, calculated automatically
Income tab columns
| Column | What goes in it |
|---|---|
| Date | When the money arrived — not when you invoiced |
| Client / Source | Who paid you |
| Description | What the payment was for |
| Amount | The number (keep it a plain number, no "$" typed in) |
Expenses tab columns
| Column | What goes in it |
|---|---|
| Date | When you paid |
| Vendor | Who you paid |
| Description | What it was |
| Category | Pick from a dropdown — this is the important one |
| Amount | The number |
Pick 8–12 expense categories and stop there
Too many categories is the number-one reason these spreadsheets get abandoned. Start from this list and cut whatever doesn't apply to you:
- Materials & supplies
- Equipment & tools
- Vehicle & travel
- Software & subscriptions
- Insurance
- Marketing & advertising
- Professional services (accountant, legal)
- Fees (bank, payment processing, marketplace)
- Office / workspace
- Other
Then make the Category column a dropdown: select it, then Data → Data validation → dropdown and paste your list. Now every entry is consistent — one typo like "Suplies" would quietly split your totals and hide money.
The three formulas that run everything
On the Dashboard tab, add these:
- Total income:
=SUM(Income!D:D) - Total expenses:
=SUM(Expenses!E:E) - Profit:
=(total income cell) - (total expenses cell)
That's the whole engine. To see where the money goes, add one line per category with
=SUMIF(Expenses!D:D,"Vehicle & travel",Expenses!E:E) — copy it down and change the
category name in quotes. Now you have a spending breakdown that updates itself.
Make it readable at a glance
- Freeze the header row (View → Freeze → 1 row) so titles stay put as the log grows.
- Conditional formatting on Profit: green when positive, red when negative — an instant health check every time you open it.
- A monthly view: add a Month column with
=TEXT(A2,"YYYY-MM")and use it in your SUMIFs to compare month over month.
The habit that makes it work
These spreadsheets fail from backlog, not from bad formulas. Two rules keep it alive:
- Log it the day it happens. A 30-second entry beats a three-hour, receipt-shoebox catch-up you'll keep postponing.
- Do a 10-minute Friday review. Scan the week, fix any categories, glance at profit.
The best income and expenses spreadsheet is the one that's always current — and that's a logging habit, not a feature list.
Common mistakes to avoid
- Logging invoices as income. Record money when it arrives; unpaid invoices belong in an invoice tracker, not your income tab.
- Mixing personal and business money. Use a separate account, even a free one — it makes this spreadsheet honest and tax time painless.
- Skipping small expenses. $9 here and $14 there is often 10%+ of real costs, and it's all deductible.
Want the whole back office, not just the books? The Small Business Owner's Toolkit pairs this with invoices, a client CRM, mileage and expense reports. Then keep the two lenses on your money sharp with bookkeeping in Google Sheets, the right expense categories, and cash flow tracking.