How to use the Work in Progress (WIP) report in MeasureSquare CRM?
This article will show how you how to use the WIP report in MeasureSquare CRM.
The Work in Progress (WIP) Report provides a real-time view of all active projects and their financial progress. It shows how much work has been completed, earned, and billed compared to project budgets, allowing you to quickly assess job status, profitability, and billing accuracy at a glance.
Step 1: Go to Reports
Step 2: Select Work in Progress Report
Step 3: Analyze your Work in Progress Report (See below for a breakdown of each column field)
Step 4: Export your report to an Excel file if needed
The following fields represent the core financial calculations used in the Work in Progress (WIP) report
- Contract Amount: The total amount the project is contracted for, including any approved change orders.
- Total Estimated Cost: The total expected cost of the project, including materials, labor, and approved change order costs.
- Estimated Profit: The expected profit for the project, calculated as the difference between the contract amount and total estimated cost.
- Cost to Date: The total costs incurred for the project up to the reporting date.
- Cost-Based Completion %: The percentage of the project completed based on costs incurred, calculated as cost to date divided by total estimated cost.
- Total Earned: The amount of revenue recognized to date, based on the project’s percentage of completion.
- Profit to Date: The profit recognized so far, calculated as total earned minus cost to date.
- Total Invoiced: The total amount invoiced to the customer for the project to date.
- Over / Under Billing: Indicates whether the project has been over-billed or under-billed by comparing earned revenue to invoiced amounts.
For any further questions, please reach out to our Support team
Related Articles
CRM User Manual: Billing and Financials, Lesson 3: Financials
Financials The Financials modules in MeasureSquare CRM centralize your project costs, vendor charges, and financial reporting, giving you a complete view of profitability without switching between systems or juggling spreadsheets. These modules ...CRM User Manual: Introduction (Includes Table of Contents)
User Guide & Best Practices Handbook Empowering Flooring Professionals With a Fully Connected Estimating, Project Management, and Operations Platform To follow along with this guide you will need to have your own MeasureSquare CRM account use this ...MeasureSquare CRM Implementation Checklist
A start-to-finish guide for your implementation manager Document File for the Implementation Checklist: CRM Implementation Checklist PHASE 0: Pre-Implementation Planning Complete before any configuration begins. Estimated time: 1–2 weeks. Strategic ...CRM User Manual: Billing & Financials, Lesson 2: Progress Billing
Progress Billing with the Schedule of Values (SoV) The Schedule of Values module is designed to support a specific and highly standardized process: progress billing. In the construction industry, the standard for this process is governed by the ...CRM Implementation Methods
The previous article touched on some high-level concepts and strategies that we recommend your team adheres to vigilantly: keeping everyone on the same page is absolutely critical during implementation. In this article, we will relate some of those ...