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.
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
How it connects
- QuickBooks OnlineNative app
Make: Search for Invoices. n8n: QuickBooks Online node, Invoice > Get All.
- SlackNative app
Make: Send a Message. n8n: Message > Send.
Steps
Run it once a week
Make: schedule the scenario weekly, Monday morning. n8n: Schedule Trigger with a Weeks interval, weekday, and hour.
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.
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.
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."
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
- QuickBooks modules in Make
- Text aggregator in Make
- Slack modules in Make
- n8n QuickBooks Online node
- n8n Schedule Trigger node
- n8n Filter node
- n8n Aggregate node
- n8n Slack node
Similar recipes
Accounting
Alert the team and draft an email when a Stripe invoice payment fails
On invoice.payment_failed, Slack gets an alert and Gmail gets a draft to the customer. A person reviews and sends it.
Accounting
Record a Stripe payment as a sales receipt in QuickBooks
A succeeded payment in Stripe becomes one sales receipt in QuickBooks Online, checked against a log so it is not entered twice.