Reconciliation Leadsheet Workbook

Build a polished Numeric Leadsheet workbook for any GL account — four periods of live balance data, EOMONTH date formulas, and a rollforward tab. One row per account × entity, ready to hand to a reviewer.

Before You Begin

• Your Claude Code (or Cowork) instance has the Numeric MCP connected.
• The Numeric Toolkit plugin is installed (see Download & Install below).
• The account you want to reconcile exists in your chart of accounts with a recent balance.

This skill works for any GL account — prepaid, fixed assets, accrued liabilities, deferred revenue, cash, AR, AP, or anything else you reconcile with a rollforward.

How It Works

1. Ask Claude to build a workbook. Example prompts:
   • "Build me a leadsheet for account 1405."
   • "Make the workbook for Prepaid Expenses for March."
   • "I need rec support for account 2505 — Acme entity, March 2026."
2. Claude confirms three things before building: account (GL code), entity, and period.
3. Claude pulls data from Numeric. It reads the account, workspace context, and up to four periods of balances from your balance sheet report.
4. Claude generates an new/updated Excel. You get a copy saved to your working directory — ready to open, share, or drop into your close workpapers folder.

Existing workbook? You can also ask Claude to add a Numeric tab to a workbook you already have. Claude inventories your sheets, detects account and period from the existing data, finds your ending balance cell, and links the Numeric tab directly to it. Your other sheets aren't touched.

What You Get

A two-sheet Excel workbook, .xlsx:

Sheet 1 — Numeric (the leadsheet Numeric reads on upload)

• Row 1: Account | Entity | C1 = start date | D1..N1 = EOMONTH formulas that auto-cascade
• Row 2: account code, entity code, three prior-period balances (hardcoded, blue font), and the current period formula-linked to the Rollforward tab

Sheet 2 — Rollforward (your working tab)A new/updated Excel workbook, .xlsx:

Sheet 1 — Numeric is the leadsheet Numeric reads on upload. It has one row per account and entity, with date headers across the top that fill in automatically. Up to three prior-period GL balances are pre-filled in blue, and the current period links live to the Rollforward tab.

Sheet 2 — Rollforward is your working tab. Beginning balance is pre-filled from the prior period GL. You fill in Additions and Reductions until the ending balance ties to the GL balance. The variance cell tells you how close you are.

If adding to an existing workbook — Claude adds the Numeric tab at the front and links the current-period cell to your existing ending balance cell. Nothing else is touched.

Troubleshooting

FAQ

• Can I run this across multiple accounts at once? Yes — ask Claude to build workbooks for a list of accounts, and it'll generate one file per account × entity. Tip: You can also ask Claude to process multiple workbooks in parallel.
• What if I only have one or two prior months of history? The skill still builds the workbook — prior periods with no data will show as zeros.
• Can I customize the template? Yes. Ask Claude to update the skill — for example: "Update the numeric-rec-workbook skill to also pull transaction detail for the current period."

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.