Self-Service Finance Reports

Body

 In your role as a financial manager, you have access to finance self-service. Access is from www.banweb.mtu.edu - same as Employee Self-Service, using your MTU SSO account ID and password. 

The Finance Reports available through self-service have changed. The reports are written with a new reporting tool called WebFOCUS. They are accessed in the same way, by selecting Finance and then Financial Reports. When you select a report, you will be prompted to enter your MTU SSO account ID and password. 

How to use the reports

Financial Reports – Budget vs Actual 

Fill in Parameters and select the Run iconrun icon

Budget vs Actual selection toolFiscal year: YYYY Example: 2017 – Michigan Tech’s fiscal year starts on July 1, so July 1, 2016 is the beginning of Fiscal year 17. 

Fiscal Period: Use the dropdown menu to choose the ending month. Example: December (the report results will be cumulative through December). 

Select an output type: Choose HTML for displaying on your screen, PDF to print or save the report, or Excel (EXL07) to print or save the report. The pdf output will have page breaks in the appropriate place when printed. 

College or Department Like: Enter a specific department or college code, such as: 41100 or enter % (wildcard). The word “Like” in a parameter indicates that you can use a wildcard. NOTE: All parameters with the word “Like” require a wildcard if you are not entering something more specific. 

Index Like: Enter a specific index, all indexes starting with a specific letter (Example: E%), or % for all indexes. 

Like: Enter % (wildcard) for all department codes or enter a specific department or college code. Example: 41100 

Lowercase Financial Mgr Userid Like: Enter your userid which is the same as your mtu email address without the @mtu.edu. Example: sajones If you have entered a specific index or department code, you may enter % in this parameter. 

Index Termination Date Cut off: This parameter is used to eliminate old indexes from the report that have been terminated. Suggested dates: 

  • Today’s Date. Example June 7, 2018 This eliminates all terminated indexes from the report. 
  • The last day of the previous month. Example: April 30, 2018. This eliminates all indexes terminated on or before April 30, 2018 but includes those terminated during the month of May. 
  • The last day of the previous fiscal year. Example: June 30, 2017. This eliminates all indexes terminated on or before June 30, 2017.

FZGDET003E – Transaction Detail by Account Code 

Fill in Parameters and click the Run icon. run icon

Beginning Period: Use the drop down menu to choose the beginning month. 

Ending Period: Use the drop down menu to select the ending month. 

Select an output type: Choose HTML for displaying on your screen, PDF to print or save the report, or Excel (EXL07) to print or save the report. The pdf output will have page breaks in the appropriate place when printed. 

Sort Order: Choose Index or Financial manager 

Fiscal year: YY Example: 17 

Department or College Like: Enter % (wildcard) for all department codes or enter a specific department or college code. Example: 41100 

Index Like: Enter a specific index, all indexes starting with a specific letter (Example: E%), or % for all indexes. 

Account Code Like: Enter a specific account code (Example: E711), all account codes starting with a specific letter, (Example: E%), or % for all account codes. 

Financial Manager Userid Like: Enter your userid which is the same as your mtu email address without the @mtu.edu. Example: sajones If you have entered a specific index or department code, you may enter % in this parameter. 

Document Code Like: Enter % for all document codes, a specific document code, or document codes beginning with a specific letter (Example: I%). 

Transaction Description Like: Enter % for all transaction descriptions, a specific description, or a partial description using %. For invoices, the description is the vendor or payee, so for all payments to an individual, the description is Last Name, First Name, Middle Initial. Example: Jones, Samuel A. You can enter the full name including the period after the initial or Jones% or Jones, Samuel% 

Rule Class: Enter % for all rule classes (a code related to the type of transaction), or enter a specific rule class. One example for using this parameter is to get only purchasing card transactions. The rule class is ZLAN.

Details

Details

Article ID: 162149
Created
Wed 10/16/24 9:17 AM
Modified
Wed 10/16/24 11:01 AM