Customer file order · Sterling Guard Manchester
SO-52130
Sent to XeroCustomer file SGS-82672.csv from Sterling Guard Security’s own system on Mon 26 Oct at 11:27, read and mapped to the Contract Master in 8 s. For Mon 2 Nov by DPD next day. Owner Hannah Price. Sterling Guard Security, security, price band A, 5 contract lines.
Website
Portal
Customer file
SGS-82672.csv, mapped in 8 s
Phone or email
Net, ex VAT
£679.45
£815.34 inc VAT
Margin
38.9%
GP floor 26% a line
Lines at Sterling Guard Security’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 |
|---|---|---|---|---|---|
TRA620 Regatta Fleece, Black SGS620BLK · plain TRA620-BLK · Sizes S to 3XL · Contract Master | 11 | £17.95 | Contract Master | 42.1% ✓ | £197.45 |
SizeSMLXL2XL3XLTotal Ordered23321011 Blanks free133026171289 On hand35717543132239 DecorationSGS620BLK: left chest embroidery (STERLING GUARD) Blanks TRA620-BLK on PO-3331, lands Tue 10 Nov | |||||
UC101 Uneek Classic Polo, Black SGS101BLK · plain UC101-BLK · Sizes XS to 4XL · Contract Master | 11 | £9.95 | Contract Master | 30.2% ✓ | £109.45 |
SizeXSSMLXL2XL3XL4XLTotal Ordered0233210011 Blanks free1619353217540128 On hand1968136145822540479 DecorationSGS101BLK: left chest embroidery (STERLING GUARD), back print (SECURITY) Blanks UC101-BLK on PO-3330, lands Tue 10 Nov | |||||
R331 Result Softshell Jacket, Black SGS331BLK · plain R331-BLK · Sizes S to 3XL · Contract Master | 10 | £25.95 | Contract Master | 37.4% ✓ | £259.50 |
SizeSMLXL2XL3XLTotal Ordered13321010 Blanks free1202442561463810814 On hand16132034019459101084 DecorationSGS331BLK: left chest embroidery (STERLING GUARD), back print (SECURITY) | |||||
PWVEST Portwest Hi-vis Vest, Yellow SGSPWVESTYLW · plain PWVEST-YLW · Sizes S/M to 4XL/5XL · Contract Master | 12 | £5.95 | Contract Master | 43.7% ✓ | £71.40 |
SizeS/ML/XL2XL/3XL4XL/5XLTotal Ordered443112 Blanks free7485016175 On hand174198239413 DecorationSGSPWVESTYLW: back print (SECURITY) Blanks PWVEST-YLW on PO-3331, lands Tue 10 Nov | |||||
B45 Beechfield Beanie, Black SGS45BLK · plain B45-BLK · One size · Contract Master | 7 | £5.95 | Contract Master | 47.9% ✓ | £41.65 |
SizeOne sizeTotal Ordered77 Blanks free330330 On hand562562 DecorationSGS45BLK: front embroidery (STERLING GUARD) | |||||
Goods, ex VAT£679.45
Delivery, DPD next dayFree
Net, ex VAT£679.45
VAT at 20%£135.89
Total£815.34
Free delivery over £100 ex VAT.
Margin 38.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
5 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 £125,750 limit.
As it arrived
CSV from the customer’s own ordering app or buying system; their codes mapped to Contract Master lines, no retypingFromPurchasing, Sterling Guard Security
Toinfo@cwear.co.uk
SubjectOrder file SGS-82672
26 Oct 11:27
SGS-82672.csv1 file, 5 rows
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CODE | COLOUR | SIZES | QTY |
| 2 | SGS620BLK | BLACK | S:2 M:3 L:3 XL:2 2XL:1 | 11 |
| 3 | SGS101BLK | BLACK | S:2 M:3 L:3 XL:2 2XL:1 | 11 |
| 4 | SGS331BLK | BLACK | S:1 M:3 L:3 XL:2 2XL:1 | 10 |
| 5 | SGSPWVESTYLW | YELLOW | S/M:4 L/XL:4 2XL/3XL:3 4XL/5XL:1 | 12 |
| 6 | SGS45BLK | BLACK | One size:7 | 7 |
How it was mapped
- SGS620BLK x S 2, M 3, L 3, XL 2, 2XL 111 x TRA620-BLK
- SGS101BLK x S 2, M 3, L 3, XL 2, 2XL 111 x UC101-BLK
- SGS331BLK x S 1, M 3, L 3, XL 2, 2XL 110 x R331-BLK
- SGSPWVESTYLW x S/M 4, L/XL 4, 2XL/3XL 3, 4XL/5XL 112 x PWVEST-YLW
- SGS45BLK x One size 77 x B45-BLK
Read and mapped in 8 s: their codes to Contract Master lines, their rows into size grids.
Delivery
DPD
DPD Next Day
Collected 16:30 Fri 30 Oct
DeliveryMon 2 Nov, Sterling Guard Manchester
AddressManchester M1
Signed forS. Hunt at 09:06, DPD photo
DPD Next DayDPD
1550 0002 0329 10
Sterling Guard Manchester, Sterling Guard Security
FAO Marcus Hale
Manchester, M1
Weight15.5 kg, 51 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-42499in Xeronot due yet
Dated2 Nov 2026
Due31 Dec 2026 (30 days end of month)
Total£815.34
Sent to Xero at 18:00 on 2 Nov from the delivered quantities. Nothing re-typed; Xero is the ledger.
Customer
SGSterling Guard Security
C-1005 · Security · 4 sites · since 2015
PricesBand A, 15% off list, 5 contract lines
Terms30 days end of month
Credit£79,301 of £125,750
Orders byCustomer file
Short stockpart-ship and back-order
RepHannah Price
Other orders from Sterling Guard Security
SO-52580
Today · Sterling Guard London
£431.85
Confirmed
SO-52572
Today · Sterling Guard Manchester
£601.70
Confirmed
SO-52554
Today · Sterling Guard Birmingham
£212.45
Confirmed
SO-52549
Today · Sterling Guard London
£480.35
Confirmed
SO-52481
Thu 5 Nov · Sterling Guard London
£546.30
In production
Audit trail
Customer file SGS-82672.csv received
Customer · 26 Oct 11:27
Read in 8 s: 5 of 5 lines matched to Contract Master lines with sizes
Auto · 26 Oct 11:28
Priced at Sterling Guard Security’s own rates: 5 from the Contract Master
Auto · 26 Oct 11:28
Stock checked by size: every line available or due in next day
Auto · 26 Oct 11:28
Credit checked: within the £125,750 limit
Auto · 26 Oct 11:28
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · 26 Oct 11:28
Production lots done on the tablet; booked back in and the pick slip released
Dev · 29 Oct 15:20
Picked and packed, checked by size against the pick slip
Tom · 30 Oct 14:10
Collected by DPD at 16:30; DPD label and tracking emailed to Marcus
DPD · 30 Oct 16:30
Delivered by DPD, signed for by S. Hunt. Photo proof from DPD
DPD · 2 Nov 09:06
Invoice INV-42499 sent to Xero from the delivered quantities. Nothing re-typed
Auto · 2 Nov 18:00