Airbnb & Stayz Bookkeeping Australia: Per-Property Guide

Australian Airbnb and Stayz hosts should keep bookkeeping by property, not just by platform payout. A tax-ready workbook should reconcile gross platform income, platform fees, supplier invoices, private-use days, rented days, genuinely available days, any floor-space percentage and source-file references for each property and month.

That is the useful starting point for airbnb stayz bookkeeping Australia work because the accountant is not only checking whether income was declared. They are checking whether the evidence supports the way expenses were grouped, apportioned and reviewed. Cleaning after a guest stay, linen hire and a smart-lock subscription do not create the same review questions as interest, council rates, strata levies or insurance on a holiday home also used by the owner.

The timing matters. BDO reports that the ATO released TR 2025/D1, PCG 2025/D6 and PCG 2025/D7 to address holiday-home and short-term rental deduction issues, including apportionment and section 26-50 leisure-facility risk in its summary of the ATO holiday property deduction changes. For hosts, bookkeepers and property managers, that does not mean a spreadsheet can decide the tax treatment. It means the spreadsheet must keep the facts visible enough for the tax agent to test.

The practical output is a workpaper with one row set per property and month:

• Gross income from Airbnb, Stayz, Booking.com, direct bookings and manager statements.
• Platform fees, commissions, adjustments and cleaning amounts separated from the gross receipts.
• Supplier invoices coded to the relevant property and expense category.
• Private-use, rented, blocked and genuinely available days held outside the expense ledger.
• Floor-space percentage where only part of the dwelling is hosted.
• Claim percentage, GST treatment flag, capital-versus-repair flag and review notes.

This is different from a generic list of Airbnb tax deductions. The useful question is not only "can I claim this?" It is "what source document, property, month, use pattern and apportionment basis would let an accountant review this claim without rebuilding the records from scratch?"

Set up one property-month record set

Build the spreadsheet around a property code and a month before entering income or expenses. That single design choice prevents a common short-term rental bookkeeping problem: one owner summary, one bank account or one Airbnb login quietly mixing several properties, platforms and use patterns.

For a practical airbnb tax australia spreadsheet per property, use separate table areas or tabs for:

• Property master list, with property code, address, ownership notes and whether the listing is whole-property or part-property hosting.
• Platform income, with one row per payout line or booking summary.
• Supplier invoices, with one row per source document or line item where line-level detail is needed.
• Property-manager disbursements, separated from the manager's summary totals.
• Holding costs, such as council rates, strata levies, insurance, loan interest, utilities and body corporate charges.
• Occupancy and private-use log, with rented days, owner-use days, blocked days, maintenance days and genuinely available days.
• Asset and capital-improvement log, kept separate from ordinary operating expenses.
• Apportionment and review notes, where the accountant can record the basis used and any unresolved judgement calls.

The columns should serve the tax review, not just the bank reconciliation. Useful fields include property code, month, source file, source page where available, supplier name, ABN if visible, invoice date, expense category, amount, GST-visible amount, capital-versus-repair flag, apportionment basis, claim percentage and accountant notes.

That level of structure is especially important for costs that look simple in a household budget but become messy across multiple properties. Rates notices, water charges and strata levies need property-level coding, and a host with several listings should not rely on a single annual total. A workflow for Australian council rates notices for multi-property portfolios is useful for the same reason: the address, assessment period, amount and source file must survive the move from document to workbook.

The spreadsheet does not have to decide whether every amount is deductible. It should make the evidence testable. A tax agent can then see which costs were direct guest-stay costs, which were whole-property holding costs, which items need capital treatment and which percentages were applied.

Reconcile platform income at gross, then explain the fees

Airbnb, Stayz and Booking.com reports are income evidence, but they are not a complete tax workpaper. The first pass should split gross booking income from the amounts withheld or deducted before the host receives cash.

For each booking or payout period, capture the platform, property code, guest stay dates, gross accommodation amount, cleaning fee charged to the guest, host service fee, platform commission, adjustments, refunds and net payout. If a cleaning amount is collected through the platform and later paid to a cleaner, keep the gross guest charge, the platform treatment and the supplier invoice trail separate. Otherwise the workbook can make income, fees and cleaning costs look like a single net number.

Stayz Owner Reports, Airbnb CSV exports and Booking.com statements also have different layouts, timing and terminology. A monthly workbook should normalise them into one property-level income table rather than letting each platform's reporting format dictate the accounting format. That is even more important when the same property is listed across several platforms or when direct bookings sit beside platform bookings.

Managed properties add another layer. A property manager's monthly statement may show income, fees, owner disbursements and supplier costs in one summary, but the accountant still needs to know what sits behind the total. Reconciling Australian property manager owner statements to Excel is a related workflow because the manager statement is often the bridge between platform data, bank deposits and individual supplier documents.

The platform export will not contain everything that drives the deduction schedule. It will not hold the council rates notice, the body corporate levy, the electricity invoice, the smoke-alarm compliance certificate, the plumber's invoice, the insurance renewal or the depreciation schedule. Treat platform income as one evidence stream in the workbook, not as the workbook itself.

Turn supplier invoices into claimable evidence fields

The expense side is where short-term rental records usually stop being tidy. A host may have Airbnb payouts in one export, a Stayz report in another, cleaner invoices in email, linen hire as PDFs, smart-lock subscriptions as receipts, rates notices from council, strata levies from the owners corporation, utility bills from separate portals and repair invoices from local trades.

For each supplier document, capture the fields an accountant can test later:

• Property code.
• Supplier name.
• ABN if visible.
• Invoice date.
• Expense category.
• Amount.
• GST-visible amount or GST flag.
• Source file and page reference where available.
• Capital-versus-repair flag.
• Notes for unusual items, mixed-property invoices or owner-paid reimbursements.

The category matters. Cleaning, linen, consumables, key handling and guest-turnover costs are different from whole-property holding costs such as insurance, strata levies, council rates and interest. Repairs and maintenance need enough description to distinguish them from improvements. Compliance certificates for smoke alarms, gas or electrical safety should not be hidden in a generic "other" bucket if the accountant may need to review the nature of the cost.

This is the point where document processing can do useful work without pretending to replace tax judgement. With Invoice Data Extraction, hosts or bookkeepers can extract supplier invoice data to Excel by uploading PDFs, JPGs and PNGs, describing the required fields in a prompt and exporting the structured result as Excel, CSV or JSON. The workflow can include property code, supplier, invoice date, ABN if visible, amount, GST flag, capital-versus-repair flag and source-file reference. It should be used alongside platform CSVs supplied by the host, not described as a native Airbnb or Stayz integration.

For a multi-property host, the aim is consistency. A cleaning invoice for Property A, a pool-service invoice for Property B and a body corporate levy for Property C should land in the same workbook structure, with enough source detail that the accountant can click back to the original document instead of chasing email attachments during tax preparation. For landlords who need those source documents rolled into tax-return schedule categories, a per-property RNTLPRPTY rental schedule built from supplier invoices follows the same document-first approach.

Record the apportionment basis before calculating the claim

A short-term rental apportionment Australia workbook needs the inputs before it needs the formula. If the private-use log, available-days record or floor-space basis is weak, a neat claim percentage can still be hard to defend.

For time-based apportionment, keep a daily record of how the property was used. Separate rented days from owner private-use days, family or friend stays, blocked days, maintenance days and days the property was genuinely available for rent. Do not treat every empty night as automatically available. The record should help the accountant see whether the property was realistically offered to guests, including whether pricing, booking conditions and blocked peak periods are consistent with genuine commercial availability.

For area-based apportionment, the spreadsheet needs enough detail to show what part of the dwelling was used to earn rental income. Spare-room hosting while the owner lives in the property is different from renting the whole home. Record the guest-exclusive area, any shared areas and the basis used for the floor-space percentage. Where both time and space matter, such as part-property hosting for only part of the year, the workbook should preserve the combined basis rather than reducing everything to an unexplained percentage.

TR 2025/D1 and the draft practical compliance guidance make this record-keeping more than an administrative preference. The accountant may need to test rented days, private-use days, genuine availability and the basis for claiming mixed-use expenses. A TR 2025/D1 holiday home apportionment spreadsheet should therefore store the facts that produce the claim percentage, not only the final claim percentage itself.

Section 26-50 adds a separate risk for holiday homes that are also used for private recreation. At a high level, holding costs such as interest, council rates and insurance may need a separate review where the property could be seen as principally a leisure facility, unless the facts support the relevant exception, such as being used or held mainly to produce assessable rental income. Keeping those categories separate helps the tax agent review leisure-facility risk without first untangling the ledger.

The strongest private-use tracker is boring by design: date, property code, status for the day, platform booking reference if rented, private-use reason if blocked, maintenance reason if unavailable and notes where the evidence is not straightforward.

Keep GST and capital items as review flags

GST should be captured in the workbook, but not assumed. Ordinary residential premises hosted on Airbnb or Stayz are generally an input-taxed category for GST purposes, so GST-visible supplier invoices do not automatically create input tax credit entitlement. Commercial residential premises are a separate review category, and the workbook should preserve the facts needed for an accountant to assess that distinction.

Use a GST treatment flag rather than a single yes-or-no column. The workbook can record whether GST is visible on the supplier invoice, whether the supplier appears to be registered, whether the property is being reviewed as residential premises or commercial residential premises, and whether the accountant has confirmed the treatment. This keeps the source data intact while leaving the GST decision with the person advising on the tax position.

Capital items need the same discipline. A new appliance, major furniture package, renovation, replacement hot-water system or structural improvement should not be flattened into the same monthly expense bucket as cleaning or linen. Capture the asset description, supplier, invoice date, amount, property code, source file, private-use context and a repair-versus-improvement flag for review.

This is where depreciation and apportionment meet. A capital item may need to sit in a depreciation schedule, and the deductible portion may still depend on private use, rented days or the part of the property used to earn income. Keeping those items in an asset log makes Australian tax depreciation schedule extraction part of the same evidence chain rather than a separate clean-up job at year end.

The safest spreadsheet design is deliberately conservative: capture what the documents say, flag what needs judgement and avoid converting GST-visible amounts or capital purchases into claims before the accountant has reviewed the facts.

Hand the tax agent a workbook they can test

The finished handoff should let the tax agent review evidence, assumptions and unresolved questions without reconstructing the year from bank feeds and platform downloads.

Include the workbook, the original Airbnb, Stayz and Booking.com exports, property-manager statements, the supplier invoice source folder, occupancy and private-use records, the capital item log and a short questions list. The questions list is useful because it separates known uncertainty from missing admin. A host can flag private stays during peak periods, mixed-use rooms, unusually high pricing, owner-paid repairs, possible capital improvements or GST treatment questions before the tax review starts.

Within the workbook, make the review trail visible. The useful columns are source reference, property code, month, expense category, apportionment basis, claim percentage, GST treatment flag, capital flag and accountant notes. If the accountant changes the treatment, the workbook should show what changed and why, rather than replacing the original record with an unexplained final number.

For an owner with one holiday unit, that structure prevents a platform payout from becoming the whole tax record. For a bookkeeper handling several Airbnb and Stayz properties, it creates a repeatable monthly process: import platform income, extract supplier documents, update occupancy and private-use days, flag capital and GST questions, and hand over a workpaper that supports review.

That is the practical standard for airbnb stayz bookkeeping Australia under the current holiday-home environment: not a spreadsheet that promises the answer, but a record set that makes the answer auditable.