reconciliation
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseReconciliation
账户对账
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:
- Pull GL balance for the control account as of period end
- Pull subledger trial balance or detail report as of the same date
- Compare totals — they should match if posting is real-time
- 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
将总账控制账户余额与明细子分类账余额进行比对。
常见账户:
- 应收账款(总账控制账户 vs 应收账款子分类账账龄)
- 应付账款(总账控制账户 vs 应付账款子分类账账龄)
- 固定资产(总账控制账户 vs 固定资产登记簿)
- 存货(总账控制账户 vs 存货估值报告)
- 预付费用(总账控制账户 vs 预付费用摊销表)
- 应计负债(总账控制账户 vs 应计项目明细表)
流程:
- 提取期末控制账户的总账余额
- 提取同一日期的子分类账试算平衡表或明细报告
- 比对总额——如果是实时过账,两者应一致
- 调查所有差异(过账时间差异、未在子分类账中体现的手工分录、接口错误)
差异常见原因:
- 过账至控制账户但未在子分类账中体现的手工日记账分录
- 子分类账交易尚未对接至总账
- 批量过账的时间差异
- 总账中进行了重分类分录但未调整子分类账
- 系统接口错误或过账失败
Bank Reconciliation
银行对账
Compare the GL cash balance to the bank statement balance.
Process:
- Obtain the bank statement balance as of period end
- Pull the GL cash account balance as of the same date
- Identify outstanding checks (issued but not cleared at the bank)
- Identify deposits in transit (recorded in GL but not yet credited by bank)
- Identify bank charges, interest, or adjustments not yet recorded in GL
- 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将总账现金账户余额与银行对账单余额进行比对。
流程:
- 获取期末银行对账单余额
- 提取同一日期的总账现金账户余额
- 识别未兑现支票(已开具但尚未在银行结清)
- 识别在途存款(已在总账记录但尚未获得银行贷记)
- 识别尚未在总账记录的银行手续费、利息或调整项
- 将双方余额调节至调整后一致的金额
标准格式:
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.00Intercompany Reconciliation
公司间对账
Reconcile balances between related entities to ensure they net to zero on consolidation.
Process:
- Pull intercompany receivable/payable balances for each entity pair
- Compare Entity A's receivable from Entity B to Entity B's payable to Entity A
- Identify and resolve differences
- Confirm all intercompany transactions have been recorded on both sides
- 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
调节关联实体之间的余额,确保合并报表中余额抵消为零。
流程:
- 提取各实体对的公司间应收/应付余额
- 比对实体A对实体B的应收账款与实体B对实体A的应付账款
- 识别并解决差异
- 确认所有公司间交易已在双方记录
- 验证合并抵消分录的正确性
差异常见原因:
- 一方实体已记录但另一方未记录的交易(时间差异)
- 各实体使用不同的汇率
- 分类错误(公司间 vs 第三方)
- 有争议的金额或未核销的付款
- 各实体期末截止日处理方式不同
Reconciling Item Categorization
对账差异项分类
Category 1: Timing Differences
类别1:时间差异
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.
因正常处理时间导致的差异项,无需操作即可自动结清:
- 未兑现支票:已开具并在总账记录,等待银行结清
- 在途存款:已存入并在总账记录,等待银行贷记
- 在途交易:在一个系统中过账但尚未对接至另一个系统的项目
- 待审批项:在一个系统中等待审批才能过账的交易
预期解决方式:这些项目应在正常处理周期内结清(通常为1-5个工作日),无需调整分录。
Category 2: Adjustments Required
类别2:需调整项
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
类别3:需调查项
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 |
跟踪对账差异项的账龄,识别需要升级处理的呆滞项目:
| 账龄区间 | 状态 | 操作 |
|---|---|---|
| 0-30天 | 当前 | 监控——处于正常处理周期内 |
| 31-60天 | 逾期 | 调查——跟进未结清原因 |
| 61-90天 | 超期 | 升级——通知主管,记录调查情况 |
| 90天以上 | 呆滞 | 升级至管理层——可能需要核销或调整 |
Aging Report Format
账龄报告格式
| Item # | Description | Amount | Date Originated | Age (Days) | Category | Status | Owner |
|---|---|---|---|---|---|---|---|
| 1 | [Detail] | $X,XXX | [Date] | XX | [Type] | [Status] | [Name] |
| 项目编号 | 描述 | 金额 | 产生日期 | 账龄(天数) | 类别 | 状态 | 负责人 |
|---|---|---|---|---|---|---|---|
| 1 | [详情] | $X,XXX | [日期] | XX | [类型] | [状态] | [姓名] |
Trending
趋势分析
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.
根据组织的风险承受能力定义升级触发条件:
| 触发条件 | 阈值(示例) | 升级对象 |
|---|---|---|
| 单个项目金额 | > $10,000 | 主管审核 |
| 单个项目金额 | > $50,000 | 财务总监审核 |
| 对账差异项总额 | > $100,000 | 财务总监审核 |
| 项目账龄 | > 60天 | 主管跟进 |
| 项目账龄 | > 90天 | 财务总监/管理层审核 |
| 未对账差异 | 任何金额 | 无法结账——必须解决或记录 |
| 增长趋势 | 连续3期以上 | 流程改进调查 |
注:需根据组织的重要性水平和风险偏好设置阈值。上述示例仅作说明。
Reconciliation Best Practices
对账最佳实践
- Timeliness: Complete reconciliations within the close calendar deadline (typically T+3 to T+5 business days after period end)
- Completeness: Reconcile all balance sheet accounts on a defined frequency (monthly for material accounts, quarterly for immaterial)
- Documentation: Every reconciliation should include preparer, reviewer, date, and clear explanation of all reconciling items
- Segregation: The person who reconciles should not be the same person who processes transactions in that account
- Follow-through: Track open items to resolution — do not just carry items forward indefinitely
- Root cause analysis: For recurring reconciling items, investigate and fix the underlying process issue
- Standardization: Use consistent templates and procedures across all accounts
- Retention: Maintain reconciliations and supporting detail per your organization's document retention policy
- 及时性:在结账日历规定的截止日期内完成对账(通常为期末后T+3至T+5个工作日)
- 完整性:按既定频率对所有资产负债表账户进行对账(重要账户每月对账,非重要账户每季度对账)
- 文档记录:每笔对账都应包含编制人、审核人、日期,以及所有对账差异项的清晰说明
- 职责分离:对账人员不应同时负责该账户的交易处理
- 跟进落实:跟踪未结项直至解决——不要无限期结转
- 根本原因分析:对于反复出现的对账差异项,调查并修复潜在的流程问题
- 标准化:所有账户使用一致的模板和流程
- 留存:根据组织的文档留存政策保存对账记录及支持性明细