Mexico eAccounting Reporting in ACR: The Chart of Accounts Report

¿Quiere leer este post en español?

The government of Mexico, by the means of Servicio de Administración Tributaria (SAT), requires that companies submit a set of reports to meet the legal requirements of Electronic Accounting (or eAccounting, as the legal requirement is commonly called).

To report eAccounting with Advanced Compliance Reporting (ACR), you can use the following set of reports:

• Chart of Accounts (MX_CHTACCTS_DCL)
• Account Balance (MX_ACCT_BAL_REP)
• Auxiliary Report of Accounts (MX_ACCT_AUX)
• Journal Entries Details (MX_JE_DETAILS)
• Auxiliary Report of Folios (MX_FOLIOS_AUX)

In this post we’ll go through the Chart of Accounts report, which is the first report you should run in order to report eAccounting for Mexico.

The Chart of Accounts report is generally submitted once when you start to declare eAccounting information, and then sent again whenever any G/L account is added, modified or deleted from the chart of accounts. In some cases, the Chart of Accounts report might be also requested by SAT on demand.

The Chart of Accounts Report: What is this report?

When you run the Chart of Accounts report in the Run Compliance Reports app, you generate an XML file that contains a list of general ledger accounts (G/L accounts), as defined in a Financial Statement Version (FSV) that you create specifically for eAccounting.

That is, the chart of accounts is a list of the G/L accounts you have to report to SAT, under the predefined account groups catalog. The XML output file of the Chart of Accounts report contains the following details of G/L accounts:

• Account group
• Nature of the account
• Level of the account
• Account description
• Account number

The header of the XML file shows details about the fiscal year, month, tax number of the company code for which you are generating the chart of accounts, and the version of the legal XML file.

How to configure the Chart of Accounts Report

Before running the Chart of Accounts report, you need to go through some settings.

If you are running with SAP S/4HANA, you need to:

• • Create a new FSV in your system that is specific for eAccounting according to SAT’s accounts catalog.
  • Assign G/L accounts to a grouping code and nature.
  • Add the FSV you have created to the parameters of ACR reporting entity.

You find the step by step for these processes in the blog How to Prepare your Company’s Chart of Accounts for Electronic Accounting in Mexico, or in the SAP Help Portal, under Financial Statement Version for Electronic Accounting.

If you are running with SAP S/4HANA Cloud, you will receive the FSV and the G/L accounts pre-configured for eAccounting. If you need to do modifications, you can refer to:

• • For adjustments in the FSV: Use the self-service configuration app Maintain Financial Statement Versions, which you find in the SAP Fiori Launchpad under Master Data.
• • For adjustments in G/L accounts: Use the self-service configuration app Manage Chart of Accounts, which you find in the SAP Fiori Launchpad under Master Data.

Done! Now you’re ready to run the Chart of Accounts report. See below an example of a report run:

For everyone to see: The pictures are screenshots of the steps that are described.

1 – In the SAP Fiori Launchpad, choose the Run Compliance Reports app.

2 – Filter for the MX_CHTACCTS_DCL report, and choose the row that you want to run.

3 – Choose New Run.

4 – Fill in the parameters and choose Run.

6 – Select the generated file, and choose Download.

Example of an XML output file of the Chart of Accounts report.

We hope this post is useful for you. Now you know how you can prepare a company’s chart of accounts for eAccounting reporting in Mexico.

Did this post help you? Leave your like and share the content with your colleagues.

Do you have questions about eAccounting for Mexico in ACR? Check our SAP FAQ Note for eAccounting.

You can find the full documentation for eAccounting in ACR in the SAP Help Portal:

SAP S/4HANA Cloud: help.sap.com/viewer/s4h_ce_mexico

SAP S/4HANA: help.sap.com/viewer/s4h_op_mexico

See you the next time and stay compliant,

Rosana

#ACR #SAPGoGlobal #SAPLocalization