University of Saskatchewan

Financial Services Division (FSD)

Report Information

In addition to the information currently available in FAST and UniFi, Financial Services has also produced reports that are available to assist UniFi users with financial management. 

The documents below will provide you with some additional information about financial reports and how to access them. 
VersionsDocument NameHelp
Financial Reports Overview  
How to Bring up a Financial Report in Publisher  

Access the Reports

Financial Services reports are available through the Publisher service (http://publisher.usask.ca). Instructions for connecting to the service and navigating through the reports can be found below.

VersionsDocument NameHelp
Publisher Navigation  

View Report Descriptions and Listings

If you are unfamiliar with Publisher and the reports available, use the following report listings to give you an idea on what reports to view in Publisher. The report listings have been grouped into the following categories:

Click on individual report number and name to view a full report description (Adobe Acrobat Reader is required to view these report descriptions).

Frequently Asked Questions

  1. Why can't I see any data in some of the Publisher reports?
    You may not have the appropriate UniFi security to view the report - most reports have either fund or organization security applied to them. If you feel that you should have access to a report but currently do not, please contact unifisupport@usask.ca or call 966-8783 for guidance on how to request for access.
  2. Can I bookmark a report for easy access?
    For commonly used reports, you may consider using the My Favourites folder to organize reports for quick access. This method creates a new physical shortcut in your My Favourites folder. When using “Search Title”, this shortcut will appear as an item in addition to the report itself.
    To add a report to My Favourites:
    a.    Locate the report title you want to create a shortcut for (but do not double click to open it)
    b.    Right click on the report title and select Organize > Create Shortcut
    c.    Right click on the My Favorites folder and select Organize> Paste Shortcut
    d.    You now have a shortcut to the report in the My Favorites folder
    e.    To delete a shortcut you no longer need in My Favorites, right click on the shortcut, and select Organize> Delete

    Note: Do not use Organize> Copy or Organize> Cut on the report as these functions may negatively affect your view for future reports.
Tip: Note down the report number that you would like to view and search for it by number when you are logged in to Publisher using the Search Title box.

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.

Financial Activity return to top

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.

Research Related return to top

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.

Tuition Related return to top

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.

Budget Related return to top

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.

UniFi Access return to top

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.

Financial Activity return to top

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.

Research related return to top

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.

Budget Related return to top

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.

UniFi Access return to top

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.

return to top

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.

10814 - Trust & Endowment Statement of Income, Expenses and Fund Balance

This report provides a summary financial statement of the previous two fiscal years for trusts and endowments.

General Reports

Intended Audience: All Finance Users.

return to top

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.

College Reports return to top

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.

Department Reports return to top

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.

Fund Financial Manager Reports return to top

TBD

TBD

Year End Reports (May 2013 Only)

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

return to top

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.