Short-Term Rental Lodging Tax Worksheet

Turn your booking export into a filing worksheet for each state, county or city lodging tax you file yourself. You enter the rates and rules; the page works out gross, exempt, platform-collected and taxable receipts and the tax due for each period. Runs entirely in your browser; nothing is uploaded.

Your jurisdictions (CSV: Jurisdiction, Rate %, Taxes Cleaning Fee (Y/N), Exempt Stays Of (nights, blank for none), Platforms Collect For (like Airbnb;Vrbo), Applies To Properties (blank for all)) Bookings (CSV: Platform, Property, Check In, Check Out, Nights, Rent, Cleaning Fee, Other Fees, Tax Collected by Platform)

Open a bookings CSV file

Filing period

Assign receipts to periods

Not tax advice. This page holds no tax rates: the rates in the sample are made up for illustration. Lodging tax rates, what counts as taxable (cleaning and other fees), long-stay exemptions, filing periods and whether receipts follow the check-in date or each night all vary by jurisdiction and change over time. Platform collection agreements vary too, and a platform may collect for the state but not the county or city. Check each jurisdiction's own website and your platform's tax reports before you file.