Get your books ready for your accountant

Before you send anything, categorize your expenses, assign them to properties, check transfers and deposits, then export the Profit and Loss report and the monthly report. This guide takes about 30 minutes and leaves your accountant with clean, labeled numbers.

Takes about 30 minutes

What you need

  • Your booking system and bank connected, with the period you need already synced
  • The start and end dates your accountant asked for

Tick each step as you go. 10 steps

Categorize your expenses

2 steps
  1. Open Profitability, then the Expenses tab, and set the dates to the period you need.

  2. Set a category on every charge marked Uncategorized. Use Set category... on a merchant to file all its charges, and Make it a rule for payees you pay by transfer.

More detail: How do I change a category and make a rule?

Allocate to properties

2 steps
  1. Switch the list to Not allocated and assign each cost to a property. Use Split by for a bill shared by several properties, and Business expense for company costs.

  2. For a bill that pays for another month, set Counts towards to the month it belongs to.

More detail: How do I assign an expense to a property?

Check deposits and transfers

2 steps
  1. On Transactions, open the Transfers tab and clear the rows under Only one side found, so no payment is hidden by mistake.

  2. Answer any deposit marked Needs review, and check the Filtered out tab for real income or charges hidden by mistake.

More detail: What are internal transfers and why are they not counted?

Export the Profit and Loss report

2 steps
  1. Choose Profitability in the sidebar, click a property and choose View full P&L report. Set the dates. Open About these numbers and check nothing says Profit may still change. The report covers one property, so repeat for each property your accountant needs.

  2. Choose Export and download P/L Report (PDF), P/L Summary (CSV), Allocated expenses (CSV) and Unallocated expenses (CSV).

More detail: How do I export a report as a PDF or CSV?

Export the booking detail

2 steps
  1. On the P&L, also download Income detail (CSV) for the bookings behind each income line.

  2. For month-by-month booking lists, open Reports, then Build New. Pick the month and the Taxes Template, then choose Export PDF, or Export CSV from Full Preview. Repeat for each month.

More detail: How do I build the monthly report?

When it worked

Your accountant gets a Profit and Loss PDF and CSV files with income, allocated and unallocated expenses, plus a monthly booking report. Every charge is categorized and every deposit explained.

People also ask

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

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

MagicBNB reads each bank charge and files it by this order: your own choice, then a payee rule you made, then a merchant you categorized before. Transfers and card payments are recognized from the bank data. Anything else is marked Uncategorized for you to pick, rather than guessed.

Read the full walkthrough

An internal transfer is money you move between your own accounts. It is not income or an expense, so MagicBNB leaves it out of your totals. It pairs a withdrawal and a deposit of the same amount in two accounts within 3 days, and hides one-sided transfers until you check them.

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.