QuickBooks Prefills Rhode Island Form TX-17 Quarterly Wage Continuation
QuickBooks auto-populates most fields on Rhode Island's TX-17 continuation sheet, but weeks and hours paid may need manual review and correction.
QuickBooks Desktop handles the heavy lifting on Rhode Island’s quarterly wage reporting, but employers with larger payrolls should understand what the software fills in automatically and where manual review is necessary.
When a Rhode Island employer has more than nine workers, the state requires a continuation sheet — Form TX-17 — to be attached to the main quarterly tax and wage report. QuickBooks generates this continuation form and prepopulates the majority of its fields using the company, payroll, and employee data already stored in the file. In most situations, if all records are current and complete, no additional manual entry is needed.
The software pulls the Rhode Island Employer ID Number directly from company setup, along with the business name and address. For each employee listed on the continuation sheet, QuickBooks auto-fills the Social Security number, the employee’s last name and first initial, and the total wages paid during the quarter.
Where Manual Review Matters
The areas that demand attention are Lines 18 and 19 — weeks paid and hours paid. QuickBooks estimates these figures as accurately as it can based on payroll data, but the underlying rules are nuanced enough that the software’s calculations may not match what the state expects.
Weeks Paid (Line 18)
Rhode Island counts any portion of a week as a full week. Sick and disability time are excluded, but vacation pay, holiday time, jury duty, severance, and other personal leave all count toward the total. For employees compensated solely through commissions, the weeks figure must be estimated. QuickBooks does its best with these rules, but the software itself flags that you may need to edit the number — and employers should take that prompt seriously.
Hours Paid (Line 19)
The hours calculation differs by pay type. For hourly workers, QuickBooks includes hours for vacation, holidays, jury duty, severance, and personal leave, but excludes sick and disability hours. For salaried employees, the software uses a simpler formula: weeks worked multiplied by 40 hours per week. That 40-hour assumption will not hold for every salaried position, so reviewing and adjusting the figure is advisable where it does not reflect reality.
Page Totals and Final Checks
Line 20 — total wages for the page — is calculated automatically. QuickBooks sums the quarterly wages for only the employees appearing on that specific continuation page, not the entire workforce. This subtotal should match the corresponding section of the main TX-17 form.
The Bottom Line
The continuation form is designed to be largely hands-off. The employer identification, company details, employee identifiers, and wage totals flow directly from existing QuickBooks data. The genuine risk area is the weeks-and-hours estimation, where state-specific counting rules — partial weeks counted as whole, certain leave types included while others are excluded — may not align perfectly with what the software computes.
Employers processing Rhode Island payroll forms in QuickBooks should treat the auto-generated weeks and hours as a starting point rather than a final answer. A quick manual check of those two lines against actual payroll records is the simplest way to avoid filing corrections later.