Reconciling Contractor and Trade Invoices in Property Management

A plumber fixes a leak in Block C on a Tuesday. The quote was verbal, the work order was a WhatsApp message, and the invoice turns up eleven days later as a photo of a paper pad — with a reference number nobody recognises and a line for "materials" that was never agreed.

Now multiply that by forty buildings, six trades, and a couple of hundred small jobs a quarter. That is the reconciliation problem in property management: not one big invoice, but hundreds of small ones that each have to find their way to the right building, the right budget line and the right owner ledger before the accounts close.

This article is about how to make that match reliable — what to compare against what, where it usually breaks, and what data you need off each invoice for any of it to work.

Why trade invoices are harder than office invoices

A standard accounts payable department buys from a stable list of suppliers against purchase orders. Property management does not work like that.

The buyer changes per job. The same contractor invoices you for five different buildings, each of which is a separate accounting entity with its own budget approved by its own owners.
Half the spend is unplanned. Emergencies, call-outs and small repairs never go through a formal purchase order, so there is nothing to match against unless you create the record yourself.
The paperwork is informal. Quotes arrive by WhatsApp, invoices arrive as photos, and the job sheet is often a signed scrap of paper left with the caretaker.
Costs get split. One invoice may cover common areas plus a specific unit, or several properties at once — and the split has to be defensible months later.
Tax handling varies by trade. Works contracts, professional fees and simple supplies are not treated the same way, and in several countries the building itself acts as a withholding agent.

None of that is exotic. It just means the classic three-way match has to be adapted rather than copied.

The three matches that actually matter

1. Invoice against the quote or work order

In standard accounts payable, three-way matching compares the purchase order, the goods receipt and the supplier invoice before payment is approved. In property management the equivalent trio is: the approved quote (or the budget line the job falls under), the work order that authorised the visit, and the invoice.

If you have no work order, create a minimal one at the moment you dispatch the job: date, building, trade, what was asked for, who authorised it, and an expected ceiling. Thirty seconds of typing at dispatch removes most of the archaeology later.

2. Invoice against the building and the budget line

This is the match that goes wrong most quietly. The amount is right, the supplier is right, the invoice gets paid — and it lands on the wrong building. Nobody notices until a set of accounts looks odd at the annual meeting, and by then the money has moved between two communities of owners.

Every invoice needs a cost centre before it is booked, not after: which building, which budget heading (lift, cleaning, plumbing, extraordinary works), and whether it is a common cost or chargeable to a specific unit. When one document covers several properties, the allocation rule needs to live with the invoice — see our guide on splitting one utility invoice across several properties for how to structure that.

3. Ledger against bank against owner funds

If you hold client money, the third reconciliation is the trust or client-account one: your accounting balance, the bank balance and the sum of the individual building or owner ledgers must all agree at a cut-off date. Invoice-level errors are what break this reconciliation, which is why it is the last line of defence rather than the first.

Five ways contractor invoices go wrong

1. The same job billed twice. Small trades often re-send an invoice when payment is slow — sometimes with a new number. Statistically this is not a rare event: APQC's benchmarking data puts duplicate or erroneous payments at a median of 1.5% of total annual disbursements, with top performers still at 0.8% and bottom performers at 2%. Our piece on catching duplicate invoices before you book them covers the detection rules in detail.

2. Price drift from the quote. The quote said €480, the invoice says €610 because of "extra materials". That may be perfectly legitimate — but it needs to be visible before payment, not discovered by an owner reading the year-end accounts.

3. Wrong building, wrong heading. Discussed above. The fix is structural: no booking without a cost centre.

4. Missing tax and identity data. A trade invoice without a valid tax ID, a correct VAT treatment or the right withholding line is a problem you inherit. If your accounts are audited or challenged, "the contractor sent it like that" is not an answer.

5. Invoices that arrive after the period closes. Works finished in November, invoiced in February. Without an accrual against the work order, the building's accounts show a surplus that does not exist.

What the numbers say about doing this by hand

The economics are not subtle. Ardent Partners' 2025 accounts payable benchmarks put the average fully loaded cost of processing a single invoice at $10.89, with an average processing time of 10.9 days. Best-in-class teams using capture and automated matching do the same work for $2.78 in 3.1 days.

For a property manager handling 300 trade invoices a quarter, the gap between average and best-in-class is roughly $2,400 a quarter in pure processing cost — before counting a single duplicate payment. We broke the same maths down at a smaller scale in what it actually costs to process one invoice by hand.

The processing-time figure matters just as much. At eleven days average, an invoice that arrives in the last fortnight of a quarter has a real chance of missing the close.

A reconciliation routine you can run weekly

The minimum fields to capture from every invoice

You cannot reconcile what you have not captured. For each contractor invoice, you need at minimum:

Supplier name and tax ID
Invoice number and date
Building or property reference (from the invoice, the work order, or assigned at intake)
Net amount, tax amount, any withholding, total
Line items with description and amount
Work order or quote reference, if any
Payment method and due date

Those seven blocks are what let you run duplicate checks, quote comparisons and budget allocation automatically. Everything else is nice to have.

Tolerances, agreed once

Decide in advance what counts as a match. A workable starting point for small trade work: accept without review if the invoice is within 5% or a fixed small amount of the approved quote, whichever is lower; review anything above; escalate anything above the budget line's remaining balance. Tolerances stop your team from treating a €4 rounding difference and a €400 overrun with the same energy.

The weekly hour

One fixed slot a week, in this order: capture everything that arrived; run duplicate detection against the last 12 months; match against open work orders; allocate anything unmatched to a building and a heading; flag exceptions to whoever authorised the job. Anything that cannot be resolved goes on a short exceptions list that is reviewed the following week — not into a folder.

Getting the data out of the PDF (or the photo)

All of the above assumes the invoice data is in a structured form. That is exactly where property management pipelines stall, because trade invoices are the least standardised documents in existence: every plumber's template is different, half arrive as phone photos, and the same contractor changes format when they switch billing software.

Template-based OCR handles this badly — you end up maintaining a layout rule per supplier and re-doing it every time one of them changes something. We wrote about why per-supplier OCR templates break and why a model that reads the document the way a person does avoids the problem.

The practical setup that fits how property managers already work: the caretaker, the contractor or the office sends the invoice photo to a WhatsApp number, the data comes back structured within seconds, and it lands in a spreadsheet or straight into your management software. No app for the contractor to install, no portal login, no scanning station.

What owners are entitled to ask you for

Reconciliation is not only an efficiency question — it is a disclosure question.

In England and Wales, a leaseholder can request a summary of service charge costs under section 21 of the Landlord and Tenant Act 1985, and once they have it they have the right to inspect the supporting documents, with facilities for inspection to be provided within a month of the request. The RICS Service Charge Residential Management Code, which has ministerial approval, is used by tribunals as the benchmark for good practice.

In Spain, article 20 of the Ley de Propiedad Horizontal makes the administrator responsible for preparing the budget, executing payments, and keeping the community's documentation available to owners.

In Italy, article 1130-bis of the Civil Code gives every owner the right to inspect the supporting expense documents at any time and take copies at their own cost.

In all three cases, the test is the same: can you produce the invoice behind any line of the accounts, immediately, with the job it relates to? A reconciliation process that is only a spreadsheet of totals fails that test.

FAQ

Do I need purchase orders for small repairs?

Not formal ones — but you need *some* record created at dispatch. A one-line work order with building, trade, scope and a spending ceiling is enough to match against and enough to defend later.

How far back should duplicate checks run?

Twelve months as a default. Trade invoices get re-sent months later far more often than corporate ones, and a rolling 90-day window misses those.

What if one invoice covers several buildings?

Capture it once, then split it with a documented rule (by units, by share, by metered consumption). The rule should be stored with the transaction so it can be re-explained at the annual meeting.

Is photo quality a problem for phone-sent invoices?

Less than it used to be. The bigger risk is a partially cropped document — if the total or the tax ID is off-frame, no system can recover it. Ask for the full page in one shot.

Can extracted data go straight into my management software?

Yes, if it exports to Excel or exposes an API. Most property management systems accept a structured import, which avoids re-keying entirely.

---

Want to see what a contractor invoice looks like as structured data? Upload one and extract the fields in seconds — try it free, no signup.