Material Billing: material costs from your dailies

3 min read

What is this?

Material Billing adds up the materials your crews report on their dailies. See the quantity, the unit cost and the total cost by project, phase, vendor, material and day. Check a vendor invoice or a job cost without a spreadsheet.

Material Billing with quantity, unit cost, cost and days by project

Who's this for?

  • Project managers, to see what materials a job used and what they cost.
  • Accounting, to check material invoices against what the field reported.
  • Operations managers, to compare material use across projects and phases.

How to use it

Step 1: Open Material Billing

In the menu, open Reports > Material Billing.

Material Billing under Reports in the menu

Step 2: Pick the period and the grouping

Click the date button and pick Day, Week, Month, Year or Custom. Then click Data Structure, check the levels you want and drag them into order.

Data Structure with Project, Material, Unit, Phase, Vendor and Day

Unit is always on. You can move it, but not remove it, so tons and loads never add up together.

Step 3: Narrow it down

Click Filters to pick projects, vendors or materials. Type in Search to find a name fast.

Filters with Project, Vendor and Material, and the vendor list open

Step 4: Add more columns

Click the Table Settings icon at the top right. Turn on Daily Lines or Lines Without Cost, then click Save.

Table Settings with Daily Lines and Lines Without Cost

Step 5: Download

Click the download icon and pick CSV or Excel. The file has one line for each project, phase, vendor, material, unit and day, with every column.

The download icon at the top right of Material Billing

The full details

  • Where the numbers come from: the material lines on your dailies.
  • Cost: the line's total cost. When a line has no total, Clue uses quantity times unit cost.
  • Unit Cost: the cost divided by the quantity of the lines that have a cost.
  • Quantity: shows when all rows in a group share one unit.
  • Days: the days with material lines.
  • Included Dailies: pick which daily statuses count. By default every daily counts except deleted ones.
  • Costs: people who can see daily costs see the cost columns. Others see quantities only.
  • Projects: you see the projects your role lets you see.
  • Turn it on: a company admin can turn Material Billing on or off in Company Settings > Permissions > Reports.

Tips

  • Put Vendor first, then Material and Day, to check an invoice line by line.
  • Turn on Lines Without Cost to find lines your crews entered without a price.
  • Ask your foremen to pick the same unit for the same material. "EA" and "each" show as two units.

See it live

Get a Demo

Available on

Download on the App StoreGet it on Google Play