How it works

From PDF chaos to a clean Yardi batch

No spreadsheets, no manual sorting. Two files in, a reconciled batch out — with every meter matched, classified, and posted to the right account.

1 · Drop two files

Your utility master invoice — electric, water, sewer or gas (PDF) — and the matching rent roll (XLSX). That's the entire input.

2 · Match & classify

Each meter is matched to its unit from the invoice service address, then cross-checked against the rent roll.

3 · Reconciled batch

A Yardi Paybal file with the right GL accounts — balanced to the invoice, with exceptions flagged.

What makes it accurate

Coordinate-level reading

Carrier invoices stack hundreds of meters across dozens of pages with shifting columns. UtiliBox reads them by position, not guesswork — so every per-meter total is exact.

Rent-roll aware classification

Occupied-on-bundle, occupied-metered, vacant, model, and common-area meters each route to the correct GL account, straight from your live rent roll.

Reconciled to the cent

The sum of every allocated meter is checked against the carrier's invoice total. If it doesn't balance, you'll know immediately.

Exceptions, not errors

When the rent roll and a meter disagree, UtiliBox flags it for a one-click decision instead of silently guessing.

See the input format

UtiliBox is tuned for the AE Texas multi-meter invoice format. Grab the sample files to see exactly what goes in:

Watch it run on a real invoice

256 meters, 87 pages, reconciled in seconds.