Operator guideEN

Transactions / Banking

Filterable banking transaction dashboard with weekly summary cards, backend stats charts, CSV export, and a detailed ledger-style table.

How to use this guide

Start with the main guide

Follow the explanation and examples first. Extra definitions and formulas are available below when you need them.

What This Surface Shows

Transactions / Banking is the main investigation page for payment and wallet-side movement. It combines a quick weekly snapshot at the top with a filterable transaction ledger underneath.

Use it when the question is about deposits, withdrawals, bonus money movement, provider references, balances before and after a transaction, affiliate payload fields, or a specific payment transaction id.

How To Read It

The top cards and charts are a weekly snapshot. They are useful for orientation:

  • Weekly Transactions is the count of current-week banking rows.
  • Weekly Volume (EUR) is the current-week amount normalized to EUR.
  • Weekly Success Rate is the share of current-week rows that meet the backend success definition.
  • Weekly Avg Value is the EUR weekly volume divided by the weekly transaction count.

The table is the operator work surface. Use it to inspect:

  • transaction id and payment transaction id
  • actionee email and player profile
  • provider, method, currency, type, and status
  • original amount and Amount EUR
  • balance before and after
  • affiliate PID and Sub ID 2
  • user tags, country, deposit form version, and optional More Info details

Filters That Change The Table

The filter form affects the table and CSV export:

  • Provider
  • ClickID or PID
  • Affiliate PID
  • Sub ID 2
  • Payment Transaction ID
  • Currency
  • Type
  • Status
  • Search by tag
  • From
  • To

Clicking a user tag in the table also writes that tag into Search by tag and immediately reloads the table.

Export Behavior

Export downloads a CSV for the current Banking query. It uses the active filters and date range, but it is not limited to only the rows currently visible on the page.

Two timestamp rules matter:

  • The table labels Updated and Date as UTC.
  • The CSV converts Created and Updated timestamps into the browser timezone sent with the export request.

The CSV can also include export-only metadata that is not visible as a table column.

Common Questions

Do the cards change when I apply table filters?

No. The cards and charts use a separate weekly stats dataset. The table filters change the ledger rows and CSV export, not the top snapshot.

What does ClickID or PID search?

It checks two affiliate payload identifiers: ClickID and PID. Use Affiliate PID when you want the dedicated PID field only.

Why can Provider find more than just provider names?

Provider search is intentionally broad. It can match the provider, payment method, and, when no specific payment transaction id is supplied, the payment transaction id.

Why does Sub ID 2 match partial text?

Sub ID 2 is a case-insensitive contains search. It is useful when the operator has only part of the webmaster or sub-affiliate value.

Does More Info change the transaction?

No. More Info is read-only and appears only on rows that carry extra detail payloads.

Known Caveats

  • The weekly snapshot does not follow the table filter form.
  • If the trend dataset is empty, the chart can show placeholder points so the chart area stays readable.
  • Rows without a conversion rate can still appear in the table, but their EUR contribution in weekly volume formulas is treated as zero.
  • No inline transaction mutation is visible on this grid.
More details

Definitions and formulas

Open only the section you need. The relevant section opens automatically when you request help for a specific item on screen.

Calculations16 topicsOpen details

Amount EUR

EUR-normalized row amount shown next to the original row amount.

Formula
`amountEUR = amount / conversionRate` when the row has a non-null, non-zero conversion rate. Rows without a valid conversion rate return NULL for this row-level derived value.
Currency Basis
Original Amount: Row `amount` in row `currencyCode`. | Reporting Currency: EUR display in the grid. | Exchange Rate Source: Per-row `conversionRate` stored on the banking transaction row. | Missing Rate Behavior: A null or zero conversion rate prevents a valid EUR division for the row amount.

Weekly Transactions

Count of all Banking rows whose creation time falls in the current backend week.

Formula
Count all rows with `created_at` between current-week start and current-week end.
Scope
Uses the stats dataset, not the filtered table dataset., Does not follow Provider, ClickID or PID, Affiliate PID, Sub ID 2, Payment Transaction ID, Currency, Type, Status, tag, From, or To filters from the table form.

Weekly Volume (EUR)

Current-week Banking volume normalized to EUR for the stats card.

Formula
Sum `amount / conversion_rate` for current-week rows where `conversion_rate` is present and not zero. Rows with missing or zero conversion rate contribute 0 to this stats total.
Currency Basis
Reporting Currency: EUR | Original Amount: Row `amount`. | Exchange Rate Source: Per-row `conversion_rate` stored on the banking transaction row. | Missing Rate Behavior: Rows with null or zero conversion rate are included in the row universe but contribute 0 EUR to this sum. | Rounding Boundary: Backend rounds the final weekly volume to two decimals before the card is formatted.
Scope
Uses the stats dataset, not the filtered table dataset.

Weekly Success Rate

Current-week success percentage for the stats card.

Formula
`weeklySuccessfulTransactions / weeklyTransactions * 100`. Successful rows must have `actioneeType = user`, `isSuccess = true`, and numeric status `1`.
Rounding Boundary
Backend rounds the rate to two decimals for the raw value; the frontend formats the card with one decimal.
Scope
The denominator is all current-week Banking rows., The numerator is stricter than "all rows with a success-looking label" because it requires user actionee, success flag, and status `1`., Uses the stats dataset, not the filtered table dataset.

Weekly Avg Value

Average current-week Banking value in EUR for the stats card.

Formula
`weeklyVolumeEUR / weeklyTransactions`; returns 0 when there are no weekly transactions.
Currency Basis
Reporting Currency: EUR | Numerator: Weekly Volume (EUR). | Denominator: Weekly Transactions. | Missing Rate Behavior: Rows with missing or zero conversion rate still count in the denominator even though they contribute 0 EUR to the numerator. | Rounding Boundary: Backend rounds the final average to two decimals before the card is formatted.
Scope
Uses the stats dataset, not the filtered table dataset.

Transaction Type Distribution

Current-week chart count grouped by transaction type.

Formula
Count current-week rows grouped by non-null `transaction_type`.
Scope
Uses the stats dataset, not the filtered table dataset., Frontend falls back to zero-value Deposit, Withdraw, and Bonus slices when distribution data is missing.

Weekly Transaction Trend

Last-four-week chart comparing deposit counts and withdrawal counts.

Formula
For each week in the last-four-week range, count rows with `transaction_type = deposit` and rows with `transaction_type = withdraw`.
Scope
Uses the stats dataset, not the filtered table dataset., Frontend can render placeholder weekly points if the backend returns no trend rows.

From / To

Date range applied to the Banking table query.

Formula
The frontend sends `startDate`, `endDate`, and browser `timeZone`; the backend applies the date filter to Banking row creation time.
Timezone Basis
Table Display: Updated and Date columns are rendered in UTC. | Csv Export: Created and Updated timestamps are converted from UTC into the browser timezone supplied by the export request.

Provider

Broad payment lookup over provider, method, and sometimes payment transaction id.

Formula
Case-insensitive contains search against payment provider and payment method. When Payment Transaction ID is empty, the same provider text can also match payment transaction id.

Payment Transaction ID

Narrows rows by payment transaction id text.

Formula
Case-insensitive contains search against payment transaction id.

Status

Narrows rows by backend Banking transaction status.

Formula
Accepts status keys and numeric strings. The SUCCESS key also includes the backend APPROVED numeric status.

ClickID or PID

Finds rows connected to either a ClickID or a PID in the joined affiliate payload.

Formula
Match affiliate payload `click_id = value` or affiliate payload `pid = value`.

Affiliate PID

Narrows rows to a specific affiliate PID.

Formula
Exact match on affiliate payload `pid`.

Sub ID 2

Narrows rows by webmaster or sub-affiliate marker text.

Formula
Case-insensitive contains match on affiliate payload `sub_id2`.

Search by tag

Narrows rows by user tags.

Formula
Lowercase contains match over each text value inside the user's tags array. Clicking a tag chip writes the clicked tag into this filter and submits the table query.

CSV export scope

Exported rows match the current Banking query but are not limited to the visible page.

Formula
The export branch removes normal pagination, uses the same filter replacements as the table query, converts Created and Updated timestamps from UTC to the supplied browser timezone, and appends export-only product prefix metadata.
Settings Dependency
system-settings.productPrefix
Notes3 topicsOpen details

Summary cards and charts are not recomputed from the visible table rows.

Table timestamps are intentionally shown in UTC; CSV timestamps are converted during export.

The current Transactions / Banking grid does not expose an inline mutation action.

Columns22 topicsOpen details

ID

Internal Banking row identifier used to distinguish rows.

Transaction

Payment processor or payment-flow transaction reference when available.

Actionee

User email attached to the Banking row; clicking it opens the player profile.

Provider

Payment provider recorded on the Banking row.

Currency

Original currency of the Banking row amount.

Amount

Original transaction amount in the row currency.

Data Type
amount

Amount EUR

EUR-normalized amount derived from the row amount and stored conversion rate.

Data Type
amount
Caveat
Missing or zero conversion rate prevents a valid row-level EUR value.

Type

Commercial type/classification of the Banking movement.

Role

Actor role recorded on the row, commonly user or admin-side actor categories.

Bonus ID

Bonus identifier attached to bonus-related money movement when present.

Aff PID

Affiliate PID joined from the user's affiliate-link payload.

Sub ID 2

Sub-affiliate or webmaster marker joined from the affiliate-link payload.

Method

Payment method displayed for the row.

Caveat
Historical Skrill and GatewayCrypto withdraw rows can be normalized from fallback provider payload data when the raw method is empty.

Status

Human-readable Banking transaction status label.

Balance Before

Wallet balance before the Banking movement, in the row currency.

Data Type
amount

Balance After

Wallet balance after the Banking movement, in the row currency.

Data Type
amount

Updated

Last update timestamp for the Banking row.

Timezone Basis
Rendered in UTC with an explicit tooltip.

Date

Creation timestamp for the Banking row.

Timezone Basis
Rendered in UTC with an explicit tooltip.

User Tags

Tags currently joined from the user record; visible chips can be used as a tag filter.

Country

Country code joined from the user record.

Deposit Form

Deposit form version marker stored on the Banking row when available.

Action

Contains More Info when the row carries extra processor/payment details.

Filters11 topicsOpen details

Provider

Searches payment provider and payment method text; when Payment Transaction ID is empty, it can also match payment transaction id.

Type
text
Affects
table rows, CSV export

ClickID or PID

Finds rows where the joined affiliate payload has this value as either ClickID or PID.

Type
text
Match Behavior
Exact match against affiliate payload `click_id` or `pid`.
Affects
table rows, CSV export

Affiliate PID

Finds rows for one dedicated affiliate PID.

Type
text
Match Behavior
Exact match against affiliate payload `pid`.
Affects
table rows, CSV export

Sub ID 2

Finds rows by webmaster or sub-affiliate marker text.

Type
text
Match Behavior
Case-insensitive contains match against affiliate payload `sub_id2`.
Affects
table rows, CSV export

Payment Transaction ID

Finds a processor/payment transaction reference.

Type
text
Match Behavior
Case-insensitive contains match against payment transaction id.
Affects
table rows, CSV export

Currency

Narrows rows to one transaction currency.

Type
select
Affects
table rows, CSV export

Type

Narrows rows by Banking transaction type such as deposit, withdraw, bonus, add money, or remove money.

Type
select
Affects
table rows, CSV export

Status

Narrows rows by Banking transaction status.

Type
select
Caveat
The backend SUCCESS status key also includes approved status rows.
Affects
table rows, CSV export

Search by tag

Narrows rows by user tags. Clicking a visible tag chip also fills this filter and submits the table query.

Type
text
Match Behavior
Case-insensitive contains match across user tag text values.
Affects
table rows, CSV export

From

Start of the Banking row creation-time window used by the table query.

Type
date
Affects
table rows, CSV export

To

End of the Banking row creation-time window used by the table query.

Type
date
Affects
table rows, CSV export
Summary cards4 topicsOpen details

Weekly Transactions

Count of current-week Banking rows in the separate stats snapshot.

Caveat
Does not follow the table filter form.

Weekly Volume (EUR)

Current-week Banking volume normalized to EUR from row amounts and stored conversion rates.

Caveat
Rows with missing or zero conversion rate contribute 0 EUR to the stats total.

Weekly Success Rate

Current-week success percentage using the backend success definition.

Caveat
Successful rows require user actionee, success flag, and status `1`.

Weekly Avg Value

Weekly Volume (EUR) divided by Weekly Transactions.

Caveat
Does not follow the table filter form.
Charts2 topicsOpen details

Transaction Type Distribution

Current-week count grouped by transaction type.

Caveat
Frontend can show zero-value fallback slices when distribution data is missing.

Weekly Transaction Trend

Deposit and withdrawal counts by week for the last-four-week stats range.

Caveat
Frontend can show placeholder points when no trend rows are returned.
Metrics4 topicsOpen details

Weekly Transactions

Count-style headline for the current weekly banking snapshot.

Aliases
total weekly transactions, banking transactions this week
Filter Dependencies
stats_section_scope
Display Rules
display-safe string normalization
Formula
Count all `transaction_bankings` rows whose `created_at` falls in the current week.

Weekly Volume (EUR)

EUR-normalized volume headline shown in the stats area.

Aliases
weekly volume, banking volume eur
Filter Dependencies
stats_section_scope
Formula
Sum `amount / conversion_rate` for current-week rows with a non-zero conversion rate.
Currency Basis
Reporting Currency: EUR | Reporting Currency Note: The stats card is formatted with a euro sign and uses `amount / conversion_rate` from the banking rows. | Exchange Rate Source: Per-row conversion_rate column on transaction_bankings; converted value is amount / conversion_rate. | Rate Basis: row-stored-rate | Rate Basis Note: The stats query reads the conversion rate already stored on each banking row; it does not fetch a current rate during report rendering. | Missing Rate Fallback: Rows with a NULL or zero conversion_rate contribute 0 to the EUR sum through the source fallback; they are not excluded from the row set.

Weekly Success Rate

Success-rate headline shown next to the volume and count cards.

Aliases
success rate, banking success rate
Filter Dependencies
stats_section_scope
Formula
`weeklySuccessfulTransactions / weeklyTransactions * 100`, where success requires `actioneeType='user'`, `isSuccess=true`, and `status=1`.

Weekly Avg Value

Average value headline for the weekly banking stats section.

Aliases
average transaction value, avg banking transaction
Filter Dependencies
stats_section_scope
Formula
`weeklyVolumeEUR / weeklyTransactions`.
Currency Basis
Reporting Currency: EUR | Reporting Currency Note: Inherits the EUR display basis of weekly_volume_eur. | Exchange Rate Source: Same per-row conversion_rate column on transaction_bankings used by weekly_volume_eur. | Rate Basis: row-stored-rate | Rate Basis Note: Numerator uses the conversion_rate already stored on each row, not a rate fetched during report rendering. | Missing Rate Fallback: Denominator (weekly_transactions) counts every current-week row, including rows whose NULL or zero conversion_rate contributed 0 EUR to the numerator, so the average can be understated when rates are missing.
More help

Related pages

Transactions / Casino

Game transaction dashboard with real-time list mode, monthly analytics mode, filterable table, and a dedicated transaction detail route.

Transactions / Casino Transaction Detail

Read-only detail page for a single casino transaction identified by `casinoTransactionId`.

Transactions / Failed Deposit

Triage grid for failed deposit rows, provider failure reasons, normalized error groups, raw detail inspection, and CSV export.

Transactions / Failed Deposit Error Groups

Configuration surface for creating, editing, importing, exporting, and assigning failed-deposit error groups and their reasons.

Transactions / KYC

Action-heavy KYC document queue exposed under the transactions area for document review, verification, re-request, download, and third-party checks.

Transactions / Shared Detail Modals

Reusable read-only transaction payload modals for banking-style rows on banking, withdrawals, and failed-deposit surfaces.