Docs›More guides

How to Manage Your Accounting in Mangobeds

9 min read

Mangobeds already knows what your property earned. Every invoice, payment and refund is in there. What it has never known is what you spent, and without that half you cannot see what a month actually made. The Accounting app adds the cost side, puts the two together for any period you choose, and turns the whole thing into a file your bookkeeper can import instead of retyping.

This guide walks through setting the app up, recording expenses, mapping your chart of accounts, and exporting your journal.

Accessing the Accounting App

  1. Log in to your dashboard: enter your Mangobeds credentials.
  2. Select your property: pick the property you want to keep books for. Accounting is set up per property, so each one keeps its own expenses and its own account codes.
  3. Open Apps: click on Apps in the sidebar.
  4. Find Accounting: it sits next to Invoicing in the list.
  5. Click Set up Accounting: that is the whole setup. Nothing to connect, nothing to configure before you can use it.

The two tabs

The app opens on Books, which is where you spend your time: the summary, your expenses and the journal export. The second tab, Sync, is where you connect an accounting system and see what has been sent to it. If you are keeping your books here and exporting them, you never need to open it.

Choosing a period

At the top of the Books tab there is a date range selector. Everything below it, the summary, the expense list and the export, follows the range you pick. It opens on this month and also offers last month, the last 30, 90 and 365 days, or a custom range for the exact dates your accountant asked for.

Where your revenue comes from

Open Settings and the first choice is Revenue comes from: Invoices or Bookings.

Invoices counts what you invoiced, on the invoice date. Pick it if you issue an invoice for every stay, for example through the Invoicing app.

Bookings counts every confirmed booking on its check-in date, so you see real revenue even if you never issue an invoice. If you use the Invoicing app, its tax rates are used to split the tax out.

The app starts on Bookings. You can change it in Settings until the first day has been sent to an accounting system. After that it stays as it is, because switching would send the same revenue again on different dates.

Note: Bookings counts a whole stay on its check-in day. Insights spreads a stay over its nights, so for a stay that crosses into the next month the two screens show different monthly figures. Both are right; they just answer different questions.

Channel commissions

Under Bookings, the commission each channel charged is counted as an expense automatically, in the Commissions category, on the booking’s check-in date. You do not enter it by hand.

When the channel sends the commission with the booking, that exact amount is used. For the rest, the app uses a percentage of the booking total. We fill in the usual rate for the main channels: Booking.com 15%, Airbnb 18%, Expedia 15%, Hostelworld 23%, Agoda 15% and Vrbo 12%. Every contract is different, so check them in Settings and change any that do not match yours. Set a channel to 0 to count no commission for it. The list only shows the channels you have bookings from.

A cancelled booking takes its commission with it. If your revenue comes from invoices, record the channel’s own invoice as an expense instead.

Reading the summary

Four figures sit above your expenses.

Revenue (net of tax) is what you earned in the period, with tax taken out. It comes from your confirmed invoices or your confirmed bookings, whichever you chose in Settings, and the hint under it says which and how many.

Tax collected is the tax portion of that same revenue, the amount you are holding on behalf of the tax authority rather than money you earned.

Expenses is the total of everything you recorded in the period, plus the channel commissions if your revenue comes from bookings.

Net is revenue minus expenses. This is the number most owners are actually looking for.

Underneath the Net figure you will also see how much was collected, which is the money that genuinely arrived in the period, payments minus refunds. It is deliberately a different number from revenue: an invoice you issued in March and were paid for in April counts as March revenue and April cash.

Note: a refund is counted on the day it was refunded, not the day the original payment was made. A January payment refunded in March belongs in March’s books.

Month by month

Under the summary, a chart shows the whole year one month at a time: revenue, expenses and what was left (net). Hover a month to see the exact amounts. Use the arrows to move between years, up to next year, so bookings you already took for the coming season show too.

The chart follows the same revenue choice as the summary, and includes repeating expenses and channel commissions. For occupancy, open the Insights app.

Recording an expense

Revenue arrives on its own. Expenses are the one thing you enter by hand.

  1. Click Add expense.
  2. Fill in the fields described below.
  3. Click Add expense to save it.

Date is the date of the expense, which is what decides the period it falls into.

Amount is always in your property’s currency. There is nothing to pick, and nothing to get wrong.

Category is what the money went on: Cleaning, Maintenance, Utilities, Supplies, Salaries, Commissions, Marketing, Software, Insurance, Taxes, Rent or Other. This is what makes your expense list readable a year from now.

Tax % is the tax rate on that expense, if you want it recorded. It is carried through to the export for your accountant. It is not split into a separate line, because recovering tax on purchases follows rules that differ by country and belongs in your accounting software.

Supplier is who you paid. The cleaning company, the electricity provider, the builder.

Reference is the number printed on their bill. It is what lets you find the paper receipt again from a row in Mangobeds, and it stops the same invoice being entered twice.

Repeats is for costs that come back: rent, salaries, software subscriptions. Pick weekly, monthly or yearly and you add the expense once. It then counts on the same day every week, month or year from its first date. A monthly expense on the 31st lands on the last day of shorter months.

Until appears when an expense repeats. Set the last date it should count, or leave it empty to keep it going.

Notes is free text for anything else you want to remember about it.

A repeating expense shows in the list once for every time it falls in the period, with a label saying how often it repeats. Editing or deleting it changes every repeat at once. If the cost changes from a certain date, set Until on the old one and add a new one from that date, so past months keep the old amount.

Note: Salaries appears as a category so that your profit figure is complete. Mangobeds does not run payroll, does not pay your staff and does not file social contributions. Record what payroll cost you, and leave the paying to your accounting software.

Setting up your chart of accounts

This step is optional, and you can safely skip it until your bookkeeper asks for it.

Every accounting package files transactions into numbered accounts. Switzerland has the KMU-Kontenrahmen, Germany has the SKR plans, Spain has the PGC. Your accountant already works with one of them, and their software will not accept the word "Cleaning" where it expects a number.

So the app lets you record their numbers once. Open Settings and, under the revenue choice, you will find two groups.

Transaction accounts covers the six things that come out of your invoices and payments: accommodation revenue, extras revenue, tax collected, accounts receivable, deposits held and bank.

Deposits held is the one worth a sentence. A security deposit is the guest’s money sitting with you, not money you earned, so it goes to a liability account until you hand it back rather than counting as revenue or as something you are owed. Mark a payment as a deposit in the Payments app and the journal files it there automatically.

Expense categories covers the twelve categories, one code each. Set Cleaning to 6040 once and every cleaning expense you ever record carries that code.

You do not have to start from nothing. The app seeds a conventional set of numbers (assets in the 1000s, revenue in the 3000s, payroll in the 5000s, running costs in the 6000s) that already produces a usable export. Show them to your bookkeeper and change only the ones they do differently. It takes them five minutes and they only do it once.

Exporting your journal

Click Export journal (CSV) and you get the whole period as a proper double-entry journal.

Each line carries the date, the account, a description, a debit or a credit, the currency, the tax rate where there is one, and a reference back to the invoice, booking or supplier bill it came from. Your invoices, your payments and your expenses are all in the same file, in the format accounting software expects to receive.

The app tells you how many lines are in the period before you export, and the totals always balance: every debit has a matching credit. That is not decoration, it is the check that tells your bookkeeper the file is sound.

Three things become journal lines.

An invoice, or a booking if your revenue comes from bookings, records what you are owed against what you earned, splitting accommodation, extras and tax apart.

A payment moves that amount from what you are owed into your bank. A refund does the same in reverse.

An expense records the cost against the category’s account and takes the money out of your bank. A channel commission is written the same way, under Commissions.

Sending your books to an accounting system

The export is how your books reach your accountant, and for most small properties that is genuinely all they need. If your bookkeeper works in a package instead, you can connect it on the Sync tab and the journal posts itself.

QuickBooks Online is connected today: see the QuickBooks connection guide for how it works. Nothing changes about the rest of the app when you connect one. Your ledger still lives here, expenses are still recorded here, and the CSV export is still there.

If you use a different package, tell us which one. We prioritise the ones our customers actually run.

Getting started

Open the Accounting app, add last month’s expenses, and look at the Net figure. Most owners find it is the first time they have seen revenue and costs for their property in one place without building a spreadsheet. From there, ask your bookkeeper for their account codes whenever you are ready, and the monthly export stops being a job anyone has to think about.