Master account reconciliation

How to reconcile a hotel master account, line by line.

Reconciliation is the accounting work behind an audit: breaking the master account into its parts, matching every line to the term that governs it, and making the balance due tie out.

The short answer

To reconcile a hotel master bill, split it into its revenue groups (rooms, F&B, rental, AV, labor, fees, taxes and service charges, deposits and credits). Match each line to a contracted or BEO-approved amount, recalculate the derived charges such as service charge and tax, then confirm that total charges minus payments and credits equals the balance the hotel says you owe.

Any line that doesn't tie to a term is either a difference to raise or a gap in your paperwork. Knowing which is the point of the exercise.

How a master account is structured

Hotels format master bills differently, but almost all of them group charges into these areas. Reconcile one area at a time.

Section	What posts here	What you match it to
Rooms and room tax	Room nights routed to master, by date and room type, with occupancy tax	Contract group rate, room block, rooming list, comp ratio
Food and beverage	Banquet checks by function, often with BEO numbers	Final BEO per function; guarantee counts; menu prices
Meeting room rental	Daily function space rental or a single rental line	Contract rental schedule and any waiver conditions
AV and technology	Equipment, labor, internet, rigging, power	AV agreement, AV BEOs, contracted discounts
Labor and staffing	Bartenders, attendants, security, technicians, overtime	BEO staffing lines, labor minimums, overtime rules
Service charges and taxes	Service charge on F&B and some services; tax on both	Contract percentage; local tax rules on service charge
Miscellaneous	Parking, shipping, business center, early check-in, fees	Contract concessions and routing instructions
Payments and credits	Deposits, prepayments, adjustments, comp credits	Deposit schedule, payment receipts, concession terms

The reconciliation method

01
Fix the governing documents first
List the contract, every addendum, and the final version of each BEO. When a term changed, write down which document replaced which. For the BEO part of this, see BEO invoice reconciliation.
02
Confirm the routing
Check that only charges your routing instructions send to the master account appear on it. Guest incidentals like minibar or personal dining usually belong on individual folios.
03
Reconcile rooms
Rebuild room nights from the pickup or rooming list, apply the group rate, subtract earned comps, and compare the result with billed room revenue before tax.
04
Reconcile each function
For each banquet check: menu price × the greater of the guarantee and the actual count (if that's your contract's rule), plus approved add-ons.
05
Recalculate derived charges
Recalculate the service charge on its stated base, then tax on the base and, where applicable, on the service charge. See service charge audit.
06
Test minimums and attrition
Compare actual F&B revenue with the contracted minimum, and actual room pickup with the attrition allowance. Apply the contract's exact formula, including what counts toward it.
07
Tie out the balance
Total charges − deposits − payments − credits should equal the balance due. If it doesn't, look for missing deposits or duplicated postings.

Tying out the balance

The last step catches issues that line-level checks miss, like a second deposit that was paid but never applied.

Sample data · Illustrative

Total charges on master account: $187,492.18
Deposit 1 (applied, folio p. 2): −$50,000.00
Deposit 2 (paid per receipt, not shown on folio): −$25,000.00
Balance due per hotel: $137,492.18
Balance due after applying both deposits: $112,492.18
Unapplied deposit to raise: $25,000.00

Sample figures. FolioMatch marks deposit and credit questions Needs review unless the documents prove the payment was missed.

Deposits, credits and adjustments

Payments are where a reconciliation most often fails to tie out. Deposits can be applied to the wrong account, split between master and a sister event, or held back against future attrition. Credits such as comp room value, a make-good or a waived fee can appear as a negative line, reduce a rate, or not appear at all.

Reconcile them against your own records, not only the folio. If you have a deposit receipt the folio doesn't reflect, that's a question for the hotel, not yet an error. Treat it that way in your notes.

Where FolioMatch fits

FolioMatch carries out the matching and recalculation steps above. It pulls terms from the contract, BEOs and addenda, reads the master bill line by line, links each line to its term, and calculates differences with fixed formulas. If you upload the hotel's CSV export as well as the PDF, it checks the two against each other.

You keep the judgment calls: whether a charge was approved onsite, whether a credit was agreed verbally, and what to send the hotel. To see how this fits into the full close-out, read post-event reconciliation.

Reconciliation terms

Pickup: Room nights actually used from the block, the basis for comp rooms and attrition.
Guarantee: The final attendance number you committed to for a function, usually 72 hours before it.
Posting: An entry made to the account by a hotel department. Duplicates happen when two departments post the same charge.
Split folio: An arrangement where some charges for a guest go to master and the rest to the guest.
Tie out: Confirming that the parts add up to the total and the balance due.

Common reconciliation problems and what they mean

A line on the master account with no matching term usually means one of three things: an onsite change that was never written down, a charge posted to the wrong account, or a genuine overcharge. The reconciliation can't tell you which on its own, but it can tell you exactly which lines need an answer, and that turns a 60-page bill into a short list of questions.

The reverse also happens: a term in the contract with no matching line on the bill. That's usually good news (a waived fee that was actually waived), but for earned items like comp rooms it means a credit is missing. Reconcile in both directions: every billed line to a term, and every term to the bill.

When the total doesn't tie out after you've matched every line, the cause is almost always in the payments section: a deposit applied to a different event, a credit memo issued but not posted, or a payment recorded after the bill was printed. Check the dates on every payment line before assuming a charge is wrong.

Questions

Is reconciliation the same as an audit?

They overlap. Reconciliation is the method of matching and tying out. An audit is the review of whether the charges are right. See hotel master bill audit for the review side.

Should guest incidentals be on the master account?

Only if your routing instructions say so. Minibar and personal charges usually belong on guest folios. FolioMatch doesn't treat them as group discrepancies.

What if the hotel sends the bill in several files?

Upload them all to the same event. It still counts as one audit.

Can I use the hotel's CSV export?

Yes. It's optional. FolioMatch compares it with the PDF and marks any differences between the two for review.

What if a billed line has no matching contract term?

It's flagged for review, not called an error. It may be an approved onsite change, a misrouted charge, or a real overcharge. The reconciliation tells you which lines need an answer; you supply the context.

Do I reconcile the bill before or after the post-con meeting?

Both. Flag obvious issues at the post-con while the hotel team is present, then do the full line-by-line reconciliation when the final master bill arrives.

You negotiated the deal. Make sure you got it.

Upload your contract, BEOs and final hotel bill. FolioMatch shows what needs attention and the source evidence behind every finding.

Audit a bill