Monitor cost per page — DIY tracking sheet

Joe B.

Expert ★★★★★ 27,853 satisfied customers

Specialities: Windows 11/10, macOS (Sonoma/Ventura/Monterey), Printers, Print Management, Office Equipment

Cost per page calculator for HP, Epson, Canon, Brother — laser & inkjet

Technician

Hey! Let’s build a simple cost per page calculator and a DIY tracking sheet you can use in Excel/Google Sheets. Tell me your brand/model (HP, Epson, Canon, Brother), whether it’s laser or inkjet, and your cartridge price, page yield, and current page counter. We’ll calculate black-and-white CPP, color CPP, and your real printer running costs.

Customer

Small office here. We have a Brother HL‑L3270CDW (color laser) and an HP OfficeJet Pro 9025e (inkjet). I need a CPP tracking spreadsheet to compare costs, including toner, drum, and the HP ink subscription.

Technician

Perfect mix to compare. Cost per page (CPP) = cartridge price ÷ ISO/IEC page yield. For lasers add drum, and occasionally fuser or maintenance kit to your total cost of ownership (TCO). For inkjets, factor in ink cost per page or your subscription cost. We’ll track real usage with counters so it’s not just brochure math.

Customer

What data do you need to start filling the CPP spreadsheet? I can pull invoices.

Technician

Fields for the DIY tracking sheet:
1) Device (brand/model; laser/inkjet).
2) Cartridge SKU (e.g., Brother TN‑223, HP 962XL).
3) Price paid (OEM vs compatible).
4) ISO page yield (monochrome: ISO/IEC 19752; color: 24711).
5) Start/End page counter or meter read from the printer report.
6) Pages printed this period (end − start).
7) CPP (calculated), monthly print volume, and rolling average.
Optional: paper cost, waste toner, drum unit cost per page, and service kit allocations.

Customer

We mostly print B&W on the Brother and color marketing on the HP. Can the sheet show black vs color cost per page?

Technician

Absolutely. The sheet keeps separate columns for black CPP and color CPP. For color laser, it sums CMYK toner costs based on yield. For inkjet, we log cost per ml or your Instant Ink subscription fee divided by total pages.
You’ll also get a running CPP trend and a printer cost comparison dashboard.

Customer

Where do I find the page counter and consumable yields on each printer?

Technician

Find page counts & yields
• Brother/HP/Epson/Canon web panel: enter the printer’s IP → print or save the usage report.
• On-device menu: Reports → Usage / Configuration to get the total pages and color pages.
• Yields are on the box and support pages under ISO yield. Add drum life (e.g., 12K pages) to allocate a drum cost per page.

Customer

Can the tracking sheet flag when CPP is too high and suggest switching to a different printer or cartridge?

Technician

Yes. We set alert thresholds (e.g., >$0.10 B&W or >$0.30 color). The sheet highlights months that exceed targets and shows
• High‑yield vs standard cartridges savings,
• OEM vs compatible toner impact,
• move jobs to lower‑CPP device suggestions (e.g., long documents to your laser),
• and a simple TCO calculator for a replacement printer.

Customer

We print about 2,500 pages/month. What’s a good CPP benchmark for that volume?

Technician

Typical small‑office targets:
• Laser B&W: $0.015–$0.03 per page (toner + drum).
• Laser color: $0.08–$0.20 per page depending on coverage.
• Inkjet office (XL tanks/subscriptions): $0.02–$0.08 B&W; $0.06–$0.15 color.
Your tracking sheet will surface your real cost so you can route jobs smartly.

Customer

Do we include paper cost and service kits in the CPP, or just cartridges?

Technician

We’ll track both: Consumables CPP (cartridges, drums, waste toner, maintenance kit allocation) and optional All‑in CPP (adds paper and service). That keeps reporting clean while giving finance a true printing cost analysis.

Customer

Great. Could you summarize steps so my team can start logging right away?

Technician

Quick start — DIY CPP tracking sheet
1) Add each device on its own row with model, cartridge SKU, price, ISO yield.
2) Record start meter today; set a monthly reminder to capture end meter.
3) Enter cartridges purchased and assign them to a device/month.
4) The sheet auto‑calculates CPP, monthly volume, and rolling averages with a dashboard to compare printer costs.
Need help? Open the chat and I’ll customize it.

Customer

Awesome — send the template and we’ll start tracking printer running costs today.

Technician

Summary: Use a cost per page calculator and our CPP tracking spreadsheet to monitor ink/toner cost per page, allocate drum/fuser costs, and benchmark laser vs inkjet. The sheet highlights expensive jobs and suggests lower‑CPP devices to reduce your total cost of ownership (TCO). Need a custom dashboard? Open the chat.

Quick answer: the accepted method

The fastest way to monitor cost per page is to log cartridge price, ISO yield, and meter reads each month in a CPP spreadsheet. Calculate black CPP and color CPP, include drum/maintenance allocations for lasers, and set thresholds to flag high costs.

FAQ

Step‑by‑step (set up your CPP sheet)

1. Create columns for Device, Cartridge SKU, Price, ISO Yield, Drum Cost, Start Meter, End Meter, Pages, B&W CPP, Color CPP.
2. Enter current cartridge prices and yields for HP/Epson/Canon/Brother models.
3. Record meter reads monthly and assign purchased cartridges to each device.
4. Review the dashboard and move jobs to the lowest-CPP printer to cut costs.

Where to find counts (Windows/macOS)

1. Open the printer’s web page (type its IP) and print the Usage/Configuration report.
2. On Windows or macOS, use the vendor utility (HP Smart, Epson Utility, Canon IJ, Brother iPrint&Scan) to view counters and supplies.
3. Save the report PDF each month and attach it to your sheet for audit trail.

Sources

• ISO/IEC 19752 — Monochrome toner yield method
• ISO/IEC 24711 — Inkjet cartridge yield method
• HP — Supplies & yield info
• Brother — Toner/Drum life
• Epson — Ink yield and usage
• Canon — Cartridge yields

Matt ● replies in < 1 min

Technician Expert

⭐⭐⭐⭐⭐ Trusted by 27,000+ customers

Alex · Expert's Assistant

Start Chat

5 Tech Support Specialists are online right now.