This template belongs to the guide on calculating an illustrative referral reward. Where the calculation scenarios page compares payment patterns, this page gives you the ledger itself: the columns, the formulas, a filled-in example and the checks that reconcile it.
The ledger columns and what goes in each
Copy these columns into any spreadsheet. Each row is one actual payment SourceX made to the referred company.
| Column | What to enter | Formula or source |
|---|---|---|
| Line | 1, 2, 3 in payment order | Typed |
| Payment date | The date the installment was paid to the company | From the status SourceX shows for your referral |
| Amount paid | The full payment | From SourceX |
| Itemized exclusions | Separately itemized taxes and expense reimbursements in that payment | From SourceX |
| Qualifying amount | Amount paid minus itemized exclusions | Amount paid less exclusions |
| Running base | Sum of qualifying amounts to date | Previous running base plus this line |
| 5% of this line | The proportionate element | Qualifying amount times 0.05 |
| Floor element | USD 50,000 on the first line that meets every condition, blank after that | Once per referred company |
| Recorded | What this line adds | 5% of this line plus the floor element, if any |
| Running total | Cumulative recorded amount, or 15% of the running base once that is greater | Previous running total plus recorded |
| Status | Estimated, Eligible, Approved, Processing or Paid | As shown on the rewards page |
Two rules keep the ledger honest. No row exists for an installment that has not been paid. And the USD 50,000 element appears on one line only, the first installment that meets every condition, because the floor applies once per referred company and not again on a repeat license, renewal or amendment. There is no cap: once the running base passes USD 500,000, 15% of it is the greater figure and the running total follows that instead.
A filled-in ledger: three installments, one floor
Illustrative and fictional. A 320-person environmental testing laboratory licenses a dataset of sample-handling records. The agreement provides three installments and its USD 420,000 of compensation clears the USD 100,000 Minimum Transaction. The second payment also includes $8,000 of separately itemized expense reimbursement for data preparation.
| Line | Paid | Amount paid | Exclusions | Qualifying | Running base | 5% of line | Floor element | Recorded | Running total |
|---|---|---|---|---|---|---|---|---|---|
| 1 | February 10 | $90,000 | $0 | $90,000 | $90,000 | $4,500 | USD 50,000 | $54,500 | $54,500 |
| 2 | May 12 | $158,000 | $8,000 | $150,000 | $240,000 | $7,500 | None | $7,500 | $62,000 |
| 3 | September 8 | $180,000 | $0 | $180,000 | $420,000 | $9,000 | None | $9,000 | $71,000 |
Reading it line by line:
- Line 1 carries the floor: USD 50,000 plus 5% of $90,000, so $54,500 is recorded.
- Line 2 shows the exclusion. The company received $158,000, but only $150,000 qualifies, so the line adds $7,500, not $7,900.
- Line 3 is the check line. 5% of $180,000 is $9,000, taking the running total to $71,000; 15% of the $420,000 running base is $63,000, lower, so the floor-plus-5% figure stands.
The laboratory's own payout is untouched by any of this. The reward is funded separately by SourceX; the proceeds guide keeps the two apart.
Lines that need special handling
| Situation | How to record it | Effect on the running total |
|---|---|---|
| An installment is scheduled but unpaid | A note with no amount, or no row at all | None until paid |
| A later installment arrives after the floor has been recorded | A row with the payment and 5% of its qualifying amount recorded | Adds that 5%; the floor is not recorded twice |
| A repeat license or renewal with the same company | New rows in the same ledger, marked as a repeat, not a new ledger | 15% of each qualifying amount when first agreed within 12 months of the first Closing; no second floor |
| A payment to the company is later reduced or reversed | A negative adjustment row tied to the original line | Recalculated on the reduced cumulative payout; the reward falls proportionately |
| A signed Schedule A sets other terms | A note at the top naming the schedule | Use its rate, base and floor |
Reversals are the subtle case. The terms say a reduction of the supplier payout reduces the related reward proportionately, while a buyer refund alone does not; the reversal page works through both. The reward is recalculated on the reduced cumulative payout, the greater of $50,000 plus 5% and 15% of what remains, with any excess already paid adjusted. Repeat business is covered in the note on referral fees on repeat business.
Three checks to reconcile the ledger
Run these each time a status changes:
- One line, one payment. Every row maps to a single dated payment SourceX shows for your referral. A row without a matching payment comes out.
- No early lines. No row exists for an installment that has not been paid, even if it is invoiced or due.
- One floor, then 5%. The USD 50,000 element sits on one row only, and every other row records 5% of its qualifying amount, with the running total checked against 15% of the running base.
If a check fails, compare your rows with the statuses on the rewards page and the rewards policy explainer before raising it with SourceX. Keep the ledger and any written answers with your tax records; the IRS generally ties how long records should be kept to the period of limitations, three years in most cases and longer in some.
What the ledger does not decide
A ledger tracks accrual, not payability. A line can sit at Approved for weeks while the remaining conditions clear; the 60-day payment conditions page shows how those conditions line up against the deadline.
Nor does it say whether a company will be accepted. That depends on qualification, 50+ full-time employees at peak (contractors excluded), documented operating history, rights to license and an authorized contact, and on SourceX's review of the records themselves. Companies in the U.S., Canada and the EU qualify, as do companies in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia when at least 70% of the data is in English. Partners confirm these at metadata level and never collect the company's records or payment documents.
Next step
Refer a company. No cap on rewards. Default reward on a company's first qualifying transaction: the greater of $50,000 plus 5% and 15% of Actual Supplier Payout, with no cap; further qualifying transactions first agreed within 12 months of the first Closing pay 15%. Eligibility and payment conditions apply, including the USD 100,000 Minimum Transaction, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.
If you are ready to track an introduction line by line, register as a partner, check the company against who qualifies and keep the program terms version beside your ledger.
What should a partner finance manager know about supplier installment referral rewards?
Three rules cover most installment questions. An installment's reward is an estimate, based on proposed compensation, until SourceX actually pays that installment to the company. Every installment of one transaction runs on the same payment clock, so an installment paid after day 60 is paid promptly once its conditions are met, without a new 60-day period. And a partial delivery gets a clock of its own only if SourceX and the partner expressly agree to that in writing.
The ledger above records lines as installments are paid. It does not show the schedule a finance manager is asked about before then: what each future installment is worth today, when each line can turn into cash, and what happens to the plan when an installment moves, shrinks or never arrives.
Section 4 of the program terms, Version 2026-10-22.2, since replaced by version 2026-11-04, sets the base in one sentence: "Before supplier payment, any reward shown is an estimate based on proposed supplier compensation; where supplier compensation is paid in installments, the reward accrues proportionately as each installment is paid." Paragraph 5.4 of Schedule A in the unsigned sample Channel Partner Agreement, which the terms link to, adds the timing: each installment's share becomes payable as that installment is paid, subject to the other payment conditions, with the USD 50,000 element on the first installment that meets every condition and the 5% element proportionately, and supplier compensation paid after the deadline does not start a fresh sixty days.
Installments or a partial handoff: which clock applies?
The structure of the company's deal decides how many clocks you track. Most installment schedules belong to one transaction with one deadline.
| Question | Installments of one transaction | A partial handoff agreed in writing |
|---|---|---|
| What is delivered | The complete, validated dataset | Separately selectable fixed-price lots, each delivered and accepted on its own |
| What sets day 0 | Whichever is later: final written acceptance by the Acquisition Partner of the complete dataset, or completed handoff | The same two events, applied to each lot |
| How many 60-day clocks | One for the whole transaction | One for each agreed lot |
| An installment paid after day 60 | Paid promptly once conditions are met; the clock does not restart | The same rule, inside that lot's clock |
| What must be in writing | Nothing beyond the company's own agreement | The lot in the company's signed documents, and an express written agreement between SourceX and the partner |
| USD 50,000 floor | Once per company, on the first installment that meets every condition | Still once per company, with no double counting across lots |
One more line in the terms stops a common mix-up. Section 8 says a supplier's payment timetable, including any Net 60 clause, never determines when referral rewards are paid. Read beside section 4, the company's timetable decides only when an installment's line stops being an estimate; the anchor dates and the section 5 conditions decide when that line can be paid.
The installment-by-installment reward schedule
Illustrative and fictional. A 270-person commercial roofing contractor licenses eleven years of inspection reports and warranty claims. Its proposed compensation is $480,000, paid in four installments of $120,000. Day 0 is the later of two dates, the day handoff is completed and the day the complete, validated dataset is given final written acceptance by the Acquisition Partner, so day 60 is the deadline for the whole transaction.
| Installment | Paid to the company on | Worth before it is paid | Counted once paid | Running total | When it can become payable |
|---|---|---|---|---|---|
| 1 | Day 20 | Estimate of $56,000, the floor plus 5% | $56,000 | $56,000 | By day 60, if every other condition is met |
| 2 | Day 50 | Estimate of $6,000 | $6,000 | $62,000 | By day 60, on the same conditions |
| 3 | Day 140 | Estimate of $6,000 | $6,000 | $68,000 | Promptly once paid and the other conditions are met; day 60 does not restart |
| 4 | Day 230 | Estimate of $6,000 | $6,000 | $74,000 | Promptly once paid and the other conditions are met |
On day 60 the honest summary is $62,000 accrued and, if Acquisition Partner funds have cleared, finance has approved and your details are on file, payable; plus $12,000 of estimates. It is not four equal lines, even though the installments are the same size, because the USD 50,000 element is counted once per company, on the first installment that meets every condition, and the three later lines add 5% each. The 15% test changes nothing here: 15% of $480,000 is $72,000, below $74,000.
Four variations on the same schedule. Each changes one fact and names the term that decides the result.
| Variation | What changes | Partner total at the end | Governing term |
|---|---|---|---|
| A. Delayed | Installment 3 slips from day 140 to day 300 | $74,000, with line 3 paid later | Schedule A 5.4: no new sixty-day period; paid promptly once conditions are met |
| B. Zero for the last line | The company's agreement is amended and installment 4 is never paid | $68,000 | Section 4: unpaid supplier amounts are not Actual Supplier Payout |
| C. Smaller second installment | Installment 2 is paid at $80,000 under an amendment | $72,000, with line 2 counting $4,000 instead of $6,000 | Section 4: the 5% element follows what is actually paid |
| D. Reversal after payment | $40,000 of installment 2 is reversed after all four are paid | $72,000, after a $2,000 adjustment | Section 6, applied to the reduced cumulative payout of $440,000 |
Variation D depends on timing. Had the same $40,000 reversal arrived on day 150, after the third installment but before the fourth, the running base would have fallen from $360,000 to $320,000 and the running total from $68,000 to $66,000. The reversal examples separate this from a buyer refund that leaves the company's payout untouched.
The partial handoff version. Suppose the inspection reports and the warranty claims had been set up as two separately selectable lots in the company's signed documents, and SourceX and the partner had agreed in writing to treat each delivery as its own qualifying handoff. Each lot would then carry its own day 0 and its own deadline, but the USD 50,000 floor would still be counted once for the company, with the 5% element on every lot and nothing counted twice. Without that written agreement, an early delivery of one lot has no deadline of its own; the clock waits for the complete dataset.
When the installment plan changes, rebuild the schedule
Four habits keep the schedule honest when installments move:
- Replace, never adjust. When an installment is paid, its counted line replaces the estimate, whatever the estimate said.
- Recompute the 5% element after every change. A smaller, later or cancelled installment changes what its line adds, as variation C shows.
- Size the open estimates. Their total is 5% of the unpaid installments, plus the floor if no installment has yet met every condition, or whatever a signed Schedule A provides.
- Keep the clock evidence. File the two anchor dates and, for a partial handoff, the written agreement with the schedule. When your figures and SourceX's status differ, ask SourceX: Schedule A 8 says it keeps supplier payout calculations and payment status, and will explain a partner's own reward on request.
The portal statuses run from Estimated to Paid, and estimated vs payable commission annotates each one. How open conditions line up against day 60 is set out in the 60-day payment conditions guide, and single-payment cases are in the reward calculation scenarios and the payout calculation examples.
Refer a company. No cap on rewards. Default reward on a company's first qualifying transaction: the greater of $50,000 plus 5% and 15% of Actual Supplier Payout, with no cap; further qualifying transactions first agreed within 12 months of the first Closing pay 15%. Eligibility and payment conditions apply, including the USD 100,000 Minimum Transaction, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.
If a company you know is negotiating staged payments, register as a partner, confirm it against who qualifies and keep the program terms version beside your schedule so each line can be checked against the clause that governs it.