Skip to content
ENExplore Calculators

Average Transaction Value Calculator

Work out average transaction value instantly with clear inputs, formula shown and shareable results.

About Average Transaction Value Calculator

Average transaction value should be calculated net of returns, since a gross figure flatters any category with a high return rate. The gap to target, expressed in currency per transaction, is the number that translates into a specific selling behaviour on the shop floor.

Formulas

Net ATV

Net ATV = (Total sales - Returns) / Transactions

Return rate

Return rate % = Returns / Total sales x 100

Worked example

With the default values below, Average Transaction Value Calculator returns Average transaction value (net of returns) of $1,794.60. Change any input above and every figure here is recalculated in your browser.

Inputs used

Total sales
3,940,500
Number of transactions
2,130
Returns and refunds
118,000
Target average transaction value
2,000

Results

Average transaction value (net of returns)
$1,794.60
Gross average transaction value
$1,850.00
Gap to target
$205.40
Return rate on sales
2.99%

Step by step

  1. 1Values used
  2. 2Net ATV
  3. 3Return rate
  4. 4Average transaction value (net of returns)= 1,794.60
  5. 5Gross average transaction value= 1,850.00
  6. 6Gap to target= 205.40
  7. 7Return rate on sales= 2.99

Assumptions and limits

  • The result is derived only from the 4 inputs listed above. Anything not among them is not part of the calculation.
  • In particular, this calculator does not take inflation, tax, fees or charges or compounding frequency into account.
  • Figures are rounded for display to 2 decimal places, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.

How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.

Frequently Asked Questions

Should returns be deducted from the transaction count too?

Only if refunds are recorded as separate transactions in your point of sale. Deducting value but not count is the conservative approach.

What raises ATV fastest?

Bundling, tiered promotions with a spend threshold, and trading customers up within a category rather than adding cheap units.

Related Calculators

Average Transaction Value Calculator | Calcrivo