Import Matrix: Journal Entries
Technical Documentation
Example CSV file/table
The first row is referred to as a header row, each row after is one line per account. Some data, such as Journal Number and Posting Date will repeat for each row that is to be within one Journal Entry record.
Journal Number, Posting Date, Account Number, Credit, Debit,
JE-12345, 01/01/2015, 5200, 100, 0,
JE-12345, 01/01/2015, 6200, 0, 100,
Available Fields
Account Number
Auto Reversing Entry
Class ID
Client ID
Credit
Currency
Debit
Department
Description
Exchange Rate
Exchange Rate (Line)
Exclude From Accrual Basis
Exclude From Cash Basis
GL Company
Intercompany DT/DF Source
Journal Number
Memo
Office
Posting Date
Project
Target GL Company
Matrix
|
Field Name |
Key Field |
Required |
Valid Values |
Table Validation |
Table |
Field Validation |
Comments |
|
Exclude From Accrual Basis |
|
|
Yes No |
|
|
|
|
|
Auto Reversing Entry |
|
|
Yes No |
|
|
|
|
|
Class ID |
|
Yes, see comments |
|
Yes |
Classes |
Class ID |
Only required if “Require Class ID” is selected in GL Tracking Options |
|
Client ID |
|
|
|
Yes |
Companies |
Client ID |
|
|
Credit |
|
|
Numeric |
|
|
|
|
|
Debit |
|
|
Numeric |
|
|
|
|
|
Department |
|
Yes, see comments |
|
Yes |
Departments |
Name |
Only required if “Require Departments” is selected in GL Tracking Options |
|
Description |
|
|
|
|
|
|
|
|
Account Number |
|
|
|
Yes |
GL Accounts |
Account Number |
|
|
Exclude From Cash Basis |
|
|
Yes No |
|
|
|
|
|
GL Company |
|
Yes |
|
|
|
|
|
|
Journal Number |
|
Yes |
|
|
|
|
|
|
Intercompany DT/DF Source |
|
Yes, see comments |
|
Yes |
GL Company Mapping |
Source |
This is only required it rows exist in GL Company Mapping |
|
Memo |
|
|
|
|
|
|
|
|
Office |
|
Yes, see comments |
|
Yes |
Offices |
Office ID |
Only required if “Require Offices” is selected in GL Tracking Options |
|
Posting Date |
|
|
Valid Date Format |
|
|
|
|
|
Project |
|
|
|
Yes |
Projects |
Project Number |
|