Operations · 5 min read

Why your electric master invoice never matches your Yardi batch

You get one electric master invoice from the retail provider. It can run 80–100 pages and carry a separate meter for every apartment, plus the leasing office, amenities and irrigation. Your job is to turn that into a Yardi Paybal batch where each charge lands on the right unit and GL account — and where the total ties out to the invoice. In practice, it rarely ties out on the first pass. Here's why.

1. Vacant meters billed to residents

When a unit turns, the electric account often reverts to the property's name for a cycle. If your allocation still treats that meter as occupied, you bill a resident who isn't there — and the owner quietly overstates recovery. Vacant meters belong on the owner's expense account, not the resident bill-back.

2. Common-area meters hiding as units

House meters for hallways, pumps and amenity buildings sometimes carry unit-like identifiers. Posted to the wrong account, they inflate resident charges and distort your cost-recovery percentage.

3. Column drift in the PDF

Carrier invoices stack meters in shifting columns across pages. Copy-paste and naive parsing routinely grab the wrong number for a meter — a regulatory fee instead of the total, or last page's figure for this page's meter. Small per-meter errors compound across hundreds of lines.

4. Move-ins and move-outs mid-cycle

A resident who moves in on the 20th, a unit that's a model, a meter with a partial read — each is an edge case that a flat allocation gets subtly wrong.

How to get back to the cent

Match by position, not guesswork — read each meter's total by its location on the page.
Classify against the live rent roll — occupied, vacant, common-area, model.
Reconcile the total — the sum of allocated meters must equal the invoice; if it doesn't, stop and look.
Flag, don't guess — surface the handful of ambiguous meters for a human decision rather than silently mis-posting.