# How do I build the monthly report?

Source: https://magicbnb.io/help/reports/monthly-report · Category: Reports and exports · Last updated: 2026-11-18

**Short answer:** 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.

**Time:** about 10 minutes

**What you need:**
- Your booking system connected with bookings in the month you want

**Where in the app:** https://app.magicbnb.io/reports/monthly-portfolio-report?step=build

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. Open **Reports** and choose **Build New**.
   ![The Build report screen with Month, Year, Channel, Properties and Template menus and a live preview.](https://magicbnb.io/help/reports-monthly-builder.webp)
2. At the top left, set **Month**, **Year**, **Channel** (the default is **All channels**) and **Properties**.
   ![The Build report screen with Month, Year, Channel and Properties menus, a Template menu, three tabs (Financial Summary, Columns, Branding) and a live preview on the right.](https://magicbnb.io/help/reports-monthly-builder.webp)
3. Pick a **Template**: **Custom layout**, a starter (**Co-host Template**, **Booking Data Template** or **Taxes Template**) or one of your saved ones.
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. 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. On the **Branding** tab, add your company name, logo, report title, sender and an optional recipient.

## Save it as a template

1. Choose **Save**, give it a name such as "Monthly owner packet", and confirm.
   ![The save template dialog with the Template name box and a Save template button.](https://magicbnb.io/help/reports-save-template-dialog.webp)
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.
   ![A saved template card on the Reports page with Generate and Edit buttons.](https://magicbnb.io/help/reports-saved-template-card.webp)

- **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?](https://magicbnb.io/help/reports/export-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

- **A toast says "Saved template not found."** Reload Reports and open the template from Your Templates.
- **You cannot remove a column.** At least one column must stay selected.
- **The preview says "Error loading preview".** Choose Reload Preview. If it repeats, change the month or properties and try again.
- **Saving shows "Failed to save template."** Give the template a name and try again.

Related: [How do I export a report as a PDF or CSV?](https://magicbnb.io/help/reports/export-pdf-or-csv) · [How do I read the Profit and Loss report?](https://magicbnb.io/help/reports/profit-and-loss-report) · [What happens to money from a cancelled booking?](https://magicbnb.io/help/profit/cancelled-booking-money) · [How do I compare two properties?](https://magicbnb.io/help/reports/compare-properties)
