How do property managers automate utility bill coding across hundreds of properties?

Property managers automate utility bill coding with MakersHub by letting it read the account number on each electric, gas, water, internet or trash bill and look up, from a list you load once, which property and unit that account belongs to. From that one lookup MakersHub assigns the QuickBooks Class, Location and GL account, builds the bill number in your format, and posts the bill to QuickBooks Online, QuickBooks Desktop, Xero, Intacct or NetSuite before anyone opens it.

The account number is the key. A utility bill often has no invoice number and the same vendor name on every page, but the account number is unique to a meter or a unit and does not change until the account closes. MakersHub is built to find it, train once per vendor where it sits, and drive everything else from it.

When this applies

You pay utilities on properties you manage or lease: one electric account per unit, one internet account per unit, water and gas per building, cable and internet on master accounts that bill hundreds of units on one statement. Bills arrive all month. Someone logs into each portal, downloads the PDF, works out which property it belongs to, types it into a QuickBooks import template with the Class and the Location, and marks it paid after the autopay clears.

The AP lead at a corporate-housing operator on QuickBooks Online, paying more than 2,000 bills a month, mostly utilities:

"We pay utilities all month long because they come in all the time. And we just need to make sure that the electric stays on, that their water is paid, that their cable is on. So that's what we do the entire month."

On the internet accounts:

"Each account has to have its own email, so they will not let you set up 12 units in one apartment complex with one email, so you have to have many aliases, and they've just grown monstrous over time."

How QuickBooks handles recurring utility bills, and where it stops

QuickBooks Online's recurring transactions and QuickBooks Desktop's memorized transactions copy a prior bill forward on a schedule, with the same vendor, lines and amounts; the user then edits the amount, the bill date and the due date each month. Neither reads a document, so nothing connects an incoming PDF to the right Class, Location or Customer. Both products can warn on a duplicate bill number, but a utility bill frequently has no invoice number to check, so a bill uploaded twice is only caught if someone assigns a number by hand.

With a few hundred accounts the import template becomes the system: one row per bill, keyed from memory of which account is which complex, and a bill number typed from a naming convention. MakersHub replaces that step with a lookup it performs itself.

How MakersHub codes a utility bill from its account number

1. Bills land in one inbox, however they are delivered. Utility portals that email a PDF send to a MakersHub address, or your existing AP inbox auto-forwards. Portals that only allow download are handled by dragging the downloaded PDFs into MakersHub in bulk. Paper bills are scanned. A scanned stack of six two-page bills from the same utility is split into six bills because MakersHub reads the six account numbers, not because it finds an invoice number.
2. The account number is found, once trained. MakersHub's extraction model, WiseVision, is trained one time per vendor on where the account number sits on that vendor's bill. Every later bill from that vendor returns the account number as a field, in ten to fifteen seconds. A company name printed at the top of a bill, such as your own, is set to be ignored so it is never mistaken for the vendor.
3. Vendor plus account number resolves the property and unit. You load a list once: vendor, account number, apartment complex, unit. MakersHub stores it as integration data, so it never appears in QuickBooks, and matches each bill against it. One customer's list holds 1,709 vendor and account pairs. A bill whose account is not on the list is assigned to its complex by hand from a dropdown, and that assignment can be saved as a new row.
4. Everything downstream is assigned from the property. Integration Mapping rules chain from that one match: the complex sets the QuickBooks Class and the Location; the vendor sets the GL account (gas and power, water, internet) and a one-letter utility code; the complex sets a short property code. The bill description is compiled in the format you specify. Rules are set once and run on every bill.
5. The bill number is built in your format. Utility bills often carry no invoice number, so MakersHub assembles one from the fields it now has: utility code, property code, unit and billing month, or account number plus the service month, whichever convention your books already use. QuickBooks duplicate-bill-number checking then works for utilities too, because every bill has a unique, predictable number.
6. Line detail is collapsed or separated as your books want. Most utility bills post as one line coded to the property. A description rule sends an exception line, such as security deposit interest or a late fee, to its own GL account while the rest of the bill follows the property coding. A master statement that bills hundreds of accounts on one invoice is read account by account and posts one line per account, each coded to its complex, with the master account number in the memo.
7. Approval and payment follow your workflow. A fully coded bill can route straight to AP or auto-approve. Bills the utility already drafted are approved with Approve and Mark as Paid against the bank or card account in your chart of accounts, which creates both the bill and a payment record that matches the bank feed. Bills you pay through MakersHub batch by vendor, so a hundred account bills to one utility go out as one payment with every bill number on the remittance.
8. The bill posts to QuickBooks with your coding. Vendor, bill number, due date, Class, Location, GL account and description land in QuickBooks Online within seconds or in QuickBooks Desktop on the next Web Connector run, with a link to the bill image. A double checkmark in MakersHub confirms the sync; a sync error, such as a duplicate bill number, shows its reason on the bill.

Accounting-system specifics

Several QuickBooks files. Where each property or ownership group has its own company file, a linked-entity rule routes the bill to its file from the bill-to name or account number first, then that file's coding rules run. Configuration of the multi-entity setup is covered on the multi-location practice page linked below.

Adding and retiring units. New units and accounts are added by dropping an updated spreadsheet into Import Integration Data; the change is live immediately. A unit you no longer manage is flagged inactive and leaves the dropdown.

Proof

A corporate-housing operator on QuickBooks Online that pays more than 2,000 bills a month, almost all utilities on leased apartment units, went live in September 2026 with an account-number lookup of 1,709 vendor and account pairs loaded into MakersHub. On each bill MakersHub finds the account number, resolves the complex and unit, assigns the Class, the Location, the GL account for the utility type and the property code, and assembles the bill number the team used to type by hand: utility code, complex code, unit and month. The unit list lives in MakersHub and is stripped on sync, so QuickBooks never gained 1,700 extra customers.

The controller, told the list would not be pushed into QuickBooks:

"That's perfect. That's what I was looking for."

The AP lead, after the first demo:

"I love what I'm seeing."

A residential rental and homebuilding group on QuickBooks Desktop needed a bill number for utilities that do not print one. Their AP lead:

"Not all utilities have an invoice number, so we just go off of the account number since that number never changes until we close that account."

MakersHub was trained to return the account number and a rule appends the service month, so QuickBooks sees a unique bill number each month and flags a true duplicate.

A multifamily owner-operator with about eighty entities on QuickBooks Desktop, whose operating companies pay roughly 125 utility bills a month, chose MakersHub for a pilot on its highest-volume utility entity. The operations lead:

"It's these pesky utility bills that we get nine million of. I feel like I could wipe those out pretty quickly."

What it doesn't do

MakersHub does not log into utility portals with your credentials; bills arrive by email, auto-forward, scan or bulk upload of downloaded PDFs, and the lookup takes over from there. It does not see that a utility has auto-drafted your account; vendors on autopay are tagged so their bills are filtered and approved with Approve and Mark as Paid in one pass, and a trained autopay-date field can hold a bill for review when the date is missing. And MakersHub never deletes or edits a bill in QuickBooks after it has synced; QuickBooks stays the book of record.

Frequently asked questions