Journals

A typical input file for journals would have this 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
Journal Type For example: 1 - AccountsReceivable, 2 - AccountsPayable, 3 - Other
GltSystem Originating module: AP, AR, CA, GL, OE, PO, RJ
GlcDescription Total credits for the period
Description This is the closing balance for the period
CurrencyCode This is the currency of the payment.
Note: All export currencies must be in USD.
CurrencyConversionRate If applicable
CreditAmount
DebitAmount
InvoiceType
InvoicePrefix
InvoiceNumber
Reference
TaxIDc This is the RFC of the customer or vendor
Search Name This is the name associated with the RFC above
TransactionDate Date of the journal
Journal Sequence Journal line number
The journal file you submit is made up of these journal types:
  • Accounts receivable journals for sales made
  • Accounts payable journals for monies incoming through purchases
  • Expenses
  • Payroll
  • Reimbursements

To set up the mappings, you must specify the mappings for Journal and Journal Entries. These would pertain to every journal on the journal file. In addition, invoice mappings should be set up for accounts receivable and accounts payable journals, and payment mappings for payments.

Invoice mappings

These are the mappings required:
Field Mapped to Rules
Journal ID Control Group
Line Number Journal Sequence
InvoiceID Invoice
InvoicePrefix Prefix
EntityName Search Name
TaxID Tax ID
VoucherType Invoice Type
InvoiceType Invoice Type
Transaction Amount
CheckDate Check Date
ExchangeRate Currency Conversion Rate
CurrencyCode Currency code

JournalEntry mappings

These are the mappings required:
Field Mapped to Rules
JournalID Control Group
AccountingYear Year
AccountingDate Date
AccountingPeriod Period
SourceDocumentID Prefix-Invoice

JournalEntryLine mappings

These are the mappings required:
Field Mapped to Rules
JournalID Control Group
AccountingYear Year
AccountingDate Date
AccountingPeriod Period
GLNominalAccount Account=Subaccount
SourceDocumentID Prefix-Invoice
ExchangeRate Currency Conversion Rate
CurrencyCode Currency
BaseDebitAmount Debit Amount
BaseAmount
BaseCreditAmount Credit Amount
DebitAmount Debit Amount
Amount
CreditAmount Credit Amount
ReportDebitAmount
ReportAmount
ReportCreditAmount
Description Description

Payment mappings

These are the mappings required:
Field Mapped to Rules
JournalID
LineNumber
CheckNumber
CheckAmount
AccountNumber
BeneficiaryName
BeneficiaryTaxID
CurrencyCode
TransactionDescription
DestinationBankAccountNumber
DestinationForeignBankName