Construction Payroll Excel Template

I need a single-workbook Excel solution that turns raw timesheet data into clean, industry-standard payroll reports for a construction company. The focus is on accurate calculations and formatting that align with the construction sector’s common reporting expectations, so foremen and accountants can review, print, or export without extra tweaking.

Here’s what matters most to me:
• A straightforward interface where I can paste or import weekly hours and have the sheet automatically populate a polished payroll report.
• Layout, column order, and headings that match typical construction payroll submissions (union/non-union splits, regular vs. prevailing wage lines, job codes, etc.).
• Built-in formulas that remain transparent and easy to audit so my accountant can follow the math.
• Minimal macro dependence—if VBA is required, please comment the code thoroughly.

I’m open to your suggestions on optional extras like embedded hour tracking or overtime calculations, as long as they don’t complicate the core deliverable: a reliable, construction-ready payroll report generated entirely in Excel. Let me know how you would structure the workbook and your estimated turnaround.