Importing Chart of Accounts
Chart of Account Codes should always be imported first. The following table defines the field references to be used in the Chart of Accounts section of the MasterGL.DEF file:
Note: Segments (such as Fund, or GL) have to be set up in the system prior to Import. Segments were set up when the organization was created. To view the segment information defined for an organization, with Administrative user rights see the Organization>Organization Information - Segments Tab.
| Table: tblAccountCode_N | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,COACODE,HEADER,HCOA | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
COA_SEGID |
Y |
User Defined |
Segment Name |
|
|
COA_CODE |
Y |
User Defined |
Account Code |
|
|
COA_STATUS |
Y |
2 |
A |
A (Active), I (Inactive), or D (Discontinued) |
|
COA_TITLE |
Y |
User Defined |
Account Title |
|
|
COA_SHORT_TITLE |
N |
15 |
Account Short Title |
|
|
COA_TYPE |
Y |
3 |
Required for GL. Account Types: CSH, AR, ARO, PLO, IFR, FAO, OA, AP, APO, IFP, OL, NAE, REV, EXP, or IFT |
|
|
COA_DESIGNATION |
Y |
3 |
Required for general ledger segments and segments with a Function of Restriction or Program. See Maintain>Chart of Accounts Codes for a list of designation codes. |
|
|
COA_990LN |
Y |
25 |
The Form 990 Line Number reflects the line number that correlates to the 990 form version (Form 990EZ or Form 990) selected by the Administrator using the Organization>Organization Information form. If Form 990 is selected, a line number is required for general ledger segments and segments with a Function of Restriction or Program (Organization>Organization Information - Segments Tab). If the Form 990EZ is selected, a line number is only required for general ledger segments. See IRS Form 990 Line Number or Column Letter for a list of Form 990 Line Numbers. |
|
|
COA_CHK_NUM |
N |
15 |
Last Used Check Number only available for General Ledger cash-type accounts. |
|
|
COA_CURRENCY |
Y* |
3 |
Active or inactive Currency code. Required for CSH-type General Ledger accounts. |
|
|
COA_GA_STAGE |
N |
2 |
Required. Stages: Pre-award (PR), Post-award (PO), or Close-out (CL). |
|
|
COA_GA_ACCTNUM |
N |
50 |
Account Number |
|
|
COA_GA_PROJDIR |
N |
80 |
Project Director |
|
|
COA_GA_AWDTYPE |
N |
50 |
Award Type |
|
|
COA_GA_AWDNOTFDATE |
N |
Date |
Award Notification Date. Can be 6, 8, or 10 digit date. |
|
|
COA_GA_GRNTPRDFROM |
N |
Date |
Grant Period From. Can be 6, 8, or 10 digit date. |
|
|
COA_GA_GRNTPRDTO |
N |
Date |
Grant Period Through. Can be 6, 8, or 10 digit date. |
|
|
COA_GA_EXTDATE |
N |
Date |
Extended Date. Can be 6, 8, or 10 digit date. |
|
|
COA_GA_PROJAMT |
N |
Currency |
0.00 |
Projected Award Amount |
|
COA_GA_PMTMTHD |
N |
1 |
A (Advanced Payment) or R (Reimbursement) |
|
|
COA_GA_CSP |
N |
Single |
0.0000 |
Cost Sharing Percentage |
|
COA_GA_ICR |
N |
Single |
0.0000 |
Indirect Cost Rate |
|
COA_GA_NRD |
N |
Date |
Next Reporting Date. Can be 6, 8, or 10 digit date. |
|
|
COA_GA_LRD |
N |
Date |
Last Reporting Date. Can be 6, 8, or 10 digit date. |
|
|
COA_GA_IAR |
N |
1 |
Independent Audit Required? 0 = No; 1 = Yes |
|
|
COA_GA_GRNTSPNSR |
N |
80 |
Grant Sponsor |
|
|
COA_GA_GRNTID |
N |
50 |
Grant ID |
|
|
COA_GA_GRNTOFFICIAL |
N |
80 |
Grant Official |
|
|
COA_GA_POSITION |
N |
40 |
Grant Official Job Position |
|
|
COA_GA_VOICE |
N |
25 |
Grantor Phone |
|
|
COA_GA_FAX |
N |
25 |
Grantor Fax |
|
|
COA_GA_ADDR |
N |
80 |
Grantor Address. Use "^" to separate address lines. |
|
|
COA_GA_CITY |
N |
30 |
Grantor City |
|
|
COA_GA_STATE |
N |
6 |
Grantor State or Province |
|
|
COA_GA_ZIP |
N |
10 |
Grantor Postal Code |
|
|
COA_GA_COUNTRY |
N |
35 |
Grantor Country |
|
|
COA_GA_EMAIL |
N |
255 |
Email Address |
|
|
COA_GA_PGMOFFICIAL |
N |
80 |
Program Official |
|
|
COA_GA_CUSTID |
N |
User Defined |
Customer ID |
|