We use the "Name Account #" field for a unique employee ID number that is how we organize and track employees throughout our company (too many same/similar names.) I'm trying to get a report to show gross wages that would include that field, so we could sort & compare reports generated from other systems.
From what I can see gross wages are shown in Payroll Summary (too wide to export 900+ employees anyways) or the Employee Earnings Summary. Neither let me add a column for this field, nor allow sorting by the Name Account #.
The reports that let me add the field as a column don't seem to be able to also get me the gross wages, just the net pay like the Payroll Transaction by Payee pictured below.
Is there any way to get the report I need, maybe there is a report I'm missing?