jwangkun china-gl-recon
Purpose
Perform A股总账核对 — comprehensive general ledger reconciliation for Chinese companies.
Data Sources
Primary: iFind MCP (Tier-1 付费) / AkShare MCP (Tier-2 免费备选)
get_financials(ticker, "balance") → Balance sheet accounts
get_financials(ticker, "income") → P&L accounts
Secondary Sources
- 巨潮 — financial statements
- 审计报告 — reconciliation notes
- 科目余额表 — trial balance
Workflow
Step 1: Understand the Chart of Accounts
Common Chinese COA structure:
| Category | Account Code Range | Key Accounts |
|---|---|---|
| 资产 (Assets) | 1001-1999 | Cash, AR, inventory, PPE |
| 负债 (Liabilities) | 2001-2999 | AP, debt, provisions |
| 所有者权益 (Equity) | 3001-3999 | Capital, reserves, retained earnings |
| 成本 (Cost) | 4001-4999 | COGS, production costs |
| 损益 (P&L) | 5001-5999 | Revenue, expenses, gains/losses |
Key accounts to reconcile:
| Account | CAS Code | Reconciliation Item |
|---|---|---|
| 银行存款 | 1002 | Bank statement |
| 应收账款 | 1122 | AR aging |
| 其他应收款 | 1187 | Related party, advances |
| 存货 | 1403 | Inventory count |
| 固定资产 | 1601 | Fixed asset register |
| 应付账款 | 2202 | Supplier statements |
| 应付职工薪酬 | 2211 | Payroll records |
| 应交税费 | 2221 | Tax returns |
| 未分配利润 | 3405 | P&L close check |
Step 2: Balance Sheet Reconciliation
BS recon checklist:
| Account | GL Balance | Supporting Docs | Reconciled Amount | Difference |
|---|---|---|---|---|
| 货币资金 | Bank statements | |||
| 应收账款 | Aging report | |||
| 预付款项 | Supplier statements | |||
| 存货 | Count sheets | |||
| 其他应收款 | Detail listing | |||
| 长期股权投资 | Investment records | |||
| 固定资产 | Asset register | |||
| 应付账款 | Supplier confirmations | |||
| 应付职工薪酬 | Payroll records | |||
| 应交税费 | Tax returns | |||
| 短期借款 | Loan agreements | |||
| 长期借款 | Loan agreements |
Step 3: Bank Reconciliation
Bank recon:
| Item | GL | Bank Stmt | Difference |
|---|---|---|---|
| Balance per GL | ¥XX | ||
| Add: Deposits in transit | ¥XX | ||
| Less: Outstanding checks | ¥XX | ||
| Add/Less: Errors | ¥XX | ||
| Adjusted GL balance | ¥XX | ||
| Balance per bank | ¥XX | ||
| Reconciled | ✓ / ✗ |
Common reconciling items (China):
- 在途存款 (Deposits in transit)
- 未兑现支票 (Outstanding checks)
- 银行手续费 (Bank charges)
- 利息收入 (Interest income)
- 未达账项 (Unrecorded items)
Step 4: AR Reconciliation
AR aging recon:
| Aging | GL Balance | Aging Report | Confirmed | Difference |
|---|---|---|---|---|
| 0-30 days | ||||
| 31-60 days | ||||
| 61-90 days | ||||
| 91-180 days | ||||
| >180 days | ||||
| Total |
AR recon items:
- 账龄分析 (Aging analysis)
- 坏账准备 (Allowance for doubtful accounts)
- 关联方应收 (Related party AR)
- 票据应收 (Notes receivable)
- 预收账款冲减 (Advances from customers)
Step 5: AP Reconciliation
AP recon:
| Vendor | GL Balance | Vendor Statement | Confirmed | Difference |
|---|---|---|---|---|
| Total |
Step 6: Inventory Reconciliation
Inventory recon:
| Item | GL | Count | Difference | Reason |
|---|---|---|---|---|
| 原材料 | ||||
| 在产品 | ||||
| 产成品 | ||||
| Total |
Inventory recon items:
- 实物盘点 (Physical count)
- 在途存货 (Goods in transit)
- 已发出商品 (Consignment goods)
- 存货跌价准备 (Obsolescence reserve)
Step 7: Fixed Asset Reconciliation
FA recon:
| Asset | GL | Register | Tag Count | Difference |
|---|---|---|---|---|
| Total |
FA recon items:
- 资产标签 (Asset tagging)
- 折旧计算 (Depreciation calculation)
- 减值测试 (Impairment testing)
- 处置记录 (Disposal records)
- 资本化 vs 费用化 (Capitalization policy)
Step 8: Payroll Reconciliation
Payroll recon:
| Item | GL | Payroll Records | Tax Filing | Difference |
|---|---|---|---|---|
| 工资 | ||||
| 社保 | ||||
| 公积金 | ||||
| 个税 | ||||
| Total |
Step 9: Tax Reconciliation
Tax recon:
| Tax Type | GL | Tax Return | Difference |
|---|---|---|---|
| 增值税 | |||
| 企业所得税 | |||
| 附加税 | |||
| 个税 | |||
| 社保/公积金 |
Step 10: P&L Close Check
P&L to retained earnings:
期初未分配利润
+ 本年净利润 (from P&L close)
- 提取盈余公积
- 提取任意公积
- 应付股利
= 期末未分配利润
Verify:
- P&L close → retained earnings
- 利润分配 entries
- Tax entries
- Dividend entries
China-Specific Recon Considerations
Common Issues
| Issue | Detection | Resolution |
|---|---|---|
| 在途资金 | Bank recon | Timing difference |
| 未达账项 | Bank recon | Follow up |
| 关联方挂账 | AR/AP aging | Related party recon |
| 发票差异 | Tax recon | Timing/cut-off |
| 折旧差异 | FA recon | Policy check |
CAS-Specific Items
| Item | Treatment |
|---|---|
| 增值税 | Pass-through, check VAT output/input |
| 政府补助 | Verify classification |
| 股份支付 | Expense recognition check |
| 汇兑损益 | FX difference verification |
Quality Checks
Before completing:
- All significant accounts reconciled
- Differences investigated and resolved
- Documentation complete
- Sign-offs obtained
- Adjustments proposed (if any)
Data Source Mode Switch: Set env var
IFIND_DATA_SOURCE_MODEto control data source preference.ifind-only(strict): Use iFind only, error if unavailableifind-fallback(default): iFind preferred, fallback to AkShareakshare-only, wind-only (Wind only), wind-fallback (Wind first, fallback to iFind → AkShare): Skip iFind, use AkShare only