Skip to Content
Product Information
Author's profile photo Rosana Ernzen

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,

Rosana

#ACR #SAPGoGlobal #SAPLocalization

 

This post was translated from English into Spanish using the SAP Translation Portal. Check it out!

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sugato Biswas
      Sugato Biswas

      Hi Rosana,

      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"?

      Regards,

      Sugato

      Author's profile photo Rosana Ernzen
      Rosana Ernzen
      Blog Post Author

      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.

      Best regards,

      Rosana

       

      Author's profile photo Uliana Amosova
      Uliana Amosova

      Hi Rosana,

      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.

      Best regards,

      Uliana

      Author's profile photo Ariel Dias
      Ariel Dias

      Hi Uliana,

      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.

      Best,

      Ariel

      Author's profile photo Daniel Cloos
      Daniel Cloos

      Hi, what is the order number about? Is it a number specific to the company/legal entity like a tax number/RFC Number?

      Many thanks!

      Daniel

      Author's profile photo Andrew Caus
      Andrew Caus

      Hello Daniel Cloos,

      Order Number is the number of the fiscal requirement from which the file is generated.

      You can check that information and many others in our Help Portal page

      Kind Regards,
      Andrew Caus

      Author's profile photo Daniel Cloos
      Daniel Cloos

      Hi Andrew,

      many thanks for your response! I know the SAP Help Docu for these Reports. The description (Order Number: Number of the fiscal requirement from which the file is generated.) is not very specific for this parameter. Can you please specify and explain the parameter?

      Thanks!
      BR Daniel

      Author's profile photo leonardo francisco
      leonardo francisco

      Dear Rosana

      I´m working in a project that have two company code but they need to create eAccounting using two financial statement but in the customizing this is not done by company.

      Have some way to make this customizing?

      Best Regards

      Leonardo