QuickBooks and Rhode Island Form TX-17 Continuation: What Auto-Fills and What to Check
QuickBooks prefills most of Rhode Island's TX-17 quarterly wage continuation sheet, but weeks and hours paid may need manual review before filing.
QuickBooks Desktop handles the heavy lifting for Rhode Island employers who need to file Form TX-17, the quarterly tax and wage continuation report used when a business has more than nine employees. The form attaches to the main TX-17 filing and breaks out individual employee wage data. While the software populates the majority of fields automatically from existing payroll records, several calculated entries deserve a close look before the form goes out.
What QuickBooks Fills Automatically
For the core identifying information, there is generally nothing to enter manually. QuickBooks pulls the Rhode Island Employer ID Number, company name, and company address directly from the records already on file. Each employee’s Social Security number appears on Line 15, and Line 16 displays the employee’s last name followed by the first initial of their first name — all drawn from the employee setup in the company file.
Line 17, total wages for the quarter for each employee, is also populated automatically based on paycheck data already recorded in QuickBooks. Line 20, which tallies the total wages for only the employees listed on a given page, is calculated by the software as well.
Where Manual Review Matters
The two fields that most often need a second look are Line 18 (Weeks Paid) and Line 19 (Hours Paid). QuickBooks estimates both based on payroll data, but the underlying rules are nuanced enough that the automatic calculation may not match what Rhode Island expects.
Weeks Paid (Line 18)
QuickBooks counts any part of a week as a whole week. The estimation includes vacation time, holiday pay, jury duty, severance pay, and other personal leave — but excludes sick and disability time. For employees who earn only commissions, the weeks-worked figure is an estimate that may need adjustment. Employers can edit this number directly on the form if the software’s estimate does not align with their records.
Hours Paid (Line 19)
For hourly employees, QuickBooks includes hours for vacation and holiday time, jury duty, severance, and personal leave, but again excludes sick and disability hours. For salaried employees, the software uses a straightforward formula: weeks worked multiplied by 40 hours per week. That 40-hour assumption may not hold for part-time salaried staff or those with irregular schedules, so the calculated figure should be verified and corrected as needed.
When the Form Seems Incomplete
If fields on the TX-17 continuation are blank or populated incorrectly, the cause usually traces back to missing or incomplete data in the company file itself. Employee records lacking a Social Security number, incorrect wage items mapped to the wrong payroll categories, or company information that was never entered will all result in gaps on the generated form. Reviewing the underlying employee and payroll setup typically resolves these issues.
The form window in QuickBooks includes a Help button that provides guidance on tracing specific numbers back to their source in the company file — useful when a figure on the form does not match expectations and you need to identify which paycheck or setup entry is driving it.
A Note on State Forms Generally
State payroll forms like the TX-17 continuation are sensitive to accurate employee setup. If your QuickBooks payroll data is complete and current, the form should require minimal manual entry. But because the weeks and hours calculations involve judgment calls — particularly around leave categories and commission-only employees — treating the auto-generated numbers as a starting point rather than a final figure is the safest approach for accurate quarterly filing.