Daily Utilities Tracker: Electricity, Water, Gas & Diesel:
In almost every business the utility costs of the business forms core part of the business expenses. These costs are ones we can't avoid and it is very essential to ensure that the management stay on top of this through daily tracking. In most companies these could be tracked and controlled by the Technical Manager / Chief Engineer.
This workbook will help you not only to track daily consumption but as well daily cost of those consumptions. Cumulative totals included in each of the utility categories to ensure as you are proceeding with any given month you consciously are aware of your cumulative utility costs per category for cash flow planning purposes as well as cost containment and cost management.
Average daily costs figures also included to benchmark daily consumptions vs norm daily consumption. This will help the management identify trends where as if the consumption is justified i.e.: in direct relation to the business levels or unjustified whereby it is unusually higher than it should be with possible causes such as water leaks.
This is a very simple template yet super effective as it is very easy to update. All greyed out cells are formularized and do not need to have any inputs in them. Only input key data in the yellow cells to populate your data.
Visual graphs for each utility category included so you can see trends and be able to track each utility category separately.
All the utilities separately and cumulatively add up to a substantial amount as company expenses and this is the main reason why management needs to be on top of their cost control and cost containment activities.
Sit back and relax and be in total control of one of your main company expenses! Hope this template will bring you great benefits.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Expense Tracker Excel: Daily Utilities Tracker Excel (XLSX) Spreadsheet, Excel Templates & Dashboards
![]() |
Download our FREE Organization, Change, & Culture, Templates
Download our free compilation of 50+ slides and templates on Organizational Design, Change Management, and Corporate Culture. Methodologies include ADKAR, Burke-Litwin Change Model, McKinsey 7-S, Competing Values Framework, etc. |