CLC Lodging

CLC Invoice Reconciliation: A Step-by-Step Guide for Hotels

Total-to-total checks hide crew billing errors. Night-by-night matching finds them. Here is the method, the exception codes and the month-end checklist.

Quick answer: CLC® invoice reconciliation means matching every crew room night in your PMS to exactly one line billed to the program and one line paid by it, then checking each line against your contract's rates, tax rules and allowable charges. Anything unmatched or mismatched becomes an exception you rebill, dispute or collect. Do it monthly at minimum, and track every open item until it closes.

Most hotels "reconcile" crew billing by comparing a monthly total to a deposit. That catches almost nothing. The errors live at the line level: one night billed at the wrong tier, one guaranteed room that never went out, one tax line dropped from an extended stay. This guide walks through a night-by-night method any crew-heavy hotel can run, with or without software.

What does crew lodging reconciliation actually match?

It matches three records for every crew room night: what happened (the PMS folio), what was billed (the program's billing record), and what was paid (the remittance). A night is clean only when all three agree with each other and with the contract.

• Record 1, the PMS folio: guest, room, arrival, departure, actual nights, rate code, room revenue, taxes and incidentals.
• Record 2, the billed line: what the hotel submitted to the crew program for that night.
• Record 3, the paid line: what the program paid, including any adjustment or short-pay note.
• The answer key, the contract: what that night should have been worth.

A total-to-total comparison can balance perfectly while hiding an unbilled night offset by an overbilled one. Line-level matching cannot.

Step-by-step: how to reconcile CLC invoices

The process is ten steps. The first month takes the longest because you are building the rate sheet and cleaning history. After that, it becomes routine.

1. Build a contract rate sheet. One page listing each rate by room type, date range and tier; tax treatment by stay type; allowable and non-allowable charges; and the billing rules for guaranteed rooms, no-shows, early departures, extensions and late check-outs. Note any time limits for billing and disputes that apply to your contract.
2. Define the period. Use check-out date for completed stays so a stay that crosses month-end is reconciled once. Keep in-house stays on a separate watch list.
3. Export crew stays from the PMS. Filter by the crew company, market segment or routing account. Export at the night level, not the stay level, so a five-night stay becomes five rows. Include guaranteed and no-show nights.
4. Export billed lines. Pull what was submitted to the program for the same period, also at the night level if possible.
5. Export payments. Pull remittance detail, including adjustment notes and reason codes.
6. Create a match key. Typically confirmation number plus stay date. If the program's record uses a different identifier, add a crosswalk column using guest name, room number and date.
7. Match PMS to billed. Every PMS night should find a billed line. PMS nights with no billed line are unbilled. Billed lines with no PMS night are potential overbilling, which you want to find before the program does.
8. Match billed to paid. Every billed line should find a payment for the same amount. Differences are short-pays or overpayments. Billed lines with no payment after your normal payment cycle are unpaid.
9. Validate against the contract. For each matched night, check rate tier, tax treatment and allowable charges against the rate sheet. This is where rate-tier and tax errors surface even when everything "matched."
10. Work the exceptions and log them. Rebill unbilled nights, correct and resubmit errors, dispute short-pays with documentation, collect non-allowable incidentals from the guest where possible, and record the date and outcome for each.

How should you classify reconciliation exceptions?

Classify each exception by what went wrong, because the fix is different for each type. A consistent set of codes also shows you which errors keep repeating, so you can fix the cause.

• Unbilled night: in the PMS, not billed. Fix: bill it with folio support.
• Rate-tier error: billed at the wrong contracted rate. Fix: correct the PMS rate code and rebill.
• Tax error: tax charged on an exempt stay or missed on a taxable one. Fix: correct the folio and rebill, and review how the stay was set up at check-in.
• Non-allowable charge: incidental billed to the program that the contract does not cover. Fix: remove it from the program bill and pursue the guest if you can.
• Missed guaranteed or no-show night: contract pays for it, it was not billed. Fix: bill with the supporting documentation your contract requires.
• Short-pay: paid less than billed. Fix: read the reason, then either accept it (and fix the root cause) or dispute it with support.
• Missing credit or adjustment: money owed to the hotel after a resolved dispute or rebill that never arrived. Fix: follow up with the reference number.
• Overbilled: billed for a night that did not happen or at too high a rate. Fix: correct it proactively; it protects the relationship and speeds up clean payments.

What does the math look like on a typical month?

Line-level reconciliation tends to find many small items rather than one big one. That is exactly why total-level checks miss them.

For example (illustrative numbers only): a hotel with 600 crew room nights in a month at an average $98 contracted rate bills about $58,800. Reconciliation finds 9 unbilled nights ($882), 14 nights at a rate tier $8 too low ($112), 3 no-show nights the contract pays for that were never billed ($294), and 4 short-paid tax lines worth $62. That is $1,350 in one month, or about $16,200 a year if the pattern holds, from a report that "balanced" at the total level.

Monthly CLC reconciliation checklist

Use this checklist to close each month. If you can tick every line, your crew receivable is clean.

• Rate sheet reviewed; any contract changes loaded into PMS rate codes.
• PMS crew nights exported at night level, including guaranteed rooms and no-shows.
• Billed and paid detail exported for the same period.
• PMS nights = billed nights, with every difference explained.
• Billed amounts = paid amounts, with every short-pay coded.
• Every matched night validated for rate tier, tax and allowable charges.
• Unbilled and missed no-show nights rebilled with support.
• Short-pays disputed or accepted with a root-cause note.
• Credits and adjustments owed followed up by reference number.
• Open items aged 0–30, 31–60, 61–90 and 90+ days, each with an owner and a deadline tied to your contract's time limits.
• Top three root causes shared with the front desk and night audit.

What causes most reconciliation exceptions?

Most exceptions start at the front desk or in the PMS setup, not in accounting. Fixing a handful of upstream habits removes most of the monthly cleanup.

• Crew stays checked in under a generic or transient rate code.
• Folio routing that sends crew charges to the wrong account.
• No step at check-out to settle non-allowable incidentals with the guest.
• Guaranteed rooms released without a record for billing.
• Rate codes not updated when the contract changes.
• Extended stays not reviewed for tax treatment as they pass state long-stay thresholds.

For a deeper look at each error type, see the crew lodging billing errors checklist. For the full picture of how crew billing works, start with our CLC lodging billing audit guide.

Should you reconcile crew billing manually or automate it?

Manual reconciliation works at low volume if one person owns it and does it every month. It breaks down when crew volume is high, when you run several properties, or when the person who knows the process leaves.

The hard part is not the matching logic. It is doing it every single month, at the night level, against a contract that changes, while the aging clock runs. That is the part most hotels eventually hand to software or a partner.

How x·quic helps

CLC® Secure 360° audits CLC® and other crew and government lodging line by line against how your contract pays, flagging rate-tier errors, missed credits and mis-billed incidentals so they can be recovered. You can see what your crew business is missing with the free 1-Year Profit Audit on your own data: read-only access, setup in minutes, no cost and no commitment. More answers are on the FAQ.

Related guides

CLC LodgingCLC Lodging Billing Audit: The Complete Guide for Crew-Heavy HotelsCLC LodgingCrew Lodging Billing Errors: 10 Mistakes Railroad and Airline Hotels MakeCLC LodgingIs Crew Lodging Profitable for Hotels? How to Measure the True Rate