Skip to main content

Matching Payouts with Customer Bookings

Matching payment reports with customer booking details.

Updated over 3 months ago

If you have been requested to provide a detailed account of the payout information aligned with the customer booking information you can export your Payouts & Transaction and Booking Payments & Transactions reports and combine them so that they reflect all of the payment and booking details.

This may have been requested by an accountant or financial director to keep an accurate log of customer bookings and payment records for their reports.

First navigate to Reports > Booking Payments & Transactions > Booking Payments and select the date range you want to view, then set the Payment Method to Online. Search with these filters applied and click the Export button in the top right.

Next go to Reports > Payouts & Transaction Report > Payments and click the Export button the top right, a export menu will pop up where you can set a custom or preset date range and which data columns you want in the report. Once you have set these, click the Export button to download the document.

Open both of these documents in Excel or Google Sheets separately. If there are any additional days outside of the set export windows on these documents, you can get remove these.

Once this is done, you can copy all of the details from one document and paste them over to the other one next to the existing details so that the payments match up on the same line.

Now you should have all of these details in one shared document.

Did this answer your question?