See llms.txt for all machine-readable content.

Back to Templates

Send weekly AR aging summaries from QuickBooks Online to Slack

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

  1. Runs on a cron schedule every Monday at 8 AM.
  2. Sets the target Slack channel and how many past-due invoices to include in the report.
  3. Pulls all QuickBooks Online invoices with a positive balance (open invoices).
  4. 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.
  5. Posts either an “all clear” message (if there are no open invoices) or the full AR aging summary to Slack.

Setup

  1. Add QuickBooks Online credentials with access to the company that contains the invoices you want to report on.
  2. Add Slack credentials and ensure the workflow has permission to post messages to your target channel.
  3. Update the Slack channel name and the number of past-due invoices to list in the Settings values.
  4. Adjust the schedule trigger cron expression if you want a different reporting cadence.