PA REV-1667 (AS) Filing in QuickBooks: What to Know

Each year, QuickBooks Desktop users who process payroll in Pennsylvania face the annual REV-1667 (AS) filing. The form — officially the Annual Withholding Reconciliation Statement — accompanies the W-2 forms submitted to the Pennsylvania Department of Revenue by January 31. Despite QuickBooks’ built-in prefill functionality, many users run into confusion about missing fields, inaccurate counts, or how to include 1099 compensation data. This report unpacks the issue and what the community has found to resolve it.

Where the Issue Surfaces

The REV-1667 (AS) is not a typical tax form that QuickBooks generates automatically. Users must open the designated payroll reports window, locate the form, and review every pre-filled line. The software pulls Employer Account Number, EIN, legal name, address, and W-2 compensation data from the company file. However, the form covers both W-2 and 1099 withholding, and QuickBooks only tracks W-2 amounts by default. The first stumbling block occurs when users see blank or zero lines for 1099 fields and assume the form is incomplete or broken.

Common Symptoms Reported

• Part I, Line 1b (Number of 1099 Forms With PA Withholding Tax) is blank and users cannot find where to enter it.
• Part I, Line 2 (Total Compensation Subject to PA Withholding) shows only W-2 numbers, ignoring 1099 compensation.
• The Employer Account Number appears in the wrong format (e.g., missing digits or hyphens) and users cannot edit it directly on the form.
• The number of W-2 forms attached (Line 1a) does not match the actual count, often because independent contractor forms (1099-NEC) were mistakenly entered as employees in payroll.

How QuickBooks Processes the Form

The software pre-fills most fields from the company and employee data. For lines it cannot calculate — such as 1099 counts and compensation — QuickBooks provides a “smart worksheet” area above Part I. Users must manually enter the 1099-related amounts into the worksheet’s Lines A through D. The program then adds those figures to the reconciliation totals. This step is frequently missed, leading to understated withholding amounts.

For the Employer Account Number, any correction must be made inside QuickBooks’ payroll setup, not on the form itself. The accuracy is critical because the state uses an optical scanline to process returns. A mismatch can cause rejection or delays.

What Actually Resolves It

According to the accepted community solution, the fix involves a deliberate walk-through of the form’s data sources:

1. Verify the employee list. Make sure only actual employees are marked for W-2 generation. Independent contractors who received 1099 forms should not appear in the payroll employee list — they are handled separately.
2. Enter 1099 information into the smart worksheet. Above Part I, there are fields labeled A–D for total 1099 compensation and withholding. Enter the aggregated amounts from your 1099-NEC or 1099-MISC forms.
3. Check the Employer Account Number format. It must be eight digits, grouped as four and four (e.g., 1234 5678). If QuickBooks shows a different format, update the company’s state tax ID in payroll settings.
4. Review the number of W-2 forms attached. Line 1a defaults to the count of employees with W-2 data. Manually adjust if you are filing on behalf of a multi-entity business or if some employees had zero wages.
5. Save a copy as PDF before mailing. QuickBooks allows saving the filled form as a PDF for your records. Use the “Save as PDF” option in the form window to avoid optical scanning issues when printing.

If you are still unable to find the form or the numbers look off, a reliable workaround is to summarize payroll data in Microsoft Excel and then manually transfer the totals. QuickBooks provides a hyperlink within the form window to export summary data. That approach gives you full control over the numbers — especially when combining multiple payroll runs or correcting prior-year errors.

Additional Context for Pennsylvania Filers

Pennsylvania’s Department of Revenue requires the REV-1667 (AS) to be mailed to a specific P.O. box in Harrisburg unless you e-file the underlying W-2s. The form itself is not e-filed — it is a paper reconciliation. Because of the optical scanline, any handwritten corrections or misaligned text can cause a rejection. That is why ensuring each field is correctly pre-filled from QuickBooks is essential.

For general guidance on QuickBooks payroll forms and troubleshooting state-specific filing issues, the community has built a knowledge base covering many states beyond Pennsylvania. Keeping a copy of your payroll data outside QuickBooks — such as an Excel summary — can save time when the form’s autofill does not behave as expected. If you frequently struggle with year-end filings, consider using a dedicated payroll help resource for step-by-step walkthroughs.

The Bottom Line

The REV-1667 (AS) form in QuickBooks works reliably when you understand what the software can and cannot calculate. The most frequent fix is manually adding 1099 data to the smart worksheet and verifying the Employer Account Number format. Once you complete those steps, the form will match your payroll records, and you can submit it with confidence. Remember that the due date is January 31 — and if that falls on a weekend or holiday, the deadline moves to the next business day. Plan ahead to avoid last-minute corrections.