Sample data
Customer file order · Hallmark Facilities

SO-52128

Sent to Xero
Customer file HMF-34183.csv from Hallmark Facilities’ own system on Mon 26 Oct at 11:00, read and mapped to the Contract Master in 8 s. For Mon 2 Nov by DPD next day. Owner Hannah Price. Hallmark Facilities, corporate and services, price band B, 4 contract lines.
Website
Portal
Customer file
HMF-34183.csv, mapped in 8 s
Phone or email
Net, ex VAT
£53.85
£71.76 inc VAT, with charges
Margin
42.1%
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
Goods, ex VAT£53.85
Delivery, DPD next day£5.95 ex VAT
Net, ex VAT£59.80
VAT at 20%£11.96
Total£71.76
Under £100 ex VAT, so £5.95 DPD delivery is added to the invoice that goes to Xero.
Margin 42.1% 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 £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-34183
26 Oct 11:00
HMF-34183.csv1 file, 1 row
ABCD
1CODECOLOURSIZESQTY
2HMF620NAVNAVYM:1 L:1 XL:13
How it was mapped
  1. HMF620NAV x M 1, L 1, XL 13 x TRA620-NAV
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
AddressSolihull B91
Signed forJ. Dixon at 10:07, DPD photo
DPD Next DayDPD
1550 0002 0334 65
Hallmark Facilities
FAO Fiona Rhodes
Solihull, B91
Weight1.1 kg, 3 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-42522in Xeronot due yet
Dated2 Nov 2026
Due31 Dec 2026 (30 days end of month)
Delivery, DPD£5.95 ex VAT
Total£71.76
Sent to Xero at 18:00 on 2 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-34183.csv received
Customer · 26 Oct 11:00
Read in 8 s: 1 of 1 line matched to Contract Master lines with sizes
Auto · 26 Oct 11:01
Priced at Hallmark Facilities’ own rates: 1 from the Contract Master
Auto · 26 Oct 11:01
Stock checked by size: every line available or due in next day
Auto · 26 Oct 11:01
Credit checked: within the £5,750 limit
Auto · 26 Oct 11:01
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · 26 Oct 11:01
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 Fiona
DPD · 30 Oct 16:30
Delivered by DPD, signed for by J. Dixon. Photo proof from DPD
DPD · 2 Nov 10:07
Invoice INV-42522 sent to Xero from the delivered quantities. Nothing re-typed
Auto · 2 Nov 18:00