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 the file and row it rests on.

The commission rule applied was 20% of accommodation only, excluding revenue retained on cancellations.

This document reports discrepancies between the expected flow and the actual flow. It does not allege intent, and it names no person.

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 · at stake €1,398.60

sample-reservations.csv · row 94Reservation HMA1092Status CancelledRetained, expected €1,398.60Paid out €0.00
sample-payouts.csvPayouts referencing it 0Searched 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 · at stake €1,161.85

sample-reservations.csv · row 25Reservation HMA1023Status CancelledRetained, expected €1,161.85Paid out €0.00
sample-payouts.csvPayouts referencing it 0Searched 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 · at stake €711.47

sample-reservations.csv · row 32Reservation HMA1030Check-out 2026-03-25Expected net €711.47Basis stated in your export
sample-payouts.csvPayouts referencing it 0Searched rows 90Received €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 · at stake €688.19

sample-reservations.csv · row 48Reservation HMA1046Status CancelledRetained, expected €688.19Paid out €0.00
sample-payouts.csvPayouts referencing it 0Searched 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 · at stake €602.37

sample-reservations.csv · row 2Reservation HMA1000Status CancelledRetained, expected €602.37Paid out €0.00
sample-payouts.csvPayouts referencing it 0Searched 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 · at stake €283.40

sample-reservations.csv · row 71Reservation HMA1069Status CancelledRetained, expected €283.40Paid out €0.00
sample-payouts.csvPayouts referencing it 0Searched 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 · at stake €276.00

sample-reservations.csv · row 94Reservation HMA1092Status CancelledYour rule no commission on cancellationsCharged €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 · at stake €238.00

sample-reservations.csv · row 3Reservation HMA1001Base €1,025.00Rate 20%Expected €205.00Charged €219.00
sample-reservations.csv · row 9Reservation HMA1007Base €995.00Rate 20%Expected €199.00Charged €217.00
sample-reservations.csv · row 15Reservation HMA1013Base €489.00Rate 20%Expected €97.80Charged €111.80
sample-reservations.csv · row 21Reservation HMA1019Base €375.00Rate 20%Expected €75.00Charged €93.00
ArithmeticReservations affected 15Base used accommodation onlyTotal 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 · at stake €221.00

sample-reservations.csv · row 25Reservation HMA1023Status CancelledYour rule no commission on cancellationsCharged €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 · at stake €160.00

sample-reservations.csv · row 13Reservation HMA1011Check-out 2026-03-28Cleaning fee collected €0.00
sample-reservations.csv · row 79Reservation HMA1077Check-out 2026-03-04Cleaning fee collected €0.00
ArithmeticTurnovers with no fee 2Usual fee at this property €80.00At 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 · at stake €148.50

sample-reservations.csv · row 14Reservation HMA1012Expected net €458.67Basis stated in your export
sample-payouts.csv · row 13Payout PO-4011Date 2026-03-06Amount €310.17
ArithmeticExpected €458.67Received €310.17Difference €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 · at stake €148.50

sample-reservations.csv · row 49Reservation HMA1047Expected net €512.92Basis stated in your export
sample-payouts.csv · row 45Payout PO-4043Date 2026-03-12Amount €364.42
ArithmeticExpected €512.92Received €364.42Difference €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 · at stake €140.00

sample-reservations.csv · row 24Reservation HMA1022Check-out 2026-03-24Cleaning fee collected €0.00
sample-reservations.csv · row 90Reservation HMA1088Check-out 2026-03-27Cleaning fee collected €0.00
ArithmeticTurnovers with no fee 2Usual fee at this property €70.00At 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 · at stake €125.40

sample-reservations.csv · row 48Reservation HMA1046Status CancelledYour rule no commission on cancellationsCharged €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 · at stake €124.20

sample-reservations.csv · row 2Reservation HMA1000Status CancelledYour rule no commission on cancellationsCharged €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 · at stake €95.00

sample-cleaning-invoices.csv · row 40Invoice INV-938Date 2026-03-02Property Villa MimosaAmount €95.00
sample-reservations.csvTurnovers at this property that day 0Reservations 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 · at stake €90.00

sample-reservations.csv · row 35Reservation HMA1033Check-out 2026-03-11Cleaning fee collected €0.00
ArithmeticTurnovers with no fee 1Usual fee at this property €90.00At 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 · at stake €80.00

sample-reservations.csv · row 46Reservation HMA1044Check-out 2026-03-08Cleaning fee collected €0.00
ArithmeticTurnovers with no fee 1Usual fee at this property €80.00At 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 · at stake €70.00

sample-reservations.csv · row 57Reservation HMA1055Check-out 2026-03-21Cleaning fee collected €0.00
ArithmeticTurnovers with no fee 1Usual fee at this property €70.00At 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 · at stake €70.00

sample-reservations.csv · row 68Reservation HMA1066Check-out 2026-03-25Cleaning fee collected €0.00
ArithmeticTurnovers with no fee 1Usual fee at this property €70.00At 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 · at stake €65.00

sample-cleaning-invoices.csv · row 18Invoice INV-916Date 2026-03-27Cleaning cost €65.00
sample-reservations.csv · row 13Reservation HMA1011Check-out 2026-03-28Cleaning fee collected €0.00
ArithmeticDifference €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 · at stake €55.00

sample-cleaning-invoices.csv · row 12Invoice INV-910Date 2026-03-28Cleaning cost €55.00
sample-reservations.csv · row 13Reservation HMA1011Check-out 2026-03-28Cleaning fee collected €0.00
ArithmeticDifference €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 · at stake €44.00

sample-reservations.csv · row 71Reservation HMA1069Status CancelledYour rule no commission on cancellationsCharged €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 · at stake €35.00

sample-cleaning-invoices.csv · row 5Invoice INV-903Date 2026-03-28Cleaning cost €95.00
sample-reservations.csv · row 6Reservation HMA1004Check-out 2026-03-28Cleaning fee collected €60.00
ArithmeticDifference €35.00

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

Scope, and what was not checked