Setting Up Automatic Invoice Reminders Based on Invoice Age in QuickBooks

You sent the invoice. It has been 45 days. You have not been paid. And nobody on your team remembered to follow up because everyone assumed someone else was handling it. Manual collections is one of the most expensive administrative problems a small business can have, and QuickBooks already includes the tools to automate most of it.

Why Manual Follow-Up Fails

Most businesses have an informal collections process. Someone checks AR when cash gets tight and sends a reminder when an invoice looks old. The problem with informal is inconsistent. Some clients get chased at 15 days, others drift to 60 before anyone notices. The inconsistency sends a message to slow payers that your terms are negotiable.

The cost of late payment is concrete. If you have $100,000 in AR outstanding at any given time and your average invoice is paid at 45 days instead of 30, you are effectively lending your customers 15 days of float on six figures. If you have a line of credit at 7 percent to cover that float, the annual cost is roughly $2,900. That is before anyone accounts for the labour cost of manual follow-up calls and emails.

Automating reminders does not just save admin time. It also normalizes the expectation that invoices are paid on time. Clients who know reminders are automatic stop treating them as a personal ask and start treating them as a billing process.

How QuickBooks Automatic Reminders Work

QuickBooks Online has a built-in feature called Reminders (or Invoice Reminders depending on your version) that lets you configure a series of automated emails tied to invoice age. You set the rules once and QuickBooks sends the emails based on the triggers you define. No one has to remember. No one has to manually scan AR.

You can configure reminders to send before the due date, on the due date, and at multiple intervals after the due date. A typical setup might include a reminder three days before the due date, a note on the due date, a follow-up seven days after, and a firmer message at 30 days past due. Each message can be customized with a different tone appropriate to the stage.

What to Do About It

1. Enable automated reminders in QuickBooks Online settings. In QuickBooks Online, go to Settings (the gear icon), then select Account and Settings. Under the Sales tab, find the Reminders section. Toggle it on. From there you can configure the timing and content of each reminder. This takes less than 15 minutes to set up for the first time.
2. Build a three-stage reminder sequence. A simple effective sequence is: a courtesy reminder three days before the due date that confirms the invoice and payment details, a due-date reminder on the day payment is expected, and a past-due notice at 14 days past due that references the original invoice and notes the overdue balance. Adding a fourth message at 30 days with a firmer subject line covers most collections situations without requiring personal outreach until an account is significantly overdue.
3. Customize the message for each stage. The pre-due reminder should feel like a helpful heads-up, not a collections call. The past-due messages should escalate in directness. QuickBooks lets you edit the email body for each reminder. Write messages that match your relationship with clients: professional and matter-of-fact, not apologetic. Avoid subject lines that bury the purpose. Something like "Invoice #1042 due in 3 days" is clearer than "A quick note about your account."
4. Exclude clients who should not receive automated reminders. Some clients have payment terms that differ from your standard (net 45 instead of net 30, or they pay on a consolidated monthly statement). QuickBooks allows you to manage reminder settings at the customer level. For clients with non-standard arrangements, either adjust the reminder timing to match their actual terms or turn off automated reminders for that customer and handle them manually.
5. Set a follow-up threshold for manual intervention. Automated reminders handle the routine cases. For invoices that reach 45 or 60 days past due with no payment and no response to reminders, define a manual escalation process: a phone call, a formal demand letter, or a conversation about a payment plan. Document who owns this step so it does not fall through the same crack as the original follow-up.
6. Review your AR aging report monthly. Automated reminders do not replace oversight. Run your AR aging report at the start of each month and look for any invoice over 45 days. Check whether reminders were sent and whether they received any response. The aging report also tells you whether your average days outstanding is improving over time, which is the measure of whether your collections process is actually working.

One Note on QuickBooks Desktop

QuickBooks Desktop does not have the same built-in automated reminder feature as QuickBooks Online. Desktop users can set up reminder templates but the sending process is semi-manual. If automated collections follow-up is a priority, it is one practical argument for migrating to QuickBooks Online, which handles this natively without add-ons.

Slow AR is a cash flow problem with a known solution. The tools are already in the software you are paying for. The only thing standing between you and a collections process that runs itself is 15 minutes of setup. Book a free call at peterxiacpa.com/book.

Next step: run your numbers through the free CFO scorecard.