Many freelancers and small business owners delay bookkeeping because they assume it requires accounting software, a subscription, and training they do not have time for. In reality, a simple spreadsheet with the right columns handles the basics perfectly for a small operation: every pound or dollar in, every pound or dollar out, categorised well enough that tax time becomes a summary rather than a reconstruction. The template itself is free to build in minutes, and the habit it supports is worth far more than any software feature.

A practical bookkeeping sheet needs only a few columns: date, description, category, income, expense, payment method, and a running balance. Income and expense stay in separate columns so totals are easy to sum, categories such as materials, travel, software, fees and sales keep similar costs together, and the running balance shows your position at a glance without a separate calculation. Add a notes column for anything unusual, such as a refund or a partial payment, because future you will not remember the context.

Keep a second tab for a monthly summary that totals income and expenses by category, either with simple formulas or by manual addition if formulas feel intimidating. That summary is what you will actually use: it shows which months were profitable, which categories grew unexpectedly, and what total to report at tax time, without re-reading hundreds of individual rows.

The system fails only when entries pile up, so set a non-negotiable weekly slot of ten minutes to record the week's transactions. Gather receipts from your phone, email confirmations and bank app, enter them in date order, and file the receipts in a single folder, digital or physical, labelled by month. Ten minutes weekly is a small habit; three hours at year-end, reconstructing a year's spending from memory, is a miserable one.

Record income on the date you receive it, not the date you invoice it, unless your tax system requires accrual accounting, and note the distinction if you are unsure. For most small cash-basis businesses, received income is the honest and simple approach, and it matches the money actually in your account, which is what matters for day-to-day decisions.

Choose categories that mirror the expense types your tax return will ask about, and keep the list short: ten to fifteen categories cover most small businesses without creating confusion about where an item belongs. Common categories include sales income, materials, subcontractors, travel, phone and internet, software, advertising, office costs, professional fees and bank charges. If an expense genuinely fits two categories, pick the closer one and note the choice, because consistency matters more than perfection.

Separate personal and business spending strictly, even if you operate as a sole trader. A business spreadsheet that includes groceries and personal subscriptions becomes unreliable for both tax and business decisions, and untangling it later wastes hours. If you pay for something partly business and partly personal, such as a phone bill, record only the business portion and note the split you used.

Review the monthly summary briefly at each month's end and ask three questions: did income cover expenses, which category grew most, and what is owed or due next month? Those questions turn bookkeeping from a chore into a management tool, because they reveal a rising software bill, a client who pays late, or a profitable service worth expanding, while there is still time to act.

When your business grows to the point where a spreadsheet feels limiting — many transactions daily, inventory to track, or employees to pay — that is the right moment to consider accounting software, and your clean spreadsheet history will make migration easy. Until then, a free template, updated weekly and reviewed monthly, gives you honest books, a calm tax season, and a clear picture of whether your business is actually making money.