Entry Type Table

Rpt. TRAN Description Entry Type WORKSHEET
No CODE   Value REFERENCE
         
  40, 41     4, col. 1
         
110 40,41 Encumbrance Amt. Total {Sum} TOTAL-ENC-LIQ 4,col2,col.4a
110 41 T/C 41 Liquidation Total   4,col2,col4a
         
111   Report Totals    
111 50 General Ledger    
111 50,52 Expenditures EXPENDITURES 3,col1
111 50,52 Revenues REVENUES 1,col1
111 50,52 Non-Revenues NON-REVENUES 1,col1
111 50,52 Transfers TRANSFERS 1,col1
111 50,52 Beg Fund Balance BEG-FUND-BAL 1,col1
111 50,52 B/N Fund Balance BN-FUND-BAL 1,col1
111 50,52 Total    
111        
111   Report (encumbrance) Totals    
111 50,51 Liq. Enc.    
111 51,52 Ind. Cost Enc.    
111 50,51 Total TOTAL-LIQ 4,col.5a
         
111 51 T/C 44 Exp. Amount TOTAL-TC44 1,col.3;2 col.1
111 50 T/C 50 TOTAL-TC50 1,col.3;2 col.1
111 51??? T/C 51 TOTAL-TC51 1,col.3;2 col.1
111 52 T/C 52   1,col.3;2 col.1
         
112   Cash Receipts Journal    
112 30 Expenditures EXPENDITURES 3,col.2
112 30 Revenues REVENUES 2,col.2a
112 30 Non-Revenues NON-REVENUE 2,col.2a
112 30 B/N Fund Balance BN-FUND-BAL 2,col.2a
112 30 Transfers TRANSFERS 2,col.2a
112 30 Beg Fund Balance BEG-FUND-BAL 2,col.2a
112 30 Total TOTAL  
         
113 32 T/C 32 Journal Total TOTAL  
113 32 Beg Fund Balance   2,col.2b
         
114   Journal Vouchers (35 & 36)    
114   Total DR DEBIT  
114   Total CR CREDIT  
114   Expenditures EXPENDITURES 3,col.3
114   Revenues REVENUES 2,col.4
114   Non-Revenues NON-REVENUES 2,col.4
114   Transfers (should be 0) TRANSFERS 2,col.4
114   B/N Fund Balance BN-FUND-BAL 2,col.4
114   Beg. Fund Balance BEG-FUND-BAL 2,col.4
114   Indirect Cost INDIRECT-COST 3,col.3
114   Total DR   1,col.2a,b
114   Total CR   1,col.2a,b
         
115   T/C 42, 43, and 53 Journal TOTAL 4,col.5b
115   Encumbrances:    
115   Salaries    
115   Stipends    
115   Staff Benefits    
115   Liquidations:    
115   Salaries    
115   Stipends    
115   Staff Benefits    
         
116   T/C 40, 41 Journal    
116   Total Encumbrance {Sum} TOTAL 4,col.3,col.4b
116   Total Liquidations   4,col.3,col.4b
         
117   C.T.I. Journal (T/C 60, 61, 62)    
117   Total Cost Transfers (p. 1) COST-TRANS 1,col.4b
117   Total Expenditures (p. 2) EXPENDITURES 1,col.4a
117   Total Liquidations (p. 2)    
         
118   T/C 70, 73 Journal   1, col.5a
118   Total T/C 70's TOTAL-TC70 3,col.4a
118   Total T/C 73's TOTAL-TC73 1, col.5b;3,col.5
118   Total Liq.s (T/C 70 + 73)    
         
121   T/C 44 Purchase Journal    
121   Net Amount NET-AMOUNT 4a,col.4
         
122   Acct. Pay Disb. (T/C 45) Journ.    
122   Total Amount TOTAL  
         
124   I.S.D. (T/C 65) Journal    
124   Tot. Internal Sales (F/A p.1) INT-SALES 1,col.4b;2,col.3b
124   Tot. Expenditures (F/A p. 2) EXPENDITURES 1,col 4a,3,col.4b
124   Tot. Liquidations (p. 2)    
         
125   T/C 46, 48 Journal (Net amt) TOTAL 4b,col.2,col.4
125   Total T/C 46    
125   Total T/C 48    
         
132   Revenue Ledger Daily Activity    
132   Total Estimated Revenue TOTAL-EST-REV 8,col1(line3)
132   Total Est. Revenue Adj.s TOTAL-EST-REV-ADJ 8,col2(line3)
132   Total Actual Revenue TOTAL-ACTUAL-REV 2,col.5b;8,col.3(line3)
132   Loan Rcv. Contra Acct.s LOAN-RCV-CONTRA 2,col.3a
         
133   Enc. Ledger Daily Activity    
133   Total Encumb. & Adjustments TOTAL-ENC-ADJ 4,col.4c;5,col.5
133   Total Liquidations TOTAL-LIQ 4,col.6;5,col.5
         
134   B/E Ledger Daily Activity    
134   Total Budget TOTAL-BUDGET 7,col.1
134   Total Budget Adjustments TOTAL-BUDGET-ADJ 7,col.2
134   Total Expenditures TOTAL-EXPEN 3,col.6b;7,col.3
134   Total Salary Recaptures TOTAL-SAL-RECAP 7,col.4
134   Total Encumbrances TOTAL-ENCUM 4,col.7b;7,col.5
134   Loan Rcv. Contra Acct.s LOAN-RCV-CONTRA 3,col.4c
         
138   A/E Ledger Daily Exp. Activity    
138   Total Allotments To Date TOTAL-ALLOT 6,col.1
138   Total Expenditures TOTAL-EXPEN 3,col.6c;6,col.2
138   Total Encumbrances TOTAL-ENCUM 6,col.3
138   Total Accruals TOTAL-ACCRUALS 3,col.6c;6,col.4
138   Available Balance AVAIL-BAL 6,col.5
         
139   A/E Ledger Daily Rev. Activity    
139   Total Revenue Allotments TOTAL-REV-ALLOT 9,col.1 (line 3)
139   Total Rev. Allotment Adjust.s TOTAL-ALLOT-ADJ 9,col.2 (line 3)
139   Total Revenue TOTAL-REVENUE 2,col.5c; 9,col.3(line 3)
         
140   Fund Totals Encumbrances   7,col.5 Cum line
140   Fund Totals FUND-TOTALS 5,col.1,col.2
140   Accnts Payable Remain Bal ACCT-PAYABLE 4a,col.6;4b,col.6
140   "C" Acct.s Pay Remain Bal   0
140   Funds breakdown (each fund should be accounted for)    
140   Accnts Payable Remain Bal F###-ACCT-PAYABLE 10-G, Accounts Payable (5111)
140   Accruals Remain Bal F###-ACCRUALS 10-G, Accrued Liab
140   Liquidating Enc {SUM +1} F###-DCOST-ENCUM 10-G, Direct Cost Encumbrn
140   Non Liquidating Enc   10-G, Direct Cost Encumbrn
140   Ind Cost Enc Remain Bal F###-ICOST-ENCUM 10-H, Indirect Cost Encumbrn
140   Payroll Encumbrn F###-PAYROLL-ENCUM 10-H, Payroll Encumbrn
         
141   Fund Totals Allotments    
141   Total Expend. Allotments {SUM +1} TOTAL-EXP-ALL-ADJ 6,col.1 Cum line
141   Total Allotment Adjustments   6,col.1Cum line
141   Total Expenditures TOTAL-EXPEN 6,col.2Cum line;7col.3 Cum line
141   Total Encumbrances TOTAL-ENCUM 6,col.3 Cum line
141   Total Accruals TOTAL-ACCRUALS 6,col.4 Cum line
141   Available Balance AVAIL-BAL 6,col.5 Cum line
141   Funds breakdown (each fund should be accounted for)    
141   Expenditure Allotments {SUM +1} F###-EXP-ALLOT-ADJ 10-F, Allotment Adjustments
141   Allotment Adjustmnts   10-F, Allotment Adjustments
         
         
142   Fund Totals B/E Ledger    
142   Total Budget TOTAL-BUDGET 7,col.1Cum line, MIS-FUND-EXP
142   Total Budget Adjustments TOTAL-BUDGET-ADJ 7,col.2 Cum line, MIS-FUND-EXP
142   Total Expenditures TOTAL-EXPEN 7,col.3 Cum line, MIS-FUND-EXP
142   Total Salary Recaptures TOTAL-SAL-RECAP 7,col.4 Cum line, MIS-FUND-EXP
142   Total Encumbrances TOTAL-ENCUM 5,col.3;7,col.5 Cum line, MIS-FUND-EXP
142   Available Balance AVAIL-BAL 7,col.6 Cum line
142   Funds breakdown (each fund must be accounted to)    
142   Expenditures F###-EXPEN 10-E, Sum of column A-G
142   Budget F###-BUDGET 10-F, Budget/Budget Adj (6701)
142   Budget Adjstments F###-BUDGET-ADJ 10-F, Budget/Budget Adj (6701)
142   Salary Recaptures F###-SAL-RECAP 10-F, Budget/Budget Adj (6701)
         
         
146   Fund Totals Revenue Ledger    
146   Total Estimated Revenue TOTAL-EST-REV 8,col.1Cum line, MIS-FUND-REV
146   Total Est. Rev. Adjustments TOTAL-EST-REV-ADJ 8,col.2 Cum line, MIS-FUND-REV
146   Total Actual Revenue TOTAL-ACTUAL-REV 8,col.3 Cum line, MIS-FUND-REV
146   Over/Under Budget OU-BUDGET  
146   Beg. Fund Bal. (Actual)    
146   Funds breakdown (each fund must be accounted to)    
146   Revenue line ( Est Rev + Est Rev Adj) F###-BUDGET-REV 10-A, budgeted revenue
146   Revenue (Actual) F###-TOTAL-REV 10-A, Total Revenue
146   Non-Revenue (Actual) F###-NON-REV 10-B, Total Non Revenue
146   Transfers(Actual) F###-TRANSFER 10-C, Total Transfers
146   Beg Fund Bal (Actual) F###-BEG-BAL 10-D, Beg Fund Bal (total + Indirect Contra Cost)
         
         
148   Fund Totals Rev. Allotments    
148   Total Rev. Allotments TOTAL-REV-ALLOT 9,col.1Cum line
148   Total Rev. Allot. Adjustments TOTAL-REV-ALLOT-ADJ 9,col.2, Cum line
148   Total Revenue (actual) TOTAL-REVENUE 8,col.3 Cum line; 9col.3,Cum line
148   Available Balance AVAIL-BAL 9,col.4, Cum line
         
    Special Extract to 18009    
    Indirect Contra Beginning Bal IND-CONTRA-BEG-BAL  
         
         
    Prior Amt.s AM18009, 140-148    
        4a,cl7;4b,cl7
140   Fund Totals Encumbrances    
140   Fund Totals    
140   Accnts Payable Remain Bal    
140   "C" Acct.s Pay Remain Bal   6,cl1 Daily
        6,cl1 Daily
141   Fund Totals Allotments   6,cl2 Daily
141   Total Expend. Allotments   6,cl3 Daily
141   Total Allotment Adjustments   6,cl4 Daily
141   Total Expenditures   6,cl5 Daily
141   Total Encumbrances    
141   Total Accruals    
141   Available Balance   7,cl1 Daily
        7,cl2 Daily
142   Fund Totals B/E Ledger   7,cl3 Daily
142   Total Budget   7,cl4 Daily
142   Total Budget Adjustments   5,cl4; 7cl5 Daily
142   Total Expenditures   7,cl6 Daily
142   Total Salary Recaptures    
142   Total Encumbrances    
142   Available Balance   8,cl1 Daily
        8,cl2 Daily
146   Fund Totals Revenue Ledger   8,cl3 Daily
146   Total Estimated Revenue   8,cl4 Daily
146   Total Est. Rev. Adjustments    
146   Total Actual Revenue    
146   Over/Under Budget    
146   Beg. Fund Bal. (Actual)   9,cl1, Daily
        9,cl2, Daily
148   Fund Totals Rev. Allotments   9,cl3, Daily
148   Total Rev. Allotments   9,cl4, Daily
148   Total Rev. Allot. Adjustments    
148   Total Revenue (actual)    
148   Available Balance    
         

Last Updated on 3/24/99
By Alexis Chin