HorecaHire
A hotel accounts receivable aging report helps finance teams understand what corporate, travel-agent, group or other approved direct-bill customers still owe, how long invoices have been outstanding and who must resolve disputes. It is different from daily cashier closing: an invoice in the AR ledger may remain unsettled well after a guest checks out. This original HoReCaHire hotel AR aging register and follow-up SOP offers a copy-ready worksheet, consistent aging logic, a worked rupee example and privacy-conscious collection communication.
What does accounts receivable aging mean in a hotel?
Hotel AR aging groups invoices or outstanding portions of invoices into defined periods. The aging start date is not universal. Oracle Hospitality OPERA Cloud lets hotels configure the Date for Aging, potentially using transfer-to-AR, invoice-closure, guest-checkout or another permitted event. Aging buckets may also be configured. Before comparing balances across systems, verify the hotel’s actual method, report cutoff, credit posting and invoice definitions.
AR aging versus due date versus disputed balance
| Term | Meaning | What to check |
|---|---|---|
| Invoice amount | Value charged according to actual contracted services and finance records | Invoice, taxes and adjustments |
| Open balance | Invoice portion not settled under approved accounting | Applied payments and authorized credits |
| Aging date | Configured date from which age is calculated | PMS/accounting setting |
| Contractual due date | Agreed date payment is due | Actual client terms and lawful arrangement |
| Disputed invoice | Customer questions a charge or supporting record | Evidence and named finance owner |
| Unapplied credit | Payment/credit not yet matched to eligible invoice | Reconciliation before chasing payment |
Seven-step hotel AR reconciliation and collections SOP
- 1. Define the snapshot: choose one as-of date, currency and hotel or company accounts scope.
- 2. Identify genuine open items: reconcile invoices, payments, credit notes and authorized transfers in the finance system.
- 3. Verify aging policy: document whether the age is based on invoice issue, transfer or other configured date.
- 4. Group correctly: use non-overlapping aging buckets and the same cutoff for every invoice.
- 5. Investigate exceptions: identify unapplied cash, duplicate invoices, partial payments and genuine disputes.
- 6. Contact fairly: send accurate statements or follow-up only through approved client contacts and contractual processes.
- 7. Escalate and record: assign resolutions, approvals, write-off/credit decisions and next review dates.
Copy-ready hotel AR aging register
| Field | What to enter |
|---|---|
| Customer / AR reference | [Authorized corporate or agent account ID] |
| Invoice and source folio | [Internal invoice number and correct service reference] |
| Invoice value and currency | [Actual posted amount] |
| Payments and applied credits | [Verified receipts and allocated credit notes] |
| Outstanding balance | [Invoice value − correctly applied settlement] |
| Aging start date | [Chosen and documented PMS/accounting rule] |
| Age at report cutoff | [Whole elapsed days under chosen date convention] |
| Age bucket | [Current/0–30, 31–60, 61–90, over 90, or actual configured groups] |
| Contract due date | [Actual signed payment condition] |
| Dispute/collection status | [Confirmed issue and named owner] |
| Next review and approval | [Approved follow-up, credit/write-off authorization] |
Illustrative hotel AR aging calculation in rupees
Imagine an internally consistent training snapshot on 31 October 2026 using invoice dates, not guest checkout or transfer dates, as its agreed aging clock. A ₹50,000 invoice dated 21 October, with ₹10,000 of genuine applied payments, has ₹40,000 open and is 10 days old. A second invoice dated 10 September has ₹30,000 open and is 51 days old. A third invoice dated 1 August has ₹20,000 open and is 91 days old. Total remaining AR = ₹90,000, before any unapplied credits or other accounts. The numbers are fictional and must not be presented as real HoReCaHire revenue.
| Invoice | Open amount | Age at 31 Oct | Illustrative bucket |
|---|---|---|---|
| A—21 Oct | ₹40,000 | 10 days | 0–30 |
| B—10 Sep | ₹30,000 | 51 days | 31–60 |
| C—1 Aug | ₹20,000 | 91 days | 91+ / actual configured bucket |
| Total | ₹90,000 | — | Three open items |
Aging buckets are not automatically payment-overdue bands
An invoice aged 35 days can still be within terms if an agreed credit period is 45 days. Conversely, an invoice aged 20 days may already be contractually overdue when the due date was seven days after issue. Keep an aging view and an actual due-date view separate when sending collection notices. Do not write “overdue” solely because an invoice appears in a 31–60 day bucket.
Four reconciliations before contacting a customer
- Match invoice to the approved corporate or agent agreement and genuine billable service.
- Confirm that a guest or group charge was not already settled in the guest folio or master account.
- Match payment receipts and any unapplied credits to the appropriate items using finance controls.
- Review any previously approved credit note, dispute or revised billing instruction before demanding the original amount.
Sample corporate AR statement email
Subject: Account Statement Review – [Verified Customer] – [Statement Date]
Dear [Authorized Accounts Contact],
Please find our statement of the following verified open invoices as of [date]: [references and amounts], prepared under our agreed account terms. We are reviewing [any identified unresolved credit or dispute] separately. Could you confirm the status of the undisputed open items or share a remittance reference where payment has already been made? If you notice an error, please contact [Authorized Hotel Finance Contact] for a factual reconciliation.
Thank you, [Hotel Accounts Receivable Team].
Collections exceptions: who owns the next action?
| Problem | Finance action | Avoid |
|---|---|---|
| Payment appears in bank but not AR | Verify remittance and correct allocation | Chasing customer again without checking |
| Client disputes meeting room charge | Compare signed contract, BEO and approved additions | Assuming all posted lines are correct |
| Credit note pending approval | Escalate to delegated finance signatory | Creating unsupported negative invoice |
| Unapproved extended credit request | Review genuine contract, policy and permissions | Changing credit terms without authority |
| Account contact is outdated | Verify authorized organization contact | Sending sensitive statements to a guess |
Hotel AR KPIs with honest interpretation
| KPI | Calculation | Limitation |
|---|---|---|
| Total overdue under actual terms | Open amounts beyond contract due dates | Different from aged value alone |
| AR over 60 days | Open balances in agreed older buckets | May include legitimately long terms |
| Disputed balance | Genuine documented items awaiting review | Not necessarily uncollectible |
| Unapplied cash | Verified receipts without correct invoice assignment | Could distort net AR view |
| Collection follow-through | Actual promised actions completed | Contact frequency alone is not collection success |
Privacy, finance approvals and audit trail
Finance should limit client invoice data and guest-linked folios to authorized recipients. Do not circulate statements on open staff groups or accept payments through an employee’s personal account. Corrections, discounts, write-offs and refunds require actual authority. The AR register is a management aid, not an accounting-standard or tax compliance certificate.
Related HoReCaHire guides
For related account and revenue responsibilities, see Hotel General Manager duties, F&B Director responsibilities, Restaurant Manager checks and Duty Manager escalation. To hire an accounts professional, post a genuine vacancy.
FAQs
Is AR aging the same as revenue earned?
No. It reports unsettled invoice balances under a defined accounting method. Revenue recognition, tax and cash settlement are separate assessments.
Does an invoice in the 31–60 bucket mean the customer is late?
Not automatically. Compare with the actual contractual due date and whether credits, disputes or payments remain unresolved.
Can an AR clerk write off a disputed folio?
Only through the approved finance and accounting authority. A dispute requires review; it is not permission to delete the record.
Research basis: Oracle Hospitality OPERA Cloud documentation on AR Aging, Accounts Receivable Reports and Date for Aging controls, reviewed October 2026. All dates, amounts, templates and scripts are original HoReCaHire illustrations and do not constitute accounting, debt recovery or legal advice.
