Draft variance (flux) commentary with AI (n8n)

Pull P&L numbers for this month and last, flag big swings, and get draft questions and commentary.

n8nMonth-end closeAdvancedHuman check: High

Tools
n8n: QuickBooks Online, OpenAI, Google Docs

Time saved
~3-5 hrs/month (estimate)

Difficulty
Advanced

Steps

Manual Trigger (run it after the books are closed).
QuickBooks Online → Transaction → Get Report for both periods (Profit and Loss).
Code node: list accounts with a variance over 10% and over $1,000.
OpenAI: 'For each account, write one line of neutral commentary and one question to ask the budget owner.'
Google Docs → Create and Update the document with the table and the drafts.

Keep a human check here: High risk

Every explanation needs a source document. AI can make up plausible reasons for a variance, so rewrite or delete any you can't support.

Node and module names match n8n's docs as of Oct 2026. Apps rename triggers and actions sometimes, so check yours in the editor. Try it with test data or a sandbox company first.

Build it

[AFFILIATE LINK PLACEHOLDER: not live]
Try n8n. We may earn a commission if you sign up, at no cost to you. Disclosure

Related recipes

Create your month-end close checklist automatically (Make)

On the 1st of each month, create every close task in Asana from a master list, with owners and due dates.

MakeMonth-end closeBeginnerHuman check: Low

Saves ~1-2 hrs/month

Remind yourself of recurring accruals (Zapier)

On the last business day of the month, email yourself a list of the accruals you usually book.

ZapierMonth-end closeBeginnerHuman check: Medium

Saves ~1 hr/month

Keep a close status board up to date (Make)

When a close task is completed in Asana, update the status sheet and post progress.

MakeMonth-end closeIntermediateHuman check: Low