ghost1034/cpaautomation/close-orchestration-dashboard

Claude Code and agent skill by ghost1034/cpaautomation

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

Track a dependency-aware month-end close with critical-path analysis and burn-down reporting

Install

npx vskill@latest install ghost1034/cpaautomation/close-orchestration-dashboard

SKILL.md

The same SKILL.md was published earlier as ghost1034/cpaautomation/close-orchestration-dashboard.

Close Orchestration Dashboard

Mission-control view of the month-end close: task status, dependency blocking, overdue items, entity-level progress, and the critical path to reporting readiness.


Overview

Target userAssistant Controller, Close Manager, Consolidation Lead
MaturityProduction for checklist ingestion, dependency graph, and critical-path analysis; human-in-the-loop for task completion attestation
What it doesTracks close tasks with dependencies, flags overdue and blocked items, computes percent complete by entity, and outputs a multi-sheet XLSX dashboard
What it does NOT doPost journal entries, auto-complete tasks, or integrate live with FloQast/BlackLine APIs

When to use

  • Daily stand-ups during the close (Day 1–Day 10)
  • Controller briefing on blockers before consolidation
  • Post-close retrospective on critical-path delays
  • Multi-entity close coordination (US + EMEA + consolidation)

When NOT to use

  • Substantive reconciliation work (use balance-sheet-reconciler)
  • Audit PBC tracking (use audit-pbc-coordinator)
  • One-off JE drafting (use journal-entry-assistant)

Authoritative sources

  • COSO ICFR — close process controls and segregation of duties
  • PCAOB AS 2201 — audit evidence on close procedures
  • AICPA Close Management best practices

Inputs

Close checklist — --checklist <path> (required)
ColumnTypeRequiredNotes
task_idstringYUnique identifier
task_namestringY
ownerstringYResponsible person/team
due_datedateYYYYY-MM-DD
statusstringYComplete, In Progress, Not Started
dependenciesstringNComma-separated task_ids that must complete first
entitystringNUS, EMEA, Consolidation, etc.
day_targetintNClose calendar day (used for critical-path weighting)
Parameters
FlagDefaultDescription
--as-ofrequiredStatus evaluation date (YYYY-MM-DD)
--outputrequiredXLSX dashboard path

Workflow

1. LOAD checklist; validate required columns
2. NORMALIZE status (Complete/Done/Closed = complete)
3. OVERDUE = incomplete AND due_date < as_of
4. BLOCKED = incomplete AND any dependency not complete
5. CRITICAL PATH = longest path through dependency DAG (by day_target weight)
6. ENTITY SUMMARY = percent complete by entity
7. OUTPUT multi-sheet XLSX dashboard
8. EXIT 2 if overdue tasks exist (data-driven FAIL for automation)

Edge cases

ScenarioHandling
Circular dependenciesTopological sort may not reach all nodes; critical path uses reachable subgraph
Missing dependency task_idIgnored (orphan reference logged in AuditTrail)
Task complete but downstream blocked on another branchOnly direct unmet dependencies block
Same owner on critical pathFlag in Bottleneck sheet for capacity review

Anti-patterns (DO NOT)

  • DO NOT mark tasks Complete without substantive work performed
  • DO NOT omit dependencies on consolidation tasks
  • DO NOT use percent complete alone — review overdue AND blocked
  • DO NOT treat "In Progress" as Complete for dependency resolution

Outputs

SheetContents
SummaryProgress %, overdue, blocked, critical path string
TasksFull checklist with conditional formatting
OverdueIncomplete past due
BlockedBlocked by unmet dependencies
EntitySummaryProgress by entity
CriticalPathOrdered task sequence
AuditTrailTimestamp, as-of date
SignOffClose Manager / Controller / CFO

Quality gates

  1. [ ] All material close tasks included with owners and due dates
  2. [ ] Dependencies reflect true process order (AP before IC elim, etc.)
  3. [ ] Overdue items have escalation notes
  4. [ ] Critical path reviewed with consolidation lead
  5. [ ] Entity summary ties to reporting calendar

Worked example

bash
python scripts/close_tracker.py \
--checklist examples/close_checklist.csv \
--as-of 2024-05-04 \
--output /tmp/close_dashboard.xlsx

On the bundled example, Fixed Asset Dep is overdue; Intercompany Elim is blocked pending tasks 3 and 4; critical path runs through AP → Bank → FA → Revenue → IC → Consolidation → Tax.

References

  • AICPA — Close Management
  • FloQast / BlackLine — close checklist best practices

Security

  • Security scanPassed, 90 of 100Pattern checks on the skill's files.
  • Model reviewPassed

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

7-day trend score
0

Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/ghost1034/cpaautomation/close-orchestration-dashboard/badge)](https://verified-skill.com/skills/ghost1034/cpaautomation/close-orchestration-dashboard)

Something wrong with this skill or its page? Tell us.