QuickBooks DC Employer's Wage Report for Tipped Employees
QuickBooks prefills most fields on the District of Columbia tips wage report, but hourly rate and hours worked may need manual entry before electronic filing.
QuickBooks Desktop includes built-in support for the District of Columbia’s Employer’s Wage Report for Employees Receiving Gratuities, a quarterly form that lists every employee who earned tips during the period. The form is informational — the actual filing happens electronically through the DC tips reporting portal — but getting the numbers right inside QuickBooks matters for record-keeping and reconciliation.
What the Form Covers
The report captures four data points for each tipped employee: hourly rate paid, total hours worked, gross wages, and total tips. QuickBooks populates most of these automatically when payroll data is complete and up to date, but at least one field typically requires manual attention.
Accessing the Form
To open the report in QuickBooks Desktop, navigate to the Employees menu, select Payroll Forms, and choose the DC Employer’s Wage Report from the available state forms list. If the form does not appear, verify that the DC state tax item is correctly assigned to each tipped employee’s payroll profile — QuickBooks only includes employees whose pay setup contains tip compensation.
The Four Fields
Hourly Rate Paid
This field is not prefilled. Employers must manually enter the hourly wage paid to each tipped employee. The District requires that tipped workers receive at least the applicable DC minimum wage; the rate entered here should reflect what the employer actually pays as base compensation before tips are factored in.
Total Hours Worked
QuickBooks fills this in from existing payroll data when the information is available. If hours are missing or incomplete — which can happen when time tracking is not fully integrated with payroll — the employer must enter the total hours the employee worked as a tipped worker during the quarter.
Gross Wages
This figure represents total DC gross wages paid for the hours worked and is populated by QuickBooks from payroll records.
Total Tips
This amount captures all tips an employee received during the quarter, whether directly from customers or through a tip pool, provided those tips were reported as wages in QuickBooks.
When Fields Are Missing
In most cases, when company information, payroll setup, and employee records are all current inside QuickBooks, the form requires little manual input. The hourly rate field is the consistent exception — it does not auto-populate. When other fields come up blank, the gap usually traces back to incomplete payroll data or an employee record that is missing DC-specific tax assignments.
QuickBooks offers in-product help through the Help button on the form window itself, which covers both general form navigation and field-by-field explanations. The same help resources explain how unemployment insurance amounts are calculated, how to export payroll summaries to Excel for reconciliation, and how to save a copy of the completed form as a PDF for internal records.
Filing the Report
The form inside QuickBooks is a preparation tool, not a filing mechanism. The actual quarterly submission goes through the DC portal at the address listed in the form’s instructions. Employers should treat the QuickBooks version as a working draft — review every field, fill in what the software missed, and then carry those figures over to the electronic filing system.
For broader QuickBooks payroll help, including troubleshooting state form issues and reconciling wage data, the community knowledge base covers common payroll-form problems and their fixes.