Customer file order · Kingsway Primary

SO-52196

Sent to Xero

Customer file KAT-63318.csv from Kingsway Academy Trust’s own system on Wed 28 Oct at 08:40, read and mapped to the Contract Master in 8 s. For Wed 4 Nov by DPD next day. Owner Hannah Price. Kingsway Academy Trust, education, price band B, 3 contract lines.

Website

Portal

Customer file

KAT-63318.csv, mapped in 8 s

Phone or email

Net, ex VAT

£233.75

£280.50 inc VAT

Margin

37.6%

GP floor 26% a line

Kingsway Academy Trust

Lines at Kingsway Academy Trust’s own prices

Contract price first, then any promotion, then their band; GP (profit / sell price) flagged when under 26%

Price lists →

Product	Qty	Price	Source	Margin	Line
GD057 Gildan Heavy Blend Hoodie, Navy KAT057NAV · plain GD057-NAV · Sizes S to 3XL · Contract Master	7	£13.95	Contract Master	33.3% ✓	£97.65
SizeSMLXL2XL3XLTotal Ordered1221107 Blanks free210750125 On hand2143452681144 DecorationKAT057NAV: left chest embroidery (KINGSWAY ACADEMY)
UC301 Uneek Classic T-shirt, Navy KAT301NAV · plain UC301-NAV · Sizes XS to 4XL · Contract Master	11	£7.95	Contract Master	45.3% ✓	£87.45
SizeXSSMLXL2XL3XL4XLTotal Ordered0233210011 Blanks free481513921052 On hand417333520610116 DecorationKAT301NAV: front chest print (KINGSWAY ACADEMY) Blanks UC301-NAV on PO-3330, lands Tue 10 Nov
UC101 Uneek Classic Polo, Royal KAT101ROY · plain UC101-ROY · Sizes XS to 4XL · Contract Master	7	£6.95	Contract Master	32.4% ✓	£48.65
SizeXSSMLXL2XL3XL4XLTotal Ordered012211007 Blanks free1528545331440189 On hand1659118125712240415 DecorationKAT101ROY: left chest embroidery (KINGSWAY ACADEMY)

Goods, ex VAT£233.75

Delivery, DPD next dayFree

Net, ex VAT£233.75

VAT at 20%£46.75

Total£280.50

Free delivery over £100 ex VAT.

Margin 37.6% 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

3 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 £17,250 limit.

As it arrived

CSV from the customer’s own ordering app or buying system; their codes mapped to Contract Master lines, no retyping

FromPurchasing, Kingsway Academy Trust

Toinfo@cwear.co.uk

SubjectOrder file KAT-63318

28 Oct 08:40

KAT-63318.csv1 file, 3 rows

	A	B	C	D
1	CODE	COLOUR	SIZES	QTY
2	KAT057NAV	NAVY	S:1 M:2 L:2 XL:1 2XL:1	7
3	KAT301NAV	NAVY	S:2 M:3 L:3 XL:2 2XL:1	11
4	KAT101ROY	ROYAL	S:1 M:2 L:2 XL:1 2XL:1	7

How it was mapped

KAT057NAV x S 1, M 2, L 2, XL 1, 2XL 17 x GD057-NAV
KAT301NAV x S 2, M 3, L 3, XL 2, 2XL 111 x UC301-NAV
KAT101ROY x S 1, M 2, L 2, XL 1, 2XL 17 x UC101-ROY

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 Tue 3 Nov

DeliveryWed 4 Nov, Kingsway Primary

AddressDudley DY1

Signed forC. Spencer at 13:47, DPD photo

DPD Next DayDPD

1550 0002 0359 81

Kingsway Primary, Kingsway Academy Trust

FAO Claire Spencer

Dudley, DY1

Weight7.7 kg, 25 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-42575in Xeronot due yet

Dated4 Nov 2026

Due31 Dec 2026 (30 days end of month)

Total£280.50

Sent to Xero at 18:00 on 4 Nov from the delivered quantities. Nothing re-typed; Xero is the ledger.

Customer

Kingsway Academy Trust

C-1009 · Education · 3 sites · since 2017

PricesBand B, 10% off list, 3 contract lines

Terms30 days end of month