College Level Reports

Intended Audience: Deans, Department Heads, Administrators, etc. whose Org Security is set at the college (5XXX), department (3XXX) or sub department (2XXX) level.

4423 - Salary and Benefit Report

User Guide for Report 4423

This report provides salary and benefit costs by employees for multiple months based on user entered parameters. Run on a required basis by the users. Filtered by Fund and Organizational Security, and users will only see their own scheduled reports.

4990S - College Summary Report of Financial Activity By Department

Summary Report of College and Department Revenues and Expenses by Organizational Level. Scheduled Monthly after closing Period. Filtered by Organizational Security.

4990D - College Report of Financial Activity By Fund Roll Up By Department

Detail Report of College and Department Revenues and Expenses by Organizational Level. Scheduled Monthly after closing Period. Filtered by Organizational Security.

4992S - College Summary Report of Financial Activity By Fund Roll-Up

This report provides a summary of all financial activity in a College or Administrative Unit, sorted by department, for the current fiscal year to date. Reports are Scheduled Monthly after each closing Period and filtered by Organizational Security.

4992D - College Report of Financial Activity By Department By Fund Roll Up

This report provides a summary of all financial activity in a College or Administrative Unit, for each department, sorted by fund roll-up, for the current fiscal year to date. Reports are Scheduled Monthly after each closing Period and filtered by Organizational Security.

7495 - College Accounts Receivable Summary

Summary of Outstanding Accounts Receivable by College.

10493S - College/Unit Summary of Financial Activity Report

This report provides a summary of financial activity for all funds in a College or Administrative Unit, sorted by fund roll-up, for the current fiscal year to date in a comparable format to the operating statement in FAST. Reports are Scheduled Monthly after each closing Period and filtered by Organizational Security.

10493D - College/Unit Summary of Financial Activity Report – By Department

This report provides a summary of financial activity for all funds in a College or Administrative Unit, for each department (i.e. 3-level org), sorted by fund roll-up. This information is presented for the current fiscal year to date in a comparable format to the operating statement in FAST. Reports are Scheduled Monthly after each closing Period and filtered by Organizational Security.

10515 - College/Unit Summary of Financial Activity Report – Operating Funds

This report provides a summary of financial activity for all operating funds in a College or Administrative Unit, sorted by fund roll-up, for the current fiscal year to date in a comparable format to the operating statement in FAST. Reports are Scheduled Monthly after each closing Period and filtered by Organizational Security.

4998 - Department Research Balances by Financial Manager

This report provides a summary of all active research funds in a department, sorted by individual responsible for the research. It provides a summary of the actual financial activity on this project since it began, as well as any commitments or advances to other institutions that are currently outstanding. A calculated 'balance available' is provided for each fund.

4589 - Overhead Revenue - for Colleges and Departments

This report is generated for each fund that receives revenue from the automatic overhead recovery process in UniFi. This report groups and summarizes all of the postings for a given month according to the source of the overhead. It does not include any overhead recoveries posted to the fund by journal voucher.

3856 - Tuition Report by College of Instruction by Term

This report provides a summary of total undergraduate tuition assessed by college of instruction excluding program based tuition (Dentistry, Medicine, and Veterinary Medicine).

4713 - Tuition Report by College of Instruction by Class Level (Excluding Program Students)

This report provides a summary of total undergraduate tuition assessed by college of instruction excluding program based tuition (Dentistry, Medicine, and Veterinary Medicine).

4286 - Program Tuition

This report will provide a summary of total tuition assessed to students whose tuition is assessed at a program level and includes students in the colleges of Dentistry, Medicine, WCVM and Graduate Studies and Research.

4702 - Program Tuition - Graduate Students

This report provides a summary of total tuition assessed to all students in the Graduated Studies level and is sorted by degree and major and includes Student names and ID Numbers.

5007 - Budget Comparison by Fund (-Org-Acct-Prog-Actv)

Compares Budget Amounts Based on two Budget Codes and Phases selected.

5008 - Budget Comparison by Organization (-Fund-Acct-Prog-Actv)

Compares Budget Amounts Based on two Budget Codes and Phases selected.

5009 - Budget Comparison by Account (-Org-Fund-Prog-Actv)

Compares Budget Amounts Based on two Budget Codes and Phases selected.

3282 - Security Lookup Colleges/Departments

User Guide for Report 3282

This report enables you to view selected security profile information for each individual whose User Org (organization) rolls up to your college (5XXX), department (3XXX) or sub department (2XXX) level Org code. This report should be reviewed monthly to check that new employees have been provided with UniFi access and that terminated employees have had their UniFi access removed.

Department Level Reports

Intended Audience: Department Heads, Deans, and those individuals who have been delegated authority to view UniFi funds on their behalf.

4423 - Salary and Benefit Report

User Guide for Report 4423

This report provides salary and benefit costs by employees for multiple months based on user entered parameters. Run on a required basis by the users. Filtered by Fund and Organizational Security, and users will only see their own scheduled reports.

4990S - College Summary Report of Financial Activity By Department

Summary Report of College and Department Revenues and Expenses by Organizational Level. Scheduled Monthly after closing Period. Filtered by Organizational Security.

4990D - College Report of Financial Activity By Fund Roll Up By Department

Detail Report of College and Department Revenues and Expenses by Organizational Level. Scheduled Monthly after closing Period. Filtered by Organizational Security.

7327 - Department Fund Balances By Financial Manager

Department Fund Balances By Financial Manager.

7328 - Department Report of Revenues, Expenditures and Fund Balances

This Report shows a summary of all financial activity in a department, sorted by fund roll-up, for the current fiscal year to date. This report is for Chart 1 only and does not contain budget or commitment information. Not all fund roll-ups will be applicable for each Department.

4589 - Overhead Revenue - for Colleges and Departments

This report is generated for each fund that receives revenue from the automatic overhead recovery process in UniFi. This report groups and summarizes all of the postings for a given month according to the source of the overhead. It does not include any overhead recoveries posted to the fund by journal voucher.

4998 - Department Research Balances By Financial Manager

This report provides a summary of all active research funds in a department, sorted by individual responsible for the research. It provides a summary of the actual financial activity on this project since it began, as well as any commitments or advances to other institutions that are currently outstanding. A calculated 'balance available' is provided for each fund.

5007 - Budget Comparison by Fund (-Org-Acct-Prog-Actv)

Compares Budget Amounts Based on two Budget Codes and Phases selected.

5008 - Budget Comparison by Organization (-Fund-Acct-Prog-Actv)

Compares Budget Amounts Based on two Budget Codes and Phases selected.

5009 - Budget Comparison by Account (-Org-Fund-Prog-Actv)

Compares Budget Amounts Based on two Budget Codes and Phases selected.

3282 - Security Lookup Colleges/Departments

User Guide for Report 3282

This report enables you to view selected security profile information for each individual whose User Org (organization) rolls up to your college (5XXX), department (3XXX) or sub department (2XXX) level Org code. This report should be reviewed monthly to check that new employees have been provided with UniFi access and that terminated employees have had their UniFi access removed.

Fund Level Reports

Intended Audience: Individuals responsible for the management of a Fund.

2915 - Fiscal Year Statement of Operations and Fund Balance by Activity Code

This report presents a statement of operations and fund balance for any given fund by grouping activity codes. This report will present activity for the current fiscal year to date of the University and will show the beginning and ending fund balances. The information presented to you will be filtered based on your Organizational Security.

3917 - Fund Summary by Financial Manager

User Guide for Report 3917

YTD Actuals by Financial Manager.

7316 - Transactions By Fund

This report provides a detailed listing of all transactions in a fund on a monthly basis. This report captures all transactions in the fund and therefore eliminates having to drill down in FAST through different org codes.

10353 - Transactions with non-default orgn codes

This report will identify funds in the ledger that have an org code different from the default org code on the fund.

General Reports

Intended Audience: All Finance Users.

5630 - Organization (Org) Hierarchy - choice of Online Viewing or Printing

A hierarchical view of all Organizations within UniFi.

7203 - Scholarship Detail Codes

This report provides a summary of all scholarship CFOAPALs processed through Student Accounts and the Banner detail code needed to process the award.

Monthly Review

Intended Audience: All Finance Users.

10782 - Dean Monthly Review - Income Statement

This report provides a summary of financial activity for all funds in a College/Unit (ie. as represented by a 5000 level org code in UniFi) for the current month.

10886 - Month End Review Completions by Period

User Guide for Report 10886

Lists the Dean and Department Head completions by College and Department for a period. Must run with desired Fiscal Year and Fiscal Period as parameters to get the most current information.

10780 - Department Head Monthly Review - Fund Balances

This report provides a summary of all active funds in a department, sorted by individual responsible for the project.

10781 - Department Head Monthly Review - Income Statement

This report provides a summary of financial activity for all funds in a Department (ie. as represented by a 3000 level org code in UniFi) for the current month.

TBD

TBD

Year End Reports (May 2013 Only)

Intended Audience: All Finance Users for the duration of May 2013

10353 – Transactions with Non-Default Orgn Codes – Year End 

This report will identify funds in the ledger that have an org code different from the default org code on the fund.

3917 – Fund Summary by Financial manager 

User Guide for Report 3917

YTD Actuals by Financial Manager.

4990S – College Summary Report of Financial Activity

Summary Report of College and Department Revenues and Expenses by Organizational Level. Scheduled Monthly after closing Period. Filtered by Organizational Security.

4992D - College Report of Financial Activity By Department By Fund Roll Up

This report provides a summary of all financial activity in a College or Administrative Unit, for each department, sorted by fund roll-up, for the current fiscal year to date. Reports are Scheduled Monthly after each closing Period and filtered by Organizational Security.

4992S - College Summary Report of Financial Activity By Fund Roll-Up

This report provides a summary of all financial activity in a College or Administrative Unit, sorted by department, for the current fiscal year to date. Reports are Scheduled Monthly after each closing Period and filtered by Organizational Security.

7327 - Department Fund Balances By Financial Manager

Department Fund Balances By Financial Manager.