Hotel ERP Consultant, Australia

Turning the end-of-day report into a journal

At an Australian motel or hotel, the end of day in the PMS usually produces a revenue summary, a payments report and a guest ledger balance. A bookkeeper then enters the totals in Xero or MYOB, often with card settlements and OTA payouts reconciled separately. That approach copes with one simple revenue stream, but it struggles once a restaurant, conference room or letting pool joins the picture.

I write a posting table that links every PMS code to an account, a department and a GST code. Accommodation, food, beverage, conference hire, laundry, parking and sundry sales are kept apart. Payments are posted by method and settlement account, including card surcharges where the property applies them. Advance deposits and guest ledger balances stay as liabilities and receivables, not income, until the stay happens. Before anything is accepted, the journal total has to match the PMS end-of-day figures.

The interface depends on what the PMS can export: an accounting link, an API or a scheduled file. I confirm the options with the vendor and write the integration requirements before any platform is chosen, then test with real end-of-day files from busy and quiet days. GST coding on each line is tested against your accountant's guidance, so the first BAS prepared from the new system needs review rather than rework. The overall model is on my hotel ERP page.

Serviced apartments, letting pools and owners' money

Many Australian serviced apartment and resort buildings are strata titled. Individual investors own the apartments, and an onsite manager holds management rights to run reception and a letting pool. Guests pay the operator, but much of the accommodation income belongs to lot owners under their letting agreements, after the manager's commission and agreed costs. State rules on holding money for others, including trust accounting, may apply, and these are matters for your accountant and lawyer.

In the ERP the design goal is separation. The operator's own revenue, such as commission, management fees, cafe or tour sales, must not mix with owners' rental income. I specify how each night's revenue is allocated to the apartment that earned it, how owner-paid costs such as cleaning, linen or repairs are charged, how distributions are calculated and paid, and what each owner statement shows. Where the PMS already handles owner accounting, the ERP receives summaries; where it does not, the ERP holds the owner ledger.

Getting this wrong damages trust with owners and may raise compliance questions, so it is tested hard: a month with mixed occupancy, an owner who stays in their own apartment, a repair charged to one owner and a change of owner mid-month. The requirements follow my requirements gathering approach and are signed off by the operator and their accountant.

Corporate travelers, crews and booking sites

Regional Australian hotels and motels often depend on business that never comes through a booking site: construction and mining crews, government travelers, sporting clubs and corporate accounts that stay on credit. Their invoices go out after departure, often with purchase order numbers, crew lists or job codes the customer needs before approving payment.

I design these accounts in the ERP with credit limits, invoice contacts, required references and statement cycles. The folio moves from the PMS to the city ledger at checkout, the invoice is raised with the references attached, and collections follow a schedule. Disputes are logged with reasons, and reception can see an account on hold before taking a new booking.

Booking sites need separate handling. Some reservations are prepaid through a virtual card, others pay at the property with commission invoiced later, and wholesalers may pay net rates. Each path is matched to its reservation, and commission on guests who have already checked out is estimated at month-end, so management can compare distribution costs against direct business. Group deposits for weddings, conferences and sporting events are held as liabilities until the event. The rules are agreed with reception, reservations and the bookkeeper in shared process mapping sessions, so the people who raise the invoices own the design.

Pools, plant, stores and the payroll boundary

Australian properties carry plant that needs regular attention: air conditioning units, hot water systems, pools and spas with water quality checks, lifts, fire safety equipment subject to state certification, and kitchen and laundry machines. Coastal and tropical properties also face corrosion and storm preparation. The work is often contracted, and the evidence that it was done lives in emails and paper.

I list each item of plant by building and location, set recurring service dates, attach contractor reports to every visit and keep critical spares in a counted maintenance store. For serviced apartments, repairs inside an owner's apartment are tagged so the cost can be charged to that owner where the letting agreement allows.

Housekeeping linen, guest amenities, minibar stock and food and beverage items are reordered when they fall below agreed pars and signed out to each department, and minibar charges from the PMS are compared with refills. Linen is worth tracking closely, whether owned or hired, because losses are easy to miss.

Payroll usually runs in a dedicated payroll system because of awards, penalty rates, superannuation and Single Touch Payroll reporting. The ERP receives a departmental journal, so labor cost per occupied room sits beside revenue. My Australian hospitality page covers award costs in more depth.

Choosing a platform and working remotely

Xero and MYOB with a PMS link serve many small Australian motels well. A fuller ERP becomes worth considering when a property needs purchase approvals, controlled stores, maintenance history, corporate receivables and owner accounting together, or when the owner wants departmental reporting each month.

An Australian shortlist commonly includes ERPNext, Odoo, Zoho and Business Central. I hand every contender the same brief from your property: an end-of-day posting with GST, a letting pool distribution with owner-paid costs, a crew invoice with job references, a pool service with a contractor report, a linen loss write-off and a minibar refill. We rate the walkthroughs together, and my fee comes only from you.

Migration covers the chart of accounts redesigned by department, open corporate receivables, deposits, owner balances where applicable, creditor balances, opening stock and the plant list. I plan go-live away from school holidays and the property's peak season, with parallel end-of-day runs beforehand. Live sessions are scheduled for the part of your day that suits, and all of the work is delivered remotely. For tax, payroll reporting and time zones across the country, see the Australian ERP consultant page or the Australia hub.