How to Set Up a Chart of Accounts for Your Short-Term Rental Business

A proper chart of accounts is the foundation of STR financial clarity. Here is the exact account structure experienced operators use to track true profit.

Most STR Operators Are Flying Blind

If your entire accounting system is a bank feed and a spreadsheet, you are not running a business. You are running a guessing game. The difference between operators who scale past 5 properties and those who stall out is almost always financial infrastructure. A chart of accounts is where that infrastructure starts.

A chart of accounts (COA) is simply a categorized list of every financial account your business uses. It is the skeleton your bookkeeping hangs on. Without one, your profit and loss statement is meaningless because you cannot compare cleaning costs to cleaning revenue, or platform fees to booking volume, or maintenance spend to property value. You just have a pile of transactions.

For a single-property hobbyist, maybe that is fine. For anyone running 3 or more units, managing someone else is properties, or trying to understand which properties are actually making money, a structured COA is non-negotiable.

The Numbering System That Actually Makes Sense

Standard bookkeeping uses a numbering convention that groups accounts by type. You do not need to memorize accounting theory. You just need to understand the buckets:

• 1xxx: Assets (bank accounts, security deposits held, prepaid expenses)
• 2xxx: Liabilities (credit cards, mortgages, owner payables if you manage for others)
• 3xxx: Equity (owner contributions, retained earnings)
• 4xxx: Income (all revenue sources)
• 5xxx: Cost of Goods Sold / Cost of Revenue (direct costs per turnover)
• 6xxx-7xxx: Operating Expenses (fixed and variable costs of running the operation)

The reason for this structure is not bureaucratic. It is so your P and L rolls up correctly: Revenue minus COGS gives you gross profit. Gross profit minus operating expenses gives you net operating income. Subtract financing costs and you have your true bottom line. That is the number that matters.

Income Accounts: More Channels Than You Think

Most operators treat income as one number: what Airbnb deposited. That is a mistake. If you are on multiple platforms, or if you collect cleaning fees separately, or if you sell damage protection, each of those is a different revenue stream with different margin profiles.

Recommended Income Accounts (4xxx)

• 4100 - Airbnb Booking Revenue
• 4110 - VRBO Booking Revenue
• 4120 - Direct Booking Revenue
• 4130 - Booking.com Revenue
• 4200 - Cleaning Fee Income
• 4300 - Damage Protection / Insurance Income
• 4400 - Pet Fee Income
• 4500 - Early Check-In / Late Check-Out Revenue
• 4600 - Other Guest Fees

Why split by channel? Because your ADR and occupancy on Airbnb versus VRBO versus direct are almost certainly different. If you combine them, you lose the ability to evaluate channel performance. Operators who run true direct booking programs often find they are netting 12-18% more per booking after you strip out platform fees. You will never see that without channel-level income tracking.

Cost of Goods Sold: What It Actually Costs to Turn a Property

COGS in an STR context means the direct, variable costs that occur because a guest stayed. If the property sat vacant, you would not incur these costs. That is the defining characteristic.

Recommended COGS Accounts (5xxx)

• 5100 - Cleaning Labor (per-turn cleaning cost paid to cleaner)
• 5110 - Cleaning Supplies (consumables restocked per turn)
• 5120 - Laundry (coin laundry or service cost)
• 5130 - Linen Replacement (wear-and-tear on towels, sheets)
• 5200 - Turnover Coordination (if you pay a co-host or PM per turn)
• 5300 - Guest Amenities (welcome basket items, coffee, toiletries)

A realistic cleaning cost for a 1-bedroom unit ranges from $65 to $110 per turn including supplies. A 3-bedroom with outdoor space can run $130 to $200. If you are not tracking this at the account level, you cannot calculate your true per-booking margin. A booking that grosses $180 but costs $150 in cleaning and supplies has a very different profile than one that grosses $180 with $60 in turnover costs.

Operating Expenses: Where Operators Get Sloppy

Operating expenses are the costs of running the business regardless of occupancy. This is where most operators have the messiest books, because there are a lot of categories and many costs span multiple properties.

Recommended Operating Expense Accounts (6xxx-7xxx)

• 6100 - Airbnb Host Service Fees (the 3% Airbnb charges hosts)
• 6110 - VRBO/Booking.com Platform Fees
• 6120 - Payment Processing Fees (direct bookings)
• 6200 - Property Management Software (Hospitable, Hostfully, etc.)

• 6210 - Dynamic Pricing Tool (PriceLabs, Wheelhouse, etc.)
• 6220 - Smart Lock / Tech Subscriptions
• 6230 - Channel Manager (if separate from PMS)
• 6300 - Insurance (STR-specific policy)
• 6400 - Utilities (electric, water, gas, internet)
• 6500 - Repairs and Maintenance
• 6510 - Maintenance Reserve (accrual, if you use one)
• 6600 - Mortgage Interest (for owned properties)
• 6610 - Rent / Lease Payment (for rental arbitrage)
• 6700 - Property Taxes (pro-rated if you need it)
• 6800 - Owner Referral / Co-Host Fees (if you pay outward)
• 6900 - Professional Services (accountant, attorney)
• 7000 - Marketing (photography, listing upgrades, direct booking ads)

A common error is lumping all platform fees into one account. If you are on three channels with different fee structures, you want to see those separately. Airbnb is charging hosts 3% on the host side, but VRBO has different models depending on whether you are on a subscription or commission plan. Knowing exactly what you are paying per platform per month is useful data.

Handling Shared Expenses Across Multiple Properties

This is where multi-property operators get into trouble. You have one PMS subscription that covers all 6 units. You have a maintenance truck that serves 4 properties. How do you allocate those costs?

There are two practical approaches. The first is direct allocation: split the expense by property based on revenue share, unit count, or some other logical ratio. If Property A generates 40% of your revenue and Property B generates 60%, you can allocate shared costs at 40/60. The second approach is to run shared costs through a central "operations" entity account and not try to allocate at all, accepting that your per-property P and L will be partially incomplete.

For most operators with fewer than 10 units, a simple revenue-weighted allocation works fine. For larger portfolios, especially if you have outside investors or co-owners on individual properties, you need cleaner per-property accounting.

MagicBnB handles this automatically through its Bank Transaction Ledger with Property Allocation feature. When a shared expense hits your bank account, you can split it across properties without any manual journal entry. The platform understands that your PriceLabs subscription serves multiple listings and lets you allocate accordingly, which feeds directly into your per-property P and L Statement.

QuickBooks vs Simpler Systems vs Purpose-Built STR Tools

QuickBooks Online is the gold standard for small business accounting and works fine for STRs if you set it up correctly with the COA structure above. Expect to spend 3-5 hours on initial setup and a few hours a month on reconciliation. The advantage is that your accountant already knows it.

Simpler systems like Wave (free) or FreshBooks work for operators with 1-3 properties who do not need sophisticated reporting. You lose some reporting depth but gain simplicity.

The limitation of both is that they are generic. They do not know what a cleaning fee is. They do not understand that an Airbnb deposit is net of host fees and you need to gross it up. They do not know how to separate booking revenue from cleaning revenue from the damage waiver. You end up doing a lot of manual categorization work every month.

MagicBnB takes a different approach. Because it connects directly to your Hospitable or Hostfully account via OAuth and pulls your bank transactions via Plaid, it already knows what each line item is. It understands STR-specific categories out of the box: Airbnb service charges, cleaning fee income, seasonal cost patterns. The expense categorization is built for this business model, not retrofitted from a generic accounting template. For operators who want financial clarity without becoming part-time bookkeepers, that is a meaningful difference.

Practical Steps to Get Started

• Step 1: Open a dedicated business bank account and business credit card for each property (or at minimum one per entity). Commingling personal and business finances is the fastest way to lose track of everything.
• Step 2: Choose your accounting tool and set up the COA structure above. Start with the account numbers that match your actual expense categories.
• Step 3: Connect your bank feeds so transactions import automatically.
• Step 4: Set up recurring rules to auto-categorize known vendors (your cleaner, your PMS, your dynamic pricing tool).
• Step 5: Reconcile monthly. Every single month. Do not let it pile up.

The operators who build this infrastructure early find that scaling from 3 to 10 properties does not feel dramatically more complex. The operators who ignore it find that at 5 properties they have no idea which ones are actually making money.

Frequently Asked Questions

What accounts should I use for Airbnb income in QuickBooks?

Create separate income accounts for Airbnb booking revenue (4100) and cleaning fee income (4200). Note that Airbnb deposits are net of host fees, so you need to gross up the revenue and book the host fee (typically 3%) as a separate platform fee expense under 6100. This way your income statement shows true gross revenue, not just what Airbnb deposited.

How do I categorize cleaning fees in my chart of accounts?

Cleaning fees collected from guests go to income (4200 - Cleaning Fee Income). What you pay your cleaner goes to COGS (5100 - Cleaning Labor). Keeping these separate lets you see your cleaning margin. Many operators collect $150 in cleaning fees but pay $110 to their cleaner, generating $40 in cleaning profit per booking that would disappear in combined accounts.

Do I need QuickBooks for a short-term rental business?

Not necessarily. QuickBooks works well but requires setup and maintenance. For STR-specific financial tracking, platforms like MagicBnB connect directly to your PMS and bank and understand STR categories natively. For tax filing, you still want a clean export your CPA can use, which both systems can produce.

How do I handle mortgage interest as an STR expense?

Mortgage interest goes to account 6600 as an operating expense. If the property is a mixed-use property (personal and rental use), you need to prorate the deduction based on rental days divided by total days available. Consult your CPA on the specifics, as this gets into Schedule E territory quickly.

About MagicBnB

MagicBnB is the financial intelligence layer for short-term rental operators. It connects to your PMS via OAuth, pulls bank transactions via Plaid, and shows true net profit per property in real time, with expense categorization built specifically for STR businesses. Features like the Bank Transaction Ledger with Property Allocation and the P and L Statement replace hours of manual bookkeeping with a clear, accurate picture of where your money is going. Visit magicbnb.io to start your free account.