Bob, I don't think there is a simple solution. I've implemented a variety of tools to support project tracking myself. I have many years experience with MS Project. I have configured and managed eProject. I have worked with Project Central. None of these solutions provide the solution.
I believe that some of the higher end solutions may provide the reporting capability I'm looking for. However, the organizations I've worked with haven't been willing to invest in the enterprise tools.
So to provide the details you need I've found three critical systems that must be in place:
Time Tracking and Reporting
Project Scheduling
Cost Tracking
Each provides a detailed amount of information depending upon the capability of the solution. Since these solutions will not be integrated you need a human integration element. This takes the form of a Project Code. Typically the accounting department is already assigning project codes.
By using the same project codes in the time tracking system you can easily pull actuals from that system. One issue I've had is getting actuals to the task. Anyway, its not an easy solution as you know. But with some common uses of Project Codes you can use Excel or other tools to pull together a report fairly easily. Of course there can be many hurdles to the process acceptance to capture the information.
BTW: Great topic.
