ePrint

1
ePrint

• A faster, more secure efficient process of
  distributing reports.

2
Why the move away from bursting??

• Cognos has proven to be a good tool for
  integrating data from multiple systems. Data
  from the Financial system, however, seems to be
  delivered more efficiently from Eprint. This is
  a good middle ground. We are able to continue
  using COGNOS to develop reports while delivering
  100 of the data to campus users through Eprint.
• BENEFITS
• Available shortly after month end closing no
  more waiting
• Electronic Media versus paper
• Electronic Historical Data
• Reports no longer use up all the available space
  in your Inbox
• Access to detail that was not available on the
  bursted reports
• Detail of Employee Wages
• Availability of other reports that will be useful
  to you

3
Access to Reports

• It should be noted that the way in which access
  operates between Eprint and Banner is different
  than the way in which it operated in the COGNOS
  burst setup. In the past we could give you a
  range of funds and know that you would only be
  able to see the activity as limited by your org
  access. Now, we have to define both fund and org
  for the majority of users. Please check your
  access against the old bursted COGNOS reports to
  see that you are able to see everything you could
  see before.
• Your access to reports depends on your set-up
  within Banner.
• If you find that you do not have access to the
  Fund/Org you need, please send an email to Joan
  Taylor (joan.taylor_at_coloradocollege.edu). For
  any access to new funds or orgs that you have not
  seen before Joan will need approval from the
  Listed Banner Financial Managers involved prior
  to granting access.

4
Some terminology

• Telnet/C3PO The finance reporting system CC
  used before 2003/04.
• Native Banner An Oracle Based Financial
  software package used by CC since 2003/04.
• Go-West A user-friendly reporting package
  developed for CC use which allows Campus to
  access its financial reports up to the most
  current data entry. Go-West draws its
  information from Native Banner.
• ODS Warehouse An online database which pools
  data from different sources in different formats.
  This allows us to create reports which may be
  some combination of data which we were unable to
  combine in the same report before due to data
  constraints. COGNOS uses the ODS warehouse.
• COGNOS An add-on reporting package allowing us
  to create reports using data from many different
  data sources.
• PDF Adobe Portable Document Format
• TEXT standard text format
• Data comma-separated value format to import
  into Microsoft Excel

Drill allows you to select the month/period to
view.
5
Access ePrint by logging into Gowest(this works
the same as it always has)
6
Click on the Finance Button
7
Click on ePrint Finance Repository
Here!
8
Step by Step Access to a Report

• Determine the report you would like to view
• Click on the Drill to select the appropriate
  period
• Click on PDF for the desired period
• You will see on the Left a Bookmark with
  the funds/org one has access to. Note In the
  unrestricted budgets there is next to the Fund
  this means there are orgs available to select
  from. On the restricted budgets you will not see
  an org dropdown though the data is available.
• Click on the next to the Fund and then select
  the Org you would like to view. The Financial
  Statement will populate on the Right.

9
Reports Currently AvailablexxxB stands for
operating budgets (110002/151001/222687)xxxR.
stands for restricted budgets (all other funds)
Operating
Restricted
10
(Available Reports Continued)
Dont forget to hit the drill!
11
Report Titles Descriptions

• FGRCHFB Reflects changes in Fund Balance Month
  CY/Month PY
• FRRGITD Grant Inception to Date (Capital
  Projects)
• FZRBDSCT Financial Statement reflecting Current
  Year Activity over Prior Year Activity (Funds
  110001, 110002, 110003, 110005, 110011 and
  222687)
• FZRBYTD Financial Statement for Current Month
  only with Year To Date Percentage Utilized
  (Funds 110001, 110002, 110003, 110005, 110011 and
  222687)
• FRZRRDSC Financial Statement Current Year
  Activity over Prior Year (All Funds except the
  11s and 222687)
• FZRRYTD Financial Statement Current Month only
  with Year to Date Percentage Utilized (All
  Funds except the 11s and 222687)
• PZREZXHR These are overtime hours exercised
  against 110001 which will have to be absorbed by
  the department.
• PZRWAGE Employee Wages for all Funds except
  110001, 110005 and 110011

12
This is what you see when you drill down. You
will be able to select a given month on the
report to look at. Remember that these reports
are in stasis. To see further underlying detail
you will need to go into the Go-West data screens.
For purposes of this presentation please use the
PDF format. PDF allows you to utilize all the
wonderful capacities of Adobe.
13
Multiple Fund and OrgOptions Operating reports
Printer image you can print the entire report,
current page or a range of pages. Clipboard
you can save to your computer but this is not
necessary since reports will always be
available. -/ - decrease or increase the size
of the actual repot
14
Multiple Fund and OrgOptions Operating reports
Bookmarks X if you click on this it will remove
the left column. To bring back the column click
on the page with the bookmark. Pages will view
all the pages/reports Binoculars to search by
word ? Adobe Help
15
Examples of Actual Reports

• Financial Statement Current Month YTD
• Financial Statement Year over Year
• Organizational Detail
• PZREXHR Overtime projections
• PZRWAGE Student Wage report

16
Current Month YTD (no encumbrance
column)Operating Budget 110002
Trust the net! This budget has 6,571.20
available to spend.
17
Current Month YTD (no encumbrance
column)Operating Budget 110002 - Overspent
Trust the net! This budget is overspent by
2,878.32
18
Current Month YTD with a Prior Year Rollforward
Research Account example
Trust the net! This budget has a balance of
81.47 available to spend.
19
Example of 21XXXX Endowment Fund
Remember that we deposit revenue in endowments by
the quarter. In this endowment only half of the
projected revenue has been deposited. 100 of
what can be spent for the year has been spent.
This endowment is not over budget. This scenario
only occurs in endowments recognizable by the
21xxxx designation.
20
Example of 22XXXX Gift Fund with Prior Year
Rollforward
Remember, these reports net activity in every
column. The reasoning runs Revenue minus
expenses equals (?).
21
Financial Statement Year over Year
22
A 110002 report with both budgeted revenue and
transfers page 1 of 4
23
A 110002 report with both budgeted revenue and
transfers page 2 of 4
24
A 110002 report with both budgeted revenue and
transfers page 3 of 4
25
Final Page 4 of 4 will reflect the Total Revenue
less Total Expenses, /- Total Transfers equals
Net Totals
Remember, these reports net activity in every
column. The reasoning runs Revenue minus
expenses equals (?).
26
Organization Detail Example
27
PZREXHR Projected Overtime based on actual
activity. This is a planning tool not an
actual expense yet. This report is to show you
what your payroll overages will be at the end of
the year if expenditures stay as they are.
This calculation is based on Position budget,
minus encumbrance for the rest of the year minus
actual fiscal year expense to date.
28
PZRWAGE By Position, By Org, By Employee
29
Presentations of Data 1 of 3 Comparisons
Go-West
30
Presentation of data 2 of 3 Comparisons Burst
Style
31
Presentation of data 3 of 3 Comparisons - Eprint
32
Who you gonna call ?

• Having difficulty accessing a fund or org?
  Contact Joan Taylor at Ext 6057
• Having difficulty understanding a report contact
  or your Organizations Business Office Contact?
  Each member of the General Accounting Team has an
  assigned set of departments. If you do not know
  who your contact is visit the following link
  located in the Controllers Office Website
• http//www.coloradocollege.edu/business/GL/documen
  ts/GLTeamorglistrev4_04_08.xls
• If you have found a discrepancy - contact your
  Organizations Business Office Contact

33
Controllers Office Websitehttp//www.coloradocol
lege.edu/business/controller/

• ePrint Power Point Presentation
• Business Office Contact
• List of Accounts
• Travel Policy
• Wire Transfer Information
• Business Office 07 Fall Workshop Presentations

34
General Accounting Team

• Lori Peck, Asst. Controller Ext 6161
• Joan Taylor, Senior Accountant Ext 6057
• Staff Accountant, TBD

35
Any Questions You May Have