Before you start

  • You need Financial Management and View on Job costing sheets. For the cost and margin columns, Can see purchase costs and Can see profit and margin.
  • The Job Costing module is on for your company. It is off by default for Design & Consultation firms. See Switch a module on or off.

Steps

  1. In the sidebar, select Financial › Job Costing. "Job Costing" opens on Projects: "Contract value against material, labour and other cost, for every project."

    Step 1. Job Costing, Projects tab, with the cards, the filters and the sheet.
    Step 1. Job Costing, Projects tab, with the cards, the filters and the sheet.
  2. Read the cards: Contract value, Cost to date, Gross margin, Projects over budget and Blocked stock value. The line below gives the dates and the currency: "As on [date], cost from [date]. Contract value excludes tax. Money in [currency]."

  3. To see only the projects over budget, select Projects over budget. Select it again to clear it.

  4. To narrow the sheet, use Search (project or customer), Status, Customer, Project manager, the dates From and As on, and the tick boxes Over budget only, No awarded quotation and Has estimated figures. Reset filters clears them.

  5. To choose the columns, select Columns. Show all columns brings them all back.

  6. Read each row. Every column is described in Job Costing: columns, figures and badges.

  7. To open one project's job costing, select its row. See Read a project's job costing.

  8. To export, select Export, then Export Excel or Export PDF. The file is named Job-Costing-[date].

Result

You see each project's contract value, quoted and actual material and labour, other expenses, total cost, margin, margin % and cost burn %, coloured by your margin threshold. A row with "Not tracked" has no awarded quotation and no contract value; "est." marks an estimated figure.

If something is different