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