Knowledge Base

Chart of Accounts Cross-Validation Rules (as of 7/16/2024)

KB06003962 1416 Views Updated 16-Jul-2024

Disclaimer:

The following values are not included in displayed Error Messages, but may be included in Validation Values criteria. Please note that conversion-only values will be disabled and removed from Cross-Validation Rules in September 2024.

 

13800 - Due from/(Due to) Funds (Account)

13860 - Due from/(Due to) Univ Entity (Account)

49000 - Net Assets (Account)

99998 - Account Conversion (Account)

999998 - Fund Conversion (Fund)

998 - Purpose Conversion (Purpose)

 

 

Name

Condition Values (for reference; not visible to transactional user)

 

Validation Values (for reference; not visible to transactional user)

 

 

Error Message (visible to transactional user)

Agency Funds

B90000 - Agency Funds

010 - Balance Sheet
530 - Other Institutional Activities
610 - Student Activities
650 - Scholarships and Fellowships
870 - Agency Activities
998 - Purpose Conversion
999 - Unspecified

If Fund is a child of B90000 (Agency Funds), then Purpose can only be equal to 010, 530, 610, 650, 870, or 999.

Agency Funds Inverse

870 - Agency Activities

B90000 - Agency Funds
999998 - Fund Conversion

Purpose 870 can only be used with Agency Funds between 900000 and 989999.

Auxiliary

C34500 - Auxiliary

010 - Balance Sheet
430 - Other Academic Activities 
540 - Depreciation
800 - Auxiliary Enterprises
999 - Unspecified

If Fund is a child of C34500 (Auxiliary Funds), then Purpose can only equal 010, 430, 540, 800, or 999.

Balance Sheet

A1000 - Total Assets
A2000 - Total Liabilities
A4900 - Net Assets

010 - Balance Sheet
998 - Purpose Conversion

Balance Sheet Accounts between 10000 and 49999 can only be used with Purpose value 010.

Balance Sheet Inverse

010 - Balance Sheet

A1000 - Total Assets
A2000 - Total Liabilities
A4900 - Net Assets

Balance Sheet Purpose 010 can only be used with Accounts between 10000 and 49999.

G&C Sponsored Projects

C31000 - Grants and Contracts - Sponsored Projects

010 - Balance Sheet
100 - Instruction - General
101 - Instruction - Precollegiate 
110 - Instruction - Sponsored
200 - Research - Sponsored Organized
206 - Research - Sponsored Training
210 - Clinical Trials - Federal
302 - Other Sponsored Activities-Gen
304 - Clinical Trials - Non Federal
420 - Library
431 - Museums
530 - Other Institutional Activities
535 - Argonne/Fermi Related Expenses
600 - Student Services
650 - Scholarships and Fellowships

860 - Argonne National Lab  
998 - Purpose Conversion
999 - Unspecified 

If Fund is a child of C31000, then Purpose must be equal to 010, 100, 101, 110, 200, 206, 210, 302, 304, 420, 431, 530, 535, 600, 650, 860, or 999.

G&C Sponsored Projects Inverse

110 - Instruction - Sponsored
200 - Research - Sponsored Organized
210 - Clinical Trials - Federal
302 - Other Sponsored Activities-Gen
860 - Argonne National Lab
   

C31000 - Grants and Contracts - Sponsored Projects
D27200 - Cost Share
999998 - Fund Conversion

Purpose values 110, 200, 210, 302, and 860 can only be used with Grants & Contracts -Sponsored Projects Funds between 310000 and 332014 and the Cost Share Fund value 272000.

Individually Designated

D27050 - Individual Discretionary

010 - Balance Sheet
100 - Instruction - General
109 - Academic Dept. Administration
120 - Instruction - Med/Clinical
124 - Instruction - GME Fellowships
130 - Research - Departmental
150 - Scholar - General
202 - Research - University Organized
300 - Public Service
420 - Library
430 - Other Academic Activities
600 - Student Services
650 - Scholarships and Fellowships
800 - Auxiliary Enterprises
850 - Physician Services - Non-RVU
998 - Purpose Conversion
999 - Unspecified

Individually Designated Funds between 270500 and 270599 can only be used with Purpose values 010, 100, 109, 120, 124, 130, 150, 202, 300, 420, 430, 600, 650, 800, 850, or 999.

Perm Restricted for A&LI

D55000 - PR - Annuity & Life Income

C1300 - Prepaid Exp & Other Assets ST
C1550 - Investments ST  
C1800 - Prepaid Exp & Other Assets LT
C1910 - Investments LT 
C2795 - Deferred Revenue LT
C5100 - Endowment Payout
C9000 - Investment Gains/Losses
E1145 - General Accounts Receivable
E2765 -  Non Current Liabilities - Other
E2825 - Deferred Revenue - Other LT
E9160 - Other Endowment Additions/Deductions
10990 - Claim on Cash -Conversion Only
13800 - Due from/(Due to) Funds
13860 - Due from/(Due to) Univ Entity
27800 - A&L Annuities Payable
49000 - Net Assets
50901 - Contribution Revenue
91101 - Actuarial Adjustments
91401 - Payments to A&L Beneficiary
95202 - Transfer - To/From Perm Restr
99998 - Account Conversion

The account combination you are attempting to use is invalid. Please review published Cross-Validation rules for Accounts that may be used when the Fund is a child of D55000.

Perm Restricted of True Endow

DP1000 - PR - True Endow

C1550 - Investments ST
C1910 - Investments LT
10990 - Claim on Cash -Conversion Only
13800 - Due from/(Due to) Funds
13860 - Due from/(Due to) Univ Entity
49000 - Net Assets
50901 - Contribution Revenue
95202 - Transfer - To/From Perm Restr
99998 - Account Conversion

If Fund is a child of DP1000, then Account can only be under C1550 or C1910, or equal to 10990, 50901, or 95202.

Quasi Endow Corpus

DQ5000 - UR - Quasi Endow

C1550 - Investments ST
C1910 - Investments LT
C5100 - Endowment Payout
C9000 - Investment Gains/Losses
E2000 - Accounts Payable - Operating ST
E2340 - Current Liabilities - Other
E9160 - Other Endowment Additions/Deductions
E9520 - Central Office Transfers
10990 - Claim on Cash -Conversion Only
13860 - Due from/(Due to) Univ Entity
13800 - Due from/(Due to) Funds
30955 - 6014 Cottage Grove Loan
49000 - Net Assets
50901 - Contribution Revenue
95007 - Transfer - Capital Projects
95203 - Transfer - To/From Quasi
99998 -Account Conversion

If Fund is a child of DQ5000, then Account can only be under C1550, C1910, C5100, C9000, E2000, E2340, E9160, or E9520, or equal to 10990, 30955, 50901, 95007, or 95203.

Quasi Endow Distribution

D15000 - UR - Quasi Endow Dist Donor Desig

B7000 - Total Operating Expenses
C1300 - Prepaid Exp & Other Assets ST
C1800 - Prepaid Exp & Other Assets LT
C5100 - Endowment Payout
C9000 - Investment Gains/Losses
D7540 - Financial Aid
D9500 - Transfers
E2000 - Accounts Payable - Operating ST
E9160 - Other Endowment Additions/Deductions
10124 - Cash - Contr Disbursement 3412
10990 - Claim on Cash -Conversion Only
13800 - Due from/(Due to) Funds
13860 - Due from/(Due to) Univ Entity
23340 - Other Liabilities ST
49000 - Net Assets
52895 - Revenue - Other Source
52899 - Misc Interest Income
76941 - Expense Conversion Only
99998 - Account Conversion 

If Fund is a child of D15000, then Account can only be under B7000, C1300, C1800, C5100, C9000, D7540, D9500, E2000, or E9160, or equal to 10124, 10990, 23340, 52895, 52899, or 76941.

Recharge

C34600 - Recharge

010 - Balance Sheet
820 - Recharge Operations
999 - Unspecified

Recharge Funds between 346000 and 346999 can only be used with Purpose values 010, 820, or 999.

Recharge Inverse

820 - Recharge Operations

C34600 - Recharge
D35000 - Capital Reserves 
100000 - General Operating
271542 - Non-Capital Projects 

358037 - CP-FY22 Arc Tunnel Washer
358298 - CP-Lago X  
999998 - Fund Conversion

If Purpose is equal to 820, then Fund can only be under C34600 (Recharge Funds), D35000, or equal to 100000, 271542, 358037, or 358298.

Temp Restricted for A&LI

D50300 - TR - Annuity & Life Income

C1300  -  Prepaid Exp & Other Assets ST
C1800  -  Prepaid Exp & Other Assets LT
C2795  -  Deferred Revenue LT
C9000  -  Investment Gains/Losses
E1145  -  General Accounts Receivable
E1910  -  Investments LT
E2765  -  Non Current Liabilities - Other
E5090  -  Contribution Revenue
E5100  -  TRIP Endowment
E9110  -  Actuarial Adjustments
E9140  -  Payments to A&L Beneficiary
E9160  -  Other Endowment Additions/Deductions
10990 -  Claim on Cash - Conversion Only
13800 -  Due from/(Due to) Funds
13860 -  Due from/(Due to) Univ Entity
27800 -  A&L Annuities Payable
49000 -  Net Assets
50901 -  Contribution Revenue
91101 -  Actuarial Adjustments
91401 -  Payments to A&L Beneficiary
95000 -  Transfer - General
95201 -  Transfer -  To/From Temp Restr
95202 -  Transfer -  To/From Perm Restr
99998 -  Account Conversion

The account combination you are attempting to use is invalid. Please review published Cross-Validation rules for Accounts that may be used when the Fund is a child of D50300.

Temp Restricted of True Endow

DT1000 - TR - True Endow

C1550 - Investments ST
C1910 - Investments LT
C5100 - Endowment Payout
C9000 - Investment Gains/Losses
D2825 - Deferred Revenue - Other LT
E5090 - Contribution Revenue
E9160 - Other Endowment Additions/Deductions
10990 - Claim on Cash -Conversion Only
13800 - Due from/(Due to) Funds
13860 - Due from/(Due to) Univ Entity
49000 - Net Assets
95000 - Transfer - General
95200 - Transfer - Endowment Reinvest
95201 - Transfer - To/From Temp Restr
95202 - Transfer - To/From Perm Restr
99998 - Account Conversion

If Fund is a child of DT1000, then Account can only be under C1550, C1910, C5100, C9000, D2825, E5090, or E9160, or equal to 10990, 95000, 95200, 95201, or 95202.

Term Endow Corpus

DT2800 - TR - Term Endow

C1550  -  Investments ST
C1910  -  Investments LT
C5100  -  Endowment Payout
C9000  -  Investment Gains/Losses
D2825  -  Deferred Revenue - Other LT
E9160  -  Other Endowment Additions/Deductions
10990 -  Claim on Cash - Conversion Only
13800 -  Due from/(Due to) Funds
13860 -  Due from/(Due to) Univ Entity
49000 -  Net Assets
50901 -  Contribution Revenue
95000 -  Transfer - General
95200 -  Transfer - Endowment Reinvest
95201 -  Transfer -  To/From Temp Restr
95202 -  Transfer -  To/From Perm Restr
99998 -  Account Conversion

If Fund is a child of DT2800, then Account can only be under C1550, C1910, C5100, C9000, D2825, E9160, or equal to 10990, 50901, 95000, 95200, 95201, or 95202.

Term Endow Distribution

D22800 - UR - Term Endowment Dist Donor Desig

B7000 - Total Operating Expenses
C1300 - Prepaid Exp & Other Assets ST
C1550 - Investments ST
C1800 - Prepaid Exp & Other Assets LT
C1910 - Investments LT
C5100 - Endowment Payout
C9000 - Investment Gains/Losses
D7540 - Financial Aid
D9500 - Transfers
E2000 - Accounts Payable - Operating ST
E5090 - Contribution Revenue
10124 - Cash - Contr Disbursement 3412
10990 - Claim on Cash -Conversion Only
13800 - Due from/(Due to) Funds
13860 - Due from/(Due to) Univ Entity
49000 - Net Assets
99998 - Account Conversion

If Fund is a child of D22800, then Account can only be under B7000, C1300, C1550, C1800, C1910, C5100, C9000, D7540, D9500, E2000, or E5090, or equal to 10124 or 10990.

True Endowment Distribution

D11000 - UR - True Endow Dist Donor Desig

B7000 - Total Operating Expenses
C1300 - Prepaid Exp & Other Assets ST
C1550 - Investments ST
C1800 - Prepaid Exp & Other Assets LT
C1910 - Investments LT
C5100 - Endowment Payout
D7540 - Financial Aid
D9500 - Transfers
E2000 - Accounts Payable - Operating ST
E9000 - Investment Gain/Loss
E9160 - Other Endowment Additions
10124 - Cash - Contr Disbursement 3412
10838 - Accounts Payable - Operating
10990 - Claim on Cash -Conversion Only
12641 - AR - Accrued Int & Div Rec ST
13315 - Prepaid - Other ST
13800 - Due from/(Due to) Funds
13860 - Due from/(Due to) Univ Entity
19626 - Clear - Equipment - Moveable
23340 - Other Liabilities ST
49000 - Net Assets
50395 - Tuition - Adjustments
50901 - Contribution Revenue
52894 - Earnings on Other Investments
52895 - Revenue - Other Source
52898 - Mgmt Fees - non Univ TRIP
52899 - Misc Interest Income
76941 - Expense Conversion Only
99998 - Account Conversion

If Fund is a child of D11000, then Account can only be under B7000, D7540, D9500, or equal to a limited set of values. Please review published Cross-Validation rules for full details.

Unspecified

Organization

 

99999 - Due to/Due From

13800 - Due from/(Due to) Funds

13860 - Due from/(Due to) Univ. Entity

23340 - Other Liabilities ST 49000 - Net Assets

Organization 99999 can only be used with system-generated Account value 13800, 13860, 23340, or 49000.

Unspecified Purpose

999 - Unspecified

A9999 - Unspecified    
B9000 - Total Non Operating
B9500 - Transfers
B9600 - Centrally Allocated Revenues
C5050 - Government Grants & Contracts
C5070 - Prvt Gifts,Grants,& Contracts
C5100 - Endowment Payout
C5120 - Patient Services
C5180 - Auxiliaries Revenue
C5280 - Other Income
C5550 - Net Assets Released from Restc

D5000 -Tuition                 

D5040 - Fees
76918 - Foreign Currency G/L

Unspecified Purpose 999 can only be used with Revenue accounts under A9999, B9000, B9500, B9600, C5050, C5070, C5100, C5120, C5180, C5280, C5550, D5000, or D5040, or equal to 76918.

 

Helpful?