Measuring environmental performance doesn’t require sophisticated software or environmental expertise. It requires tracking the right metrics consistently over time and using that data to drive practical improvements. This free Excel template gives you a complete system for monitoring energy, water, waste, and transport consumption at your business.

What’s Included in the Tracker

This ready-to-use spreadsheet includes six worksheets designed specifically for small and medium enterprises:

Business Details – Document which site the tracker covers, who’s responsible for updates, baseline periods, and key environmental objectives. This transforms the spreadsheet from a simple tool into a formal management system that demonstrates systematic environmental performance monitoring to auditors and customers.

Instructions – Clear guidance on how to use the tracker, color-coding system, and tips for success. Everything you need to get started is explained on this tab.

Energy Tracking – Monitor electricity and gas consumption with automatic calculations showing variance against your baseline. Includes space for 24 months of data, summary calculations for 12-month averages, and target-setting fields.

Water Tracking – Record water supply volumes and costs, track changes against baseline, and monitor trends over time. Particularly valuable for businesses with significant water consumption or facing rising water costs.

Waste Tracking – Measure general waste, recycling, and organic waste separately. Automatic calculations show your total waste volumes and landfill percentage, helping you identify opportunities for waste diversion and cost reduction.

Transport/Fuel Tracking – Track fuel consumption, distance traveled, and efficiency (liters per 100km). Essential for businesses operating vehicle fleets or depending heavily on freight.

Summary Dashboard – View all key performance indicators in one place, showing current 12-month averages against baselines and percentage changes. This single-page summary is perfect for management reporting or quick performance reviews.

How to Use This Tracker

Step 1: Complete Business Details

Fill in your company information, site details, and who’s responsible for maintaining the tracker. Set your baseline period (typically your most recent 12 months of data) and define your review frequency.

Step 2: Enter Baseline Data

Go to each tracking sheet and enter your baseline information at the top. This is typically your average monthly consumption from the previous year. If you don’t have 12 months of historical data, use at least 3 months to establish a reasonable starting point.

Step 3: Record Monthly Data

Each month, enter consumption figures from your utility bills or monitoring systems in the blue cells. The spreadsheet automatically calculates totals, variances, and percentages. Use the notes column to document context – weather events, operational changes, facility shutdowns, or anything else affecting that month’s consumption.

Step 4: Review Quarterly

Every three months, review the summary section at the bottom of each sheet and the Summary Dashboard. Look for trends, investigate anomalies, and identify opportunities for improvement. Quarterly reviews provide sufficient frequency to catch problems without creating excessive administrative burden.

Key Features

Color-Coded for Simplicity – Blue text indicates where you enter data. Black text shows automatic calculations that you don’t edit. This visual system prevents accidental formula deletion and makes data entry foolproof.

Built-In Formulas – All calculations happen automatically. Totals, averages, percentages, and variances update as you enter monthly data. No manual calculations required.

Professional Formatting – Ready to use immediately with clear headers, organized layouts, and proper number formatting. Suitable for presenting to management or including in compliance documentation.

Scalable System – Start with the metrics most relevant to your business. You don’t need to track everything immediately. Many businesses begin with just energy and waste, adding water and transport tracking as their system matures.

Getting the Most Value

This tracker works best when someone owns responsibility for monthly updates. Set a recurring calendar reminder to enter data from utility bills. The actual data entry takes less than 10 minutes per month once you establish the routine.

Don’t worry about perfect data initially. Start tracking with the information you have, refine your data collection methods over time, and adjust your baseline if you later discover it was based on incomplete information.

The real value comes from consistent tracking over time, not from perfect data on day one. Businesses that measure environmental performance systematically identify improvement opportunities that businesses operating without measurement simply miss.

Supporting Resources

For detailed guidance on environmental measurement, baseline setting, target development, and using your data to drive improvements, see our comprehensive guide: How to Measure Your Environmental Performance: Simple Metrics for SMEs.

The tracker provides the system. The guide explains the strategy. Together they give you everything needed to implement effective environmental performance measurement at your business.

Related Resources

Setting Realistic Environmental Objectives for Small Businesses Once you’ve established measurement systems, translate your data into meaningful objectives.

5 Environmental Quick Wins That Save Money Use your measurement data to identify these practical improvements that deliver financial returns.

Environmental Record Keeping: What to Save and For How Long Your measurement data needs proper documentation and retention for compliance purposes.