reconciliation

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

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
将总账控制账户余额与明细子分类账余额进行比对。
常见账户:
  • 应收账款(总账控制账户 vs 应收账款子分类账账龄)
  • 应付账款(总账控制账户 vs 应付账款子分类账账龄)
  • 固定资产(总账控制账户 vs 固定资产登记簿)
  • 存货(总账控制账户 vs 存货估值报告)
  • 预付费用(总账控制账户 vs 预付费用摊销表)
  • 应计负债(总账控制账户 vs 应计项目明细表)
流程:
  1. 提取期末控制账户的总账余额
  2. 提取同一日期的子分类账试算平衡表或明细报告
  3. 比对总额——如果是实时过账,两者应一致
  4. 调查所有差异(过账时间差异、未在子分类账中体现的手工分录、接口错误)
差异常见原因:
  • 过账至控制账户但未在子分类账中体现的手工日记账分录
  • 子分类账交易尚未对接至总账
  • 批量过账的时间差异
  • 总账中进行了重分类分录但未调整子分类账
  • 系统接口错误或过账失败

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
将总账现金账户余额与银行对账单余额进行比对。
流程:
  1. 获取期末银行对账单余额
  2. 提取同一日期的总账现金账户余额
  3. 识别未兑现支票(已开具但尚未在银行结清)
  4. 识别在途存款(已在总账记录但尚未获得银行贷记)
  5. 识别尚未在总账记录的银行手续费、利息或调整项
  6. 将双方余额调节至调整后一致的金额
标准格式:
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
调节关联实体之间的余额,确保合并报表中余额抵消为零。
流程:
  1. 提取各实体对的公司间应收/应付余额
  2. 比对实体A对实体B的应收账款与实体B对实体A的应付账款
  3. 识别并解决差异
  4. 确认所有公司间交易已在双方记录
  5. 验证合并抵消分录的正确性
差异常见原因:
  • 一方实体已记录但另一方未记录的交易(时间差异)
  • 各实体使用不同的汇率
  • 分类错误(公司间 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 BucketStatusAction
0-30 daysCurrentMonitor — within normal processing cycle
31-60 daysAgingInvestigate — follow up on why item has not cleared
61-90 daysOverdueEscalate — notify supervisor, document investigation
90+ daysStaleEscalate to management — potential write-off or adjustment needed
跟踪对账差异项的账龄,识别需要升级处理的呆滞项目:
账龄区间状态操作
0-30天当前监控——处于正常处理周期内
31-60天逾期调查——跟进未结清原因
61-90天超期升级——通知主管,记录调查情况
90天以上呆滞升级至管理层——可能需要核销或调整

Aging Report Format

账龄报告格式

Item #DescriptionAmountDate OriginatedAge (Days)CategoryStatusOwner
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:
TriggerThreshold (Example)Escalation
Individual item amount> $10,000Supervisor review
Individual item amount> $50,000Controller review
Total reconciling items> $100,000Controller review
Item age> 60 daysSupervisor follow-up
Item age> 90 daysController / management review
Unreconciled differenceAny amountCannot close — must resolve or document
Growing trend3+ consecutive periodsProcess 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

对账最佳实践

  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. 及时性:在结账日历规定的截止日期内完成对账(通常为期末后T+3至T+5个工作日)
  2. 完整性:按既定频率对所有资产负债表账户进行对账(重要账户每月对账,非重要账户每季度对账)
  3. 文档记录:每笔对账都应包含编制人、审核人、日期,以及所有对账差异项的清晰说明
  4. 职责分离:对账人员不应同时负责该账户的交易处理
  5. 跟进落实:跟踪未结项直至解决——不要无限期结转
  6. 根本原因分析:对于反复出现的对账差异项,调查并修复潜在的流程问题
  7. 标准化:所有账户使用一致的模板和流程
  8. 留存:根据组织的文档留存政策保存对账记录及支持性明细