Keep booking creation, stay, document and bank dates separate, then connect records with references. A timing difference does not establish missing money, while unexplained items still need evidence.
A booking report and bank statement can differ without either being wrong: they answer different questions. New bookings describe reservation activity during a period. Bank receipts describe money recorded by the bank. Comparing them without their date bases can mislead an owner.
Keep distinct dates
Record booking creation, service or stay period, billing-document date and bank-receipt date separately. Guest payment and the channel's transfer to the property may also occur on different dates. Use descriptive labels rather than calling every field “sales date.”
This is an operational information framework. The accountant should determine formal revenue recognition, tax treatment and required documents from the actual circumstances.
Bridge the records
| Field | Purpose |
|---|---|
| Booking ID | Connect records without relying on a guest name |
| Creation date | Understand reservation activity |
| Stay period | Identify the related service dates |
| Document reference and date | Connect billing or adjustments |
| Receipt or payout-batch reference | Connect channel and bank evidence |
| Amount and currency | Avoid silently combining different currencies |
| Difference status | Timing, documented deduction or investigation |
| Follow-up owner | Who obtains evidence and reviews the item? |
Retain amendments and cancellations as history rather than deleting the original trail.
Hypothetical cross-month example
Suppose DEMO-A was booked on 28 January, stayed on 3–5 February and was paid to the property by the channel on 8 February. It can appear in January booking activity and February bank receipts for a timing reason.
These dates are not a standard payout schedule for any platform. Check the actual account terms and documents. If the transfer on the eighth combines several bookings, use an allocation bridge before declaring DEMO-A fully received.
Investigate without jumping to conclusions
First align reporting periods and definitions. Then check identifiers, amounts, currencies, deductions, refunds and reservation changes. Separate differences supported by evidence from items lacking documents.
An expected future receipt is not cash already received. Do not close an item solely because a reservation screen says paid. For owner reporting, use the monthly report framework and label the date basis of every table.
Frequently asked questions
Are higher receipts than new bookings necessarily an error?
No. They may relate to earlier activity. Match evidence before deciding whether something is wrong.
Can bank date be used everywhere for simplicity?
That would obscure reservation activity and service dates. Preserve the separate dates and choose the view that answers the question.
Build traceable reports
Prepare de-identified example records to discuss reporting processes through LINE OA @kines.
Tool provenance
This Kines worksheet adapts KB themes on receipts, payments and performance review. It supports operational reconciliation, not an accounting or tax ruling. The example is fictional.


