All workflows
QuickBooks Online logoGmail logo

Email finance what each customer owes in overdue invoices

On the 1st, emails finance each customer with overdue invoices and what they owe, plus the total.

Every month on the 1st at 09:002 apps2 steps

Apps it connects

Authenticate each one once and the workflow is ready to run.

What it does

Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.

  1. 1QuickBooks OnlineList invoicesFinds the overdue invoices, already added up per customer.
  2. If overdue.count is more than 0

    1. 2GmailSendEmails the list to finance.

How it works

What happens on each run, in plain English.

Month-end collections start with knowing who owes what. On the 1st of each month this looks at every invoice in QuickBooks that is past its due date and has not been paid.

Finance gets one email with a row per customer, how many invoices are overdue and what they owe, biggest first, and the total at the top. Nothing is sent in a month when nothing is overdue.

quickbooksgmailinvoicesoverdueaccounts receivablemonthly

Start from a workflow that already works.

Add "Email finance what each customer owes in overdue invoices" to your workspace, connect its apps, and make it yours.

Free plan, no credit card