Tracking Expenses

G

Gene Dudley

I think I know the answer to this problem, but wanted to get the groups
feedback. We are implementing PS2003 to track project costs. As on any
project miscellaneous expenses occasionally occur. The accounting
department would like to be able to associate these miscellaneous expenses
back to the project they were incurred for so that the project manager can
have an accurate picture of the project's cost, and utlimately it's profit
margin. We have an existing web base expense reporting system. I've done a
bit of research and have not found a clean way to track miscellaneous
expenses in Project. I've come up with the following two solutions:

1) Add a miscellaneous expense task to all project plans and update it's
actual cost via an automated interface to the existing expense app. Pros -
it keeps all the actual costs for a project in one spot. Cons - the detail
is lost and the PM would need to access another system to view the
individual transactions that lead up to the aggregate miscellaneous cost
figure.

2) Build a custom report that would incorporate the information for PS and
the expense application, allowing the PM to see the high level and drill
down to the detail level.

Obviously there are some pros and cons to both solutions. If anyone has any
suggestions to improve either of the above options or has a third option
please let me know. Thanks in advance.

Gene
 
J

Jan De Messemaeker

Hi Gene,

When you want to keep track of the detail, I would expand on your first
solution, make your expenses task a summary task and all detailed expenses
its "children" tasks.

HTH
Jan De Messemaeker Project MVP
 
Top