← All prebuilt solutions
Bookkeeping & Compliance

Invoice Generator & Register

Professional invoices, a full sales register and a clear view of who owes you what

£20

Secure checkout. Your download link is sent as soon as payment clears.

Invoice Generator & Register

Overview

This workbook is a complete, simple invoicing system for a small business. You keep your customers and your products and services in two lists, record each invoice and the items on it, and the workbook does the rest: net, VAT and gross totals, due dates, balances and a status for every invoice. Pick an invoice number and a professional A4 invoice is ready to print or save as a PDF; pick a customer and you get a statement of everything they owe. The dashboard shows sales by month, cash received, aged debt, the oldest overdue invoices, your top customers and how quickly people pay.

Price
£20
Who it’s for
Bookkeeping & Compliance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Products

What you sell, unit prices and VAT rates – plus quantity and sales to date. What you do: add and update products and services.

Products
Invoice Register

Step 2

Invoice Register

The register: one row per invoice with totals, due date, payments, balance and status. What you do: add each invoice; record payments.

Step 3

Invoice Lines

The items on each invoice, linked by invoice number. What you do: add the items for each invoice.

Invoice Lines
Invoice

Step 4

Invoice

The printable A4 invoice. What you do: pick an invoice number and print.

Who it is for

Made for people like you

  • Example – text
  • Trades, contractors & installers – Job invoices with labour, materials and mixed VAT rates on the same invoice.
  • Consultants & service businesses – Clean, professional invoices and a register that shows exactly what's outstanding.
  • Small shops & makers selling to businesses – Product list with prices and VAT rates, customer statements and credit control.
  • Anyone not ready for accounting software – A tidy, complete sales record your accountant can work from.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter your business name, address, contact details, VAT and company numbers, bank details, default payment terms and your invoice number prefix.
  2. Customers – Add each customer's name and address, and payment terms if they differ from your default.
  3. Products – List what you sell with a unit price (ex VAT) and the VAT rate.
  4. Invoice Register – start an invoice – On the next empty row type the invoice number (the 'Next invoice number' is shown at the top), the date and pick the customer.
  5. Invoice Lines – add the items – One row per item: pick the invoice number, the product code and type the quantity. Override the description, price or VAT rate only if this sale is different.
  6. Print it – On the Invoice sheet pick the invoice number, then File > Print (or Save as PDF) – it's set up to fit one A4 page.
  7. When you're paid – Back on the Invoice Register type the date paid. If it was only part of the invoice, type the amount paid as well.

Key features

  • Keep your customers, products and services in one place – with prices and the right VAT rate (20%, 5%, zero or exempt) for each.
  • Record every invoice and its lines; net, VAT, gross, due date, balance and status (Paid, Part paid, Overdue or Due) all calculate for you.
  • Print a professional A4 invoice – or a customer statement of everything unpaid – by picking a number or a name.
  • Dashboard: sales and cash by month, aged debt, oldest overdue invoices, top customers, average days to pay and a VAT summary by rate.

What’s included

  • Dashboard – Sales, debt and payment speed
  • Settings – Your business and bank details
  • Customers – Names, addresses and terms
  • Products – What you sell, prices and VAT rates
  • Invoice Register – Every invoice, its totals and payments
  • Invoice Lines – The items on each invoice
  • Invoice – Printable A4 invoice
  • Statement – Printable customer statement
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions