Im Hosted when I run a P&L by rep there are no expenses. If I run a P&L on individual jobs there are expenses

  • 1
  • Question
  • Updated 5 months ago
  • Answered
I cannot get an accurate P&L by rep. All I get is the income side of things. An individual P&L for the job is fine. P&L by class is fine (classes are not our reps). Job costing by REP also only shows income. Any one help me?  Have updated to 2018 and am using STP (although I can't see how that would affect anything)
Photo of Wendy

Wendy

  • 400 Points 250 badge 2x thumb

Posted 5 months ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
Wendy - this is because costs cannot be allocated to a Rep - only to an invoice - so you will only ever see revenue by Rep...    probably not what you want to hear - but in most cases a Sales Rep can really only influence sales and I would imagine that their commissions would be based on sales, not net returns?  Cheers Linda
Photo of Wendy

Wendy

  • 400 Points 250 badge 2x thumb
No not want I wanted to hear. Our sales reps are project managers and so costs are equally as important. To have to prepare a P&L per job is horrendous. I even tried job costing summaries by rep. but obviously costs can't be allocated by rep under any circumstances. 
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
Wendy - are you using the Class features of Reckon?  perhaps you could setup Class tracking where your Classes are your Reps?  then you can allocate both revenue and expenditure to a class - and then you can run a P&L report by Class?   
Photo of Wendy

Wendy

  • 400 Points 250 badge 2x thumb
We are using classes but they are for building type (Commercial, domestic etc). We have reps working in each class, so it would have been great to be able to run the P&L per rep and not just their sales figures. Profit share is involved so not straight commissions. 

Will have to rethink on this one. 
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
ok - sounds to me like the profit sharing means the P&L by Rep is possibly more important than the breakdown of Commercial, Domestic etc? (how many of these Classes do you use?)... thoughts... build the Commercial, Domestic breakdowns into your chart of accounts... or if there are 5 Reps and say 2 or 3 building types - you could consider having each Building Type as a class and then creating sub classes for each Rep...you could then filter the P&L reports when you want just a particular Rep... or you run it normally and you will get the Total of each Building Type as well - this could be sent to Excel and the sub classes hidden if you just want a summary P&L by building type?  Just something to consider? Other alternative - if you dont see value in the P&L by Customer... is to create a Customer for each Rep...then add Jobs under this - you would just invoice the customer based on the job details but as the job is a sub account of a Customer (the Rep) you can then get the P&L summary you are looking for?  However this probably wouldnt work if you need to send out statements for say a commercial customer that runs lots of jobs at the same time...
Wendy, how many sales rep you have ? And also since you are using Hosted do sales rep do invoice them selves .  Feel free to discuss on 0407068942 Chandra
Photo of Wendy

Wendy

  • 400 Points 250 badge 2x thumb
Currently 5 but they don't do any invoicing themselves.

Looks like we can't do what we want with both classes and reps.  
ok, but there may be a possibility of creating a hard coded report tool  as again it depend on how critical is this for your business , as there is an additional  once off cost . 
look at the opportunity cost ?