Quick overview
This workflow runs every Monday morning to fetch all open invoices from QuickBooks Online, calculate an accounts receivable aging summary and top past-due invoices, and post the results as a formatted message to a Slack channel.
How it works
- Runs on a cron schedule every Monday at 8 AM.
- Sets the target Slack channel and how many past-due invoices to include in the report.
- Pulls all QuickBooks Online invoices with a positive balance (open invoices).
- Calculates total outstanding, groups balances into aging buckets (Current, 1–30, 31–60, 61–90, 90+), and compiles a list of the oldest past-due invoices.
- Posts either an “all clear” message (if there are no open invoices) or the full AR aging summary to Slack.
Setup
- Add QuickBooks Online credentials with access to the company that contains the invoices you want to report on.
- Add Slack credentials and ensure the workflow has permission to post messages to your target channel.
- Update the Slack channel name and the number of past-due invoices to list in the Settings values.
- Adjust the schedule trigger cron expression if you want a different reporting cadence.