Chart of accounts
A typical input file for the chart of accounts would have these information:
| Data | Notes |
|---|---|
| Company | This is the accounting entity |
| Tax ID | This is the RFC reference of the registered company reporting to SAT |
| ChartName | Specify Master |
| Account | Level 1 account |
| SubAccount | Level 2 account or blank if the record is a journal for a level 1 account |
| ChartSection | For example: 1 - Balance Sheet, 2 - Profit and Loss |
| Account Description | This should be in Spanish where possible |
| DebitCreditFlag | For example: 1 - Credit, 2 - Debit Note: This value can be specified through the
Chart of Accounts maintenance form if it is not available in your
ERP.
|
| CFDIType | For example: 1 - Customer, 2 - Vendor, 3 - Payments, 4 - Payroll, 5 - Reimbursement |
| SATAccountGroup | These are predefined values. Note: This value can be specified through the Chart
of Accounts maintenance form if it is not available in your ERP.
|
| SATAccountLevel | For example: 1 - Account, 2 - SubAccount |
These are the mappings required:
| Field | Mapped to | Rules |
|---|---|---|
| GLNominalAccount | Concatenate “Account”-”SubAccount” | |
| Name | Account Description | |
| Description | Account Description | |
| AccountType | ChartSection | Translate these values: 1 - Credit, 2 - Debit |
| DebitCreditFlag | DebitCreditFlag | Translate these values: 1 - Credit, 2 - Debit |
| CFDIType | CFDIType | Translate these values: 1 - Customer, 2 - Vendor, 3 - Payments, 4 - Payroll, 5 -Reimbursement |
| SATAccountGroup | SATAccountGroup | |
| SATAccountLevel | Translate these values: 1 - Account (since GL Nominal Account has concatenated all levels to 1) | |
| AccountingChartAE | Company | |
| AccountingChartID | ChartName |