VickeryFinance • Small Business Finance

How to Track Business Expenses in Google Sheets

You do not need accounting software to track expenses well. You need one sheet, the right columns, categories that match a tax return, and a ten-minute weekly habit.

5 columnsdate, vendor, category, amount, payment method

10 minutesthe weekly upkeep this system needs

$644the worked month's total, fully categorized

Why most spreadsheet expense trackers fail

They fail in February, not in January. The sheet itself is easy; the failure is a category list invented on the spot ('stuff', 'business', 'misc') that maps to nothing at tax time, and entries that stop happening by week three. The fix is structural: use the expense categories a Schedule C actually asks for, and make the sheet answer three questions at any moment — what did I spend, on what, and how much of the year is spoken for.

Google Sheets earns the job for most solo businesses because it is free, shared, and available on the phone at the moment a receipt exists. Everything below works identically in Excel.

Set up the tracker in fifteen minutes

One tab for entries, one for the summary. Nothing fancier survives contact with a busy year.

Create the entry tab with five columns. Date, Vendor, Category, Amount, Payment method. Add a sixth — Notes — if you attend events or buy for specific jobs. One row per transaction, no exceptions.
Load the category list before you need it. Advertising, Car and truck, Insurance, Legal and professional, Office expenses, Rent, Supplies, Taxes and licenses, Travel, Meals, Utilities, and Other. These mirror the lines a sole proprietor's return uses, so year-end is a pivot table, not a translation project.
Enter on a weekly rhythm. Ten minutes, same day each week, from the bank and card feeds you already check. Enter from statements, not receipts — the statement is the complete list; receipts are the proof you file behind it.
Build the summary tab once. A SUMIFS per category per month gives you the running picture and the year-end totals in the same view. Total by category, total by month, and a year-to-date column.
Reconcile monthly. The sheet's monthly total must agree with what actually left the accounts. If it does not, an entry is missing or doubled — catch it in the month it happened.

Keep business and personal in separate accounts first

No tracker survives a mixed account. If business and personal spending run through the same card, every entry needs a judgment call and tax time becomes an audit of your own life. A separate business checking account and card — even at the same bank — turns tracking into copying, and the categorization question becomes the only question. This single change does more for clean books than any template, including ours.

One week of entries, categorized

A freelance designer's first week of March. Five entries, five categories, and the summary tab already knows the month is at $644:

Date	Vendor	Category	Amount
Mar 3	Software subscription	Office expenses	$89
Mar 4	Fuel station	Car and truck	$214
Mar 5	Office supply store	Supplies	$156
Mar 6	Mobile carrier	Utilities	$65
Mar 7	Ads platform	Advertising	$120
	Week total		$644

Rules that keep the sheet trustworthy

Four habits separate a tracker from a pile of rows:

Never edit a past month's rows to fix a mistake — add a correcting entry dated today, so the sheet tells the truth about what happened and when you fixed it.
Photograph paper receipts into one cloud folder named by month. The sheet says what; the folder proves it.
Mileage is not an expense row — keep a separate mileage log (date, destination, business purpose, miles) and let the summary apply the standard rate at year-end.
If a category needs a subcategory twice, it deserves its own category next year — not this year. Mid-year category changes break comparisons.

Want the tracker already built?

The $29 Freelancer Income and Expense Template is this system finished: entry tabs with the category list loaded, a quarterly tax estimator that reads your entries, and summaries in the format a return wants — in Google Sheets and Excel. The Month-End Close Template adds the monthly reconciliation and review routine around it.

Freelancer Template — $29 Month-End Close Template — $29

Frequently asked questions

Should I track income in the same sheet?

Yes — a parallel income tab (date, client, invoice, amount, received date) turns the workbook into a full set of solo-business books: profit is income minus the expense summary, and unpaid invoices are visible at a glance.

How do I handle cash expenses?

Enter them the day they happen, from the phone, and keep the receipt photo. Cash is where trackers leak; same-day entry is the whole defense.

Will my tax preparer accept a spreadsheet?

Preparers accept organized records in any format — a categorized annual summary with receipts behind it is better than a shoebox and equal to most software exports. Ask yours what summary format they prefer before year-end, not during it.