Freelancer Bookkeeping Basics: A No-Spreadsheet Setup

Bookkeeping is the part of freelancing nobody signs up for, and the part that bites hardest at tax time. You don't need accounting software or a wall of spreadsheet tabs. You need four habits and a way to capture receipts before they fade. Here's the whole setup.

Separate your money first

Before any bookkeeping trick, do one structural thing: open a second bank account for your freelance work and route all client income and business spend through it. This single step does more for clean books than any app. When personal and business money share an account, every month becomes a forensic exercise in remembering whether that coffee was a client meeting or a Saturday. Keep them apart and your business account statement is most of your bookkeeping — every line is already a business transaction. Add a dedicated card for the same account and you never have to untangle a mixed purchase again.

Capture receipts as you go, not at tax time

The classic freelancer failure is the shoebox: a year of receipts saved for "later," where later means April, and by April the thermal paper has faded to a blank gray strip. Bank statements tell you an amount was spent, but not what for or how much was tax — and that's exactly what a deduction needs to survive review. The fix is to capture each receipt the moment it lands in your hand:

1. Photograph it right there — crumpled, curled, or faded is fine.
2. Let the scan pull the merchant, date, total, tax, and line items.
3. Confirm the category and get on with your day.

Expense Rabbit reads any receipt and turns it into structured data with a confidence score, so you're checking its work rather than typing everything by hand. It runs on iPhone and the web from one synced account, which matters for freelancers who buy supplies on their phone and pay for software at a desk. The record is permanent and searchable the moment you capture it.

Categorize so tax time is a filter, not a project

A category is just a bucket that ties a purchase to why it's deductible: software, supplies, travel, meals, home office, contractor payments. You don't need a fancy chart of accounts — a dozen plain-language buckets covers most solo freelancers. The point is consistency. If you tag spend as it happens, your year-end "bookkeeping" collapses into filtering by category and reading a total, instead of reconstructing twelve months from memory. When something's genuinely half personal, split it or note it now, while you still remember the context.

Set aside for taxes before you spend

Employees have tax withheld automatically; freelancers don't, which is why a good year can turn into a nasty spring bill. Treat a slice of every payment as money that was never yours. A common rule of thumb is to move 25–30% of each invoice into a separate savings account the day it clears, then forget it exists until you file — but your real rate depends on your income and where you live, so check with a local tax pro or your tax authority's guidance. The mechanism matters more than the exact number: automate the transfer so the decision is made once, not every payday.

Keep records long enough, then relax

Hold your receipts and supporting records for the window your tax authority can look back on: generally at least 6 years under the CRA in Canada, or 3 years from filing for most IRS situations in the US, longer if income was underreported or certain losses are claimed. Digital copies take no physical space, so the lazy-but-correct move is to keep everything for the longest window that could apply to you and never think about it again. When you file, export a single books-ready CSV — sorted, categorized, totaled — instead of retyping a pile of paper. That's the whole system: separate the money, capture as you go, categorize consistently, set aside for tax. No spreadsheet required.

← More guides