Home › Guides

Map ERP tax codes to VAT return boxes and file the periodic return

Your ERP records tax by tax code. The authority asks for tax by box. Between the two sits a mapping that someone has to design, test and keep current. When the mapping is wrong, the return can still add up: the total payable is right, but sales sit in the wrong box, a reverse-charge purchase is missing from both sides, or an exempt supply is not reported at all.

Part 3 of 3 in the series Running a country after go-live. Read this first: Localization governance: a RACI per obligation type and a review calendar.

This guide shows how to build that mapping as a controlled matrix, prepare the return from it, reconcile it to the ledger and post the settlement. It does not give any country's box numbers or rates. Each country's form, frequency, deadline and channel is on VAT reporting, with the official source.

This site currently lists 100 VAT reporting requirements in 73 countries, of which 66 are ordinary periodic VAT returns. Each row on VAT reporting gives the form, frequency, deadline and channel with its official source, and shows which ERPs document support for it.

Start from the form, not the tax codes

Download the current return form and its instructions from the authority. List every box with its label and what it asks for: a net amount, a tax amount, or both. Note boxes that are calculated from other boxes. Then mark which boxes your business will use. A domestic seller with no imports may use a handful; a trading company may use most of them.

Next, list every tax code in the ERP, including codes that are no longer used but still have postings in open periods. For each code, record what it represents: the type of supply, the direction (sale or purchase), the rate, and any special treatment such as reverse charge, exemption, intra-community supply or import.

Build the tax-code-to-box matrix

A tax code often feeds more than one box. A domestic sale at the standard rate feeds a net-amount box and an output-tax box. A reverse-charge purchase usually feeds an output-tax box, an input-tax box and one or more net-amount boxes. Record each of those links as its own row.

Tax code	Meaning	Net amount to box	Tax amount to box	Sign	Notes
S-STD	Domestic sale, standard rate	Box A (taxable sales)	Box B (output tax)	+
S-EXM	Exempt domestic sale	Box C (exempt sales)	—	+	Check whether the form asks for it
S-ICS	Intra-community supply of goods	Box D	—	+	Also feeds the EU sales list
P-STD	Domestic purchase, deductible	Box E (purchases)	Box F (input tax)	+
P-RC	Reverse-charge purchase	Box E and Box G	Box B and Box F	+	Same tax amount on both sides
P-NDED	Non-deductible purchase	Box E (if asked)	—	+	No input tax

The box letters in this table are placeholders. Replace them with the boxes on your country's form. Agree the sign convention for credit notes: a credit note on a sale must reduce the same boxes the sale increased.

Have the tax owner approve the matrix. Store it with an effective date, because forms change. When the authority publishes a new form, version the matrix rather than overwriting it, so you can still re-run an old period.

Configure the ERP and test it

Many ERPs have a return-report designer, a box or tax-grid field on the tax code, or a localization that ships with a box mapping. Whichever you use, compare its mapping with your approved matrix line by line. A delivered mapping reflects one reading of the form; your business may use codes that it does not cover.

Test with a set of known transactions: one per tax code, plus a credit note, a reverse-charge purchase, a transaction in foreign currency and a manual journal that hits a tax account. Run the return for the test period and check every box against your expected values. Check the acceptance tests guide for how to record the evidence.

Prepare the return each period

Close the period for tax postings, so nothing posts after you run the report.
Run the return report and the tax-code totals for the same period.
Reconcile: the sum of the output-tax boxes equals the balance on the output-tax accounts for the period; the input-tax boxes equal the input-tax accounts. Explain any difference before filing.
Check that no posting uses a tax code with no mapping. A transaction with no tax code on a tax account is a warning sign.
Have the return reviewed and approved, then file it through the channel the country page names.
Store the filed return, the report output, the reconciliation and the receipt together.

If you issue e-invoices or report transactions to the authority, also compare the return with that data; see reconcile e-invoices with the ERP and the tax return.

Worked example: one return period

A company has one month of activity. The amounts are illustrative round numbers, and the 20% rate is an example, not a statement of any country's rate.

Activity	Tax code	Net	Tax
Domestic sales	S-STD	10,000	2,000
Domestic purchases	P-STD	4,000	800

The return shows Box A 10,000, Box B 2,000, Box E 4,000 and Box F 800. Tax payable is 2,000 − 800 = 1,200.

Example entries: settle the VAT accounts and pay (illustrative)
Step	Account	Debit	Credit
Settle output and input VAT to VAT payable	Output VAT	2,000.00
	Input VAT		800.00
	VAT payable		1,200.00
Pay the authority	VAT payable	1,200.00
	Bank		1,200.00

After the settlement, the output-VAT and input-VAT accounts for the period are zero, and the VAT payable account holds exactly the amount on the return. After payment it is zero too. If VAT payable does not clear, either the payment differs from the return or something posted to the tax accounts after the return was run.

Now suppose a reverse-charge purchase of 1,000 had been booked with code P-STD instead of P-RC. Box B would be 200 too low and Box G would be missing. Tax payable would not change, because the output and input amounts cancel. That is why the reconciliation checks boxes, not only the total payable.

Corrections

When you find an error after filing, follow the authority's correction route. Some countries adjust in the next return; others require an amended return. Record the original box values, the corrected values and the reason. Do not repost old transactions in the current period without the tax owner's approval, because that moves amounts between periods.

Worksheet

Use the tax-code-to-box matrix and return checklist.

Worksheet: Tax-code-to-box matrix and return checklist

Copy this worksheet for each case. It records decisions and evidence; it does not determine the tax or legal treatment.

Show the worksheet

Use with the VAT return mapping guide. Keep one approved version per form version.

Form

Country, return name and form version:
Effective from:
Source (authority page) and country row on this site:
Approved by (tax owner) and date:

Matrix

Tax code	Meaning	Net amount to box	Tax amount to box	Sign	Valid from	Valid to	Notes

Test set

☐ One transaction per tax code
☐ Credit note reduces the same boxes as the sale
☐ Reverse-charge purchase hits both sides
☐ Foreign-currency transaction uses the approved rate
☐ Manual journal to a tax account is caught

Period checklist

☐ Tax period closed for posting
☐ Return report and tax-code totals run for the same period
☐ Output-tax boxes = output-tax accounts; input-tax boxes = input-tax accounts
☐ No postings with unmapped tax codes
☐ Reviewed and approved
☐ Filed; receipt stored
☐ Settlement posted; VAT payable equals the return
☐ Payment made; VAT payable cleared

Sources checked: 27 October 2026. Forms, frequencies, deadlines and channels come from this site's VAT reporting rows and their official sources. Box numbers and rates in this guide are placeholders.