Invoice template or invoice software? When each one is fine

Grace is a bookkeeper in Cape Town with three clients, each billed once a month. Her Word template has served her for four years without a problem. Her friend Sipho runs a small events company from the same kind of template, sends forty invoices a month, and spends every Friday afternoon working out who has paid. Same tool, very different results. The question is not whether templates are good. It is whether yours still fits the business you have.

What a template is good at

• It costs nothing and you already know Word, Excel or Google Docs.
• It looks how you want. Any layout, any wording.
• It works offline and keeps the file on your own computer.
• It is enough for a few invoices, to a few customers, with simple tax.

What it leaves to you

A template makes the document. Everything around the document is still manual:

• The next number. You look up the last one and hope nobody else used it. Our guide to numbering invoices explains why gaps and repeats matter.
• The tax. You pick the rate and trust a formula that may have been copied over a cell.
• The due date. You count days on a calendar.
• Who has paid. A second sheet, or your memory, or a search through the bank.
• Reminders. Remembering to send them, and writing each one.
• Records. A folder of files with names like invoice final v2.docx.

A quick test

If most of your answers are in the left column, keep the template. If two or three are on the right, the manual work is costing you.

If you keep a template, run it safely

1. Keep a register. One sheet with every invoice: number, date, customer, net, tax, total, due date, date paid. This is your record of what is owed.
2. Take numbers from the register, never from memory, and never reuse one.
3. Lock the formulas. Protect the cells that do the sums, so a typed number cannot replace a formula.
4. Send a PDF, not the editable file, and save that PDF. The PDF is the invoice; the template is only how you made it.
5. Never change a sent invoice. Fix it with a credit note or by cancelling it in the register. See cancelling an invoice.
6. Look at the register every week for anything past due.
7. Back it up somewhere other than the same laptop.

What software takes off your hands

Invoice software keeps each invoice as a record, not a file. The number comes from the series, the tax comes from your country and your customer, and each invoice has a status: due, overdue, part paid, paid. The list of who owes you is always there, and a reminder can be sent from the invoice. What you give up is some freedom of layout, and usually a monthly fee once you pass a free tier.

It does not replace accounting software or an accountant. Invoicing software covers the part between the work and the payment. For a fuller comparison with free invoice makers and accounting software, see the ways to invoice compared.

Moving over without losing anything

Keep your old files and register exactly as they are, for as long as your tax rules ask. Start the new tool with a new number prefix, so no number repeats across the two. Bring over your customers and the things you sell, and send your next invoice from the new tool. The step-by-step version is in switching from Excel or Word.

The short version

• A template is fine for a few invoices, few customers and simple tax, when you know who has paid without looking.
• It makes the document. Numbers, tax, due dates, payments and reminders stay manual.
• If you keep one: a register, locked formulas, PDFs, and a weekly look at what is due.
• Switch when chasing and checking take more time than the invoices themselves.
• When you switch, keep the old files and start a new number prefix.