# Small practice referral dashboard by route | SourceX

Canonical: https://refer.sourcex.si/guides/a-referral-dashboard-for-a-small-advisory-practice
Last updated: 2026-11-04

A small advisory practice needs one sheet with one row per company it introduced, a route column saying how each introduction was recorded, and a status column that copies SourceX's own words from the partner dashboard: Estimated, Eligible, Approved, Processing or Paid. The board counts rows. It never adds up estimates or forecasts reward income, and it holds no client records. The only money it shows is a reward that reads Paid and has actually arrived.

This is for the partner or office manager at a two-to-fifteen-person accounting, consulting or advisory firm that introduces a few client companies a year and wants a view it can update in ten minutes a month. A firm that needs a full referral system should start from [the referral CRM schema](/guides/the-referral-crm-should-track-companies-permissions-and-next-steps); this board can sit on top of it.

## What one row may say about a client company

One row is one company your firm introduced to SourceX with its CEO's agreement. Nine columns are enough, and each value has a named source, so nobody types a guess into a cell.

| Column | What it holds | Where the value comes from |
|---|---|---|
| 1. Company | The legal name of the operating company, not a brand or the wider group | The CEO, or the company's public registration |
| 2. Route | One of four codes for how the introduction was recorded | Your sent email, portal submission or written confirmation |
| 3. Introduced | The date on that written record | The record itself, never a date reconstructed later |
| 4. Owner | The one person at your firm who holds the CEO relationship | Your firm |
| 5. CEO's yes | The date the CEO agreed and where that email is filed | The CEO's own words |
| 6. Portal word | Not shown, Estimated, Eligible, Approved, Processing, Paid or Other label | Your partner dashboard |
| 7. Read on | The date column 6 was read, plus the exact label when it says Other label | Whoever read it |
| 8. Next step | What happens next, who holds it and by when | Whoever holds it |
| 9. Received | Amount and date of a reward that has arrived | SourceX's payment statement, Paid rows only |

Column 5 names the CEO on purpose. Under the program, the company's CEO agrees to a licensing discussion; a finance director or operations head who likes the idea gives you a reason to ask the CEO, not a yes.

Some things never enter the sheet: exports, samples, screenshots or logins; record counts, payroll numbers or revenue taken from the client's books; engagement work papers; estimate amounts; and any guess at value. The unsigned sample of the Channel Partner Agreement gives a partner no authority to share a supplier's records, raw data or personal information (section 4.2), and it bars partners from collecting or keeping copies of a supplier's dataset through the program without separate written authorization (section 4.4). An advisory firm has a second reason: client files live in the engagement system, and a referral sheet that borrows from them becomes a copy nobody meant to make. Screening for fit happens before a row exists, against [who qualifies](/who-qualifies) or the [company fit checker](/tools/company-fit-checker).

## Four introduction routes, named for the record behind each

The route column answers one question: if anyone later asks how this introduction happened, which written record shows it? The sample agreement lists the forms an introduction record can take, among them a submission through the authenticated portal, a verified application, an email or an introduction log both sides acknowledge, and it says an oral introduction must be confirmed in writing before the agreement's protection attaches (section 1.2). Those forms give a small firm four routes.

| Code | Route | The record that shows it | What to watch on the board |
|---|---|---|---|
| P | Portal submission from your partner dashboard | The submission and its date | A row stuck at Not shown deserves one look |
| L | Partner link sent to the CEO, company applied itself | Your email carrying the link, then the company's application | A sent link becomes a row only after the CEO agreed; clicks are never counted |
| E | Email introduction | The message with the CEO and SourceX on one thread | Keep the original message, not a forward |
| S | Spoken first, then confirmed in writing | The written confirmation and its date | A spoken row with no confirmation is the firm's own gap |

Route never decides credit: under section 2 of the terms, SourceX decides it from dated records, and an earlier link click alone decides nothing. The route column maps your firm's own evidence, and the board shows which habit leaks: links that never become applications, or conversations nobody wrote down.

## The small-team operating dashboard

Two tabs and three numbers. The intake tab holds the rows, and the board tab counts them.

**Intake tab.** Columns 1 to 9 above. Put a dropdown on column 6 so only the portal's words fit in it. In Google Sheets, a dropdown can be added from Data, then Data validation, with the allowed values typed in, and the rule's advanced options decide whether an entry outside the list is rejected (Google's help page, paraphrased). Set it to reject. Allowed values: Not shown, Estimated, Eligible, Approved, Processing, Paid and Other label.

**Board tab.** A pivot table with Route as rows, Portal word as columns and a count of Company as the only value. Google's help says each source column needs a header, and that a pivot table takes fields under Rows, Columns and Values and can show totals (paraphrase). Nothing on the board is summed except column 9.

| Header number | How it is computed | Why it earns the space |
|---|---|---|
| Introductions recorded this year | Rows whose Introduced date falls in the year | The firm's own activity, measured in companies |
| Rows not read this month | Rows whose Read on date is older than the 1st | A stale board misleads more than no board |
| Rewards received this year | The sum of column 9 | Money that has arrived, and nothing else |

The board refuses five things a template usually offers: an estimated total, a pipeline value, expected rewards by quarter, a conversion rate, and any amount beside a row that is not Paid. The terms give the reason. Before SourceX pays the company, a reward shown in the portal is an estimate based on proposed compensation (section 4), and section 5 says estimates shown in the portal or calculator are "projections, not promises". The sample agreement adds that a partner must not tell a referred company that an indicative estimate, positive interest, a signature or a data upload makes a purchase or a reward certain (section 4.6, paraphrased). A number the firm cannot spend has no place in a column it adds up.

## Reading the portal's five words without turning them into money

SourceX's pages use five reward-status words. Its how-it-works page lists four as what the partner dashboard shows, and the rewards page adds Processing. Copy each word as displayed, with the date, and treat it as SourceX's statement rather than your own.

| Portal word | What SourceX's pages say it means (paraphrase) | What the sheet does | What the sheet never does |
|---|---|---|---|
| Estimated | An indication while the opportunity is still moving | Counts the row | Copies the estimate, totals it or calls it owed |
| Eligible | The reward can go forward to approval and payment once SourceX has paid the company and the terms' conditions are met | Confirms your tax and payment details are complete | Treats it as approved |
| Approved | SourceX finance has approved the reward | Waits for the payout | Books it as cash |
| Processing | A payout is underway after tax and payment details are in | Watches for the payment statement | Enters an amount |
| Paid | The payout is recorded as completed; the dashboard shows Paid only after an actual payout | Enters amount and date in column 9 from the statement | Treats it as final, because a later cut to the company's payout recalculates the reward |

Two values sit outside those five. Not shown is your firm's own word for a company the portal does not list yet, usually a partner-link row where nobody has applied. Other label covers anything else the dashboard displays, such as a duplicate review note: type it exactly into column 7 and leave its meaning to SourceX.

Clients ask one money question often enough to answer it on the sheet's cover note. Your firm's reward does not come out of their payout. Section 4 of the terms says the reward is "paid separately by SourceX and is never deducted from the supplier's agreed compensation", and SourceX pays it from its own share, so a company receives the same amount whether or not a partner introduced it.

## A nine-introduction year at a six-person practice (Illustrative)

Illustrative. A generic six-person advisory practice, invented companies and dates; no outcome is implied beyond what each cell says. The board as read on 3 November 2026:

| Route | Not shown | Estimated | Eligible | Approved | Processing | Paid | Total |
|---|---|---|---|---|---|---|---|
| P, portal submission | 0 | 2 | 0 | 1 | 0 | 0 | 3 |
| L, partner link | 1 | 1 | 0 | 0 | 0 | 1 | 3 |
| E, email introduction | 0 | 1 | 1 | 0 | 0 | 0 | 2 |
| S, spoken first | 1 | 0 | 0 | 0 | 0 | 0 | 1 |
| All routes | 2 | 4 | 1 | 1 | 0 | 1 | 9 |

Header numbers: 9 introductions recorded this year, 2 rows not read since 1 November, USD 55,000 received.

- **The S row is the firm's own problem.** A partner introduced a 140-person distributor's CEO to SourceX over lunch in September and never sent the written confirmation. The owner sends it today, dated today, and nobody back-dates it to the lunch.
- **The L row's Not shown waits on the company.** The CEO took the link in August and said the COO would apply. One question to the CEO, then the row waits; the terms credit an introduction only when the verified application lands inside the 90-day window, whoever chases.
- **Four Estimated rows are four rows.** One partner wanted a forecast tab multiplying each estimate by a hunch. The board shows a count of 4 and no total, so nothing has to be unwound if a company stops.
- **The single Paid row is the only money.** SourceX's statement showed a USD 55,000 reward on a USD 100,000 Actual Supplier Payout, the company's first qualifying transaction, where USD 50,000 plus 5% beats 15%, and column 9 holds that amount with the date it arrived.

## Who updates which column, and three moments that need a partner

| Columns | Who updates them | When | Pass to a partner at the firm when |
|---|---|---|---|
| 1 to 5 | The relationship owner | The day the CEO agrees and the introduction is made | The record is spoken only, or the yes came from someone other than the CEO |
| 6 and 7 | One named operations lead | First working day of each month, from the partner dashboard | A word moves backward, or a label nobody recognizes appears |
| 8 | Whoever holds the step | When the step changes | A step has had no holder for ten working days |
| 9 | Whoever reconciles the bank | When a payment statement arrives | Paid shows and the money has not arrived |

Three moments never stay inside the sheet:

1. **Another partner claims the company.** When several partners know one company, only one introduction can be credited, and SourceX settles overlapping cases in duplicate review. Leave column 3 exactly as written and let SourceX decide.
2. **The company changes hands or CEOs.** Before an acquisition closes, the target's CEO decides for it; after closing, the acquirer's CEO does. Column 5 then needs a fresh, dated yes from whoever decides now. For the reward, a company and its corporate group count as one referred company: the USD 50,000 floor applies once, to its first qualifying transaction, and never again on a repeat.
3. **A question about your own referral.** Only the partner of record, the person or firm that signed the Channel Partner Agreement before submitting, asks SourceX. The sample agreement gives a partner the information reasonably needed to understand its own referral and reward (section 3.4): ask about your row, not the company's deal.

How to raise any of these without a run of reminders is set out in [escalating a referral without repeated messages](/guides/how-to-escalate-a-referral-without-sending-repeated-messages), and a step nobody holds in [the next-step owner register](/guides/when-a-referral-has-no-named-next-step-owner).

## Month-end: reconcile Paid rows against cash, then archive

- **Reconcile.** Every Paid row needs a matching amount in column 9 and in the bank. If SourceX later reduces a reward because the company's payout was cut by a cancellation, refund or chargeback, the reward falls in proportion to the reduced Actual Supplier Payout. Enter SourceX's recalculated figure on a new dated line instead of overwriting the old one.
- **Archive.** Move a row to an Archive tab only once it is closed under [the stalled-versus-closed rules](/guides/the-difference-between-a-stalled-referral-and-a-closed-one). Archiving moves a row and never deletes it: the sample agreement says a dispute must not erase original evidence (section 3.3), and it lets a partner keep records needed for reward accounting or dispute evidence (section 4.4).
- **Refresh the vocabulary.** If SourceX's pages change their status words, change the dropdown the same day and date the change.

## Where a one-sheet board stops being enough

- **It lags SourceX.** Partners follow their referrals through generic stages or reference codes (sample agreement, section 4.6), and a monthly read can trail by weeks. When a decision depends on today's word, read the [partner dashboard](/questions/where-can-a-partner-see-the-current-stage-of-an-introduction); for definitions, the [status glossary](/resources/referral-status-glossary).
- **Nine rows support no rates.** With a handful of introductions a year, a percentage swings on one company. SourceX has not published conversion figures, and the board does not invent any.
- **A sheet is easy to overshare.** Keep it in the firm's own drive, shared only with the people who make introductions; it never goes to a client, another partner or SourceX.
- **Growth outgrows it.** Our rule of thumb: past about thirty open rows or a second office, move the same columns into a CRM.
- **It says nothing about whom to ask next.** [Growing a client advisory practice](/guides/how-to-grow-client-advisory-services) shows how a yearly records-and-systems review can surface a client worth asking; more operating guides sit in the [guides library](/guides).

## 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.

When the board shows a client whose CEO wants the conversation, [register as a partner](/register) so the firm signs the Channel Partner Agreement before it submits, check the company against [who qualifies](/who-qualifies), and keep the version of the [program terms](/terms) your status words come from beside the sheet. Reward basics live on the [rewards page](/rewards).

## Sources

- https://refer.sourcex.si/terms
- https://refer.sourcex.si/rewards
- https://refer.sourcex.si/how-it-works
- https://sourcex.si/documents/partner/SourceX_Channel_Partner_Agreement_Sample.pdf
- https://support.google.com/docs/answer/186103
- https://support.google.com/docs/answer/1272900
