Rebates and true net cost
LiveInternal onlyToday: spreadsheets, reconciled once a year
Tracked in spreadsheets today, reconciled once a year, so nobody quoting a price knows what the line really costs.
Agreements8suppliers paying MSC
Accrued to date£7,755this agreement year
Full year forecast£21,131straight-lined from the year to date
Lines the rebate rescues0under 12% on invoice cost, over it on true net
Supplier rebate agreementsWhat comes back to MSC once the spend lands in a band
| Agreement | Rate ladder | Spend | Rebate | Year elapsed | Earning now |
|---|---|---|---|---|---|
| Rillbeck ImportsRBS-3202 · Flat percentage | One rate, no ladderOne rate for the whole year | £88,464£241,047 forecast | £3,715.49£10,123.95 full year | 37% | 4.2% |
| Cassford MillsRBS-3207 · Flat percentage | One rate, no ladderOne rate for the whole year | £64,499£175,747 forecast | £2,063.98£5,623.92 full year | 37% | 3.2% |
| Stridewell SafetyRBS-3200 · Flat percentage | One rate, no ladderOne rate for the whole year | £39,771£108,368 forecast | £1,073.82£2,925.94 full year | 37% | 2.7% |
| Quenby BrushwareRBS-3203 · Growth over last year | One rate, no ladderOne rate for the whole year | £36,588£99,694 forecast | £512.23£1,395.72 full year | 37% | 1.4% |
| Glenmarl DistributionRBS-3201 · Flat percentage | One rate, no ladderOne rate for the whole year | £5,776£15,740 forecast | £196.40£535.15 full year | 37% | 3.4% |
| Larkfell GroupRBS-3204 · Flat percentage | One rate, no ladderOne rate for the whole year | £8,841£24,089 forecast | £114.93£313.16 full year | 37% | 1.3% |
| Duncroft SanitarywareRBS-3205 · Growth over last year | One rate, no ladderOne rate for the whole year | £2,440£6,649 forecast | £78.09£212.78 full year | 37% | 3.2% |
| Pelham Row TradingRBS-3206 · Growth over last year | One rate, no ladderOne rate for the whole year | None yet£0 forecast | Nothing accrued£0.00 full year | 37% | 4.3% |
Rillbeck ImportsRBS-3202 · Flat percentage4.2%
Rate ladderOne rate, no ladderOne rate for the whole yearSpend£88,464£241,047 forecastRebate£3,715.49£10,123.95 full yearYear elapsed37%
Cassford MillsRBS-3207 · Flat percentage3.2%
Rate ladderOne rate, no ladderOne rate for the whole yearSpend£64,499£175,747 forecastRebate£2,063.98£5,623.92 full yearYear elapsed37%
Stridewell SafetyRBS-3200 · Flat percentage2.7%
Rate ladderOne rate, no ladderOne rate for the whole yearSpend£39,771£108,368 forecastRebate£1,073.82£2,925.94 full yearYear elapsed37%
Quenby BrushwareRBS-3203 · Growth over last year1.4%
Rate ladderOne rate, no ladderOne rate for the whole yearSpend£36,588£99,694 forecastRebate£512.23£1,395.72 full yearYear elapsed37%
Glenmarl DistributionRBS-3201 · Flat percentage3.4%
Rate ladderOne rate, no ladderOne rate for the whole yearSpend£5,776£15,740 forecastRebate£196.40£535.15 full yearYear elapsed37%
Larkfell GroupRBS-3204 · Flat percentage1.3%
Rate ladderOne rate, no ladderOne rate for the whole yearSpend£8,841£24,089 forecastRebate£114.93£313.16 full yearYear elapsed37%
Duncroft SanitarywareRBS-3205 · Growth over last year3.2%
Rate ladderOne rate, no ladderOne rate for the whole yearSpend£2,440£6,649 forecastRebate£78.09£212.78 full yearYear elapsed37%
Pelham Row TradingRBS-3206 · Growth over last year4.3%
Rate ladderOne rate, no ladderOne rate for the whole yearSpendNone yet£0 forecastRebateNothing accrued£0.00 full yearYear elapsed37%
8 of 8 agreements, £7,755 accrued so far. A band only pays from the spend it starts at, so the forecast is straight-lined from the year to date and moves as the year runs. Each agreement carries its own settlement terms, which is where the credit note is raised and how it reaches Xero.
True net costWhat the line really costs once the supplier rebate comes backNo line rescued yet
| Product | Invoice cost | Rebate | True net cost | Margin on invoice | Margin on true net |
|---|---|---|---|---|---|
| Kestralon 5 Litre Floor StripperCHM-1088 · Rillbeck Imports | £4.62 | 4.2% | £4.43 | 18.1% | 21.5% |
| Rillbeck 5 Litre Washroom CleanerCHM-1077 · Rillbeck Imports | £20.57 | 4.2% | £19.71 | 24.8% | 27.9% |
| Thornlea 5 Litre Glass CleanerCHM-1082 · Rillbeck Imports | £37.61 | 4.2% | £36.03 | 26.3% | 29.4% |
| Thornlea 750ml Heavy Duty DegreaserCHM-1098 · Rillbeck Imports | £30.76 | 4.2% | £29.47 | 27.5% | 30.5% |
| Stridewell 5 Litre Carpet ShampooCHM-1081 · Rillbeck Imports | £2.63 | 4.2% | £2.52 | 29.5% | 32.4% |
| Quenby Heavy Duty Mop HandleJAN-1002 · Cassford Mills | £6.75 | 3.2% | £6.53 | 19.3% | 21.9% |
| Stridewell 750ml Odour NeutraliserCHM-1100 · Rillbeck Imports | £1.85 | 4.2% | £1.77 | 39.9% | 42.5% |
| Ashvale 5 Litre Thickened BleachCHM-1079 · Rillbeck Imports | £2.83 | 4.2% | £2.71 | 39.8% | 42.3% |
| Rillbeck 5 Litre Sanitiser ConcentrateCHM-1090 · Rillbeck Imports | £16.00 | 4.2% | £15.33 | 39.8% | 42.3% |
| Corvelle Plain Work ShirtWWR-1148 · Duncroft Sanitaryware | £37.95 | 3.2% | £36.74 | 21.4% | 23.9% |
| Ashvale Heavy Duty Long Handled DustpanJAN-1014 · Cassford Mills | £23.65 | 3.2% | £22.89 | 22.1% | 24.6% |
| Nordlin Heavy Duty Refuse Sack RollJAN-1011 · Cassford Mills | £6.88 | 3.2% | £6.66 | 22.6% | 25.1% |
| Kestralon Colour Coded Kentucky Mop HeadJAN-1023 · Cassford Mills | £15.83 | 3.2% | £15.32 | 23.5% | 26.0% |
| Glenmarl Colour Coded Deck ScrubberJAN-1044 · Cassford Mills | £2.56 | 3.2% | £2.48 | 22.0% | 24.4% |
| Purevex Colour Coded Flat Mop KitJAN-1025 · Cassford Mills | £15.32 | 3.2% | £14.83 | 24.1% | 26.5% |
| Stridewell Colour Coded Hand Scrubbing PadJAN-1043 · Cassford Mills | £23.03 | 3.2% | £22.29 | 26.4% | 28.8% |
| Stridewell Colour Coded Long Handled DustpanJAN-1036 · Cassford Mills | £6.78 | 3.2% | £6.56 | 30.4% | 32.6% |
| Glenmarl Heavy Duty Scrubbing BrushJAN-1013 · Cassford Mills | £11.12 | 3.2% | £10.76 | 31.3% | 33.5% |
| Thornlea Colour Coded Mop HandleJAN-1024 · Cassford Mills | £30.19 | 3.2% | £29.22 | 31.1% | 33.3% |
| Glenmarl Heavy Duty Sweeping BrushJAN-1007 · Cassford Mills | £21.26 | 3.2% | £20.58 | 35.1% | 37.2% |
Kestralon 5 Litre Floor StripperCHM-1088 · Rillbeck Imports21.5%
Invoice cost£4.62Rebate4.2%True net cost£4.43Margin on invoice18.1%
Rillbeck 5 Litre Washroom CleanerCHM-1077 · Rillbeck Imports27.9%
Invoice cost£20.57Rebate4.2%True net cost£19.71Margin on invoice24.8%
Thornlea 5 Litre Glass CleanerCHM-1082 · Rillbeck Imports29.4%
Invoice cost£37.61Rebate4.2%True net cost£36.03Margin on invoice26.3%
Thornlea 750ml Heavy Duty DegreaserCHM-1098 · Rillbeck Imports30.5%
Invoice cost£30.76Rebate4.2%True net cost£29.47Margin on invoice27.5%
Stridewell 5 Litre Carpet ShampooCHM-1081 · Rillbeck Imports32.4%
Invoice cost£2.63Rebate4.2%True net cost£2.52Margin on invoice29.5%
Quenby Heavy Duty Mop HandleJAN-1002 · Cassford Mills21.9%
Invoice cost£6.75Rebate3.2%True net cost£6.53Margin on invoice19.3%
Stridewell 750ml Odour NeutraliserCHM-1100 · Rillbeck Imports42.5%
Invoice cost£1.85Rebate4.2%True net cost£1.77Margin on invoice39.9%
Ashvale 5 Litre Thickened BleachCHM-1079 · Rillbeck Imports42.3%
Invoice cost£2.83Rebate4.2%True net cost£2.71Margin on invoice39.8%
Rillbeck 5 Litre Sanitiser ConcentrateCHM-1090 · Rillbeck Imports42.3%
Invoice cost£16.00Rebate4.2%True net cost£15.33Margin on invoice39.8%
Corvelle Plain Work ShirtWWR-1148 · Duncroft Sanitaryware23.9%
Invoice cost£37.95Rebate3.2%True net cost£36.74Margin on invoice21.4%
Ashvale Heavy Duty Long Handled DustpanJAN-1014 · Cassford Mills24.6%
Invoice cost£23.65Rebate3.2%True net cost£22.89Margin on invoice22.1%
Nordlin Heavy Duty Refuse Sack RollJAN-1011 · Cassford Mills25.1%
Invoice cost£6.88Rebate3.2%True net cost£6.66Margin on invoice22.6%
Kestralon Colour Coded Kentucky Mop HeadJAN-1023 · Cassford Mills26.0%
Invoice cost£15.83Rebate3.2%True net cost£15.32Margin on invoice23.5%
Glenmarl Colour Coded Deck ScrubberJAN-1044 · Cassford Mills24.4%
Invoice cost£2.56Rebate3.2%True net cost£2.48Margin on invoice22.0%
Purevex Colour Coded Flat Mop KitJAN-1025 · Cassford Mills26.5%
Invoice cost£15.32Rebate3.2%True net cost£14.83Margin on invoice24.1%
Stridewell Colour Coded Hand Scrubbing PadJAN-1043 · Cassford Mills28.8%
Invoice cost£23.03Rebate3.2%True net cost£22.29Margin on invoice26.4%
Stridewell Colour Coded Long Handled DustpanJAN-1036 · Cassford Mills32.6%
Invoice cost£6.78Rebate3.2%True net cost£6.56Margin on invoice30.4%
Glenmarl Heavy Duty Scrubbing BrushJAN-1013 · Cassford Mills33.5%
Invoice cost£11.12Rebate3.2%True net cost£10.76Margin on invoice31.3%
Thornlea Colour Coded Mop HandleJAN-1024 · Cassford Mills33.3%
Invoice cost£30.19Rebate3.2%True net cost£29.22Margin on invoice31.1%
Glenmarl Heavy Duty Sweeping BrushJAN-1007 · Cassford Mills37.2%
Invoice cost£21.26Rebate3.2%True net cost£20.58Margin on invoice35.1%
The twenty lines where the invoice cost hides the most margin, of 40 rebated lines. This is the number the quote builder’s margin floor should be argued against. A line at 10% on invoice cost that earns 4.5% back is not a below-floor line, and a business that cannot see that either walks away from work it wants or discounts work it should not.