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.

Next, complete the Advance Deposits sheet using your PMS (property management system) folio and reservation reports. List every deposit received for future arrivals, including group blocks and event deposits. This becomes your deferred revenue balance on the main balance sheet. Then work through the Balance Sheet sheet itself: enter cash balances from your bank statements, pull outstanding guest and city ledger balances from your PMS aging report, and enter vendor payables from your accounts payable aging. Accrued wages, franchise fees payable, and current mortgage payment go in current liabilities. Long-term mortgage principal balance goes in non-current liabilities.

Update your balance sheet monthly — it takes under 30 minutes once the FF&E schedule is set up, because most changes from month to month are just updating cash, receivables, payables, and the advance deposit balance. The Period Comparison sheet is your tool for board meetings, lender reporting, and ownership reviews: pull two months or two year-ends side by side and you have a clean picture of how equity is building, how the mortgage is amortizing, and whether the property's asset base is being maintained or degraded. Most hotel lenders require balance sheets quarterly alongside P&L statements as part of loan covenant compliance — having this template ready makes that reporting straightforward.

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.

The standard hotel balance sheet separates receivables into two buckets for a reason. The guest ledger tracks in-house guests with open folios — amounts owed by currently checked-in guests that will settle at checkout. These are typically liquid within days. The city ledger is everything else: corporate direct-bill accounts, OTA settlements, group master folios, and any post-departure disputes. City ledger aging matters — accounts over 60 days are at meaningful risk of becoming bad debt, and hotels with heavy corporate business need to monitor this closely. A clean balance sheet tracks both separately so you can spot collection problems before they compound.

Lenders and investors evaluate hotel balance sheets differently than they evaluate other commercial real estate. The key ratios they examine: debt-to-equity (most hotel lenders want this below 70–75%), net book value of FF&E as a percentage of total property value (a proxy for renovation health), and the ratio of advance deposits to average daily revenue (unusually high can signal a heavy group dependency that creates operational concentration risk). Running a current balance sheet isn't just a year-end accounting exercise — it's the document that tells you whether your equity is growing, whether your renovation cycle is funded, and whether your property's capital structure can support the next phase of investment.