Taxes and records

Tracking Business Expenses Without Fancy Software

A simple system for tracking business expenses with one bank account, a five column spreadsheet, and your phone camera. No software subscription needed.

By the FreeInvoices.co team | Updated August 9, 2026 | 4 min read

You don't need accounting software to track business expenses. You need one clean account, a five column spreadsheet, and the camera on your phone, held together by a fifteen minute weekly habit. Plenty of healthy service businesses run on exactly that for years. Software earns its keep at a certain size, and we'll get to when. Until then, a tidy manual system beats an expensive tool you never open.

Give Every Expense One Front Door

The biggest upgrade isn't a tool, it's routing every business purchase through one dedicated account or card. Do that and your bank statement becomes a nearly complete expense list on its own. Skip it and every month means picking business costs out of a lineup of groceries and streaming subscriptions, which is exactly the chore that makes people quit tracking altogether. One card for the business also means one renewal calendar, which is how you finally notice the tool you stopped using in March but kept paying for. If your money is still mixed, fix that first; the full case is in why a separate business bank account pays for itself.

The Five Column Spreadsheet

Date, vendor, amount, category, note. That's the entire schema, and it's enough to file taxes, answer an auditor, and see where the money goes. No formulas required beyond a sum at the bottom, though a monthly subtotal tab is a nice addition by summer. Start it in January or start it today; a sheet that begins in July still beats the sheet that never starts.

Keep categories to a dozen or fewer: supplies, software, insurance, advertising, vehicle, meals, equipment, professional services, fees, other
Loosely mirror the expense buckets on a US Schedule C, which turns tax prep into mostly a copy job
Don't agonize over edge cases. Consistent and slightly imperfect beats precise and abandoned every time

Photograph Receipts the Day You Get Them

Bank statements prove you spent money; receipts prove what you bought. You want both, because thermal paper fades to blank and a statement line reading “CITY HARDWARE 84.12” gives no hint whether that was job site lumber or a garden hose. Snap the photo before you leave the parking lot and drop it in a cloud folder sorted by year. For meals and travel, add who and why, since those categories draw the most questions later. The receipt answers what; your note answers what for.

The Friday Fifteen

1Open the bank feed and the spreadsheet side by side
2Add the week's transactions. For most solo businesses that's five to twenty rows
3Match receipt photos to rows, renaming files as you go
4Flag anything you don't recognize while it's fresh enough to remember
5Glance at the month's running total so nothing sneaks up on you

Fifteen minutes weekly is the entire trick. Expense tracking fails as an annual archaeology project and succeeds as a small habit. April-you inherits either a labeled folder and a finished spreadsheet, or a shoebox and a sense of dread. Same business, same receipts, very different week.

The Note Column Earns Its Keep

Write notes a stranger could categorize from: “lunch, kickoff meeting, Maple Grove retainer” instead of a bare $23. Eight months from now, you are that stranger.

What a Year of This Buys You

Come filing time, you hand over category totals instead of a pile, and deductions stop leaking. A forgotten $30 monthly subscription is $360 of deductions you never claimed, and there's no refund for money nobody wrote down. Clean records also feed better decisions, since you'll actually know whether the van, the software stack, or the subcontractors are eating your margin. Deduction rules shift and vary by state and country, so have a local accountant sanity check your categories once. After that, the system mostly runs itself, and the numbers flow straight into the routine described in simple bookkeeping for service businesses.

When to Graduate to Software

Move up when the spreadsheet starts costing you: more than a hundred transactions a month, contractors or employees to pay, inventory on shelves, sales tax filings in several states, or an accountant asking for reports the sheet can't produce. The migration is painless precisely because your records are already structured. Until one of those things happens, don't let anyone shame you about the spreadsheet. It's doing the job.

Frequently asked questions

Can my bank statement alone serve as my expense records?

It's a solid backbone, but thin on its own. A statement proves you paid and when, not what you bought or why it was business related. Receipts and a short note fill that gap, and for categories like meals the context is the whole game. Statement plus receipt photo plus a one line note covers nearly every question anyone will ask.

What actually counts as a business expense?

The IRS standard is “ordinary and necessary”: common in your line of work and helpful for doing it. Supplies, software, insurance, advertising, professional fees, and work mileage all typically qualify. Gray zones like the home office, mixed use phones, and meals have specific rules attached, so log them anyway and let an accountant sort the edge cases at filing time.

How should I handle cash purchases?

Treat them as the exception and document them harder. Get a receipt every time, photograph it on the spot, and log it the same day, because there's no bank feed to catch what you forget. Remember an ATM withdrawal isn't an expense; only the purchase is. If a vendor can't produce a receipt, write yourself a dated note with the amount and purpose.