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.
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.