What is the format for importing transactions into General Ledger?

Each record in the import file is a separate entry that contains the necessary record format and fields required to produce a General Ledger Transaction. Commas separate the fields in each record. If a field is omitted from the import file, there must be a comma separator inserted for the omitted field. The system ignores spaces and tabs before or after commas. You may insert comments in the import file by preceding the comment with a semicolon or a pound sign. You must enter comments as separate lines.

The following table shows the import format for the transaction record type:

Import order	Item	Type	Length	Notes
1	Record ID	Alpha	3	Required, must be GLT.
2	Account	Alpha	25	Required. Accounts may be entered with or without punctuation (e.g., 12-456-100.10 or 1245610010 or 12456100.10).
3	Accounting Date	Date	10	Required.
4	Journal	Numeric	2
5	Reference 1	Alpha	10
6	Reference 2	Alpha	10
7	Transaction Description	Alpha	30
8	Debit	Numeric	11	Eleven digits plus the decimal point and sign may be entered (e.g., -9.2).
9	Credit	Numeric	11	Eleven digits plus the decimal point and sign may be entered (e.g., -9.2). Note: Normal credits should be a positive amount in the import file. A negative amount would be treated as a negative credit which equates to a debit.
10	Accrual or Cash	Option	1	Required if the Accounting Method is set to Both. 1 for Accrual method, 2 for Cash method. If the Accounting Method is not set to Both, this field may be left blank and the default value will be used.

Notes:

To import negative numbers successfully, the sign must immediately come before the number (e.g., -100.00).
For more information about importing transactions in General Ledger, refer to the article: How to import transactions in General Ledger
For information about importing budgets in General Ledger, refer to the article: What is the General Ledger Import Budget file format?

Import transactions example:

;This is a comment in a sample Import Transactions input file
;This next line provides an example of an import transactions record
GLT,20-1201,02132019,10,ref1,ref2,this is the description, 0,13.20,1
;The next line is purposely split into two physical lines, which is accomplished by adding a + to the end of line one
GLT,20-1001,2/13/2019,10, +
ref1,ref2,this is the description,13.20,0,1