The Web-Based Financial Reporting System

21 slides
1.61 MB
803 views

Similar Presentations

Presentation Transcript

1

The Web-Based Financial Reporting SystemThis session is intend to familiarize you with our Web-based financial reporting system. The best way to learn is to practice and click on the various buttons and linked numbers when you are actually logged into the system.

2

The Web-Based Financial Reporting SystemTo find the financial reports, go to the Accounting Office homepage.

3

The Web-Based Financial Reporting SystemThen click on the “General Ledger Financial Report” button and you will be taken to the login screen.

4

The Web-Based Financial Reporting SystemSelect the report you wish to review and click the account number.

5

The Web-Based Financial Reporting SystemClick here to make changes to those authorized to view or spend on the account.Choose the report by specific date.Move forward or back a month.

6

The Web-Based Financial Reporting SystemBlue numbers and headers indicate the ability to drill-down to additional detail.“Help” gives you information on the page you are currently viewing.

7

The Web-Based Financial Reporting SystemClicking the “Total Budget” and “Encumbrance” headings will give you the detail for all the category codes in the account.

8

The Web-Based Financial Reporting SystemAdd a new employee by typing in their ID number here.Use the drop- down menu to describe the relationship of the employee to the department.Authorization File MaintenanceThe department head is set institutionally and can only be changed by the Accounting Office.

9

The Web-Based Financial Reporting SystemAs the account steward, you can limit the amount another employee can charge on the account at on-campus locations like the bookstore.You can also limit the amount they spend off-campus on purchase orders, and check requests.This drop-down box allows you to set a flag that allows, requires or does not allow an employee to see the financial data.An empty box indicates unlimited spending capability. To exclude the individual from spending, a zero must be entered in the box.

10

The Web-Based Financial Reporting SystemThe Report Authorization FeatureIf someone is marked as “required to look”, and if they do not regularly review the financial information, he/she will be listed on an exception report in the Accounting Office. Accounting will remind the employee by email of their responsibility. If there is a consistent pattern of failing to review financial data, the steward’s supervisor will be notified.

11

The Web-Based Financial Reporting SystemIf you click the “Total Budget” heading you will be shown the budget detail for all categories by entry type for the year.

12

The Web-Based Financial Reporting SystemThe description shows the source of the budget entry.

13

The Web-Based Financial Reporting SystemClicking the “Encumbrance” heading will give you the detail on all encumbrances outstanding in all categories for the month.

14

The Web-Based Financial Reporting SystemClicking on a current month balance on the financial report will take you to this general ledger detail display for that account and category.If a number is printed in blue, it indicates additional drill-down detail is available.

15

The Web-Based Financial Reporting SystemReview of General Ledger DetailInspecting the transactions on the general ledger detail is a very important step in the financial review process. This review allows you to find errors in posting to your account, or even transactions that represent an improper use of university funds. As an account steward, you are responsible to verify that each transaction in your account is correct and proper.

16

The Web-Based Financial Reporting SystemTo review general ledger detail from another period, you need not return to the report menu, you can simply move backward or forward using the buttons or by putting in the date of the period you wish to review.

17

The Web-Based Financial Reporting SystemYou may also select the data from the reports and copy it to an Excel spread sheet for analysis. Select the area from the column headers down, right click and select copy.

18

The Web-Based Financial Reporting SystemOpen an Excel session and paste the data into the Excel spread sheet. Some columns may not be sized correctly so you may need to fix them.

19

The Web-Based Financial Reporting SystemSelect the Format, Column, AutoFit option and the columns’ widths will be automatically adjusted to fit the data. You can now begin to work with the data.

20

The Web-Based Financial Reporting System

21

The Web-Based Financial Reporting SystemWe hope this tutorial has been helpful. If you have any questions about the use and functionality of the web-based financial reporting tools, please feel free to contact Layne Hymas at 1990 or Shane Webster 1971.

Browse More Presentations

Last Updated: 8th March 2018