Two reports can disagree without either losing money. Sometimes they answer different questions. The problem begins when that distinction disappears as data moves between systems.
A booking across two months
A stay begins at the end of September and ends in October. Full payment is collected on arrival. Follow the same operation using both criteria:
Follow the same operation
A stay from September 28 to October 8. Ten nights at $120. The full amount is collected on arrival.
September
The full payment is collected this month.
Three nights: the 28th, 29th and 30th.
October
No additional payment is collected.
Seven nights: the 1st through the 7th.
The $1,200 appears in September because the criterion is the payment date. The report answers when the money came in.
The report allocates $360 to September and $840 to October based on the nights stayed. The total is still $1,200.
Fictional data. Simplified example without taxes, fees, cancellations or adjustments.
What changed and what did not
The payment is still $1,200. Under the second criterion, the report allocates three nights to September and seven to October. The reporting period has changed, not the amount collected.
A screen that calls both values “revenue” without stating the basis forces the team to investigate every difference. The integration needs to carry the definition along with the data.
The meaning of a figure needs to survive a change of tool.
Before correcting the number
- Define the question. When was payment collected, or when was the service provided?
- Find the date being used. Creation, service, payment and modification dates may all exist on one record.
- Follow one operation. Check its identifier in the source and the report before comparing totals.
- Review exceptions. Cancellations, taxes and adjustments need their own rules.
This does not replace your business’s accounting judgement. It helps establish what each report measures and what an integration needs to preserve.
Published by Alma Intel. Fictional examples prepared to explain the working approach.
See the related working approach