alirezarezvani/claude-skills / finance/month-end-close/skills/month-end-close
month-end-close
VerifiedUse when running, planning or speeding up a month-end (or quarter-end) close — building or reviewing the close checklist and calendar, reconciling a bank statement or sub-ledger to the general ledger, writing or reviewing flux (variance) explanations, or finding why the close takes too many days. Orders close tasks by dependency and finds the critical path, proves each reconciliation and ages what is left, and refuses to sign off material fluctuations explained with boilerplate.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 5.5 KB |
| assets/bank_statement.example.csv | other | 213 B |
| assets/close_plan.example.json | config | 2.0 KB |
| assets/flux_input.example.csv | other | 654 B |
| assets/gl_cash.example.csv | other | 308 B |
| assets/reconciliation_signoff.md | markdown | 1.2 KB |
| references/close_calendar_and_benchmarks.md | markdown | 4.3 KB |
| references/flux_analysis_and_materiality.md | markdown | 4.0 KB |
| references/reconciliation_standards.md | markdown | 4.2 KB |
| scripts/close_calendar_planner.py | script | 11.0 KB |
| scripts/flux_analyzer.py | script | 9.0 KB |
| scripts/reconciliation_matcher.py | script | 16.6 KB |
references/reconciliation_standards.md
View on GitHub# Reconciliation standards
What a reconciliation must contain to be evidence, how to age what is left,
and why "reviewed" needs more than a signature.
Confidence key: 🟢 read in the primary source · 🟡 institutional policy or secondary source · 🔴 recommendation.
## 1. A reconciliation is a proof
Agreement of two balances is a result. A reconciliation is the proof that the
difference between them is fully explained by named items:
```
adjusted source = source balance + items in GL not yet in source (timing)
adjusted GL = GL balance + items in source not yet in GL (entries to book)
unexplained = adjusted source - adjusted GL → must be 0
```
`reconciliation_matcher.py` builds this proof for any pair of detail files:
bank to cash GL, AR sub-ledger to AR control, payroll register to payroll
liabilities. A non-zero unexplained difference blocks sign-off. Plugging it
with a "reconciling difference" line hides the one number someone should
investigate. 🔴
Hints the script gives, from long-standing bookkeeping practice: 🔴
- a difference already present in the opening balances implied by each side
(ending balance minus the period's detail) was carried in from last period:
fix it in that reconciliation, not this one;
- a difference divisible by 9 often means transposed digits (54 for 45);
- a difference equal to an open item, or twice one, often means a posting
missed or doubled, or entered with the wrong sign.
## 2. What it must contain
One university's published policy is a good, concrete example: 🟡 [Vanderbilt]
- a preparer and an approver who sign off and **cannot be the same person**;
- support clear enough that someone without deep knowledge of the account can
understand the balance;
- every reconciling item identified, explained and supported;
- frequency set by risk (daily, monthly, quarterly);
- aging from the first day after month-end in buckets 0-30, 31-60, 61-90, >90 days;
- items over 90 days and over 10,000 need a documented resolution plan sent to the controller.
The 60- and 90-day limits in the script are this example's policy, not a
standard. Set `--escalate-days` and `--stale-days` to yours.
COSO 2013 Principle 10 names reconciliations among the control activities an
entity selects to mitigate risk, alongside authorizations, approvals,
verifications and business performance reviews. 🟢 [COSO P10]
## 3. Review precision
PCAOB Staff Audit Practice Alert 11 on management review controls: 🟢 [SAPA 11]
- "Verifying that a review was signed off provides little or no evidence by itself."
- Precision depends on the review's objective, level of aggregation,
consistency, correlation to the assertion, predictability of expectations,
and the criteria for investigation.
- A review threshold close to materiality has less precision and greater risk.
AS 2201 ¶.23 distinguishes entity-level controls that only monitor from those
designed to operate precisely enough to prevent or detect misstatements. 🟢 [AS 2201]
So the sign-off sheet in `assets/reconciliation_signoff.md` asks the reviewer
what they checked, against which document, and which items they challenged,
not just for a name. 🔴
## 4. Segregation of duties
The preparer cannot be the reviewer. `reconciliation_matcher.py` blocks when
the names match; `close_calendar_planner.py` blocks a key control whose
reviewer is its owner. In a team too small to separate, document the
compensating control (e.g. CFO review of all reconciliations above a threshold)
in the plan. 🔴
## Sources
1. Vanderbilt University. *Account Reconciliations Policy.* https://finance.vanderbilt.edu/policies/Account_Reconciliations_Policy.pdf
2. PCAOB. *Staff Audit Practice Alert No. 11: Considerations for Audits of Internal Control Over Financial Reporting.* https://pcaobus.org/Standards/QandA/10-24-2013_SAPA_11.pdf
3. PCAOB. *AS 2201.* https://pcaobus.org/oversight/standards/auditing-standards/details/AS2201
4. COSO (2013). *Internal Control — Integrated Framework*, Principle 10, via AAA. https://aaahq.org/node/35143
5. COSO (2013). Principle 12, via AAA. https://aaahq.org/node/35157
6. PCAOB. *AS 2305: Substantive Analytical Procedures.* https://pcaobus.org/oversight/standards/auditing-standards/details/AS2305
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| planning-and-task-breakdownaddyosmani/agent-skillsBreaks work into ordered tasks. Use when you have a spec or clear requirements and need to break work into implementable tasks. Use when a task feels too large to start, when you need to estimate scope, or when parallel work is possible. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| screenpipethedotmack/claude-memSearch screen and audio history recorded by Screenpipe and optionally save selected context into claude-mem. Use when the user asks to recall desktop activity, a meeting, or something seen in another app through Screenpipe. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| contact-widgetnexu-io/open-designSelf-contained floating chat widget with welcome screen, social links, meeting button, and message input. Single HTML file, zero dependencies. | Stars: 108k | Updated | Claude CodeCodex | Verified | Install |
| meeting-notesnexu-io/open-designMeeting notes page — title bar with attendees, agenda checklist, decisions block, action items table with owners + dates, and a "next meeting" footer. Use when the brief mentions "meeting notes", "minutes", "1:1 notes", "all-hands recap", or "会议纪要". | Stars: 108k | Updated | Claude CodeCodex | Verified | Install |