Management would like to see our job cost transactions show payroll as a set $ amount per hour as agreed upon by each project owner. These set rates would vary between project. For example, project X would have a billable labor rate for Project Manager of $90 / Hour, project Z would have a billable labor rate for the Project Manager of $100 / Hour. The amounts charged to job cost would be based on the cost code the payroll hours are charged to, ie Project Manager, Project Engineer, Project Superintendent, Safety Manager, Estimating, Project Administrative. The amounts charged would to job cost would not reflect actual payroll or burden amounts.

Currently, i use ODBC to download the job cost transactions to excel, then use a formula to overwrite the amount by taking the units charged to that particular cost code x the billable rate. However, our management would like the cost details reflected in our job cost budget (we use Procore, the job cost transactions sync up). Any advice or guidance would be greatly appreciated.