Shared Utility Cost Allocation – Excel Template

Split a shared electricity, water, gas or cooling bill between units or flatmates by meter reading, area or equal shares, and track who has paid.

• Automatic summary: Units / people, Total allocated, Collected, Still to collect
• Calculated for you: Usage, Share %, Share of bill, Status
• Drop-down menus for quick, consistent entry
• Colour-coded status and progress highlights
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.