Quick answer: A business expense spreadsheet is a single ledger where every income and expense entry gets a date, amount, category, business purpose, and receipt. With that ledger you can see where your money goes, separate revenue from profit, and hand clean records to a bookkeeper or tax professional. The 30-day roadmap below takes you from a blank sheet to a weekly review habit and a working dashboard.
Use Your Expense Spreadsheet With a Profit Calculator
Try our interactive freelancer profit calculator, learn how to track business expenses, and compare costs with our break-even model.
The $4,000 Example From “You’re Making Money. So Where Is It Going?”
Companion video note: This article accompanies NoviraLane’s 61-second video “You’re Making Money. So Where Is It Going?” The video isn’t embedded on this page yet. Everything it covers is explained in writing below.
The video describes a business with $4,000 in monthly revenue and four listed expenses: $300 for software, $250 for ads, $100 for payment processing, and $150 for contractors. Those add up to $800, which leaves $3,200 before other costs and taxes. That $3,200 is not take-home pay. It is what remains after only the costs you have listed so far.
Revenue vs Profit: Five Numbers to Keep Separate
- Revenue: total sales before any costs ($4,000).
- Gross profit: revenue minus direct costs of delivering the work. If you treat contractors ($150) and processing fees ($100) as direct costs, gross profit is $4,000 − $250 = $3,750.
- Operating profit: gross profit minus overhead. Subtracting software ($300) and ads ($250) gives $3,750 − $550 = $3,200, counting only the listed costs.
- Cash balance: what is actually in your business account. Unpaid invoices, timing, and loan payments mean this number can differ from profit.
- Take-home profit: what remains after all expenses, taxes, and money you need to reserve. It is unknown here and will be lower than $3,200.
Business Expense Spreadsheet Setup and Formulas
Create one Google Sheets file with four tabs: Transactions, Categories, Dashboard, and Monthly Review. No template file is attached to this article, but you can build the whole thing in about 20 minutes.
Transactions tab columns (A–K)
Date, Vendor, Description, Type (Income/Expense), Category, Amount, Business Purpose, Receipt Link, Account, Tax Review, Month.
Enter every Amount as a positive number and let the Type column decide whether it counts as income or expense. Mixing negative and positive numbers is one of the most common causes of totals that are off by double the error. Add data validation to column D (Income, Expense) and column E (a list from the Categories tab).
Core formulas
Month (in K2, then fill down): =TEXT(A2,"yyyy-mm")
On the Dashboard, type the month you want to review as text in B1, for example 2026-10.
- Revenue (B2):
=SUMIFS(Transactions!F:F,Transactions!D:D,"Income",Transactions!K:K,B1,Transactions!E:E,"<>Sales Tax Collected") - Expenses (B3), with owner draws excluded:
=SUMIFS(Transactions!F:F,Transactions!D:D,"Expense",Transactions!K:K,B1,Transactions!E:E,"<>Owner Draw") - Before-tax remainder (B4):
=B2-B3 - Expense ratio (B5):
=IF(B2=0,"",B3/B2), formatted as a percent
Categories, receipts, and the audit trail
Keep the Categories tab to roughly 10–15 categories, such as Software, Advertising, Payment Processing, Contractors, Supplies, Travel, Owner Draw, Refunds, and Sales Tax Collected. The Receipt Link column connects each row to its source document, which gives you an audit trail. The IRS explains which records to keep and for how long in its recordkeeping guidance. For general rules on what counts as a business expense, see IRS Publication 535. The SBA’s “Manage your finances” guide is another useful bookkeeping primer.
Example Transactions
Revenue comes to $2,500 + $1,500 = $4,000. Counted expenses come to $300 + $250 + $100 + $150 = $800. Because the $1,000 owner draw is excluded, the formula still returns $800, which leaves a $3,200 remainder before taxes. The draw does still reduce your bank balance by $1,000.
Cash runway, reconciliation, and separation
Cash runway estimates how many months your cash would last if revenue stopped. Take a $9,000 balance with $800 in expenses plus a $2,000 monthly draw: $9,000 ÷ $2,800 ≈ 3.2 months. Once a month, reconcile by checking that the spreadsheet balance for each account matches your bank statement. A dedicated business bank account and card make this much easier. Sorting out mixed personal charges later is slow and error-prone.
The 30-Day Roadmap: How to Track Business Expenses
Each task takes 10–30 minutes. Thirty days is enough to build a reliable habit, but don’t expect to master bookkeeping in that time.
Days 1–7: Foundation
- Day 1, Create the file: set up the four tabs. Output: a blank workbook.
- Day 2, Headers: add the 11 column headers. Output: the ledger structure.
- Day 3, Categories: write your category list. Output: a dropdown source.
- Day 4, Validation: add dropdowns for Type and Category. Output: fewer typos.
- Day 5, Gather statements: download last month’s bank and card statements. Output: source files.
- Day 6, Back-enter: log last month’s transactions. Output: real data.
- Day 7, Receipts folder: create a cloud folder and link receipts. Output: an audit trail.
Days 8–14: Consistency
- Day 8, Daily entry: log today’s transactions. Output: the habit begins.
- Day 9, Business purpose: fill in missing purpose notes. Output: clear records.
- Day 10, Separate funds: flag personal charges and move them out. Output: a clean ledger.
- Day 11, Owner draws: recategorize your payments to yourself. Output: an accurate expense total.
- Day 12, Tax Review flags: mark unclear items for a professional. Output: a question list.
- Day 13, Subscriptions: list recurring charges. Output: a cancel/keep list.
- Day 14, Weekly review: compare entries to the bank. Output: zero missing rows.
Days 15–21: Insight
- Day 15, Month column: add the TEXT formula. Output: monthly grouping.
- Day 16, Revenue formula: build the SUMIFS formula. Output: a revenue total.
- Day 17, Expense formula: exclude draws. Output: an expense total.
- Day 18, Remainder and ratio: add both cells. Output: your core KPIs.
- Day 19, Category breakdown: use a SUMIFS for each category. Output: your biggest cost drivers.
- Day 20, Reconcile: match account balances. Output: a verified month.
- Day 21, Monthly Review tab: write three observations. Output: decisions.
Days 22–30: Advanced System
- Day 22, Budget column: set a monthly limit for each category. Output: targets.
- Day 23, Variance: compare budget to actual with a formula. Output: overspend alerts.
- Day 24, Cash runway: add a cash ÷ outflow cell. Output: months of cushion.
- Day 25, Forecast: project the next three months conservatively. Output: a plan.
- Day 26, Tax reserve: track the amounts you set aside. Output: a reserve log.
- Day 27, Chart: add a revenue vs expense chart. Output: a visual trend.
- Day 28, Protect: lock formula cells and enable version history. Output: integrity.
- Day 29, Handoff pack: export the ledger and receipts. Output: bookkeeper-ready files.
- Day 30, Retrospective: schedule your weekly reviews. Output: an ongoing system.
Weekly checklist: every transaction entered, receipts linked, personal items removed, Tax Review flags noted, totals checked against the bank.
Free Spreadsheet vs Bookkeeping Software
Beginner Mistakes
- Treating revenue, or the $3,200 remainder, as take-home pay.
- Counting owner draws or sales tax collected as expenses or income.
- Mixing negative and positive amounts.
- Skipping receipts for small purchases.
- Letting weeks pass between entries.
For accessibility, use clear header names, avoid relying on color alone to signal problems, and freeze the header row.
FAQ
How much should I set aside for taxes?
It depends on your income, entity type, state, and self-employment tax. Many owners set aside a fixed percentage, but that percentage should come from a CPA or enrolled agent. This article is educational only, and NoviraLane is not a tax advisor.
Can I use my personal account?
It’s legal for many sole proprietors, but it makes your records much messier. A separate business account makes reconciliation far easier.
Cash or accrual?
Cash basis records a transaction when money moves. Accrual records it when you earn the income or incur the cost. Most small freelancers start on a cash basis, so confirm which method fits your business with your tax professional.
Which expenses are deductible?
Generally, expenses that are ordinary and necessary for your business. Specifics vary, so use the Tax Review column and ask a professional.
Does sales tax apply to me?
Sales tax rules vary by state and by product or service. GST and VAT are non-US systems. Track sales tax collected in its own category.
Summary and Next Step
Related reading: Learn about selling website projects to small businesses and small-business automation tools. The bookkeeping approach in this guide also works when client projects or software subscriptions are recurring.
A business expense spreadsheet shows where your money goes. In the example, $4,000 in revenue minus $800 in listed costs leaves $3,200 before other costs and taxes. That figure is not take-home profit. Build the four tabs, log every transaction with its receipt, and follow the 30-day roadmap. Start Day 1 today.
