- Timing differences between timesheets, disbursements, invoices, write ons/offs and job completion dates.
- Client Performance includes open jobs or jobs in progress, Client Profitability does not.
- Each month's opening WIP balance and the end of period WIP balance does not appear in the Client Profitability report.
- Time costs are based on per-hour cost rates per staff member, not wages and salaries.
- Open jobs may have invoices that will appear in Xero but never in the Client Profitability report (because it's not profit yet).
- Timing differences between job completion date (the criteria for this report) and invoice date (the criteria used in Xero)
The Client Performance report is the best basis for a 'Client Profitability over time' type report however it does not include the time cost or direct cost of disbursements incurred on jobs for that client. Although 'Client Profitability over time' looks pretty and looks like a P&L over time - ask yourself - why am I running this report? What decisions do I want to make? What benefit do I gain from monthly invoiced value vs cost?
What you are likely to see is wide variability in the profitability shown in each month. This is due to the timing difference between the timesheet date, the disbursement date and the invoiced date. Not due to the performance of your sales or delivery teams, the quality of the work, the busyness of the month or how you've priced your services. Client Profitability over time also does not display the un-invoiced value of time and effort carried forward each month so distorts what profitability is for a particular client in a particular month.