Transcription
EPSi Navigation and OverviewPresented by Finance Operations SupportJune 20171
Agenda EPSi Dashboard and Applications Navigation»Hierarchies Sidebar»Dashboard Reports Summary Income Statements (GL 001 MTD/YTD, GL 002 12 Month Trend) Utilization Reports (GL 040 MTD/YTD, GL 041 12Month Trend)»Labor Distribution Report»Accounts Payable Report»Viewing Prior Period Reports»Reports/Drilldowns/Cubes Sidebar Using Drilldown Links»Cost Centers/Sub Accounts»Breadcrumb Path»View Sub Ledger Transactions – Accounts Payable, Journal Entry, MaterialsManagement Applications Button»Budget Manager Variance Analysis Tab and Notes Q & A2
Logging In Obtain EPSi by submitting anIT Security Access Request» Provide role and list of cost centers» Directors and above are granted GL and Payroll Access» Access for all others is by special request and approval(Managers, Supervisors, Leads Coordinators, BusinessAnalysts) Click on the EPSI Link on MCHSnetPortal Applications column Click on the star to make EPSi a favorite Enter your network User ID and password3
EPSi Landing Page DashboardsDefault landing page dashboards show the Summary Income Statement and Utilizationreports4
EPSI Dashboard ReportsFour landing page dashboards GL 001 – Summary Income Statement (most recent month-end)oStatement that reports financial performance for the month and year-to-date. Summary ofRevenues, Deductions and Expenses through both operating and non-operating activities.Sometimes referred to as the Profit and Loss (P&L). GL 002 – 12-month Trend of Income Statement GL 040 – Utilization Reports (most recent month-end)o Key Hospital volume statistics GL 041 – 12-month Trend of Utilization ReportOther Dashboard Reports Labor Distribution Report (most recent pay period) Accounts Payable Report5
Hierarchies – Facilities/Division/Cost Centers Click on the left sidebar“Facilities/Division/Cost Center”to open and close the DivisionHierarchies. The sidebarhighlights orange with mouseover. Choose a Division View fromthe list, Facility or Management. Click on a Facility or a ManagerName: SVP, VP, Admin Dir, Dir. Individual cost centers appearin the bottom half of thenavigation pane. Scroll and click to select asingle cost center. Vertical sidebar indicates levelof selection.6
GL 001 Summary Income Statement - most recent MTD/YTDMaximize/RestorePrint Default is the current month closing period Month changes to the next closing period on day 15Export to Excel7
GL 002 Summary Income Statement – 12 Month Trend Default Year is ACTUAL2017 Choose a different year from the Year list8
GL 040 Utilization Report Hospital Key Statistics9
GL 041 Utilization Report – 12 Month Trend Default Year is ACTUAL2017 Choose a different year from the Year list.10
Labor Distribution Report – Cube Most Recent Pay Period Work In Progress – validating to Lawson Payroll; confirming whetherincludes Float-Ins Can filter and modify fields. Print/Export to Excel11
Accounts Payable Report Default view is PDF. Can select Excel Spreadsheet to export. Open,Save, or Save As. Result is formatted, not tabular record layout.12
Viewing a prior month period report Choose a prior month-Year13
Selecting a prior period report from the Reports sidebar Open the Reports/Drilldowns/Cubes sidebar. Distributed Reports is selected by default. Select year, month, and report. Mouse-over shows refresh date If report name is blue, click to open NOTE: no indication of division/cost center/month. Write on print out, or include identifyinginformation in Save As name,14
Drilldown LinksBlue line itemshave thecapability of drilldown15
Drilldown FunctionalityDrilldown to:Cost CenterAccountSub AccountTransaction LevelFurther drill-down to transaction level:1. Accounts Payable Sub ledger2. GL Journal Entry3. Material Management transactions (Purchase Orders, InventoryControl)Note: Blue line items drill-down detail to cost centers or accounts16
GL 001- Summary Income StatementDrilldown – Cost Center or Subaccount level Choose Cost Center or Sub Account.Bread crumb path to return one level or jump to Home report.17
GL 001- Summary Income StatementDrilldown – Sub Ledger Detail for AP, Journal Entry, Materials Management Select Sub Ledger Category, Year, Beginning/End MonthsClick Refresh18
Applications Button Click on the Applications button toselect various modules. Click on My Portal tab to return todashboards and Applications Button19
Budget Manager – Variance Analysis and Notes Click on the Budget Manager button. If security include 4 or more cost centers, select from the list. Press the F3 key on the keyboard to open a search box20
Variance Analysis and Notes Track Statistics, Expenses, and Revenue. Drill into Sub Ledger Detail. Choose Month, Year, or Month and YTD from the Display In Grid list. Click Refresh. Click on column heading to sort, one-click for A-Z, two-clicks for Z-A. Or select “Threshold Only.” Hide graph by clicking on downward triangle.21
Variance Analysis and Notes Investigate 70300000 Casual Labor22
Lawson GL90 Transaction Analysis Obtain additional information from Lawson GL90 and GL95 Transaction Analysis 7030-0000 Casual Labor Hours – filter for units.23
Variance Analysis and Notes Once the reasons for the variance aredetermined, enter a Note. Quantify the variance – Hours, Dollars,Duration Notes are date/time stamped with UserID Can add additional text to an existingnote Address Year-to-Date Variances24
Q & A/ Contacts Questions? Contacts» Finance & Accounting – list of contacts on Accounting Department site» Finance Operations Support – portal site in development»Karla Medina, Director Finance Operations Support x5790»Astrid Weinkle, Budget/Financial Planning Analyst x5764 Thank you!25
Definitions Budget – a future forecast of anticipated volumes, expenses, revenuesand deductions, based on historical trends and long-range and strategicfinancial plans. Actual – the actual reported dollars and units for the volumes, expenses,revenues and deductions for the prior month period (MTD) and cumulativeyear-to-date (YTD). Variance – the difference between actual compared to budget. A variancecan be favorable, for example if actual expenses are lower than budgeted,or if revenue is higher, or unfavorable if expenses are higher, or revenuelower. Threshold – the percent of variance tolerance that triggers a need toinvestigate and explain why the variance occurred.»Expenses - 5% or 5,000 over budget»Revenue - 5% or 5,000 under budget»Volume 5% under26
Obtain EPSi by submitting an IT Security Access Request »Provide role and list of cost centers »Directors and above are granted GL and Payroll Access »Access for all others is by special request and approval (Managers, Supervisors, Leads Coordinators, Business Analysts) Cli
