Month·End·Close

Flux & Variance

Month-end flux analysis that survives review

Most flux commentary gets sent back for the same handful of reasons. These are workbooks, checklists and worked examples for getting it right the first time — built by someone who runs a close, not a content team.

What can I flux right now? Grade your commentary

Free tools that run in your browser, plus a free Excel template. Nothing sent anywhere.

What this covers

Flux and variance, specifically. Not the whole close.

That's a deliberate limit. Variance commentary is the part of close where the work is least standardized, most subjective, and most likely to come back with questions attached — and it's the part where a repeatable structure saves the most time. Everything here is built for that.

Who it's for

Controllers, senior accountants and FP&A managers who prepare or review flux schedules on a monthly cycle, and who would rather not rebuild the same structure every period.

The working assumptions

Start with month-end flux

If you're here for the flux review specifically, month-end flux: what it is and how to run it is the full method: what the comparison is, the steps to run it in one close, the five properties of commentary that holds up, and where each piece is covered in depth. New to it? Start with the definition. Want to try it? Work a full practice case with an answer key.

Here for agents specifically? Getting started with agents in month-end close is the order to do it in — vocabulary, which accounts are worth trying, testing one before it touches anything real, and what still needs a person.

Free tools

They run entirely in your browser, no signup. Plus a free Excel template. Nothing sent anywhere. See all tools.

New: flux analysis demo — watch a checked flux review run on a synthetic company, then break the export and watch it stop.

Free · in the browser

What can I flux right now?

Tick off what's closed as close progresses — subledgers, reserves, accruals — and see which account groups just became explainable. Because flux doesn't have to wait for the whole close to finish.

Open the tracker

Free · in the browser

Account breakdown

Paste raw GL detail and get it organized by customer, vendor, or program — current against prior, sorted by what moved. Flags what's new and what disappeared.

Open the breakdown tool

Free · in the browser

The commentary test

Grades flux commentary you've already written: do the drivers account for the movement, point the right direction, cite a source, avoid filler. Opens with six worked examples.

Open the test

Free · in the browser

Price volume mix calculator

Paste units and revenue by product for two periods and split the revenue movement into volume, mix, price, new and lost products. The pieces add up to the movement, with any rounding shown on its own line.

Open the calculator

Free · in the browser

Prepaid and deferred revenue schedules

Paste a prepaid register or a contract list. Get the monthly schedule, a roll-forward tied to your trial balance, the current and non-current split, and the entry.

Prepaid schedule Deferred revenue

Free · in the browser

Flux thresholds

Paste two periods of balances and see how many accounts each dollar and percentage setting would flag, and the largest movement it would let through. Set a threshold on evidence, then write it down.

Open the threshold grid

Free · in the browser

Bank reconciliation calculator

Enter the statement balance, the GL balance and the reconciling items. Get the unexplained gap, where to look first when it doesn't tie, stale items past your limits, and the entries the books still need.

Open the calculator

Free · in the browser

Payroll accrual calculator

Paste weekly and biweekly pay groups with their pay lag. Get the unpaid days at month end, accrued wages and on-cost, the entry, and how much of the payroll expense move is just the day count.

Open the calculator

Free · in the browser

FX revaluation calculator

Paste foreign-currency balances, carrying amounts and closing rates. Get the unrealized gain or loss by account and currency, the entry, and a flag when a rate looks entered the wrong way round.

Open the calculator

Free · in the browser

Budget vs actual

Paste budget and actual by account. See which variances to explain, favorable or unfavorable, and whether your explanation adds up to the number.

Open the tool

Free · in the browser

Fixed asset roll-forward

Paste your asset register. Get monthly book depreciation, the cost and accumulated depreciation roll-forward, disposal gains and losses, the entries, and the tie to your trial balance.

Open the tool

Free · Excel download

Flux analysis template

Paste two periods of balances, set your thresholds, and it flags what needs explaining — with a residual that tells you whether your drivers actually add up. Formula-only, no macros.

Get the template

Also free: the Reviewer Red-Flag Checklist. Or the CloseOps Flux & Variance System ($79) — starts from your trial balance and builds both flux statements once you confirm each account's classification.

Notes

Flux & Variance

Getting started

Checklist · free ExcelMonth-end close checklist: every step, and what done looks like

Thirty-six steps in dependency order, from cutoff to sign-off, each with the evidence that shows it's done and a link to the free tool for it.

Start here if you're newWhat is flux analysis in accounting?

What it is, why it isn't taught in coursework, what the work actually involves, and the mistake almost everyone makes first.

TerminologyFlux analysis vs variance analysis: what's the difference?

The words get used interchangeably. What actually differs is what the comparison tests and where the answer lives.

Worked exampleBudget vs actual variance analysis: a worked example

How to calculate budget variances, label them favorable or unfavorable, choose which to explain, and check that the explanation adds up, on a fifteen-line income statement.

General ledger doesn't match the trial balance? Check the export first

Both reports usually come from the same postings. When they disagree, suspect the export — and one per-account check finds the account and the amount.

Month-end flux: what it is and how to run it

Start here. What month-end flux is, the steps to run it in one close, the five properties of commentary that survives review, and where each piece is covered in more depth.

Why some accounts are fasterThe accounts you can flux fastest are the ones you booked yourself

Flux difficulty tracks entry familiarity, not account size — which changes when in the close you can actually start.

Late entries after commentaryCommentary written against a balance that then moved

A late entry lands after commentary is already finished. The residual test still applies — it just has to run a second time.

The first days of closeWhy month-end close takes so long to start

AR billing, cash application and the bank rec loop that sends exceptions back. Where the waiting comes from, and how to cut the round trips.

When automated flux drafting helps, and when it costs you more

Set a tool to draft one account's commentary while you work another by hand. It only saves time if the account could actually be drafted.

Worked exampleFlux analysis example: a revenue account and a receivables account worked through

Two accounts start to finish — the pull, the pivot, the drivers, the residual, and the finished commentary. Illustrative figures.

By statement, and rolled-up lines

Income statementIncome statement flux analysis: explaining what drove the period

The accounts reset, so you pull both periods. Volume, rate and mix — and the blind spot for an expense that should have been incurred and wasn't.

Balance sheetBalance sheet flux analysis: how to explain what moved

The balance carries forward, so one month of detail is already the movement. How the common accounts behave and what thresholds miss.

Income statement flux and balance sheet flux need different data

A month of income statement detail is the balance. A month of balance sheet detail is already the movement.

Consolidated reporting linesExplaining a line that isn't an account

A group reporting line is several of your accounts, and may be measured against a different comparison than your internal review runs.

What thresholds missFlux flags what moved. The exceptions are structural.

A variance threshold compares an account to itself. Most of what actually goes wrong is caught by a different comparison entirely.

Writing and reviewing commentary

Four of the five tests your flux commentary fails are arithmetic

Coverage, direction, sourcing and specificity are computable. Only causation actually needs a person.

Two systems disagreeingWhen the operational report and the GL don't agree

Two systems computing the same figure, both correct, not tying. Which movements are real and which are artifacts of the difference.

Why flux commentary gets sent back

Three reasons, none of them about the numbers being wrong — and what a reviewer is actually checking.

Why your flux commentary keeps getting rewritten

The control tests that commentary is present. Everything past that is reviewer preference, applied under deadline — which is why yours gets rewritten.

Why AI can explain some accounts and not others

The constraint isn't the prompt. It's whether the reason for the movement is retrievable at all.

What flux review doesn't catch

One of a handful of controls reached for repeatedly, alongside reconciliations and JE review. Its detection mechanism is movement — which leaves a narrow residual.

Explaining an account made of forty small charges

Material in aggregate, immaterial line by line. How to write it up without pretending you investigated all of it.

Agents & Automation

Getting started with agents in month-end close

Start here. The vocabulary, which accounts are even worth trying, testing one before it touches anything real, and what still needs a person.

What agents can and cannot do in the close

Agents can prepare the close — pulling exports, matching rules, drafting first passes. The judgment calls, and the commentary review standard, still sit with a person.

Standing logCold tests of agents on real close work

An agent, a real close task, a reference answer computed in advance, and a formula-driven grade — not a self-report. First entry: a fixed-asset-to-GL tie-out.

Journal Entries & Estimates

TerminologyTrue-up in accounting: what it is and when you book one

Estimate-to-actual and balance-to-target both get called a true-up. Worked examples of both, and what a same-direction run of them can mean.

TerminologyReclass vs adjusting entry: what's the difference?

A reclass moves an amount; an adjusting entry changes it. The published definitions conflict — and the label matters less than the impact.

TerminologyReversing entries: which accruals to reverse

A reversing entry cancels itself out on day one of the next period; a non-reversing one stays booked. Which accruals belong in each category, and when not to use one.

TerminologyTopside entries: what they are, with a worked example

Manual adjustments to consolidated numbers, made outside the entity ledgers. A worked cutoff example: the entries, each month, and what flux sees.

Worked exampleFixed asset roll-forward: what it is, with a worked example

Cost and accumulated depreciation, beginning to ending: an addition, a disposal with a gain, the entries, and what a difference against the trial balance usually means.

Worked exampleForeign currency revaluation: the journal entry, with a worked example

Which balances get restated at the closing rate, the unrealized gain or loss on receivables and payables, the entry, and the two mistakes that produce a large wrong number.

Worked examplePrepaid expense journal entry, with an amortization schedule example

The entry when a prepaid is paid and each month after, a seven-item register at a September close, items paid early or recorded late, and the tie to the trial balance.

Worked exampleDeferred revenue journal entry with monthly recognition

The billing entry, the monthly recognition entry, and the roll-forward that ties the contract list to the trial balance.

Bank reconciliationBank reconciling items: what each exception means

Deposits in transit, outstanding checks, NSF, fees and errors: which side each sits on, who owns it, and which ones need an entry.

What actually goes into an accounting estimate

The entry is two lines. The method behind it — grouping, data window, documented rationale — is the part that has to hold up.

Recurring entries going staleThe judgment happens once. The entry gets prepared every month.

A recurring JE's design gets thought through once. Preparation is mechanical after that — until the business outgrows the design and nothing flags it.

Fixes deferred during close"Fix it next month" is not a schedule

Correcting this period's number and rebuilding the process behind it are two different decisions. Only one of them can wait.

Reports missing new accountsThe report was right when it was built. That's the problem.

A report scoped to a fixed list of accounts or vendors doesn't know when the business adds a new one. Nothing about running it monthly tells you.

Tools

Free, in the browserFlux analysis demo — watch a checked review run, then break it

A full flux review on a synthetic company, step by step. Delete a transaction or flip a sign and it stops, naming the account and the amount. Exports a formula-based workpaper.

Free, in the browserAccount breakdown — organize GL detail by driver

Paste raw detail, get it grouped by customer, vendor or program, current against prior, sorted by what moved. Flags what's new and what disappeared.

Excel downloadFree flux analysis Excel template

Paste two periods of balances, set your thresholds, get flagged accounts and a residual. Formula-only, no signup.

What can I flux right now?

Tick off what's closed during the month and see which accounts just became explainable. Free, runs in your browser.

The commentary test — run the four computed tests

Enter your accounts and driver lines. Coverage, direction, sourcing and specificity answer themselves. Nothing you enter leaves your browser.