This article explains how to set up and generate the general ledger XML files version 1.1 that all companies in Mexico are required to report to the Mexican tax authorities (SAT) on a monthly basis.
All companies in Mexico are required to report ledger accounting statements to the Mexican tax authorities (Servicio de Administración Tributaria [SAT]) every month. Annex 24 of Miscellaneous Tax Resolution for 2015 requires that you submit general ledger XML files version 1.1. You can generate the following XML files per company:
- Chart of account
- Monthly Trial Balance
- Journal transactions, together with the related subledger transactions (Comprobante Fiscal Digital a través de Internet [CFDI], Comprobante Fiscal Digital [CFD], and other operations)
- Auxiliary ledger account
This functionality is available only when the country/region of the company is defined as MEX.
The government also requires an additional auxiliary XML file (folios) that details all fiscal documents (CFDI, CFD, and others). This file isn't included in the current feature, because this information is included in the Journal transactions XML file, as specified in Chapter 2.8, section 220.127.116.11 of the Miscellaneous Tax Resolution for 2015 (Second section) of December 30, 2014. For more information, see http://www.sat.gob.mx/fichas_tematicas/buzon_tributario/Documents/extracto_reglas.pdf.
The following process lists the prerequisites that must be in place before you start to generate the XML files that SAT requires. Parameters determine how the data will be exposed in the XML files, and all of them are required. Missing parameters can cause inconsistencies or incorrect validations in the government validation tool.
- Set up main account parameters.
- Set up a Parent_Account to identify the level of account.
- Set up total accounts in all levels.
- Set up SAT account group.
- Create consolidation account group for SAT.
- Assign main account to SAT group and level accounts.
- Set up Method of payments and Bank accounts.
- Assign SAT method of payments.
- Assign SAT bank code in routing number field.
Chart of accounts
Per government requirements, the Chart of account XML file must include specific information that you must configure in advance to prevent inconsistencies when the XML file is generated and validated. Set the following parameters to configure this information:
- Parent main account: The <SubCtaDe> tag in the XML file is used to specify the account of the previous level. In this case, we use a Parent account country/region field in the configuration of the chart of accounts.
- Account level: The <Nivel> tag in the XML file is used to specify the level of the government account group. We localized the functionality of the Consolidation account group field under Additional consolidation accounts to specify the level of the government account group.
- Debit and Credit indicator: The <Natur> tag in the XML file is used to specify the debit and credit indicator of the main account. The following rules have been defined:
- Main Account type = Cost, Asset
- Main Account type: If Profit & Loss and DB/CR proposal = Debit
- Main Account type: If Balance and DB/CR proposal = Debit
- Main Account type: If Profit & Loss and DB/CR proposal = Blank
- Main Account type: If Balance and DB/CR proposal = Blank
- Account type : Revenue, Liability
- Account type AX: If Profit & Loss and DB/CR proposal = Credit
- Account type AX: If Balance and DB/CR proposal = Credit
- Totals amount in all levels: Configure the Totals value in the chart of accounts to enable generation of a Monthly Trial Balance XML file that includes the related totals amounts in all levels of the hierarchy.
SAT account group
The Chart of account XML file includes a <CodAgrup> tag that is used to specify the related government account group for the reported account. The government has published a table on the government portal. To meet this requirement, you must use the Consolidation account groups functionality, which lets you configure the mapping between your company chart of account and the government account group. Then, when you generate the report, you will be asked to indicate which consolidated account group is used to specify the government grouping.
In specific situations, the government might request that you deliver a Journal transaction XML file that details all accounting transactions and the document that originated them. When these transactions are related to vendors payments, you must specify the type of payment in the <OtrMetododePago> node and the <MetPagPol> attribute by using a specific table that is published by the government. Click Accounts payable > Payment setup > Methods of payment, and assign the SAT payment method to the company's method of payment.
The Journal transaction XML file must include all bank transfer transactions that are posted to the general ledger where some additional information is required in a specific node <Transferencias> and their attributes <BancoOriNal> and <BancoDestNal> is required to inform the government bank code. Click Cash and bank management > Bank accounts, and use the Routing number field to set up this information.
The Journal transaction XML file also requires that you identify the invoice number when an invoice is issued and received. Per Mexican legislation, this invoice number can be represented in various ways, depending on how the invoice was delivered:
- Regular invoice (non-electronic). You must include the Series and Invoice number.
- CFD: You must include the UUID of an electronic invoice CFD.
- CFDI: You must include the UUID of an electronic invoice CFD.
Users can now include this information in transactions that are generated from the following areas:
- Purchase invoice
- Vendor invoice (non–purchase order)
- Invoice register
- Invoice journal
- Invoice approval
- Invoice pool
This feature is based on Electronic reporting configuration (ER), where each XML file format is defined by using the model and format designer for electronic reporting. Use the AX resources repository configuration type to import these configurations into the current company and enable the generation of XML files. Click Organization administration > Workspaces > Electronic reporting > Repositories.
You must upload the following repository models and formats:
- Electronic ledger accounting model MX
- Auxiliary Ledger XML MX (format)
- Chart of Account XML MX (format)
- Journal XML MX (format)
- Trial Balance XML MX (format)
After the repository is available in your environment, you must identify these formats in the general ledger parameters. Click General ledger > Ledger setup > General ledger parameters, and then, in the Electronic reporting mapping field group, select the format to use to generate the XML files.
Generate electronic ledger accounting files
Click General ledger > Inquire and reports > Ledger reports > Electronic ledger accounting statement to generate the required XML files and download them to your environment. The following table describes the parameters that you must set.
|SAT consolidation account group||Select the consolidation account group that you previously configured to identify the SAT account group.|
|Period||Select the period for the report. The selected date will include all general ledger transactions for the selected month.|
|Closing transactions||This slider indicates if the closing transactions should be included as transactions in the Monthly Trial Balance XML file. Switch this slider to No to exclude closing transactions from the Monthly Trial balance XML file.|
|Trial Balance||Select this check box to generate the Chart of account and Monthly Trial Balance XML files for the specified period.|
|Delivery type||Specify the type of delivery:
|Update date||Specify the updated date of a complementary delivery.|
|Ledger entries||This slider indicates if the Journal transaction XML file is generated for the specified period.|
|Auxiliary ledger||This slider indicates if the Auxiliary ledger XML file is generated for the specified period.|
|Request type||Select this option to identify the type of request when the Ledger entries or Auxiliary ledger slider is set to Yes.|
|Order number||Enter the order number that was assigned by the government tax authority, if the request type is Control or Compulsive control.|
|Process Number||Enter the process number that was assigned by the government tax authority, if the request type is Return or Compensation.|