Total Spendable Balance Details using the Find Journal Lines – OSU - Posted Journals by Amount Type

View the Total Spendable Balance details from Income Statement reporting

The Total Spendable Balance is the sum of: Beginning Balance, GFA Activity (includes GFA original & net revisions & student reimbursement) and YTD Sources/Other revenues-Transfers In.

View the specifics of your total sources financial activity using the Find Journal Lines – OSU - Posted Journals by Amount Type report. To begin, open the report and complete the prompt guides below: 

  1. Select the appropriate Company.
  2. In Period select the period you wish to view activity for or up through.
  3. In Time Period select Current Period YTD.
  4. In Amount Type select Activity.
  5. In Amount Type select Ending Balance.
  6. In Ledger select Actuals.
  7. In Book select Common Book to match managerial reports. You can view another book if preferred. 
  8. In Ledger Accounts select Master: UNIV_M Non UNIV Transfers In, Master: UNIV_M Sources, Master: UNIV_M Total Equity, and Master: UNIV_M Transfers In.
  9. In Worktags specify the appropriate Cost Center hierarchy.
  10. In Exclude Funds, all the funds that are typically excluded in managerial reporting are selected by default.  If you wish to include these funds in your reporting, de-select the following Funds to include them in the report:  
    1. FD511 Pending Endowment Distribution Fund
    2. FD610 Endowment Principal Restricted Non-Expendable Fund
    3. FD660 Pending Endowments Principal Fund
    4. FD700 Annuity and Life Fund
    5. FD750 Loan Federal Fund
    6. FD751 Loan Non-Federal Fund
    7. FD950 GASB Adjustment Fund

 

Note: If more information is needed on a specific line item right click the ... button next to the magnifying glass in the Journal line and select See in New Tab to View Journal and all the specifics of the posting.