Tax Code Mapping for Mexico DIOT File (Mexico Complementary Features SuiteApp)

Note:

Only Vendor Bill, Vendor Credit, and Expense Report transactions mapped as 002 - IVA tax codes in the Mapping Tool are included in the DIOT file.

Here is a list of terminology used in the TAX Codes for Mexico DIOT File:

National vendor

Vendor type identified by Mexican tx registration

Foreign vendor

Vendor type that can be identified by a Mexican tax registration, and a single non-Mexican tax registration

Global vendor

Vendor type that can be identified by a Mexican tax registration, and one or more non-Mexican tax registrations

Standard tax rate

002 - IVA tax rates including 11% and 16%

Reduced tax rate

002 - IVA tax rate of 8%

Zero tax rate

002 - IVA tax rate of 0%

Exempt tax rate

002 - IVA exempt tax rate

The following table shows how NetSuite uses the Mexico VAT codes to get the values for the DIOT file. Tax codes for Mexico are described in the Mexico Tax Codes.

DIOT Column Number	Content
1	Vendor Type: 04 - National vendor 05 - Foreign vendor 15 - Global vendor
2	Operation Type: 03 - Professional services 06 - Real estate leasing 85 - Others
3	Mexican Tax ID - RFC: Required when Vendor type is 04 Optional when Vendor type is 05 Not requested when Vendor type is 15
4	Foreign Tax ID: Required when Vendor type is 05
5	Vendor name: Required when Vendor type is 05 Not required when Vendor type is 04 or 15
6	Country for Foreign Vendors: Required when Vendor type is 05 Not required when Vendor type is 04 or 15
7	Nationality: Required when Vendor type is 05 Not required when Vendor type is 04 or 15
8	Sum of the value of the bills paid, before IVA, where standard tax rate was applied
9	0 (not supported)
10	0 (not supported)
11	0 (not supported)
12	0 (not supported)
13	Sum of the value of the bills paid, before IVA, where reduced tax rate was applied
14	0 (not supported)
15	0 (not supported)
16	Sum of the value of the bills paid, before IVA, where standard tax rate was applied
17	0 (not supported)
18	0 (not supported)
19	0 (not supported)
20	Sum of the value of the bills paid, before IVA, where exempt tax rate was applied
21	Sum of the value of the bills paid, before IVA, where zero tax rate was applied
22	Sum of the value of the bills paid, before IVA, where exempt tax rate was applied
23	Sum of the values of the bills paid where withholding taxes were applied”.
24	Returns and discounts on bills that have any of the following tax rate: standard, reduced, zero, exempt

General Notices