At Texas Collision Centers, I built a Power Query commission payroll process that gathers, maps, and validates pay data for direct Paycom upload. It saves about 8 hours of manual work each week with no upload errors, and I trained the payroll team on the workflow.
I process weekly Paycom payroll for approximately 300 employees across 18 locations, including commission calculations with split pay and allocations. Previously, at Open House Texas Realty & Investments, I supported multi-company accounting and built an Excel invoice coding tool that eliminated manual property lookups.
