Journal Entry Posting — From Support-to-NetSuite

Last updated: April 17, 2026

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.

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

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

  2. Claude pulls 'PENDING' JE tasks and shows them in a table; you pick one.

  3. Claude reads task description and prior comments for context (subsidiary, account prefs, External ID pattern, column mapping).

  4. Claude asks you to upload the source file.

  5. Claude auto-detects JE type (Source Document / Platform Export / GL Dump / Allocation Workbook) and parses.

  6. Claude generates JE lines per the NetSuite schema and validates DR = CR.

  7. Claude builds a three-layer workpaper (Source → Calc → JE with formula-first structure).

  8. On your approval, Claude posts via ns_createRecord and saves CSV + workpaper as backup.

  9. 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

Troubleshooting

Issue

What to Check

Journal entries have the wrong ID format

Default pattern JE-{CUSTOMER}-{YYYYMM}-{SOURCE}-{SEQ} auto-increments. Override via task description of update the Skill to your needs.

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

Direct link to the Skill

🔗 journal-entry-generator.zip

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.