Free CSV template

Match every payout to the deposit that reached your bank.

Use one simple row to connect the booking subtotal, host fee, expected payout, and actual bank deposit. If a payout contains several bookings, enter their combined totals. The difference column tells you which payout deserves a second look.

Download the free CSVOpens in Excel or Google Sheets

No account or email. One example row and 24 ready-to-use rows included.

Booking subtotal$550.00
Host fee− $85.25
Expected payout$464.75
Bank deposit$464.75
Difference$0.00
MATCHED
One row per payoutWorks for single or batched reservations
Formulas includedExpected payout, difference, and status
No guest data neededReservation ID is enough for your own records

Five numbers, one check.

Copy them from the platform transaction page and your bank. The template handles the comparison. See the full walkthrough.

Enter the booking subtotal

Use the amount before the host service fee. If the payout contains several bookings, add their subtotals together.

Enter the host fee

Use the dollar amount shown by the platform instead of estimating from a percentage. Add the fees together for a batched payout.

Let the sheet calculate expected payout

Expected payout equals booking subtotal minus the host fee.

Enter the actual bank deposit

Use one row for the whole bank deposit. For a batched payout, list all included reservation IDs in the same ID cell or in Notes.

Investigate rows marked Check

Look for refunds, adjustments, taxes, processing fees, or a second booking inside the same deposit.

The arithmetic.

A clean payout trail separates the sale from the platform's cut and the money that arrived.

Booking subtotal$550.00
−
Host fee$85.25
=
Expected payout$464.75
Keep private data out of the file. Guest names, addresses, payment details, tax IDs, and bank account numbers are not needed. A reservation ID is enough to find the booking later.

Managing one to five rentals? Apply to test the full workbook free in exchange for private product feedback. A public testimonial is optional.