Stop maintaining a spreadsheet just to split business from personal spending

Almost every freelancer starts the same way: a Google Sheet with columns for date, amount, category, and a note. It works great for about three weeks. Then a busy week happens, six receipts pile up, and by the time you sit down to enter them you're guessing at what half of them were even for.

The spreadsheet isn't the problem — the delay is

A spreadsheet is a perfectly good place to store expense data. It's a terrible place to capture it, because capturing it requires you to stop what you're doing, open an app, find the right row, and type into several fields in the right format. That's maybe 30 seconds of friction. Multiply by every coffee, every Uber, every client lunch, and the honest truth is most people log the big stuff and quietly let the small stuff slide.

Small stuff adds up faster than it feels like it should. A €4 coffee here, a €12 parking fee there — none of it feels worth interrupting your day for, and none of it gets logged, and by month-end your actual spending and your spreadsheet have quietly diverged by a meaningful amount.

Business vs. personal is a decision, not a category

The other place spreadsheets fall down is the business/personal split specifically. It's easy in theory — was this for the business, or not? — but in the moment, sitting at a café with a receipt in hand, it takes actual thought: was that lunch really a client meeting, or did you just happen to grab lunch with a friend who's also a client? People either skip the decision (dumping everything into "uncategorized," which just moves the problem to later) or make it inconsistently, which is worse than not tracking at all if you ever need the numbers to hold up.

The fix isn't a better spreadsheet template. It's making that decision take one tap instead of a moment of reflection, and making it happen at the point of spending, not during a Sunday-night cleanup session three weeks later when you've forgotten the context entirely.

What actually works

The pattern that holds up long-term has three properties: it's faster than opening a spreadsheet, it doesn't require remembering a category taxonomy, and it doesn't punish you for logging something small. In practice that usually means:

• Capture in plain language. "12.50 coffee with client" is faster to type (or say) than filling in four spreadsheet columns, and it's just as useful once something parses it into structured data for you.
• Photograph receipts instead of transcribing them. A receipt has every number you need already printed on it — the only job left is getting it out of your pocket and into a system before it becomes an unreadable ball of paper.
• Tag business/personal at capture, not at review. The context is free in the moment and expensive to reconstruct later.

Whatever you end up using, the actual habit that matters is the same one: capture immediately, decide business-or-personal while you still remember why, and let whatever tool you use handle the organizing. The spreadsheet was never really the point — it was just the only option most people knew about.