Send a weekly Slack digest of overdue QuickBooks invoices

Once a week the flow lists invoices with an open balance past their due date and posts one message to Slack.

Updated .

A guide, not professional advice. Test before you use it for real. See terms.

An owner or office manager who invoices from QuickBooks Online and chases payments.

Not sure which one to use? See Make vs n8n.

Problem

Overdue invoices only come up when someone runs a report, and that rarely happens.

What you need

QuickBooks OnlineSlackMaken8n

How it connects

Steps

  1. Run it once a week

    Make: schedule the scenario weekly, Monday morning. n8n: Schedule Trigger with a Weeks interval, weekday, and hour.

  2. Get the invoices

    Make: QuickBooks Search for Invoices. n8n: Invoice > Get All. Test with a small company file first and check that the balance and due date fields come back.

  3. Keep only overdue ones

    Make: a filter with balance greater than 0 and due date before today. n8n: a Filter node with the same Number and Date & Time conditions.

  4. Build one message

    Make: a Text aggregator with one line per invoice: customer, invoice number, balance, due date. n8n: an Aggregate node, then join the lines. If there are none, post "No overdue invoices."

  5. Post to Slack

    Slack Send a Message (Make) or Message > Send (n8n) to a private channel. Invoice amounts are business data; keep the channel small.

Time

Build time is about 40 minutes, estimated by the recipe’s author. It is not a measured average.

Saves running the report by hand. Calling the customer is still on you.

Cost

Your QuickBooks Online account, Slack, and Make or n8n per their current pricing.

What it doesn’t do

It doesn’t email customers, add late fees, or change invoices. QuickBooks has its own reminder settings; this digest is for your team, not for clients.

Build it

The account is yours. The Make link is an affiliate link.

Sources

Similar recipes