Accrual Identification & Journal Entry

Last updated: April 17, 2026

Completes a Numeric accrual task end-to-end — pulls vendor spend history, identifies accrual candidates, generates the Excel workpaper and NetSuite-ready CSV, posts task comments, submits the task, and saves your preferences to the task description so they carry forward next month.

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

Preferences auto-save to the task description. Next month, vendor overrides and exclusions carry forward from this period's task automatically.

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

Issue

What to Check

Preferences didn't carry forward

The skill searches the prior period's task by name (fuzzy match). If renamed, copy the ## Accrual preferences block manually.

Manual vendor missing from workpaper

The skill appends manual vendors after the candidates table. Verify the vendor name matches (fuzzy match).

DR ≠ CR

Usually a formula issue in the accrued liability account — check the account's external_id.

NetSuite post failed on one vendor

Skill logs the error, skips that vendor, continues. Reports which succeeded/failed after the batch.

Reviewer role instead of preparer

Skill offers to swap assignee/reviewer roles before submitting.

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

Direct link to the Skill

🔗 complete-accruals-task.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.