Accrual Identification & Journal Entry

Completes a Numeric accrual task end-to-end — pulls vendor spend history, identifies accrual candidates using configurable triggers, generates the full Excel workpaper and NetSuite-ready CSV journal entries, posts task comments, submits the task, and saves your preferences (vendor overrides, exclusions, criteria) to the task description so they carry forward next month automatically.

Before You Begin

• Numeric MCP connected.
• Numeric Toolkit installed.
• An accrual task exists on your Numeric close checklist for the open period.
• You have preparer or reviewer role on the task.
• Optional: NetSuite MCP connected if you want to post JEs directly (CSV fallback otherwise).

How It Works

1. Ask Claude to run accruals. Example prompts:
   • "Run the accruals for this period."
   • "What accruals do we need to book?"
   • "Complete the software accrual task."
2. Claude finds the matching task and confirms the entity scope.
3. Claude loads prior-period preferences from the previous close's ## Accrual preferences section if present.
4. Claude asks about manual vendors you need to accrue for that the triggers won't catch (unbilled, expected prior-month invoice).
5. Claude pulls 7 months of transaction lines (6 completed + open period) and identifies candidates.
6. Claude presents the candidate table; you select which to accrue.
7. Claude generates workpaper + JE CSV + validation file.
8. (Optional) NetSuite posting — if NS MCP is available, Claude asks to post directly.
9. Claude submits the task with structured comments and saves preferences to the task description.

What You Get

• Workpaper .xlsx (3 sheets):
  • Sheet 1: all vendors × 6 months, accrual candidates highlighted yellow
  • Sheet 2: accrual detail (confirmed vendors) with avg and memo
  • Sheet 3: Numeric tab with accrued liability account + formula total
• JE CSV: NetSuite-ready import, one debit + credit line per vendor
• Validation file: candidate summary + DR = CR balance check (PASS/FAIL)
• Two Numeric task comments: Total + observations (top) and per-vendor detail (below)
• Saved ## Accrual preferences in the task description for next period

Default triggers (overridable per task):

• Vendor has $0 in open period AND >$0 last month
• Vendor has $0 in both but had >$0 in 3 of prior 5 months
• No minimum spend threshold

Default estimation methods (priority order):

1. 6-month rolling average (≥6 months of data)
2. 3-month rolling average (≥3 months)
3. Most recent non-zero month (1–2 months)
4. Flag "estimate needed" (no history)

Troubleshooting

FAQ

• Override method for specific vendors? Yes — saves vendor_overrides to the task description; next run applies automatically.
• Set a materiality threshold? Add min_accrual_amount: X to the task description or tell Claude at runtime.
• Can it reverse the accrual next month? Out of scope for this skill — use Journal Entry Posting for that.
• What if my task description isn't parsed correctly? Claude surfaces the parsed criteria before running; you can correct them.
• Is there an audit trail for auditors or internal review? Yes. Every run leaves a reviewable audit trail in the comments.

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.