Transaction Logs & Analytics

Owned by Charles Wernicke
Last updated: May 14, 2024
4 min read

The transaction logs & analytics are very important on a daily basis. They represent everything you’re in business for, and deserve such attention.

image-20240514-174940.png

Transaction Logs

Display the various transaction reports available for this terminal, each broken down by crypto and fiat types:

  • All: lists all transactions; sales (BUY), purchases (SELL), and CASHBACKS.

  • Buy: lists all crypto sales to customers.

  • Sell: lists all crypto purchases from customers.

  • Sell Not Withdrawn: crypto purchases that are still waiting on confirmations.

  • Sell Allocated: crypto purchases that have begun, and fiat has been reserved for dispensing.

  • Cashback: fiat amounts dispensed via manual cashback transactions.

Analytics

Analytics are powerful tools & charts to visually identify sales/purchases by period.

  • Transaction Analytics: flexible chart + data for transactions

  • Behavioral Analytics: this chart shows where (in the Sales logic) your customers are spending their time, or where they abandon the transaction.

  • Cash Box Analytics: a quick & easy bill-count for this specific BATM.

image-20240513-165426.png

Transaction Log

Transaction log granularity settings:

image-20240513-165609.png

  • Limit the log (as desired) to specific coins, fiats, and date ranges.

Tags & Batch Actions:

TAGS

Tags enable you to label specific transactions with custom notes, allowing you to arbitrarily refine your logging results.

BATCH ACTIONS

Some (or all) ACTIONS may be performed on multiple transactions in a single step.

Log column descriptions:

  • Terminal: the BATM at which the transaction occurred.

  • Server Time: the time that CAS recognized the transaction.

  • Terminal Time: the timezone-sensitive time of transaction.

  • Lid: the “Local” (CAS) identifier of the transaction.

  • Rid: the “Remote” (BATM) transaction identifier.

  • Type: BUY, SELL, CASHBACK, WITHDRAW

  • Classification: [NORMAL / TEST / REFUNDED] - default = NORMAL, change to TEST or REFUNDED via ACTIONS (below)

  • Cash: the fiat amount involved.

  • Crypto: the coin amount involved.

  • Rate Incl. Fee: the calculated rate including the fees.

  • Rate W/O Fee: the calculated rate excluding the fees.

  • Fixed Fee: any charged fixed fee (see Crypto Settings).

  • % Fee: any charged variable fee (see Crypto Settings).

  • Used Discount: the % and code of any discount applied.

  • Actual Discount: the calculated amount off the fees.

  • Destination address: the wallet used.

  • Related Tx: points to the related SELL transaction.

  • Identity: the customer Identity (if any).

  • Status: varies by BUY, SELL, or REDEEM.

    • A (lock) symbol indicates the transaction is on hold due to Output Queue locking.

  • Note: manually attached to the transaction.

  • Actions: Transaction Actions explained in detail.

    • Some Actions can be performed on multiple transactions using BATCH ACTIONS.

Rate Calculations Explained:

The "Rate Incl. Fee" calculation is derived like so:
CoinCost = 10000
PercentFee = 7.0
FixedFee = 1.00
Tender= 100.00

Calculate AdjTender:

  1. Customer inserts Tender into the BATM,

  2. FixedFee is directly deducted from that: 100 - 1 = 99

  3. AdjTender is: 99

Calculate the effective purchase amount:

  1. Divide AdjTender by the profit rate,

  2. AdjTender / (1 + (.01 * PercentFee))

    1. 99 / (1 + (.01 * 7)) = 99 / (1 + .07) = 99 /1.07 = 92.523364486

    2. the effective purchase amount tendered after fees is: 92.523364486

    3. this amount is not displayed in any reporting.

The math may seem unintuitive, and admittedly many people are initially confused by it.

A % markup and a % discount are calculate differently. The goal of the equation is:

  • from what number will a certain % markup generate the AdjTender amount?

In this example, a 7% markup of $92.52, when added to $92.52, equals the AdjTender of $99.

  • Your profit amount (in this example) is: $100 - $92.52 = $7.48 (rounded).

Calculate the amount of coin at the effective rate:

  1. Divide the purchase amount by the cost of the coin,

  2. 92.523364486 / CoinCost

  3. 92.523364486 / 10000 = 0.009252336 BTC

    1. 0.009252336 is the transaction amount.

Calculate "Rate Incl. Fee":

Tender (100.00) / 0.009252336 = 10808.08 is the rate including fee.

 

Percentages are trickier than you might think. Here’s how to calculate your profit %.

  • Yet another example of the (correct) markup calculation:

    • Fixed fee 0 USD

    • 1 BTC = 100 USD

    • 7% markup/fee

The BTC exchange rate for end customers is: 1 BTC = 107 USD.

  • What is the profit of the operator when somebody buys 1 BTC? Hint: 7 USD

  • Operator bought 1 BTC for 100 USD and sold it for 107 USD. 7% markup

  1. Customer inserts 107 USD.

  2. They will receive 1 BTC.

  3. What is the profit of the operator? 7 USD.

Calculation is: 107/1.07 = 100. Operator’s profit is 107 - 100 = 7 USD.

The (erroneous) discount calculation should not be considered here, and this is why:

  • 7% of 107 = 7.49, subtracting that from 107 = 99.51, which is less than a whole BTC.

  • Someone would be cheated by this equation.

 

One more Example

Yet another explanation of calculation (transaction ROABHX):

  1. Customer inserted $55

  2. Amount inserted without fixed fee = $55(total inserted) - $2.99 (fixed fee) = $52.01

  3. Amount without markup = $52.01 ÷ 115(operator’s markup 15%) × 100 = 0,45226087 ×100 = $45,226086957

  4. Operator’s markup = $52.01 - $45,226086957 = $6,78

Copyright © 2020-2024 General Bytes USA LLC