Have you considered a custom transaction report that includes formulas that will table the rates based on the specific criteria and do all the math for you that includes a column that returns the billable labor rate and amount?

I have considered creating a custom report within Timberline which would mirror the ODBC excel file i currently utilize, however our management would like the job cost details to flow/sync with the Procore budget, I'm not sure a custom report would sync with Procore. Probably a question for them. Thanks for your feedback.

GAAP does not allow you to mix cost and labor profit, so whatever you do, you need to reverse it somehow to not show on your WIP schedule. I am not sure of your current set up but this is what I found to do the trick. I use ODBC to pull the NEW payroll file hrs/batches before it is posted in job cost and have "AR Customer" rates linked to jobs/cost codes. The rate gets multiplied by the hrs and the result will be your billable amount per job & cost code. The billable amount gets compared to the actual cost from the payroll batch (L and Burden) and the differences noted in a separate column (billable - cost). Next step is to post this under each cost code/job. I created a separate category "LD" (labor diferential) and a "fictitious" cost code # 99999. You would import the difference under cost code PManager\LD and reverse it under 99999\LD each pay period. You would need to then modify your reports to omit the 99999 cost code whenever necessary. This has no effect on the WIP and I believe 99999 can be part of your Procore integration to not get pulled in your budgets. My budgets reside in Sage and Procore is more of an electronic storage to me. Hope this helps.

Thank you Angel, i forgot to mention the contra cost code that would capture the payroll/burden delta, funny i was actually thinking of using 99999. Thank you for sharing your process with me, very helpful.

I do not use that cost code\category combination. It would depend on your JC set up and whether they were used in the past. Forgot to mention - you need to create an account to track all that part of your P&L. Link it to the LD category. Account shoul have zero balance at all times and will help with reconciliation of the import

Hi EHPAC, happy to see that the community helped you figure out a solution!

If you have a minute, tell us about your great experience on Sage City, take this short survey

Hi EHPAC,

Another option would be to create a PR fringe that would calculate the difference between the standard rate and the actual pay rate.  This fringe could be directly defaulted to your 99999 cost code. As previously stated, you could then exclude the 99999 cost code from your WIP to maintain GAAP compliance.

To be honest, the payroll formulas that are currently setup for our payroll fringe are outside of my comfort level. I'm open to partnering with someone to work through this.

We would be more than happy to assist you with this.  Please send me an email at [email protected]

We do the same thing, just to ensure that the correct billable rate is charged to our client as some Manager's bill based on cost.  We set up rate tables based on either the cost code, or by person depending on the contract, with a contra account to overhead, so no additional cost is being expensed to the finanials.