ethority power & purpose
DESCRIPTION
eThority Power & Purpose . Presented by: Candice Hastings – Accounting Manager, Clinical Sciences, CVMBS Jessica Fuentes - CVMBS Finance & Strategic Services Clint Brown – CVMBS Finance & Strategic Services. What is eThority ?. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/1.jpg)
eThority Power & Purpose
Presented by:
Candice Hastings – Accounting Manager, Clinical Sciences, CVMBSJessica Fuentes - CVMBS Finance & Strategic Services
Clint Brown – CVMBS Finance & Strategic Services
![Page 2: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/2.jpg)
What is eThority?
• eThority is the bridge between complex data sources and easy to understand user interfaces. Customizable so it is easily able to satisfy the needs of users simply wanting to access standard reports, or for users who require extensive data mining and report generation capabilities.
![Page 3: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/3.jpg)
Survey Results
![Page 4: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/4.jpg)
Benefits of eThority• Costs vs. Vista for reconciliation purposes
• University wide resources of actual daily users• Give PI’s up-to-date information on their spending• Know status of project accounts ending• Much easier to manipulate than other reporting tools. • Contains financial and HR information• Create reports for historic, current or future predictions• Can use as a trigger tool
Total Cost Per month
Vista
Total Cost per
month eThority
Total Cost Per Year
Vista
Total Cost per Year eThority
eThority Savings
$ 826.26 $ 523.59 $ 9,915.07 $ 6,283.05 37%
![Page 5: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/5.jpg)
What do you use?
• What reports do you currently use for:– Reconciliation– Financial reporting/analysis– HR needs– Transactions– Research details
![Page 6: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/6.jpg)
What will I learn?
• what reports are currently available• why and how a user can utilize the information• a good jump off point to create your own
reports • and a navigation of the more complex tools
available in eThority– Dashboards, graphing, variance mapping,
SuperPivot
![Page 7: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/7.jpg)
Reports• Current Reconciliation Reports
– Account Balance Summary and Account Detail Prior Month • Budget or Cash• Current or Previous FY’s
• Projects with balance >$10k ending next 90 days• Trigger
– I-9 Expiration– Appointment end dates in next 90 days– Use of restricted object codes– Revenue/expense on sub funds
• Auto reports– GENOP/RECHAR end of month balances– 13/14/16 monthly balances– Auto Charges – weekly
• FRS Data (2004-2009)
![Page 8: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/8.jpg)
Budget Summary
![Page 9: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/9.jpg)
Budget Detail
![Page 10: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/10.jpg)
Cash Summary
![Page 11: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/11.jpg)
Cash Detail
![Page 12: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/12.jpg)
Transaction Detail
![Page 13: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/13.jpg)
Project ending 90 days > $10k avail
![Page 14: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/14.jpg)
Auto Report ExampleI-9 Expiration next 3 months
Report is emailed every month at the beginning of the month.
![Page 15: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/15.jpg)
Auto Report ExampleObject Code 6615
Report is emailed every month at the beginning of the month.
![Page 16: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/16.jpg)
Trigger Report ExampleExternal Revenue on DCESUP Accts
Report is emailed when a trigger is set. In this case, nothing would happen, because there are no transactions.
![Page 17: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/17.jpg)
RECHAR Example
![Page 18: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/18.jpg)
FRS Data
![Page 19: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/19.jpg)
Utilizing eThority
How would we create a projection of expense report…1. Open up PDI Dept Acct Projection2. Choose a department account (budget based)3. What we see now:
1. Current Budget2. Actual Exp through 11/30/113. Roll Forward Limit at 6/30/12
Let’s Create a Powerfield…
![Page 20: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/20.jpg)
PowerFields
What is our Average Monthly Expense?
1. Powerfields2. Add eXpression PowerField
![Page 21: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/21.jpg)
PowerFields
1. Field Name: Avg Mo Exp2. Data Type: Currency3. Use this Expression – Edit
![Page 22: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/22.jpg)
PowerFields
1. Column Name = Actual2. User Values – Custom Value = 53. Change sign to /4. Click OK
![Page 23: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/23.jpg)
PowerFields
1. Click Test2. Once receive “The expression syntax is valid”
click OK and Click Save
![Page 24: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/24.jpg)
PowerFieldWhat is our yearly projected expenses?1. Follow the same steps previously to create a
PowerField that determines your Projected expenses for the current fiscal year.
![Page 25: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/25.jpg)
PowerFieldsWhat is the Over/Under Budget?1. Follow the same steps previously to create a
PowerField that determines your Over/Under Budget
![Page 26: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/26.jpg)
How can eThority work for YOU?
![Page 27: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/27.jpg)
Launch Points
– Any of the before mentioned reports would be good launch points
– Looking for non-detail? Try the summary based root data books, KFS – Account Balance Summary
– Let us know if you have any ideas for root data books
– If your feeling lost, stuck, overwhelmed, ask for help
![Page 28: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/28.jpg)
Advanced Tools
– Dashboards– Graphing– Variance Mapping– SuperPivot
![Page 29: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/29.jpg)
Cost Center 43 Revenue Dashboard
SuperPivot
Graphs
Table eXcerpt
![Page 30: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/30.jpg)
![Page 31: eThority Power & Purpose](https://reader036.vdocuments.us/reader036/viewer/2022062501/56815f27550346895dcdf35a/html5/thumbnails/31.jpg)
Contacts
Jessica Fuentes970-491-1931 – [email protected]
Clint Brown970-492-4102 – [email protected]
Missy Hein970-491-7037 – [email protected]
Candice Hastings 970-297-4251 – [email protected]