China Finance & Tax Excel Practice

Problem

Finance teams working on China-related spreadsheets often get stuck on policy scope, local rules, and formula compatibility. Small-scale and general VAT taxpayers use different rates; annual IIT depends on yearly brackets and special deductions; social insurance and housing fund rules change by city; bank reconciliation also requires identifying unreconciled items. A common pain point is that formulas may compute correctly, but it is unclear which policy year, province, or taxpayer status should be used.

How It Works

This skill routes questions into fixed paths: VAT, individual income tax, social insurance and housing fund, payroll, financial statements, and bank reconciliation. Before writing formulas, it confirms taxpayer status, policy year, and local jurisdiction. The output typically includes WPS-compatible formulas, worked validation examples, and policy references, such as VLOOKUP, LOOKUP, array extraction of invoice numbers, and cumulative withholding. It also prefers to avoid Excel 365-only functions such as LET, LAMBDA, and TEXTSPLIT. For complex edge cases, such as cross-border matters, equity changes, M&A, tax inspections, or large supplementary payments, it recommends consulting a professional tax advisor.

Boundaries

It does not provide tax avoidance schemes, does not replace official filing, and does not promise indefinite validity for historical policy. All figures and formulas should be manually rechecked before filing, in line with the latest local tax authority guidance. Regional incentives, real-estate-related taxes, equity matters, and cross-border scenarios especially require professional review.