While there are several Paycom reports available in R365, the Paycom Payroll TAI03 File should be downloaded specifically for Paycom Pay. This file will provide a summarized version of payroll information rather than list Labor Punches, which Paycom Pay does not accept.



Prerequisites


Before this report can be run, the Paycom Payroll integration setup must be completed. Learn more about the steps to complete the Paycom Payroll integration here.


Navigation


To navigate to the Paycom Pay TAI03 File report, click 'My Reports' under 'Reports' in the left pane and then select 'Labor' in the top header of the reporting window. Once opened, a listing of all reports will be shown.


Find 'Paycom Pay TAI03 File' and select 'Customize' next to the report. This will open up the Report Parameters that can be used to define your report.



Report Parameters



1) Filter By - A listing of all Location categories

2) Filter - A listing of all Locations associated with the selected Location category

3) Start Date - The beginning date for the report

4) End Date - The end date for the report

5) Download Button - Downloads the report


Click here to learn about Report Views and their added functionality.



Report Columns



A) Employee ID - This is the Employee Payroll ID

B) Gross to Net Code - This value will always be set to '1' for 'Earning'

C) Type Code - The code listed for the Labor Type. Codes include:

  • R - Regular
  • O - Overtime
  • DOT - Double Overtime
  • TP1 - Charge Tips
  • TP2 - Declared Tips

D) Amount - The amount earned based on the Type Code (C)

E) Temporary Rate - This is an empty field

F) Distributed Dept Code - The value from the Paycom Settings that corresponds to what is set as 'Department Code - 0'. This could be the Location Name, Job Code, or Payroll Profile ID

G) Tax Profile Override - This is an empty field 

H) Empty Field - This is an empty field 

I) Labor Allocation - This is the 'Labor Category' option for the Job Code with Job Categories separated by pipe ( | ) characters. This value is the same as that for the Paycom Export

J) Rate Override - This is an empty field