Finance Software Upgrade Project Update

The upgraded financial system went live on Monday, January 28. The project was to upgrade our severely out-of-date IFAS (Version 7.7) software to the most current version, called One Solution (Version 16.2). The older version was no longer supported by the vendor, difficult to use, and had limited reporting capabilities. There have been a few bumps along the road, including the sale of the software company twice over the implementation period along, with a change in Health District staffing with the departure of Judy Chapman and Dan LeFree and hiring of Rich Son and me.

What we’ve gained: 

• A more stable, cloud-based application that is easier to use

• The ability to develop more transparent reporting packages and dashboards

• Electronic timecards and employee self-service for updating HR and Payroll information such as W-4s, addresses

• Online employee access to pay stubs and W-2s.

Cash and Investments at November 30, 2018

Cash                                       $490,830 

Investments                           $8,526,995, comprised of

• $6.0 million – State of Washington Local Government Investment Pool

• $2.5 million – Snohomish County Investment Pool

Unrealized Gain or Loss on Investments     ($15,512)

At the end of each year, Snohomish County provides the District with an analysis of unrealized gain or loss for the County’s investment pool. As part of our year-end closing process, we recorded the unrealized loss of $15,512 for the pool as of December 31, 2017. The unrealized gain/loss figures for 2018 have not been received from Snohomish County as of the report date. 

Calendar Year Operations through November 30, 2018

The District remains on track with the 2018 budget. 

Revenues – Actual revenues District-wide are 2.6% above projections at 94.3% with 91.7% of the year elapsed.  Although revenues remain ahead of budget, you can see the effect of the influx of revenue from the July second installment of the State Public Health Assistance funds of $1.7 million starts to shrink as we move closer to year-end.   

Administration                               92.93% of budget 

Prevention                                   114.92% of budget

Environmental Health                   83.36% of budget

PHEPR                                         79.75% of budget

Expenditures – Actual expenditures District-wide are 3.3% below projections at 88.4% with 91.7% of the year elapsed.

Administration                             89.1% of budget     

Prevention                                   88.5% of budget

Environmental Health                 90.8% of budget

PHEPR                                       69.7% of budget

Fund Balance

SHD’s General Fund Balance is comprised of the following amounts as of November 30, 2018:

Non-spendable items are comprised of Vital Statistics Fees due to the State of Washington that are remitted quarterly and some payroll related accruals.

No action required. Briefing only.