Rural Villa Guesthouse

Monthly Financial Report

1 β€” Booking.com

Booking.com Online platform β€” commissions deducted before payout

Total revenue shown in the Booking.com extranet / your system

Commission charged by Booking.com (not shown in your system)

Any promotional discounts or rate reductions applied

Actual payout deposited in your bank statement

Any additional charges e.g. VAT, bank transfer fees on payout

System Total βˆ’ Commission βˆ’ Discounts βˆ’ Other Deductions

Bank vs Expected Payout β€”

2 β€” POS Card Machine

POS / Card Machine In-person card payments β€” bank charges deducted before settlement

Total transactions processed on the card machine

Transaction fees and bank charges deducted before payout

Any discounts applied to card-paying guests

Net settlement amount deposited in your bank statement

Refunds, chargebacks, or any other adjustments

POS Total βˆ’ Bank Charges βˆ’ Discounts βˆ’ Other Deductions

Bank vs Expected Settlement β€”

3 β€” Cash

Cash Physical cash collected on-site

Total cash received from guests during the month

Any discounts applied to cash-paying guests

How much of the cash was deposited into the bank account

Cash retained on-site for petty cash / expenses

Cash refunds or any other reductions

Collected βˆ’ Deposited βˆ’ Petty Cash βˆ’ Discounts βˆ’ Other

Cash Balance β€”

Monthly Totals

Channel System / Collected Total Deductions Discounts Given Received / Deposited Difference
Booking.com R 0.00 R 0.00 R 0.00 R 0.00 β€”
POS / Card Machine R 0.00 R 0.00 R 0.00 R 0.00 β€”
Cash R 0.00 R 0.00 R 0.00 R 0.00 β€”
TOTALS R 0.00 R 0.00 R 0.00 R 0.00 β€”

Reconciliation Summary

How the money matches up
Total System / Collected (all channels) R 0.00
Less: Booking.com Commission & Fees βˆ’ R 0.00
Less: POS / Bank Charges βˆ’ R 0.00
Less: Total Discounts Given βˆ’ R 0.00
Less: Other Deductions βˆ’ R 0.00
= Expected Net Revenue R 0.00
Total Actually Received in Bank + Cash Kept R 0.00
Gain / (Loss) R 0.00