Tracking Billable and Nonbillable Time for Customer Projects

Share

Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.

Problem

When working on a project for a customer, both billable and nonbillable hours need to be accounted for in order to have a full 360-degree view of the health of a project to aid in analyzing where improvements can be made or where a company is doing well.

Solution

Use Milestones PM+ to create customer projects in Salesforce and customize them with billable/nonbillable hour fields, then use Rollup Helper (free download here) to roll up the total hours.

Summarize billable and non-billable hours logged using Rollup Helper. Note: Milestones PM+ Premium Edition shown.
Summarize billable and non-billable hours logged using Rollup Helper. Note: Milestones PM+ Premium Edition shown.

With Milestones PM+ Premium Edition, users can log time in a convenient time entry grid which automatically relates Time Entries to its Task and submit to Time Entry Approval. With this option, Rollup Helper is not required.

 Milestones PM+ Premium Edition Time Entry Grid.
Milestones PM+ Premium Edition Time Entry Grid.

With Milestones PM+ Free Edition, users can log time directly on each Task and Rollup Helper can be used (free download here) for these hours.

  1. Create custom fields:
    1. Time
      1. Checkbox - Billable?
    2. Project Task
      1. Number Field - Total Billable Hours
      2. Number Field - Total Nonbillable Hours
    3. Project
      1. Number Field - Total Billable Hours
      2. Number Field - Total Nonbillable Hours
    4. *Optionally create fields on Milestone for Total Billable and Nonbillable hours if you would like to see the totals at that level as well. This may be important if you want to also track estimates of work against actuals at a resource group or phase level.
  2. Create Sum rollups from Time (Hours) to Project Task using the Billable checkbox as a filter.
  3. Create Sum rollups from Project Task to Project using the rollup results from the first rollup as the source for this one.

Take advantage of Milestones PM+ reporting capabilities to identify trends for both billable and nonbillable time. For example, here are some reports you may want to create:

  • Utilization Reporting
  • Realization Reporting
  • This Project’s Billable Time
  • This Project Nonbillable Time
  • All Projects - This Week’s - Billable Time

Learn more about reporting on Projects in Salesforce in the Milestones PM+ Admin Guide.

Need help?
Schedule Demo

Event Planning with Salesforce Project Management for Marketing Cloud Milestones PM+ Use Case Library New Location Opening: manage plans easily with Salesforce projects