Back to MCP Use Cases

Auto-Draft Flux Explanations

Loops through every flux task assigned to you where commentary has been requested, pulls 6 months of transaction lines per account, and drafts concise first-pass explanations directly in Numeric — ready for you to review, adjust, and submit.

Install
Flux & Variance

Auto-Draft Flux Explanations

Loops through every flux task assigned to you where commentary has been requested, pulls 6 months of transaction lines per account, and drafts concise first-pass explanations directly in Numeric — ready for you to review, adjust, and submit.

Before You Begin

  • Numeric MCP connected.
  • Numeric Toolkit installed.
  • You're assigned as preparer on at least one flux task with a pending explanation.
  • A saved flux report (IS, BS, or both).

How It Works

  1. Ask Claude to draft your fluxes. Example prompts:
    • "Write my flux explanations."
    • "Draft all my fluxes for this month."
    • "Run flux analysis for close."
  2. Claude filters to PENDING flux tasks where you're the preparer.
  3. For each task, Claude pulls 6 months of transaction lines and groups by available dimensions (vendor, customer, department, class, location).
  4. Claude investigates variances by pulling the underlying transaction lines, and investigates them using a pre-defined rule set.
  5. Claude drafts a conclusion-first explanation. Claude drafts and optionally posts the explanation to Numeric.

What You Get

Formatted flux explanation per pending task, structured:

  • Conclusion paragraph first: total variance, primary driver, concentration statement
  • Supporting bullets: vendor / dept / customer breakdown with $ amounts
  • When data supports: YoY comparison, run-rate implication, % of revenue for variable costs

Example draft (5105 Employee Wages, Mar 2025):

The $496k MoM increase (12.4%) is driven entirely by Marketing department bi-weekly payroll for full-time employees, which accounts for 100% of activity in this account across all 6 months.
-- $496k Marketing payroll rose from $4,005k in Feb to $4,500k in Mar.
-- Mar at $4,500k is 79% above the 6-month average of $2,515k.
-- Average monthly increase over Oct–Mar: $622k. March implies $54.0M annualized, up from Oct–Dec average of $17.4M annualized.

Troubleshooting

Issue What to Check
Draft was overly speculative
The skill is tuned to state only what the GL data shows — no speculation about headcount, one-time events, org changes. If you see speculation, call it out; the skill logs adjustments.
Got appended content instead of overwrite
By design — the skill never overwrites existing flux content. If you want to replace, delete the old explanation manually first, then re-run.
Wrong grouping dimension
Add a ## Flux Template override in the task description (Grouping, Ignore, Context, Format). Carries forward next period.
update_flux_explanation returned nothing
Normal. Treat a non-error call as success.
Skill skipped a task
It only processes PENDING preparer tasks; submitted tasks are intentionally skipped.

FAQ

  • Does it submit the task? No — it drafts and posts explanations only. You review and submit.
  • What if I don't have 6 months of history? The skill uses what's available and notes the limitation.
  • Parallel across accounts? Yes — fans out sub-agents, one per account, after setup.

Download & Install

Download the full Numeric Toolkit (15 community skills, including this one):

🔗 numeric-mcp-toolkit.zip

Install via Claude Code CLI:

/plugin marketplace add geoff-lew/numeric-toolkit
/plugin install numeric-mcp-toolkit

Or drop the .skill directory into ~/.claude/skills/ manually. Once installed, just describe what you need — the skill activates automatically.

Need help? Reach out to support@numeric.io.

Related use cases

Read story
SOP Documenter

Turns how an accounting task was actually performed into an evidence-grade, sourced record — every action, every piece of context, and the rationale behind each, with gaps flagged rather than invented. For controllers and teams documenting close processes for audit or handoff.

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Read story
Depreciation Scheduler

Maintains a fixed asset register and runs depreciation end-to-end — processes additions and disposals, calculates depreciation with proration, and outputs a full schedule plus a ready-to-post journal entry. For controllers and accountants managing fixed assets each period.

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Read story
Invoice & Receipt Extractor

Turns a folder of invoices and receipts (PDF or image) into a clean, categorized expense spreadsheet — vendor, dates, tax, and totals extracted, anomalies flagged, source files renamed. For bookkeepers, accountants, and anyone prepping expenses for the books.

This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.

See numeric in action

Schedule a demo