Tools
Free tools that run in your browser, a free Excel template, plus one paid workbook. Nothing you enter in the free tools leaves your machine.
New to this? Watch a whole flux review run first, on a synthetic company. After that, roughly in the order you'd use them during a close: flux-ready to see what's unblocked, account breakdown or the template to organize and flag what needs explaining, then the commentary test to grade what you wrote before it goes to review. For a revenue movement driven by products, the price volume mix calculator splits it into drivers first. The template is the free single-workbook version: paste two periods of balances, flag, explain. The $79 system is the step up: it starts from your trial balance, builds both flux statements and ranks what to investigate.
A full flux review of one synthetic company’s August close, step by step: read the export, check it ties to the trial balance, compute the movements, flag what crossed both thresholds, show pre-written draft commentary beside the computed drivers, and list what still needs a person. Delete a transaction or flip a sign and the review stops, naming the account and the amount. Export the finished workpaper as a formula-based Excel file. Before a review like this reads any export, check it’s complete: general ledger doesn’t match the trial balance.
Paste raw GL or sub-ledger detail and get it organized by whatever dimension matters — customer, vendor, program — current period against prior, sorted by what moved. Flags categories that are new and ones that disappeared.
The pivot you build by hand every period, done in a second. Nothing is uploaded or stored.
Paste units and revenue by product for two periods. It splits the revenue movement into volume, mix, price, new products and lost products, and the pieces add up to the movement, with any rounding shown on its own line. Driver lines come out ready to paste into commentary, with an optional dollar tie-out to the GL revenue movement.
Two periods of actuals, revenue only: no budget, no currency. Nothing you enter leaves your browser.
Open the price volume mix calculator
Paste your prepaid register. You get each month's expense, a roll-forward tied to the prepaid balance on your trial balance, the current and non-current split, and the journal entry for the month you're closing. Equal monthly amounts or actual days; paid-in-advance and recorded-late items handled and named. Download it all as an Excel workpaper with the roll-forward and entry as formulas.
The entries step by step, with a worked example that matches the calculator: prepaid expense journal entry.
Paste your contracts with amount, service start and end. You get the monthly revenue waterfall, a roll-forward tied to deferred revenue on your trial balance, the current and non-current split, and the entry. For revenue earned evenly over the service period; no signup, and nothing you paste leaves your browser. Downloads as an Excel workpaper too.
The entries behind it, with worked numbers that match the tool: deferred revenue journal entry.
Open the deferred revenue schedule
Paste two periods of balances and see, for every pair of dollar and percentage thresholds, how many accounts you'd have to explain, how much movement you'd leave unflagged, and the largest account that would slip through. Both-or-either logic, the same rule as the free template. Use it on a finished close, then write the setting down.
Enter the statement balance, the GL cash balance and the items that didn't match. It gives adjusted bank and book balances, the unexplained difference in dollars, and, when it doesn't tie, which item would close the gap if it were removed, flipped or had two digits swapped. It also flags old deposits in transit and stale checks against limits you set, and lists the entries the books still need.
What each reconciling item means, who owns it, and which ones need an entry: bank reconciling items.
Open the bank reconciliation calculator
Paste your weekly and biweekly pay groups with their pay calendar, pay lag and gross per period. It gives the unpaid days at month end, the accrued wages and on-cost, the entry for either reversing method, and how much of the month's payroll expense move is just the day count. No holiday calendar or statutory tax rates; the on-cost rate is yours.
Open the payroll accrual calculator
Paste foreign-currency balances with their carrying amounts and closing rates, quoted either way. It gives the unrealized gain or loss by balance and by currency, a balanced entry with the net to your gain/loss account, and a flag when a carrying amount implies a rate that looks like the closing rate upside down, which usually means a rate was entered the wrong way round. Download it all as an Excel workpaper where every figure is a formula. Revaluation of balances only; no translation or realized gains.
The revaluation step by step, with a worked example that matches the calculator: foreign currency revaluation example.
Open the FX revaluation calculator
Paste budget and actual by account. It gives each line's variance in dollars and percent of budget, favorable or unfavorable by line type, the lines that cross your dollar and percent thresholds (largest first, with a plain sentence for each), and a check that the drivers you enter add up to the variance. Ties actual net income to your trial balance if you enter it, and downloads as an Excel workpaper.
The method step by step, with a worked example that matches the tool: budget vs actual variance analysis.
Paste your fixed asset register and pick the month. It gives each asset's straight-line book depreciation (full-month, month-after or mid-month convention), the cost and accumulated depreciation roll-forward from beginning to ending, the gain or loss on disposals, the depreciation and disposal entries, and the difference against your trial balance. Downloads as an Excel workpaper. Book depreciation only; no tax lives.
The roll-forward step by step, with a worked example that matches the tool: fixed asset roll-forward example.
Open the fixed asset roll-forward
Thirty-six close steps in dependency order, each with what done looks like and a link to the tool for it. Owner, due day and status per step, and a summary by phase of what's still open.
Formula-only — no macros, no add-ins.
Paste two periods of account balances, set a dollar and a percentage threshold, and it flags what needs explaining. Driver lines, an unexplained residual, and a direction check on each account.
Formula-only — no macros, no add-ins. Works in Excel, Google Sheets and LibreOffice.
Flux doesn't have to wait for the whole close to finish. Tick off milestones as they complete — subledgers closing, reserves booked, accruals posted — and account groups turn ready the moment everything feeding them has landed.
Set your dependencies once; it saves in your browser only. Nothing sent anywhere, no account needed.
Open the flux readiness tracker
The four computed tests, running on a page. Enter the accounts you're reviewing and the driver lines behind each one; coverage, direction, sourcing and specificity are graded as you type. The fifth test is judgment and stays yours.
It opens with six worked examples already in it. Nothing you enter leaves your browser — the page has no server, and it saves your work in this browser only.
A made-up distributor's September close in one Excel file: trial balance, GL detail, product sales and the notes you'd collect during a close. Work the flux review with the tools above, then check it against the answer key, including the two things that are booked wrong.
The questions a reviewer asks before signing off on flux commentary. It's a review artifact, not a template: run it against a schedule you've already prepared and it surfaces what's missing.
The working version of the same discipline, built around your trial balance.
Formula-only throughout. No macros, no Power Query, no dynamic arrays — INDEX/MATCH rather than XLOOKUP, so it opens in older Excel installs. Holds up to 80 trial balance lines and compares two periods, not budget to actual.
The same fixed-asset tie-out from the agent cold tests log, packaged to run yourself: the workbook, the client's two exports, the engagement note, and a formula-only grading sheet with the reference answer already in it. Hand it to your own agent, then grade the result yourself — nothing sent back to me.
It isn't a close management platform, an ERP integration, or a substitute for your own judgment on materiality — those thresholds get set during risk assessment and control scoping, not by a spreadsheet. It's a structure for work you're already doing, so you stop rebuilding it every month.
Related: flux analysis vs variance analysis, the method behind these in how to run month-end flux, and four of the five tests your commentary fails are arithmetic.
Found something wrong or missing? Tell me here — anonymous, thirty seconds.