Report Export w/ Transaction Detail

Last updated: April 17, 2026

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.

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

  1. 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."

  2. Claude identifies workspace, period, and entity.

  3. Claude pulls the report — saved (via get_report_data) or ad-hoc (via build_report) with any comparison type.

  4. Claude parses every drillable row to extract key objects for transaction queries.

  5. For each account, Claude calls query_transaction_lines to pull underlying GL detail.

  6. 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, added metadata headers, or inserted 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.

Run fails partway through

You potentially have too much data or hit a rate-limit. Re-run the skill, or specify fewer accounts to process each time. Also make sure you're using Claude Cowork and not Claude Chat.

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

Direct link to the Skill

🔗 report-txn-detail.skill

In Cowork, go to Customize in the left sidebar, click +, select the Skills tab, and click Install to upload the downloaded skill file.

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