Excel 表格处理
打开、读取、编辑和修复表格文件,支持 .xlsx、.xlsm、.csv 和 .tsv 格式。
比较总账、明细账、银行及第三方账单,分类差异、识别时间性项目并整理账龄。
/skill install reconciliation比较总账、明细账、银行和第三方账单,整理匹配、差异、时间性项目及待查事项,帮助形成可继续核对的对账底稿,适合财务与业务账务复核。
银行对账;平台和渠道账单核对;总账与明细账比较;未清项目跟踪。
可直接用自然语言说明这些选项;带代码样式的参数按实际工具定义处理。
| 参数或输入项 | 填写说明 |
|---|---|
| 账单与期间 | 双方原始明细、期初期末余额及相同或可解释的日期范围。 |
| 匹配依据 | 订单号、流水号、交易日期等,注明一对多和重复记录情况。 |
| 金额口径 | 含税/未税、原币/本位币、手续费、退款和汇率。 |
| 容差与账龄 | 可指定金额容差、时间差及待查项目账龄范围。 |
核对这份供应商账单与平台调用明细,以订单号和结算日期匹配,金额按含税人民币比较,手续费单列,输出未匹配项及待确认差异。
对账汇总、匹配与差异明细、待查项目和账龄或调整建议。
以下为技能最新版本的 SKILL.md 正文,智能体按其中的步骤完成任务。
使用当前 Agent 已提供的文件、搜索、代码或业务工具完成任务,按实际可用能力选择路径。默认以中文回应,并遵循用户指定的语言和交付格式。
先统一币种、期间、税额、单位与金额符号。用上传账单即可进行资料整理;实际数值匹配需代码或表格工具。没有 ERP/银行连接时不声称已取数、已入账或已完成会计签核。
Important: This skill assists with reconciliation workflows but does not provide financial advice. All reconciliations should be reviewed by qualified financial professionals before sign-off.
Methodology and best practices for account reconciliation, including GL-to-subledger, bank reconciliations, and intercompany. Covers reconciling item categorization, aging analysis, and escalation.
Compare the general ledger control account balance to the detailed subledger balance.
Common accounts:
Process:
Common causes of differences:
Compare the GL cash balance to the bank statement balance.
Process:
Standard format:
Balance per bank statement: $XX,XXX
Add: Deposits in transit $X,XXX
Less: Outstanding checks ($X,XXX)
Add/Less: Bank errors $X,XXX
Adjusted bank balance: $XX,XXX
Balance per general ledger: $XX,XXX
Add: Interest/credits not recorded $X,XXX
Less: Bank fees not recorded ($X,XXX)
Add/Less: GL errors $X,XXX
Adjusted GL balance: $XX,XXX
Difference: $0.00
Reconcile balances between related entities to ensure they net to zero on consolidation.
Process:
Common causes of differences:
Items that exist because of normal processing timing and will clear without action:
Expected resolution: These items should clear within the normal processing cycle (typically 1-5 business days). No adjusting entry needed.
Items that require a journal entry to correct:
Action: Prepare adjusting journal entry to correct the GL or subledger.
Items that cannot be immediately explained:
Action: Investigate root cause, document findings, escalate if unresolved.
Track the age of reconciling items to identify stale items requiring escalation:
| Age Bucket | Status | Action |
|---|---|---|
| 0-30 days | Current | Monitor — within normal processing cycle |
| 31-60 days | Aging | Investigate — follow up on why item has not cleared |
| 61-90 days | Overdue | Escalate — notify supervisor, document investigation |
| 90+ days | Stale | Escalate to management — potential write-off or adjustment needed |
| Item # | Description | Amount | Date Originated | Age (Days) | Category | Status | Owner |
|---|---|---|---|---|---|---|---|
| 1 | [Detail] | $X,XXX | [Date] | XX | [Type] | [Status] | [Name] |
Track reconciling item totals over time to identify growing balances:
Define escalation triggers based on your organization's risk tolerance:
| Trigger | Threshold (Example) | Escalation |
|---|---|---|
| Individual item amount | > $10,000 | Supervisor review |
| Individual item amount | > $50,000 | Controller review |
| Total reconciling items | > $100,000 | Controller review |
| Item age | > 60 days | Supervisor follow-up |
| Item age | > 90 days | Controller / management review |
| Unreconciled difference | Any amount | Cannot close — must resolve or document |
| Growing trend | 3+ consecutive periods | Process improvement investigation |
Note: Set thresholds based on your organization's materiality level and risk appetite. The examples above are illustrative.
| 版本 | 发布日期 | 更新说明 |
|---|---|---|
1.0.0 | 2026-10-20 | - |
打开、读取、编辑和修复表格文件,支持 .xlsx、.xlsm、.csv 和 .tsv 格式。
读取表格文件,进行数据画像、相关性分析和异常值检测,生成交互式图表报告与分析摘要。
分析会议转写中的发言比例、提问、打断和行动项清晰度,给出带原文证据的沟通建议。
交付前检查SQL结果、分析报告的分母、聚合、重复计数、样本偏差和结论依据。
比较预算、实际与同期,把收入或成本变化分解为价格、数量、组合等因素。
按月结前、关账日及后续日程整理任务、负责人、依赖、阻塞与进度。
把团队的做事方法沉淀为技能
在技能中心导入技能包、从平台资源生成或在线编写,发布后安装到超级AI助理使用。
