Hotel Room Block Attrition Calculator

Check what a hotel can bill you for an under-filled room block and a missed food and beverage minimum, using the terms in your contract. Runs entirely in your browser; nothing is uploaded.

Room block by night (CSV with columns Date, Contracted Rooms, Picked Up Rooms, and optional Comp Rooms)

Open a CSV file

Group rate per room-night ($)

Performance requirement (% of block)

Method

Damages basis (% of group rate)

Resold room-nights credited by the hotel

Comp ratio (1 comp per N paid room-nights, 0 to skip)

Cap each night's pickup at the block

Charge tax on room damages

Tax rate on room damages (%)

Food and beverage minimum (optional)

F&B minimum ($)

Actual F&B spend ($)

F&B damages (% of shortfall)

Add service charge and tax to F&B damages

Service charge (%)

Tax on F&B damages and service charge (%)

What to negotiate

Hypothetical block reduction at the review or cutoff date (%)

Not legal or accounting advice. Attrition clauses differ: some use cumulative room-nights, some night-by-night, some cap overflow, some credit resold rooms only after the hotel sells out, and some exclude comps from pickup. Damages may be at the full group rate or a lost-profit percentage, and whether tax or service charges apply varies by contract and by state. This page applies the terms you enter; read your contract and confirm the numbers with the hotel's own pickup report.