It is the last business day of the month. You run a one-person design studio out of a spare room, and your bookkeeper wants September closed by Friday.
The City Electric PDF is in your work email. The internet bill went to the personal Gmail you signed up with years ago. The water bill is a paper slip under a magnet on the fridge. The phone autopay confirmation landed in an inbox you check twice a year. Eventually all of it gets dragged into a Drive folder named Utilities, and that feels like progress.
It isn't reporting. A folder can't tell you what September cost. When the bookkeeper's variance check flags electric as higher than August, you open PDFs one by one to find out why, and you still can't say whether that number included last month's balance.
What is utility expense reporting?
Utility expense reporting means turning every recurring service bill (electric, gas, water, internet, trash, phone) into one row with the same fields: date, vendor, total, tax, category, and where the bill came from. To track utility bills, log each one as a row when it arrives, then filter and total the month. The report is the filtered rows, not a folder of PDFs.
Why isn't a utility expense template enough?
Search for a utility expense template and you'll find spreadsheets with sixteen columns or more: account number, service address, billing period start, billing period end, amount before tax, payment method, deductible amount, notes. Each one made sense to somebody. Together they turn a two-minute job into a form you put off.
The template also assumes the hard part is the layout. It isn't. The hard part is getting bills from four different places into one shape, every month. A blank grid doesn't do that. A habit does: a bill arrives, a row gets written, the source file stays attached.
Six columns are enough to report on. Anything else, like an account number or kilowatt-hours used, can stay on the source document the row points to.
What does a month of utility rows look like?
Here is an invented September for a home-based studio. Seven bills, four kinds of source, one shape.
| date | vendor | total | tax | category | source |
|---|---|---|---|---|---|
| 2026-09-03 | City Electric Co. | $186.42 | $12.14 | Utilities / electric | email PDF |
| 2026-09-05 | Metro Gas | $54.10 | $3.52 | Utilities / gas | email PDF |
| 2026-09-08 | Municipal Water | $41.75 | $0.00 | Utilities / water | phone photo |
| 2026-09-12 | FiberNet Internet | $89.99 | $7.42 | Utilities / internet | forwarded email |
| 2026-09-15 | Ridgeline Waste Services | $38.60 | $2.31 | Utilities / trash | phone photo |
| 2026-09-20 | MobileCo | $72.00 | $5.94 | Utilities / phone | autopay confirmation |
| 2026-09-24 | Relay Voice (studio line) | $24.99 | $3.18 | Utilities / phone | forwarded email |
| September | 7 bills | $507.85 | $34.51 |
Filter Utilities / phone and you get both lines, $96.99 together. Filter the source column for phone photo and you see which two bills exist only as pictures of paper. Sum the total column and September comes to $507.85, $34.51 of it tax.
The rule is short: one bill is one row, and utility type is a category, not a second file tree. No Utilities/Electric/2026 subfolders. The category column does that job, for every month at once.
How much of a bill counts as business use is a separate question. If you work from home, the home-office split or business-use percentage is a field you decide and record yourself, usually with your accountant. This page is the ledger, not tax advice. The ledger only makes sure that when you apply a percentage, you apply it to the right numbers.
Why doesn't the bank feed count as a utility report?
Your bank or card feed proves money left the account. That matters, and it's where you reconcile. But a feed line like CITY ELEC AUTOPAY 186.42 is missing most of what a utility report needs:
- Billing period. A payment on the 3rd might cover service from mid-July to mid-August. The feed only knows the day it cleared.
- Service address. If you pay for a home and a small studio, both electric charges look the same.
- Taxes and fees. The feed shows one amount. The tax line is on the bill.
- What the amount actually is. After a short or late payment, one payment can blend the prior balance with the current bill. The feed can't pull them apart.
Keep the feed for reconciliation. Build the rows from the bills. It's the same argument as a card statement is not a receipt, applied to things that bill you every month.
Why are utility bills harder to read than receipts?
A coffee receipt has one total. A utility PDF has five or six numbers that look like one: current charges, previous balance, payment received, delivery or distribution charges, taxes and surcharges, and sometimes a credit. The amount due can sit below the month's charges because of a credit, or above them because of a carried balance.
Run a bill like that through plain OCR and every one of those numbers comes back as text, with nothing to say which belongs in the total column. The row you want is this period's charge and its tax, not whichever amount is printed largest.
Tax is where extraction slips first. In a Q2 2026 test of 20 receipts with Tesseract OCR, vendor was right 95% of the time and date and total 100%, but tax only 60%, and all four fields were correct on just 55%. Those were simple receipts. A utility bill puts more amounts on the page, not fewer.
So review isn't optional. It's the step where you assign the utility category and check the tax against the bill, before anything is exported.
Slipsheet is built around that step. Photograph the paper water bill, upload the electric PDF, or forward the autopay email to receipts@slipsheet.app. Each one becomes a row you review, with date, vendor, total, tax, and the utility category you set. Then export the month as a CSV or send it to Google Sheets. The file is yours.
A few straight answers
Do I need a utility expense template?
You need six consistent columns: date, vendor, total, tax, category, and source. Any spreadsheet with those headers works. A template with sixteen columns mostly adds fields you will leave blank.
Should I track utilities monthly or by billing period?
Report by month and date each row by the bill date, so utilities close on the same rhythm as everything else. Billing periods rarely match calendar months, so the period stays on the source bill. If your accountant wants costs matched to service dates, that is one extra column, not a new system.
How do I track utility bills that arrive on paper?
Take a flat, well-lit photo the day the bill arrives and log it as a row with phone photo as the source. (Getting a clean photo is its own short post.) The paper can go in a drawer. The row is what shows up in the report.
Can I include home-office utilities?
Log the full bill as the row. The business-use share is a decision you make, ideally with your accountant, and record on its own. Keeping the full amount on the row means any split is applied to the real number.