Dept Briefing Book - Finance (Jan-21)

Transcription

FinanceElementScorecardSummary ViewsLanding PageOutcome MeasuresInitiativesMilestonesDetail ViewsAccountabilityTransparencyDepartment InitiativesImplementation of Enterprise SystemDigital RecordsENERGOV - Contract Signed/ProjectKickoffMUNIS FINANCIALS - KickoffMUNIS HR/PAYROLL - HumanResourcesMUNIS HR/PAYROLL - KickoffMUNIS HUMAN RESOURCES/PAYROLL Go Live - PayrollENERGOV - Go LiveMUNIS FINANCIALS - Budget/P-cardManagement/Capital Assets/CashManagementMUNIS FINANCIALS - CashReceipts/Accounts Receivable/GeneralBillingMUNIS FINANCIALS - ProjectManagement & Grant AccountingMUNIS FINANCIALS-Go Live - GeneralLedger/Purchasing/AccountsPayable/Invoice EntryMap Storage AreaDestruction/Shred - AP/AR/CR/MR (17boxes)Destruction/Shred - Timesheets andPayroll Reports

Landing PageFinance Home Scorecard OutcomeMeasuresDepartment Purpose StatementProvide Excellent financial services to the organization and community through accountability and transparency.Department MeasuresObjectivesObj. 5.1: Promote financial integrity through effectivelyand efficiently managing public assetsOutcome MeasuresAccountabilityMorrisvilleObj. 5.3: Require the highest professional standardsMorrisvilleObj. 5.1: Promote financial integrity through effectivelyand efficiently managing public assetsMorrisvilleObj. 5.3: Require the highest professional standardsMorrisvilleTransparency Initiatives Milestones

Department InitiativesObjectivesObj 3.2 Increase awareness ofactivities and opportunities forengagementInitiativesImplementation of EnterpriseSystemInitiative MeasuresENERGOV - Contract Signed/ProjectKickoffMorrisvilleObj. 3.3: Effectively maintain assetsand make the most of existingresourcesMUNIS FINANCIALS - KickoffObj. 5.1: Promote financial integritythrough effectively and efficientlymanaging public assetsMUNIS HR/PAYROLL - HumanResourcesObj. 5.2: Deliver customer-focusedserviceMUNIS HR/PAYROLL - KickoffObj. 5.5: Align priorities withresourcesMUNIS HUMANRESOURCES/PAYROLL - Go Live PayrollObj. 5.6: Leverage the use oftechnology to maximize resultsENERGOV - Go rrisvilleMUNIS FINANCIALS - Budget/P-cardManagement/Capital Assets/CashManagementMUNIS FINANCIALS - CashReceipts/AccountsReceivable/General BillingMUNIS FINANCIALS - ProjectManagement & Grant AccountingMUNIS FINANCIALS-Go Live GeneralLedger/Purchasing/AccountsPayable/Invoice EntryObj. 5.6: Leverage the use oftechnology to maximize resultsDigital RecordsMap Storage AreaMorrisvilleDestruction/Shred - AP/AR/CR/MR(17 boxes)Destruction/Shred - Timesheetsand Payroll Reports

Accountability HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesDescriptionAccountability as measured by our annual financial audit report – with the commitment by staff for no audit findings/corrections.Why It MattersFinance staff does their best to ensure the integrity of the financial records for the Town. An annual audit and CAFR report demonstrate thecommitment to operational excellence.AnalysisCY Q4-20ObjectivesThe Audit RFP was posted online and proposals have beenreceived and reviewed. Town Council is in the process ofawarding a contract soon.Obj. 5.1: Promote financial integrity through effectiv MorrisvilleObj. 5.3: Require the highest professional standardsMorrisvilleCollection and Calculation MethodPreparation of audit schedules and CAFR by finance staff,external review by Cherry Bekaert staffData Collection LeadController/Finance DirectorInitiativesOwnerKBKaren BassData Collection Point(s) of Contact (if needed)Controller/Finance DirectorAccountability as measured by our annual financial audit report (i.e. any audit findings, corrections, etc) to be completed by October 31 of eachyear.

CY Q1-19CY Q2-19CY Q3-19CY Q4-19CY Q1-20CY Q2-20CY Q3-20CY Q4-20CY Q1-21CY Q2-21CY Q3-21ActualOutcome Measure DataPeriodCY Q4-21TargetLast Calculated 39 minutes agoStatusCY Q1-19Not DefinedCY Q2-19Not DefinedCY Q3-19Not DefinedCY Q4-19Not DefinedCY Q1-20Not DefinedCY Q2-20Not DefinedCY Q3-20On TargetCY Q4-20On TargetCY Q1-21Not DefinedCY Q2-21Not DefinedCY Q3-21Not DefinedCY Q4-21Not DefinedActualTarget

Transparency HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesDescriptionTransparency as measured by at least 5 opportunities for the public to review the Town’s financial information annually; i.e. the Town’sannual CAFR, financial reports, budget reports, budget input sessions for citizens, Town Council meetings, Citizen Advisory Committees, andpublic information requests.Why It MattersFinance staff does their best to ensure the integrity of the financial records for the Town. An annual audit and CAFR report demonstrate thecommitment to operational excellence. Staff is also committed to responding to public information requests.AnalysisCY Q4-20ObjectivesThe CAFR is posted on the website along with the FinancialStatement report through December 2020Obj. 5.1: Promote financial integrity through effectiv MorrisvilleObj. 5.3: Require the highest professional standardsMorrisvilleCollection and Calculation MethodPreparation of audit schedules and CAFR by finance staff,external review by Cherry Bekaert staff. Financial reports,budget reports, budget input sessions, Citizen AdvisoryCommittees, Town Council meetings are mechanisms fortransparency of financial dataInitiativesOwnerData Collection LeadKBKaren BassController/Finance DirectorData Collection Point(s) of Contact (if needed)Controller/Finance DirectorTransparency as measured by at least 5 opportunities for the public to review the Town’s financial information annually; i.e. the Town’s annualCAFR,

CY Q1-19CY Q2-19CY Q3-19CY Q4-19CY Q1-20CY Q2-20CY Q3-20CY Q4-20CY Q1-21CY Q2-21CY Q3-21ActualOutcome Measure DataPeriodCY Q4-21TargetLast Calculated 39 minutes agoStatusCY Q1-19Not DefinedCY Q2-19Not DefinedCY Q3-19Not DefinedCY Q4-19Not DefinedCY Q1-20Not DefinedCY Q2-20Not DefinedCY Q3-20On TargetCY Q4-20On TargetCY Q1-21Not DefinedCY Q2-21Not DefinedCY Q3-21Not DefinedCY Q4-21Not DefinedActualTarget

Department Initiatives HomeFinanceObjectivesObj 3.2 Increase awareness ofactivities and opportunities forengagementInitiativesImplementation of Enterprise System Scorecard OutcomeMeasures Initiatives MilestonesInitiative MeasuresENERGOV - Contract Signed/ProjectKickoffMorrisvilleObj. 3.3: Effectively maintain assetsand make the most of existingresourcesMUNIS FINANCIALS - KickoffObj. 5.1: Promote financial integritythrough effectively and efficientlymanaging public assetsMUNIS HR/PAYROLL - HumanResourcesObj. 5.2: Deliver customer-focusedserviceMUNIS HR/PAYROLL - KickoffObj. 5.5: Align priorities with resourcesMUNIS HUMAN RESOURCES/PAYROLL Go Live - PayrollObj. 5.6: Leverage the use oftechnology to maximize resultsENERGOV - Go rrisvilleMUNIS FINANCIALS - Budget/P-cardManagement/Capital Assets/CashManagementMUNIS FINANCIALS - CashReceipts/Accounts Receivable/GeneralBillingMUNIS FINANCIALS - ProjectManagement & Grant AccountingMUNIS FINANCIALS-Go Live - GeneralLedger/Purchasing/AccountsPayable/Invoice EntryObj. 5.6: Leverage the use oftechnology to maximize resultsDigital RecordsMap Storage AreaMorrisvilleDestruction/Shred - AP/AR/CR/MR (17boxes)Destruction/Shred - Timesheets andPayroll Reports

Implementation of Enterprise System HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesTargetMunis by June 30, 2019Energov by July 1, 2019HR/Payroll by July 1, 2020DescriptionImplementation of the new Enterprise System to include Munis, EnerGov, and HR/Payroll Modules.Why It MattersNew ERP System will streamline, automate, and integrate efficient business processes and best practices. It will also enable and empowerusers to become more efficient, productive and responsive. Provide tools to better serve departments to produce and access information ina real-time environment.AnalysisCY Q4-20Multiple Enterprise System project components completed.HR/Payroll component still pending finalization.Percent Complete90 %Start DateObjectives11/30/17Obj 3.2 Increase awareness of activities and opportu MorrisvilleObj. 3.3: Effectively maintain assets and make the m MorrisvilleObj. 5.1: Promote financial integrity through effectiv MorrisvilleObj. 5.2: Deliver customer-focused serviceMorrisvilleObj. 5.5: Align priorities with resourcesMorrisvilleObj. 5.6: Leverage the use of technology to maximize MorrisvilleCollection and Calculation MethodData Collection Point(s) of Contact (if needed)Finance Department StaffEnd Date7/1/21CY Q4-20

Data Collection LeadMilestonesENERGOV - Contract Signed/Project KickoffFinance 11/30/17 - 2/15/18MUNIS FINANCIALS - KickoffFinance 11/30/17 - 2/15/18MUNIS HR/PAYROLL - Human ResourcesFinance 11/30/17 - 7/1/21MUNIS HR/PAYROLL - KickoffFinance 11/30/17 - 3/28/19MUNIS HUMAN RESOURCES/PAYROLL - Go Live - Pa Finance 11/30/17 - 4/1/20ENERGOV - Go LiveFinance 2/15/18 - 9/1/19MUNIS FINANCIALS - Budget/P-card Management/C Finance 2/15/18 - 2/15/19MUNIS FINANCIALS - Cash Receipts/Accounts Receiv Finance 2/15/18 - 1/10/19MUNIS FINANCIALS - Project Management & Grant Finance 2/15/18 - 12/31/19MUNIS FINANCIALS-Go Live - General Ledger/Purch Finance 2/15/18 - 12/3/18OwnerKBKaren BassGantt Chart20172018201920202021Q4 17 Q1 18 Q2 18 Q3 18 Q4 18 Q1 19 Q2 19 Q3 19 Q4 19 Q1 20 Q2 20 Q3 20 Q4 20 Q1 21 Q2 21 Q3 21Name Finance Implementation of Enterprise SystemENERGOV - Contract Signed/Project KickoffMUNIS FINANCIALS - KickoffMUNIS HR/PAYROLL - Human ResourcesMUNIS HR/PAYROLL - KickoffMUNIS HUMAN RESOURCES/PAYROLL - Go Live - PayrollENERGOV - Go LiveMUNIS FINANCIALS - Budget/P-card Management/Capital Assets/Cash ManagementMUNIS FINANCIALS - Cash Receipts/Accounts Receivable/General BillingMUNIS FINANCIALS - Project Management & Grant AccountingMUNIS FINANCIALS-Go Live - General Ledger/Purchasing/Accounts Payable/Invoice Entry

ENERGOV - Contract Signed/Project Kickoff HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20Start Date11/30/17Milestone Percent CompleteCY Q4-20End Date100 %2/15/18InitiativeImplementation of Ente 11/30/17 - 7/1/21CY Q4-20

MUNIS FINANCIALS - Kickoff HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20Start Date11/30/17Milestone Percent CompleteCY Q4-20End Date100 %2/15/18InitiativeImplementation of Ente 11/30/17 - 7/1/21CY Q4-20

MUNIS HR/PAYROLL - Human Resources HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerMilestone AnalysisCY Q4-20Start Date11/30/17Milestone Percent CompleteCY Q4-20End Date75 %7/1/21InitiativeImplementation of Ente 11/30/17 - 7/1/21CY Q4-20

MUNIS HR/PAYROLL - Kickoff HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20Start Date11/30/17Milestone Percent CompleteCY Q4-20End Date100 %3/28/19InitiativeImplementation of Ente 11/30/17 - 7/1/21CY Q4-20

MUNIS HUMAN RESOURCES/PAYROLL - Go Live - Payroll HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20Start Date11/30/17Milestone Percent CompleteCY Q4-20End Date100 %4/1/20InitiativeImplementation of Ente 11/30/17 - 7/1/21CY Q4-20

ENERGOV - Go Live HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20Start Date2/15/18Milestone Percent CompleteCY Q4-20End Date100 %9/1/19InitiativeImplementation of Ente 11/30/17 - 7/1/21CY Q4-20

MUNIS FINANCIALS - Budget/P-card Management/CapitalAssets/Cash Management HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20Start Date2/15/18Milestone Percent CompleteCY Q4-20End Date100 %2/15/19InitiativeImplementation of Ente 11/30/17 - 7/1/21CY Q4-20

MUNIS FINANCIALS - Cash Receipts/AccountsReceivable/General Billing HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20Start Date2/15/18Milestone Percent CompleteCY Q4-20End Date100 %1/10/19InitiativeImplementation of Ente 11/30/17 - 7/1/21CY Q4-20

MUNIS FINANCIALS - Project Management & GrantAccounting HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20Start Date2/15/18Milestone Percent CompleteCY Q4-20End Date100 %12/31/19InitiativeImplementation of Ente 11/30/17 - 7/1/21CY Q4-20

MUNIS FINANCIALS-Go Live - GeneralLedger/Purchasing/Accounts Payable/Invoice Entry HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20Start Date2/15/18Milestone Percent CompleteCY Q4-20End Date100 %12/3/18InitiativeImplementation of Ente 11/30/17 - 7/1/21CY Q4-20

Digital Records HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesTarget50% paper records disposed/destroyed and converted to electronic retention by January 1, 2020DescriptionDigitize financial records required for various retention periodsWhy It MattersThis coincides with the rollout of our new ERP system as the new system will allow for a paperless environment. This will allow the Town tomaximize our facility space by eliminating most of the records we store in the attic; will help save money; will protect the environment byreducing wastes; and will make access and sharing of data easier.AnalysisCY Q4-20project put on hold due to COVID-19 and staff workingremotely.Percent CompleteCY Q4-2050 %Start DateObjectives7/1/18Obj. 5.6: Leverage the use of technology to maximize MorrisvilleEnd DateCollection and Calculation MethodFiles collected from each Finance office and reported semiannually to the Town Clerk's office and destroyed at the Town'sshred event in the Spring and Fall each year.6/30/22MilestonesMap Storage AreaFinance 7/1/18 - 7/5/18Data Collection Point(s) of Contact (if needed)Destruction/Shred - AP/AR/CR/MR (17 boxes)Finance 7/5/18 - 6/1/22Finance Department StaffDestruction/Shred - Timesheets and Payroll ReportsFinance 7/5/18 - 6/1/22Data Collection LeadOwnerKBKaren Bass

Gantt Chart20182019202020212022Q3 18 Q4 18 Q1 19 Q2 19 Q3 19 Q4 19 Q1 20 Q2 20 Q3 20 Q4 20 Q1 21 Q2 21 Q3 21 Q4 21 Q1 22 Q2 22Name Finance Digital RecordsMap Storage AreaDestruction/Shred - AP/AR/CR/MR (17 boxes)Destruction/Shred - Timesheets and Payroll Reports

Map Storage Area HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20the storage area has been mapped outMilestone Percent Complete100 %Start Date7/1/18CY Q4-20End Date7/5/18InitiativeDigital Records7/1/18 - 6/30/22CY Q4-20

Destruction/Shred - AP/AR/CR/MR (17 boxes) HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20changed target date, due to COVID-19 - working remotely andhave not been in the office to finishStart Date7/5/18End DateMilestone Percent CompleteCY Q4-206/1/2250 %InitiativeDigital Records7/1/18 - 6/30/22CY Q4-20

Destruction/Shred - Timesheets and Payroll Reports HomeFinance Scorecard OutcomeMeasures Initiatives MilestonesOwnerNENancy Emslie (Finance)Milestone AnalysisCY Q4-20changed the end date, due to COVID-19 and most staff workingremotely.Start Date7/5/18End DateMilestone Percent CompleteCY Q4-206/1/2250 %InitiativeDigital Records7/1/18 - 6/30/22CY Q4-20

MUNIS HR/PAYROLL - Kickoff Obj. 5.5: Align priorities with resources Morrisville MUNIS HUMAN RESOURCES/PAYROLL - Go Live - Payroll Obj. 5.6: Leverage the use of technology to maximize results Morrisville ENERGOV - Go Live MUNIS FINANCIALS - Budget/P-card Management/Capital Assets/Cash