MENU
    Paycom Payroll TAI03 File
    • 26 Jul 2024
    • 2 Minutes to read
    • Dark
    • PDF

    Paycom Payroll TAI03 File

    • Dark
    • PDF

    Article summary

    While there are several Paycom reports available in R365, the Paycom Payroll TAI03 File is designed to be downloaded specifically for Paycom Pay. This file provides 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.


    1. In the Reports section of the left navigation pane, select My Reports.
      The My Reports screen appears.

    2. At the top of the My Reports screen, select Labor.
      The screen generates a list of reports in alphabetical order.

    3. Locate the Paycom Payroll TAI03 File.

    4. Select Customize to adjust the report parameters and run the report.


    Report Parameters

    Field

    Description

    1

    Filter By

    A list of all filter categories. Filter categories will vary based by report.

    2

    Filter

    A list of filter options, determined by the 'Filter By' category selected (#1).

    3

    Start

    First date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates.

    4

    End

    Last date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates.

    5

    View options

    This section provides options to select, save, edit, or delete a report view.

    6

    Download

    Exports the report to a spreadsheet file and downloads the file to the default downloads location on the user’s device.


    Report Columns

    1. Employee ID - This is the Employee Payroll ID.

    2. Gross to Net Code - This value will always be set to '1' for 'Earning'.

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

      • R - Regular

      • O - Overtime

      • DOT - Double Overtime

      • TP1 - Charge Tips

      • TP2 - Declared Tips

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

    5. Temporary Rate - This is an empty field.

    6. 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.

    7. Tax Profile Override - This is an empty field. 

    8. Empty Field - This is an empty field.

    9. 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.

    10. Rate Override - This is an empty field.


    Was this article helpful?