Small Business Invoice Template UK: VAT, Payment Tracking and Overdue Accounts in Excel
InvoicingUK Small BusinessVATAccounts ReceivableExcel Templates

Small Business Invoice Template UK: VAT, Payment Tracking and Overdue Accounts in Excel

EExcels.uk Editorial Team
2026-11-18
7 min read

Build a UK small business invoice template in Excel with VAT fields, payment tracking, partial payments, credit notes and overdue account reviews.

A well-structured Excel invoice template can do more than produce a professional sales invoice: it can calculate VAT, show payment terms, record partial payments and maintain a clear list of overdue accounts. This guide explains how to build and use a small business invoice template UK businesses can adapt to their own processes, while keeping invoice records easy to review and reconcile.

Overview

An invoice is a request for payment for goods or services supplied. A receipt is different: it normally confirms that payment has been received. Keeping the two documents separate helps customers understand what remains payable and helps your business maintain accurate accounts.

DocumentPurposeTypical timing
InvoiceRequests payment and records the saleIssued when goods or services are supplied, or according to the agreed billing schedule
ReceiptConfirms that some or all of an invoice has been paidIssued after payment is received
Credit noteReduces or reverses part or all of an invoiceIssued after an approved return, correction, cancellation or price adjustment

A practical invoice template Excel workbook should have at least two linked areas: an invoice sheet for creating the document and a payment tracker for monitoring outstanding balances. You can add a third sheet for lists, such as customer names, payment terms and VAT rates used by your business. Before relying on the workbook for formal records, confirm that its fields and calculations suit your accounting process and applicable UK requirements.

For broader cash planning, pair the invoice payment tracker with a small business budget and cash flow forecast template. This helps distinguish sales raised from cash actually received.

What to track

1. Supplier and customer details

Place your business details clearly at the top of the invoice. Include the legal or trading name, business address and contact details. If relevant, include registration details and the VAT registration number. Add the customer’s name, billing address and a contact or purchase-order reference where one has been provided.

Use consistent spelling and customer identifiers in the payment tracker. A customer name entered three different ways can make filtering and debtor-list reviews unreliable.

2. Invoice control fields

Give every invoice a unique invoice number. A simple sequence, customer prefix or year-based sequence can work, provided it is consistent and does not create duplicates. Also record the invoice date, supply date or tax point where relevant, due date, currency and payment terms.

Useful payment terms include the exact due date rather than only a phrase such as “30 days”. If you offer staged billing, show the relevant milestone or billing period so the customer can match the invoice to the agreed work.

3. Line items, discounts and VAT

Give each line a description, quantity, unit price and line total. A basic Excel calculation is:

=Quantity*Unit_Price

For a discount, decide whether it applies to individual lines or to the subtotal. For example, a subtotal of £1,000 with a 10% discount produces a discount of £100 and a discounted net amount of £900.

Keep VAT calculations visible rather than burying them in a single total. A useful layout shows net subtotal, discount, taxable net amount, VAT rate, VAT amount and total payable. If prices are VAT-exclusive, calculate VAT as:

=Net_Amount*VAT_Rate

Then calculate the gross total as:

=Net_Amount+VAT_Amount

For a VAT-inclusive amount, the net value is calculated by dividing the gross amount by one plus the VAT rate, rather than simply subtracting the rate. Because VAT treatment can depend on the transaction and the business’s status, review the relevant current guidance before publishing a template or applying it to an unusual sale. The UK VAT calculator for businesses can be used as a separate sense-check for sales and purchase calculations.

4. Payment instructions and references

Include the payment methods you accept, bank details where appropriate, the account name and a payment reference. Avoid changing bank details casually in an email thread; use a controlled process so customers can verify unexpected changes.

At the bottom of the invoice, state the total due, due date, late-payment contact route and any other agreed instructions. Keep wording factual and consistent with your contract and payment terms.

5. Payment tracker fields

Create one row per invoice in the tracker. Recommended columns are:

  • Invoice number and customer name
  • Invoice date, due date and currency
  • Net amount, VAT amount and total invoice value
  • Payment received date, amount received and remittance reference
  • Outstanding balance, status and days overdue
  • Follow-up date, contact method and notes

Calculate the outstanding balance as invoice total less payments received. For staged or partial payments, record each payment in a separate payment log and summarise it against the invoice, rather than overwriting the original invoice value. This preserves an audit trail and makes reconciliation easier.

Cadence and checkpoints

Before sending an invoice

  1. Confirm the customer’s legal or billing name and address.
  2. Check that the invoice number is unique and sequential according to your process.
  3. Match the description, quantity, price and purchase-order reference to the agreement.
  4. Check whether each line is VAT-inclusive or VAT-exclusive and verify the displayed VAT calculation.
  5. Confirm the invoice date, due date, bank details and payment reference.
  6. Check that the subtotal, discount, VAT and total payable agree.
  7. Save a read-only copy, such as a PDF, using a consistent filename.

When payment arrives

Match the bank receipt or remittance advice to the invoice number. Enter the amount received, date and reference in the payment log. If the amount is lower than the balance, leave the invoice open and mark it as partially paid. If it covers several invoices, allocate the amount clearly rather than recording it against whichever invoice is easiest to find.

Weekly or monthly review

Filter the tracker for unpaid and overdue invoices. Review disputed items separately from invoices that simply have not yet been paid. Update notes after each contact, including the date, person contacted, response and next action. At month end, reconcile tracker totals to the relevant accounting or bank records and produce a current debtor list.

For sales reporting, link invoiced and paid amounts carefully. A sales KPI dashboard template in Excel can help report billed sales, collections and outstanding balances without treating them as the same measure.

How to interpret changes

A growing outstanding balance does not automatically mean sales are improving. Compare invoices raised, cash received, average days to payment and the age of open balances. A rise in invoices with stable collections may signal a working-capital pressure, while a rise in overdue accounts may point to unclear terms, billing errors, disputes or changes in customer behaviour.

Use simple status categories such as Draft, Sent, Part-paid, Paid, Overdue, Disputed and Written off, if applicable to your internal process. Conditional formatting can highlight due dates and overdue balances, but do not rely on colour alone: include the status as text so the workbook remains accessible and easy to filter.

Credit notes should refer to the original invoice and explain the adjustment. Do not delete or silently replace an issued invoice; preserving the original record makes the history easier to understand. For pricing or margin checks, compare net sales values with costs rather than using VAT as revenue. The product pricing and profitability workbook provides a useful companion for reviewing markup, margin and break-even assumptions.

When to revisit

Revisit the invoice template at least quarterly and carry out a more formal review each year. Review it sooner when your VAT treatment, payment terms, legal details, bank account, pricing structure, accounting software or customer workflow changes. Excel itself may also change how formulas, tables or compatibility features behave, so test the workbook after moving it between desktop Excel, Excel for the web or another spreadsheet application.

At each review, test one VAT-exclusive invoice, one VAT-inclusive invoice, one discounted invoice, one partial payment and one credit note. Check that totals, status fields, overdue calculations and printed or exported layouts remain correct. Protect formula cells while leaving input cells editable, and keep a dated backup of the approved version.

To put the process into practice, duplicate the approved invoice sheet, assign the next unique number, complete the pre-send checklist and save the issued copy. Then record the invoice in the tracker immediately. On each weekly or monthly review, reconcile payments, update follow-up dates and export the overdue list for action. This small routine turns a basic sales invoice spreadsheet into a dependable record of what was billed, what was paid and what needs attention.

Related Topics

#Invoicing#UK Small Business#VAT#Accounts Receivable#Excel Templates
E

Excels.uk Editorial Team

Business Templates Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.