Numeric Reconciliation Leadsheet Workbook
Last updated: April 17, 2026
Build a clean Numeric Leadsheet workbook for any GL account — live GL balances, date headers that fill in automatically, and a rollforward tab pre-wired to the Numeric tab. One row per account × entity, ready to upload into Numeric.
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 in Numeric.
How It Works
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."
Claude confirms three things before building: account (GL code), entity, and period.
Claude pulls data from Numeric. It reads the account, workspace context, and up to four periods of balances from your balance sheet report.
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 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
Issue | What to Check |
Numeric tab doesn't upload cleanly | Confirm the Numeric tab column names are correct ("Account", "Entity"), and dates are for the last day of the month in MM/DD/YYY format. Also confirm that "Account" contains only the account number with no extra details like the name. |
Entity code isn't recognized | Ask Claude to re-pull |
Numeric says account or balance not found | Dates should include the last day of the month for current period. If the current period is March 2026, the date should be |
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):
Install via Claude Code CLI:
/plugin marketplace add geoff-lew/numeric-toolkit
/plugin install numeric-mcp-toolkitDirect link to the 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.