brainstorming
brainstorming
You MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation).
china-gl-reconGeneral ledger reconciliation for A-share companies. Adapts the original gl-recon skill for Chinese accounting standards, chart of accounts, and common reconciliation items. Triggers on "A股总账核对", "总账调节", "GL reconciliation China", "科目余额表", or "reconcile [company] accounts".
Independent GitHub snapshot · Automated classification · Original documentation governs
Perform A股总账核对 — comprehensive general ledger reconciliation for Chinese companies.
get_financials(ticker, "balance") → Balance sheet accounts
get_financials(ticker, "income") → P&L 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 |
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 |
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):
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:
AP recon:
| Vendor | GL Balance | Vendor Statement | Confirmed | Difference |
|---|---|---|---|---|
| Total |
Inventory recon:
| Item | GL | Count | Difference | Reason |
|---|---|---|---|---|
| 原材料 | ||||
| 在产品 | ||||
| 产成品 | ||||
| Total |
Inventory recon items:
FA recon:
| Asset | GL | Register | Tag Count | Difference |
|---|---|---|---|---|
| Total |
FA recon items:
Payroll recon:
| Item | GL | Payroll Records | Tax Filing | Difference |
|---|---|---|---|---|
| 工资 | ||||
| 社保 | ||||
| 公积金 | ||||
| 个税 | ||||
| Total |
Tax recon:
| Tax Type | GL | Tax Return | Difference |
|---|---|---|---|
| 增值税 | |||
| 企业所得税 | |||
| 附加税 | |||
| 个税 | |||
| 社保/公积金 |
P&L to retained earnings:
期初未分配利润
+ 本年净利润 (from P&L close)
- 提取盈余公积
- 提取任意公积
- 应付股利
= 期末未分配利润
Verify:
| 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 |
| Item | Treatment |
|---|---|
| 增值税 | Pass-through, check VAT output/input |
| 政府补助 | Verify classification |
| 股份支付 | Expense recognition check |
| 汇兑损益 | FX difference verification |
Before completing:
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