FAB General Ledger Reports Overview

Query Name Description Report(s) Available
5 Year Expense Comparatives Use this query to compare expenses in the current fiscal year to the last 4 fiscal years.  Expenses are categorized based on the budget category.
  1. By Department by Category
  2. By Area by Category
  3. By Department by Account
  4. By Area by Account
5 Year Revenue Comparatives Use this query to compare revenues in the current fiscal year to the last 4 fiscal years.  Expenses are categorized based on the budget category.
  1. By Department by Category
  2. By Area by Category
  3. By Department by Account
  4. By Area by Account
Available Budget Balance This query is useful in retrieving budget, actual, and commitment activity for all unrestricted and nonsponsored restricted University Funds.

** Fiscal Year to Date **

  1. Area: Summary by Budget Account
  2. Area: Summary by Budget Account by Program
  3. Area: Department Summary by Budget Account
  4. Area: Department Summary by Budget Account by Program
  5. Department: Summary by Budget Account by Program
  6. Department: Summary by Department by Budget Account
  7. Department: Summary by Program by Budget Account
  8. Fund – Program: Summary by Budget Account
  9. Fund – Program: Summary by Account
Available Budget Balance with Dates This query is useful in retrieving budget, actual, and commitment activity for all unrestricted and nonsponsored restricted University Funds.

** Can be limited by a Date Range**

  1. Area: Summary by Budget Account
  2. Area: Summary by Budget Account by Program
  3. Area: Department Summary by Budget Account
  4. Area: Department Summary by Budget Account by Program
  5. Department: Summary by Budget Account by Program
  6. Department: Summary by Department by Budget Account
  7. Department: Summary by Program by Budget Account
  8. Fund – Program: Summary by Budget Account
  9. Fund – Program: Summary by Account
Budget Cost Share This query is useful in retrieving cost sharing expense activity by department, program, and sponsored Project ID.
  1. Fund/Program Summary by Budget Account
  2. Fund/Program Summary by GL Account
Budget Detail – Current and Prior Year This query is useful in retrieving detail budget activity of unrestricted expenses and revenues (chartstrings with a fund code of 11 or 14).

** The information is limited to the current and prior fiscal years **

  1. Mycode – Base and Non-Base Budget Summary
  2. Mycode – Base and Non-Base Budget Detail
  3. Base and Non-Base Budget By Program Detail
Budget Detail – Prior Years This query is useful in retrieving detail budget activity of unrestricted expenses and revenues (chartstrings with a fund code of 11 or 14).

** The information is limited to fiscal year 2002 through two years prior to the current fiscal year**

  1. Mycode – Base and Non-Base Budget Summary
  2. Mycode – Base and Non-Base Budget Detail
  3. Base and Non-Base Budget By Program Detail
GL Detail – Current and Prior with EMPLID Use this query to retrieve detail information for the financial transaction information that you have access to view.  This detail information will include EMPLID (SU ID) where applicable.  For example; for fee revenue this will be the associated student’s emplid; for payroll expense this will be the employee’s emplid, etc.  This is the emplid defined in the HRSA system.

IMPORTANT: IF YOU DO NOT HAVE PAYROLL DETAIL ACCESS, YOU WILL NOT BE ABLE TO VIEW ANY PAYROLL TRANSACTIONS IN THIS QUERY AND REPORTS.  Data is available for the current fiscal year and the prior fiscal year in these reports.  Use the journal date limit to retrieve information for specific time periods.

  1. By Department by Program
  2. By Mycode
GL Detail – Current and Prior Year Use this query to retrieve detail journal information for Budgets, Actuals, and Commitment journals.

** The information is limited to the current and prior fiscal years **

  1. Actuals FDP- Grouped by Fund-Dept-Program
  2. Actuals FDPA – Grouped by Fund-Dept-Program-Account
  3. Actuals MYC – Grouped by Mycode
  4. Actuals ACC – Grouped by GL Account
  5. Budget FDP- Grouped by Fund-Dept-Program
  6. Budget FDPA – Grouped by Fund-Dept-Program-Account
  7. Budget MYC – Grouped by Mycode
  8. Budget ACC – Grouped by GL Account
  9. Commitments FDP- Grouped by Fund-Dept-Program
  10. Commitments FDPA – Grouped by Fund-Dept-Program-Account
  11. Commitments MYC – Grouped by Mycode
  12. Commitments ACC – Grouped by GL Account
  13. All FDP – Budget, Actuals, and Commitments – Grouped by Fund-Dept-Program
  14. All FDPA – Budget, Actuals, and Commitments – Grouped by Fund-Dept-Program-Account
  15. All MYC – Budget, Actuals, and Commitments – Grouped by Mycode
GL Detail – Prior Years Use this query to retrieve detail journal information for Budgets, Actuals, and Commitment journals.

** The information is limited to fiscal year 2002 through two years prior to the current fiscal year**

  1. Actuals FDP- Grouped by Fund-Dept-Program
  2. Actuals FDPA – Grouped by Fund-Dept-Program-Account
  3. Actuals MYC – Grouped by Mycode
  4. Actuals ACC – Grouped by GL Account
  5. Budget FDP- Grouped by Fund-Dept-Program
  6. Budget FDPA – Grouped by Fund-Dept-Program-Account
  7. Budget MYC – Grouped by Mycode
  8. Budget ACC – Grouped by GL Account
  9. Commitments FDP- Grouped by Fund-Dept-Program
  10. Commitments FDPA – Grouped by Fund-Dept-Program-Account
  11. Commitments MYC – Grouped by Mycode
  12. Commitments ACC – Grouped by GL Account
  13. All FDP – Budget, Actuals, and Commitments – Grouped by Fund-Dept-Program
  14. All FDPA – Budget, Actuals, and Commitments – Grouped by Fund-Dept-Program-Account
  15. All MYC – Budget, Actuals, and Commitments – Grouped by Mycode
Mycode Original Journal When adjusting a mycode adjustment, you will need to determine the original journal id.  You cannot adjust a mycode journal.  Use this query to find the original journal id if you have the mycode journal information only.  This report lists the mycode journal information and the associated information for the original journal.  This information (Original Journal Id, Original Journal Date, and Orig Jrnl Ln) will be needed when making a Mycode Adjustment in FAB.
Non-Sponsored restricted fund available Use this query to determine the available funds for each non-sponsored restricted chartstring.
  1. Area Summary
  2. Department Summary
  3. Program Summary
  4. Fund Summary
  5. Program Detail
  6. Program Summary by Chartstring
Open Purchase Order Commitments Use this query to get a listing of OPEN purchase order commitments by chartstring or purchase order number.
  1. Listing grouped by Department by Fund Program – sorted by department description
  2. Listing grouped by Department by Fund by Program – sorted by department ID.
Payroll Activity Detail – Current and Prior This report will list Payroll transactions for employees by Account/Department/Category for the desired journal dates.  Any report run today will include activity from the close of business of the previous day.

Note: Your access to employee payroll information in your area/department is limited by your PeopleSoft Security.

  1. Payroll Activity by Employee
  2. Payroll Activity grouped by Mycode
  3. Payroll Activity by Employee grouped by Mycode
  4. Payroll Activity Detail grouped by Chartstring
Payroll Fiscal Year To Date Summary – Current and Prior This report will list total labor charges and open commitments for each employee by Account/Department/Category for the current fiscal year to date.  Any report run today will include activity from the close of business the previous day.

Note: Your access to employee payroll information in your area/department is limited by your PeopleSoft Security.

Payroll Summary Report – Fiscal to Date Payroll transactions.  The report summarizes for each payroll account total by employee.