Skip to content

QuickBooks mapping checklist

QuickBooks 1099 mapping checklist

Use this QuickBooks 1099 mapping checklist to review payment accounts, category mapping, report output, missing contractors, wrong amounts, and vendor readiness before the firm review handoff. QuickBooks is where account mapping and report review happen. The QuickBooks 1099 workflow guidance covers the product path. W9Finder by FormSignal helps with the surrounding cleanup: missing W-9s, vendor exceptions, secure requests, private uploads, reminders, review handoffs, and reviewed CSV exports.

Who this page is for

This checklist is for firm users reviewing QuickBooks account mapping and 1099 reports before client filing work. It is designed for operational QA and exception tracking, not tax or legal advice.

Map accounts and reconcile totals

  1. Select accounts Open Expenses & Bills > 1099s > Prep my own via QuickBooks and review the company information before Select accounts. Use Select accounts to choose the expense account used for the payments; the example shows Contract labor. Intuit workflow guidance.
    QuickBooks account mapping row with Contract labor assigned to Non-employee compensation in Box 1
    For tax year 2025, Contract labor is assigned to Box 1 nonemployee compensation in Select accounts.
  2. Assign the 1099 box In Select accounts, open the 1099 box dropdown beside the expense account. For the 2025 nonemployee compensation example, choose Non-employee compensation | Box 1 1099-NEC, then select Next. Intuit workflow guidance.
    QuickBooks 1099 box dropdown open, listing available boxes with Non-employee compensation | Box 1 1099-NEC selected
    The 2025 mapping dropdown has Non-employee compensation | Box 1 1099-NEC selected.
  3. Review recipients and reportable totals In Review recipients, check Tracked for 1099 and Reportable payments only. Compare each selected recipient and Reportable total with Transaction List by Vendor for the same payment year, and check Not tracked for 1099 for omitted records. Intuit workflow guidance.
    QuickBooks Review recipients screen with two selected recipients and their reportable totals
    Review recipients shows two selected recipients and reportable totals for tax year 2025 after Box 1 mapping.
  4. Read the Non-reportable total tooltip In Review recipients, change Reportable payments only to Non-reportable payments only. Open the question-mark tooltip beside Non-reportable total and compare the payment method with the excluded total. Intuit workflow guidance.
    QuickBooks Non-reportable total tooltip explaining card payments and payments below the reporting threshold
    In the 2025 Box 1 workflow, Review recipients shows the Non-reportable total tooltip and a sample vendor under Non-reportable payments only.
  5. Use W9Finder to resolve missing W-9s, legal names, addresses, and other readiness gaps that account mapping will not fix.

Why payments appear under Non-reportable total

QuickBooks leaves some payments out of the 1099 totals on purpose. Payments made with a credit card or payment card, and certain other payments including third-party network transactions, are reported on Form 1099-K by the payment settlement entity and are not subject to reporting on Forms 1099-NEC and 1099-MISC (https://www.irs.gov/instructions/i1099mec and https://www.irs.gov/forms-pubs/about-form-1099-k). A contractor paid entirely by card can show a total of zero in the mapping review even though the payments happened. Check the payment method before treating a zero total as an error.

For the QuickBooks behavior shown in this review, compare the tooltip with the QuickBooks guidance for missing contractors and wrong 1099 amounts.

The tooltip uses the $600 figure, which applies to nonemployee compensation paid in 2025 (2025 IRS instructions for Forms 1099-MISC and 1099-NEC); the reporting threshold for otherwise reportable nonemployee compensation paid in 2026 is $2,000 or more per recipient, subject to the applicable exceptions (IRS instructions for Forms 1099-MISC and 1099-NEC).

Zero recipients: check similarly named accounts

If Review recipients shows zero recipients, compare the expense category on the original transactions with the account selected in Select accounts. Expenses categorized to Contract labor will not be picked up by mapping a different account named Contract labor - cost of sales. Select the account actually used, assign the appropriate 1099 box for the payment year, and review the totals again; see Intuit troubleshooting guidance.

Mapping and totals reconciliation checklist

Mapping stage QuickBooks check Reconciliation evidence
Account mapping Open Expenses & Bills > 1099s > Prep my own via QuickBooks and review the Select accounts step. https://quickbooks.intuit.com/learn-support/en-us/help-article/form-1099-nec/create-file-1099s-using-quickbooks-online/L2BapEpb1_US_en_US The mapped account list is the starting point for reconciliation.
Mapping dropdown Assign each account through the mapping dropdown and verify the nonemployee compensation mapping box. https://quickbooks.intuit.com/learn-support/en-us/help-article/form-1099-nec/create-file-1099s-using-quickbooks-online/L2BapEpb1_US_en_US The selected tax box is visible for reviewer comparison.
Totals reconciliation Compare the per-contractor totals produced by mapping with the QuickBooks report output. https://quickbooks.intuit.com/learn-support/en-us/help-article/payroll/understand-contractors-need-1099s/L9Wqjtfif_US_en_US Differences can be traced to an account, contractor, or payment method.
Excluded payments Read the Non-reportable total tooltip and check the payment method before treating a zero total as an error. https://quickbooks.intuit.com/learn-support/en-us/help-article/electronic-tax-filing/fix-missing-contractors-wrong-amounts-1099s/L0MspaDKN_US_en_US The exception is documented before the totals are escalated.
W-9 handoff Route missing W-9s, legal names, addresses, and other readiness gaps to W9Finder for collection and review. Mapping cannot fill a missing vendor record.

Free QA tool

Scan your vendor list for W-9 gaps

Use the Vendor Readiness Scanner to spot missing W-9s, incomplete vendor details, and records that need review before your firm starts cleanup work.

Scanner output

Missing W-9s Flagged
Duplicate vendors Checked
TIN-like values Masked

FAQ

What is QuickBooks 1099 mapping?

QuickBooks 1099 mapping is the review of payment accounts and categories used in the Expenses & Bills > 1099s > Prep my own via QuickBooks workflow. The product path is described at https://quickbooks.intuit.com/learn-support/en-us/help-article/form-1099-nec/create-file-1099s-using-quickbooks-online/L2BapEpb1_US_en_US

Why do mapping mistakes matter?

Mapping questions can affect which amounts appear in 1099 review screens or reports. Compare mapped accounts with report output before the firm review handoff using https://quickbooks.intuit.com/learn-support/en-us/help-article/payroll/understand-contractors-need-1099s/L9Wqjtfif_US_en_US

What should be checked outside account mapping?

Review W-9 status, vendor names, addresses, tax tracking context, missing contractors, and wrong amounts. Mapping is only one part of vendor readiness.

Does W9Finder change QuickBooks mapping?

No. W9Finder helps firms organize W-9 collection and vendor readiness cleanup. QuickBooks account mapping remains inside the QuickBooks workflow.

Related W9Finder resources

Sources

This page explains the rules for firm review workflows. It is not tax or legal advice.