QuickBooks AP/AR Aging Intelligence
AI-powered weekly AR/AP aging analysis — per-customer collection risk, AP payment optimization, concentration alerts, aging trends, and escalation recommendations.
Analyzes QuickBooks AR and AP aging reports weekly. Ranks customers by collection risk using aging bands, historical payment speed, and revenue weight. Identifies AP early payment discount opportunities. Flags single-customer concentration risk. Tracks aging trend health over 90 days. Generates specific escalation recommendations (call, remind, escalate, write-off, pay early, defer). Notion AR/AP brief + Slack priority list. 23-node n8n workflow with Monday scheduler. BQS 12/12 certified.
Four Agents. Weekly Aging Analysis. Collection and Payment Intelligence.
Step 1 — The Fetcher
Code-only
Retrieves accounts receivable and accounts payable aging data from QuickBooks Online API — outstanding invoices, bills, aging buckets (current, 1-30, 31-60, 61-90, 90+), customer/vendor details, and payment history patterns.
Step 2 — The Assembler
Code-only
Computes per-customer AR collection risk scores based on aging concentration, payment history, and trend direction. Computes AP payment optimization windows identifying early payment discounts and cash flow timing. Calculates aging concentration alerts when a single customer/vendor exceeds threshold.
Step 3 — The Analyst
Tier 2 Classification
Generates prioritized collection recommendations for AR (ranked by risk score and amount), AP payment optimization suggestions (pay early for discount vs defer for cash flow), and aging trend analysis (improving or deteriorating per customer/vendor). Identifies escalation candidates for AR and renegotiation candidates for AP.
Step 4 — The Formatter
Tier 3 Creative
Generates a Notion AR/AP aging intelligence report with per-customer/vendor breakdowns, risk scores, and recommendations, plus a Slack digest with top collection priorities and payment optimization actions.
What It Does NOT Do
Does not send collection notices or make payments — it provides recommendations for human action
Does not modify invoices or bills in QuickBooks — this is a read-only analysis tool
Does not work with QuickBooks Desktop — QuickBooks Online API only
Does not replace your collections process — it augments it with risk scoring and prioritization
Does not integrate with collection agencies — it identifies escalation candidates for your team to action
The Complete Customer Success Bundle
6 files.
Tested. Measured. Documented.
Weekly AR/AP aging analysis with per-customer collection risk scoring, AP payment optimization, aging trend analysis, and concentration alerts delivered via Notion and Slack.
QuickBooks AP/AR Aging Intelligence v1.0.0──────────────────────────────────────────Nodes: 23 main + 3 scheduler (26 total)Agents: 4 (Fetcher, Assembler, Analyst, Formatter)LLM Calls: 2 per run (Analyst + Formatter)Model: Sonnet 4.6 (SINGLE-MODEL)Trigger: Schedule (weekly Monday 8:00 UTC) + WebhookPattern: BATCH (weekly aging analysis)Tool A: QuickBooks Online API (OAuth2) — AR/AP aging dataTool B: Notion (httpHeaderAuth) — aging intelligence reportTool C: Slack (httpHeaderAuth) — collection/payment priority digestITP: 8/8 records, 14/14 milestonesBQS: 12/12 PASSCost: $0.03–$0.10 per run
What You'll Need
Platform
n8n 2.7.5+
Est. Monthly API Cost
~$0.03-0.10 per weekly run + QuickBooks subscription.
Credentials Required
- ▪Anthropic API
- ▪QuickBooks Online (OAuth2)
- ▪Slack (Bot Token, httpHeaderAuth Bearer)
- ▪Notion (httpHeaderAuth Bearer)
Services
- ▪QuickBooks Online account with AR/AP data
- ▪Anthropic API key
- ▪Notion workspace
- ▪Slack workspace (Bot Token with chat:write)
Setup Track
Quick Start
~15 min
All credentials live, n8n running
Full Setup
1–2 hrs
Needs API config + tables
From Scratch
2–4 hrs
No n8n, no credentials
QuickBooks AP/AR Aging Intelligence v1.0.0
$199
one-time purchase
What you get:
- ✓23-node main workflow + 3-node scheduler
- ✓Weekly AR/AP aging analysis from QuickBooks Online data
- ✓Per-customer AR collection risk scoring with payment history patterns
- ✓AP payment optimization with early discount vs cash flow timing recommendations
- ✓Aging concentration alerts for single-customer/vendor threshold breaches
- ✓Aging trend analysis (improving/deteriorating) per customer and vendor
- ✓Prioritized collection recommendations ranked by risk and amount
- ✓Escalation candidate identification for overdue AR
- ✓Renegotiation candidate identification for AP terms
- ✓Notion AR/AP aging intelligence report with per-entity breakdowns
- ✓Slack digest with top collection priorities and payment optimization actions
- ✓Configurable: aging buckets, risk thresholds, concentration alerts
- ✓Full technical documentation + system prompts
Frequently Asked Questions
What is AR collection risk scoring?+
Each customer receives a collection risk score based on three factors: aging concentration (what percentage of their balance is in 60+ day buckets), payment history (average days to pay historically), and trend direction (are they paying slower or faster over recent months). Higher scores indicate higher collection risk.
What is AP payment optimization?+
For each outstanding AP bill, the Analyst evaluates whether paying early (to capture vendor discounts) or deferring to the due date (to preserve cash) is optimal given your current cash position and the discount terms. This is a recommendation — your finance team makes the payment decision.
How does aging concentration alerting work?+
If a single customer accounts for more than the configurable threshold (default 30%) of your total outstanding AR, or a single vendor accounts for more than the threshold of total AP, an alert is raised. This identifies dangerous concentration in receivables or payables.
Is there a refund policy?+
All sales are final after download. Review the Blueprint Dependency Matrix and prerequisites before purchase. Questions? Contact support@forgeworkflows.com before buying. Full terms at forgeworkflows.com/legal.
Related Blueprints
QuickBooks Invoice Anomaly Detector
AI-powered weekly invoice anomaly detection — duplicates, amount outliers, new vendor risk, line item issues, and overdue concentration with risk scoring and recommended actions.
QuickBooks Cash Flow Forecasting Intelligence
AI-powered weekly cash flow forecasting — 3-scenario projections at 30/60/90 days with AR risk analysis, AP optimization, seasonal adjustment, and cash crunch alerts.
QuickBooks Vendor Spend Analyzer
AI-powered monthly vendor spend analysis — top vendor ranking, concentration risk, renegotiation candidates, fragmentation alerts, and contract renewal estimation.