How to Reconcile POS and Accounting Data Across Hospitality Venues

To reconcile POS and accounting data across hospitality venues, set one trading-day cut-off for every venue, map each POS department and tender type to the same accounts in Xero, MYOB, NetSuite or Sage, and check every tender against what was actually received before the daily journal posts. Then reconcile the clearing and bank accounts each week and roll every venue up through the same mapping.

Why POS and ledger figures drift apart#

A POS report and the general ledger rarely disagree because someone made a typing error. They disagree because each system defines the day, the sale and the payment differently. A pub that trades until 2 am may book late sales to the next calendar day in one system and the previous trading day in the other. EFTPOS settles a day or two after the sale. Discounts, voids, refunds and open tabs carried overnight change the gross figure the POS shows. Gaming, TAB and Keno usually sit outside the POS altogether.

In a single venue a bookkeeper can explain these gaps from memory. Across a hospitality group, each venue tends to build its own spreadsheet and its own workarounds, and the finance team ends up reconciling the reconciliations. Variances found at month-end are weeks old, the staff who worked that shift have moved on, and the cash or stock involved is hard to trace.

Step by step: reconciling POS to accounting#

1. Fix the trading-day cut-off. Agree on when a trading day ends (for example, 5 am) and apply it in the POS export, the cash-up and the journal date. Write it down so a new venue manager follows the same rule.
2. Build one account mapping for the group. Map POS departments (bar, bistro, functions, retail) to revenue accounts and each tender (cash, EFTPOS, vouchers, member points, account sales) to a clearing account. Use the same mapping at every venue so group reports add up without adjustments.
3. Reconcile tenders to what was received. Compare POS cash with the till count and the safe. Compare POS EFTPOS with the terminal settlement report, then with the bank deposit when it lands. Treat vouchers and account sales as their own lines so they do not hide inside cash.
4. Separate gross sales from net revenue. Record discounts, voids, refunds and comps explicitly rather than netting them off. A spike in voids is a control signal, and it disappears if you only post net sales.
5. Post one daily journal per venue with evidence attached. The journal should carry revenue by department, GST, and each tender into its clearing account. Attach the cash-up, the POS summary and the shift notes so the financial controller can review it without asking the venue for paperwork.
6. Clear the clearing accounts. Each week, check that EFTPOS clearing matches bank settlements and that cash clearing matches banked deposits. Anything left in a clearing account is an unexplained difference that needs an owner.
7. Roll up across venues. With one cut-off and one mapping, the group view is a sum. Differences between venues then show real trading or control issues rather than different spreadsheet habits.

The parent guide on connecting cash control with POS, payroll and accounting data explains how the same approach extends to wages and cash-handling hardware.

Edge cases that break the reconciliation#

Gaming, TAB and Keno. These are reconciled from their own systems, not the POS. Bring them into the same daily record so the venue total and the bank deposit can be compared as one figure. Keep the treatment strictly about financial control: clearances, hopper fills, payouts and banking.

Surcharges and tips. Card surcharges and tips paid through EFTPOS inflate the settlement compared with POS sales. Give each its own line in the mapping or the EFTPOS clearing account will never zero.

Function deposits and gift cards. Money received before the event or redemption is a liability, not revenue. Map these tenders to a liability account and release them when the function runs or the card is used.

A venue changing POS. When one venue moves from, say, SwiftPOS to Bepoz, the department codes change. Re-map before the cut-over date and run both mappings side by side for the first week to confirm totals match.

Open tabs over the cut-off. Decide whether an open tab at close belongs to the day it was opened or the day it was settled, and apply that rule everywhere.

Where a connected platform helps#

Doing the steps above by hand works, but it depends on someone exporting reports every morning and keeping the mapping consistent. wirely.ai connects the POS, gaming, cash-handling and accounting systems venues already use, brings safe, till, POS, gaming, TAB and Keno and banking data into one daily workflow, and turns the reconciled day into consistent journals for the accounting platform. The current list of connected systems is on the integrations page.

At Frankston RSL, the API connection to the venue's POS means voids and discrepancies reconcile automatically without manual figure changes. Hurley Hotel Group says wirely.ai has taken the stress out of reconciliation and given its team confidence in the data.

If you are comparing approaches, the cluster's evaluation of hospitality finance integration platforms sets out what to check before choosing one. For the wider picture of how daily close, reconciliation and reporting fit together, see the complete guide to connected hospitality financial operations.

Frequently asked questions#

How often should POS and accounting data be reconciled?#

Daily at the venue level and weekly for clearing and bank accounts. Daily reconciliation means a variance reaches the manager while the shift is still fresh. Waiting until month-end turns a ten-minute question into an investigation.

Should each venue have its own chart of accounts?#

Each venue can have its own tracking category or division, but the account mapping should be the same across the group. A shared mapping is what lets a financial controller compare venues and produce group reports without manual adjustments.

Why does EFTPOS in the POS never match the bank deposit on the same day?#

Card settlements arrive a day or more after the sale, and surcharges, tips and merchant fees change the amount. Post POS EFTPOS to a clearing account and match it against the settlement report and the deposit when they arrive.

Do I need to replace my POS to reconcile across venues?#

No. Most groups run more than one POS. The reconciliation depends on a consistent cut-off and mapping, and a platform that connects existing systems can apply them across different POS brands.

See it with your own venues#

If your finance team is still reconciling each venue's spreadsheet before it can reconcile the ledger, book a demo and bring your POS, accounting platform and venue count. We will walk through how your daily close would map into one connected view.