Skip to content
Tutorials Center
My learning

Topics

Lesson 14 of 36 ยท Customers, Invoices and Sales

QuickBooks Recurring Invoices, Reminders and A/R Aging Reports

Automate repeat billing with QuickBooks recurring transactions, send payment reminders and read the Accounts Receivable Aging report to collect overdue customer invoices.

Two habits make cash flow healthier: billing on time without remembering it, and chasing late payers early. QuickBooks supports both with recurring transactions and the Accounts Receivable aging reports. This lesson finishes the sales chapter with these tools.

Recurring transactions

A recurring template creates invoices (and other forms) on a schedule. Go to gear > Recurring transactions > New:

  1. Choose a Transaction type: Invoice, Sales receipt, Bill, Expense, Check, Journal entry and others.
  2. Name the template and choose the Type:
    • Scheduled: QuickBooks creates and optionally sends the transaction automatically on the interval.
    • Reminder: QuickBooks reminds you to create it; you review and save.
    • Unscheduled: a saved template you create from manually when needed.
  3. Set the Interval (daily, weekly, monthly, yearly), the start date and an optional end (after N occurrences or a date).
  4. Pick Days in advance to create, so that invoices exist before they are due.
  5. Choose the customer, items and amounts, then Save template.

Use scheduled recurring invoices for retainers, subscriptions and rent. For amounts that change every month, prefer a reminder and edit before sending. Review the recurring list regularly: price increases, ended contracts and cancelled customers should update the template. Pay attention to the Previous date and Next date columns, which show what ran and what is next.

Recurring transactions in QuickBooks Online are created as normal transactions with a normal number. They show in the normal reports; the recurring template itself does not post to the books.

Payment reminders

Under Account and settings > Sales > Reminders (or Sales > Invoices > Reminders) set up automatic reminders: how many days before or after the due date to send them, and the message. A friendly reminder a few days before the due date and another after it recovers many late payments. Customize the wording per template, and exclude specific customers if needed.

Accounts Receivable aging

The A/R Aging Summary and A/R Aging Detail reports show who owes you and how long it has been. Find them under Reports > Who owes you.

  • Summary: one row per customer with columns Current, 1-30, 31-60, 61-90 and 91 and over, plus Total.
  • Detail: one row per open invoice with date, number, due date, amount and Past due days. Use Customize to change the Aging method (by due date or by invoice date) and the days per aging period.
  • The total of the aging summary must equal the Accounts Receivable balance on the balance sheet at the same date. If it does not, look for payments posted to the wrong account or journal entries touching A/R.
flowchart LR
    C["Current<br/>not yet due"] --> A["1-30 days"]
    A --> B["31-60 days"]
    B --> D["61-90 days"]
    D --> E["91+ days<br/>escalate / write off"]

The older an invoice, the lower the chance of being paid; act at each step.

A simple collection routine

  1. Weekly, run A/R Aging Detail and sort by Past due.
  2. At 1-30 days, send a polite reminder (QuickBooks can do this automatically).
  3. At 31-60 days, call or e-mail with the invoice attached and a payment link.
  4. At 61-90 days, send a firm notice, pause further work and consider a payment plan.
  5. Past 90 days, consider a collection agency or a write-off.

Use Customer statements to give each late payer one clear summary (see customers).

Key receivables numbers

  • Days sales outstanding (DSO): average days to collect. Roughly (A/R balance / credit sales) x days in period.
  • Collection effectiveness: percent of billed amounts collected on time.
  • Share over 60 days: the part of A/R that is seriously late.

Stand-in: an aging report from invoices

This stand-in builds an aging summary from raw invoices and computes DSO, the same way the report groups them.

Python Stand-in: A/R aging buckets

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Python Stand-in: days sales outstanding

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What is the difference between a scheduled and a reminder recurring template?

    A scheduled template creates (and can send) the transaction; a reminder prompts you.
  2. 2. The A/R Aging Summary total should equal which balance?

    Both reports list the same open invoices and credits, so the totals must match.
  3. 3. Which aging bucket is the most urgent?

    The older an invoice, the less likely it is paid, so act on 91+ first.
  4. 4. Where do you find the aging reports?

    A/R Aging Summary and Detail are in the Who owes you group.

Summary

  • Recurring templates automate repeat invoices or remind you to send them.
  • Payment reminders reduce late payments with little effort.
  • A/R aging shows who owes what and how late; its total must match the balance sheet.
  • Follow a steady collection routine and write off truly uncollectible debts.

Next: Vendors and 1099 tracking