Skip to content
Innkeeper

7 min read

QuickBooks for hotels and how the PMS feeds hotel accounting

QuickBooks works well for a small hotel's books, but it is not a hotel system. It has no room calendar, no folios and no night audit, so the revenue has to come from your property management system. The clean setup is one summary journal entry per day or per month built from the PMS export, with room revenue, extras, lodging tax, card payments and OTA receivables on separate lines. The worked example below shows that entry for a 12 room inn.

Front desk laptop at a small hotel with the month end revenue report open

Is QuickBooks good for hotels?

For an independent hotel, inn, motel or B&B up to about 80 rooms, yes. QuickBooks Online handles bills, payroll links, bank feeds, sales tax liabilities and the profit and loss your lender asks for, and almost every small business bookkeeper in the US already knows it. Intuit lists QuickBooks Online from $38 a month for Simple Start, with higher tiers for more users and class tracking, so check the QuickBooks pricing page for the current figure.

What QuickBooks cannot do is run the rooms. Reservations, rates, channels, guest folios and the nightly room charge live in a PMS. The question for a hotel owner is not QuickBooks or a PMS, but how cleanly the PMS hands its numbers to QuickBooks.

QuickBooks hotel management software options

There are two ways to get PMS revenue into QuickBooks, and the right one depends on how much your bookkeeper wants to see.

Route How it works What QuickBooks receives Best for
Direct sync The PMS pushes transactions to QuickBooks Online through an integration Often one sales receipt or invoice per stay Properties whose accountant wants every guest in QuickBooks
Summary export The PMS exports invoices and payments as CSV, the bookkeeper posts one summary journal entry per day or month Totals per revenue, tax and payment account Owner-run hotels that want a short close and a clean ledger

Several PMS vendors sell a direct QuickBooks Online connection, often on a higher plan or as a paid add-on. A per stay sync sounds tidy, but a 12 room property creates 150 to 250 stays a month, and each one becomes a customer and a transaction in QuickBooks. Most accountants for small hotels prefer the summary, because the detail already lives in the PMS and QuickBooks only needs the totals that hit the ledger.

Innkeeper uses the summary route. It exports invoices and payments for any date range as CSV, with net, tax per rate and gross on every invoice and every payment and refund listed, on every plan. The hotel invoicing software page shows the export fields.

A 12 room inn's October close in QuickBooks

Take a 12 room inn in October. It sold 242 room nights out of 372 available (65% occupancy) at an average rate of $165, plus extras such as breakfast baskets, late checkout and pet fees. The state and local lodging tax in this example is 12% on room revenue only. Use your own rates, because lodging tax differs by state, county and city.

Line from the PMS export Amount
Room revenue (242 nights at $165) $39,930.00
Extras on folios $1,240.00
Lodging tax at 12% of room revenue $4,791.60
Total invoiced to guests $45,961.60
Card payments taken by the inn (website, front desk, Booking.com guests paying at the property) $41,300.00
Owed by Expedia for prepaid bookings it collected $4,661.60

The payments side equals the invoiced side ($41,300.00 plus $4,661.60 is $45,961.60). If it does not, something is still open on a folio, and the PMS is the place to find it, before anything goes into QuickBooks.

The summary journal entry

Account in QuickBooks Debit Credit
Card clearing (undeposited card payments) $41,300.00
Accounts receivable, Expedia $4,661.60
Room revenue $39,930.00
Other income, guest extras $1,240.00
Lodging tax payable $4,791.60
Total $45,961.60 $45,961.60

QuickBooks Online imports journal entries from a CSV file under Settings, Import data, Journal entries, and Intuit documents the column format in its journal entry import guide. Give each entry its own journal number, or QuickBooks merges the lines into one.

Matching the bank and the OTAs

The card processor deposits net of fees. At about 2.9%, $41,300.00 of card payments arrives as roughly $40,102.30, and the $1,197.70 difference is booked to merchant fees when the deposits land in the bank feed and are matched against card clearing. Expedia pays the $4,661.60 later minus its commission, so the payout clears the receivable and the difference goes to commission expense. Booking.com bills its commission separately for hotel collect bookings, so its monthly invoice, say $1,800, goes in as a bill to commission expense. When card clearing and the Expedia receivable both reach zero, the month is closed.

Deposits for future stays

A deposit taken in October for a stay in December is not October revenue. Book deposits to a liability account, customer deposits, and move them to revenue when the stay happens. On Innkeeper's Boutique plan a deposits ledger lists every deposit held, which is the figure your bookkeeper ties that liability to at month end.

Five mistakes that make hotel books in QuickBooks wrong

  • Booking OTA payouts as revenue. The payout is net of commission and arrives weeks later. Revenue is the gross room charge on the night of the stay, and the commission is an expense.
  • Mixing lodging tax into revenue. Lodging tax belongs to the state and city. Keep it in a liability account so the return you file matches the PMS tax report line for line.
  • Posting card deposits as sales. Card deposits are net of fees and cover several days. Run them through a clearing account, or revenue and fees will both be wrong.
  • One customer per guest. Hundreds of one time customers slow QuickBooks down and add nothing. The guest record belongs in the PMS.
  • Retyping folios by hand. Typing totals from screen to screen is where transposed digits come from. Import the export file instead.

Owners who keep a personal brokerage account next to the business should also keep it out of the hotel books entirely. If you test stock ideas with a research tool such as agenttrading.ai before putting the off season cash to work, that account and its results belong in your personal records, not in the inn's QuickBooks file.

What to look for in a PMS if you use QuickBooks

  • An export of invoices and payments for any date range, as a file your bookkeeper can open.
  • Net, tax per rate and gross on each invoice, so lodging tax ties out without a calculator.
  • Every payment and refund listed with its method, so card clearing can be matched to the bank.
  • Invoices that do not change after the fact, so last month's close stays closed.
  • A clear yearly price. A direct sync that only comes on a top plan can cost more per year than the bookkeeping time it saves.

Innkeeper covers the first four on every plan from $49 a month, with the Hotel plan at $888 a year adding the night audit and daily reports that make a daily summary entry easy. Our best PMS for small hotels comparison puts that price next to ten other systems at 12 rooms, and the hotel PMS pricing page lists every feature by plan. Owners of several properties get one export per property on the multi property hotel software plan, which keeps each property in its own QuickBooks class or file.

When a direct QuickBooks sync is worth paying for

If your accountant insists on a sales receipt per stay in QuickBooks, or you sell a lot of gift cards, retail and event packages that need item level detail in the ledger, a PMS with a direct QuickBooks Online integration saves work. Some systems include it only on higher tiers, so put it in the yearly price when you compare. Our Easy Innkeeping alternative page shows one example where QuickBooks sits on the top plan.

Where Innkeeper fits

Innkeeper is the PMS for owner-run US inns, B&Bs, motels and small hotels that already keep their books in QuickBooks or Xero. The calendar, channels, commission-free booking engine and folios run in Innkeeper, and the month end export gives your bookkeeper the totals for one journal entry. See the hotel booking engine for how direct bookings and deposits come in, then open the demo and export a month of sample invoices yourself.

QuickBooks for hotels questions

Can I use QuickBooks as hotel management software?

No. QuickBooks is accounting software. It has no room calendar, rates, channel connections or guest folios. A hotel runs those in a property management system and sends the revenue totals to QuickBooks as a daily or monthly journal entry, or through a direct integration if the PMS offers one.

Which QuickBooks version is best for a small hotel?

For most independent hotels and inns, QuickBooks Online is the practical choice, because bookkeepers work in it remotely and it imports journal entries from CSV. A plan with class or location tracking helps when you want separate rooms, restaurant and events results, or several properties in one file.

How do I record OTA bookings in QuickBooks?

Record the gross room revenue and lodging tax when the guest stays, and a receivable for any OTA that collected the money. When the OTA pays, clear the receivable and book its commission as an expense. For hotel collect bookings, the guest pays you and the OTA bills its commission separately.

Does Innkeeper integrate with QuickBooks?

Innkeeper exports invoices, payments and refunds for any date range as CSV, with net, tax per rate and gross on each invoice, on every plan. Your bookkeeper builds a daily or monthly summary journal entry from that file and imports it into QuickBooks Online. There is no built-in per stay sync, and the Boutique and Group plans add API access and webhooks if your accountant wants invoices pushed automatically.

Hotel PMS blog with practical guides for small properties

Best PMS for small hotels compared by what a 12 room property pays Ten systems side by side on the yearly cost for a 12 room property, with channels, booking fees and setup counted. Newbook pricing and what a small hotel pays per year What directories show for Newbook, the lines to ask about in a quote and a yearly cost table from 8 to 50 rooms. Hotelogix pricing and what a small hotel pays per year Per room tiers and add-on lines from public sources, and a yearly cost table from 8 to 50 rooms next to published plans. RMS Cloud pricing and what a small hotel pays per year What directories show for RMS Cloud, the costs to ask about in a quote and a yearly cost table from 8 to 50 rooms. Clock PMS pricing and what a small hotel pays per year What the vendor and directories show for Clock PMS Suite, the costs to ask about and a yearly cost table from 8 to 100 rooms. AutoClerk PMS pricing and what a small hotel pays per year What public sources show for AutoClerk PMS, the costs to ask about and a yearly cost table from 8 to 80 rooms. Opera PMS pricing and what a small hotel pays per year What review sites list for Oracle Opera PMS, the costs to ask about and a yearly cost table from 8 to 80 rooms. Maestro PMS pricing and what a small hotel pays per year What review sites list for Maestro PMS, the costs to ask about and a yearly cost table from 8 to 80 rooms. RoomRaccoon pricing and what a small hotel pays per year RoomRaccoon tiers from about $188 to $620 a month on review sites, the costs to ask about and a yearly cost table from 8 to 80 rooms. HotelKey pricing and what a small hotel pays per year What review sites estimate for HotelKey, the fees to ask about and a yearly cost table from 8 to 80 rooms. BookingCenter pricing and what MyPMS costs an inn per year MyPMS at $50 a month for unlimited rooms, the booking engine at $50 or 3%, OTA enrollment, the MyCard gateway and a yearly cost table from 8 to 80 rooms. Visual Matrix pricing and what the PMS costs a hotel per year VM Core, Core Plus and Enterprise by room band, the MOP housekeeping app and a yearly cost table from 8 to 80 rooms. Frontdesk Anywhere pricing and what an independent hotel pays after the Mews move The old $100 a month listing, what changed when Mews bought it, card fees and a yearly cost table from 8 to 60 rooms. INNsight pricing and what the INNsight PMS costs a small hotel per year The $99 flat suite, INNsightPay fees and website packages, with a yearly cost table from 8 to 60 rooms. Motel software pricing and what a motel PMS costs per year by room count Check-Inn, RoomMaster, WebRezPro, innRoad, INNsight and Innkeeper side by side, with yearly cost at 12 and 30 rooms. Check-Inn PMS pricing and what InnSoft costs a motel or small hotel per year The $899 to $1,399 license, the $660 service contract, channel manager and booking engine fees, and cost at 8 to 60 rooms. Easy InnKeeping pricing and what each GraceSoft plan costs a month Reported Basic to Platinum prices, which tier adds the channel manager and a yearly cost table by size. SkyTouch pricing and what Hotel OS costs an independent hotel in year one The per-room quote, the reported $200 to $600 start, onboarding fees and first-year cost at 12 to 60 rooms. eviivo pricing and what a B&B or small hotel pays each month The base price, the $0.50 fee per booking, per-room add-ons and cost at 8 to 60 rooms. Mews pricing and what a small hotel pays for the Mews PMS How the per-room quote works, card fees, the reported term and cost at 8 to 100 rooms. Stayntouch pricing and what a small hotel pays per month The $5 per room rate, the $750 monthly minimum, add-on modules and cost at 12 to 150 rooms. RoomKey PMS pricing and what an independent hotel pays per month How the quote works, estimated cost at 20, 50 and 100 rooms, and the add-ons billed on top. PMS vs channel manager and what a small hotel actually needs What each tool does, where they overlap, and which setup fits a small property. How to prevent hotel overbooking at a small hotel or B&B The causes, a daily routine, channel settings and what to do if it happens. Increase direct bookings and pay less OTA commission at a small hotel Booking engine, website, Google, rate parity and guest emails, step by step. Hotel housekeeping checklist for small teams Room turnover, bathroom, stayover service, inspection and the weekly deep clean. How to choose a PMS for a small hotel with 12 questions to ask The questions to put to every vendor about price, channels, commission and data. Cloudbeds pricing and what a small hotel or B&B actually pays Cloudbeds quotes every property individually. The four plans, reported monthly prices, add-ons and fees, and a yearly cost example for 8, 24 and 40 rooms. Little Hotelier pricing and what a B&B or small hotel actually pays Basics, Pro and Revenue Optimiser, the 1% booking fee in dollars, and a yearly cost example for three property sizes. ThinkReservations pricing and what a B&B or inn pays in year one Reported monthly cost, setup and onboarding fees, and a first-year cost example for 8, 15 and 30 rooms. RoomMaster pricing and what a small hotel or inn pays per year The reported starting price, what a RoomMaster quote includes, and a yearly cost example for 10, 25 and 50 rooms. WebRezPro pricing and cost, what a small hotel or inn pays per year The $10 per unit price, what it leaves out, and a yearly cost example for 8 to 80 rooms. innRoad pricing and cost, what a small hotel, inn or B&B pays per year The reported $10 per room price and $150 minimum, which modules cost extra, and a yearly cost table for 8 to 80 rooms. ResNexus pricing and what an inn or B&B pays per year The reported edition prices, what the hosted website, SMS and site map add, and a yearly cost table for 8 to 80 units. Innkeeper's Advantage pricing and what a B&B pays per year The $69.95 plan, $160 a year per OTA channel, texting and domain fees, and a yearly cost table by property size. Sirvoy pricing and what a B&B or inn pays per month The Free, Starter and Pro plans, why OTA channels need Pro, per-room scaling and a monthly cost table by property size.