Contact Info
Canadian Hotels
Where does an ERP fit in a Canadian hotel, inn or resort?
I design the back office for a Canadian hotel, inn or resort around the PMS it already runs. Reservations and folios remain with the PMS; after each audit, the ERP receives one journal with each sales tax and accommodation levy separated, handles direct-bill and group receivables, purchasing, stores, building maintenance and staff housing, and receives the payroll journal. I work remotely and stay independent of software vendors.
Last reviewed by Vikas Saroj
A Canadian hotel might be a downtown business property, a highway hotel serving road travelers, a lakeside inn or a mountain lodge. The PMS at reception handles guests well. Behind it, the controller often works from the audit report, a mix of GST, HST, PST or QST lines and accommodation levies, card settlements in two currencies and a maintenance plan that changes with the weather.
I work remotely with Canadian owners, general managers and controllers to design the property back office: postings from the PMS after each audit, tax and levy reconciliation, direct-bill and group receivables, purchasing, stores and minibars, upkeep of the building through hard winters, and staff housing where the location demands it.
What I Do
The PMS stays responsible for guests. I define what it hands to finance each day and design the purchasing, stores, maintenance and reporting processes that follow.
A mapping of every PMS transaction code to the ledger, department and tax code, producing one balanced journal per business day, with deposits, guest ledger and city ledger movements posted as balances.
Separate liability accounts for GST or HST, provincial sales tax or QST where they apply, and each municipal accommodation tax or destination fee the PMS charges, reconciled to returns and remittances monthly.
Deposits for weddings, sports teams, film crews and conferences, master account billing after departure, credit approval for direct-bill companies and aging reviewed every week in the ERP.
OTA payouts, commission invoices and travel agent claims tied to the reservation that produced them, with month-end accruals for guests who have left, so distribution cost stops hiding in card and bank charges.
Asset registers and preventive schedules for boilers, heating loops, roof drainage, pools, hot tubs, kitchen equipment and life-safety checks, with seasonal opening and closing routines for resort facilities.
Demos scripted on your audit days, tax lines, group folios and cross-border receipts, judged with your team and without commission, then oversight of the implementer configuring the chosen platform.
What to Measure
An ERP for hotels should make these numbers available without a spreadsheet. I design the data model and reports around them from the start.
Platform Fit
How I Work
Learn the property's year
Audit pack and tax lines
Group and direct-bill review
Seasonal facility calendar
Staff housing and stores walk
Postings, controls and scoring
Tax and levy account map
Deposit and master account rules
Maintenance and store design
Demos on Canadian scenarios
Switch in a shoulder season
Parallel audit-day runs
Opening receivables and deposits
Storeroom and minibar counts
First tax return tie-out
The night audit at a Canadian property closes the day in the PMS and produces a stack of reports. The controller needs one thing from them: a journal that is complete, balanced and coded the way the ledger expects. Where that journal is still built by hand, mistakes appear in the places that matter most, such as tax liabilities, deposits and card settlements.
I write a posting table with the controller and the front office manager. Each PMS code is assigned its GL account, department and tax treatment. Room revenue is split by segment so corporate, group, leisure and wholesale business can be read separately; food, beverage, spa, parking and other revenue keep their own lines. Payments are posted by card type, cash and direct bill. Advance deposits, guest ledger balances and city ledger transfers stay on the balance sheet until they are applied, and nothing posts until the journal agrees with the audit totals.
The interface method depends on the PMS. Some provide an accounting export, some an API and some only a file that has to be transformed. I confirm the options with the vendor before the platform is chosen and write the integration requirements to match. Testing then pushes a run of real audit days through the interface and compares the output with the controller's own postings. The general model for hotels sits on my hotel ERP page.
A room night in Canada can carry federal GST or a harmonized HST, a provincial tax in some provinces, and a municipal or provincial accommodation tax or levy depending on the location. Some properties also collect a destination marketing fee for a tourism organization, which may be treated differently from a tax. My Canadian hospitality page looks at how these layers differ by province across a group. For one property the job is to make sure every line the PMS charges lands in its own account and can be proved at remittance time.
I design one liability account per tax, levy and fee, by authority or recipient. Daily journals credit them; returns and remittances debit them. A monthly tie-out compares collected amounts with filed amounts, and differences are explained before they become a problem. Exempt stays, long stays and packages that include meals or activities are written into test cases, because these are where PMS setups most often drift from what your advisor expects.
I do not advise on rates, exemptions or whether a fee is taxable; that comes from your accountant and the relevant authorities. I turn their guidance into PMS codes, ledger mapping and checks. Bilingual invoicing for Quebec guests or companies, if it applies, is handled in the same templates. More national context is on the Canadian ERP consultant page.
Group business keeps many Canadian hotels full outside peak leisure periods: sports tournaments, conferences, weddings, film and construction crews, and government travel. Each brings its own billing pattern. Some pay deposits and settle on a master account after departure; others need a direct-bill account with a purchase order and monthly statement.
I design the receivables side in the ERP. Deposits are held as liabilities against the group contract, then transferred to the PMS master account when the group arrives. After departure the balance moves to the city ledger, an invoice goes out with the references the customer requires, and collections follow a defined cycle. Credit limits and approvals for direct-bill companies live in the ERP, so the sales team can see who is overdue before confirming a new block.
Cross-border guests add currency questions. Some US travelers pay in US dollars at the desk, some wholesale contracts are priced in US dollars, and card settlements may convert at different rates. I set rules for which currency each transaction is recorded in, where exchange differences post and how a US dollar bank account, if you hold one, is reconciled. OTA payouts and travel agent commissions are matched by reservation and channel. These flows are agreed with front office, sales and finance in shared process mapping workshops.
Canadian winters are hard on buildings. Boilers, heating loops, make-up air units, snow and ice removal, roof drainage and frozen-pipe prevention all need planned attention, and resorts add pools, hot tubs, ski lockers, docks and outdoor facilities that open and close with the seasons. Fire alarm, sprinkler and emergency lighting inspections follow provincial and municipal rules that your maintenance lead knows well.
Maintenance records can sit inside the ERP or in a linked work-order app. Either way it needs a list of assets by building and plant area, preventive schedules with seasonal start-up and shut-down routines, contractor visits with inspection reports attached, and a parts cage stocked to minimum quantities for spares that cannot wait. Room attendants keep reporting faults the way they do today, and the ERP records the work and its cost.
Remote lodges and resort-town properties often house staff because local rentals are scarce. Staff accommodation brings rent or ownership costs, utilities, furnishings and upkeep, and sometimes rent recovered through payroll deductions. I give it a separate department in the ledger, with its own repairs and supplies, so owners see what housing really costs. Minibar, gift shop, amenity and linen stores run against par levels. Payroll usually stays with a payroll provider because of provincial employment standards and gratuities; the ERP receives a departmental journal.
Many independent Canadian hotels run QuickBooks, Sage or Xero with a PMS interface, and that can be enough. A fuller ERP earns its place when the property needs purchasing approvals, controlled stores, a maintenance register, group receivables and departmental reporting together, or when the owner wants statements close to the USALI format.
Canadian properties I work with tend to shortlist Zoho, Business Central, Odoo and ERPNext. Each candidate demonstrates the same scenarios from your hotel: an audit day with GST or HST, provincial tax and an accommodation levy, a group deposit applied to a master account, a US dollar wholesale payment, a boiler service with a contractor report, a staff housing allocation and a minibar refill. You and I grade the demonstrations side by side, and no vendor or implementer pays me.
Migration covers the departmental chart of accounts, open receivables and deposits, vendor balances, storeroom quantities and the equipment list, following the steps in my data migration approach. Go-live suits a shoulder season rather than ski season or summer. Calls are booked to suit the time zone your property runs on, everything is delivered remotely, and further market notes sit on the Canada hub.
Tell me about your business and current systems. I’ll suggest the most sensible first step.
Book a Consultation
Not sure which ERP you need?
Share your business requirements with me and I will help you understand the right process, architecture and platform before implementation.
FAQ
It depends on the arrangement. Some fees are collected for a tourism organization and passed on, which points to a liability account; others may be retained by the hotel. The tax treatment of the fee is a separate question. Your accountant confirms both, and I set the PMS code and ledger mapping so it reconciles cleanly.
Yes. Most ERPs record foreign currency transactions and post exchange differences, as long as the rules are clear: which transactions are recorded in US dollars, which bank account receives them and how card conversions are treated. The PMS has to send currency information, which I confirm with the vendor during design.
It does. Seasonal closing and opening routines, stock counts before shutdown, winterization work orders, deferred costs and staff housing that empties between seasons all need planning. I design templates for these routines so each season starts with the same checklist rather than from memory.
Workshops run by video around your time zone, your night staff and maintenance crew film brief screen or phone recordings, and audit packs, returns and counts reach me as shared files. That covers almost everything a single property needs. Should a short visit become worthwhile, we can arrange it separately.
Every business is different. Share where you are today and what you want to fix, and I’ll tell you honestly whether and how I can help.
Book a Consultation
Insights
Book a Consultation
Book a consultation to talk through your processes, systems and goals. I’ll reply with practical next steps - no obligation.
