Quickbooky

Accounting News

Payroll

QuickBooks and Idaho Form 967: What Split-Monthly Filers Need to Know

QuickBooks prefills most of Idaho's annual withholding reconciliation form, but 1099 data and certain read-only fields require manual attention before filing.

QuickBooks and Idaho Form 967: What Split-Monthly Filers Need to Know

QuickBooks Desktop handles the heavy lifting on Idaho’s annual withholding reconciliation, but employers filing Form 967 — particularly those on a split-monthly payment schedule — still need to understand what the software fills in automatically and where manual entries are required before the return goes to Boise.

Form 967 is the Idaho Annual Withholding Report. It exists to reconcile the total taxable wages an employer paid against the total Idaho tax actually withheld and remitted to the Idaho State Tax Commission during the calendar year. The reconciliation is filed alongside Copies A of all Forms W-2 and 1099, and the combined package is due 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 returns are mailed to the Idaho State Tax Commission at P.O. Box 76, Boise, ID 83707-0076.

What QuickBooks Prefills

When a user opens Form 967 inside QuickBooks, the application populates most fields automatically based on the company information and payroll data already on file. The software draws on employer details — company name, Employer Account Number, and related setup entries — to generate the scannable content that appears on the return.

Several fields on the form are locked as read-only. These contain scannable data tied to state specifications, and QuickBooks populates them from existing company records. Users cannot edit these directly on the form itself. If a company name or account number is incorrect on Form 967, the correction has to be made back in the main QuickBooks company file, not on the reconciliation form.

The Employer Account Number deserves particular scrutiny. Idaho optically processes tax returns using the scanline at the bottom of the form, so an incorrect account number can cause processing problems at the state level. Employers should verify this number before filing and, if it needs updating, make the change in QuickBooks so it flows through correctly.

Line-by-Line: Where Manual Entry Matters

The three primary wage and tax lines on Form 967 are where most of the reconciliation work happens, and QuickBooks handles W-2 data and W-2 data only. That distinction matters for employers who also issue 1099 statements with Idaho state tax withholding.

Line 1 — Total Idaho Taxable Wages: This figure should match the total Idaho taxable wages reported in Box 1 of all W-2 forms and any applicable 1099 statements for the calendar year.

Line 2 — Total Idaho Tax Withheld: QuickBooks calculates withholding amounts based on W-2 payroll data. Any state tax withheld on 1099 statements must be added manually. Users enter the total 1099 state withholding amount on line A of the smart worksheet that sits above line 1, and QuickBooks then adds that figure to line 2.

Line 3 — Total Payments: The same principle applies here. QuickBooks tracks and calculates payment data for W-2 amounts. To include payments associated with 1099 forms that carry state tax withholding, users must enter those totals manually through the smart worksheet so they roll into the correct line.

Verifying the Numbers

For employers who want to cross-check the figures QuickBooks generates, the form window provides hyperlinks that trace amounts back to their source data within the company file. Clicking these links shows where each number originated, which helps confirm that wage totals and withholding amounts are accurate before the return is filed.

QuickBooks also offers options to summarize payroll data in Microsoft Excel and to save a copy of the completed form as a PDF. The Excel summary can be useful for internal review or for reconciling against outside records, while the PDF copy provides a permanent file of what was submitted.

For general QuickBooks payroll help and related troubleshooting, additional resources cover common issues employers encounter when preparing state withholding forms.

Before You File

The key takeaway for split-monthly filers — and any Idaho employer working through Form 967 in QuickBooks — is that the software covers W-2 wage and withholding calculations comprehensively but does not capture 1099 withholding data automatically. Reviewing every field QuickBooks left blank, entering 1099 amounts in the smart worksheet, and confirming that read-only data like the account number is correct will help ensure the reconciliation matches what the Idaho State Tax Commission expects when the return arrives for optical processing.

← Back to Community Issues