Two weeks of trading · 26 Oct to 9 Nov

Reports

481 orders and £69,145 ex VAT over 11 working days. 82% arrived without anyone typing them, margin held at 38.4%, 7 stock-outs were stopped by a delivery that landed in time, and 2 production lots are late. Today counts to 10:42.

Orders per working day, by how they arrived

Hover or tap a day for the figures; tap it again to open that day's orders.

PortalCustomer fileEmailWebsitePhone

M26T27W28T29F30M2T3W4T5F6M9

Where the orders came from

481 orders, 26 Oct to 9 Nov

Portal109 · 23%

Placed by the customer · 191 lines · last today 10:36

Customer file55 · 11%

Read from the customer file, never typed · 179 lines · last today 10:36

Email141 · 29%

Read from the email, never typed · 232 lines · last today 10:41

Website84 · 17%

Arrived from Shopify, never typed · 140 lines · last today 10:38

Phone86 · 18%

Keyed once, during the call · 157 lines · last today 10:22

Re-typing avoided, 26 Oct to 9 Nov

The old way, on Visual 2000 (which also held the accounts), the biggest customer's CSV was typed in by hand. Here an order is read once and the invoice is posted from the delivered quantities.

751order lines nobody typed394 orders read or placed on the portal; the 157 phone lines were keyed once, on the call 392invoices sent to Xero, not re-keyed£57,932 ex VAT, over the last 10 nights at 18:00 48 hof desk time handed back285 orders read and 10 invoice runs, at an assumed 8 min an order and 60 min an invoice run (your real times to confirm)

Day by day

The figures behind the chart. Tap a day to open its orders. Export writes this table.

Day	Phone	Website	Email	Customer file	Portal	Orders	Lines	Nobody typed	Value	Margin
Todayto 10:42	5	6	13	10	7	41	76	85%	£5,920.80	36.9%
Fri 6 Nov	8	3	15	2	13	43	73	81%	£5,732.75	37.6%
Thu 5 Nov	7	8	8	7	11	41	93	83%	£7,154.25	39.2%
Wed 4 Nov	9	5	17	4	6	43	75	79%	£6,376.50	37.4%
Tue 3 Nov	8	7	15	5	9	45	87	82%	£7,042.65	37.6%
Mon 2 Nov	10	4	14	4	9	41	69	76%	£5,480.05	37.8%
Fri 30 Oct	9	5	15	4	7	41	78	78%	£6,140.75	40.0%
Thu 29 Oct	8	7	14	6	8	43	85	81%	£6,403.30	38.7%
Wed 28 Oct	6	7	14	3	11	41	76	85%	£5,496.80	38.0%
Tue 27 Oct	5	9	8	4	16	42	78	88%	£5,621.35	38.9%
Mon 26 Oct	11	7	8	6	8	40	82	73%	£6,661.70	39.4%
Two weeks	86	84	141	55	109	481	911	82%	£69,144.50	38.4%

Margin on every account, by price band

Each dot is one account's margin on its orders, 26 Oct to 9 Nov. The line on each band is its average. Tap a dot to open the account.

30 of 31 accounts plotted, Wingers priced from its Contract Master

Band A15% off list · 2 accounts39.4% on £25,323

Band B10% off list · 13 accounts37.9% on £29,517

Band C5% off list · 10 accounts39.2% on £9,509

List priceno discount · 5 accounts38.0% on £3,261

Lowest band average: Band B at 37.9%; highest: Band A at 39.4%. No account averages under the 26% GP floor.

Margin by how each line was priced

Every line is priced at that account's own rate as it lands.

Priced at	Lines	Sales	Margin
Band price (A, B, C or list)	144	£3,575	37.2%
Contract price	765	£65,569	38.4%
Waiting for a person	2	priced once confirmed
All lines, 26 Oct to 9 Nov	911	£69,145

Stopped by the margin floor

Lines that carried an old price under the 26% GP floor. £29.15 kept.

Price lists →

Kingsway Academy Trust SO-52559

GD057 Gildan Heavy Blend Hoodie, Sport Grey: 12 at £9.20 on the order, under the £10.55 floor price (26% GP at £7.80 cost). Priced at £10.55

+£16.20

Mon 9 Nov 09:12

Greenacre Care Homes SO-52384

GD057 Gildan Heavy Blend Hoodie, Navy: 5 at £9.40 on the order, under the £10.55 floor price (26% GP at £7.80 cost). Priced at £10.55

+£5.75

Tue 3 Nov 10:29

Brookline Construction SO-52285

GD057 Gildan Heavy Blend Hoodie, Black: 6 at £9.20 on the order, under the £9.76 floor price (26% GP at £7.22 cost). Priced at £10.40

+£7.20

Fri 30 Oct 10:10

Every account, biggest first

Sales and margin on orders placed 26 Oct to 9 Nov. Export writes the accounts you can see.

Account	Band	Orders	Sales	Gross profit	Margin	Contract lines
Sterling Guard Security Security · London	Band A	36	£19,964.35	£7,803.45	39.1%	5
Brookline Construction Construction and trades · Coventry	Band B	36	£7,566.15	£2,573.03	34.0%	4
Harbourline Hospitality Group Hospitality · London	Band A	60	£5,358.75	£2,169.70	40.5%	11
Redline Hospitality Hospitality · Manchester	Band B	27	£3,243.55	£1,337.35	41.2%	4
Oakmere Security Security · Birmingham	Band B	20	£3,208.20	£1,252.65	39.0%	4
FitHub Gyms Events and leisure · Liverpool	Band B	18	£2,574.60	£1,125.30	43.7%	3
Sentinel Door Supervisors Security · Newcastle upon Tyne	Band C	10	£2,211.15	£928.65	42.0%	3
Brightside Cleaning Services Corporate and services · Nottingham	Band B	16	£2,203.85	£896.45	40.7%	3
Summit Events Events and leisure · Birmingham	Band B	20	£2,074.20	£834.15	40.2%	2
Riverside Leisure Centre Events and leisure · Bristol	Band B	12	£1,739.45	£745.00	42.8%	3
Greenacre Care Homes Healthcare and care · Derby	Band B	11	£1,683.00	£491.40	29.2%	3
Vantage Logistics Corporate and services · Tamworth	Band B	19	£1,565.55	£564.05	36.0%	2
Pinnacle Roofing Construction and trades · Cardiff	Band C	10	£1,562.40	£654.70	41.9%	3
Wingers	Contract Master	15	£1,534.55	£400.39	26.1%	28
Elmstead Primary School Education · Solihull	Band C	12	£1,448.10	£613.65	42.4%	3
Ironbridge Electrical Construction and trades · Dudley	Band B	10	£1,325.05	£504.65	38.1%	3
Castlegate Lettings Corporate and services · Leeds	Band C	9	£1,162.05	£413.85	35.6%	4
Swift Plumbing and Heating Construction and trades · Bristol	Band C	12	£1,110.35	£429.45	38.7%	2
Bloom Florists Corporate and services · Redditch	List price	17	£954.75	£352.33	36.9%	none
Kingsway Academy Trust Education · Wolverhampton	Band B	7	£934.65	£326.10	34.9%	3
Hallmark Facilities Corporate and services · Solihull	Band B	8	£865.75	£307.55	35.5%	4
Hartley Joinery Construction and trades · Swindon	List price	20	£679.60	£261.80	38.5%	none
Ashford Dental Care Healthcare and care · Reading	Band C	8	£677.40	£212.10	31.3%	2
Cobalt Coffee Hospitality · Cambridge	List price	20	£677.10	£261.60	38.6%	none
Westbrook College Education · Leicester	Band B	5	£532.65	£226.15	42.5%	2
Little Oaks Nursery Education · Norwich	List price	15	£505.90	£189.10	37.4%	none
Halo Hair and Beauty Spa and wellbeing · Sutton Coldfield	Band C	6	£492.90	£216.20	43.9%	2
Mercer and Hale Solicitors Corporate and services · London	Band C	5	£487.15	£140.35	28.8%	3
Paws Grooming Studio Corporate and services · Exeter	List price	12	£443.40	£174.60	39.4%	none
The Copper Pan Restaurant Hospitality · Edinburgh	Band C	4	£206.50	£71.10	34.4%	2
Apex Scaffolding Construction and trades · Walsall	Band C	1	£151.45	£44.15	29.2%	4

When the shelf would have run dry, without the delivery

Each dot is a line that would have hit zero at that day's 16:30 DPD collection if its purchase order had not landed first. Tap one for the detail.

Raised by the reorder rule (4)Raised by Vinay (3)

M26T27W28T29F30M2T3W4T5F6M9

Stock-outs avoided, 26 Oct to 9 Nov

times a line would have run out before its next delivery, across 3 lines and 420 garments delivered. The reorder point is sales during the supplier's lead time plus a week, so the order goes in before the shelf is bare.

4from POs the reorder rule drafted 3from POs Vinay raised

Worked out from each line's stock ledger: the lowest the shelf got after the delivery, against the garments it brought.

Next to run out

Under the reorder point now, with stock on order counted

Stock →

UC101 Uneek Classic Polo, Black

128 available covers 5 days; Uneek takes 1 day to deliver

GD057 Gildan Heavy Blend Hoodie, Black

17 available covers 2 days; Midlands Garment Distributor takes 1 day to deliver. On draft PO-3333

GD057 Gildan Heavy Blend Hoodie, Navy

25 available covers 3 days; Midlands Garment Distributor takes 1 day to deliver. On draft PO-3333

SS6 Fruit of the Loom Polo, White

66 available covers 3 days; Midlands Garment Distributor takes 1 day to deliver. On draft PO-3333

TRA620 Regatta Fleece, Navy

17 available covers 2 days; Northern Workwear Wholesale takes 1 day to deliver

UC127 Uneek Polo, Black

3 available covers 21 days; Uneek takes 1 day to deliver

Not avoided: navy UC101 polos

More were ordered than the shelf held. Lead time next day, on PO-3330. Nothing was oversold: each short line followed its account's own rule.

Short →

UC101 Uneek Classic Polo, Navy

234 on the shelf, all kept. 193 back-ordered: 187 on part-shipped orders, 6 waiting for a call

PO-3330

160 due Tue 10 Nov

Every stock-out avoided

Latest first. Tap a row to open the line and its stock history. Export writes this table.

Line	Delivered	Would have run out	Days to spare	First order short
TRA620 Regatta Fleece, Navy Northern Workwear Wholesale	PO-3310 Wed 28 Oct, 30 garments, reorder rule	Thu 5 Nov 16:30 collection	8	SO-52265 Brightside Cleaning Services
TRA620 Regatta Fleece, Navy Northern Workwear Wholesale	PO-3315 Fri 30 Oct, 30 garments, reorder rule	Thu 5 Nov 16:30 collection	6	SO-52265 Brightside Cleaning Services
TRA620 Regatta Fleece, Navy Northern Workwear Wholesale	PO-3321 Wed 4 Nov, 30 garments, Vinay	Thu 5 Nov 16:30 collection	1	SO-52265 Brightside Cleaning Services
UC101 Uneek Classic Polo, Navy Uneek	PO-3312 Wed 28 Oct, 120 garments, Vinay	Thu 5 Nov 16:30 collection	8	SO-52450 Little Oaks Nursery
UC101 Uneek Classic Polo, Navy Uneek	PO-3320 Wed 4 Nov, 120 garments, reorder rule	Thu 5 Nov 16:30 collection	1	SO-52450 Little Oaks Nursery
UC301 Uneek Classic T-shirt, Navy Uneek	PO-3320 Wed 4 Nov, 40 garments, reorder rule	Thu 5 Nov 16:30 collection	1	SO-52449 Cobalt Coffee
UC301 Uneek Classic T-shirt, Navy Uneek	PO-3312 Wed 28 Oct, 50 garments, Vinay	Tue 3 Nov 16:30 collection	6	SO-52196 Kingsway Academy Trust

What customers owe, by age

Posted invoices not yet paid, as Xero holds them. £183,959 in all across 25 accounts.

Invoicing →

Not due yet£157,912.23 · 85.8%

1 to 30 days overdue£22,900.59 · 12.4%

31 to 60 days£2,479.88 · 1.3%

61 to 90 days£665.93 · 0.4%

Over 90 days£0.00 · 0.0%

£26,046 overdue on 4 accounts1 on stop, 2 over their limit0 reminders, statements and calls this week

Cash in, week by week

£182,607 paid by 30 accounts, matched to invoices

w/c 26 Oct£120,248

110 payments from 30 accounts

w/c 2 Nov£58,149

103 payments from 30 accounts

w/c 9 Nov (to 10:42 today)£4,210

1 payments from 1 accounts

Held for credit now

Redline Hospitality SO-52557Over limit, £153 Apex Scaffolding SO-52563On stop, £182

Accounts that owe money

Most overdue first. Tap an account to open it. Export writes the accounts you can see.

Account	Balance	Overdue	Oldest	Limit	Status
Redline Hospitality 30 days end of month · Manchester	£14,031.72	£7,406.19	9 days	£16,500	Over limit
Brookline Construction 30 days end of month · Coventry	£22,107.57	£6,727.31	9 days	£85,250	Overdue
Kingsway Academy Trust 30 days end of month · Wolverhampton	£10,685.29	£6,092.66	9 days	£17,250	Overdue
Apex Scaffolding 14 days · Walsall	£5,820.24	£5,820.24	70 days	£1,500	On stop
Sterling Guard Security 30 days end of month · London	£68,191.57	£0.00	not due	£125,750	Up to date
Harbourline Hospitality Group 30 days end of month · London	£7,819.33	£0.00	not due	£32,000	Up to date
Oakmere Security 30 days end of month · Birmingham	£6,507.41	£0.00	not due	£18,500	Up to date
Greenacre Care Homes 30 days end of month · Derby	£5,854.72	£0.00	not due	£29,000	Up to date
Brightside Cleaning Services 30 days end of month · Nottingham	£4,354.09	£0.00	not due	£20,500	Up to date
Riverside Leisure Centre 30 days end of month · Bristol	£4,341.35	£0.00	not due	£10,250	Up to date
FitHub Gyms 30 days end of month · Liverpool	£4,247.12	£0.00	not due	£16,500	Up to date
Summit Events 30 days end of month · Birmingham	£3,530.05	£0.00	not due	£9,750	Up to date
Vantage Logistics 30 days end of month · Tamworth	£3,523.84	£0.00	not due	£14,500	Up to date
Ironbridge Electrical 30 days end of month · Dudley	£3,435.02	£0.00	not due	£8,000	Up to date
Pinnacle Roofing 30 days end of month · Cardiff	£3,417.78	£0.00	not due	£20,250	Up to date
Hallmark Facilities 30 days end of month · Solihull	£3,047.13	£0.00	not due	£5,750	Up to date
Elmstead Primary School 30 days end of month · Solihull	£2,886.52	£0.00	not due	£8,000	Up to date
Castlegate Lettings 30 days end of month · Leeds	£2,769.19	£0.00	not due	£9,500	Up to date
Westbrook College 30 days end of month · Leicester	£1,900.60	£0.00	not due	£3,000	Up to date
Ashford Dental Care 30 days end of month · Reading	£1,330.18	£0.00	not due	£6,750	Up to date
Sentinel Door Supervisors 14 days · Newcastle upon Tyne	£1,329.60	£0.00	not due	£6,250	Up to date
Mercer and Hale Solicitors 30 days end of month · London	£1,091.30	£0.00	not due	£2,500	Up to date
The Copper Pan Restaurant 30 days end of month · Edinburgh	£955.81	£0.00	not due	£2,500	Up to date
Swift Plumbing and Heating 14 days · Bristol	£545.10	£0.00	not due	£2,500	Up to date
Halo Hair and Beauty 14 days · Sutton Coldfield	£236.10	£0.00	not due	£1,000	Up to date