Payments reports relate to any form of payment made on the system. The following columns can be added to a payment report.
| Payment ID | A unique identifying code generated by the system |
| Venue | Shows the venue associated this data |
| Payment Method | The payment method used |
| Payment Status | Whether the payment is pending, complete or failed |
| Amount | The Payment amount |
| Description | The description of the product or payment |
| Payment Date Time | The date and time the payment was made |
| Payment Date | The date the payment was made |
| Payment Month | The month the payment was made |
| Payment Week | The week the payment was made |
| Payment Date Time (UTC) | The date and time the payment was made in Universal Time |
| Payment Due Date | The date the payment is due |
| Payment Due Month | The month the payment is due |
| Payment Due Week | The week number the payment is due |
| Payment Taken By | User that took the payment (will return Online-Booking if this was via a web booking/payment link) |
| Payment Receipt | The amount of payment received |
| Payment Void | Returns true if the payment was voided or false if not |
| Void Reason | The reason why it was voided |
| Voided By | The user who voided the payment |
| Void Date | The date the payment was voided |
| Payment Deleted | Returns TRUE if the payment was deleted or FALSE if not |
| Deleted By | The User who deleted the payment (will return Online-Booking if this was autocancelled by the system) |
| Deletion Date | The date it was deleted |
| Device Name | The device on which the payment was taken on |
| Event Date Time | The date and start time of the event |
| Event Date | The date of the event |
| Event Month | The month of the event |
| Event Week | The week number of the event |
| Bill Number | The Bill number associated |
| Net Bill Total Amount | The total of all items on the bill excluding any tax |
| Gross Bill Total Amount | The gross total of all items on the bill including any tax |
| Bill Discount Amount | The total amount that has been discounted |
| Bill Tax Amount | The total amount of Tax on the bill |
| Bill Fee Amount | The total amount of any Fees on the bill |
| Customer Name | The customer's full name |
| Customer Email | The customer's email address |
| Company Name | The name of the company associated |
| Customer Address | The customer's basic address details |
| Additional Info | Any additional information provided by the gateway or system |
| Activities | This lists any activities associated with that payment |
| Resources | The resource associated with this item |
| Products | The name of the products associated with this payment |
| Transaction ID | For Stripe Gateways - this is the "payment_intent_id" |
| Vouchers Purchase Date | The date the voucher was purchased |
| Vouchers Purchase Year | The year the voucher was purchased |
| Voucher Purchase Month | The Month the voucher was purchased |
| Voucher Product | Name of the Voucher Product |
Payments reports can use the following filters:
- Venue: List of venues
- Payment Taken Date
- Payment Taken Date (UTC)
- Status: Scheduled, Success, Failed, In Progress
- Paid: Yes/No
- Event Date
- Event Date (or bill date if non event bill)
- Payment Method: dropdown of payment methods
- Void payments: Yes/No
- Payment void date
- Payment Taken By
For an example of a payments report please see this guide on an End of Day payments report.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article