$1M+ in closed cash traced to the funnels that produced it$1M+ traced to sourceBook a call →
refundschargebackspayment plans

Refunds and chargebacks belong to the source that sold

By Taziem Uddin · · 7 min read
AFTER THE SALEMoney comes back outPAIDREFUNDCHARGEBACKDISPUTE WONKEPT

When we added refunds to one client's sales model, nobody had been refunded yet. There was no row to test against. We wrote the rule anyway and ran it on made-up rows: a refund is minus cash on the day the money moved, taken back from the sale's source, closer and setter, and the order stays a deal.

That was the right order to do it in. A refund that turns up first in a live report gets handled in a hurry, by whoever notices it, and each person fixes it differently. Writing the rule before the first refund meant the first refund had somewhere to go. This post is about that rule, and about the two other ways money comes back out of a sale: the chargeback and the instalment plan that stops.

What a missing refund costs

A source report is how an owner decides where the next ad budget goes. It adds up what each source sold. If a refund is not taken back out of that source, the source keeps the credit for money the business no longer holds, and the budget follows the credit.

Two other decisions use the same rows. A closer's commission is worked out from the cash their sales brought in, so a refund that never reaches the closer pays them for money that went back. And the cash number the owner plans the month on is wrong in the other direction when a refund is booked against the day it happened and nobody can say which sale it belonged to. In every case the refund exists in the processor and has no owner in the report.

Four things that move money after the sale

A refund. The payment is returned, wholly or in part. Stripe's refund page says its processing fees from the original payment are not returned, and that a refund is paid from your available balance. If that balance cannot cover it, Stripe holds the refund as pending, and fails it if the balance is still short 45 days later. That is a vendor describing its own product, but it shows a problem every processor has: a refund has a day it was created and a day the money moved, and your records need to say which one they use.

A chargeback. The buyer goes to their bank instead of to you. Stripe's disputes page says the issuer opens a formal dispute that reverses the payment straight away, and Stripe then debits your balance for the payment and a dispute fee. Its page on responding says you usually have 7 to 21 days to answer, depending on the card network, and that the bank's decision can take up to 3 months once you have. If you win, the amount comes back to you. If you lose, the reversal is permanent. Unless your contract says otherwise, the first fee is not returned either way. A single sale can therefore leave the books, return, and leave again, across five months.

An instalment plan that stops. If you run the plan yourself, a stopped plan is a set of future payments that will not arrive. If a lender carries it, it works differently. Stripe's page on Klarna says you receive the order amount minus fees up front and that Klarna takes the loss if the buyer cannot repay. It also says you can refund a Klarna payment up to 180 days after it completes, that Klarna cancels the remaining payments on a refunded charge, and that a partial refund is spread across the payments still to come. What the buyer gets back from a refund therefore depends on how much of the plan they had already paid. The same page says Klarna cannot refund a payment once it has become a dispute, so a late reversal arrives as a dispute and not as a refund.

A reserve. The processor holds back part of what you collected. Stripe's balances page says Stripe might create a reserve on your account to cover expected refunds and disputes, and that you cannot pay out the reserved funds until the hold period ends. The money was collected, and it is not yours to spend yet. A reserve is neither a refund nor a fee, so it belongs on its own line in a cash report, never in the refund line.

Every processor words these differently, and your own contract decides the details. Read the pages for the one you use.

The rule: money goes back to the sale it came from

Each of the four events has a date of its own, and each has a sale it undoes. A sale has a source (the link the buyer first came through), a closer, a product and a payment day. The refund row must carry all four from the payment it reverses.

A refund or chargeback is dated by the day the money moved. On that day it is minus cash, and the minus is credited back to the setter, the closer and the source of the sale it undoes. The cash post dates cash the same way, one row per payment, so a month you have already reported does not move when a refund arrives later. The refund lands in the month it happened, against the source that sold.

That answers the source question too. What did this ad actually return? Add up the cash each source collected, refunds and chargebacks included, from the first sale to today. The number for an earlier month does not get restated. The source's return falls on the day the refund moves, and you can read the fall. Print an "as of" date on the source report, and keep the cash-by-day view next to it.

A refund does not move a count. The sale was a deal when it closed and it stays a deal. The close rate and the closer's deal count do not change, and only the cash does. A full refund and a partial refund work the same way: minus the amount that moved, on the day it moved.

A worked example

This is a made-up example. It names no client, and every amount is in one currency.

Two ad sources each cost 20,000. Each brings in five buyers who pay 6,000 in full in month 1, so each source collects 30,000 and the month-1 report reads a return of 1.5 for both.

On source A, the following happens afterwards:

  • Month 2: one buyer is refunded in full (6,000) and another in part (2,000).
  • Month 3: one buyer disputes the charge, and the 6,000 is reversed at once.
  • Month 5: the dispute is contested and won, and the 6,000 returns.

Source B has no refunds and no disputes.

Source ACash on the day it movedReturn by source, cumulative to that month
Month 130,0001.5
Month 2minus 8,0001.1
Month 3minus 6,0000.8
Month 5plus 6,0001.1

Source B reads 1.5 throughout.

Return by source, as of each month
  • Source A, month 1 report1.5
    30,000 collected over a 20,000 ad bill
  • Source A, month 21.1
    a full and a partial refund come off
  • Source A, month 30.8
    a chargeback reverses one more payment
  • Source A, month 51.1
    the dispute is won and the payment returns
  • Source B, every month1.5
    no refunds, no disputes
Source A's return by source, as of each month. Source B stays at 1.5. A made-up example.

Read the two columns together. The cash column shows each movement on the day it happened. In month 2 the report carries 8,000 of negative cash, and the refund row names source A, its closer and its setter, because it carries them over from the payment it undoes. The return column says that the budget decision made in month 1, to treat the two sources as equals, was wrong by month 3, and only partly right again by month 5.

All ten sales on both sources stay deals throughout. The refunded buyers and the disputed buyer are still in the close rate, and the closer on source A is still credited with the deal. What changes is the cash credited to them, on the days the money moved: the dispute takes 6,000 out in month 3 and gives it back in month 5.

What to do this week

  1. List the refunds and disputes your processor shows for the last ninety days. For each, find the sale it undoes and write down the source, the closer and the payment day.
  2. Count how many have no sale attached. Each one is a report that has no owner for that refund.
  3. Date each one by the day the money moved, as minus cash, and credit it back to the sale's setter, closer and source. Leave the sale in the deal count and the close rate.
  4. Build one source report net of refunds with an "as of" date, and keep the cash-by-day report beside it.
  5. Show a reserve on its own line, and keep it out of the refund line.

If you want to see which of these you can answer today, the Revenue Blind-Spot Score takes about a minute. The step from call to payment in the trace of a sale is where a refund loses its source.

We wrote the refund rule before there was a refund to apply it to. The first real one will land on a source, a closer and a setter, on the day the money moved, and the deal count will stay where it was.

More from the blog

Ready to see this running on your own numbers?

Book a call →
Checking available times…