Product Information
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.
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
Rosana,
Thanks for updates.
Best Regards,
Roberta Fernandes
Hi Roberta Fernandes,
Thanks for your comment, we appreciate having feedback!
We will keep posting about other eAccounting reports, so stay tuned for more info. 🙂
Best,
Rosana
Very useful.
Can you please share the Details for VAT, WHT , DIOT reports and configuration details for ACR
My email id vinayraoabap@gmail.com
Hi Vinay Guduri,
You can find all these details in the Help Portal documentation for Mexico, which is available at:
If you have further questions, please don't hesitate to contact us.
Best regards,
Rosana
Hi,Rosana
Thanks for your share.
And when I run Mexico Chart of Accounts Reporting, it display 'Generation Failed'
Could you please help me what the problem is.
Best Regards
Hi Biao,
I recommend you take a look at our FAQ Note for this report.
https://launchpad.support.sap.com/#/notes/2812643
You must follow the correct order of SAP Notes implementation described in this FAQ Note.
Please check the questions in this FAQ Note to help you with the implementation.
Also, check out our Help Portal for further details and configuration regarding this report.
https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/835ce9e19dfb46b5b4e3b48d76eb00a7/939f14863de84f949fb21baf892b2f50.html?version=2021.002&q=Mexico
If the issue continues, please contact SAP through our official communication channels.
https://support.sap.com/en/my-support/product-support.html?anchorId=section_249481993
Kind Regards,
Andrew Caus
Dear Rosana
If i have more than one company code and we need to use more than one financial statement is possible to make? Or there are some way to filter accounts that is not necessary to send?
Dear ROsana
How you use more than one financial statement?
Best Regards
Leonardo