Excel energy spreadsheet

Small Business Energy Tracker

Track usage across sites or meters, separate VAT and keep tidy records for budgeting and bookkeeping.

All spreadsheets

FileHomeInsertFormulas

A1fxSites

Sites worksheet

Your electricity, organised

PeriodYour readingsYour costs

January——

February——

March——

April——

May——

June——

Unit rates and standing charges: your own figures

Illustrative layout preview — not a screenshot of the finished workbook.

Sole traders & small businesses

A clearer view of your energy spending

Organise electricity records across your premises without losing sight of individual meters. Separate net costs and VAT, compare sites and prepare a monthly view for your own budgeting and bookkeeping.

Multiple meters or premises
VAT and net cost columns
Cost per site breakdown
Printable monthly report

£12.99One-time purchase · no subscription

I expressly consent to receiving the digital download immediately after purchase and acknowledge that I lose my 14-day cancellation right once the digital content supply begins.

I accept the Terms & Conditions.

Your statutory rights for faulty or misdescribed content remain. Refund Policy · Privacy Policy

Secure checkout · digital download

Download contents

One commercial-release Excel workbook (.xlsx), available immediately after a successful payment.

Sites worksheet
Meters worksheet
Costs worksheet
Report worksheet

Microsoft Excel compatibility

Supplied in Microsoft Excel’s .xlsx format. Microsoft Excel is not included. Compatibility with specific Excel versions on Windows and Mac is not yet verified.

Charts and formulas in other spreadsheet apps may behave differently; compatibility is not yet verified.

Made for sole traders & small businesses

Use your own readings, electricity unit rates and standing charges. Keep the workbook on your device and update it as your circumstances change.

Estimates are for planning, not a replacement for your supplier’s bill or professional advice.