Reporting eAccounting in Mexico with ACR: The Auxiliary Report for Accounts
¿Quiere leer este post en español?
Electronic accounting (or eAccounting) consists of sending XML files containing transactions registered in electronic media that are carried out by a company or a person and sent through SAT portal.
eAccounting process consists of:
- The preparation of the chart of accounts.
- The monthly delivery of the account balance.
- If required, the sending of folios and auxiliary information.
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 for 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 Auxiliary Report for Accounts, which is a report you run when SAT requires auxiliary information to report eAccounting.
What the report is about
The Auxiliary Report for Accounts is all about details of general ledger accounts and posted journal entries for a specific monthly period.
Companies inform this report when the government demands it or when these companies need to request a tax refund from SAT.
The XML output file of the Auxiliary Report for Accounts contains details of:
- The Initial balance of the G/L accounts
- The end balance of G/L accounts
- Debit and credit amounts posted in the relevant journal entries
The header of the XML file contains details about the type of requirement, fiscal year, month, tax number of the company code, and the version of the legal XML file.
How to configure the report
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 ACR reporting entity parameters.
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 G/L accounts preconfigured for eAccounting, but if you need to do modifications you can refer to:
- For adjustments in the FSV: Self-service configuration app Maintain Financial Statement Versions, under Master Data for General Ledger.
- For adjustments in G/L accounts: Self-service configuration app Manage G/L Account Master Data, under Master Data for General Ledger.
You can find the details of the preconfigured content for the Auxiliary Report for Accounts in SAP S/4HANA Cloud, refer to Advanced Compliance Reporting (1J2).
How to run the report
Find below an example of report run:
For visually impaired readers: 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_ACCT_AUX report and choose the run you want to execute.
3 – Choose New Run.
4 – Fill in the parameters and choose Run. Keep in mind that the Order Number or Process Number must be filled depending on the Type of Requirement selected.
5 – Select the generated file, and choose Download.
Example of XML output file of the Auxiliary Report for Accounts.
How to validate the XML output file
Before you send the XML file to SAT, you need to validate the file structure and the figures contained in it.
The file structure validation can be done in SAT website. In this validation, SAT will check the technical details of the XML file and let you know if it would be accepted for a formal submission.
Besides this technical validation, you can do a functional validation to check if all the figures contained in the file are correct. You can do this validation in the following ways:
If you are running with SAP S/4HANA, you can go to FAGLL03 transaction (Display/Change Items).
For visually impaired readers: The picture shows a screenshot of FAGLL03 transaction.
In this transaction, you can find the detailed balance for a given company code. This way, you can check if the amounts are correctly posted.
If you are running with SAP S/4HANA Cloud, you can go to the Display Line Items in General Ledger app in the SAP Fiori Launchpad. There you can check balances at line item level with all the details.
For visually impaired readers: The picture shows a screenshot of the Display Line Items in General Ledger app in the SAP Fiori Launchpad.
And that’s basically it about this eAccounting report! Now you know what the Auxiliary Report for Accounts is about, how to configure and run the report, and also how to validate the output XML file before sending it to SAT.
For more information about the Auxiliary Report for Accounts, visit the report documentation 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
Do you have questions about eAccounting for Mexico in ACR? Check our SAP FAQ Note for eAccounting.
See you next time,
#ACR #SAPGoGlobal #SAPLocalization
This post was translated from English into Spanish using the SAP Translation Portal. Check it out!
Thanks for this detailed blog. When I tried to execute the report MX_JE_DETAILS from Fiori, I can not see any "New Run" button at the top. Am I missing any authorization to execute "New Run"?
Hi Sugato Biswas,
Thanks for your comment. I would recommend you to open an incident for the relevant component in SAP Support Portal, but it came to my knowledge that you already have one case opened to solve the issue with SAP. I talked to the team and they're doing their best to help you have this case solved as soon as possible. If you have further issues, don't hesitate to contact us again.
Thank you for the blog. It's very informative and helpful.
Could you please advise regarding - Auxiliary Report of Folios (MX_FOLIOS_AUX) - Does it require additional license for ACR? I mean, this report is not included into basic ACR scope?
Thank you in advance.
Yes, the Auxiliary Report of Folios (MX_FOLIOS_AUX) requires a specific license for its execution. I suggest that you contact your account executive for more details.