Idaho Form 967 Withholding Reconciliation Missing in QuickBooks Payroll

QuickBooks Desktop payroll users responsible for Idaho’s annual withholding reconciliation — Form 967 — have reported difficulty locating the form, understanding which fields QuickBooks populates automatically, and figuring out how to incorporate 1099 withholding data that the software does not track by default. The form itself is straightforward once you know where QuickBooks stops and manual entry begins, but several quirks catch employers off guard during year-end filing.

What Form 967 Covers

Form 967 is Idaho’s Annual Withholding Report. It serves as a reconciliation of total taxable wages paid against the total Idaho state tax withheld and remitted throughout the calendar year. The form is filed together with W-2 and 1099 statements, and all three are due to the Idaho State Tax Commission on or before the last day of February. When that deadline lands on a weekend or legal holiday, the filing moves to the next business day. Completed paperwork goes to the commission’s P.O. Box in Boise.

Fields QuickBooks Fills Automatically

QuickBooks pre-populates a significant portion of Form 967 based on company data already on file. However, certain fields are locked as read-only because they feed into the scannable data at the bottom of the form — the optical scanline the state uses to process returns. Company name, employer account number, and similar identifying data fall into this category.

If any of those pre-filled fields are incorrect, editing them directly on the form is not an option. The fix requires going back into the company profile in QuickBooks itself, updating the source data there, and then returning to the form. This two-step process is a common source of confusion for users who expect to correct information inline.

The 1099 Withholding Gap

The most frequently reported issue involves Line 2, Total Idaho Tax Withheld. QuickBooks tracks and calculates W-2 withholding amounts automatically, but it does not do the same for 1099 statements that include state tax withholding. Employers who issued 1099s with Idaho tax withheld must enter those amounts manually.

The form provides a smart worksheet above Line 1 for this purpose. Line A of that worksheet is where the total state withholding from all 1099 statements goes. QuickBooks then adds that figure to the W-2 withholding total on Line 2. Users who skip this step underreport their total withheld tax, which creates a reconciliation mismatch.

Line-by-Line Entry

Line 1 — Total Idaho Taxable Wages: This figure should match the total from Box 1 of all W-2 forms and any 1099s with Idaho taxable wages. QuickBooks pulls W-2 wage data automatically, but employers should verify the total against their actual filed forms.

Line 2 — Total Idaho Tax Withheld: As noted above, this line combines W-2 withholding (calculated by QuickBooks) with any 1099 withholding entered on Line A of the smart worksheet.

Line 3 — Total Payments: This line reflects total payments made to the Idaho State Tax Commission during the year. The same 1099 limitation applies — QuickBooks tracks W-2-based payments but does not automatically account for payments associated with 1099 withholding.

Reviewing and Saving the Form

Before filing, users should review every field QuickBooks did not fill automatically. The form window includes a Help button for general navigation guidance and troubleshooting specific to the form. QuickBooks also provides hyperlinks within the form view that trace withheld amounts back to their source data in the company file, which helps verify that the numbers are accurate.

For recordkeeping, the form can be saved as a PDF directly from the form window. Employers who need a broader view of their payroll data for reconciliation purposes can also export a summary to Excel, which is useful for cross-referencing wage and withholding totals before finalizing the Form 967 submission.

Key Takeaway

The core issue is not that Form 967 is missing from QuickBooks — it is available through the payroll forms workflow — but rather that QuickBooks handles only the W-2 side of the equation automatically. Employers with 1099 filers who had Idaho tax withheld must manually complete the smart worksheet, and anyone with an incorrect employer account number or company name must correct it at the source in QuickBooks before the form will reflect accurate scannable data.