财务账目对账

标识: reconciliation最新版本: 1.0.0安装 5 次更新于 2026-11-06
办公效率数据分析

比较总账、明细账、银行及第三方账单,分类差异、识别时间性项目并整理账龄。

在超级AI助理对话中安装/skill install reconciliation

技能介绍

技能简介

比较总账、明细账、银行和第三方账单,整理匹配、差异、时间性项目及待查事项,帮助形成可继续核对的对账底稿,适合财务与业务账务复核。

适用场景

银行对账;平台和渠道账单核对;总账与明细账比较;未清项目跟踪。

使用方法
  1. 提供双方账单或明细,说明对账期间、主体、币种和各字段含义。
  2. 明确匹配键、金额口径、手续费、税费、退款及允许的差额处理方式。
  3. 核对匹配结果与差异清单,补充原因和凭证后再次对账,未确认项目保留为待查。
参数与输入说明

可直接用自然语言说明这些选项;带代码样式的参数按实际工具定义处理。

参数或输入项 填写说明
账单与期间 双方原始明细、期初期末余额及相同或可解释的日期范围。
匹配依据 订单号、流水号、交易日期等,注明一对多和重复记录情况。
金额口径 含税/未税、原币/本位币、手续费、退款和汇率。
容差与账龄 可指定金额容差、时间差及待查项目账龄范围。
示例需求

核对这份供应商账单与平台调用明细,以订单号和结算日期匹配,金额按含税人民币比较,手续费单列,输出未匹配项及待确认差异。

交付内容

对账汇总、匹配与差异明细、待查项目和账龄或调整建议。

使用前提与注意事项
  • 需要真实且可对应的账单,不能仅凭合计差额推断每笔原因。
  • 对账建议不代表已经入账或调整财务系统,调整分录应经负责人员复核。

使用说明

以下为技能最新版本的 SKILL.md 正文,智能体按其中的步骤完成任务。

平台使用说明

使用当前 Agent 已提供的文件、搜索、代码或业务工具完成任务,按实际可用能力选择路径。默认以中文回应,并遵循用户指定的语言和交付格式。

  • 接受用户在会话中提供的资料,或通过宿主已授权的文件工具读取其指定文件。需要检索、联网、数据库或业务账号时,先确认对应工具真实可用;没有连接器时,使用用户提供的文本或导出文件。
  • 文中的斜杠命令是任务示例,直接根据用户的自然语言请求启动同一流程即可;不要依赖 Claude 专属的插件命令或不存在的工具名称。
  • 不把示例中的实体、数字或工具结果当作用户事实,不虚构已读取、已执行、已发送或已发布。数据不足时说明缺项并完成现有资料支持的部分。
  • 如果任务需要计算或运行脚本,先确认代码运行环境及所需库。工具缺失时给出具体缺项;解释方法、生成草稿不等于已经运行计算。业务写入只使用真实存在且已经授权的工具。
  • 当前技能的资源路径均相对于本技能目录。运行脚本时从宿主提供的技能根目录解析绝对路径,用户资料与输出保存在工作目录,不写入技能资源目录。

先统一币种、期间、税额、单位与金额符号。用上传账单即可进行资料整理;实际数值匹配需代码或表格工具。没有 ERP/银行连接时不声称已取数、已入账或已完成会计签核。

Reconciliation

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.

Reconciliation Types

GL to Subledger Reconciliation

Compare the general ledger control account balance to the detailed subledger balance.

Common accounts:

  • Accounts receivable (GL control vs AR subledger aging)
  • Accounts payable (GL control vs AP subledger aging)
  • Fixed assets (GL control vs fixed asset register)
  • Inventory (GL control vs inventory valuation report)
  • Prepaid expenses (GL control vs prepaid amortization schedule)
  • Accrued liabilities (GL control vs accrual detail schedules)

Process:

  1. Pull GL balance for the control account as of period end
  2. Pull subledger trial balance or detail report as of the same date
  3. Compare totals — they should match if posting is real-time
  4. Investigate any differences (timing of posting, manual entries not reflected, interface errors)

Common causes of differences:

  • Manual journal entries posted to the control account but not reflected in the subledger
  • Subledger transactions not yet interfaced to the GL
  • Timing differences in batch posting
  • Reclassification entries in the GL without subledger adjustment
  • System interface errors or failed postings
Bank Reconciliation

Compare the GL cash balance to the bank statement balance.

Process:

  1. Obtain the bank statement balance as of period end
  2. Pull the GL cash account balance as of the same date
  3. Identify outstanding checks (issued but not cleared at the bank)
  4. Identify deposits in transit (recorded in GL but not yet credited by bank)
  5. Identify bank charges, interest, or adjustments not yet recorded in GL
  6. Reconcile both sides to an adjusted balance

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
Intercompany Reconciliation

Reconcile balances between related entities to ensure they net to zero on consolidation.

Process:

  1. Pull intercompany receivable/payable balances for each entity pair
  2. Compare Entity A's receivable from Entity B to Entity B's payable to Entity A
  3. Identify and resolve differences
  4. Confirm all intercompany transactions have been recorded on both sides
  5. Verify elimination entries are correct for consolidation

Common causes of differences:

  • Transactions recorded by one entity but not the other (timing)
  • Different FX rates used by each entity
  • Misclassification (intercompany vs third-party)
  • Disputed amounts or unapplied payments
  • Different period-end cut-off practices across entities

Reconciling Item Categorization

Category 1: Timing Differences

Items that exist because of normal processing timing and will clear without action:

  • Outstanding checks: Checks issued and recorded in GL, pending bank clearance
  • Deposits in transit: Deposits made and recorded in GL, pending bank credit
  • In-transit transactions: Items posted in one system but pending interface to the other
  • Pending approvals: Transactions awaiting approval to post in one system

Expected resolution: These items should clear within the normal processing cycle (typically 1-5 business days). No adjusting entry needed.

Category 2: Adjustments Required

Items that require a journal entry to correct:

  • Unrecorded bank charges: Bank fees, wire charges, returned item fees
  • Unrecorded interest: Interest income or expense from bank/lender
  • Recording errors: Wrong amount, wrong account, duplicates
  • Missing entries: Transactions in one system with no corresponding entry in the other
  • Classification errors: Correctly recorded but in the wrong account

Action: Prepare adjusting journal entry to correct the GL or subledger.

Category 3: Requires Investigation

Items that cannot be immediately explained:

  • Unidentified differences: Variances with no obvious cause
  • Disputed items: Amounts contested between parties
  • Aged outstanding items: Items that have not cleared within expected timeframes
  • Recurring unexplained differences: Same type of difference appearing each period

Action: Investigate root cause, document findings, escalate if unresolved.

Aging Analysis for Outstanding Items

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
Aging Report Format
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:

  • Compare total outstanding items to prior period
  • Flag if total reconciling items exceed materiality threshold
  • Flag if number of items is growing period over period
  • Identify recurring items that appear every period (may indicate process issue)

Escalation Thresholds

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.

Reconciliation Best Practices

  1. Timeliness: Complete reconciliations within the close calendar deadline (typically T+3 to T+5 business days after period end)
  2. Completeness: Reconcile all balance sheet accounts on a defined frequency (monthly for material accounts, quarterly for immaterial)
  3. Documentation: Every reconciliation should include preparer, reviewer, date, and clear explanation of all reconciling items
  4. Segregation: The person who reconciles should not be the same person who processes transactions in that account
  5. Follow-through: Track open items to resolution — do not just carry items forward indefinitely
  6. Root cause analysis: For recurring reconciling items, investigate and fix the underlying process issue
  7. Standardization: Use consistent templates and procedures across all accounts
  8. Retention: Maintain reconciliations and supporting detail per your organization's document retention policy

版本记录

版本发布日期更新说明
1.0.02026-10-20-

相关技能

全部技能 →
Excel 表格处理 图标

Excel 表格处理

办公效率、数据分析

打开、读取、编辑和修复表格文件,支持 .xlsx、.xlsm、.csv 和 .tsv 格式。

数据探索分析报告 图标

数据探索分析报告

办公效率、数据分析

读取表格文件,进行数据画像、相关性分析和异常值检测,生成交互式图表报告与分析摘要。

会议沟通复盘 图标

会议沟通复盘

办公效率、数据分析

分析会议转写中的发言比例、提问、打断和行动项清晰度,给出带原文证据的沟通建议。

数据结论质量审查 图标

数据结论质量审查

办公效率、数据分析

交付前检查SQL结果、分析报告的分母、聚合、重复计数、样本偏差和结论依据。

预算与经营差异分析 图标

预算与经营差异分析

办公效率、数据分析

比较预算、实际与同期,把收入或成本变化分解为价格、数量、组合等因素。

财务月结管理 图标

财务月结管理

办公效率、数据分析

按月结前、关账日及后续日程整理任务、负责人、依赖、阻塞与进度。

把团队的做事方法沉淀为技能

在技能中心导入技能包、从平台资源生成或在线编写,发布后安装到超级AI助理使用。

前往技能中心
©2025 极简未来
粤ICP备2023060400号
网信算备440307657151501250017号
购买咨询