Financial Managers Council Agenda Updates
This content showcases updates from the Financial Managers Council meeting, focusing on eSupplier portal, finance BI dashboards, and project costing. The agenda covers topics such as beginning balances, accounts payable, revenue budgets, and more.
Uploaded on Mar 21, 2025 | 0 Views
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Financial Managers Council April 11, 2017 3/21/2025 1
Agenda STAR Updates Form 78 Beginning Balance eSupplier Portal Finance BI Dashboards User Groups: Project Costing Accounts Payable Updates Year-End Revenue Budgets GL Spreadsheet Uploader 3/21/2025 2
Agenda STAR Updates Form 78 Beginning Balance eSupplier Portal Finance BI Dashboards User Groups: Project Costing Accounts Payable Updates Year-End Revenue Budgets GL Spreadsheet Uploader 3/21/2025 3
Form 78 Beginning Balance Beginning Balance = +Period 0 Equity - Period 0 Accounts Receivable Current FY Revenue = + Current Revenue - Current Accounts Receivable The New Revenue would be replaced with the KK Collected Revenue if we get that fixed. Contact SCO if you have a concern about differences in an appropriation. 3/21/2025 4
Agenda STAR Updates Form 78 Beginning Balance eSupplier Portal Finance BI Dashboards User Groups: Project Costing Accounts Payable Updates Year-End Revenue Budgets GL Spreadsheet Uploader 3/21/2025 5
eSupplier Update Supplier Portal ( eSupplier ) pilot will launch in Spring 2017! Pilot will include: Invitation-based rollout to select suppliers Target suppliers with emails, open contracts, & ACH payment method Features: Registration via WAMS Inquiry access to see their open POs, invoices, payment details Future phases: Bidder integration Self-Service Supplier information updates 2/07/2017 6
eSupplier: Login Page Suppliers will receive email invitation and will setup or use an existing WAMS account. 3/21/2025 7
eSupplier: Home Page Pagelets allow Supplier to drill into supporting transaction and contacts information 3/21/2025 8
Agenda STAR Updates Form 78 Beginning Balance eSupplier Portal Finance BI Dashboards User Groups: Project Costing Accounts Payable Updates Year-End Revenue Budgets GL Spreadsheet Uploader 3/21/2025 9
BI Finance Dashboards 3/21/2025 10
BI Dashboards Agencies currently testing in UAT. Access based on Security. Agencies will need to consider who should have access to production. Data is as of the previous day. Dashboards based on DOC, so not all ChartFields were initially available. BI Team expanding that this week. April 17 goal for go-live. May be a little later. 3/21/2025 11
Agenda STAR Updates Form 78 Beginning Balance eSupplier Portal Finance BI Dashboards User Groups: Project Costing Accounts Payable Updates Year-End Revenue Budgets GL Spreadsheet Uploader 3/21/2025 12
PC User Groups Approved Project Status Configuration FINAL PROJECT STATUS CONFIGURATION - PCUG 3/22/17 Appears in Other Modules** Expense Entry AR Direct Journals Status Requisitions Purchasing AP Entry Billing AR Maintenance Journals Time Entry* Pending Y N Y Y N N N N N N Active Y Y Y Y Y Y Y Y Y Y Hold N N N N N N N N N N Closeout Y W N COM=W. CCA, CRV = Y Y Y Y Y Y N Reconciliation Y N N N N Y Y Y W N Closed N N N N N N N N N N Cancelled N N N N N N N N N N Pre-Award Y Y Y Y Y N N N Y Y Audit Y N N N N N N N W N N = Reject Y = Allows W = Warning FAC approved 4/6/2017 Implementation target date May 1st 04/05/2017 13
PC User Group Approved Account Code Control Allows account codes (Asset, Revenue, Expense, Liability, Equity) to be used with specific analysis types. GLE = Expenses GLR = Revenues GLB = Balance Sheet, Equity, Liability CNE = Expense CNR = Revenue PAY = Expense Will significantly reduce errors in project costing by tying analysis type to account code. PCUG Approved 4/5/2017 & FAC Approved 4/6/2017 Implementation target date May 1st 04/05/2017 14
PC Reconciliation Template Is available for agencies to use (see your PC User Group Rep. Also on Sharepoint in PCUG). PC User Group is discussing final tweaks. Goal = Create this report in Nvision so agencies can run as needed by project. Project and GL data are life-to-date (unable to query by date or FY) Reconciles Projects by: Analysis Type PC to GL/GL to PC Will also reconcile by Appropriation and Allotment line with drill down capabilities to account code. 3/22/2017 15
AP Payment Request Enhanced Workflow Proposal Proposed New Workflow that allows the request to be sent back to the Requester for updates/cancellation Agencies tested Tuesday 4/4/17 Feedback was very positive. Next steps: Develop an implementation plan for approval by the User Group and FAC. 04/05/2017 16
Agenda STAR Updates Form 78 Beginning Balance eSupplier Portal Finance BI Dashboards User Groups: Project Costing Accounts Payable Updates Year-End Revenue Budgets GL Spreadsheet Uploader 3/21/2025 17
Year End Activities Related to Budget (I) Informational or (A) Action Required Business Function Day Date Task FY2018 Department trees created with effective dates Response due to SCO regarding FY2018 option for operating budget load. Initialize Budget Definitions for Effective Date 7/1/2017 Agencies can begin entering FY2018 operating budgets (No change to definition.) FY2018 $0 Appropriation Load FY2018 operating budget load based on agency responses Last day to submit changes to FY2018 operating budget definitions Friday 4/7/2017 I Budget Friday 4/14/2017 A Budget Friday 4/14/2017 A Budget Monday 4/17/2017 Friday 4/21/2017 I I Budget Budget Friday 4/28/2017 I Budget Friday 4/28/2017 A Budget 3/21/2025 18
Revenue KK Ledger Revenue Commitment Control Accounting Still working with Oracle. STAR Dev Team working on an interim solution. Oracle understands the issue now and is working on a solution. This is as of Friday, April 7, 2017 Update: Harris had a meeting with Oracle reps on Friday. Oracle has been explained and demonstrated the bug. They are now working their Development to see one of the following three options: Add the KK_AMOUNT_TYPE field to the TRA_ACCTG_LINE Record Review the PeopleCode for logic in terms of why system is not allowing for Treasury Journals to have Collected Revenue in drop-down. It could be a faulty logic as well. Discuss the workaround STAR has by creating a view. Oracle ticket will remain critical (highest priority) and they will work with development to suggest next steps and timeline. At this time, Oracle has stated that it seems to be a bug in system. 3/21/2025 19
GL Journal Spreadsheet Uploader GL Journal Uploader New uploader working. Fix moved into production. Home > Interface Documentation > Release 1 Finance and Procurement > GL_INT_007 3/21/2025 20
Questions Questions? 3/21/2025 21
Thank you for your time and attention!!! For additional information: STAR Connection: STARConnection.wi.gov STAR Project SharePoint site: https://webapps.wi.gov/sites/ERP/default.aspx STAR Project Mailbox: starproject@wisconsin.gov 3/21/2025 22
