Customer file order · Westbrook College
SO-52332
DeliveredCustomer file WBC-36081.csv from Westbrook College’s own system on Mon 2 Nov at 09:07, read and mapped to the Contract Master in 6 s. For Mon 9 Nov by DPD next day. Owner Hannah Price. Westbrook College, education, price band B, 2 contract lines.
Website
Portal
Customer file
WBC-36081.csv, mapped in 6 s
Phone or email
Net, ex VAT
£31.80
£45.30 inc VAT, with charges
Margin
40.9%
GP floor 26% a line
Lines at Westbrook College’s own prices
Contract price first, then any promotion, then their band; GP (profit / sell price) flagged when under 26%
| Product | Qty | Price | Source | Margin | Line |
|---|---|---|---|---|---|
UC101 Uneek Classic Polo, Royal WBC101ROY · plain UC101-ROY · Sizes XS to 4XL · Contract Master | 4 | £7.95 | Contract Master | 40.9% ✓ | £31.80 |
SizeXSSMLXL2XL3XL4XLTotal Ordered011110004 Blanks free1528545331440189 On hand1659118125712240415 DecorationWBC101ROY: left chest embroidery (WESTBROOK COLLEGE) | |||||
Goods, ex VAT£31.80
Delivery, DPD next day£5.95 ex VAT
Net, ex VAT£37.75
VAT at 20%£7.55
Total£45.30
Under £100 ex VAT, so £5.95 DPD delivery is added to the invoice that goes to Xero.
Margin 40.9% on the order; no line under the 26% GP floor.
Checked as it landed
price, stock and credit, before anyone touched it£price
Priced at their rate
1 from the Contract Master. Contract Master prices as agreed; plain lines clear the 26% GP floor.
▦stock
Stock kept by size
Every size was available or due in next day, and kept for this order as it was read.
✓credit
Within the limit
Passed when it landed: inside the £3,000 limit.
As it arrived
CSV from the customer’s own ordering app or buying system; their codes mapped to Contract Master lines, no retypingFromPurchasing, Westbrook College
Toinfo@cwear.co.uk
SubjectOrder file WBC-36081
2 Nov 09:07
WBC-36081.csv1 file, 1 row
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CODE | COLOUR | SIZES | QTY |
| 2 | WBC101ROY | ROYAL | S:1 M:1 L:1 XL:1 | 4 |
How it was mapped
- WBC101ROY x S 1, M 1, L 1, XL 14 x UC101-ROY
Read and mapped in 6 s: their codes to Contract Master lines, their rows into size grids.
Delivery
DPD dispatch →DPD
DPD Next Day
Collected 16:30 Fri 6 Nov
DeliveryMon 9 Nov
AddressLeicester LE1
DPD windowwas due about 10:29
Signed forL. Ellis at 10:24, DPD photo
DPD Next DayDPD
1550 0002 0410 13
Westbrook College
FAO Phil Archer
Leicester, LE1
Weight1.4 kg, 4 garments
LabelDelivered
One DPD consignment per delivery address a day: orders for the same address that day go under one label. DPD collects at 16:30 the working day before delivery and sends the proof of delivery back onto the order.
Invoice
Invoicing →INV-42698posts at 18:00
Dated9 Nov 2026
Due31 Dec 2026 (30 days end of month)
Delivery, DPD£5.95 ex VAT
Total£45.30
Made from the signed-for quantities; posts to Xero at 18:00 tonight with the day’s other deliveries.
Customer
WCWestbrook College
C-1008 · Education · Leicester · since 2016
PricesBand B, 10% off list, 2 contract lines
Terms30 days end of month
Credit£2,540 of £3,000
Orders byCustomer file
Short stockpart-ship and back-order
RepHannah Price
Audit trail
Customer file WBC-36081.csv received
Customer · 2 Nov 09:07
Read in 6 s: 1 of 1 line matched to Contract Master lines with sizes
Auto · 2 Nov 09:08
Priced at Westbrook College’s own rates: 1 from the Contract Master
Auto · 2 Nov 09:08
Stock checked by size: every line available or due in next day
Auto · 2 Nov 09:08
Credit checked: within the £3,000 limit
Auto · 2 Nov 09:08
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · 2 Nov 09:08
Production lots done on the tablet; booked back in and the pick slip released
Dev · Thu 5 Nov 15:20
Picked and packed, checked by size against the pick slip
Tom · Fri 6 Nov 14:10
Collected by DPD at 16:30; DPD label and tracking emailed to Phil
DPD · Fri 6 Nov 16:30
Delivered by DPD, signed for by L. Ellis. Photo proof from DPD
DPD · Today 10:24
Invoice INV-42698 ready: goes to Xero at 18:00
Planned · Today 18:00