Back to the sample audit

Print this page to save it as a PDF.

Propseer audit · SAMPLE-2026-03

Reservation, commission and cleaning audit

A demonstration. The properties and amounts are invented; the arithmetic and the format are what a paid audit produces.

Period
2026-03-01 to 2026-03-31
Issued
2026-04-02
Source
a sample export
Properties
6
Reservations read
96
Payouts read
90

Summary

Across March 2026, 24 findings account for €7,031 at stake.

Each finding states its confidence, source file and row.

Commission rule: 20% of accommodation only.

Retained cancellation revenue is excluded. Discounts are deducted before commission.

This document compares expected flow with actual flow. It does not allege intent.

FamilyFindingsAt stake
Reservation to payout8€5,142.88
Commission verification6€1,028.60
Cleaning and service10€860.00
Total24€7,031.48

Findings

Finding 01 · Reservation to payout · Likely

Retained cancellation revenue with no payout

Villa Mimosa · HMA1092 · Impact €1,398.60

Evidence

sample-reservations.csv · row 94

Reservation
HMA1092
Status
Cancelled
Retained, expected
€1,398.60
Paid out
€0.00

sample-payouts.csv

Payouts referencing it
0
Searched rows
90

Action · Ask the platform for the cancellation payout on this reservation, quoting the code and the retained amount.

Finding 02 · Reservation to payout · Likely

Retained cancellation revenue with no payout

Le Balcon 12 · HMA1023 · Impact €1,161.85

Evidence

sample-reservations.csv · row 25

Reservation
HMA1023
Status
Cancelled
Retained, expected
€1,161.85
Paid out
€0.00

sample-payouts.csv

Payouts referencing it
0
Searched rows
90

Action · Ask the platform for the cancellation payout on this reservation, quoting the code and the retained amount.

Finding 03 · Reservation to payout · Likely

No payout found for this reservation

Bastide Olivier · HMA1030 · Impact €711.47

Evidence

sample-reservations.csv · row 32

Reservation
HMA1030
Check-out
2026-03-25
Expected net
€711.47
Basis
stated in your export

sample-payouts.csv

Payouts referencing it
0
Searched rows
90
Received
€0.00

Action · Ask the platform which payout carried this reservation. If none did, claim the expected net quoting the reservation code.

Finding 04 · Reservation to payout · Likely

Retained cancellation revenue with no payout

Maison Vieux Port · HMA1046 · Impact €688.19

Evidence

sample-reservations.csv · row 48

Reservation
HMA1046
Status
Cancelled
Retained, expected
€688.19
Paid out
€0.00

sample-payouts.csv

Payouts referencing it
0
Searched rows
90

Action · Ask the platform for the cancellation payout on this reservation, quoting the code and the retained amount.

Finding 05 · Reservation to payout · Likely

Retained cancellation revenue with no payout

Bastide Olivier · HMA1000 · Impact €602.37

Evidence

sample-reservations.csv · row 2

Reservation
HMA1000
Status
Cancelled
Retained, expected
€602.37
Paid out
€0.00

sample-payouts.csv

Payouts referencing it
0
Searched rows
90

Action · Ask the platform for the cancellation payout on this reservation, quoting the code and the retained amount.

Finding 06 · Reservation to payout · Likely

Retained cancellation revenue with no payout

Studio Fontaine · HMA1069 · Impact €283.40

Evidence

sample-reservations.csv · row 71

Reservation
HMA1069
Status
Cancelled
Retained, expected
€283.40
Paid out
€0.00

sample-payouts.csv

Payouts referencing it
0
Searched rows
90

Action · Ask the platform for the cancellation payout on this reservation, quoting the code and the retained amount.

Finding 07 · Commission verification · Confirmed

Commission charged on a cancelled reservation

Villa Mimosa · HMA1092 · Impact €276.00

Evidence

sample-reservations.csv · row 94

Reservation
HMA1092
Status
Cancelled
Your rule
no commission on cancellations
Charged
€276.00

Action · Credit this commission back on the next owner statement, or correct the rule if cancellations are commissionable.

Finding 08 · Commission verification · Confirmed

Commission charged above the contract rate

Loft Canal 3B · Impact €238.00

Evidence

sample-reservations.csv · row 3

Reservation
HMA1001
Base
€1,025.00
Rate
20%
Expected
€205.00
Charged
€219.00

sample-reservations.csv · row 9

Reservation
HMA1007
Base
€995.00
Rate
20%
Expected
€199.00
Charged
€217.00

sample-reservations.csv · row 15

Reservation
HMA1013
Base
€489.00
Rate
20%
Expected
€97.80
Charged
€111.80

sample-reservations.csv · row 21

Reservation
HMA1019
Base
€375.00
Rate
20%
Expected
€75.00
Charged
€93.00

Arithmetic

Reservations affected
15
Base used
accommodation only
Total difference
€238.00

Action · Recompute the commission on these reservations from the contract base and credit the difference on the next owner statement.

Finding 09 · Commission verification · Confirmed

Commission charged on a cancelled reservation

Le Balcon 12 · HMA1023 · Impact €221.00

Evidence

sample-reservations.csv · row 25

Reservation
HMA1023
Status
Cancelled
Your rule
no commission on cancellations
Charged
€221.00

Action · Credit this commission back on the next owner statement, or correct the rule if cancellations are commissionable.

Finding 10 · Cleaning and service · Worth checking

Turnovers with no cleaning fee collected

Le Balcon 12 · Impact €160.00

Evidence

sample-reservations.csv · row 13

Reservation
HMA1011
Check-out
2026-03-28
Cleaning fee collected
€0.00

sample-reservations.csv · row 79

Reservation
HMA1077
Check-out
2026-03-04
Cleaning fee collected
€0.00

Arithmetic

Turnovers with no fee
2
Usual fee at this property
€80.00
At stake
€160.00

Action · Check whether these stays were cleaned. If they were, the cleaning was paid for and never rebilled.

Finding 11 · Reservation to payout · Confirmed

Payout short of the expected net

Bastide Olivier · HMA1012 · Impact €148.50

Evidence

sample-reservations.csv · row 14

Reservation
HMA1012
Expected net
€458.67
Basis
stated in your export

sample-payouts.csv · row 13

Payout
PO-4011
Date
2026-03-06
Amount
€310.17

Arithmetic

Expected
€458.67
Received
€310.17
Difference
€148.50

Action · Open a payout query with the platform for the difference, quoting the reservation code and both amounts.

Finding 12 · Reservation to payout · Confirmed

Payout short of the expected net

Le Balcon 12 · HMA1047 · Impact €148.50

Evidence

sample-reservations.csv · row 49

Reservation
HMA1047
Expected net
€512.92
Basis
stated in your export

sample-payouts.csv · row 45

Payout
PO-4043
Date
2026-03-12
Amount
€364.42

Arithmetic

Expected
€512.92
Received
€364.42
Difference
€148.50

Action · Open a payout query with the platform for the difference, quoting the reservation code and both amounts.

Finding 13 · Cleaning and service · Worth checking

Turnovers with no cleaning fee collected

Maison Vieux Port · Impact €140.00

Evidence

sample-reservations.csv · row 24

Reservation
HMA1022
Check-out
2026-03-24
Cleaning fee collected
€0.00

sample-reservations.csv · row 90

Reservation
HMA1088
Check-out
2026-03-27
Cleaning fee collected
€0.00

Arithmetic

Turnovers with no fee
2
Usual fee at this property
€70.00
At stake
€140.00

Action · Check whether these stays were cleaned. If they were, the cleaning was paid for and never rebilled.

Finding 14 · Commission verification · Confirmed

Commission charged on a cancelled reservation

Maison Vieux Port · HMA1046 · Impact €125.40

Evidence

sample-reservations.csv · row 48

Reservation
HMA1046
Status
Cancelled
Your rule
no commission on cancellations
Charged
€125.40

Action · Credit this commission back on the next owner statement, or correct the rule if cancellations are commissionable.

Finding 15 · Commission verification · Confirmed

Commission charged on a cancelled reservation

Bastide Olivier · HMA1000 · Impact €124.20

Evidence

sample-reservations.csv · row 2

Reservation
HMA1000
Status
Cancelled
Your rule
no commission on cancellations
Charged
€124.20

Action · Credit this commission back on the next owner statement, or correct the rule if cancellations are commissionable.

Finding 16 · Cleaning and service · Likely

Cleaning invoiced with no turnover that day

Villa Mimosa · INV-938 · Impact €95.00

Evidence

sample-cleaning-invoices.csv · row 40

Invoice
INV-938
Date
2026-03-02
Property
Villa Mimosa
Amount
€95.00

sample-reservations.csv

Turnovers at this property that day
0
Reservations searched
91

Action · Ask the supplier which stay this cleaning was for. With no turnover that day, it should not have been billed.

Finding 17 · Cleaning and service · Worth checking

Turnovers with no cleaning fee collected

Studio Fontaine · Impact €90.00

Evidence

sample-reservations.csv · row 35

Reservation
HMA1033
Check-out
2026-03-11
Cleaning fee collected
€0.00

Arithmetic

Turnovers with no fee
1
Usual fee at this property
€90.00
At stake
€90.00

Action · Check whether these stays were cleaned. If they were, the cleaning was paid for and never rebilled.

Finding 18 · Cleaning and service · Worth checking

Turnovers with no cleaning fee collected

Villa Mimosa · Impact €80.00

Evidence

sample-reservations.csv · row 46

Reservation
HMA1044
Check-out
2026-03-08
Cleaning fee collected
€0.00

Arithmetic

Turnovers with no fee
1
Usual fee at this property
€80.00
At stake
€80.00

Action · Check whether these stays were cleaned. If they were, the cleaning was paid for and never rebilled.

Finding 19 · Cleaning and service · Worth checking

Turnovers with no cleaning fee collected

Loft Canal 3B · Impact €70.00

Evidence

sample-reservations.csv · row 57

Reservation
HMA1055
Check-out
2026-03-21
Cleaning fee collected
€0.00

Arithmetic

Turnovers with no fee
1
Usual fee at this property
€70.00
At stake
€70.00

Action · Check whether these stays were cleaned. If they were, the cleaning was paid for and never rebilled.

Finding 20 · Cleaning and service · Worth checking

Turnovers with no cleaning fee collected

Bastide Olivier · Impact €70.00

Evidence

sample-reservations.csv · row 68

Reservation
HMA1066
Check-out
2026-03-25
Cleaning fee collected
€0.00

Arithmetic

Turnovers with no fee
1
Usual fee at this property
€70.00
At stake
€70.00

Action · Check whether these stays were cleaned. If they were, the cleaning was paid for and never rebilled.

Finding 21 · Cleaning and service · Confirmed

Cleaning cost above the fee collected

Le Balcon 12 · INV-916 · Impact €65.00

Evidence

sample-cleaning-invoices.csv · row 18

Invoice
INV-916
Date
2026-03-27
Cleaning cost
€65.00

sample-reservations.csv · row 13

Reservation
HMA1011
Check-out
2026-03-28
Cleaning fee collected
€0.00

Arithmetic

Difference
€65.00

Action · Rebill the difference, or renegotiate the cleaning fee you charge guests at this property.

Finding 22 · Cleaning and service · Confirmed

Cleaning cost above the fee collected

Le Balcon 12 · INV-910 · Impact €55.00

Evidence

sample-cleaning-invoices.csv · row 12

Invoice
INV-910
Date
2026-03-28
Cleaning cost
€55.00

sample-reservations.csv · row 13

Reservation
HMA1011
Check-out
2026-03-28
Cleaning fee collected
€0.00

Arithmetic

Difference
€55.00

Action · Rebill the difference, or renegotiate the cleaning fee you charge guests at this property.

Finding 23 · Commission verification · Confirmed

Commission charged on a cancelled reservation

Studio Fontaine · HMA1069 · Impact €44.00

Evidence

sample-reservations.csv · row 71

Reservation
HMA1069
Status
Cancelled
Your rule
no commission on cancellations
Charged
€44.00

Action · Credit this commission back on the next owner statement, or correct the rule if cancellations are commissionable.

Finding 24 · Cleaning and service · Confirmed

Cleaning cost above the fee collected

Maison Vieux Port · INV-903 · Impact €35.00

Evidence

sample-cleaning-invoices.csv · row 5

Invoice
INV-903
Date
2026-03-28
Cleaning cost
€95.00

sample-reservations.csv · row 6

Reservation
HMA1004
Check-out
2026-03-28
Cleaning fee collected
€60.00

Arithmetic

Difference
€35.00

Action · Rebill the difference, or renegotiate the cleaning fee you charge guests at this property.

Scope, and what was not checked