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.
Agreements8customers MSC pays
Accrued to date£16,169this agreement year
Full year forecast£44,057straight-lined from the year to date
Lines the rebate rescues0under 12% on invoice cost, over it on true net
Customer rebate agreementsWhat MSC owes out once the customer's spend lands in a band
| Agreement | Rate ladder | Spend | Rebate | Year elapsed | Earning now |
|---|---|---|---|---|---|
| Pilgrim Bay Holiday ParksRBC-3104 · Spend band | Top band reached4 bands in the ladder | £139,461£380,004 forecast | £4,881.15£13,300.14 full year | 37% | 3.5% |
| CleanCo ResaleRBC-3100 · Spend band | Top band reached4 bands in the ladder | £117,282£319,570 forecast | £4,104.87£11,184.93 full year | 37% | 3.5% |
| Ludgate Row RestaurantsRBC-3107 · Spend band | Top band reached4 bands in the ladder | £73,437£200,101 forecast | £2,570.30£7,003.54 full year | 37% | 3.5% |
| Selby Court ResidencesRBC-3105 · Spend band | Top band reached4 bands in the ladder | £68,789£187,435 forecast | £2,407.60£6,560.22 full year | 37% | 3.5% |
| Thornfield HotelsRBC-3103 · Spend band | 3.5% at £120,0004 bands in the ladder | £38,559£105,065 forecast | £963.97£2,626.63 full year | 37% | 2.5% |
| Larchmont Retail GroupRBC-3102 · Spend band | 3.5% at £120,0004 bands in the ladder | £30,618£83,427 forecast | £765.45£2,085.68 full year | 37% | 2.5% |
| Anchorline FerriesRBC-3106 · Spend band | 2.5% at £60,0004 bands in the ladder | £21,633£58,945 forecast | £324.49£884.18 full year | 37% | 1.5% |
| Northgate LeisureRBC-3101 · Spend band | 2.5% at £60,0004 bands in the ladder | £10,084£27,478 forecast | £151.26£412.16 full year | 37% | 1.5% |
Pilgrim Bay Holiday ParksRBC-3104 · Spend band3.5%
Rate ladderTop band reached4 bands in the ladderSpend£139,461£380,004 forecastRebate£4,881.15£13,300.14 full yearYear elapsed37%
CleanCo ResaleRBC-3100 · Spend band3.5%
Rate ladderTop band reached4 bands in the ladderSpend£117,282£319,570 forecastRebate£4,104.87£11,184.93 full yearYear elapsed37%
Ludgate Row RestaurantsRBC-3107 · Spend band3.5%
Rate ladderTop band reached4 bands in the ladderSpend£73,437£200,101 forecastRebate£2,570.30£7,003.54 full yearYear elapsed37%
Selby Court ResidencesRBC-3105 · Spend band3.5%
Rate ladderTop band reached4 bands in the ladderSpend£68,789£187,435 forecastRebate£2,407.60£6,560.22 full yearYear elapsed37%
Thornfield HotelsRBC-3103 · Spend band2.5%
Rate ladder3.5% at £120,0004 bands in the ladderSpend£38,559£105,065 forecastRebate£963.97£2,626.63 full yearYear elapsed37%
Larchmont Retail GroupRBC-3102 · Spend band2.5%
Rate ladder3.5% at £120,0004 bands in the ladderSpend£30,618£83,427 forecastRebate£765.45£2,085.68 full yearYear elapsed37%
Anchorline FerriesRBC-3106 · Spend band1.5%
Rate ladder2.5% at £60,0004 bands in the ladderSpend£21,633£58,945 forecastRebate£324.49£884.18 full yearYear elapsed37%
Northgate LeisureRBC-3101 · Spend band1.5%
Rate ladder2.5% at £60,0004 bands in the ladderSpend£10,084£27,478 forecastRebate£151.26£412.16 full yearYear elapsed37%
8 of 8 agreements, £16,169 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.