Report + Transaction Detail

Pull any Numeric report alongside every underlying GL transaction line in a single Excel workbook. The financial statement on one tab, every journal entry behind each number on the other — for review, audit prep, or just understanding what drove a balance.

Reporting & Analysis

Report + Transaction Detail

Install this skill.

Before You Begin

Numeric MCP connected.
Numeric Toolkit installed.
A saved report, OR enough context to build one (statement type, period, entity).

How It Works

Ask Claude for the report with detail. Example prompts:
- "Income statement with transactions."
- "MoM P&L with drill-down."
- "Show me what makes up each line."
- "BS with GL detail."
Claude identifies workspace, period, and entity.
Claude pulls the report — saved (via get_report_data) or ad-hoc (via build_report) with any comparison type.
Claude parses every drillable row to extract key objects for transaction queries.
For each account, Claude calls query_transaction_lines to pull underlying GL detail.
Claude builds a two-sheet workbook: Report tab (as-returned) + Transaction Lines tab (flat table).

What You Get

Sheet 1 — Report tab (name matches the report type, e.g. "MoM Income Statement"):

Faithful reproduction of the Numeric report — accounts, group subtotals, computed rows, margins, every column
Currency format applied
No restructuring, no added metadata headers, no inserted SUM formulas

Sheet 2 — Transaction Lines (flat table, one row per GL line):

Column	Description
Report Group	Section: Revenue, COGS, OpEx, etc.
Account Name	Full label, e.g. "40100 — Flat Usage"
Transaction Date
Posting Date
Transaction Type	Journal / Invoice / Bill / etc.
Transaction Name	Document number
Memo
Net Amount	Single column, not split DR/CR
Counterparty	Vendor, customer, entity
Department	If populated
Organization	Entity/subsidiary
Currency
Transaction URL	Clickable link back to the ERP

Plus: auto-filter on header row, frozen header, column widths tuned for readability. Filename: {Entity}_{ReportName}_{YYYY-MM}.xlsx

Troubleshooting

Issue	What to Check
Report has no data rows	Period is empty. The skill tells you before building an empty file.
50K+ rows	Still works (Excel handles it) but you'll get a file-size warning.
12-month MoM takes forever	Full 12 months of transaction lines for every account. Claude confirms before running — say no if that's too much.
Missing transaction URL	Some ERPs don't expose it. Column is left blank in those cases.
Custom groupings	Report Group column reflects whatever grouping the saved report uses (pivots, custom groups).

FAQ

Can I run this across multiple entities at once? Yes — ask Claude to produce workbooks for each entity, and it'll generate one file per entity. You can also ask it to run reports or entities in parallel.
Can I customize what's in the Transaction Lines tab? Yes. Ask Claude to update the skill — for example: "Update the report-txn-detail skill to also include the posting user and location on the Transaction Lines tab."

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.

Report + Transaction Detail