Automate your invoices from first draft to final reminder

The short answer

To automate invoicing, set it up in three stages. First, create invoices automatically: recurring templates for fixed fees, and a trigger from your CRM, job system or store for everything else. Second, send them automatically with an online payment link attached. Third, turn on scheduled reminders before and after the due date. In QuickBooks Online that means recurring transactions set to Scheduled, the automatic email option, online payments enabled and automatic invoice reminders turned on in the Sales settings.

The rest of this guide walks through each stage, the settings to check, and the controls that stop an automated system from sending the wrong amount to the wrong client.

Stage 1: create invoices without retyping

Invoices come from one of three places. Automate each differently.

Recurring templates in QuickBooks Online

According to Intuit’s help article on recurring transactions, you open Recurring transactions, select New, choose Invoice, and set the type. A Scheduled template creates the invoice on the interval you choose. A Reminder template only prompts you, and an Unscheduled template waits for you to use it. Set the customer, the interval, the start date and the end date, and select the option to send emails automatically.

One caution: Intuit’s documentation for some regions says recurring invoices are saved as drafts for review rather than sent. Test one template on your own email address before you rely on it for clients, and check the Recurring transactions list after the first run.

Invoices from completed work

If your team marks jobs complete in a field service app, a project tool or a CRM, that status change should create the invoice. Many of these tools sync natively with QuickBooks or Xero. Where they do not, a connector such as Zapier, Make or Power Automate can create the invoice from the job record. Map every field: customer, line items, quantities, rates, tax and terms. Most invoicing errors in automated setups come from a missing or misnamed product or service item.

Stage 2: send and collect automatically

• Turn on online payments. A pay-now link for card and ACH in every invoice email removes the step where a client has to find your bank details.
• Set default terms per customer. Net 15 for one client and due on receipt for another should live on the customer record, not in someone’s memory.
• Use a consistent sender. Send from a billing address the client recognizes, and make sure your domain is set up for email authentication so invoices are not filtered as spam.
• Attach the detail. Include the PDF and a short line describing the period or job, so the client’s approver does not need to ask.
• Offer autopay for recurring clients. Card or bank autopay on retainers removes reminders entirely for that group.

If you bill through Stripe, its documentation explains that when automatic collection is on, Stripe can send reminders when an invoice is overdue and retry failed card payments automatically. Stripe’s recommended default retry setting is 8 tries within 2 weeks.

Stage 3: reminders that do the chasing

In QuickBooks Online, Intuit’s help article says automatic reminders are turned on under Account and settings, then the Sales tab, then Reminders. You can schedule up to three reminders and set each one up to 90 days before or after the due date, with your own subject line and message. On QuickBooks Online Advanced, Intuit points users to workflows for reminders instead.

A reminder sequence that works for most service businesses:

1. 3 days before due. A friendly heads-up with the payment link.
2. 3 days after due. A short note that the invoice is past due, with the link again.
3. 14 days after due. A firmer message, and an internal task for a person to call.

Stop automation there. After two weeks overdue, a phone call from someone who knows the client recovers more money and protects the relationship better than a fourth email.

Want to know how much of your billing could run itself? Our free Technology Health Assessment takes about 30 minutes of data collection. The next day you get a plain-language report rating your applications, integration and automation opportunities, with a short list of next steps in order. It is yours to keep, with no obligation. Book your assessment.

Using AI in invoicing, carefully

AI tools can draft line-item descriptions from timesheets, summarize what a client was billed this quarter, or suggest which overdue accounts to call first. Keep AI away from the numbers themselves unless a person reviews them. An automated system that sends a wrong total to 40 clients creates more work than it saves. Rules-based automation is the right tool for amounts, dates and terms.

Controls that keep automated invoicing accurate

• Weekly exception review. Look at invoices that failed to send, bounced or were created with zero or unusually large totals.
• Price changes in one place. Update rates on the product or service list, not on individual templates, then check every recurring template that uses them.
• End dates on recurring templates. A contract that ended in March should not still bill in June.
• Clean customer emails. Use a billing contact, not a former employee’s address. Bounces should alert someone.
• Separation of duties. The person who changes templates should not be the only person who reviews receivables.
• Run history ownership. If a connector creates invoices, a named person checks its failure log weekly.

If you invoice from Word or Excel today

Many small firms still build invoices in a spreadsheet or document template and email them by hand. Automation starts with moving those invoices into your accounting system, because reminders, payment links and reporting all depend on the invoice living there. Set up each client as a customer, each service as an item with its rate and income account, and your standard terms. Import open balances so reminders know what is outstanding. Once the records live in one system, recurring templates and reminders take minutes to configure, and your receivables report becomes accurate without a separate tracking sheet. Keep the old template only for the odd one-off job until the new process has run cleanly for a full month.

A one-week setup plan

1. Day 1: list every invoice you sent last month and group them as recurring, work-based or order-based.
2. Day 2: clean the product and service list and the customer billing emails.
3. Day 3: build recurring templates and test one on your own address.
4. Day 4: turn on online payments and set terms on each customer record.
5. Day 5: configure the three reminders and an internal call task at day 14.
6. Week 2 onward: connect your job system or CRM so completed work creates invoices.

If invoices need to start in a CRM, field app or store, JLB USA can connect those systems to your accounting software and set up automation with alerts when anything fails. Our article on QuickBooks integration with Shopify and your CRM covers the sync side in more detail.

Keep reading

• Accounts payable automation for small business: how it works
• Automated lead follow-up that responds in minutes and still sounds human
• 20 business process automation examples for small businesses
• AI for small business owners: practical, safe uses that save time

Related services

• Automation and practical AI
• Systems integration
• QuickBooks integration with Shopify and CRM