The Member P&L by Period report is a profit and loss statement over a set time period that shows the members who put in time and how much of that time is billable. The report is run for a specific department or all departments (example below is filtered on the IT department for all clients).

The report looks at a specific client or all clients (1) for a date range (2). You can use the 'Quick set' button to specify the trailing 12 months or a specific year for the date range. The report looks at all departments or one specific department (3). Inactive members are excluded if this box is checked (4).

Note: This report can be downloaded in PDF format or Excel/CSV spreadsheet for use outside of the MSPCFO system. When using the '+' the report is stored in a Download Basket to be downloaded with other reports at a later time (see highlighted area below).

The line items of the report focus on the member who put in time for specific types of work. If a department is specified in the filters, only that department is included. The report displays revenue, cost and margin by separating the type of work done: FFA, Projects, T&M. It also looks at internal time, admin time and lost time and calculates the utilization for the member during this time period. 

The Client hours, Admin hours and Internal Technical hours are the actual time worked. These numbers come from the PSA data. Total hours is the sum of Client, Admin and Internal Technical hours. 

There are a number of ways that Employee Utilization can be calculated. MSPCFO calculates Employee Utilization in the following way:  Employee Utilization = Client hours / Normal hours per month. 

This calculation is based on 'normal hours per month'. To arrive at this figure, MSPCFO assumes an 8 hour work day and uses days per month from the Lookup > Days per Month table to find out how many standard work days your company has in a given month. ( A default number of days per month is set up, but should be customized to the work days in each month for an MSP.)

Lost Time is the number of hours below the 'normal hours per month'. For example, if you have 21 work days in a month X 8 hours per day, the normal hours per month would be 168. Anyone working less than 168 hours for the month would have the difference as Lost Time. (Note: Calculations are done in actual time including decimals. The report shows whole hours only so there is some rounding considerations.)

The last line of the report totals the revenue, cost, margin and hours from the report and calculates an average utilization.