Small Business Accounts Spreadsheet

A small business accounts spreadsheet is all most UK sole traders and micro-businesses need to keep their finances in order. You do not need expensive accounting software when you are starting out. A well-structured spreadsheet tracks your income, expenses, profit, and tax obligations just as effectively. And it costs a fraction of the price.

What Your Small Business Accounts Spreadsheet Needs

At minimum, your spreadsheet needs to track four things: money coming in, money going out, what category each transaction falls under, and the running totals. Here is how to set it up:

Income Tracking

Create a tab for income with columns for date, client or customer name, description of work, invoice number, amount, and whether it has been paid. This last column is crucial. Knowing who owes you money and how long they have owed it prevents cash flow problems.

Expense Tracking

Your expense tab needs date, supplier or vendor, description, category, amount, and payment method. Categories should match HMRC's allowable expense types: office costs, travel, clothing (work-specific), staff costs, stock and materials, legal and financial costs, marketing, and training.

Summary Dashboard

A summary tab that pulls data from your income and expense tabs gives you an instant view of your financial health. Total income, total expenses, profit, and estimated tax owed. Use simple formulas to calculate these automatically.

Small Business Accounts Spreadsheet vs Accounting Software

The question everyone asks is whether they should use a spreadsheet or software like QuickBooks, Xero, or FreeAgent. Here is the honest answer:

Use a spreadsheet if:

• You are a sole trader with relatively simple finances
• You have fewer than 50 transactions per month
• You are not VAT registered
• You want full control over your data without monthly fees
• You are comfortable with basic formulas

Consider accounting software if:

• You are VAT registered and need to submit MTD returns
• You have employees and need payroll
• You send more than 20 invoices per month
• You want automatic bank feed imports

Most new businesses start with a spreadsheet and move to software as they grow. There is nothing wrong with that approach.

How To Categorise Your Business Expenses

Getting categories right makes tax time much easier. Here are the main ones HMRC recognises for self employed individuals:

• Cost of goods sold - Materials, stock, direct costs of providing your service
• Office, property, and equipment - Rent, utilities, repairs, office supplies, computer equipment
• Car, van, and travel - Fuel, parking, public transport, vehicle insurance (business portion only)
• Clothing - Only uniforms or protective clothing. Not regular clothes even if you only wear them for work
• Staff costs - Wages, subcontractor payments, employer NICs
• Financial costs - Bank charges, credit card fees, interest on business loans
• Marketing and entertainment - Advertising, website costs, business cards. Note: client entertainment is not tax deductible
• Professional fees - Accountant, solicitor, professional subscriptions

Monthly Bookkeeping Routine

The biggest mistake small business owners make is leaving their accounts until the end of the year. By then you have lost receipts, forgotten what transactions were for, and the whole thing becomes a massive headache.

Instead, set aside 30 minutes at the end of each month to:

1. Enter all income received that month
2. Enter all expenses paid that month
3. Reconcile your spreadsheet against your bank statement
4. Chase any unpaid invoices
5. Check your profit and estimated tax position

This simple routine keeps you on top of your finances year-round. When January comes and your tax return is due, everything is already done. You just transfer the totals to your Self Assessment form.

Tips for Better Small Business Bookkeeping

• Separate bank account - Even if HMRC does not require it, having a dedicated business account makes bookkeeping ten times easier
• Photograph receipts - Paper receipts fade. Take a photo and save it in a folder organised by month
• Record everything immediately - The longer you wait, the more likely you are to forget what an expense was for
• Back up your spreadsheet - Use Google Sheets or save regular copies to cloud storage. Losing your accounts data would be a nightmare
• Set aside tax money - Move 25 to 30 percent of your profit into a separate savings account each month. When the tax bill arrives, the money is already there