Introduction

Every small business runs on two questions: how much money came in, and how much went out. If you cannot answer both in under a minute, you are guessing about your profit.

Google Sheets can answer both. Free with a Google account and available on any device, it turns a simple list of sales and expenses into a monthly profit picture with a handful of formulas — no accounting software or spreadsheet expertise needed.

This guide shows you how to build a simple sales expense tracker Google Sheets system: the workbook structure, the exact formulas, a short month-end routine, and the signs that it is time to move to dedicated accounting software.

One note first: this article is general record-keeping education, not tax preparation or professional bookkeeping advice, and it does not replace an accountant. Keep personal and business records separate, and talk to a qualified professional about anything tax-related.

Why a Spreadsheet Works for a Small Business

A spreadsheet tracker fits a small business with simple, low-volume transactions — a freelancer with a few dozen invoices a month, an online shop with a few hundred orders. In that range, a spreadsheet is fast, flexible, and honest: every number is visible.

Three ideas make the system work:

• One row per transaction. Every sale and expense gets its own row, with a date. Keep that habit and every total takes care of itself.
• Categories do the thinking. A short list — Supplies, Marketing, Software, Shipping — turns receipts into answers like “how much did I spend on ads?”
• Formulas, not typing. Totals and profit should be formulas that update themselves. Hand-typed totals go stale the moment you add a row.

The Workbook Structure: Four Tabs

Create one workbook with four tabs. Keeping sales and expenses separate keeps the formulas simple and mistakes easy to spot.

1. The Sales sheet

One row per sale. Columns: Date | Invoice or Order ID | Customer | Item or Service | Category | Quantity | Unit Price | Amount | Payment Method | Status.

Enter dates as real dates (for example, 11/14/2026), not as text, and mark each sale Paid or Unpaid.

The Amount column is a formula, never typed by hand: in H2 enter =F2*G2 and copy it down — 3 units at $25 shows $75.

Keep the invoice number in column B consistent with the invoice itself — that link makes chasing unpaid sales possible. Our guide to How to Make an Invoice in Google Sheets shows how to set up the invoice side.

2. The Expenses sheet

One row per business cost. Columns: Date | Vendor | Category | Description | Amount | Payment Method | Receipt (Yes/No).

Two rules: record expenses on the date you paid them, not the date the bill arrived, and never mix personal spending into this tab — a tracker that includes your groceries cannot be trusted. For a separate personal budget, see our guide to How to Track Monthly Expenses Using Google Sheets.

Write descriptions that still make sense in six months: “Canva annual plan” beats “subscription.”

3. The Categories tab

One category per row, in column A. Start short and add categories only when a real expense fits nowhere:

• Sales categories: Products, Services, Digital Downloads, Consulting
• Expense categories: Supplies, Software and Subscriptions, Marketing and Ads, Shipping and Postage, Equipment, Professional Services, Travel, Bank Fees, Other

Ten to fifteen categories is plenty; forty means the system is too complicated to keep using.

Add data validation to the Category columns on both tabs (Data, then Data validation, then Dropdown from a range, pointing at your Categories list) — it stops typos like “Marketing” and “marketting”, the most common reason category totals come out wrong.

4. The Monthly Summary tab

One row per month: Month | Total Sales | Total Expenses | Profit | Profit Margin.

In the Month column, put the first day of the month as a date (for example, 11/1/2026), formatted as “November 2026”.

The Formulas to Use

The formulas below use the layout above: Sales dates in column A, amounts in column H; Expenses dates in column A, categories in column C, amounts in column E. Adjust the column letters if your layout differs.

Total sales and total expenses

The simplest totals use SUM over a whole column:

=SUM(Sales!H2:H)

=SUM(Expenses!E2:E)

An open-ended range such as H2:H includes new rows automatically.

Monthly sales with SUMIFS

To total only one month’s sales, use SUMIFS with a date range. If cell A2 on the Monthly Summary tab holds the first day of the month:

=SUMIFS(Sales!H:H, Sales!A:A, ">="&EOMONTH($A2,-1)+1, Sales!A:A, "<="&EOMONTH($A2,0))

What each part does:

• SUMIFS adds values only when every condition is true. Its syntax is =SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) — the range to sum comes first, the opposite order from SUMIF.
• EOMONTH($A2,-1)+1 is the first day of the month (EOMONTH gives the last day of the previous month, plus one day), and EOMONTH($A2,0) is the last day. The ">="& and "<="& parts join the comparison operator to the date, which is how SUMIFS accepts a date condition.

The matching formula for monthly expenses is the same, pointed at the Expenses sheet:

=SUMIFS(Expenses!E:E, Expenses!A:A, ">="&EOMONTH($A2,-1)+1, Expenses!A:A, "<="&EOMONTH($A2,0))

Note: SUMIFS cannot take MONTH(range) as a criteria range — that returns a #VALUE! error. The EOMONTH date-range approach above is the reliable way to do monthly totals.

Monthly profit and profit margin

Profit is simple subtraction — if B2 is the month’s sales and C2 its expenses:

=B2-C2

Profit margin shows what share of sales you kept:

=IF(B2=0,0,D2/B2)

The IF wrapper avoids a #DIV/0! error in a month with no sales yet. Format the result as a percentage (Format, then Number, then Percent): 20% means you kept $20 of every $100.

Category totals and money still owed to you

To see how much one category cost you in total, use SUMIFS with a text condition. Total spending on Supplies, for example:

=SUMIFS(Expenses!E:E, Expenses!C:C, "Supplies")

Add the date conditions above to make it monthly, and build a category table on the Monthly Summary tab — one row per category, one SUMIFS per row.

Unpaid sales are the easiest money to lose track of. This formula totals every sale marked Unpaid:

=SUMIFS(Sales!H:H, Sales!J:J, "Unpaid")

Put it at the top of the Monthly Summary tab and check it weekly — a forgotten unpaid invoice is a sale that never becomes cash.

A Month-End Routine That Takes 20 Minutes

Do this on the same day every month — the last day of the month, or the first weekend of the next one:

• Enter everything. Go through your bank and card statements and add anything you missed.
• Check the unpaid list. Follow up on every sale still marked Unpaid, and update the Status column when money arrives.
• Save receipts. For every expense row with Receipt marked No, save the receipt — a photo in a folder, or a link in a notes column — then change the row to Yes.
• Read the Monthly Summary. Compare sales, expenses, profit, and margin with the previous month. One odd number is worth investigating; a three-month trend is worth acting on.
• Check the categories. Which expense category grew most this month, and why?
• Set aside money for what is coming. If your summary shows a profit, decide what to do with it before it gets spent — see our guide to How to Set Savings Goals Using a Simple Spreadsheet.

Reconciliation Habits That Keep the Numbers Honest

Reconciliation is a simple check: does the spreadsheet agree with the bank? Do it monthly and it takes minutes; skip it for six months and it takes a weekend.

• Match the totals to your statements. Compare the month’s expenses with what left your business bank account and cards. Small differences usually mean a missed row.
• Match sales to deposits. The month’s sales should line up with business deposits, allowing for timing — a sale paid on the 31st may not clear until the 1st.
• Keep one account for the business. Reconciliation is ten times harder when business and personal money share an account.
• Do not edit old months. If you find a mistake in March, fix it in March and note what changed.
• Back up the workbook. Sheets saves to the cloud automatically, but export a copy (File, then Download, then Microsoft Excel) at the end of each quarter.

Signs a Spreadsheet Is No Longer Enough

A spreadsheet is a starting point, not a destination. Watch for these signs you have outgrown it:

• Hundreds of transactions a month. Manual entry stops being a ten-minute job and starts being a part-time job.
• Invoices, quotes, and payment reminders in one place. A tracker records sales; software manages the whole sales process.
• Employees, payroll, or inventory. Those need their own systems, and a spreadsheet held together with formulas will not keep up.
• Tax time is a scramble. If preparing records for an accountant takes days of cleanup every year, the system costs more than software would.
• More than one person edits the file. Shared spreadsheets work until two people edit the same row at once, or someone overwrites a formula.
• Reports your accountant can use directly. Accountants work with accounting software; at some point handing over a file is not enough.

None of these signs means you did anything wrong — they mean the business grew. If you are just starting out, our guide to How to Start an Online Business With a Small Budget covers keeping early costs low. When you do move on, export your Sheets history first: years of clean records make the switch far easier.

Frequently Asked Questions

What is the best formula for monthly totals in Google Sheets?

Use SUMIFS with a date range built from EOMONTH, as shown in the formulas section above. Do not put MONTH() inside SUMIFS — it returns a #VALUE! error, because SUMIFS needs a real range as its criteria range.

Should sales and expenses be on the same sheet or separate sheets?

Separate sheets: one tab for sales and one for expenses keeps the formulas simple, makes mistakes easy to spot, and lets each tab have its own columns.

How do I calculate profit in Google Sheets?

Profit is total sales minus total expenses: =B2-C2, where B2 is the month’s sales and C2 is the month’s expenses. Profit margin is profit divided by sales, =IF(B2=0,0,D2/B2), formatted as a percentage. Both belong on the Monthly Summary tab so they update automatically.

Can I use Google Sheets instead of accounting software?

For a small business with simple, low-volume transactions, yes — many freelancers and side businesses run on exactly this setup. Once volume grows, or you need invoicing, payroll, inventory, or accountant-ready reports, dedicated accounting software is the better tool.

The Bottom Line

Tracking sales and expenses in Google Sheets comes down to four tabs, a few formulas, and one habit: one row per transaction with a real date, SUMIFS for monthly totals and category breakdowns, and a month-end check against your bank statements — plus following up on anything unpaid.

Use this structure for a month before adding anything to it. A simple tracker you actually maintain beats a complicated one you abandon in February — and when the spreadsheet can no longer keep up, that is good news: the business outgrew it.