Generating Mexico Electronic Accounting Files

With the Tax Audit Files SuiteApp (or the Tax Reporting Framework SuiteApp if SuiteTax is enabled in your account), you can generate the Mexico Electronic Accounting Files in XML file format.

Important:

Make sure that you have completed the prerequisite tasks before generating the Mexico tax audit files. For more information, see Mexico Electronic Accounting Files (Mexico Localization).

NetSuite provides the following Mexico tax audit files:

Mexico Chart of Accounts (XML) – Report that includes chart of accounts used in the period, with account group codes as defined by SAT.
Mexico Trial Balance (XML) – Report that includes the trial balance with beginning balances, movement for the period, and ending balances for each account.

Note:
The generated Mexico Trial Balance XML file only shows the balance for the selected account. Balances for sub-accounts are not consolidated into the generated XML report.
Mexico Complementary Trial Balance (XML) – Updated trial balance that includes opening balances, movements during the period, and final balances of each of the accounts corresponding to assets, liabilities, capital and reserves, and results (revenue, costs, expenses).

The generated XML report shows ‘C’ as the value for the ‘TipoEnvio’ tag. The tag ‘FechaModBai’ is also reflected, which refers to the date when the XML was generated.
Mexico Journal (XML) – Report that includes journal entries in the accounting records, with transaction details.
Mexico Auxiliary Report of Accounts (XML) – Report that includes chart of accounts used in the period for auxiliary accounts.

Important Things to Note:

Inactive accounts with balances are included in the generated Mexico tax audit files.
Active accounts with assigned SAT group codes but have a 0.00 balance are included in the Mexico Chart of Accounts, Mexico Auxiliary Report of Accounts, and Trial Balance.
Accounts without assigned SAT group codes are not included in the Mexico Chart of Accounts, Mexico Auxiliary Report of Accounts, and Trial Balance. For information about mapping SAT group codes, see Mapping Account Group Codes Through CSV.

For steps to generate a tax audit file, see:

Generating a Tax Audit File, if SuiteTax is not enabled.
Mexico Audit Files: Electronic Accounting Files, if SuiteTax is enabled.

Related Topics