Automating your B&B bookkeeping: from booking to accounting software without retyping

There's one evening a month that no B&B owner puts in the brochure. The guests are gone, the rooms are ready, and there you are with three tabs open: the Booking.com extranet, your Airbnb dashboard and your own bookings. From those you type up invoices by hand, work out which payment belongs to which booking, and send the pile to your accountant — who emails you two weeks later because something doesn't add up.

That evening isn't a law of nature. It's the result of a chain that isn't connected anywhere. In this article we walk through that chain step by step: from booking to invoice to accounting software, where it breaks in practice, and what you can automate without putting your accountant out of work.

The chain you actually want

When your admin is set up properly, the road from guest to bookkeeping looks like this:

1. The booking arrives — via an OTA, your own widget or by phone — and lands in one system.
2. The stay lines appear automatically: nights, breakfast, tourist tax, any extras.
3. The invoice is drawn up with the right VAT rate per line and a sequential invoice number.
4. The payment is matched to it — bank transfer, online payment or virtual card.
5. The invoice moves on to your accounting software, booked to the right ledger account.

Every step where you have to intervene by hand is a step where an error can creep in. And the accommodation sector has more pitfalls in that chain than most other small businesses.

Where it breaks in practice

Multiple VAT rates on one invoice

A B&B invoice rarely uses a single rate. The overnight stay falls under the reduced accommodation rate, which in Belgium has stood at 12% since 1 March 2026. Breakfast, drinks or a bottle of cava don't. Lump those lines together and your VAT return is wrong — and you usually only find out at the quarterly filing. More on that rate in VAT on accommodation in Belgium.

Tourist tax isn't revenue

The tourist tax you collect for your municipality is money that passes through your hands but isn't yours. Book it as revenue and you'll pay tax on it needlessly. It belongs on your invoice as a separate, clearly recognisable line, and on its own account in your books. See Handling tourist tax.

OTAs pay out net, not gross

Booking.com withholds commission and transfers you the balance. If you book that transfer one-to-one as revenue, the commission vanishes from your figures — even though it's a deductible cost. Your revenue looks lower than it is, your costs lower than they are, and your margin is wrong on every side. Gross booking value and commission belong in your books separately.

Virtual cards and payment providers

With a virtual credit card the money doesn't arrive on the booking date, but when you charge the card. With an online payment provider you receive a payout bundling several bookings, minus transaction fees. Both break the simple assumption "one booking = one deposit" — and that's exactly the assumption manual reconciliation rests on. See Booking.com virtual credit cards.

What you can realistically automate

Automating doesn't make your accountant redundant. They still interpret your figures, file your returns and tell you what's smart from a tax point of view. What it does remove is the retyping. Concretely:

• Let invoices arise from the booking. The nights, the breakfast and the tourist tax are already known the moment the guest books. There's no reason to key them in a second time.
• Set VAT rates per product line instead of per invoice. That way accommodation automatically gets the accommodation rate and breakfast gets its own, without you having to think about it.
• Push invoices into your accounting software instead of exporting, emailing and importing them. A connection sends the invoice through with the right VAT and the right account.
• Use e-invoicing where you can. For business guests, structured e-invoicing is gradually becoming the norm. More on that in Peppol e-invoicing.

The test: how long does your month-end take?

There's a simple, honest gauge. Put a timer on your next month-end close. If you come in under half an hour, and that half hour is checking rather than typing, your chain is in good shape. If it stretches into a whole evening, you're paying for that time every single month — twelve times a year, every year. Seen that way, admin is rarely a matter of working harder, but of setting things up properly once.

Where BedFlow PMS makes the difference

BedFlow PMS lines up that chain from booking to bookkeeping. Bookings from Booking.com, Airbnb and your own booking widget arrive in one place, and the invoice lines — nights, breakfast, tourist tax, extras — arise from the booking itself, each with its own VAT rate. Tourist tax stays a separate line, so it doesn't disappear into your revenue. You match payments to the invoice, including when they come in via a virtual card or a payment provider.

From there, BedFlow PMS pushes your invoices into your accounting software, so your accountant gets them the way they want them: booked, with correct VAT, without a stopover in your inbox. What's left is checking — not retyping.

In short

• The booking → invoice → bookkeeping chain usually breaks on VAT rates, tourist tax, OTA commissions and virtual cards.
• Accommodation (12% in Belgium since 1 March 2026) and breakfast don't belong on the same VAT pile.
• Tourist tax isn't revenue — keep it separate.
• OTA payouts are net: book gross revenue and commission separately.
• Automate the retyping, not your accountant: invoices from the booking, VAT per line, a connection to your package.

Want that monthly evening back? Check the pricing, read the documentation or try BedFlow PMS free for 30 days — no credit card required.