Why does my profit look wrong? A step-by-step check
Work through your numbers in order: filters and dates, connections, how income is dated, deposits waiting for your answer, transfers, then expenses and currency. Most gaps come from one of the first few. This guide takes about 15 minutes and ends with figures you can trust.
Takes about 15 minutes
What you need
- Your booking system and bank already connected
- The page, the date range and the number you expected, written down
Tick each step as you go. 12 steps
Rule out the simple causes
2 stepsSet the date range, properties and channel at the top of the page to the dates you expect. A property or channel filter hides everything else.
Open Integrations and check the bank and booking system are connected. Reconnect and run a sync if either has expired.
More detail: Why do my numbers look wrong? A checklist
Check how income is dated
2 stepsOn Overview, compare Booked revenue with Payouts received in the Cash vs accrual card. Income counts in the month of check-in, not the payout date.
Remember that reservations count confirmed stays only, and that kept cancellation fees count as income.
More detail: Which month does a booking count in?
Answer deposits and check transfers
3 stepsOn Transactions, choose All time and click any Needs review badge. Answer This is income, My PMS already counted this or A transfer between my own accounts.
Open the Transfers tab. Check the rows under Only one side found and mark real moves Yes, my transfer.
Open the Filtered out tab and Restore any real deposit or charge that was hidden by mistake. A deposit with a Payout badge on All transactions is matched to a payout and is not listed there.
More detail: Why is a bank deposit not matched to a payout?
Fix expenses
3 stepsOn Profitability, read Needs your attention and choose Allocate it to assign spending that has no property.
Open the Expenses tab and set a category on charges marked Uncategorized. Use Set category... on a merchant to fix all its charges at once.
If a bill pays for another month, set Counts towards when you allocate it.
More detail: What does "Uncategorized" mean on an expense?
Check owners, currency and coverage
2 stepsIf a home has an owner contract, check the Owner payouts line in the Business breakdown. It comes off profit.
Open the Profit and Loss report and read About these numbers. It shows payout coverage and tax collected. If it says Multiple currencies detected, choose one reporting currency.
More detail: How do I read the Profit and Loss report?
When it worked
You know which step explains the gap. Either the numbers were right under a different rule, or you fixed the cause and the totals now match your bank and your bookings.
People also ask
Work through the causes in order: the date range and filters, a bank connection that has stopped syncing, the check-in date rule, cancelled bookings, deposits waiting for your answer, transfers hidden from totals, unallocated or uncategorized expenses, and currency. Most mismatches come from the first few.
Read the full walkthroughProfit is the money your bookings pay you, minus your expenses. MagicBNB takes your net payout from reservations, subtracts the bank expenses assigned to your properties and business, and subtracts any owner payouts. The result is Overall Business Profit. Margin is profit divided by revenue.
Read the full walkthroughAfter each sync, MagicBNB compares every incoming bank deposit with the payouts your booking system expects. A deposit is matched when the amount is exactly the same, the currency is the same, the date is within about 5 business days, and only one payout fits. Matched deposits are tagged Payout.
Read the full walkthrough