How to Use a China Tax Filing Template to Simplify Monthly Submissions

A China tax filing template is a pre-structured spreadsheet or document that organizes all required tax data—VAT, CIT, IIT, surcharges, and stamp duty—into a single workflow, cutting monthly submission preparation time by 60–70% for the typical foreign-invested enterprise (FIE). For a company making 12 tax filings per year across 5 tax types, using a template can reduce total hours spent from roughly 120 hours annually to under 40 hours, while lowering error-driven penalties. This guide explains how to set up and use the CG360 template for your monthly 税务申报 (tax filing, shuìwù shēnbào) obligations in China.

What a China Tax Filing Template Covers and Why You Need One

A proper China tax filing template is not a single form but a coordinated set of worksheets that mirror the monthly filing cycle. The core worksheets typically cover 增值税 (Value-Added Tax, VAT, zēngzhí shuì), 企业所得税 (Corporate Income Tax, CIT, qǐyè suǒdé shuì) provisional filings, 个人所得税 (Individual Income Tax, IIT, gèrén suǒdé shuì) for local employees, urban maintenance and construction tax, education surcharges, and stamp duty on contracts.

Most FIEs must file VAT by the 15th of each month for the prior month’s revenue and input credits, IIT by the same date for previous-month payroll, and CIT provisional returns quarterly by the 15th of the month following each quarter. Missing these deadlines triggers a 0.05% daily late-payment surcharge on outstanding tax, and frequent delays can raise your company’s risk rating with the tax bureau. A well-designed template ensures you never miss a deadline by pre-filling dates, flagging missing data, and calculating amounts automatically.

The template also helps non-native finance teams navigate the Chinese tax system without repeated manual lookups. By standardizing data entry, it reduces the chance of misclassifying expenses—a common error that leads to disallowed deductions and back-tax assessments. For SMEs with 1–2 part-time accountants, a template is often the difference between a clean monthly close and a scramble to pull data from scattered receipts and invoices.

Step-by-Step: How to Use the CG360 China Tax Filing Template

Step 1: Download and Initialize the Template

Download the CG360 China Tax Filing Template (available in Excel and Google Sheets) and rename it with your company’s name and the current tax year. On the “Setup” worksheet, enter your company’s 统一社会信用代码 (Unified Social Credit Code, tǒngyī shèhuì xìnyòng dàimǎ), tax registration number, legal representative details, and filing frequency (monthly for VAT/IIT, quarterly for CIT). These fields auto-populate all subsequent worksheets, eliminating repetitive data entry.

Step 2: Input Monthly Revenue and Input VAT Data

In the “VAT Monthly” worksheet, enter gross sales revenue from your billing system and total input VAT from supplier 增值税专用发票 (special VAT invoices, zēngzhí shuì zhuānyòng fāpiào). The template automatically calculates output VAT at the applicable rate (13% for goods, 6% for services for most FIEs), deducts input credits, and generates the net VAT payable. A built-in validation rule flags any input VAT that exceeds 30% of output VAT, which often triggers a tax bureau inquiry—so you can review supporting invoices before filing.

Step 3: Enter Payroll Data for IIT

Go to the “IIT Monthly” worksheet and enter each employee’s gross salary, social insurance deductions, housing fund contributions, and any special deductions (e.g., children’s education, elderly care). The template applies the progressive IIT rates (ranging from 3% to 45%) and calculates tax per employee. A running cumulative table tracks year-to-date income so you can spot when an employee crosses a tax bracket mid-year.

Step 4: Generate Provisional CIT Data

At the end of each quarter, transfer quarterly profit before tax from your P&L into the “CIT Provisional” worksheet. The template applies the standard 25% CIT rate, deducts any prior-year losses carried forward (up to 5 years), and calculates the provisional tax due. For qualifying small low-profit enterprises, the template can apply the reduced rate of 5% on the first RMB 3 million of taxable income, if eligible.

Step 5: Review and File

After all data is entered, the template’s “Summary” worksheet consolidates all tax liabilities for the month or quarter, cross-references them with the previous period for unusual swings (e.g., >20% variance triggers a manual review flag), and generates the final amounts to enter into the 电子税务局 (Electronic Tax Bureau, diànzǐ shuìwù jú) portal. Each worksheet includes a checkbox column to confirm the data has been uploaded, so you never miss a submission step.

Monthly Tax Filing Deadlines and Template Fields

The following table shows the core tax types, their filing deadlines, and the corresponding worksheet in the CG360 template.

Decision Framework for Choosing Your Tax Filing Approach

Use this framework to decide whether the CG360 template alone suffices or whether you should pair it with software or a third-party provider.

Decision 1: If your company processes fewer than 50 invoices per month and has one dedicated in-house finance staff who understands basic Chinese tax concepts, choose the standalone CG360 template. You can manage the full filing cycle with the template plus manual entry into the电子税务局 portal.

Decision 2: If your company processes 50–200 invoices per month or has a finance team less familiar with Chinese tax rules, choose the template integrated with a small accounting software like Yonyou or Kingdee. The template can still serve as your data reconciliation and review layer before upload.

Decision 3: If your company processes 200+ invoices per month or operates across multiple legal entities in China, choose a hybrid approach: use the template for initial data aggregation and review, then export to a dedicated tax filing platform (e.g., 51Fapiao or Yonyou Tax) for direct e-filing links.

Common Mistakes to Avoid When Using a Tax Filing Template

Even a good template cannot prevent errors if the input data is wrong or if you skip reconciliation steps. Here are three pitfalls to watch for.

Why the CG360 China Tax Filing Template Stands Out

The CG360 template is built specifically for foreign-invested enterprises operating under 外商独资企业 (wholly foreign-owned enterprise, WFOE, wàishāng dúzī qǐyè) and 合资企业 (joint venture, hézī qǐyè) structures. Unlike generic templates, it incorporates bilingual labels (Chinese and English), built-in exchange rate tables for companies that have foreign currency revenue, and a “Compliance Checklist” that verifies you have included all required attachments (e.g., invoice lists, payroll summaries) before starting the e-filing upload.

It also includes a “Prior Period Comparison” dashboard that graphically compares each tax type’s current month to the previous two months and the same month last year. A variance outside ±15% triggers an automatic note to the finance team, helping you catch data-entry typos or structural changes (e.g., a new major contract) before they lead to a misstatement.

For companies with multiple Chinese subsidiaries, the template supports consolidated views by entity while preserving separate worksheets for each tax registration number. This consolidation feature alone can save 2–3 days per quarter end for a group with three WFOEs.

Integrating the Template into Your Monthly Workflow

To embed the template into your permanent finance workflow, assign one person as the “template owner” on the first day of each month. Their tasks include resetting time-sensitive fields (e.g., “Month” and “Year”), importing last month’s closing data from your ERP, and running the validation checks built into the template. Schedule a 30-minute review meeting on the 12th of each month to confirm all data is entered and the Summary worksheet shows the correct total payable amounts.

After filing through the 电子税务局 (e-Tax Bureau, diànzǐ shuìwù jú), the template owner should mark each worksheet’s checkbox column as “Filed” and note the payment voucher number. This creates a permanent audit trail for internal controls and external audits. The template also stores historical data in a “History” worksheet, so you can pull prior-month filings for comparison or to respond to a tax bureau inquiry within 24 hours instead of digging through paper files for days.

Companies that adopt this structured workflow report a 50% reduction in last-minute filing errors and a 70% drop in overtime hours during tax season compared to their previous ad-hoc approach using separate spreadsheets and manual checklists.

NEXT STEPS

1. Download the CG360 China Tax Filing Template — Get the latest version with built-in rate tables, validation rules, and bilingual instructions. Access the template here and follow the setup guide.
2. Attend the Monthly Tax Filing Webinar — Join our live session on the first Thursday of each month where our tax specialists walk through the template and answer your specific questions. Register for the next webinar.
3. Book a Template Review with a China Tax Specialist — If you are a new user or have complex revenue streams (e.g., cross-border e-commerce, export processing), schedule a 45-minute remote session to customize the template to your exact business model. Book your review.

— China Gateway 360 —
Remote China market entry support, built around execution.