We often get asked about comparisons of data made against different sources.


For example;

  • graphs
  • data exports
  • within BRM itself (on the Reservation List Panel)


Let's take a real-world example

(taken from an actual BRM store, but anonymized)


Reservations for the month of June.



First of all, let's look at the actual data;



BRM - JuneBRM - June (+cancelled)BRM - custom
1-30th June
GraphsExport
no. rentals153*167*145 / 158144158
total rental income7,065.00*7,129.00*6,475.00 / 6539.006,397.006,539.00


* It seems that in BRM when you search for June(30 days) it includes reservations starting on 1st July. (bug)

[issue ID BRM-4982 we are working on a fix]

Then let's dig in to understand the various sources of data;



BRMBRM (+cancelled)Graphs
Export
include cancelled?**optional (default no)yesnoyes
datesreservation STARTS on June 1st > 30th




** When a reservation is cancelled it has its price set to zero.


Reservations for the month of March

(smaller data set is easier to compare)




BRM - MarchBRM - March
(+cancelled)
GraphsExport
no. rentals43564356
total rental income2,369.002,422.00***2,369.002,422.00



Reservations for the month of July

(now a bigger data set)




BRM - JulyBRM - July
(+cancelled)
GraphsExport
no. rentalstoo many ****too many
271309 (30 cancelled)
total rental incometoo many
too many
19,729.0022,117.00



*** It appears that when refunds occur the price (which has been refunded) is re-instated post refund.  (even though the reservation's price is set to zero on cancellation.


There are two further dimensions to consider, which add to the complexity.


  1. When is the data 'frozen'? - it is not.  If you modified a reservation 2 months later (price or date) - then it would be altered.
  2. **** Physical limits on pulling back Reservation Data into BRM - 300 reservations.


Transactions

Then there is another complication.  What about comparing reservation data with transactional data?

This is of course, a very different thing!


Transactions may occur at different dates - even after the reservation has 'ended'.

Reservations may also be paid for through multiple transactions.

Reservations may not be fully paid - or may be overpaid.


All of these things mean you may get a very different answer when comparing or reconciling payments against