How to Track Business Income and Expenses in a Spreadsheet

Every row should tell a complete story. At minimum include the date, a short description, amount, whether it is income or expense, and a category. Add a reference (invoice number, receipt ID or bank transaction code) so you can trace entries later.

Payment method matters too: card, bank transfer, cash or platform payout. Splitting by method helps reconcile against bank statements.

Keep categories broad enough to stay consistent, but specific enough to be useful. Common income groups include product sales, service fees, consulting, digital downloads, refunds received (as negative expense rather than income), and other operating income.

If you sell through multiple channels, a column for channel (website, marketplace, in-person) avoids blending unlike streams in one total.

Typical expense groups: cost of goods or materials, postage and packaging, software subscriptions, marketing and advertising, professional fees, travel, office supplies, equipment, training, and bank or platform charges.

Avoid a catch-all “miscellaneous” bucket that grows without review. If an item lands there repeatedly, create a proper category.

A summary tab or pivot-style view can show income, expenses and the difference by month. Even a simple formula totalling each category helps you spot spikes — a subscription you forgot, or a seasonally quiet month.

Reconcile monthly against your bank account. If the spreadsheet and bank disagree, find the gap before it compounds. Small rounding errors and duplicate rows are the usual culprits.

UK businesses must keep records that support accurate tax returns. What you must keep, and for how long, depends on your business type and circumstances. This guide does not provide tax or accounting advice.

Use your spreadsheet to stay organised, then confirm reporting obligations with HMRC guidance or a qualified accountant — especially when you register for VAT, employ staff or change structure.

Self Assessment for sole traders and partners uses the tax year ending 5 April. Your spreadsheet can follow calendar months internally while you or your accountant map totals to the correct tax year on submission. Mark any transaction that spans year-end — a subscription paid annually in March, for example — so your adviser can apply the right treatment.

Making Tax Digital for VAT requires digital records and submission through compatible software once you are VAT registered. A spreadsheet alone is not sufficient for MTD VAT filing, but many businesses still use a sheet as a working log before data enters their MTD tool. If you are approaching the VAT threshold (£90,000 taxable turnover in a rolling twelve-month period at the time of writing — confirm current figures with HMRC), design categories now that will map cleanly to VAT boxes later.

Keep bank statements, invoices and receipts that support each row. HMRC generally expects records for at least five years after the 31 January submission deadline for a given year. Your spreadsheet is the index; the evidence lives in folders or your accounting platform.

Mixed transactions are the fastest way to corrupt a tracker. If you pay from a personal card in a pinch, log it immediately with a “reimbursement due” note rather than leaving it for quarterly archaeology. Some sole traders run two bank accounts — one business, one personal — and still use one spreadsheet with a “Source account” column for clarity.

Allowable expenses for tax purposes follow HMRC rules your accountant applies. Your spreadsheet categories should describe what you bought in plain language; do not rely on the sheet to decide tax treatment. A row labelled “Client lunch — Leeds” is useful; marking it automatically as “100% deductible” without advice is not.

Home office costs often need a consistent method — simplified expenses flat rate or actual proportion of household bills. Pick one approach, document it on a Settings tab, and apply it the same way each month so comparisons year on year remain meaningful.