Budget vs Actuals Narrative Generator with Claude and QuickBooks MCP
FP&A & Reporting
Quick Answer
Pull budget and actuals from QuickBooks MCP, calculate variances with n8n, send to Claude for plain-English narrative generation, and email the management commentary. The workflow produces a first-draft narrative in minutes instead of hours.
The Problem This Solves
FP&A analysts spend hours each month writing budget variance narratives that explain the same recurring patterns. This workflow automates the first draft, letting analysts focus on judgment and exception handling rather than description writing.
About This Workflow
This workflow eliminates the most time-consuming part of monthly management reporting: writing the variance narrative. It pulls actual and budget figures from QuickBooks MCP, calculates variances by category, sends the data to Claude with context about your business, and produces a structured narrative explaining what drove the variances, whether they are favorable or unfavorable, and what management should know. The output is a ready-to-use management commentary that would previously take an FP&A analyst 2-3 hours to write manually.
Tools Required
Step-by-Step Blueprint
Trigger on the 5th of each month
n8nCreate an n8n Schedule trigger to run on the 5th of each month after the prior month close is complete. This timing ensures actuals are finalized before the narrative is generated.
Pull actuals from QuickBooks MCP
QuickBooks MCPAdd an n8n HTTP node to call QuickBooks MCP and retrieve the prior month profit and loss actuals by category. Request data at the account level for maximum narrative granularity.
Pull budget from Google Sheets
Google SheetsAdd an n8n Google Sheets node to retrieve the corresponding budget figures for the same period and categories. Budget data is typically maintained in a spreadsheet outside QuickBooks.
Calculate variances in n8n
n8nAdd an n8n Code node to calculate variance amounts and percentages for each line item. Flag variances exceeding 10 percent or a material dollar threshold for emphasis in the narrative.
Generate narrative with Claude
ClaudeAdd an n8n Claude node. Send the variance data with context about your business type and instruct Claude to write a management commentary explaining top favorable and unfavorable variances, their likely drivers, and any items requiring attention.
Use this prompt →Email narrative for review
n8nAdd an n8n Email node to send the AI-generated narrative to the FP&A team for review and editing before distribution to management. Include the raw variance table alongside the narrative.
Cost Estimate
n8n Cloud Pro $50/month or self-hosted free. QuickBooks MCP via Coupler.io $49/month. Claude API costs minimal for monthly narrative runs. Google Sheets free.
Related Resources
AI Agents
MCP Servers
Software