Arkansas Quarterly Wage Report in QuickBooks: What Fills Automatically

QuickBooks Desktop users responsible for filing Arkansas unemployment insurance tax often open the state’s quarterly contribution and wage report — Form DWS-ARK-209B — and find that while most fields are populated automatically, a handful require manual attention before the form is ready to submit.

The form serves as the State of Arkansas’s mechanism for reporting unemployment insurance tax calculated on total wages paid during a given quarter. QuickBooks is designed to prefill the majority of the fields using company, payroll, and employee data already entered in the software. In practice, most employers find they need to review — and in some cases manually complete — lines 8, 9, and 10, as well as several identification fields at the top of the form.

What QuickBooks Fills In Automatically

Several key identification and wage fields populate without user intervention, provided the underlying company data is complete and up to date in QuickBooks:

• DWS Identification Number — Pulled from the employer’s Department of Workforce Services ID stored in QuickBooks company settings.
• Date Quarter Ended — Entered automatically based on the quarter and year-end the employer has configured.
• Federal Identification Number — Drawn from the federal employer identification number on file.
• Total Wages Paid for Personal Services — This figure in Part A auto-populates from the total wages figure calculated across all pages of Part B.

The employee count section — covering the number of workers in the pay period that includes the 12th of each month during the reporting quarter — also fills in based on payroll data. Full-time and part-time workers who received pay subject to unemployment insurance wages are counted. If no employees were on payroll during a given month, the software enters a zero in that field rather than leaving it blank.

Fields That May Need Manual Entry

The areas most likely to require employer input are lines 8, 9, and 10 of the form. The exact amounts depend on the employer’s specific wage calculations and any excess-wage determinations that QuickBooks may not fully automate.

Employers should also be aware of the Unique Numeric ID field. This functions similarly to a personal identification number. The employer selects any four-digit ID to identify a particular return. Each filing instance — whether an original return, an amended return, a supplemental filing, or a submission for a different branch — requires a different ID. An employer can reuse the same ID across quarters, but any additional filing instance within the same period needs its own distinct identifier.

A No Wages Paid checkbox is available for quarters in which no wages were distributed. Employers in that situation should check the box rather than submitting a blank form.

Reviewing and Verifying the Data

Because QuickBooks relies on the accuracy of the data already entered, the completeness of the prefilled form is directly tied to how current the company’s payroll setup is. If employee wage details, state identification numbers, or quarterly wage totals are missing or outdated in QuickBooks, the form will reflect those gaps.

Employers who want to verify where the numbers originated can use the help resources accessible from within the form window itself. The form interface includes a Help button for general navigation guidance and troubleshooting. Additional references within the help system explain how unemployment insurance amounts are calculated, how to summarize payroll data in a spreadsheet for cross-checking, and how to save a completed copy of the form as a PDF for recordkeeping.

For broader guidance on payroll form preparation and troubleshooting, the form’s built-in help references point back to the data already stored in the company file — so the most reliable fix for incomplete or incorrect fields is ensuring that the underlying payroll and employee records are accurate before generating the report.