Country & TaxFree worksheetPDF, Excel, Word exportChina

China VAT Special Fapiao Reconciliation Worksheet

Accounts payable teams in China reconcile VAT on every incoming fapiao against what the ERP posted. This worksheet calculates the expected tax from the net amount and rate and shows two differences: fapiao versus calculation, and ERP versus fapiao.

Download:

Expected VAT	Difference	ERP vs fapiao
CNY 13,000	CNY 0	CNY 0
CNY 6,266	CNY 0	CNY 0
CNY 1,125	CNY 0	-CNY 25
CNY 480	CNY 0	CNY 0

Total net

CNY 168,700

Total VAT on fapiao

CNY 20,871

Total rounding difference

CNY 0

Total ERP variance

-CNY 25

Effective VAT rate

12.4%

Common mainland rates are 13 percent, 9 percent and 6 percent, with 3 percent for some small-scale taxpayers. Rates change by policy; confirm current rules with your tax adviser. A small rounding difference per invoice is normal.

AP reconciliation automation

Optional: talk through automating the ERP side of fapiao reconciliation.

Optional. The tool and every export work without this. No spam.

How to use it

Enter one row per fapiao with the net amount, VAT rate, tax printed on the invoice and the tax posted in your ERP. The sheet computes expected VAT rounded to two decimals, then the difference to the invoice and to the ledger. Rows with a non-zero ERP variance are the ones to fix before the monthly input VAT certification and filing cut-off.

Reading the differences

A difference of a few fen is usually rounding from line level calculation. A larger gap means the wrong tax code, a split invoice, or an invoice that includes a non-taxable item. A fapiao-to-calculation gap points at the supplier; an ERP-to-fapiao gap points at your posting or tax code setup.

Check the tax code mapped to each purchase category
Look for freight billed at 9 percent on a 13 percent order
Watch for credit notes posted with the wrong sign
Confirm the period you post matches the period you claim

Common mistakes

Do not assume one rate per supplier. A single supplier may bill goods at 13 percent and services at 6 percent on separate lines. Also keep the fapiao number as text, never as a number, so leading digits are not lost in Excel. Tax rules and e-fapiao formats change, so treat this as a working check, not a filing.

Frequently Asked Questions

Which VAT rates does it support?

Any. You type the rate in percent. Typical mainland rates are 13, 9 and 6 percent, and 3 percent for some small-scale taxpayers, but check current policy.

Why compute VAT again?

It exposes tax code and rounding problems early, before they appear as unexplained differences in the VAT account at period end.

Is this a tax filing tool?

No. It is a reconciliation aid. File through the official tax platform and follow advice from your tax adviser.

Can I use it for sales invoices?

Yes, the arithmetic is the same. Enter output VAT and compare it with the ledger.

If you reconcile hundreds of fapiao each month, Netray can discuss pulling the ERP side of this check automatically from your tables.

Talk to an Expert Explore More Free Tools

Related Tools

Country & Tax

More Country & Tax tools

See all

Back to All Tools