90 likes | 337 Views
Utility Bill Management County of Ventura. by Bruce Fischer Energy Manager County of Ventura. County of Ventura Utility Bill Overview. Electricity 1 company 502 accounts. Water 26 companies 301 accounts. Sewer 11 Companies 192 accounts. Natural Gas 1 company 114 accounts. PPA
E N D
Utility Bill ManagementCounty of Ventura by Bruce Fischer Energy Manager County of Ventura
County of Ventura Utility Bill Overview Electricity 1 company 502 accounts Water 26 companies 301 accounts Sewer 11 Companies 192 accounts Natural Gas 1 company 114 accounts PPA 1 company 3 accounts
How we used to do it All utility bills received by accounting department Consumption and cost manually entered into database Bill processed for payment Once a month database uploaded as “read only” Issues Consumption data could be two months old Manual process took a lot of time; occasional errors in data entry If copies of bills are needed, bill is retrieved, scanned and e:mailed To conduct spreadsheet analysis had to re-enter data manually
HOW WE DO IT NOW • All utility bills sent to contractor • Contractor scans bills and creates virtual (summary) bill • Contractor analyses bill in relation to previous bills • Notifies County if a bill seems inconsistent BENEFITS • Bills available for viewing within a couple of days of receipt • Provides some analytical tools to • Review trends and building–to–building comparisons • All data available to download into Excel • Uploads data into County Financial Management system
669 County Square Drive 15-minute kw Demand
669 County Square Drive Adjusted start times for equipment to reduce spikes 15-minute kw Demand
Contact Information Bruce Fischer Energy Manager County of Ventura (805) 477-1596 bruce.fischer@ventura.org