What is on order, what is short, and what ships today

Your order book, turned into a run sheet the warehouse can actually work from.

Synced fromOrder Book.xlsx25 rows · 4 minutes ago

Ask BrightsheetOptional add-on. Answers below are calculated live from the rows in this sheet.

Open orders

Open order value

$91,000

Lines awaiting stock

4Click to see these rows

Products below 100 on hand

Order book value

$188,251

Units on order

3,918

Top customers by value

Ironbark Steel$37,995

Arndell Building Supplies$20,300

Prestons Trade Centre$15,790

Northwest Electrical$15,295

Marsden Park Supplies$13,300

Metal Fabrication Co$12,320

Deliveries by suburb

Prestons2

Smithfield2

Blacktown2

Wetherill Park2

Silverwater2

Penrith2

Warehouse board

SO-8805

Halstead Fasteners

SO-8809

Ironbark Steel

SO-8812

Girraween Engineering

SO-8820

Penrith Plumbing Co

SO-8801

Prestons Trade Centre

SO-8804

Metal Fabrication Co

SO-8808

Ingleburn Plumbing Co

SO-8813

Moorebank Steel

SO-8816

Northwest Electrical

+2 more

SO-8802

Smithfield Plumbing Co

SO-8806

Penrith Trade Centre

SO-8810

Villawood Pipe & Valve

SO-8814

Seven Hills Plumbing

SO-8817

Halstead Fasteners

+2 more

SO-8803

Blacktown Pipe & Valve

SO-8807

Northwest Electrical

SO-8811

Arndell Building Supplies

SO-8815

Erskine Trade Centre

SO-8818

Prestons Trade Centre

+2 more

Top products by value

RHS 75x75x3$54,320

Galvanised purlin C15019$46,935

TPS cable 2.5mm 100m$22,610

Treated pine 90x45$16,080

PVC pressure pipe 100mm$13,426

Brass ball valve 20mm$12,610

Copper tube 15mm$12,150

M12 galv bolt pack$10,120

Order flow

Awaiting stock25100%

Picking-42184%

Dispatched-71456%

Delivered-7728%

Order value over time

Latest$61,145Peak$61,145Total$188,251Points11 by day

Delivery run sheet

Grouped by suburb in the real product


SO-8801	120	$8,940
SO-8802	300	$4,110
SO-8803	450	$6,075
SO-8804	88	$12,320
SO-8805	1500	$3,450
SO-8806	640	$7,680
SO-8807	40	$5,320
SO-8808	220	$2,860
SO-8809	200	$14,900
SO-8810	180	$2,466
SO-8811	145	$20,300
SO-8812	900	$2,070

Showing 12 of 25 rows