"As contracted" uses each reseller's own terms. The other two are a what-if: they show how much each payout moves if everyone earned on billed revenue (when the invoice goes out) or on collected revenue (when the customer pays).
Payouts by reseller
Open a reseller to see every September invoice behind its number, including the ones that were left out and why.
Held for review
Each of these needs a person's decision. Held amounts stay out of "ready to pay" until then.
Watch list
Not held, but worth a look: part-paid invoices, and amounts a billed-basis reseller earns before the customer has paid.
Assumptions
The reseller terms are made up for this demo. Every rule the checker uses is listed below in plain words.
- Money is kept in whole cents and rates in basis points (100 bps = 1%). Every division rounds down.
- What earns a share: subscriptions always; add-ons only if the reseller's terms include them; one-time fees (implementation, training) never; void invoices never.
- Billed basis: the reseller earns on an invoice when it goes out, paid or not. Collected basis: the reseller earns on the share that was paid (eligible amount times paid over total, rounded down to the cent).
- Earned on each invoice = eligible amount times the rate, rounded down to the cent. The fractions of a cent that rounding drops are added up and shown, so the totals reconcile to the cent.
- A 12-month term runs from the customer's start date. Invoices dated on or after the anniversary earn nothing. Lifetime terms never stop.
- Payments are matched to invoices by reference, oldest first. A payment with no reference is held. A payment that arrives after its invoice is already paid in full is a duplicate: it's held and doesn't count as revenue.
- A refund on an invoice that was already paid out: if the reseller's terms allow clawbacks, the checker proposes taking back the same share of what was paid on that invoice as the share that was refunded, and holds it until someone confirms. If they don't, the reseller keeps what it was paid and the refund is absorbed (shown as a note).
- A customer who changes resellers during the month is held, with three options: split by days (each reseller's own terms, for the days the customer was theirs), all to the old reseller, or all to the new one. The amount in question is the largest of the three. A 12-month term at the new reseller would start on the move date.
- A customer tagged to a reseller with no terms on file is held. Nothing is guessed.
- Each reseller's own invoice to us is compared with what the record says it earned under its contract, before held items are decided. Any difference is held. The basis what-if never changes this comparison.
- Part-paid invoices aren't held. They go on the Watch list, as do billed-basis amounts earned before the customer pays.
- Payout minimum: if a reseller's total for the month, plus anything carried in, is under its minimum, all of it carries to next month.
- Proposed clawbacks and held amounts are not taken out of, or added to, "ready to pay" until a person decides.
- Direct customers (no reseller) are ignored. Only invoices dated in September earn in September.
Reconciliation checks
Worked out live every time the numbers change. If any of these fails, the payout shouldn't go out.
Questions I'd need answered before using this on real numbers
- Do resellers earn on billed or collected revenue, and does it differ by partner?
- Do add-ons and one-time implementation fees count?
- Is the share for the life of the customer or a fixed term?
- When a customer is refunded after a payout, do you claw it back from the next payout or absorb it?
- Do any resellers bill customers themselves and remit to you?
- Monthly or quarterly payouts, and is there a minimum?