It's the 19th. The return is due tomorrow, and you're at the office with a laptop, last month's booking spreadsheet, and a coffee going cold, trying to remember whether that three-night stay in the second week got refunded or whether the guest just shortened it.
Every month it's the same drill. You owe the state a room occupancy excise on your taxable room revenue, and every month you rebuild the number from scratch, scrolling through reservations and second-guessing yourself. The filing itself is quick once you have the figure. The digging is what eats the evening.
Here's the thing worth fixing: that number already lives in your booking system. You don't need to reconstruct it in a panic. You need a small, boring routine that pulls it the same way every month, so by the time the deadline comes around the figure is sitting there waiting for you.
What you're actually reporting
The room occupancy excise in Massachusetts is a tax on short-term lodging, charged on the rent you collect for stays under 90 days. It's not one flat rate. It's a stack.
- The state rate, which applies everywhere.
- A local option that your town or city can add on top. The rate varies by municipality, so check what yours charges.
- The Cape Cod and Islands Water Protection Fund, an extra charge that applies if your property sits in one of the towns covered by it. Plenty of South Shore and Cape inns owe this piece and forget it exists.
You collect all of it from the guest, hold it, and hand it to the state. The return is filed monthly through MassTaxConnect, generally due on or before the 20th of the month after the stays happened. Miss the date and you're looking at penalties and interest on money that was never yours to keep.
One more wrinkle that trips owners up: taxable rent usually includes more than the nightly room charge. Cleaning fees and extra-person charges often count. Refunds and certain longer or exempt stays come back out. That's exactly why rebuilding the number by eye is so error-prone, and why a repeatable rollup beats a late-night guess.
Build a monthly rollup from your booking system
Most booking and property-management systems can already show you the two things you need: how many room nights you sold in a month, and how much taxable revenue those stays brought in. The trick is pulling it the same way each time so the numbers line up month to month.
Set it up once as a saved report. Walk through it like this:
- Find the revenue or tax report in your booking software and set the date range to a single calendar month.
- Pull room nights sold and taxable room revenue for that month. Keep cleaning and extra-guest fees in if your town taxes them.
- Subtract refunds and any exempt stays, like a guest who stayed past 90 days, so you're left with the rent that's actually taxable.
- Save it as a template or a recurring report so next month you just change the dates.
If your software won't produce that cleanly, a simple spreadsheet does the job. One row per month, columns for room nights, taxable revenue, and the tax collected. The point isn't fancy. The point is that the number comes from the same place, the same way, every single month.
Separate the tax into its own bucket as it comes in
The bigger money mistake isn't the paperwork. It's spending tax you've already collected because it landed in your operating account and looked like income.
When a guest pays, part of that payment is room rent you earned and part is occupancy tax you're just holding for the state. Treat those as two different things from the moment the money arrives. Some owners move the tax portion into a separate savings account each week. Others tag it in their bookkeeping so it never shows up as available cash. Either way, the goal is the same: when the 20th comes, the money to pay the bill is already set aside and you're not scrambling to cover it.
A weekly rhythm beats a monthly one here. Once a week, glance at what you collected, move the tax share into its bucket, and note the running total. It takes a few minutes and it means the deadline is a transfer, not a surprise.
What this setup does, and what it doesn't
Be clear with yourself about the limits, because this is tax money and sloppy assumptions get expensive.
A rollup organizes your numbers. It gives you a clean, consistent taxable-revenue figure and a tax total you've been setting aside, so you walk into the filing knowing what you owe. That alone saves the night-before scramble and cuts down on the typos that come from working tired.
It does not file for you, and it is not tax advice. The actual return still goes through MassTaxConnect, and the rules on what's taxable, which stays are exempt, and what your exact local and water-fund rates are deserve a real conversation with your accountant or bookkeeper. Software can pull a number. It can't tell you whether you've got an exemption right or whether a new town rate kicked in. Let the tools handle the counting and let a person handle the judgment.
If the figures ever look off, trust the gap and go find it before you file, rather than after. An hour spent reconciling in the quiet of shoulder season is cheaper than a correction letter in July.
Worth doing this week
You don't have to solve all of this at once. Start with the pieces that kill the scramble:
- Open your booking system and find the report that shows room nights and taxable revenue for one month. Save it as a template you can reuse.
- Confirm your actual rates: the state portion, your town's local option, and whether the Cape Cod and Islands water fund applies to you. Your accountant can confirm these in five minutes.
- Open a separate account or a bookkeeping tag for occupancy tax, and set a weekly reminder to move the collected tax into it.
- Do one practice run for last month. Compare the rollup number to what you actually filed. If they match, your routine works. If they don't, you just found a leak worth plugging.
Set up right, the monthly filing stops being a dreaded evening and becomes a two-minute check of a number you already trust. Helping coastal inns put quiet systems like this in place is a lot of what we do, and this is one of the easier wins on the list.