Free tool

A building materials purchase order: each line with its unit and delivery site.

A building materials order puts cement bought by the bag, steel by the ton and sand by the cubic metre on one sheet, and it may be split across several sites. So this template adds two columns: the unit, so a quantity in tons is never added to one in bags, and the delivery site for each line. It has sample rows for common materials with no brands, and the prices are blank for you to fill with what you agreed with the supplier.

Download

Plain files with no macros; they work in Excel, Google Sheets and LibreOffice.

Common questions

Why does a building materials order need a unit column?

Because one order mixes tons, bags, cubic metres and pieces, and their quantities cannot be added or multiplied by a price in a different unit. With the unit on every line, the unit cost and total match what you agreed. In Dashing you define the base unit and larger ones with a factor, and fractional quantities such as 2.5 tons can be sold.

How do I use the delivery site if I have more than one site?

Write the site name on each line, so one order can be spread over several sites and the supplier and the truck driver know where each item goes. Sort the sheet by this column if you want everything for one site together. The field lives on the sheet only.

How do I check what arrived against what I ordered?

After each delivery compare the quantity that arrived with the line's quantity, and note the gap in the margin or in a copy of the sheet. In Dashing a purchase order can be received in part, and what you owe the supplier is booked for what arrived.

Dashing does this for every item, automatically, in your shop.