QuickBooks Expense Category Intelligence

AI-powered monthly expense analysis — MoM category changes, vendor concentration risk, budget variance, and cost reduction opportunities scored across 5 dimensions.

Analyzes QuickBooks P&L data monthly to identify material expense changes, vendor concentration risks, budget overruns, and cost reduction opportunities. Computes per-category MoM deltas with probable causes. Flags categories with >10% growth and urgently flags >20%. Notion monthly expense report + Slack top 3 actions. 23-node n8n workflow with monthly scheduler. BQS 12/12 certified.

triggerSchedule01FetcherQuickBooks API02Assembler5 Dimensions03AnalystTrend Score04FormatterBrief + DigestNotionExpense BriefSlackCost Digest

Four Agents. Monthly Expense Analysis. Category-Level Intelligence.

The Fetcher

Step 1The Fetcher

Code-only

Retrieves expense transactions from QuickBooks Online API for the current and prior months — categorized expenses, vendor details, amounts, and account classifications. Pulls historical monthly totals for trend comparison.

The Assembler

Step 2The Assembler

Code-only

Computes month-over-month changes per expense category, identifies vendor concentration risk (top vendor share per category), calculates budget variance where budgets are configured, and flags categories with significant growth or decline.

The Analyst

Step 3The Analyst

Tier 2 Classification

Analyzes expense patterns for cost reduction opportunities: categories growing faster than revenue, vendors with excessive concentration, redundant vendor spending, and seasonal anomalies. Generates prioritized savings recommendations with estimated impact.

The Formatter

Step 4The Formatter

Tier 3 Creative

Generates a Notion expense intelligence report with per-category breakdowns, MoM trends, vendor concentration charts, and savings recommendations, plus a Slack digest with top 3 cost reduction opportunities.

What It Does NOT Do

×

Does not modify expenses or categories in QuickBooks — this is a read-only analysis tool

×

Does not negotiate with vendors — it identifies concentration risk and recommends renegotiation candidates

×

Does not work with QuickBooks Desktop — QuickBooks Online API only

×

Does not replace your accountant or controller — it provides data-driven expense insights for review

×

Does not track individual employee expenses — it analyzes category-level aggregate data

The Complete Customer Success Bundle

6 files.

quickbooks_expense_category_intelligence_v1_0_0.jsonMain workflow (23 nodes)
quickbooks_expense_category_intelligence_scheduler_v1_0_0.jsonScheduler workflow (3 nodes)
README.md10-minute setup guide
docs/TDD.mdTechnical Design Document
system_prompts/analyst_system_prompt.mdAnalyst prompt reference
system_prompts/formatter_system_prompt.mdFormatter prompt reference

Tested. Measured. Documented.

Monthly expense category intelligence with MoM trend analysis, vendor concentration risk, budget variance, and cost reduction opportunity identification delivered via Notion and Slack.

QuickBooks Expense Category 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 (monthly 1st 9:00 UTC) + WebhookPattern:      BATCH (monthly expense analysis)Tool A:       QuickBooks Online API (OAuth2) — expense transactionsTool B:       Notion (httpHeaderAuth) — expense intelligence reportTool C:       Slack (httpHeaderAuth) — digest with top 3 savings opportunitiesITP:          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 monthly run + QuickBooks subscription.

Credentials Required

  • Anthropic API
  • QuickBooks Online (OAuth2)
  • Slack (Bot Token, httpHeaderAuth Bearer)
  • Notion (httpHeaderAuth Bearer)

Services

  • QuickBooks Online account with expense transactions
  • 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 Expense Category Intelligence v1.0.0

$199

one-time purchase

What you get:

  • 23-node main workflow + 3-node scheduler
  • Monthly expense category intelligence from QuickBooks Online data
  • MoM category change analysis with growth/decline flagging
  • Vendor concentration risk per category (top vendor share)
  • Budget variance analysis where QuickBooks budgets are configured
  • Cost reduction opportunity identification with estimated savings
  • Redundant vendor detection across categories
  • Seasonal pattern analysis from historical monthly data
  • Notion expense intelligence report with per-category breakdowns and MoM trends
  • Slack digest with top 3 cost reduction opportunities
  • Configurable: category filters, variance thresholds, concentration alerts
  • Full technical documentation + system prompts

Frequently Asked Questions

What expense categories does it analyze?+

All expense account categories in your QuickBooks chart of accounts. The Fetcher retrieves transactions grouped by account classification. You can optionally filter to specific categories using the CATEGORY_FILTER parameter if you want to focus on particular expense areas.

How does vendor concentration risk work?+

For each expense category, the Assembler calculates the share of spend going to the top vendor. If one vendor accounts for more than 60% of a category (configurable threshold), it is flagged as a concentration risk. This helps identify dependency on single suppliers.

Does it require QuickBooks budgets?+

No. Budget variance analysis is included when QuickBooks budgets are configured, but the workflow produces full value without budgets — MoM trend analysis, vendor concentration, and cost reduction recommendations all work from transaction data alone.

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.

Read the full guide →

Related Blueprints