2026-10-19・Automation / Small business / Invoicing

How to Automate Invoicing and Payment Follow-Up

Sending the invoice is the easy part. The tedious part is what comes after: remembering who owes you, spotting the late ones, writing the awkward email, and matching each payment to the right invoice.

You do not need new software to fix most of this. This guide shows how to automate invoicing and payment follow-up in five steps, using tools you probably already have: a spreadsheet, your email, and a file from your bank.

It is written for small businesses in the US, UK, Canada and Australia. It does not recommend any brand.

1. Build an invoice tracker in a spreadsheet

What's tedious: Invoices live in different folders and email threads. Nobody has one view of what is sent, due or paid.

The way: Make one sheet where every invoice is one row. A simple layout works:

A few small rules save a lot of time:

• Numbering: Pick a pattern and never break it, such as year, month, then a running number. It makes invoices easy to find and gaps easy to spot.
• Due dates: Let the sheet calculate them. If your terms are 30 days, the due date is the issue date plus 30.
• Status: Use a drop-down list so the wording is always the same.
• Overdue flag: Add a formula or conditional formatting that highlights rows where the due date has passed and the "date paid" cell is empty.

If you keep the tracker in Google Sheets or Excel, you also get one place to filter by client or month.

First step: Put this month's invoices into the sheet, one row each. That alone shows you what is outstanding.

2. Send reminders from email templates

What's tedious: You write nearly the same polite chase-up email again and again, and you tend to put it off.

The way: Write the wording once and save it as a template.

In Gmail, templates are turned on in Settings under the Advanced tab, and Google's help page says you can only turn them on and use them from Gmail on a computer. You write a message in Compose, then use More options, Templates, and save the draft as a template. To use one, open Compose, choose More options, Templates, and pick it under "Insert template."

In Outlook, Microsoft's support page describes saving an email as a template from the Message ribbon in the new Outlook for Windows. It also says that Mail Templates and the My Templates add-in need a qualifying Microsoft 365 subscription. The steps differ in classic Outlook, so follow Microsoft's page for the version you use.

Two or three templates are enough:

1. Friendly reminder (a few days before the due date, or the day after)
2. Second notice (about a week later)
3. Final notice before you take other steps

Here is a simple example for the first reminder:

Hi [Name], This is a quick reminder that invoice [number] for [amount] was due on [date]. If you have already paid, thank you, and please ignore this note. If not, could you let me know when to expect payment? The invoice is attached again for convenience. Thanks, [Your name]

Keep the tone polite. Late payment is often an oversight.

Make it semi-automatic. Add a "Last reminder sent" column to your tracker. Once a week, filter for overdue rows, open the matching template, fill in the details and send. If you are comfortable with scripting, some tools can send these emails on a schedule, but start by sending by hand from a template. Review each email before it goes out; an automated message sent to the wrong person is worse than a late one.

First step: Save one "friendly reminder" template today.

3. Match payments with your bank export

What's tedious: Checking each deposit against your invoice list one by one.

The way: Most online banks let you download recent transactions as a CSV file. Check your bank's help pages to see what formats it offers.

1. Download the last month of transactions.
2. Paste them into a second sheet in your workbook.
3. For each invoice, look for a deposit with the same amount and a client name or invoice number in the description.
4. When you find one, enter the "date paid" and set the status to Paid.

Spreadsheet lookups can do much of this for you. For example, a lookup on the amount or reference can flag which invoices have a matching deposit.

Watch for the usual traps:

• A client pays several invoices in one transfer.
• A bank or card fee means the amount is slightly short.
• The name on the payment is different from the client name.

Mark anything unclear as "check" instead of guessing. Doing this once a week, at a fixed time, keeps it small.

First step: Download one month of bank transactions and try matching just five invoices.

4. Know what your invoices must show

Invoice rules depend on where you operate. The notes below are only a starting point, based on official pages we read. Rules change, so check the official guidance or ask your accountant.

United Kingdom. GOV.UK says that if you are VAT-registered, you must show VAT information on your invoice, and that invoices must include your VAT number and display the VAT separately. GOV.UK also says all VAT-registered businesses should now be signed up for Making Tax Digital for VAT. HMRC's VAT Notice 700/22 says VAT-registered businesses must keep certain records digitally and file VAT Returns using software. The same notice says a spreadsheet can be part of compatible software when it is used together with other programs, such as bridging software. For late payment, GOV.UK says you can claim interest and debt recovery costs if another business is late paying you. It also says that with no agreed date, a payment is late 30 days after the customer receives the invoice or the goods or services are provided, whichever is later. See the GOV.UK pages for the details.

Australia. The Australian government's business.gov.au says GST-registered businesses must use tax invoices, and that a tax invoice is needed for a taxable sale over $82.50 including GST, or whenever a customer asks for one, in which case you have 28 days to give it. A tax invoice must include the words "tax invoice," your business name, your ABN, the issue date, a description with quantity and price, and any GST amount. For sales over $1,000, it should also show the buyer's identity or ABN. Check the ATO's guidance for the full rules.

Canada. The Canada Revenue Agency says businesses must tell customers whether GST/HST applies and whether the tax is included in the price or shown separately. For HST, it says to show the total HST rate only, not the federal and provincial parts separately. The CRA also says the invoice date decides the reporting period in which the tax must be reported, even if payment has not been received. Separately, the CRA's input tax credit page lists what a customer needs on an invoice to claim credits, and the amount depends on the invoice total: for $500 or more, that includes the buyer's name, a brief description and the terms of payment.

United States. There is no single national sales tax rule. The Small Business Administration says tax laws vary by location and business structure and advises checking with state and local governments about your obligations. So whether and how you charge sales tax on an invoice depends on your state. Check your state's department of revenue or ask your accountant.

Put these requirements into your invoice template once, and every future invoice starts out right.

First step: Compare your current invoice with the notes for your country and add anything missing.

5. When accounting software makes sense

A spreadsheet is a good start, but it has limits. Consider accounting or invoicing software when:

• You send many invoices each month and the manual routine is taking real time.
• You want reminders to go out on a schedule without you triggering them.
• You want payments to be recorded automatically from a bank connection.
• Tax filing needs to be tied to your records. For example, in the UK, VAT-registered businesses must use compatible software for their VAT Returns.
• More than one person needs to see or update the invoices.

Before choosing, write down what you actually need: recurring invoices, online payment links, bank feeds, tax reports, multiple users. Then compare tools against that list instead of against their feature pages. Try a free trial with real invoices, and check that you can export your data if you leave.

If you are not sure yet, run the spreadsheet routine for a month or two. You will learn exactly which parts hurt, and that tells you what to look for.

Where to start

Do not try to automate everything at once. Pick one:

1. Build the tracker and enter this month's invoices.
2. Save one reminder template.
3. Set a weekly 15-minute slot to match payments and send reminders.

Three habits keep it working: keep one source of truth, use the same statuses every time, and review it on a fixed day each week.

If you are not sure which tasks in your business are worth automating, try the free Small Business Automation Check. Pick your business and tools, and it compares methods and suggests where to start.

Sources

• GOV.UK, "Charge, reclaim and record VAT" https://www.gov.uk/vat-record-keeping
• VAT invoices must include your VAT number and display VAT separately; all VAT-registered businesses should now be signed up for Making Tax Digital for VAT
• GOV.UK, "VAT Notice 700/22: Making Tax Digital for VAT" https://www.gov.uk/government/publications/vat-notice-70022-making-tax-digital-for-vat/vat-notice-70022-making-tax-digital-for-vat
• VAT-registered businesses keep certain records digitally and file VAT Returns using software; a spreadsheet can be a component of compatible software when used with other programs such as bridging software
• GOV.UK, "Late commercial payments: interest and debt recovery" https://www.gov.uk/late-commercial-payments-interest-debt-recovery
• Businesses can claim interest and debt recovery costs for late payment; with no agreed date, payment is late 30 days after receipt of the invoice or delivery or service, whichever is later
• business.gov.au, "How to invoice" https://business.gov.au/finance/payments-and-invoicing/how-to-invoice
• Tax invoice vs regular invoice, $82.50 threshold, 28 days to provide on request, required content, buyer details over $1,000
• Canada.ca (CRA), "Charge and collect the tax - Which rate to charge" https://www.canada.ca/en/revenue-agency/services/tax/businesses/topics/gst-hst-businesses/charge-collect-which-rate.html
• GST/HST statements on invoices, showing the total HST rate only, invoice date determining the reporting period
• Canada.ca (CRA), "Input tax credits" https://www.canada.ca/en/revenue-agency/services/tax/businesses/topics/gst-hst-businesses/calculate-prepare-report/input-tax-credit.html
• Invoice information customers need to support input tax credit claims, by invoice total
• U.S. Small Business Administration, "Pay taxes" https://www.sba.gov/business-guide/manage-your-business/pay-taxes
• Tax laws vary by location and business structure; check with state and local governments
• Google, "Create a template in Gmail" https://support.google.com/mail/answer/14864208?hl=en
• Turning on and using Gmail templates, on a computer only
• Microsoft Support, "Create email templates in Outlook" https://support.microsoft.com/en-us/outlook/create-email-templates-in-outlook
• Saving an email as a template; Mail Templates and My Templates need a qualifying Microsoft 365 subscription

This article was written with the help of AI and checked against the official sources above on October 19, 2026. Rules differ by country and change over time — confirm with the official guidance or an accountant.