FAB General Ledger Reports Overview - CFO

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.	By Department by Category By Area by Category By Department by Account 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.	By Department by Category By Area by Category By Department by Account 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	Area: Summary by Budget Account Area: Summary by Budget Account by Program Area: Department Summary by Budget Account Area: Department Summary by Budget Account by Program Department: Summary by Budget Account by Program Department: Summary by Department by Budget Account Department: Summary by Program by Budget Account Fund – Program: Summary by Budget Account 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	Area: Summary by Budget Account Area: Summary by Budget Account by Program Area: Department Summary by Budget Account Area: Department Summary by Budget Account by Program Department: Summary by Budget Account by Program Department: Summary by Department by Budget Account Department: Summary by Program by Budget Account Fund – Program: Summary by Budget Account 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.	Fund/Program Summary by Budget Account 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	Mycode – Base and Non-Base Budget Summary Mycode – Base and Non-Base Budget Detail 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	Mycode – Base and Non-Base Budget Summary Mycode – Base and Non-Base Budget Detail 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.	By Department by Program 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	Actuals FDP- Grouped by Fund-Dept-Program Actuals FDPA – Grouped by Fund-Dept-Program-Account Actuals MYC – Grouped by Mycode Actuals ACC – Grouped by GL Account Budget FDP- Grouped by Fund-Dept-Program Budget FDPA – Grouped by Fund-Dept-Program-Account Budget MYC – Grouped by Mycode Budget ACC – Grouped by GL Account Commitments FDP- Grouped by Fund-Dept-Program Commitments FDPA – Grouped by Fund-Dept-Program-Account Commitments MYC – Grouped by Mycode Commitments ACC – Grouped by GL Account All FDP – Budget, Actuals, and Commitments – Grouped by Fund-Dept-Program All FDPA – Budget, Actuals, and Commitments – Grouped by Fund-Dept-Program-Account 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	Actuals FDP- Grouped by Fund-Dept-Program Actuals FDPA – Grouped by Fund-Dept-Program-Account Actuals MYC – Grouped by Mycode Actuals ACC – Grouped by GL Account Budget FDP- Grouped by Fund-Dept-Program Budget FDPA – Grouped by Fund-Dept-Program-Account Budget MYC – Grouped by Mycode Budget ACC – Grouped by GL Account Commitments FDP- Grouped by Fund-Dept-Program Commitments FDPA – Grouped by Fund-Dept-Program-Account Commitments MYC – Grouped by Mycode Commitments ACC – Grouped by GL Account All FDP – Budget, Actuals, and Commitments – Grouped by Fund-Dept-Program All FDPA – Budget, Actuals, and Commitments – Grouped by Fund-Dept-Program-Account 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.	Area Summary Department Summary Program Summary Fund Summary Program Detail 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.	Listing grouped by Department by Fund Program – sorted by department description 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.	Payroll Activity by Employee Payroll Activity grouped by Mycode Payroll Activity by Employee grouped by Mycode 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.