Sample data
Customer file order · Hallmark Facilities

SO-52215

Sent to Xero
Customer file HMF-61543.csv from Hallmark Facilities’ own system on Wed 28 Oct at 12:40, read and mapped to the Contract Master in 6 s. For Wed 4 Nov by DPD next day. Owner Hannah Price. Hallmark Facilities, corporate and services, price band B, 4 contract lines.
Website
Portal
Customer file
HMF-61543.csv, mapped in 6 s
Phone or email
Net, ex VAT
£177.30
£212.76 inc VAT
Margin
36.6%
GP floor 26% a line
Hallmark Facilities
Lines at Hallmark Facilities’ own prices
Contract price first, then any promotion, then their band; GP (profit / sell price) flagged when under 26%
Price lists →
ProductQtyPriceSourceMarginLine
TRA620 Regatta Fleece, Navy
HMF620NAV · plain TRA620-NAV · Sizes S to 3XL · Contract Master
3£17.95Contract Master42.1% ✓£53.85
SizeSMLXL2XL3XLTotal
Ordered0111003
Blanks free45530118
On hand112123134173
DecorationHMF620NAV: left chest embroidery (HALLMARK FACILITIES)
Blanks TRA620-NAV on PO-3331, lands Tue 10 Nov
SS6 Fruit of the Loom Polo, White
HMF6WHT · plain SS6-WHT · Sizes S to 3XL · Contract Master
8£7.95Contract Master38.4% ✓£63.60
SizeSMLXL2XL3XLTotal
Ordered1231108
Blanks free92417112366
On hand5310511264193356
DecorationHMF6WHT: left chest embroidery (HALLMARK FACILITIES)
R331 Result Softshell Jacket, Black
HMF331BLK · plain R331-BLK · Sizes S to 3XL · Contract Master
3£19.95
£20.00
Contract Master29.8% ✓£59.85
SizeSMLXL2XL3XLTotal
Ordered0111003
Blanks free1202442561463810814
On hand16132034019459101084
DecorationHMF331BLK: left chest embroidery (HALLMARK FACILITIES)
Goods, ex VAT£177.30
Delivery, DPD next dayFree
Net, ex VAT£177.30
VAT at 20%£35.46
Total£212.76
Free delivery over £100 ex VAT.
Margin 36.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 £5,750 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, Hallmark Facilities
Toinfo@cwear.co.uk
SubjectOrder file HMF-61543
28 Oct 12:40
HMF-61543.csv1 file, 3 rows
ABCD
1CODECOLOURSIZESQTY
2HMF620NAVNAVYM:1 L:1 XL:13
3HMF6WHTWHITES:1 M:2 L:3 XL:1 2XL:18
4HMF331BLKBLACKM:1 L:1 XL:13
How it was mapped
  1. HMF620NAV x M 1, L 1, XL 13 x TRA620-NAV
  2. HMF6WHT x S 1, M 2, L 3, XL 1, 2XL 18 x SS6-WHT
  3. HMF331BLK x M 1, L 1, XL 13 x R331-BLK
Read and mapped in 6 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
AddressSolihull B91
Signed forF. Rhodes at 10:04, DPD photo
DPD Next DayDPD
1550 0002 0366 84
Hallmark Facilities
FAO Fiona Rhodes
Solihull, B91
Weight4.4 kg, 14 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.
INV-42601in Xeronot due yet
Dated4 Nov 2026
Due31 Dec 2026 (30 days end of month)
Total£212.76
Sent to Xero at 18:00 on 4 Nov from the delivered quantities. Nothing re-typed; Xero is the ledger.
Customer
HF
Hallmark Facilities
C-1021 · Corporate and services · Solihull · since 2021
PricesBand B, 10% off list, 4 contract lines
Terms30 days end of month
Credit£3,809 of £5,750
Orders byCustomer file
Short stockpart-ship and back-order
RepHannah Price
Audit trail
Customer file HMF-61543.csv received
Customer · 28 Oct 12:40
Read in 6 s: 3 of 3 lines matched to Contract Master lines with sizes
Auto · 28 Oct 12:41
Priced at Hallmark Facilities’ own rates: 3 from the Contract Master
Auto · 28 Oct 12:41
Stock checked by size: every line available or due in next day
Auto · 28 Oct 12:41
Credit checked: within the £5,750 limit
Auto · 28 Oct 12:41
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · 28 Oct 12:41
Production lots done on the tablet; booked back in and the pick slip released
Dev · 2 Nov 15:20
Picked and packed, checked by size against the pick slip
Tom · Tue 3 Nov 14:10
Collected by DPD at 16:30; DPD label and tracking emailed to Fiona
DPD · Tue 3 Nov 16:30
Delivered by DPD, signed for by F. Rhodes. Photo proof from DPD
DPD · Wed 4 Nov 10:04
Invoice INV-42601 sent to Xero from the delivered quantities. Nothing re-typed
Auto · Wed 4 Nov 18:00