Understanding the Project Financial Tab in MeasureSquare CRM

Understanding the Project Financial Tab in MeasureSquare CRM

In this article, we will cover the new Financial Tab on a CRM project, including how to enable it and how each figure on the dashboard is calculated.

To enable the Financial Tab:

  1. Go to Settings
  2. Select Preferences, then Project
  3. Check the box next to Financial
  4. Click Save




Understanding the Financial tab

The Financial tab gives a real-time snapshot of a project's revenue, cost, and profit. Below is what each section reflects:





Summary cards
  • Revenue – Pre-tax total of all approved Proposals (Quote/Bid) and Change Orders on the project

  • Estimated Cost – Cost total of the same approved Proposals and Change Orders

  • Estimated Profit – Revenue minus Estimated Cost

  • Margin – Estimated Profit divided by Revenue, shown as a percentage

Income Progress

  • Income – Post-tax total of approved Proposals and Change Orders

  • Invoiced – Total of approved but unpaid invoices

  • Paid – Total of paid invoices

Cost Progress

  • Estimated – Same value as Estimated Cost above

  • Committed – Total of approved Purchase Orders and Work Orders. This can show over 100% of Estimated Cost, since it's pulled from a different source than the original bid

  • Billed – Total of approved Bills

Cost Breakdown

  • Splits the Estimated Cost total into Material, Labor, and Other, based on all approved Proposals and Change Orders

Invoices

  • Splits the Invoiced total into Paid, Open, and Overdue

Bills

  • Splits the Billed total into Paid, Open, and Overdue

Estimated vs. Actual Cost

  • Compares Estimated cost (approved Proposals + Change Orders) against Actual cost (approved Purchase Orders for material and Work Orders for labor), broken out by Material, Labor, and Other


InfoIt's normal for Committed to show over 100% of Estimated Cost. Committed reads from approved POs/WOs, a separate data source from the original bid, so the two won't always match exactly.


For any further questions, please reach out to our Support team 

Monday - Friday from 7:30am-4:30pm PST: (626) 683-9188 ext. 3
All Hours: support@measuresquare.com