Skip to main content

πŸ—οΈ Cost WIP Report

Updated over 2 weeks ago

Overview

The Cost WIP Report provides insight into your job-level cost performance, based on how much has been quoted, billed, receipted, and earned. It helps project managers, finance teams, and operations leads understand whether jobs are under or over budget, and where money has been spent relative to progress.

πŸ”Ž Note: This report is filterable only by department.


Key Fields in the Report

  • Job Number / Description – The job ID and summary of the work.

  • Total Unit Price (Quoted Cost) – The original estimated cost for the job.

  • Percentage Complete – A manually updated field showing job progress.

  • Earnt Value – How much value has been earned based on completion %.

  • Bills to Date / Receipts – Shows actual spend and received goods/services.

  • Difference – The variance between spend and quoted value.

  • WIP (Earnt Value) – The current value of work in progress.

  • Invoiced to Date – How much has already been billed to the client.


How to Use This Report

  1. Access the Report

    • Go to Reports > Cost WIP Report.

    • Select the Department you wish to filter by.

  2. Review Financial Progress

    • Check jobs with high Bills to Date but low % Complete β€” these may need review.

    • Focus on negative Difference values for potential overspending.

  3. Support Invoicing Decisions

    • Use WIP and Invoiced to Date columns to determine what can be billed or needs adjustment.

  4. Monitor Project Profitability

    • Compare Quoted Cost, Actual Spend, and Invoiced to ensure job financials are tracking correctly.


Ideal For

  • Project managers reviewing live job costs

  • Finance teams reconciling spend vs quote

  • Department heads managing budget performance

  • Monthly WIP meetings and financial audits

Did this answer your question?