Tax Code Mapping for Mexico DIOT File (Mexico Compliance SuiteApp)
Only transactions with IVA (VAT) relevant tax codes are included in the DIOT file. If a transaction has no tax code, or if the tax code is marked as Exclude from VAT reports, the transaction will not be included in the DIOT file.
Make sure that your transactions conform to the following rules:
-
For transactions with non-Mexican vendors, use tax codes with the Import property.
-
For transactions with Mexican vendors, use tax codes that do not have the Import property.
-
For transactions with either Mexican or non-Mexican vendors, you can use tax codes with 0% rate or tax codes with the Exempt property.
When you click Save on a transaction record, the system checks if there are line items that do not conform to the rules for import or non-import tax codes. If validation errors are found, the system displays the errors in a confirmation message. You can change the tax codes before saving, or you can choose to save the record without changing the tax codes.
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 Tax Code Table for Mexico.
DIOT Column Number |
Content |
---|---|
8 |
Sum of the value of the bills paid, before IVA, where tax code S-MX 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 tax code R-MX was applied |
14 |
0 (not supported) |
15 |
Sum of the value of the bills paid, before IVA, where tax code DR-MX was applied |
16 |
Sum of the value of the bills paid, before IVA, where tax code IS-MX 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 tax code IE-MX was applied |
21 |
Sum of the value of the bills paid, before IVA, where tax code Z-MX or IZ-MX or ZX-MX was applied |
22 |
Sum of the value of the bills paid, before IVA, where tax code E-MX was applied |
23 |
Withholding VAT |
24 |
Returns and discounts on bills that have any of the following tax codes:
|