Logeergastenregister (Guest Register)

Every short-term rental in Aruba is legally required to keep a guest register.

Not a shoebox of receipts. A proper logeergastenregister with the exact data the inspector can demand — guest, ID, dates, nights, what they paid, what tax was due. Miss it, and “I lost track” isn’t a defence. It’s a naheffing.

Most hosts either don’t keep one, or keep a messy spreadsheet that doesn’t actually calculate the tax — so they never know if they’re charging correctly until the tax office tells them they weren’t.

This register does both jobs at once.

You type in each stay. It works out the rest.

What it does

• Logs every stay with the fields the law requires — guest name, passport/ID, accommodation type, arrival and departure, nights, rooms, and what was paid
• Calculates the nights for you — type the dates as dd-mm-yyyy and it counts them, on any computer, no date-format headaches
• Works out the tax automatically — Tourist → Toeristenheffing 12,5% + BBV. Local registered in the censo → BBO 7% instead. It knows the difference and applies the right one
• Builds the base correctly — room rate × nights + cleaning + other fees. This is exactly where hosts under-declare, and the register gets it right every time
• Checks whether you charged correctly — enter the tax the platform collected and it tells you: OK, under by $X, or over. No more guessing at payout time
• Everything in USD — the way your Airbnb and Booking.com payouts actually arrive
• Monthly totals in florin — the Monthly Summary tab lays out TH, BBV and BBO in the exact DIMP-form layout, converted to Afl., ready to copy field-for-field onto your declaration
• A full-year overview — all 12 months of TH, BBV and BBO on one tab, so you can see the year at a glance

Built for your real workflow

Read your Airbnb payout, type in the numbers, done. The register handles the peg (USD 1 = Afl. 1,79), the rates, the conversions, and the correctness check. When declaration time comes, you’re copying finished florin totals onto a form — not rebuilding your month from scratch.

Locked where it matters

The formulas are protected so you can’t overwrite them by accident. You type only in the input cells — everything calculated stays safe.

One number worth knowing

BBV is USD 3 per occupied room, per night. Toeristenheffing is 12,5% of everything the guest pays to stay. Both are the guest’s tax — you collect and remit. But if you don’t charge them, you still owe it. This register makes sure you always charge the right amount, to the right guest, every time.

This template is toelichting — supporting documentation, not a legally binding record, and not admissible as proof in tax disputes or court. Rates and rules can change — verify your situation or consult iFacts Consultancy. © iFacts Consultancy.

Licensed for the purchaser’s personal use. ✔ Reuse it for yourself ✘ No reselling ✘ No sharing or distributing. All rights reserved by iFacts Consultancy.