Mexico DIOT File (Mexico Complementary Features SuiteApp)
In Mexico, taxpayers must submit a monthly declaration of all payments made to third parties, with details of the applicable value added tax.
Using the Mexico Complementary Features SuiteApp you can generate a DIOT file that conforms to the requirements specified by the SAT, and can be submitted online to the tax authority portal.
The DIOT File Report is only available for accounts that use OneWorld. and SuiteTax
The Mexico DIOT file is a text file that contains a list of all payments made by a subsidiary to third parties within a selected period, and includes details of applicable value added tax. Only vendor bill, vendor credit and expense report operations with IVA relevant tax codes are included in the DIOT file. If a transaction has no tax code, the transaction is not included in the DIOT file. For information about transactions included in the DIOT file, see Tax Code Mapping for Mexico DIOT File (Mexico Complementary Features SuiteApp).
For vendor bills, those that have been paid (through any of the payment transactions) and partially paid are included in the DIOT file.
Partial payments are not supported for expense reports and vendor credit.
Required Fields for Mexico DIOT Reporting
For DIOT reporting, you must complete the following fields on entity and transaction records for companies or subsidiaries in Mexico:
-
Tax Registration Country field on the vendor record
In the DIOT file, vendors must be classified as national vendor, foreign vendor, or global vendor. Be sure to provide a value in the Country field of the vendor billing address.
-
Mexico RFC field on the employee, vendor, lead, prospect, customer, contact, and partner record
If there is no value in the RFC code field on the vendor record, the DIOT report also shows an empty RFC field for the entity.
-
Operation Type field
Vendor bill, expense report, and vendor credit must have an indication of their operation type, which could be Professional Services, Real Estate Leasing, or Others. If you do not enter a value, the DIOT report uses Others as the default operation type for the transaction.
Note:The Operation Type field is also available in Purchase Orders to let you capture this information before converting the PO into a Vendor Bill.
-
Vendor field
In the DIOT file, all lines on expense reports must indicate the name of the vendor or supplier.
For information about custom fields and validations for Mexico, see Mexico Localization Features.
Generating the Mexico DIOT File
To generate a Mexico DIOT file:
-
Go to Reports > Tax > Country Tax Reports.
-
Select DIOT from the Report list.
-
Select the Mexico parent company or a Mexico subsidiary company.
-
Select an accounting period.
-
Click Generate.
The system queues the process for generation, and then notifies you by email when the audit file has been generated. The email notification includes a link to the downloadable file. While the country tax report is being generated, you can see its progress in the Download column of the Country Tax Reports table. Click Refresh to update the Download column. When file generation is complete, the Download status displays a link to the downloadable file.
-
To generate a new report, click Reset and repeat steps 2 to 5.
-
When a Mexico DIOT file has been successfully generated, you can download it for submission to the SAT.