Appendix > Format Requirements for the Import/Export Feature > General Ledger File Format Requirements for Importing Data
General Ledger File Format Requirements for Importing Data
Before you begin to import data, you need to make sure the text file is in the proper format and that all required fields have entries. If the external file is properly formatted, it will help eliminate the possibility of errors.
Accounting Product
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Length
Column Position (Fixed-Length Format)
Data Type
1
* Account Number
50
1
Character
2
Description
50
51
Character
3
Classification
3
101
Character
4
Annual Budgets
1
104
Numeric
6
Inactive Account
1
105
Char-Caps
7
GL Memo/Notes
35
106
Character
8
Reporting Group 1
6
141
Char-Caps
9
Reporting Group 2
6
147
Char-Caps
10
Reporting Group 3
10
153
Char-Caps
11
Date Created
10
163
Date
12
Balance Forward Record2
 
18
173
Numeric

1 This number is for reference purposes only and will not appear in the actual text file.

2 This field is used only if import or export data includes balance forwards.

Fund Product
Required fields are noted with an asterisk (*).
Field Order
Field Description
Maximum Length
Column Position
(Fixed-Length Format)
Data Type
1
* Account Number
50
1
Character
2
Description
50
51
Character
3
Classification
3
101
Character
4
Annual Budgets
1
104
Numeric
5
Restriction Type
1
105
Character
6
Inactive Account
1
106
Char-Caps
7
GL Memo/Notes
35
107
Character
9
Reporting Group 1
6
142
Char-Caps
10
Reporting Group 2
6
148
Char-Caps
11
Reporting Group 3
10
154
Char-Caps
12
Date Created
10
164
Date
13
Balance Forward Record 1
 
18
174
Numeric 14.4

1 This field is used only if import or export data includes balance forwards.

 
 
 
 
 
Published date: 10/23/2019