Hotel accounts receivable: track overdue company and agency invoices

A company guest has checked out, the agreed invoice has been sent, and payment is due later. Reception may have finished the stay, but someone must still track the company’s balance. For a small hotel in Azerbaijan, a short, consistently maintained invoice list can make that responsibility visible.

This workflow starts after charges have been invoiced on agreed credit terms. It differs from maintaining an in-house guest folio or deciding which charges the company covers. The following register is a proposed external control worksheet, not a claim about automatic BirOtel functionality.

Separate outstanding from overdue

Outstanding means the unpaid invoice balance, including money whose payment deadline has not yet arrived. Overdue means the unpaid amount remaining after the agreed due date. An invoice sent yesterday can already be overdue under its terms; an older invoice can still be within its agreed payment period.

Use a fixed review date and calculate overdue calendar days from the due date. In this worksheet, payment due today remains in the not-yet-due group; tomorrow is day one. The groups do not overlap:

• Not yet due: the agreed due date is today or later.
• 1–30 days overdue: one through thirty days after the due date.
• 31–60 days overdue: thirty-one through sixty days after it.
• 61+ days overdue: sixty-one days or more after it.

Infor’s aging documentation describes consecutive periods and unmatched payments. Check the date basis of any software report: invoice-age groups are not necessarily overdue-day groups. Label this worksheet explicitly as “days after agreed due date.”

Build one traceable row per invoice

Record the agreed payer, invoice number, invoice date, due date, currency, original amount, matched payments and remaining balance. Add the delivery reference, dispute status, responsible colleague and next contact date. A company name alone cannot identify which of several invoices a payment covers.

Check the payment terms against the accepted arrangement. An agency contract discount does not itself establish a payment deadline. If the due date is missing or disputed, flag it for confirmation instead of inventing a date and presenting the resulting aging as reliable.

Keep each currency separate. Retain previous references when an approved correction changes a balance or deadline, so a colleague can understand the difference between yesterday’s list and today’s.

A hypothetical review on 25 October 2026

The fictional invoices below are all in AZN. There are no other charges or approved adjustments in this exercise. Dates are in 2026; the 400 AZN payment has been verified and matched to invoice B-102.

Payer / invoice	Issued	Due	Original	Matched payment	Balance	Group
Company A / A-101	15 Oct	30 Oct	600	0	600	Not yet due
Agency B / B-102	25 Sep	10 Oct	1,000	400	600	15 days: 1–30
Company C / C-103	5 Aug	20 Aug	800	0	800	66 days: 61+

Original invoices total 2,400 AZN. Deducting the matched 400 AZN leaves 2,000 AZN outstanding. Of that, 600 AZN is not yet due and 1,400 AZN is overdue. The 31–60-day group is zero. Partial payment reduces B-102’s balance without resetting its due date.

There is also a confirmed bank receipt of 150 AZN without a reliable invoice allocation. Record it separately as unapplied, with its bank reference and an investigation owner. Do not reduce C-103 simply because it is oldest, or describe the invoice total as 1,850 AZN. Match the receipt before changing an invoice balance. The separate payment reconciliation guide covers verifying money against external records.

Give follow-up a specific next action

In the example, assign A-101 to Leyla, with no dispute and a 30 October review. Assign B-102 to Murad, with no dispute and contact on 26 October. Assign C-103 to Leyla: a disputed service line needs supporting documents and contact on 26 October. These are fictional task assignments, not recommended collection intervals.

A reminder should identify the invoice, due date and verified balance, then ask whether documents are missing and when payment is expected. Record the response and next contact date. A promise to pay remains a promise until receipt is confirmed. Keep disputed amounts visible while the authorised colleague checks them; a dispute alone does not erase the balance.

A daily control checklist

1. Fix the review date, property and currency.
2. Check new invoices and agreed due dates.
3. Match confirmed payments and investigate unapplied receipts.
4. Recalculate balances and non-overlapping overdue groups.
5. Review disputes and promised payment dates with the assigned owner.
6. Save the next action and contact date for each open follow-up.

Frequently asked questions

Is every outstanding invoice overdue? No. Some balances remain within the agreed payment period.

Does a partial payment restart the clock? No. Use the existing due date unless an authorised change is documented.

Does BirOtel automate aging and reminders? That capability is unconfirmed. BirOtel provides payment records and basic reports, with PMS interfaces in Azerbaijani and English. Bring this register to a cashier and reporting demonstration to verify the available records and external follow-up process.