Hotel Balance Sheet Template

Download the file and open it in Excel or Google Sheets. Start with the FF&E Schedule: list every major fixed asset the property owns — room furniture, lobby fixtures, kitchen equipment, fitness equipment, signage, and vehicles — along with each asset's original cost, purchase date, and useful life. Most hotel owners pull this from their depreciation schedule in their tax return or accounting software. The sheet calculates accumulated depreciation and net book value automatically, and the total feeds into the main balance sheet. Getting this right first is worth the time — FF&E is often the single largest asset on a hotel balance sheet.

Hotel balance sheets are more complex than most small-business balance sheets because of two features specific to the industry. First, fixed assets are substantial and require their own tracking: a single mid-scale property might carry $5–15 million in building and FF&E value, and that value erodes through depreciation faster than most business owners realize. Rooms-division FF&E typically deprecates over 7–10 years, which means a property that hasn't invested in renovations for a decade may be carrying net book values that no longer reflect what guests experience — a signal that lenders and buyers look at carefully. Second, advance deposits create a liability that cash-flow-focused operators often overlook. A sold-out holiday weekend with $50,000 in deposits on the books is not $50,000 in revenue until those guests check in.

Key Performance Indicators