Flux Analysis and Variance Commentary
Paste two periods of a profit and loss. Get the variance table, the lines that cross your thresholds, the margin bridge, and a commentary draft for each line with every figure filled in from the table, so no number in the narrative can disagree with the numbers above it.
Run the flux
The variance column takes a second. Deciding which lines need a sentence, and writing sentences whose numbers match the table, takes the rest of the afternoon. This does the first part and drafts the second.
Your profit and loss
Two periods
One row per line: the account, the current period, the comparison period.
corbel-analytics-pl-sep-aug-2026.csv · 16 lines. Paste from a spreadsheet, or open a comparative P&L export from QuickBooks Online or Xero. Headings and totals are read and checked.
Columns
Income · Subscription revenue · Services revenue
· 1842000.00 · 214000.00
· 1786500.00 · 168000.00
Optional. Headings in the file set the section otherwise.
What needs a sentence
Set the dollar amount to your materiality, and keep the same thresholds every month.
A line must move at least this much.
And at least this percentage, or either one, by the rule below.
Both keeps a large line with a small percentage move quiet; either flags it.
Used in the commentary: against August, against budget.
Runs entirely in your browser. Nothing you enter is sent to us or stored.
Your flux
Updates as you type
Lines over your thresholds
7 of 16
Operating income $114,400 against $66,400, up $48,000. Gross margin 81.6%, down 0.5 points.
- Pass3 totals in your file agree with the lines read
- NoteRow 11, Gross ProfitA computed row. The tool works its own out from the lines.
- NoteRow 25, Net Operating IncomeA computed row. The tool works its own out from the lines.
- NoteRow 26, Net IncomeA computed row. The tool works its own out from the lines.
Every line
| Line | Current | August | Change | % | Flag |
|---|---|---|---|---|---|
| Subscription revenue | $1,842,000 | $1,786,500 | +$55,500 | +3.1% | |
| Services revenue | $214,000 | $168,000 | +$46,000 | +27.4% | Flagged, favorable |
| Hosting | $196,400 | $171,200 | +$25,200 | +14.7% | Flagged, unfavorable |
| Support salaries | $142,800 | $140,100 | +$2,700 | +1.9% | |
| Third-party software | $38,200 | $37,900 | +$300 | +0.8% | |
| Sales salaries | $412,000 | $398,500 | +$13,500 | +3.4% | |
| Commissions | $96,300 | $71,800 | +$24,500 | +34.1% | Flagged, unfavorable |
| Marketing programs | $128,000 | $182,500 | -$54,500 | -29.9% | Flagged, favorable |
| R&D salaries | $538,000 | $531,200 | +$6,800 | +1.3% | |
| G&A salaries | $164,000 | $161,300 | +$2,700 | +1.7% | |
| Professional fees | $88,400 | $46,100 | +$42,300 | +91.8% | Flagged, unfavorable |
| Rent | $62,000 | $62,000 | 0 | 0.0% | |
| Software subscriptions | $41,700 | $40,900 | +$800 | +2.0% | |
| Travel | $19,600 | $8,400 | +$11,200 | +133.3% | Flagged, unfavorable |
| Recruiting | $0 | $22,000 | -$22,000 | Gone | Flagged, favorable |
| Depreciation | $14,200 | $14,200 | 0 | 0.0% |
Sections and margins
| Current | August | Change | |
|---|---|---|---|
| Revenue | $2,056,000 | $1,954,500 | +$101,500 |
| Cost of revenue | $377,400 | $349,200 | +$28,200 |
| Gross profit | $1,678,600 | $1,605,300 | +$73,300 |
| Operating expenses | $1,564,200 | $1,538,900 | +$25,300 |
| Operating income | $114,400 | $66,400 | +$48,000 |
| Gross margin | 81.6% | 82.1% | -0.5 points |
| Operating margin | 5.6% | 3.4% | +2.2 points |
- Operating income, August
- $66,400
- Plus the change in revenue
- +$101,500
- Less the change in cost of revenue
- -$28,200
- Less the change in operating expenses
- -$25,300
- Operating income, current
- $114,400
Commentary
Every figure is filled in from the table. Add a short note on what drove each line; with no note, the draft keeps [What drove it] so the open question stays visible.
Services revenue rose $46,000 (27.4%) against August, to $214,000. [What drove it]
In your words. It is added to the draft as you typed it.
Hosting rose $25,200 (14.7%) against August, to $196,400. [What drove it]
In your words. It is added to the draft as you typed it.
Commissions rose $24,500 (34.1%) against August, to $96,300. [What drove it]
In your words. It is added to the draft as you typed it.
Marketing programs fell $54,500 (29.9%) against August, to $128,000. August trade show; nothing comparable in Sept.
In your words. It is added to the draft as you typed it.
Professional fees rose $42,300 (91.8%) against August, to $88,400. Q3 audit fieldwork billed in Sept, one-off.
In your words. It is added to the draft as you typed it.
Travel rose $11,200 (133.3%) against August, to $19,600. [What drove it]
In your words. It is added to the draft as you typed it.
Recruiting fell to nil from $22,000 in August. Two agency placements paid in Aug.
In your words. It is added to the draft as you typed it.
- Runs entirely in your browser. Your profit and loss is never uploaded and we never see a line or an amount.
Related reading
Where the explanation for a variance actually lives, and what it takes to write commentary whose figures match the statement.
- Glossary
Variance Analysis
Variance analysis compares an actual result against a benchmark, usually budget, forecast, or prior period, and explains the difference with specific, evidenced causes. It is distinct from flux analysis, which reviews period-over-period fluctuations during the close.
- Glossary
Record to Report (R2R)
Record to report (R2R) is the finance process tower that runs from posting a transaction to publishing the financial statements built from it: recording, closing, consolidating, and reporting. It is the enterprise term for the whole cycle the month-end close sits inside.
- Integration
QuickBooks
QuickBooks is a cloud-based accounting platform that enables businesses to manage finances, track income and expenses, and gain real-time insights into their financial performance.
- Integration
Xero
A cloud-based accounting platform that helps small businesses manage invoicing, expenses, payroll, and financial reporting.
- Use case
Financial Reporting
- Use case
Month-End Close
- Free tool
Financial Ratio Calculators
- Free tool
Month-End Close Checklist
How flux analysis works
What a flux is for
A flux analysis compares each line of the financial statements with another period and explains the lines that moved more than expected. It does two jobs. As a review step in the close, it catches errors: an accrual booked twice, a reversal that did not reverse, an invoice coded to the wrong account all show up as a line that moved for no business reason. As a report, it tells the CFO, the board or the auditors what happened in the month in a few sentences per line.
The first job is the one that matters most and gets the least time, because the second has a deadline.
Choosing the comparison
| Comparison | What it is good for |
|---|---|
| Prior month | Catching close errors. Most recurring costs should be flat month to month, so a move stands out |
| Same month last year | Seasonal businesses, where the prior month is the wrong baseline |
| Budget | Performance against plan, for FP&A and the board |
| Prior quarter | Quarterly reporting and audit committee packs |
A close review is usually against the prior month. A board pack is usually against budget and last year. They are different analyses with different thresholds, and this tool runs one comparison at a time.
Setting thresholds
Most teams set a dollar threshold and a percentage threshold together and explain a line when it crosses both. The dollar threshold keeps small lines with large percentage swings out: travel going from $400 to $1,200 is 200 percent and not worth a sentence. The percentage threshold keeps large stable lines out: a $1.8 million revenue line that moves $55,000 has moved 3 percent, which is ordinary.
Auditors often set flux thresholds from materiality, and some teams use a lower dollar threshold for review than for reporting. Choose the rule deliberately and keep it: a threshold that changes month to month makes the flux impossible to compare.
Favorable and unfavorable
A change is favorable when it raises income: revenue up, or a cost down. That is why each line needs its section. The tool never guesses a section from a line name, because "Refunds" can be negative revenue in one company's chart and an expense in another's.
Favorable is not the same as good. Marketing spend falling by 30 percent is favorable to income this month and may be a campaign that was paused by mistake. The flag says the line moved, and the commentary says whether that is a problem.
Writing commentary a reader can use
Good commentary names the cause, says whether it will recur, and gives the figure that matters. "Professional fees rose $42,300 because third-quarter audit fieldwork was billed in September; not expected to recur" tells the reader everything. "Professional fees increased due to higher professional fees" tells them nothing, and so does "timing".
The figures in the commentary must be the figures in the table. When commentary is written by hand after the numbers change, the two drift apart, and the first question in the review meeting is which one is right. That is why this tool fills every figure in from the table and never lets anyone type one.
Why the totals in your file are checked
A flux built from a paste can lose a line without anyone noticing: a row skipped in the selection, a subtotal pasted as a line, a section header with an amount in it. When the file has its own totals, the tool compares each one with the sum of the lines it read, and stops on any difference. A flux that does not add up to the statement it explains is the wrong flux.
Worked example
The sample the tool loads. Invented.
Corbel Analytics sells data quality software to mid-market retailers on annual subscriptions and runs a small implementation services team. The controller writes a monthly flux for the CFO against the prior month. This is September 2026 against August.
Thresholds: $10,000 and 10 percent, both.
The flux table:
| Line | Section | September | August | Change | % | |
|---|---|---|---|---|---|---|
| Subscription revenue | Revenue | 1,842,000 | 1,786,500 | +55,500 | +3.1% | |
| Services revenue | Revenue | 214,000 | 168,000 | +46,000 | +27.4% | Flagged, favorable |
| Hosting | Cost of revenue | 196,400 | 171,200 | +25,200 | +14.7% | Flagged, unfavorable |
| Support salaries | Cost of revenue | 142,800 | 140,100 | +2,700 | +1.9% | |
| Third-party software | Cost of revenue | 38,200 | 37,900 | +300 | +0.8% | |
| Sales salaries | Operating expense | 412,000 | 398,500 | +13,500 | +3.4% | |
| Commissions | Operating expense | 96,300 | 71,800 | +24,500 | +34.1% | Flagged, unfavorable |
| Marketing programs | Operating expense | 128,000 | 182,500 | -54,500 | -29.9% | Flagged, favorable |
| R&D salaries | Operating expense | 538,000 | 531,200 | +6,800 | +1.3% | |
| G&A salaries | Operating expense | 164,000 | 161,300 | +2,700 | +1.7% | |
| Professional fees | Operating expense | 88,400 | 46,100 | +42,300 | +91.8% | Flagged, unfavorable |
| Rent | Operating expense | 62,000 | 62,000 | 0 | 0.0% | |
| Software subscriptions | Operating expense | 41,700 | 40,900 | +800 | +2.0% | |
| Travel | Operating expense | 19,600 | 8,400 | +11,200 | +133.3% | Flagged, unfavorable |
| Recruiting | Operating expense | 0 | 22,000 | -22,000 | Gone | Flagged, favorable |
| Depreciation | Operating expense | 14,200 | 14,200 | 0 | 0.0% |
Seven lines are flagged. Subscription revenue moved the most dollars of any line, $55,500, and is not flagged, because 3.1 percent is inside the threshold. Under the either rule it would be, and so would sales salaries, for nine lines in all.
Sections and margins:
| September | August | Change | |
|---|---|---|---|
| Revenue | 2,056,000 | 1,954,500 | +101,500 |
| Cost of revenue | 377,400 | 349,200 | +28,200 |
| Gross profit | 1,678,600 | 1,605,300 | +73,300 |
| Gross margin | 81.6% | 82.1% | -0.5 points |
| Operating expenses | 1,564,200 | 1,538,900 | +25,300 |
| Operating income | 114,400 | 66,400 | +48,000 |
| Operating margin | 5.6% | 3.4% | +2.2 points |
The bridge: August operating income $66,400, plus $101,500 of revenue, less $28,200 of cost of revenue, less $25,300 of operating expenses, is September's $114,400.
What the controller sees first. Gross margin fell half a point while revenue grew 5.2 percent, because hosting grew 14.7 percent, nearly three times as fast. That is the line worth the most attention in the review: either usage grew ahead of billing, or a hosting invoice landed in the wrong month.
The commentary, with the controller's notes:
| Line | Note typed | Draft |
|---|---|---|
| Professional fees | Q3 audit fieldwork billed in Sept, one-off | Professional fees rose $42,300 (91.8%) against August, to $88,400. Q3 audit fieldwork billed in Sept, one-off. |
| Marketing programs | August trade show; nothing comparable in Sept | Marketing programs fell $54,500 (29.9%) against August, to $128,000. August trade show; nothing comparable in Sept. |
| Recruiting | Two agency placements paid in Aug | Recruiting fell to nil from $22,000 in August. Two agency placements paid in Aug. |
| Hosting | left empty | Hosting rose $25,200 (14.7%) against August, to $196,400. [What drove it] |
The hosting line keeps its placeholder, so the open question goes into the review rather than out of the memo.
What this does not do
This tool compares two columns you give it. It does not connect to your ledger, look at transactions or invoices, or know why a line moved: the explanations come from your notes. It runs one comparison at a time, for one entity, and does not consolidate. Commentary drafts are wording for a person to review and approve, not an audit procedure or a substitute for one.
Questions
A comparison of each line of the financial statements with another period, usually the prior month, the same month last year or the budget, with an explanation for each line that moved more than a set threshold. It is a review step in the month-end close and the basis of the commentary in a management or board report.
Mostly the audience. Accountants say flux for the period-over-period review in the close. FP&A says variance analysis for actual against budget. The arithmetic is the same: the change in dollars, the change in percent, and an explanation for the ones that matter.
A dollar amount and a percentage together, with a line explained when it crosses both. Many teams set the dollar amount from audit materiality or a share of it. What matters most is keeping the same thresholds every month, so the flux can be compared over time.
From you. Every figure in a draft is filled in from the table, and the reason is the note you typed for that line. A line with no note keeps a visible placeholder, because a variance nobody has explained should look unexplained.
The table and thresholds work for any two columns of balances. Favorable and unfavorable, the margins and the bridge only make sense for a profit and loss, so for a balance sheet set every line's section to Other and ignore those columns.
No. The table is built in your browser. Nothing is sent to us and nothing is kept when you close the tab.
Every variance explained.
Every figure traced.
Statements assembled from every entity's ledger, each variance explained against the transactions that caused it, and commentary whose figures come from the statement, never from the writer. Your team approves the package before it goes anywhere.
