From Spreadsheets to a Live P and L: How One Co-Host Scaled to 12 Properties

Priya managed 9 STR properties and spent 10 hours a month building owner statements in Google Sheets. One missed deadline almost cost her a client. Here is how she scaled to 12 without the chaos.

Eight Hours a Month That Should Not Have Existed

Priya started co-hosting in 2021, helping a friend rent a Scottsdale condo on Airbnb while the friend traveled for work. She handled listing optimization, guest communication, and cleaning coordination. The owner paid her 20% of gross revenue. It was simple, manageable, and profitable.

By mid-2023, she had seven owner clients and nine properties spread across Scottsdale, Tempe, and Mesa. The business had grown the way good STR businesses tend to: one referral at a time, each new client arriving because a previous one mentioned her name. She had built something real. And the monthly reporting process was threatening to break it.

Each month, Priya would block out a full day to build owner statements. The process: export a CSV from Airbnb for each property, do the same for VRBO listings, pull her management fee calculation (20% of gross per property), open the Google Sheet for each owner, manually enter every expense she had paid that month for each property, format the totals, convert to PDF, and email. Nine properties meant nine separate workstreams. At nine properties, she missed the tenth-of-the-month deadline twice. The second time, one of her owners, a semi-retired couple in Chandler who owned two of her Scottsdale listings, sent a message that made her stomach drop. They wanted a call. On the call, they told her they were evaluating whether to continue the relationship. The statement had contained a math error that overstated their net payout by $340. They found it themselves.

The Tool Search

Priya spent about three weeks evaluating options after that call. She was not looking for general accounting software. She needed something that understood how STR revenue worked, could separate income by property, handle per-property expense allocation, and produce something professional enough to send to owners without manual formatting on her end.

She tried Guesty reporting features first. The platform showed booking revenue cleanly but had no mechanism for importing actual bank expenses or allocating them by property. The owner statement it generated showed gross bookings and her management fee deduction, but no expense detail below that. Owners would still need to track their own costs, which defeated the purpose.

She tested QuickBooks next. QuickBooks is excellent general accounting software. It had no concept of STR expense categories, no understanding that a cleaning fee on one property was structurally different from a cleaning fee on another, and no native way to generate per-property P&L statements in a format that made sense to someone reviewing rental income. After two weeks of trying to build custom categories, Priya abandoned it.

She found MagicBnB through an STR operator Facebook group where a property manager in Nashville mentioned using it for owner reporting.

The Setup: 45 Minutes to Nine Properties

Priya connected her Hostfully PMS account through OAuth and linked two business checking accounts through the Plaid integration. The setup took approximately 45 minutes from account creation to seeing her first property dashboard. MagicBnB pulled in all nine properties automatically, along with all reservations and six months of historical bank transactions.

The historical transaction import was the most time-consuming part of onboarding. Six months of bank history across two accounts meant roughly 340 transactions to review. Priya spent one afternoon, about three and a half hours, going through the transactions and allocating each one to the correct property. Recurring expenses like insurance, utilities, and HOA dues could be set as recurring allocations after the first assignment, which reduced the ongoing work significantly. After that afternoon, every new transaction coming in from the bank feeds appeared in the Bank Transaction Ledger and could be allocated to a property in one or two clicks.

The Owner Statement That Changed Her Sales Pitch

The first time Priya generated an owner statement through MagicBnB, she sent it to the Chandler couple who had nearly terminated her contract. The statement showed: gross bookings broken down by platform (Airbnb versus VRBO), her 20% management fee deducted as a line item, every property-level expense with category labels, and a final net owner payout figure that tied precisely to what had been deposited into their account.

The response came back in four hours. This was exactly what they had been asking for. Not just the number, but the itemization. They wanted to see that their $3,400 in gross March bookings generated $680 in management fees, $210 in cleaning costs, $85 in supplies, $142 in insurance, and $174 in utilities, leaving them a net payout of $2,109.

A week later, the Chandler couple referred her to a colleague who owned two properties in Tempe. During the pitch call, Priya shared a sample owner statement as a PDF. The colleague signed a co-hosting agreement the same week. That was the first time Priya had won a client in part by showing them the quality of her reporting before they had even become a client. She used the same approach two more times over the following four months. Both converted. By early 2025, Priya had 12 properties under management.

Owner reporting is not overhead. It is the client-facing product of a co-hosting business. If statements are late, inaccurate, or hard to read, the relationship degrades regardless of how well the properties perform.

The Numbers: What Twelve Properties Looks Like

At 12 properties in 2025, the portfolio average gross monthly revenue per property is $3,200. Priya charges 20% of gross as her management fee.

• Management fee per property per month: $640
• Total management revenue across 12 properties: $7,680/month
• Annual management revenue: $92,160

The monthly reporting process using MagicBnB Owner Statements now takes 22 minutes. That includes reviewing each statement for accuracy, exporting the branded PDFs, and sending them to each owner via email. She does this on the morning of the eighth, giving herself two days of buffer before her tenth-of-the-month deadline.

The Profitability Discovery She Did Not Expect

Three months after reaching 12 properties, Priya opened the MagicBnB Profitability Rankings with a different question in mind. She had been focused on owner statements and her own management revenue. She had not spent much time analyzing net margins at the property level from the perspective of her owners.

What she found made her uncomfortable in a productive way. Two properties in her portfolio, both in Mesa, were running net margins in the 14-17% range after her management fee and all operating expenses. For the owners of those properties, the economics were thin. Her 20% management fee was consuming a disproportionate share of what the property generated, not because she was overcharging, but because the operating costs on those two properties were high relative to the revenue they produced.

Priya used the data to initiate conversations with both owners. On the high-HOA property, she renegotiated her fee to 17% of gross, accepting slightly lower management revenue in exchange for keeping the owner relationship healthy. On the high-maintenance property, she helped the owner prioritize deferred maintenance items that would reduce ongoing costs, and they agreed to revisit the fee structure after six months of improved margins. Both owners remained clients.

Using Milo to Answer Owner Questions On the Spot

Owner questions arrive at unexpected moments. A client might text on a Thursday evening asking why their February payout was lower than January. Before MagicBnB, Priya would have to open the Google Sheet for that property, cross-reference the Airbnb CSV, and write back a paragraph-length explanation after reconstructing the math.

Now she opens the Milo AI interface in MagicBnB, types the question with the property name, and gets a plain-English answer with the relevant numbers already cited. Milo has full context on every property in the portfolio, every transaction, every expense category. She can ask: why is the Tempe property net payout lower in February than January, and Milo produces an answer that references the specific expense lines that changed, the difference in booking days between the two months, and whether platform fees shifted. She copies the relevant parts into her reply to the owner.

Key Lessons for Co-Hosts Scaling From Five to Fifteen Properties

• Owner reporting is not overhead. It is the client-facing product of a co-hosting business.
• Per-property expense visibility is essential for renegotiating fee structures when market conditions or operating costs shift.
• Connecting bank accounts directly to your portfolio management tool eliminates the monthly manual export-and-enter cycle that breaks down as portfolio size grows.
• Prospective owners respond to seeing the quality of your reporting before they sign. A sample owner statement in a pitch call is a sales asset.
• Time savings from automation compound. The 8 hours per month Priya recovered went to new client acquisition, which added three clients over 12 months.

About MagicBnB

MagicBnB (magicbnb.io) is a portfolio intelligence platform for short-term rental operators. The Owner Statements feature generates branded, itemized PDFs ready to send by the tenth of every month. The Monthly Portfolio Report Builder and Profitability Rankings give co-hosts the data they need to have honest conversations with owner clients about fee structures and property performance. Milo AI answers any portfolio question in plain English with the specific numbers already pulled. Visit magicbnb.io to see how it works for your portfolio.