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 |