1. Accounting
  2. Taxation
  3. Legacy Tax
  4. Mexico Tax Topics (Mexico Compliance SuiteApp)
  5. Mexico Electronic Accounting File (Mexico Compliance SuiteApp)
  6. Setting Up Mexico Electronic Accounting File (Mexico Compliance SuiteApp)
  7. Field Mapping for Mexico (Mexico Compliance SuiteApp)

Field Mapping for Mexico (Mexico Compliance SuiteApp)

Important:

If you are using the Mexico Localization SuiteApp, see Mexico Localization Field Mapping.

The Mexico Tax Administration Service (SAT) requires fields with specific values to be included in the Mexico Electronic Accounting File.

The Audit Files Field Mapping feature enables you to map standard NetSuite fields to categories required by tax authorities. The mapped values will be included in the generated tax audit files after they are saved in the system.

This feature is included in the Tax Audit Files SuiteApp, and can be used in accounts with a Mexico nexus or subsidiary.

Read the following topics for more information:

Mapping Account Group Codes for Mexico Chart of Accounts

The Mexico Chart of Accounts audit file must include the account group codes defined by SAT.

You can map the accounts assigned to your Mexico subsidiary to SAT-defined group codes using CSV import.

Note:

Accounts without an assigned SAT group code will not be included in the Mexico Electronic Accounting File.

To map group codes for Mexico accounts using CSV import:

  1. For the list of valid SAT group code values, download the CSV template for Mexico SAT Account Grouping from the NetSuite File Cabinet. You can also use the template as a reference when you format the CSV file for import.

    1. Go to Documents > File > File Cabinet.

    2. On the file cabinet, go to SuiteBundles > Bundle 47492 > Tax Audit Files CSV Templates.

    3. Click MX Account Group Codes template.csv to download the file.

    4. Save the template on your computer.

  2. Create a saved search of the subsidiary’s accounts. You can export the results to a CSV file, which you can edit and use for Mexico Account Group Code CSV import.

    1. Go to Lists > Search > Saved Searches > New.

    2. Click Account.

    3. On the Criteria subtab, set the filter for subsidiary and select your Mexico subsidiary.

    4. On the Results subtab, set the results to only include the Internal ID and Name columns.

    5. Click Preview.

    6. On the results page, click the icon for Export - CSV.

    7. Save the CSV file with account search results.

  3. Open the CSV file of the account search from Step 2. For automatic field mapping during CSV import, edit the file so that the column headers match the columns in the CSV template (from Step 1).

    1. Add two columns for Mapping Category and Mapping Value.

    2. Replace the column header for Internal ID with Mapping Key.

    Example of a CSV file with Mapping Category, Mapping Value, and Mapping Key columns

  4. Using the same CSV file above, specify values for the Mapping Category and Mapping Value cells for each account.

    • Mapping Category – Enter MX SAT: Account Grouping.

    • Mapping Value – Enter the group code value. To make sure that you are entering the correct values, copy the SAT group code values listed in the template that you downloaded in Step 1, and paste the exact value in the Mapping Value column of the CSV file.

      Example of copying the SAT group code value from the downloaded template to the Mapping Value column of the CSV file

      1

      The SAT group codes are listed in the template that you downloaded in Step 1. Look for the appropriate group code in the Mapping Value column of the template and copy the value.

      2

      In the CSV file with account internal IDs, paste the exact value copied from the template in the appropriate cell in the Mapping Value column.

  5. Save the CSV file with accounts and group code information.

  6. Import the saved CSV file to NetSuite. Go to Setup > Import/Export > Import CSV Records. Select the following options for CSV import:

    • Import Type = Custom Records

    • Record Type = TAF Mapping

    • Character Encoding = Western (Windows 1252)

    For more information on importing CSV files, see Importing CSV Files with the Import Assistant.

  7. Verify if the record submitted using CSV import is mapped correctly.

    1. Go to Setup > Tax Audit Files > Audit Files Field Mapping.

    2. Select MX SAT: Account Grouping in the Category field.

    3. In the Subsidiary field, select your Mexico subsidiary.

    4. In the Account Type field, select an account type. Verify the accounts under each account type.

Mapping Bank Accounts and Payment Methods for Mexico Journal Entries

The Mexico Journal audit file must include SAT-defined values for bank accounts and payment methods. You can map these NetSuite standard fields to categories required by SAT on the Audit Files Field Mapping page.

To map standard NetSuite fields to required categories for Mexico Journal:

  1. Go to Setup > Tax Audit Files > Audit Files Field Mapping.

  2. In the Category field, select which fields to map.

    The following field mapping options are available for Mexico Journal:

    • MX SAT: Bank – Maps bank accounts, including those added to vendor and employee records, to SAT-defined bank categories.

    • MX SAT: Payment Method – Maps payment methods to SAT-defined categories.

  3. For MX SAT: Bank, select a subsidiary in the Subsidiary field.

  4. Map the fields by specifying a value on the right column.

  5. Click Save.

Related Topics

Tax Audit Files
Mexico Tax Topics (Mexico Compliance SuiteApp)
Mexico Electronic Accounting File (Mexico Compliance SuiteApp)
Setting Up Mexico Tax Audit Files Configuration (Mexico Compliance SuiteApp)
Developing a Mexico UUID Plug-in Implementation

General Notices