How to set up a reliable bookkeeping system for a growing freelance consultancy

How to set up a reliable bookkeeping system for a growing freelance consultancy

Running a freelance consultancy is rewarding — and chaotic. Early on I learned the hard way that tidy bookkeeping isn't just about compliance; it’s what lets you see where your business is going, price services correctly and avoid last-minute panics at tax time. Below I share the practical, step-by-step approach I use with consultants who are growing from a side-hustle into a sustainable business. It’s written as if I’m sitting next to you, walking through the exact choices and routines that keep the numbers under control.

Decide on the right business structure (and set it up properly)

Before you log your first invoice, make sure your business structure is correct. As a freelancer in the UK you’ll typically choose one of three options: sole trader, partnership or limited company. Each has different tax, filing and bookkeeping implications.

From a bookkeeping perspective:

  • If you’re a sole trader, you can run simple records but must track income and allowable expenses accurately for your Self Assessment.
  • If you set up a limited company, you need to maintain full statutory accounts, file Corporation Tax, and keep director’s loan and payroll records if you pay yourself a salary.
  • Pro tip: set this up before you start trading (or very soon after). Wrong structure means different reporting requirements and more work later to correct records.

    Open a dedicated business bank account

    Mixing personal and business transactions is the fastest way to create bookkeeping headaches. Open a dedicated current account (or a separate account within your existing bank) the moment you begin taking clients. I recommend choosing a bank or fintech that integrates well with accounting software — for example, Starling, Tide or Revolut all offer easy transaction downloads and open banking feeds.

    Create a simple chart of accounts that fits consultancy work

    You don’t need a complicated chart of accounts. Keep categories that reflect the way you run the business:

  • Income — consultancy fees, retainer income, reimbursed expenses
  • Cost of sales — subcontractors, project-specific costs
  • Operating expenses — software subscriptions, office costs, travel, marketing
  • Payroll/Directors Pay — salary, PAYE withholding, employer NICs
  • Taxes — VAT, Corporation Tax, PAYE liabilities
  • Use these consistently. If you’re using software like Xero, QuickBooks or FreeAgent, customise the default chart to include the above so your management reports are useful.

    Choose bookkeeping software and set it up properly

    My go-to recommendation for growing consultants is to pick one cloud accounting package and stick with it. The common choices are:

  • Xero — excellent reports and bank feed reliability; great if you plan to scale or onboard subcontractors.
  • QuickBooks Online — strong invoicing and VAT features; widely used by accountants.
  • FreeAgent — designed for sole traders and small companies; straightforward Self Assessment support.
  • When setting up, do these things straight away:

  • Connect your business bank account via bank feed.
  • Create repeating invoices for retainers and standard services.
  • Upload your chart of accounts and tax settings (VAT scheme, tax rates).
  • Enable automatic reconciliation rules for regular transactions (e.g. monthly software subscriptions).
  • Invoice like your cashflow depends on it — because it does

    Clear invoicing reduces payment delays. I tell every consultant I work with:

  • Use branded invoices with clear payment terms (e.g. 14 days), invoice number, due date and a brief description of the work.
  • Include accepted payment methods and any late-payment terms. Consider offering BACS and GoCardless for direct debit options — GoCardless is handy for retainers.
  • Set reminders within your software so unpaid invoices trigger automated follow-ups at 7, 14 and 28 days.
  • For recurring work, set up recurring invoices or retainers and reconcile them monthly so incoming money is predictable.

    Keep receipts, subsistence and mileage organised

    HMRC expects that expenses are evidenced. I recommend a two-part system:

  • Capture receipts immediately with a smartphone app — Dext Prepare, Receipt Bank (now Dext) or even the mobile apps built into Xero/QuickBooks. Snap, categorise and attach to the relevant transaction.
  • Use a simple spreadsheet or the expenses feature in your accounting software to log mileage (miles, date, business purpose). Use HMRC’s approved mileage rates when reimbursing.
  • Doing this in real time saves hours later and protects your allowable expense claims.

    Reconcile and review weekly

    Make reconciliation a weekly habit. Reconcile bank transactions to invoices and expense receipts so your bookkeeping is never more than a few days out of date. This takes 15–30 minutes a week for many consultants and prevents long catch-up sessions later.

    When reconciling, look for:

  • Duplicate payments or bank fees that haven’t been booked.
  • Missing invoices or client payments that need chasing.
  • Any unusual transfers between accounts that need tagging (e.g. personal withdrawals from a sole trader account).
  • Manage VAT and taxes from day one

    If you expect to exceed the VAT threshold, register early and choose a VAT scheme that suits cashflow. For consultants, the Flat Rate Scheme can be attractive but compare the effective rates by sector. MTD for VAT is mandatory for most VAT-registered businesses — ensure your software is MTD-compatible.

    Plan for taxes:

  • Set aside a percentage of every payment in a separate ‘tax’ pot. A good rule of thumb is 20–30% depending on profits and structure.
  • For limited companies, account for Corporation Tax (usually 19–25% depending on profits) and for salaries, manage PAYE in real time with payroll software like Xero Payroll, QuickBooks Payroll or an outsourced provider.
  • Monthly management routine (my checklist)

    TaskWhy it matters
    Reconcile bank transactionsKeeps books up-to-date and spotting issues early
    Review aged receivablesChase late invoices before they impact cashflow
    Record and attach receiptsEvidence for expenses and VAT claims
    Run profit & loss and cashflow reportCheck performance and plan for upcoming bills
    Move tax money to a savings accountPrevent surprises at year-end

    Use simple cashflow forecasting

    I build a three-month rolling cashflow forecast for every client who’s scaling. It doesn’t need to be fancy — list expected income (confirmed and pipeline) and fixed/variable outgoings. This quick view helps you decide whether to take on that subcontractor or delay marketing spend. Free templates in Excel or the cashflow modules in Xero/QuickBooks will do the job early on.

    When to bring in help

    You don’t have to do everything yourself. I recommend engaging an accountant when any of the following apply:

  • You’re changing structure (sole trader → limited company).
  • Payroll is required (you hire staff or pay yourself a salary).
  • VAT or Corporation Tax obligations become complex.
  • You want regular management accounts and tax planning.
  • An accountant can tidy historical records, set up bookkeeping processes and give strategic advice. I often act as the bridge between freelancer and HMRC — saving time and reducing risk.

    Common mistakes I see — and how to avoid them

    From years of advising freelancers, these errors come up repeatedly:

  • Mixing personal and business spending — solve this with a separate account from day one.
  • Not automating repetitive tasks — use bank feeds, recurring invoices and receipt capture apps.
  • Failing to set aside tax — open a separate savings account and move money monthly.
  • Poor record naming — attach invoices and receipts with clear filenames and dates.
  • Fix these early and you’ll save hours (and stress) each month.

    Tools I recommend

  • Accounting software: Xero, QuickBooks Online, FreeAgent.
  • Receipt capture: Dext Prepare, Xero mobile app, QuickBooks app.
  • Payments: GoCardless for retainers, Stripe or PayPal for card payments, BACS for bank transfers.
  • Banking: Starling or Tide for strong integration and easy bank feeds.
  • Pick one tool for each function and make them talk to each other — integrations are the real time-saver.

    If you follow these steps, you’ll have a bookkeeping system that scales with your consultancy: tidy, compliant and genuinely useful for decision-making rather than just an annual chore. If you want, I can share a starter spreadsheet template (chart of accounts + monthly checklist) or walk through setting up Xero or QuickBooks specifically for your consultancy — just tell me which tools you’re using and where you’re getting stuck.


    You should also check the following news:

    Tax & Compliance

    How to calculate fair director’s pay and dividends for owner-managed SMEs

    02/12/2025

    When you run an owner‑managed SME, one of the most common—and frustrating—questions is: how much should I pay myself as salary, and how much as...

    Read more...
    How to calculate fair director’s pay and dividends for owner-managed SMEs
    Financial Planning

    How to prepare a simple management accounts pack to help you make confident decisions

    02/12/2025

    I often tell clients that management accounts are like a torch in a dark room — they don’t have to be perfect or beautiful, but they must show...

    Read more...
    How to prepare a simple management accounts pack to help you make confident decisions