🔐 Required Role Permissions: Transactions
🔓 Optional Role Permissions: Save Searches, See Bulk Action, Data Export, Generate Reports
Default Columns
Action - refers to the type of transaction
Action | Description |
Dispute | an amount disputed via a chargeback |
Adjustment | represent the transaction fees taken by the payment service provider (PSP), in rare cases it may capture other financial adjustments, like reserve deposits |
Bill | not used |
Refund | any refunds made by the operation |
Payout | any payouts made to the reseller through an invoice |
Payment | any payments collected by the operation |
Balance Transfer | not used |
Reference - shows the numeric transaction reference
Channel - indicates where the transaction occurred
Amount - shows the exact financial amount of the transaction
Order - shows the alphanumeric order reference
Method - refers to the payment method use to make the transaction; methods include
Payment Method |
Credit / Debit Card |
Cash |
Reseller Voucher |
Gift Card |
Other |
Balance Transfer |
Transaction Date - shows the date of the transaction
Transaction Time - shows the time of the transaction
📗 TIP
Columns can be easily filtered by pressing the arrow next to the column title.
Actions
The action bar between the navigation bar and the bookings table enables you to perform a number of additional functions.
Search bar - filter the bookings table, using any parameter from the available columns
Keep Filter - when using search, tick the checkbox to make the column filters available
Saved Searches - press Saved Searches> Save Current Search to save your current search parameters and filtered columns, or Saved Searches > Manage Searches to edit or delete existing searches
📗 TIP
To learn more about saved searches, read our article Working with Saved Searches.
Reset All Filters - appears when a filter was used; press to reset filters to their default states
Bulk Actions - select one or multiple bookings and press to apply an action on your selection; options include
Bulk Action | Description |
Change Other Type | change the payment method of all selected transactions to an 'Other', or custom, payment method |
Show Columns - press to add new columns, or remove existing ones from your current view
📗 TIP
The list of columns which can be added is listed at the end of this article, under Generate Report.
Export - export the bookings table in CSV, Excel or SQL format
Generate Report - create charts and reports to analyse data from the booking table
📗 TIP
To learn more about reports, read our article Working with Charts and Reports.
Available Columns
Column | Description |
Action | refers to the type of transaction, see above |
Reference | shows the numeric transaction reference |
Channel | the source of the sale (Terminal, Web Checkout, Backoffice, Direct API, Concierge, Sales Kiosk, custom channels) |
Amount | shows the exact financial amount of the transaction |
Method | refers to the payment method use to make the transaction; methods include credit/debit card, cash, voucher, gift card, balancer transfer, other |
Order | displays the alphanumeric order reference |
Transaction Date | shows the date when the transaction occurred |
Transaction Time | displays the exact time when the transaction took place |
Voided | indicates whether the transaction was voided (Yes/No) |
Voided Date | if a transaction was voided, shows the date it was voided |
Voided Time | if a transaction was voided, shows the exact time it was voided |
ID | a unique alphanumeric string identifying the transaction |
Payment ID | a unique alphanumeric string identifying the payment |
Shift ID | a unique identifier of the shift |
Shift | the name of the shift, usually the same as the seller's name |
Seller | the name of the seller who processed the transaction |
User | the name of the dashboard user who created or modified the transaction |
Location | the terminal location where the transaction was made |
Location Channel | the channel assigned to the transaction location |
Location Tags | tags assigned to a location; used for filtering |
Peach Brand | the brand of credit / debit card, or other digital transactions processed via Peach Payments |
Card Bin | the first 6 digits of a credit or debit card number, identifying the issuing bank and card type |
Card Brand | the payment network of the card used (for example, |
Card Country | the country where the credit or debit card was issued |
Card Funding | indicates the type of card use (credit, debit) |
Card Holder | the name of the cardholder, if available |
Card Last4 | the last four digits of the credit or debit card used |
Card Variant | specifies the type of card (for example, Platinum, Gold, Standard) |
Ghost | indicates whether the transaction was marked as a ghost transaction (Yes/No) |
Recovered | indicates if the transaction was part of a recovered abandoned checkout session |
Gateway | the payment gateway used to process the transaction |
Custom Gateway | indicates that the gateway is not any of the supported |
Transfer | shows the transfer reference |
Transfer Date | the date when the transfer was initiated |
Transferred | indicates whether the transaction was part of a transfer (Yes/ No) |
Transfer Currency | currency used for the transfer |
Transfer Amount | the exact amount transferred |
Gift Code | a gift card or voucher code used for payment |
Adyen PSP | the Payment Service Provider (PSP) reference for transactions processed via Adyen |
VivaWallet Reference | a reference code for transactions processed via VivaWallet |
Razorpay Payment ID | a unique identifier for transactions processed via Razorpay |
Stripe Charge ID | a unique identifier for transactions processed via Stripe |
BridgePay Gateway ID | a unique identifier for transactions processed via BridgePay |
BridgePay Auth Code | a unique authorisation code generated for transactions processed via BridgePay, confirming that the payment was approved |
BridgePay Reference | a reference for transactions processed via BridgePay |
Has Order | indicates whether the transaction is linked to an order (Yes/No) |
Customer | the full name of the customer |
Has Invoice | indicates whether the transaction is associated with an invoice |
Invoice | reseller invoice reference, consists of reseller code or name and invoice number |
Has Top-up | indicates whether the transaction includes a reseller top-up |
Top-up | the top-up reference |
Currency | the currency used for the transaction |
Terminal | the name of the terminal where the transaction was performed |
Test | indicates whether the transaction is part of a test booking |
Cash Tendered | the amount of cash received in a cash transaction |
Surcharge | any additional fee applied to the transaction |
Gratuity | any tip or gratuity added to the transaction |
Fees | credit card processing fees charged by the credit card processor (for example, Adyen); these fees will only be displayed after Ventrata receives the batch transfer from Adyen, therefore, they will not appear immediately when a transaction occurs. |
Net | the net amount received after deducting fees and charges |
Supplier FX | the conversion rate used against the supplier’s base currency |
Source | the name of the source from which the transaction originated |
Sequence Value | indicates the order number of the transaction in the database |
Destination | the destination where the product belongs to |
Billing Account Code | a code assigned to a billing account for tracking purposes |
Seller Billing Account Code | a code assigned to a seller for billing purposes |
Reseller Billing Account Code | a custom code used for ERP integrations like SAP |
Reseller | the name of the reseller who processed the transaction |
Reseller Channel | the assigned sales channel of the reseller |
Reseller Destination | the destination assigned to the reseller |
Reseller Tags | tags assigned to a reseller; used for filtering |
Reseller Allow Top-ups | indicates whether a reseller is allowed to receive credit top-up; credit is used when a reseller, usually a concierge, accepts cash payments instead of using the payment gateway, which can be a liability for the operation |
Imported | indicates whether the booking associated with the transaction was imported from another system |
Outlet | the name of the reseller outlet; outlets function as chains assigned to a reseller |
Agent | the name of an agent working for the reseller who processed the transaction |
Notes | any additional information or remarks added to the transaction |
Other Type | the reference of an other payment method |