Trial balance
A typical input file for the trial balance 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 |
| Year | This is the reporting year |
| Period | This is the reporting period (1 to 12) |
| Account | Level 1 account |
| SubAccount | Level 2 account or blank if the record is a journal for a level 1 account |
| BegBal | This is the opening balance for the period |
| DbAmt | Total debits for the period |
| CRAmt | Total credits for the period |
| EndBal | This is the closing balance for the period |
| JeSequence | This is the journal sequence |
| Currency | Specify MXN |
These are the mappings required:
| Field | Mapped to | Rules |
|---|---|---|
| Fiscal Year | Year | |
| Fiscal Period | Period | |
| GLNominalAccount | Concatenate “Account”-”SubAccount” | |
| OpeningNetBalanceBaseAmount | BegBal | |
| DebitMovementBaseAmount | DbAmt | |
| CreditMovementBaseAmount | CrAmt | |
| ClosingNetBalanceBaseAmount | EndBal |