Back to MCP Use Cases

Audit Evidence Export

Extract the complete activity history of any Numeric close period into a five-tab Excel workbook ready to hand to auditors. No more screenshotting the activity panel on every task.

Install
Audit & Compliance

Audit Evidence Export

Extract the complete activity history of any Numeric close period into a five-tab Excel workbook ready to hand to auditors. No more screenshotting the activity panel on every task.

Before You Begin

  • Numeric MCP connected.
  • Numeric Toolkit installed.
  • At least one closed (or in-progress) close period to pull from.

This skill works on open or closed periods — the title row of the workbook notes which, so auditors know if the close is still in progress.

How It Works

  1. Ask Claude for audit evidence. Example prompts:
    • "Pull audit evidence for December close."
    • "SOX evidence package for Q4."
    • "Reconciliation sign-off history for March."
  2. Claude asks which workspace and period (if not already specified).
  3. Claude pulls every task across all four types — reconciliations, checklist, flux, journal entries - querying each type separately.
  4. Claude pulls activity events and review notes/comments for every task, batching the calls in parallel.
  5. Claude produces a formatted Excel workbook with five sheets.

What You Get

A single .xlsx file, <Workspace>_<Period>_Audit_Evidence.xlsx, with five sheets:

Sheet Content
1. Reconciliation Tasks
Account × preparer × reviewer × statuses × due dates
2. Checklist Tasks
Custom + journal-entry tasks combined
3. Activity Log
Every event in chronological order — the core evidence sheet
4. Review Notes & Comments
Open notes highlighted yellow, resolved green, general comments plain
5. Summary
Status counts, event breakdown, activity by user

Troubleshooting

Issue What to Check
Comments are missing on some tasks
Numeric stores comments on the entity-1 variant of each key. The skill handles this automatically — if you still see gaps, re-run and confirm the entity-1 key conversion.
Workbook has fewer tasks than expected
Some workspaces return 0 on unfiltered list_tasks. The skill falls back to per-type queries — check the run log to confirm fallback ran.
Comment body has raw HTML tags
The skill strips HTML to plain text. If you see

or
, re-run — parsing likely failed silently on one batch.

Tasks with no events are missing
Expected. Tasks without events appear in the Reconciliation Tasks and Checklist Tasks sheets; the Activity Log only includes tasks with at least one event.

FAQ

  • Can I run this before the close is done? Yes — works on open periods. The workbook labels the period status for auditors.
  • Does it include deleted tasks? No. Only live tasks in the selected period.
  • Can I filter to one task type? Yes — say "just recs" or "only flux" when you trigger the skill.

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

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