Airbnb Bookkeeping: A Complete System for Multi-Property Hosts

A $3,290.42 Airbnb deposit is three reservations across two properties with $603.58 of platform fees already removed. Book it as one line and every per-property number below it is wrong.

An Airbnb bookkeeping system that survives a multi-door portfolio has four parts: separated bank accounts, a chart of accounts with a clear capitalize line, gross revenue recorded apart from platform fees, and a weekly categorization pass. The third part is the one almost everybody skips, and it is why a $3,290.42 Airbnb deposit covering three reservations across two properties understates both revenue and expenses by $603.58.

Key takeaways

• Airbnb nets its single 15.5% host service fee out of the payout before it reaches your bank, so $3,894 of gross bookings arrives as $3,290.42 and recording the deposit as revenue hides $603.58 of fee expense.
• A $185 cleaning fee against a $142 cleaner invoice looks like $43 of margin, but the 15.5% fee applies to the cleaning fee too, leaving $14.32 per turn and $3,064 across 214 turns instead of $9,202.
• The IRS de minimis safe harbor lets a taxpayer without an applicable financial statement expense any item up to $2,500 per invoice, so a $1,780 sofa is deductible this year and a $4,300 HVAC replacement is not.
• Airbnb is only required to issue a Form 1099-K once payments exceed $20,000 and transactions exceed 200, after the One, Big, Beautiful Bill restored the pre-2021 threshold, and the income is reportable either way.
• An operator with more than three rental properties attaches as many Schedules E as the portfolio needs, but fills the Totals column on only one of them.

Start with four bank accounts, not one

Four accounts do the job: an operating checking account, a reserve savings account, one business card, and a separate owner-funds account if you hold money that is not yours. Every payout lands in operating. Every operating expense pays out of operating or the card. Nothing else touches either.

The reserve account exists so tax and capital replacement stop being a decision. A six-door portfolio taking $241,670 of net payout and sweeping 12% of every deposit on arrival moves $29,000 into reserve without deciding to in any given month. Sweep manually and you sweep in good months and skip the bad ones, which is backwards.

Co-hosts have a harder rule. Money collected for an owner is not revenue and is not yours, and one commingled account makes that impossible to prove when a relationship goes sideways.

Categorization is where the hours go once the accounts are clean. MagicBNB's Smart transaction ledger tags every bank transaction with a suggested category and a high, medium, or low confidence band, and its allocate-to-property dialog splits one transaction across several doors, so a $412 pest-control invoice covering four properties posts as four lines instead of one you will be guessing at in April.

The chart of accounts, and where the capitalize line sits

Around eighteen accounts covers a portfolio under twenty doors, and the only hard call is where an expense stops being a deduction and turns into depreciation. Income splits four ways: nightly revenue, cleaning fee income, other guest income (pet fees, early check-in, extra guest), and damage recovery.

Three contra-revenue accounts sit underneath: platform service fees, channel commissions, and refunds and adjustments. Keeping fees in their own account instead of netting them into revenue is what lets you answer whether a channel is worth its take rate.

• Direct operating: cleaning and turnover labour, supplies and consumables, utilities, internet and streaming, repairs and maintenance.
• Fixed carrying: insurance, property tax, HOA dues, permits and licences, mortgage interest.
• Overhead: software and subscriptions, management and co-host fees, professional fees, marketing.
• Non-cash and capital: furnishings expensed under the safe harbor, capitalized improvements, depreciation.

The capitalize line has an actual number behind it. Under the IRS tangible property final regulations, a taxpayer without an applicable financial statement may elect the de minimis safe harbor and deduct up to $2,500 per invoice or per item, substantiated by the invoice. The threshold rose from $500 to $2,500 for tax years beginning on or after January 1, 2016. A $1,780 sofa is a current-year deduction. A $4,300 HVAC replacement is not, and it depreciates.

The election is not automatic. It is a statement titled Section 1.263(a)-1(f) de minimis safe harbor election, attached to a timely filed original return. Assume it applies without filing it and the furniture deduction does not exist.

Build the list once and stop renaming things. The full line-by-line version is in our chart of accounts for short-term rentals.

A channel payout is not revenue

The payout is revenue minus fees, and recording it as revenue destroys two numbers at once. Take a single Airbnb deposit of $3,290.42 landing on a Tuesday in a six-door portfolio. It is three reservations.

• Reservation A, Property 1: five nights at $242 plus a $185 cleaning fee is $1,395 gross, less $216.23 of fee, paying out $1,178.77.
• Reservation B, Property 1: three nights at $198 plus a $185 cleaning fee is $779 gross, less $120.75 of fee, paying out $658.25.
• Reservation C, Property 2: seven nights at $215 plus a $215 cleaning fee is $1,720 gross, less $266.60 of fee, paying out $1,453.40.
• Property 1 owns $1,837.02 of that deposit and Property 2 owns $1,453.40, against $3,894 of gross bookings and $603.58 of platform fees.

Booked as one deposit, the portfolio still nets the same. Every per-property number underneath it is wrong.

The fee is a single line now, which makes the arithmetic easier and the omission larger. Airbnb's own host resource on simplified service fees sets the combined host-paid fee at 15.5% and states the consequence plainly: a host who leaves a $100 price unchanged now earns $84.50. Across $286,000 of annual gross bookings that fee is $44,330. Recording net payouts as revenue reports revenue $44,330 low and expenses $44,330 low, which is fine for net income and wrong for every ratio a lender computes off it.

Cleaning fees are where this bites hardest, because the fee applies to them too. Collect $185, pay the cleaner $142, and the apparent margin is $43. Subtract the $28.68 of platform fee riding on that cleaning fee and the real margin is $14.32. Over 214 turns that is $3,064 rather than $9,202, and the $6,138 gap is why operators think cleaning is a profit centre when it barely breaks even.

Expenses have the same allocation problem and a cheaper fix. MagicBNB's Recurring rules tie a merchant to a property split once, then apply that split to every future transaction from the same merchant and backfill the past ones, so an internet bill covering three doors at 40/35/25 is allocated correctly after one decision instead of twelve.

The 20-minute weekly pass

Twenty minutes on the same day each week keeps the books current, and the sequence is fixed so it never needs thinking about.

• Categorize every transaction since the last pass, starting with the low-confidence ones because the obvious ones are already right.
• Split any shared invoice across properties while you still remember which doors it covered.

• Match each channel deposit to its reservations, or at minimum confirm the deposit total ties to the payout report.
• Capture receipts for anything paid in cash or on a personal card, then reimburse it out of operating so the trail exists.

Receipt capture is not optional housekeeping. The IRS guidance on rental recordkeeping is direct: you generally must have documentary evidence such as receipts, cancelled cheques, or bills to support your expenses, and if you are audited and cannot produce it you may face additional taxes and penalties. A bank line reading HOME DEPOT $214.86 proves money left. It does not prove what it bought or which door it was for.

The monthly close, in six steps

A close on a clean week is under an hour, and it runs in one direction: cash first, then allocation, then reporting. Reverse that order and you end up reconciling a P&L an owner already has.

• Reconcile every bank and card account to its statement balance, and stop until the difference is zero.
• Tie each channel payout report to the deposits that hit the bank, flagging any deposit that arrived in a different month than the stay.
• Clear every unallocated transaction so no expense sits at the portfolio level unassigned.
• Post the non-cash entries: depreciation, and any accrued item you track outside the bank feed.
• Review per-property margin against the prior month and open anything that moved more than five points.
• Issue owner statements, then lock the period so a later edit cannot silently change a number you already sent.

Step three is the one that stretches. MagicBNB's Expense inbox isolates only the unallocated transactions rather than showing the whole ledger, so the close starts against a queue of twelve items instead of a scroll through four hundred rows that are already correct.

The step-by-step version of this sequence, with the checks that catch a bad close before an owner sees it, is in our STR bookkeeping monthly close guide.

What your CPA needs in January

Your CPA needs per-property income and expense totals, a fixed asset schedule, and an explanation for why the 1099-K does not match the bank. The first two fall out of the system above. The third catches people every year.

Schedule E Part I takes income, expenses, and depreciation per property, and the IRS instruction for a larger portfolio is specific: with more than three rental properties you attach as many Schedules E as you need, complete lines 1 and 2 including the street address on each, and fill the Totals column on only one. A blended ledger cannot produce that without a February rebuild.

The 1099-K mismatch has a simple cause and a changed threshold. The IRS announcement on the One, Big, Beautiful Bill threshold confirms the pre-2021 rule is back retroactively: a third party settlement organization need not file a 1099-K unless gross reportable payments exceed $20,000 and the transaction count exceeds 200. A smaller portfolio may get no form and still owes tax on every dollar. A larger one gets a form reporting gross, which never equals the bank deposits, because the $44,330 of platform fee never arrived.

Timing is the last piece. Most individual operators use the cash method, so income counts in the year received and expenses in the year paid. A stay completed December 29 that pays out January 3 is January income. Book it to December because the guest slept there and revenue lands in the wrong tax year.

Frequently asked questions

Do I need separate books for each Airbnb property?

Yes, because Schedule E Part I is filed per property and lists income, expenses, and depreciation for each separately. A blended ledger also cannot tell you which of six doors is losing money, which is the question that changes what you do next quarter. Separate ledgers per property, one roll-up above them.

Should I record the Airbnb payout or the gross booking amount?

Record the gross booking as revenue and the 15.5% host service fee as its own expense line. On the example above that is $3,894 of revenue and $603.58 of fee, rather than a single $3,290.42 entry. Net income is identical either way. Every ratio built on revenue is wrong under the second method.

Does Airbnb send a 1099-K?

Only when gross payments to you exceed $20,000 and transactions exceed 200, following the One, Big, Beautiful Bill's retroactive restoration of the pre-2021 threshold. Falling under it changes nothing about what you owe. Rental income is reportable whether or not a form arrives.

Can I deduct furniture for my Airbnb in the year I buy it?

Up to $2,500 per invoice or per item, yes, if you elect the de minimis safe harbor and have no applicable financial statement. The test applies per line rather than to the whole shopping trip, so a $6,400 furniture order of eleven items each under $2,500 is fully deductible. The election statement attaches to a timely filed original return.

What is the difference between a repair and an improvement on a rental?

A repair keeps the property in ordinary operating condition and is deductible now; an improvement is a betterment, restoration, or adaptation to a new use and is recovered through depreciation. The IRS states plainly that you may not deduct the cost of improvements. Patching the deck is a repair. Replacing it is an improvement.

How often should I reconcile Airbnb payouts to my bank?

Weekly, because the cost of skipping rises faster than linearly. One skipped week is twelve transactions you still recognise. Three skipped weeks is forty, several of which you will allocate by guessing, and a guessed allocation is a per-property margin you cannot defend to an owner.

Set up the four accounts this weekend

Open the reserve account, move every property expense onto one business card, and run the first weekly pass on last week only. Then record one Airbnb deposit properly, gross revenue and platform fee on separate lines, and see how far your current per-property margin was off. Reconcile your portfolio in MagicBNB →

The gap between apparent cleaning margin and real cleaning margin is usually the first thing that shows up. On 214 turns it was worth $6,138.

About MagicBNB

MagicBNB is a portfolio intelligence platform for short-term rental operators running multiple doors. Its Bank account integration links checking, savings, business, and merchant accounts with real-time and historical sync, so there are no CSV uploads in the monthly close. The Net Payout source of truth drives one canonical calculation across profitability, listings table, property detail, and reports, and the Cash position card shows combined cash across every connected account before an autopay bounces. See it at magicbnb.io.