How do I generate a Payments Report?

Here is a step by step guide to generate a Payments Report

🧑🏻‍💻 Currently, Payment Reports are exclusively accessible to admin users. If you wish to obtain this report, kindly reach out to support@bookteq.com and they will be able to assist you further.

 

Step 1: Navigate to Venue Settings

  1. In your Bookteq Workspace, locate the menu on the left-hand side.
  2. Scroll down and select Invoices & Payments

Step 2: Access Finance Reports

  1. On the right-hand side of the screen, scroll down to the Finance Reports section.

Step 3: Set Report Criteria

  1. Choose the Transaction Date for the report.
  2. Optionally, add additional criteria such as Venue and Booking Type.
  3. Click Generate Report.

Screenshot 2025-01-13 at 12.44.13 pm

Step 4: Download the Report

  1. Check your email inbox for the CSV report.
  2. Download the CSV file from the email.

Screenshot 2025-01-13 at 12.48.11 pm

Report Contents

The downloaded Payments Report will include details such as the booking reference, date, customer name, space name, facility name, booking type, price, price excluding VAT, VAT rate, payment amount, payment state, payment processing fee, Bookteq commission, and Playfinder commission. Use the glossary below to identify payment type and column definitions.

Payments Report Glossary

Payment Type Definitions

Below is a list of Payment Types and their definitions included in the Payments Report. 

apiOnline payment made on the Playfinder website or app
stripeOnline payment made via a Payment Link or on the Widget
splitterOnline payment made using PaySplit through the Widget or Payment Link
settlementOnline payment made through the Customer Portal
bank_transferManual payment entered by operator
cashManual payment entered by operator
chequeManual payment entered by operator
creditManual payment entered by operator
direct_debitManual payment entered by operator
otherManual payment entered by operator
pos_terminalManual payment entered by operator
standing_orderManual payment entered by operator

Payments Report Definitions

Below is a list of column definitions included in the Payments Report. 

Price TotalPrice of Bookings to the end customer
Price Ex VatPrice of a booking excluding VAT to the customer
Vat AmountAmount of VAT charged
Vat RateThis is the Rate at which VAT is charged on a booking
Payment Amount (Balance)The net balance of the booking revenue received post refunds/reversals, if any
Payments in (Total)The amount which has been received against any booking
Payments out (Total)The amount which has been refunded / transactions reversed
Payment amount (May 2024)The money that has been received in the month of the report
Payment TypesThe mode of receipt of booking amount i.e. Stripe, api, bank transfer etc
Refund TypesThe mode of payment to process refund of booking 

 

Was this article helpful?