What threshold triggers a flux explanation?

Short answer

Most teams require an explanation when a change passes both a dollar amount and a percentage, such as $25,000 and 10%, often set by account.

A threshold keeps flux review focused. Without one, the team explains every line, including changes too small to matter. Set too high, a real misstatement passes without a second look. The threshold is a close policy: documented, applied the same way every period, and reviewed when the business changes.

How a dual threshold works

Using both a dollar and a percent test filters out two kinds of noise: large percentage swings on small balances, and small percentage moves on very large ones. With a threshold of $25,000 and 10%:

ChangeDollar changePercent changeExplanation required?
Software expense, $20,000 to $28,000$8,00040%No, under the dollar threshold
Payroll expense, $600,000 to $630,000$30,0005%No, under the percent threshold
Accrued liabilities, $150,000 to $190,000$40,00027%Yes, passes both
New legal reserve, $0 to $60,000$60,000Not meaningfulYes, flagged on the dollar amount

Some teams flip the logic and require an explanation when either test is met, which catches more lines and creates more work. Others add a dollar ceiling that always triggers an explanation, whatever the percentage.

How thresholds are set

  • Start from materiality: The dollar amount is often anchored to a fraction of the materiality level used for the financial statements, so anything that could matter to a reader gets reviewed.
  • Vary by account: Cash, revenue, and accrued liabilities often get tighter thresholds than accounts that move on a fixed schedule, such as depreciation.
  • Handle new and zeroed accounts: An account that goes from zero to a balance, or back to zero, has no meaningful percent change, so it's tested on the dollar amount alone.
  • Line up with the auditors: Thresholds close to what external auditors expect mean close explanations can double as audit support.

Keeping thresholds consistent

  • Document the policy: Record the thresholds, the comparison periods, and who reviews the explanations.
  • Don't adjust mid-close: Changing a threshold to avoid an explanation defeats the control.
  • Revisit when the business changes: An acquisition or a step change in revenue usually means the old dollar amount no longer fits.

Setting the threshold in Ramp Stack

In Ramp Stack, the threshold policy is written once in a skill and applied at every close.

StepHow it works in Stack
Write the policy into the skillUnder Stack > Knowledge > Skills, the variance analysis skill holds the dollar and percent tests, whether a line has to pass both or either, any tighter thresholds for cash or revenue, and the dollar-only rule for new and zeroed accounts.
Run it from the connected ledgerEach close, the agent pulls current and prior balances from QuickBooks Online, NetSuite, or Sage Intacct and applies the tests account by account.
Show which test was metThe results land in a workbook that lists each account's dollar and percent change, so a reviewer can see why a line was flagged or skipped.
Explain only what passedAccounts that clear the threshold get a draft explanation. Accounts under it aren't written up.
Keep the record for auditThe Session Audit Log records the sources the agent used and the actions it took, which supports the close explanations when auditors ask how lines were selected.
Change the policy in one placeAfter an acquisition or a step change in revenue, the team edits the skill, and the next close uses the new amounts. Skills are reusable, so a firm can apply one policy across its clients.

Related questions

Can variance explanations be drafted from general ledger detail?

Yes. GL detail shows which vendors, entries, and dates moved an account, which is enough to draft an explanation that an accountant reviews and edits.

Read more
How are budget vs. actual variances explained in month-end reporting?

Each material variance gets a short note on its cause, whether it's timing or permanent, and what it means for the forecast, tied to the numbers.

Read more
How is the driver of a month-over-month account change identified?

By breaking the change into the transactions behind it, grouped by vendor, entry, or department, until a few items explain most of the movement.

Read more

Don’t miss key shifts in business spend.