Skip to main content
All CollectionsDashboardTransactions
How to Use the Transactions Table
How to Use the Transactions Table

The Transactions tab captures any movement of monies that was recorded by the Ventrata dashboard.

Updated over 2 weeks ago

🔐 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, visa, mc, amex)

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

Did this answer your question?