How do I build the monthly report?

Last updated November 18, 2026

Open Reports, then Build New. Pick the month, year, channel and properties, then choose the columns you want, such as check-in date, guest name and payout. A live preview updates as you go. Save it as a template to rebuild next month in a few clicks.

Takes about 10 minutes

What you need

  • Your booking system connected with bookings in the month you want
Open in MagicBNB

The monthly report lists the bookings that check in during one month, one row per booking, with the columns you choose. It includes accepted and cancelled bookings, and the Status column tells them apart.

Build it

  1. 1

    Open Reports and choose Build New.

  2. 2

    At the top left, set Month, Year, Channel (the default is All channels) and Properties.

  3. 3

    Pick a Template: Custom layout, a starter (Co-host Template, Booking Data Template or Taxes Template) or one of your saved ones.

  4. 4

    On the Columns tab, click chips to add or remove columns. They are grouped as Booking, Financial and Taxes & Payout, and at least one column must stay selected.

  5. 5

    On the Financial Summary tab, see Revenue, Total Expenses, NOI (net operating income) and Margin. Turn on Expense breakdown, Expense detail list or Unallocated transactions to include them.

  6. 6

    On the Branding tab, add your company name, logo, report title, sender and an optional recipient.

Save it as a template

  1. 1

    Choose Save, give it a name such as "Monthly owner packet", and confirm.

  2. 2

    Next month, open Reports. Your template is under Your Templates. Choose Generate followed by the month name, or Edit to change it. The Quick Generate banner has Generate Report and Edit first for your last-used template.

  • Update saves changes to the template you are using.
  • Duplicate makes a copy to edit.

To export, see How do I export a report as a PDF or CSV?.

When it worked

A live preview of the month, ready to export. Your saved template appears under Your Templates for next month.

If something goes wrong

Reload Reports and open the template from Your Templates.

At least one column must stay selected.

Choose Reload Preview. If it repeats, change the month or properties and try again.

Give the template a name and try again.

NextHow do I export a report as a PDF or CSV?

Was this answer helpful?

People also ask

On the Profit and Loss report, open the Export menu and choose a PDF or a CSV file. On the monthly report, choose Export PDF, or open Full Preview to get Export CSV too. A CSV is a plain spreadsheet file you can open in Excel or Google Sheets.

Read the full walkthrough

Open Profitability, click a property, then choose View full P&L report. The top shows profit and margin for the dates you pick. Below, a chart called Where the money went and a Statement list income, expenses, owner payout and profit line by line. Tap any row to see the bookings or bank charges behind it.

Read the full walkthrough

A cancelled booking does not count as a reservation, but money you kept from it does count as income. That includes a cancellation fee or a non-refundable deposit. It shows as Kept from cancellations and is part of your net payout.

Read the full walkthrough

Open a listing and choose Compare, or go to the compare page directly and pick a Left and a Right listing. Tabs show financials, reservations, guest reviews, profit and loss, expenses and transactions side by side. On Profitability, the Properties tab ranks every property by profit and margin.

Read the full walkthrough

Trends shows how your numbers move over time, compared with the same period a year earlier. It has six tabs: Radar for what needs attention, Earnings, Bookings & Demand, Operations, Guest Sentiment and Future Pacing. Hover the info icon on any card to see exactly how it is calculated.

Read the full walkthrough

Open Analyses under Property Analyzer, choose New Analysis, pick Leasing or Purchase, enter the address, rates and costs, and choose Generate report. You get projected revenue, costs, key metrics and risk indicators. Use the More options menu to export it or edit your inputs.

Read the full walkthrough

Still stuck? Email support@magicbnb.io and a person will reply, usually within 24 hours. Contact options

See your real profit per property

Connect your booking system and bank and MagicBNB does the rest.