Live from Prospect. Lists split into Allocated and Unallocated. Floor Allocated shows the SO + customer behind committed stock; Unallocated is free to sell, with the supplier and arrival date taken from the purchase order that delivered it. On the Group view, BV cost shows EUR then GBP in brackets (today's rate is shown top-right). Use the Warehouse / Supplier filters to narrow a list — every column still sorts.
View:
Due in by month — free to sell unallocated · at cost · today's FX · all three charts share one scale · click a month to open it in Due in
Due in by month — allocated pre-sold incoming · at cost · today's FX · click a month to open it in Due in
Due in by month — total free + allocated · at cost · today's FX · click a month to open it in Due in
Floor value by company at booked cost
Where the value sits all at cost · cards and rows are clickable
Add columns:
All stock on the floor
A/U
Co
Warehouse
PO
PO date
Barcode
Product
Case
CPP
Arrived
Days
SO
SO date
Customer
Units
Pallets
Cost/u
Sale/u
Margin %
Value (cost)
Sale value
Margin cash
Allocated — committed to sales orders
A/U
Co
Warehouse
PO
PO date
Barcode
Product
Case
CPP
Lang
Sales order
SO date
Customer
Supplier
Days
Due
Units
Order value
✳ AI edit:
Unallocated — free to sell
Tick "Drop" on any line to leave it off the SOH download — the line stays on screen.
A/U
Co
Warehouse
PO
PO date
Barcode
Product
Case
CPP
Lang
Supplier
Arrived
Days
Free units
Sold units
Cost
Sale
Margin
Free value
Notes
BBE
Origin
Drop
Add columns:
All incoming stock
A/U
Co
PO
Supplier
Warehouse
Barcode
Product
Case
CPP
Lang
Customer
PO date
Due in
Free units
Sold units
Units
Cost
Sale
Margin
Value (local)
Allocated — pre-sold incoming
PO
Supplier
Warehouse
Co
Barcode
Product
Case
CPP
Lang
Customer
PO date
Due in
Allocated units
Cost
Sale
Margin
Value (local)
Unallocated — incoming, not yet sold
✳ AI edit:
Offer
Co
PO
Supplier
PO date
Warehouse
Barcode
Product
Case
CPP
Lang
Due in
Free units
Sold units
Cost
Sale
Margin
Stock value
Notes
BBE
Origin
Drop
space = all words · + = either
Open sales orders
Co
Order
Customer
Due
Status
Order value
space = all words · + = either
Sale pricing
UK prices in £, NL in € — these feed the stock report's price columns.
Bulk import sale pricesone per line: barcode price (space, comma or tab between)
Oxbridge Associates Group · prepared for Andrew Dymond, Managing Director ·
Paste your Outlook signature here once — it is saved on this device and added to the bottom of every offer email. Shared with the Offer Builder.
Send now emails the customer straight away via Microsoft online (Excel attached, copy kept in Sent). Save to Outlook Drafts creates the email in your mailbox Drafts — it appears in your Outlook desktop Drafts within a few seconds, ready to review, tweak and send from there.