Managing the materials list

Updated on

Do you always work with the same range, such as brushes, primers and tape? Then put it in the materials list. Your staff choose from it on the job sheet and the timesheet, the price lands on the line automatically, and if you want, the app keeps track of your stock. Only admins can manage the list.

Step 1: Open the materials list

Go to Job sheets and click Materials list at the top. Do you only use time tracking, without job sheets? Then the button is on your Timesheet.

Step 2: Fill the list

  • One by one: click Materials, fill in the description, category, unit, sales price and optionally the purchase price, and click Save.
  • From Excel: click Import and choose an Excel or CSV file with the column names category, name, variant, unit, price, purchase price and stock at the top. Only name is required; other columns are skipped. You first see a preview: how many materials are new and how many will be updated. Only then do you click Import. Download template gives you an example file.

If a name is already in the list, the import updates it. Nothing is ever deleted, and an empty price or stock in your file keeps the existing one. A filled-in stock becomes the new count.

Variants

Does a material come in different versions, such as a brush that can be round, flat or small? Then create one material "Brush", open it and click Variant (the one with the plus). Each variant has its own unit, price and stock. On the job sheet the line is then called, for example, "Brush round".

In an Excel file you put the variant in the variant column: rows with the same name and a variant are grouped under one material.

Tracking stock

Switch on Track stock for a material (or a variant) and fill in how many there are now. From then on:

  • the stock goes down as soon as a staff member puts the material on a job sheet or timesheet;
  • it comes back when someone lowers the quantity or deletes the line;
  • it may go below zero: whoever is on the job can always carry on. The staff member does get a notification.

Has a delivery come in, or have you counted? Open the material and click Add or count. Choose Add (something comes in), Remove (broken or returned, without a job sheet) or Counted (sets the stock to what is actually there). Below that you see the history: who used or booked what, and when.

Quotes and project budgets don't deduct anything: that is what you expect to use, not what was actually used.

On quotes and projects

You also pick from the list on a quote and in a project's materials, with the From materials list button. The name, price and (as an admin) purchase price then go on the line. When a quote is accepted, the link goes along to the project, with the unit from the list. Quotes and projects don't deduct stock. On the project, Budgeted and used shows what was budgeted next to what was actually used (see Materials in a project).

Statistics

At the top of the list is Most used (12 months): the materials with the most revenue, with how often they were used and the margin. When you open a material, you see Use in the last 12 months at the bottom: how often and on how many projects, the total and the average per use, revenue, margin, when it was last used and on which projects most. Everything comes from job sheets and timesheets. The margin only counts lines with a purchase price; lines only carry one from the moment you entered a purchase price in the list.

How your staff choose

On the job sheet and the timesheet, your staff tap the material field. A window opens (full screen on a phone) with the categories and the materials. They pick a material, the variant if it has variants, and fill in the quantity straight away. Every material whose stock you track shows how many are left. Searching works too: they then see the materials from the list that match, and below that what has been used before. If something isn't in the list, they type it and choose Use.

Staff see the stock, but never prices. As an admin you do see the sales and purchase price in the window, and the price is on the job sheet and in the project's weekly overview with With amounts.

Frequently asked questions

  • Does a new price also change old lines? No. The price lands on the line at the moment someone picks the material. Old job sheets and weekly overviews stay correct.
  • I filled in a different price on a job sheet myself. That stays. The list never overwrites a price you set by hand.
  • A material is no longer used. Open it and switch off Available to staff. It then disappears from the choice, but stays in the list. Deleting is also possible; lines it was already on keep their text and price. If you delete a material with variants, the variants go too.
  • Why is the stock below zero? More was used than the list said was there, for example because a delivery hasn't been added yet. Count and choose Counted, and it's right again.
  • My Excel file isn't recognised. Check that there is a name column at the top (or description, article or product). It is required.

Was this helpful?

Related articles