Rhode Island Public Employee Tax Compliance Act Reporting
Do we have a RI State Specific Report for the PETCA (Public Employee Tax Compliance Act)?
- Payroll
- Rhode Island
RI Gen. Laws SECTION 44-69-3 requires all political subdivisions to provide the Division of Taxation with a list of all employees as of July 1. The list of employees must be submitted electronically using an Excel spreadsheet, in the following format:
Field | Description | Length | Alpha/Numeric |
1 | Employee Social Security Number | 9 | Numeric |
2 | First Name | 25 | Alpha |
3 | Last Name | 25 | Alpha |
4 | Address | 25 | Alpha and Numeric |
5 | Address 2 | 25 | Alpha and Numeric |
6 | City | 25 | Alpha |
7 | State | 2 | Alpha |
8 | Zip | 5 | Numeric |
9 | Municipality Name | 25 | Alpha |
10 | Municipality Federal ID Number | 9 | Numeric |
Use the Employee Inquiry program to export the required employee details to Excel.
- Open the Employee Inquiry program.
- Select Search
- Enter selection criteria, such as Status = Active.
- Select Accept
- Select Yes, Continue to confirm the record set
- Select Excel
- Select the Full Report Excel Report Option
- Click the Select None option
- In the Select column, click the box for the following Fields:
- SSN
- Last Name
- First Name
- Address Line 1
- Address Line 2
- City
- State
- Zip
- Select Accept
- Open the Excel file
- Highlight Column C (First Name)
- Select Cut
- Highlight Column B
- Right-click and select Insert Cut Cells
- Enter Municipality Name in Cell I1
- Enter Municipality Federal ID Number in Cell H1
- In Cell I2, enter the Municipality Name that you want reported
- In Cell H2, enter the Municipality Federal ID Number you want reported
- Copy Cells I2 and H2 and paste into all remaining cells for Columns I and H
- Save the file
- Submit to the Division of Taxation. Email Tax.Audit@tax.ri.gov for a secure link and instructions to upload the requested information.
Questions about the reporting requirements can be directed to the Division of Taxation by phone at 401-574-8962, or by email to Tax.Audit@tax.ri.gov