Is a September payment September revenue?

Follow a stay across two months. The money stays the same; the question answered by the report changes.

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.

Reporting basis

September

$1,200

The full payment is collected this month.

October

$0

No additional payment is collected.

The $1,200 appears in September because the criterion is the payment date. The report answers when the money came in.

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

  1. Define the question. When was payment collected, or when was the service provided?
  2. Find the date being used. Creation, service, payment and modification dates may all exist on one record.
  3. Follow one operation. Check its identifier in the source and the report before comparing totals.
  4. 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

Let’s talk about the work

Which process will your team do by hand again this week?

Book a 30-minute call