All use cases
Refund Above the Sale · Integrity · already happened
  1. 01How it is found
  2. 02What you see
  3. 03What you do next
  4. 04The money
  5. 05In both engines' views
  6. 06On from the start

Sold for $80. Refunded $120.

A double refund, a refund on the wrong order, a partial refund typed as a full one. Otiox checks every order's refunds against what it sold for and shows the amount over the sale.
app.otiox.comFig. 00
Integrity · margin
Refunded $40 more than it sold for
Order · last 90 days
SignalMeasuredValue
Sold fororder amount$80.00
Refund 1shop$80.00
Refund 2by hand$40.00
Over the sale: $40
What to do

Open the order's payments and check the refunds.

The extra refund is recovered or corrected.

01The Challenge

Refunds are fast. Checks are not.

For example: an $80 order is refunded twice, $80 from the shop and $40 by hand. The customer got $120 back on an $80 sale. Refunds come from several places, and nobody adds them up per order.
  1. 01
    Refunds come from the shop, the processor and by hand
  2. 02
    Nobody adds them up per order
  3. 03
    Double refunds look like normal refunds
  4. 04
    Money leaves and never comes back
02SEE IT IN OTIOX

The same situation, in the product.

Real screens from the Otiox demo workspace, step by step.
  1. 01

    The finding, and how it happened

    The Integrity Engine's finding names the record and what to do, and its cascade shows how it reached the money. Open the order's payments and check the refunds: a double refund, or a refund on the wrong order.

    The finding, and how it happened
  2. 02

    Where the margin goes

    On the order, the waterfall runs from price through discount, goods cost, shipping not paid by the customer, payment fees and refunds to the true margin, and names the biggest leak.

    Where the margin goes
  3. 03

    On, shadow or off

    The scenario's row on the Scenario switches page: how many findings are open, and its switch. It is on from the start; shadow keeps it counting without raising findings.

    On, shadow or off
03

How It Works

Purpose-built features that solve these exact problems.
01

How it is found

Orders of the last 90 days whose refunds (not reversed) add up to more than the order amount.
02

What you see

The Risk Inbox line "Order {n} refunded $40 more than it sold for" with an Open order button; the order's waterfall shows the refunds step.
03

What you do next

Open the order's payments and check the refunds: a double refund, or a refund on the wrong order.
04

The money

Refunded minus sold.
05

In both engines' views

The finding appears in the Integrity Engine with its cascade from the record to the money, in the Risk Inbox and in the Loss Prevention Report.
06

On from the start

The scenario is on by default. Put it in shadow to keep it counting on the margin scenarios screen, with a six-month backtest, without raising findings, or switch it off.
04

What You'll Gain

Tangible improvements that impact your bottom line.
  1. 01
    Every refund added up

    Per order, from every source.

  2. 02
    Caught in days

    Not at the year-end reconciliation.

  3. 03
    Counted with every other loss

    Margin findings feed the Loss Prevention Report next to the other engine findings.

  4. 04
    Nothing changes by itself

    No scenario changes a price, a discount or an order. You decide.

05

Real-World Scenarios

See how this works in practice.
Scenario 1

Refunded twice

An $80 order gets $80 and $40 back.
Scenario 2

Flagged

The finding shows $40 refunded above the sale.
Scenario 3

Fixed

The second refund was meant for another order; it is corrected.
06

The Transformation

From chaos to clarity.
Before
  • Refunds from many places
  • Never added up
  • Double refunds unnoticed
  • Found at reconciliation
After
  • Refunds summed per order
  • Over-refunds flagged
  • Amount over the sale shown
  • Corrected in days
07

Frequently Asked Questions

Quick answers to common questions.
01Are reversed refunds counted?
No. Only refunds that were not reversed.
02Does it look at returns?
It looks at refunds on the order's payments, whatever their source.
03Who sees the numbers?
Cost and margin figures are shown only to people with cost or accounting rights.
04Does Otiox change prices or orders?
No. No scenario changes a price, a discount or an order. It raises the finding and opens the record; the decision is yours.
05Can I put it in shadow or switch it off?
Yes. Every scenario is on from the start. Per scenario, you can put it in shadow (it keeps counting on the margin scenarios screen, with a six-month backtest, but raises nothing) or switch it off, on the margin card or the Scenario switches page. Thresholds are workspace settings.
06Which currency are the amounts in?
Your books currency, at the store's own rate. With no rate, the amount is left empty, never guessed. VAT is taken out before margins; test, cancelled, refunded, draft and abandoned orders are left out.
Refund Above the Sale

Ready to transform your refund above the sale?

See how Otiox can solve your specific challenges.