Customer file order · Kingsway Academy
SO-52246
Sent to XeroCustomer file KAT-69801.csv from Kingsway Academy Trust’s own system on Thu 29 Oct at 09:18, read and mapped to the Contract Master in 3 s. For Thu 5 Nov by DPD next day. Owner Hannah Price. Kingsway Academy Trust, education, price band B, 3 contract lines.
Website
Portal
Customer file
KAT-69801.csv, mapped in 3 s
Phone or email
Net, ex VAT
£34.75
£48.84 inc VAT, with charges
Margin
32.4%
GP floor 26% a line
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%
| Product | Qty | Price | Source | Margin | Line |
|---|---|---|---|---|---|
UC101 Uneek Classic Polo, Royal KAT101ROY · plain UC101-ROY · Sizes XS to 4XL · Contract Master | 5 | £6.95 | Contract Master | 32.4% ✓ | £34.75 |
SizeXSSMLXL2XL3XL4XLTotal Ordered011210005 Blanks free1528545331440189 On hand1659118125712240415 DecorationKAT101ROY: left chest embroidery (KINGSWAY ACADEMY) | |||||
Goods, ex VAT£34.75
Delivery, DPD next day£5.95 ex VAT
Net, ex VAT£40.70
VAT at 20%£8.14
Total£48.84
Under £100 ex VAT, so £5.95 DPD delivery is added to the invoice that goes to Xero.
Margin 32.4% 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 £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 retypingFromPurchasing, Kingsway Academy Trust
Toinfo@cwear.co.uk
SubjectOrder file KAT-69801
29 Oct 09:18
KAT-69801.csv1 file, 1 row
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CODE | COLOUR | SIZES | QTY |
| 2 | KAT101ROY | ROYAL | S:1 M:1 L:2 XL:1 | 5 |
How it was mapped
- KAT101ROY x S 1, M 1, L 2, XL 15 x UC101-ROY
Read and mapped in 3 s: their codes to Contract Master lines, their rows into size grids.
Delivery
DPD
DPD Next Day
Collected 16:30 Wed 4 Nov
DeliveryThu 5 Nov, Kingsway Academy
AddressWolverhampton WV1
Signed forC. Spencer at 11:19, DPD photo
DPD Next DayDPD
1550 0002 0378 31
Kingsway Academy, Kingsway Academy Trust
FAO Claire Spencer
Wolverhampton, WV1
Weight1.7 kg, 5 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-42624in Xeronot due yet
Dated5 Nov 2026
Due31 Dec 2026 (30 days end of month)
Delivery, DPD£5.95 ex VAT
Total£48.84
Sent to Xero at 18:00 on 5 Nov from the delivered quantities. Nothing re-typed; Xero is the ledger.
Customer
KAKingsway Academy Trust
C-1009 · Education · 3 sites · since 2017
PricesBand B, 10% off list, 3 contract lines
Terms30 days end of month
Credit£11,485 of £17,250, £6,093 overdue
Orders byCustomer file
Short stockpart-ship and back-order
RepHannah Price
Other orders from Kingsway Academy Trust
SO-52576
Today · Kingsway Primary
£144.05
Confirmed
SO-52568
Today · Kingsway Academy
£76.45
Confirmed
SO-52559
Today · Kingsway Academy
£168.30
Confirmed
SO-52477
Thu 5 Nov · Kingsway Academy
£131.10
In production
SO-52364
Tue 3 Nov · Kingsway Academy
£146.25
Picking
Audit trail
Customer file KAT-69801.csv received
Customer · 29 Oct 09:18
Read in 3 s: 1 of 1 line matched to Contract Master lines with sizes
Auto · 29 Oct 09:19
Priced at Kingsway Academy Trust’s own rates: 1 from the Contract Master
Auto · 29 Oct 09:19
Stock checked by size: every line available or due in next day
Auto · 29 Oct 09:19
Credit checked: within the £17,250 limit
Auto · 29 Oct 09:19
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · 29 Oct 09:19
Production lots done on the tablet; booked back in and the pick slip released
Dev · Tue 3 Nov 15:20
Picked and packed, checked by size against the pick slip
Tom · Wed 4 Nov 14:10
Collected by DPD at 16:30; DPD label and tracking emailed to Claire
DPD · Wed 4 Nov 16:30
Delivered by DPD, signed for by C. Spencer. Photo proof from DPD
DPD · Thu 5 Nov 11:19
Invoice INV-42624 sent to Xero from the delivered quantities. Nothing re-typed
Auto · Thu 5 Nov 18:00