Home / Resources / Accounting
Accounting

Setting up 1099 vendors and preparing 1099s in QuickBooks

9 min read · Keepsync Systems

1099 season is painful for one reason: the work needed to make it easy happens all year, and most of it gets skipped until January. Set your vendors up correctly from the start and year-end is a report and a review. Leave it to the last minute and it’s a scramble to chase missing tax IDs and untangle miscoded payments. Here’s how to do it properly.

Collect a W-9 before you pay

The foundation of clean 1099s is having a completed W-9 on file for every vendor who might need one — before you cut the first payment, not after. The W-9 gives you the legal name, tax ID (TIN) and entity type you’ll need. Chasing this in January, after the relationship is over, is where most 1099 pain comes from.

Mark the right vendors as 1099-eligible

In QuickBooks you flag a vendor as tracked for 1099s and record their tax ID. Not every vendor qualifies — generally corporations are excluded, and payments for goods are treated differently from payments for services. Getting the flag right per vendor is what makes the year-end report trustworthy.

Map accounts to the correct 1099 boxes

1099s report by category, so the accounts you pay vendors from have to map to the right box — most commonly 1099-NEC for nonemployee compensation (contractor and professional services) and 1099-MISC for things like rent. If payments land in unmapped accounts, they won’t show on the 1099 report, and you’ll under-report.

Know what to exclude

Payments made by credit card or third-party processor are reported by the processor on a 1099-K, so you must exclude them from your own 1099s to avoid double-reporting. QuickBooks handles this when payment methods are recorded correctly — another reason clean data matters.

Year-end: verify, review, file

  1. Confirm every 1099 vendor has a name and TIN on file — the last chance to chase missing W-9s.
  2. Run the 1099 summary and detail reports and review totals against the threshold (generally $600 for the year — confirm the current figure).
  3. Check for miscoded payments and vendors that should or shouldn’t be included.
  4. File by the deadline — 1099-NEC is due at the end of January (confirm the current date).

In a migration

When you convert a client into QuickBooks, the vendor 1099 flags and tax IDs have to come across correctly — and duplicate vendors will split a vendor’s payments across two records and understate their 1099. Clean vendor data before import saves a January headache; see finding and merging duplicate vendors.

Thresholds, boxes and deadlines change — confirm the current rules, and this isn’t tax advice. The habit that makes 1099s painless is stable, though: collect the W-9 first, flag vendors correctly, map accounts to boxes, and exclude card payments. Do that all year and January is quiet.
Keepsync Data Prep

Get the data right before it lands

Data Prep maps, validates and reconciles your source data before it’s written to QuickBooks — so vendor flags, tax settings and balances arrive correct, not corrected later.

See Data Prep