Excel 表格处理
打开、读取、编辑和修复表格文件,支持 .xlsx、.xlsm、.csv 和 .tsv 格式。
按月结前、关账日及后续日程整理任务、负责人、依赖、阻塞与进度。
/skill install close-management把财务月结工作整理为有负责人、依赖、截止时间和状态的计划,帮助跟踪阻塞与关键任务,适合规范月结节奏和准备进度沟通。
月结计划;跨团队任务协同;关账进度跟踪;阻塞清单;月结复盘改进。
可直接用自然语言说明这些选项;带代码样式的参数按实际工具定义处理。
| 参数或输入项 | 填写说明 |
|---|---|
| 期间与日历 | 月末日期、目标关账日、当地工作日和节假日安排。 |
| 任务与责任 | 任务名称、负责人、复核人和预计完成时间。 |
| 依赖与状态 | 前置任务、未开始/进行中/待复核/阻塞/已完成等实际状态。 |
| 输出形式 | 任务表、按日计划、状态摘要或复盘清单,可沿用企业模板。 |
根据这份财务任务清单制作 T+5 月结计划,标出每项负责人、前置任务和复核节点,单独列出当前阻塞及需要业务部门配合的资料。
月结日历、任务与依赖表、阻塞及进度摘要、复盘改进建议。
以下为技能最新版本的 SKILL.md 正文,智能体按其中的步骤完成任务。
使用当前 Agent 已提供的文件、搜索、代码或业务工具完成任务,按实际可用能力选择路径。默认以中文回应,并遵循用户指定的语言和交付格式。
根据企业的真实月结制度与职责生成清单和依赖日程。没有任务系统或调度工具时只交付计划和状态表,不声称已提醒成员、已关账、已入账或会自动持续追踪。
Important: This skill assists with close management workflows but does not provide financial advice. All close activities should be reviewed by qualified financial professionals.
Month-end close checklist, task sequencing and dependencies, status tracking, and common close activities organized by day.
Tasks are organized by what must complete before the next task can begin:
LEVEL 1 (No dependencies — can start immediately at T+1):
├── Cash receipts/disbursements recording
├── Bank statement retrieval
├── Payroll processing/accrual
├── Fixed asset depreciation run
├── Prepaid amortization
├── AP accrual preparation
└── Intercompany transaction posting
LEVEL 2 (Depends on Level 1 completion):
├── Bank reconciliation (needs: cash entries + bank statement)
├── Revenue recognition (needs: billing/delivery data finalized)
├── AR subledger reconciliation (needs: all revenue/cash entries)
├── AP subledger reconciliation (needs: all AP entries/accruals)
├── FX revaluation (needs: all foreign currency entries posted)
└── Remaining accrual JEs (needs: review of all source data)
LEVEL 3 (Depends on Level 2 completion):
├── All balance sheet reconciliations (needs: all JEs posted)
├── Intercompany reconciliation (needs: both sides posted)
├── Adjusting entries from reconciliations
└── Preliminary trial balance
LEVEL 4 (Depends on Level 3 completion):
├── Tax provision (needs: pre-tax income finalized)
├── Equity roll-forward
├── Consolidation and eliminations
├── Draft financial statements
└── Preliminary flux analysis
LEVEL 5 (Depends on Level 4 completion):
├── Management review
├── Final adjustments
├── Hard close / period lock
├── Financial reporting package
└── Forecast updates
The critical path determines the minimum close duration. Typical critical path:
Cash/AP/AR entries → Subledger reconciliations → Balance sheet recs →
Tax provision → Draft financials → Management review → Hard close
To shorten the close:
Track each close task with the following attributes:
| Task | Owner | Deadline | Status | Blocker | Notes |
|---|---|---|---|---|---|
| [Task name] | [Person/role] | [Day T+N] | Not Started / In Progress / Complete / Blocked | [If blocked, what's blocking] | [Any notes] |
During the close period, hold a brief (15-minute) daily standup:
| Metric | Definition | Target |
|---|---|---|
| Close duration | Business days from period end to hard close | Reduce over time |
| # of adjusting entries after soft close | Entries posted during management review | Minimize |
| # of late tasks | Tasks completed after their deadline | Zero |
| # of reconciliation exceptions | Reconciling items requiring investigation | Reduce over time |
| # of restatements / corrections | Errors found after close | Zero |
| Day | Key Activities | Responsible |
|---|---|---|
| T+1 | Cash entries, payroll, AP accruals, depreciation, prepaid amortization, intercompany posting | Staff accountants, payroll |
| T+2 | Revenue recognition, remaining accruals, subledger reconciliations (AR, AP, FA), FX revaluation | Revenue accountant, AP/AR, treasury |
| T+3 | Balance sheet reconciliations, intercompany reconciliation, eliminations, preliminary trial balance, preliminary flux | Accounting team, consolidation |
| T+4 | Tax provision, equity roll-forward, draft financial statements, detailed flux analysis, management review | Tax, controller, FP&A |
| T+5 | Final adjustments, hard close, period lock, reporting package distribution, forecast update, retrospective | Controller, FP&A, finance leadership |
For organizations targeting a faster close:
| Day | Key Activities |
|---|---|
| T+1 | All JEs posted (automated + manual), all subledger reconciliations, bank reconciliation, intercompany reconciliation, preliminary trial balance |
| T+2 | All balance sheet reconciliations, tax provision, consolidation, draft financial statements, flux analysis, management review |
| T+3 | Final adjustments, hard close, reporting package, forecast update |
Prerequisites for a 3-day close:
| Bottleneck | Root Cause | Solution |
|---|---|---|
| Late AP accruals | Waiting for department spend confirmation | Implement continuous accrual estimation; set cut-off deadlines |
| Manual journal entries | Recurring entries prepared manually each month | Automate standard recurring entries in the ERP |
| Slow reconciliations | Starting from scratch each month | Implement continuous/rolling reconciliation |
| Intercompany delays | Waiting for counterparty confirmation | Automate intercompany matching; set stricter deadlines |
| Management review changes | Large adjustments found during review | Improve preliminary review process; empower team to catch issues earlier |
| Missing supporting documents | Scrambling for documentation at close | Maintain documentation throughout the month |
After each close, ask:
| 版本 | 发布日期 | 更新说明 |
|---|---|---|
1.0.0 | 2026-10-20 | - |
打开、读取、编辑和修复表格文件,支持 .xlsx、.xlsm、.csv 和 .tsv 格式。
读取表格文件,进行数据画像、相关性分析和异常值检测,生成交互式图表报告与分析摘要。
分析会议转写中的发言比例、提问、打断和行动项清晰度,给出带原文证据的沟通建议。
交付前检查SQL结果、分析报告的分母、聚合、重复计数、样本偏差和结论依据。
比较总账、明细账、银行及第三方账单,分类差异、识别时间性项目并整理账龄。
比较预算、实际与同期,把收入或成本变化分解为价格、数量、组合等因素。
把团队的做事方法沉淀为技能
在技能中心导入技能包、从平台资源生成或在线编写,发布后安装到超级AI助理使用。
