Free tool

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.

Profit and loss

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

Every line, both periods, and the change
LineCurrentAugustChange%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,00000.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,000GoneFlagged, favorable
Depreciation$14,200$14,20000.0%

Sections and margins

Section totals and margins for both periods
CurrentAugustChange
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 margin81.6%82.1%-0.5 points
Operating margin5.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.

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

ComparisonWhat it is good for
Prior monthCatching close errors. Most recurring costs should be flat month to month, so a move stands out
Same month last yearSeasonal businesses, where the prior month is the wrong baseline
BudgetPerformance against plan, for FP&A and the board
Prior quarterQuarterly 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:

LineSectionSeptemberAugustChange%
Subscription revenueRevenue1,842,0001,786,500+55,500+3.1%
Services revenueRevenue214,000168,000+46,000+27.4%Flagged, favorable
HostingCost of revenue196,400171,200+25,200+14.7%Flagged, unfavorable
Support salariesCost of revenue142,800140,100+2,700+1.9%
Third-party softwareCost of revenue38,20037,900+300+0.8%
Sales salariesOperating expense412,000398,500+13,500+3.4%
CommissionsOperating expense96,30071,800+24,500+34.1%Flagged, unfavorable
Marketing programsOperating expense128,000182,500-54,500-29.9%Flagged, favorable
R&D salariesOperating expense538,000531,200+6,800+1.3%
G&A salariesOperating expense164,000161,300+2,700+1.7%
Professional feesOperating expense88,40046,100+42,300+91.8%Flagged, unfavorable
RentOperating expense62,00062,00000.0%
Software subscriptionsOperating expense41,70040,900+800+2.0%
TravelOperating expense19,6008,400+11,200+133.3%Flagged, unfavorable
RecruitingOperating expense022,000-22,000GoneFlagged, favorable
DepreciationOperating expense14,20014,20000.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:

SeptemberAugustChange
Revenue2,056,0001,954,500+101,500
Cost of revenue377,400349,200+28,200
Gross profit1,678,6001,605,300+73,300
Gross margin81.6%82.1%-0.5 points
Operating expenses1,564,2001,538,900+25,300
Operating income114,40066,400+48,000
Operating margin5.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:

LineNote typedDraft
Professional feesQ3 audit fieldwork billed in Sept, one-offProfessional fees rose $42,300 (91.8%) against August, to $88,400. Q3 audit fieldwork billed in Sept, one-off.
Marketing programsAugust trade show; nothing comparable in SeptMarketing programs fell $54,500 (29.9%) against August, to $128,000. August trade show; nothing comparable in Sept.
RecruitingTwo agency placements paid in AugRecruiting fell to nil from $22,000 in August. Two agency placements paid in Aug.
Hostingleft emptyHosting 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

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.