Tax and GST

Side hustle VAT records for a UK freelancer: net, VAT and gross

Set up simple side hustle VAT records in the UK for freelance invoices: invoice numbers, net, VAT and gross in pounds, plus a month-end reconciliation.

Editorial illustration for Side hustle VAT records for a UK freelancer: net, VAT and gross

A UK freelancer with a side hustle can keep VAT records simple by giving every invoice its own row with a number, a net amount, a VAT amount and a gross amount. Do the same for supplier bills. Whether you need to be registered and what you owe is for HMRC's current guidance or an accountant to confirm; the habit below makes either conversation straightforward.

Why invoices, not bank deposits, are the unit

A bank deposit of £720 might be one invoice, two invoices, or an invoice minus a client's deduction. Starting from the invoice means every pound has a number attached, and the bank statement is something you check against, not something you reverse-engineer.

The invoice register

  • Invoice number in an unbroken sequence, with no gaps and no reuse.
  • Invoice date and client name.
  • Net amount before VAT.
  • VAT amount shown on the invoice, if applicable.
  • Gross amount, which is net plus VAT.
  • Date paid and the amount that reached your account.

Three months of a designer's invoices, invented

Say a designer raises these invoices, with a VAT line of 20 percent used purely as an example.

InvoiceNetVATGrossPaid
0041 logo work£400.00£80.00£480.00Yes
0042 web banners£250.00£50.00£300.00Yes
0043 brochure£900.00£180.00£1,080.00Due
Total£1,550.00£310.00£1,860.00£780 in

Check: 400 plus 250 plus 900 is £1,550 net; 80 plus 50 plus 180 is £310 VAT; and 1,550 plus 310 equals £1,860. In a sheet, VAT in cell C2 can be =B2*0.2 and gross =B2+C2, with the rate typed into one cell rather than hard-coded, so that you only change it in one place if it changes.

What goes in the supplier bills register?

The same shape: bill date, supplier, net, VAT shown, gross, paid or not. Stock photos, software subscriptions, a co-working day pass and printing each go in a row. Keep the original PDF or photo with a file name that matches the row, for example 2026-05-adobe-14.99.

How do I reconcile the register with my bank?

At month end, total the gross of invoices marked paid and compare it with client money received. Differences usually mean a part payment, a bank charge taken off, or an invoice paid twice. Write the reason beside the row instead of changing the invoice.

Keep one file per tax year and one tab per register, and never delete a row; mark it void with a reason instead. A bookkeeper reading the sheet two years later should be able to see every decision you made, including the mistakes.

What if a client pays late or only part?

Leave the invoice as issued and add payment lines beneath it: £500 received on the 12th, £580 on the 30th. The register then shows how long each client takes, which is useful when you decide whom to ask for deposits. It also stops you reissuing an invoice just because the money arrived in two halves, which would break your number sequence.

A simple sheet can show what is still owed. If gross is in column D and payments received are in column E, then =D2-E2 gives the balance for a row, and =SUM(F2:F200) totals everything outstanding.

When to bring in a professional

  • You are unsure whether your sales mean you should be registered.
  • A client disputes an invoice and VAT is involved.
  • You sell to customers outside the UK.
  • You are about to change how you invoice.

SpendixAI offers GST and ITC-style flags on categories, designed for India; if you track Indian spending as well, it is worth a look, but pounds and UK VAT are outside what it is built for.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports