Short-term Rental Expense Spreadsheet (Free Template)

Running a vacation rental means juggling dozens of costs at once. There are one-time repairs, recurring cleaning fees, utilities and booking site commissions. Without a system, it’s easy to lose track of where your money goes. A short-term rental expense spreadsheet gives you a clear snapshot of every dollar coming in and going out, so you can focus on hosting instead of chasing numbers.

This guide is for independent hosts, vacation rental owners and small-scale property managers in the United States. Below, we explain why you need a vacation rental expense spreadsheet, which categories and metrics to track, how to set one up in 6 steps and how to get started with our free Excel template.

Don’t see the form to download the expense tracking spreadsheet? Click here.

What is a short-term rental expense spreadsheet?

A short-term rental expense spreadsheet is a structured tracking tool, usually built in Excel or Google Sheets, that records all income and costs for a vacation rental property. It helps hosts and property managers monitor cash flow, calculate profit margins and prepare for tax season in one place.

You’ll also see it called a vacation rental expense spreadsheet, a vacation rental income and expense worksheet or a short-term rental accounting spreadsheet. They all do the same job: they show you whether your rental actually makes money.

Why do you need a short-term rental expense spreadsheet?

The goal of a short-term rental expense spreadsheet is to make financial management easy. A vacation rental income and expense worksheet cuts manual accounting work and shows you how your property really performs. Here’s why it belongs in your workflow.

Save time and effort

A short-term rental accounting spreadsheet that’s already set up for vacation rentals saves you from calculating your finances by hand every month. You don’t start from scratch each billing cycle. You enter your monthly expenses and earnings, and the formulas do the rest.

When it’s time for filing your taxes, your numbers are already organized in one spreadsheet. That means less stress at year-end and a faster handoff to your accountant.

Pay your team on time

Vacation rental operations involve many moving parts: turnover cleaning, mid-stay upkeep, laundry and maintenance. Each one has its own cost. Late or inconsistent payments frustrate cleaners and contractors, and that can lead to weaker service and lower guest reviews. A vacation rental expense spreadsheet helps you keep payments on schedule, so your team stays motivated and your guests get a 5-star stay.

Catch every expense

Small costs add up quietly. Think of a replacement door handle, a carpet deep clean or a new set of towels. Tracking every expense keeps you on top of your real spending and prevents surprises at the end of the month. It also means fewer missed deductions when you file.

Bonus tip: Plug your expenses into our vacation rental income calculator to estimate how much your property should be generating.

Understand your vacation rental’s performance

You might have a sense of how your business is doing. Without data, it’s still a guess. A vacation rental expense spreadsheet shows you exactly where your costs are concentrated, so you can decide where to cut back and where to reinvest.

Tracking key data in your short-term rental analysis spreadsheet shows you which months perform best and which guests you attract. It also lets you project future revenue with confidence. Once you have the numbers, you can pinpoint areas to improve and make a clear case for reinvestment.

Your spreadsheet shows your average nightly rate. To set rates that maximize profit, pair it with Lodgify Dynamic Pricing. It uses an algorithm that factors in more than 40 attributes, market conditions and local trends to adjust your rates automatically all year.

What does the short-term rental expense spreadsheet cover?

Our free short-term rental expense spreadsheet lets you record every expense and purchase for your vacation rental on a monthly and yearly basis. The template comes preloaded with common cost categories, such as cleaning products and property management tools. You can customize it for your situation. For example, if your property has a pool, add a line item for pool maintenance.

The spreadsheet also tracks income. You can record gross monthly income, compare it against projected earnings and get an estimate of your average nightly rate for each month.

Finally, the template compares expenses against earnings. You can see your profit margins and the exact share of revenue that goes to costs and fees.

Here’s a preview of the vacation rental property expense spreadsheet template:

Ready to dive in? Download our free template.

Essential metrics to include in your expense spreadsheet

These are the key metrics every short-term rental expense spreadsheet should track:

Common short-term rental expense categories

Group your costs into clear categories. This makes monthly reviews faster and helps your tax preparer match expenses to the right lines on your return. Here are the categories most vacation rental owners track:

How to set up a short-term rental expense spreadsheet in 6 steps

Use our free template or build your own in Excel or Google Sheets. Either way, these steps give you a system you can keep up with in a few minutes each week:

1. Start with a template. Download Lodgify’s free template or create a sheet with 1 tab for income, 1 for expenses and 1 for a monthly summary.
2. Add your income sources. Create a column for each booking site, direct bookings, guest-paid cleaning fees and upsells.
3. List your expense categories. Use the categories above and add property-specific lines, such as pool maintenance or snow removal.
4. Log transactions every week. Record the date, amount, vendor and category. Save a digital copy of each receipt.
5. Calculate your key metrics every month. Add formulas for occupancy rate, ADR, RevPAR, NOI and cash flow.
6. Review every quarter. Compare actual results against projections, adjust your pricing and budget, and share the file with your tax preparer at year-end.

Spreadsheet vs. accounting software vs. vacation rental software

A spreadsheet is a great place to start. As your portfolio grows, you may want more automation. Here’s how the main options compare:

Frequently asked questions

What should I include in a short-term rental expense spreadsheet?

Include gross revenue, occupancy rate, average daily rate (ADR), RevPAR, average length of stay (ALOS), operating expenses (utilities, cleaning and supplies), booking site fees, property management fees, net operating income (NOI), projected revenue and cash flow. Add custom lines for property-specific costs like pool maintenance or landscaping.

Is there a free short-term rental expense spreadsheet I can download?

Yes. Lodgify offers a free short-term rental expense spreadsheet template in Excel format. It comes preloaded with the most common expense categories and income metrics for vacation rental owners. You can download it with the form on this page.

How do I track vacation rental income and expenses?

Use a dedicated spreadsheet or accounting software. Each month, enter your gross income and every cost: cleaning, booking site commissions, repairs, utilities and management fees. Subtract operating expenses from gross revenue to get net operating income. Subtract mortgage payments as well to get cash flow. For automated tracking across multiple properties, try Lodgify’s accounting features.

What expenses can vacation rental owners deduct on their taxes?

In the United States, vacation rental owners may deduct ordinary and necessary rental expenses. These include mortgage interest, property taxes, cleaning, repairs, management fees, booking site commissions, insurance, utilities and depreciation. Your deductions depend on personal use. If you use the property for more than 14 days or more than 10% of the days it’s rented, whichever is greater, the IRS treats it as a residence and limits deductions. If you rent it for fewer than 15 days a year, you generally don’t report the income. Always consult a qualified tax professional. For details, see the IRS guidance on rental income and expenses and IRS Publication 527.

What is the difference between gross revenue and net operating income for a vacation rental?

Gross revenue is the total income your vacation rental generates before any deductions. It includes nightly rates, cleaning fees charged to guests and upsells. Net operating income (NOI) is what remains after you subtract operating expenses such as cleaning, utilities, booking site fees and management fees. NOI excludes mortgage payments and capital expenses, which makes it a strong indicator of day-to-day profitability.

How do I calculate the occupancy rate for my short-term rental?

Divide the number of nights your property was booked by the number of nights it was available, then multiply by 100. For example, if your property was available for 30 nights and booked for 22, your occupancy rate is 73%. A low occupancy rate may signal that your pricing needs adjusting or that new amenities could attract more guests.

Download our free short-term rental expense spreadsheet

Running a vacation rental without tracking your numbers is like driving without a map. Clear records of your expenses and earnings show you where your money goes and what to change to earn more. Download our free short-term rental expense spreadsheet and manage your finances with confidence.

Want deeper financial reporting without the manual entry? Try Lodgify’s owner statements free for 7 days. Start your free trial today!

Don’t see the form to download the expense tracking spreadsheet? Click here.