You can prepare a small number of straightforward invoices without adopting a full accounting application. The important part is the record around the document: which number was issued, which version was sent and which payments arrived.
This method uses a document template and two simple logs. It is useful for occasional billing. It is not a substitute for tax software, a shared accounting ledger or a structured e-invoicing system where those are required.
Set up three places before the first invoice
- A clean template: supplier fields, customer fields, descriptions, totals and payment instructions.
- An invoice register: one row per issued invoice.
- A payment log: one row per payment, linked to the invoice it settles.
Keep the files in an access-controlled folder with a backup. A spreadsheet can hold the two logs, but a folder full of PDFs alone will make partial payments and overdue balances hard to review.
Use a register with enough information to work
Invoice reference | Issue date | Customer | Currency Invoice total | Due date | File/version | Status Related quote/order | Notes/correction reference
Keep issued references unique within your chosen system. For full UK VAT invoices, sequential numbering in one or more series has specific requirements; the numbering guide explains prefixes and documented gaps. Do not delete an issued row merely because the job was cancelled.
A fictional entry and two payments
| Register field | Example |
|---|---|
| Reference | CD-2026-044 |
| Customer and total | Northbank Workshop; GBP 600 |
| Issued / due | 19 October / 2 November 2026 |
| Issued file | CD-2026-044_Northbank.pdf |
Now record PAY-071 for £200 and PAY-078 for £400 against that reference. The remaining balance moves from £600 to £400 to £0. Keep each payment date and bank-matching reference in the payment log. Do not change the original £600 invoice total to £400 after the first payment.
Prepare and issue the document
- Confirm the customer, approved work, currency and terms.
- Reserve the next reference in the register.
- Copy the master template and enter the actual transaction.
- Recalculate quantities, rates, discounts and tax independently.
- Export and open the final PDF.
- Save it, record its location and deliver it using the customer’s agreed route.
The copyable template covers the document structure. You can also use the Talentra generator for a simple bill, but its browser-local number suggestion is not the register. Two devices can suggest the same next number.
Do not overwrite history to fix an error
If a draft is wrong, correct it before issue. If an issued invoice is wrong, preserve it and use the appropriate correction, replacement or credit process for your circumstances. Link the new record to the old one so another reader can follow what changed.
Keep a short note for a reserved number that was not issued. Clear explanations are more useful than silently renumbering later bills to hide a gap.
Schedule a reconciliation
Review unpaid rows regularly. Match actual receipts, check partial payments and verify any claimed bank transfer in your account. Back up the latest register and issued documents after significant changes. Avoid storing full payment-card details or tax-identification forms in a general invoice spreadsheet.
Know when to move on
Repeated manual errors, several people editing the same sheet, mixed tax rates and a growing backlog are signs that this process may be too fragile. Use the software decision worksheet to compare the next step. UK VAT businesses must separately check their digital-record and filing obligations in HMRC’s MTD guidance.
Published by Talentra Solutions. Revised 19 October 2026 with a practical workflow and clearer limits. Examples are fictional. Report a correction.