Free tool · Robert × Dor
Average transaction value
& UPT calculator.
Turn your POS totals into average transaction value, units per transaction and average unit retail. Then test what a change in traffic, conversion or basket size would do to sales.
Average transaction value and units per transaction calculator
Average transaction value
$42.00
2.10 items per sale at $20.00 each.
- Units per transaction
- 2.10
- Average unit retail
- $20.00
- Conversion rate
- 20.0%
- transactions ÷ visitors
- Sales per visitor
- $8.40
What-if sales
$48,510 +$6,510 (+15.5%)
Bars show each change on its own. Together they multiply, so the combined change (+$6,510) is a little more than their sum. New ATV: $44.10, new conversion 22.0%.
Show your work
ATV = net sales ÷ transactions$42,000 ÷ 1,000 = $42.00UPT = units ÷ transactions2,100 ÷ 1,000 = 2.10AUR = net sales ÷ units$42,000 ÷ 2,100 = $20.00Check: ATV = UPT × AUR2.10 × $20.00 = $42.00Sales = visitors × conversion × UPT × AUR5,000 × 20.00% × 2.10 × $20.00 = $42,000New sales = sales × (1 + traffic) × (1 + conversion) × (1 + UPT) × (1 + AUR)$42,000 × 1.1550 = $48,510
Worked example.
A gift shop’s POS shows $42,000 of net sales from 1,000 transactions and 2,100 units in a month. A door counter recorded 5,000 visitors.
- ATV: $42,000 ÷ 1,000 = $42.00.
- UPT: 2,100 ÷ 1,000 = 2.10 items per sale.
- AUR: $42,000 ÷ 2,100 = $20.00 per item. Check: 2.10 × $20.00 = $42.00.
- Conversion: 1,000 ÷ 5,000 = 20%. Sales per visitor: $8.40.
What if conversion rises 10% (20% to 22%) and a till-point add-on lifts UPT 5% (2.10 to 2.205)? Sales become $42,000 × 1.10 × 1.05 = $48,510, up $6,510. On their own those changes are worth $4,200 and $2,100; the extra $210 is the add-on applying to the new buyers too.
Four levers, one formula.
Every sale breaks down into traffic × conversion × units per transaction × average unit retail. ATV is just the last two multiplied. Splitting it shows which lever moved and what to work on:
- UPT responds to selling skills, bundles, displays near the till and complementary stock placed together.
- AUR responds to price, mix and markdowns. A higher AUR from fewer discounts is better than one from selling a single expensive item that leaves a hole elsewhere.
- Conversion responds to staffing at peak hours, stock availability and fitting-room or checkout queues.
- Traffic responds to location, windows, marketing and events. Without a visitor count it is invisible in POS data.
Questions retailers ask.
How do I calculate average transaction value?
Divide net sales by the number of transactions in the same period. $42,000 from 1,000 transactions is a $42 ATV. Use receipts, not items, and net sales after returns.
What is UPT in retail?
Units per transaction: the average number of items in each sale. Divide units sold by transactions. 2,100 units across 1,000 sales is a UPT of 2.1.
What is average unit retail (AUR)?
The average price each item actually sold for: net sales divided by units sold. It falls with markdowns and rises with a richer mix.
How are ATV, UPT and AUR related?
ATV equals UPT multiplied by AUR. If ATV drops, the split tells you whether customers bought fewer items or cheaper ones.
Which lever grows sales fastest?
Each lever multiplies sales, so a 10% gain in any one adds 10%. What differs is the cost and effort to move it; for many stores, conversion and UPT are cheaper to improve than traffic.
Add the missing lever: traffic.
Your POS knows ATV and UPT. Dor adds the visitor count, so you can see conversion and sales per visitor every hour.
Book a Dor demo (opens dorhq.com in a new tab)