Project reporting, using tasks and calculating remaining cost

  • 1
  • Question
  • Updated 10 months ago
  • Acknowledged
I am trying to find or create a report that will show me the remaining estimated cost of my project at the project and task level. Currently, the amount I get is estimated cost minus the individual actual billed amount. I need it at the project level.

For example:
Project X has an estimated cost of $600k to be completed in 3 phases. Phase 1 is $170k and has 3 people assigned to it. Employee 1 bills $5950, Employee 2 bills $4500, and Employee 3 bills $5250 for a total of $15,700. 

My remaining total for phase 1 should be $154300. My report shows $164050, $165500 and $164750 respectively for each employee. And the total Remaining Task Cost is showing as $494300 - which is $170k times the 3 employees, less the $15700 billed. Additionally, the Remaining Revenue Amount for the project is $1784300. My report added the $600k 3 times less the billed amount. 

I was able to create a report to give me the sum total billed, but I can't get it to give me the total remaining costs.

I appreciate any help.
Photo of McBride, Annette

McBride, Annette

  • 8 Posts
  • 1 Reply Like

Posted 11 months ago

  • 1
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1560 Posts
  • 108 Reply Likes
Hi Annette,

Thank you for using the Replicon Community!

Can we have a short call in order to discuss this. 

Thanks,
Aashnee
Photo of McBride, Annette

McBride, Annette

  • 8 Posts
  • 1 Reply Like
Hi Aashnee - I am still waiting for a call. This remains an open question for me.  Thanks.
Annette
Photo of Raghu K

Raghu K, Community Moderator

  • 162 Posts
  • 9 Reply Likes
Hi Annette, Sorry for the delay. We will contact you shortly
Photo of McBride, Annette

McBride, Annette

  • 8 Posts
  • 1 Reply Like
Yes, that would be helpful.