In partnership with

Audit Friendly MODERN ACCOUNTING
TUE · NOV 17 · EDITION

Build a month-end flux commentary workflow with an AI assistant

 

Writing flux commentary from scratch eats time a controller does not have at month-end: this workflow takes a two-period trial balance export and produces a structured first draft, with bracketed placeholders wherever the assistant cannot infer cause from the data alone. It is built for the accountant who needs defensible workpaper commentary fast, not polished prose that obscures what still needs human judgment. The prompt enforces that discipline by design: the assistant is explicitly instructed not to remove bracketed notes to make the output appear more complete.

BUILD WITH AI

Build a month-end flux commentary workflow with an AI assistant

This workflow turns a two-period trial balance export into a first-draft flux commentary in one assistant session. The output is a structured draft with bracketed placeholders wherever the assistant cannot determine cause from the data alone.

1
Export a two-period trial balance from your accounting system as a CSV, with columns: account code, account name, prior period balance, current period balance, and variance amount. Remove subtotal rows.
2
Open a general-purpose AI assistant that accepts file or text input, and paste or upload the CSV.
3
Set your materiality threshold by including this instruction at the top of your prompt: 'Only comment on accounts where the absolute variance exceeds [your dollar threshold].'
4
Paste the following prompt: 'You are preparing month-end flux commentary for an internal workpaper. The attached trial balance shows two periods. For each account where the absolute variance exceeds the threshold I specified, write two to three sentences explaining the likely cause based on the account name and the direction and size of the movement. Where the cause cannot be reasonably inferred from the account name alone, write the two sentences you can support and add a bracketed note: [Cause unconfirmed: reviewer to verify against subledger]. Group accounts by: revenue, cost of goods sold, operating expenses, other income and expense, balance sheet. Do not invent subledger detail. Do not remove any bracketed note to make the commentary appear more complete.'
5
Review the draft output and confirm that every account meeting your threshold has an entry and that no account below the threshold has been included.
6
Resolve every bracketed placeholder by pulling the relevant subledger report, accrual schedule or supporting document and writing the confirmed cause in plain language.
7
Trace each figure the assistant states (dollar amounts, percentages, period references) back to the trial balance CSV before the commentary is copied into the workpaper.
8
Have the responsible accountant or controller sign off on the final commentary as a named preparer step in the workpaper, not as an AI-generated exhibit.
The rule: A human with knowledge of the period must resolve all bracketed placeholders and trace all figures before the commentary enters any client report or workpaper.

WORKED EXAMPLE

In practice

A controller at a 12-entity services firm is closing the month just ended. She has a two-period trial balance for one entity as a CSV: 47 accounts, prior and current period balances, variance column already calculated. She needs flux commentary for the management report due in two days.

THE PROMPT
You are preparing month-end flux commentary for an internal workpaper. The attached trial balance shows two periods for a services company. For each account where the absolute variance exceeds $10,000, write two to three sentences explaining the likely cause based on the account name and the direction and size of the movement. Where the cause cannot be reasonably inferred from the account name alone, write the sentences you can support and add this note exactly: [Cause unconfirmed: reviewer to verify against subledger]. Group accounts under these headings: revenue, cost of services, operating expenses, other income and expense, balance sheet. Do not invent subledger detail. Do not remove bracketed notes.

What came back. The assistant returned commentary for 19 accounts, grouped correctly. Most revenue and payroll entries had clean two-sentence explanations consistent with the account labels and variance directions. Four accounts in prepaid expenses and intercompany receivables carried bracketed placeholders. One entry for a large increase in professional fees stated a cause (outside counsel costs) that was plausible but not supportable from the account name alone, and the controller added a placeholder there herself before moving on.

How it was checked. The controller opened the CSV alongside the draft and confirmed that every dollar figure the assistant cited matched the variance column exactly, and that no account below $10,000 had been included.

A constructed example. The prompt is usable as written; the figures show the shape of a result, not a measured one.

WHEN TO USE IT

 
You have a clean two-period trial balance export and a reviewer who knows the period.
 
The preparer's bottleneck is writing time, not account-level knowledge.
 
Commentary is needed for an internal management report or a workpaper first draft.
 
The entity's account names are descriptive enough to suggest cause without subledger access.

WHEN NOT TO

 
The reviewer is unfamiliar with the period and cannot evaluate whether the narrative is correct.
 
Account names are generic codes with no descriptive labels; the assistant has nothing to reason from.
 
The commentary will go directly to an external auditor or regulator without a human review pass.
The pitfall: An assistant that returns commentary with no bracketed placeholders has likely papered over ambiguous accounts. If the draft looks uniformly confident, treat it as a signal to slow down and check each entry manually.
FROM THE CAREER PORTAL
Upload your resume once. The portal does the rest.
Drop your resume into the career portal and it pulls every signal out of it, role history, skills, seniority, target comp, then feeds that into our matching engine. From one upload you get job matches ranked to your profile, recruiter contacts who place people like you, and a prioritized list of fixes to get your resume past the ATS. Tools that do a fraction of this charge around $40 a month and were never built for accounting. Ours is free, and the matching is tuned on accounting and finance profiles, not a general pool.

Attio is the #1 fastest-growing CRM on Brex and Ramp

Built for the most ambitious companies in GTM, Attio is an end to end revenue platform that allows teams to run multiple plays across different revenue motions and lifecycles.

Teams at the frontier are already building on it: Granola, turbopuffer, Modal, and many many more.

FROM OUR PARTNERS

Dext: collect client receipts without chasing
Receipts and bills arrive by app, email or supplier-portal fetch, get coded by supplier rules and publish to the ledger, with a separate price book for firms. Audit Friendly scored Dext 70/100 in a fact-checked review. We earn a referral fee if you sign up, and the score is not affected.
Rewards for sharing
Share Modern Accounting. Unlock free rewards.
1
AI Starter Kit
1 friend · 10 copy-ready prompts for everyday work
Free gift
3
Close Prompt Playbook
3 friends · All 20 month-end prompts with reviewer's guides
$39 value
5
Playbook + Close Skills
5 friends · The Playbook plus five Claude skills: bank rec, flux review, duplicate payments, deferred revenue and journal entry review
$99 value
10
Month-end close kit
10 friends · The Playbook, the Close Skills and the AI-assisted month-end close workflow
$149 value
Your personal share link and your count are right below. Each friend who confirms their subscription counts. Rewards arrive by email.
Month-end close kit
The whole month-end close, with AI doing the first pass.
The AI-assisted month-end close workflow, the Close Prompt Playbook and all five Close Skills in one kit. One payment, 30-day refund.
Get the close kit, $149 →
New: the AuditFriendly Library, 49 close, audit and bookkeeping tools from $9, some free. Playbook buyers get the matching Library items free. Browse the Library

GO DEEPER

Go deeper

Software reviews → Fact-checked vendor reviews with verdicts and pricing
AF Stack Designer → Design your accounting stack in ten minutes
Skills that pay → Which named tools move the number
Software in postings → Every tool ranked by live demand

Next issue: more of the tools and shifts reshaping how accounting gets done.

Forward this to the partner still doing it the old way.

An original workflow written for practitioners. Replicate it in a sandbox first; nothing here replaces your review.

How accountants are using AI, automation and smarter workflows to close faster, audit cleaner, and free up time for real work.

More from AuditFriendly
Month End Closers · Everything that moved in accounting this week
Accounting Stack · The software, head to head
The Remote Accountant · Remote accounting roles with pay, every weekday
The Finance Nomad · Remote finance roles with pay, every weekday
Want to reach these readers? Advertise with us. Sponsors buy the slot, never the coverage.

Audit Friendly · modernaccounting.ai · Audit Friendly Data