Journal Entry Posting — Support-to-NetSuite

Pulls outstanding journal entry tasks from your Numeric close checklist, reads the supporting workbook or documentation, generates balanced journal entries, marks the task complete in Numeric, and posts directly to NetSuite. From checklist task to posted entry — no manual steps in between.

Journals & Transactions

Journal Entry Posting — Support-to-NetSuite

Install this skill.

Before You Begin

Numeric MCP connected.
Numeric Toolkit installed.
NetSuite MCP connected if direct posting (CSV-only fallback available otherwise).
A JE task on your Numeric checklist with supporting documentation available to upload.

You should be the task assignee if you want the task to auto-submit. If you're not, the skill posts its comments but leaves the task open for the assignee..

How It Works

Ask Claude to process JEs. Example prompts:
- "Post the outstanding journal entries."
- "Process the JE tasks from the checklist."
- "Complete and post the JEs with this support."
Claude pulls 'PENDING' JE tasks and shows them in a table; you pick one.
Claude reads task description and prior comments for context (subsidiary, account prefs, External ID pattern, column mapping).
Claude asks you to upload the source file.
Claude auto-detects JE type (Source Document / Platform Export / GL Dump / Allocation Workbook) and parses.
Claude generates JE lines per the NetSuite schema and validates DR = CR.
Claude builds a three-layer workpaper (Source → Calc → JE with formula-first structure).
On your approval, Claude posts via ns_createRecord and saves CSV + workpaper as backup.
Claude submits the task in Numeric with JE detail comment, and saves ## JE Instructions to the task description for next time.

What You Get

Per JE run:

NetSuite journal entry posted (if NS MCP available) — captures returned NS internal ID
CSV file — flat NetSuite-import format, ready for the Import Assistant if needed
Excel workpaper (3 layers):
- Source — raw parsed data, no formulas
- Calc — formulas transforming source into JE amounts
- JE — every amount is a formula pointing to Calc, balance check at bottom
Numeric task submitted with structured comment: $X — [description] (NS JE #NNN). N DR + N CR. [classification notes]
## JE Instructions auto-saved to the task description: subsidiary, account numbers, External ID pattern, column mapping, required fields

JE types supported:

Type	Intent	Example inputs
1 — Source Document	Record a transaction	Vendor invoice, interest statement
2 — Platform Export	Record consumed services	Cloud usage export, rewards CSV
3 — GL Dump	Fix/extend existing data	P&L GL dump for reclass, reversal, FX
4 — Allocation Workbook	Distribute an allocation	Commission reclass, sublease schedule

Troubleshooting

Issue	What to Check
Validation failed (DR ≠ CR)	Skill fixes and re-validates automatically; won't proceed until balanced.
NS post failed	Raw error shown plus suggested fix (from bundled `references/ns-posting-errors.md`).
External ID collision	Default pattern `JE-{CUSTOMER}-{YYYYMM}-{SOURCE}-{SEQ}` auto-increments. Override via task description.
Intercompany entry posted incorrectly	IC entries need the 4-line structure with a clearing account. Pass `--ic` to enable; without it, the skill defaults to a 2-line structure.
Rounding error	Largest line absorbs the penny difference; visible in the Calc layer.

FAQ

Can it handle multiple types of journal entries? Yes — the skill detects the JE type automatically and applies the right logic.
Do I need to manipulate the supporting data before uploading? No. Upload the file as-is — Claude will try to process the workbook appropriately. If you're not obtaining the right results, provide it with more instruction.
Process multiple JEs in one run? One task at a time by design — you confirm each before posting. Loop by re-running the skill.
Do I have to post to NetSuite? No — skip the post step and the CSV + workpaper are still generated.
Cash flow statement entries? Depends on source-file structure. Ask Claude — Type 4 (Allocation) often fits.
Will it overwrite existing workpapers? No — always creates a new file per task.
Non-accrual JEs too? Yes — skill handles any JE type. Use Accrual Identification if you specifically need the accruals workflow.

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.

Journal Entry Posting — Support-to-NetSuite