Setting up 1099 vendors and preparing 1099s in QuickBooks
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
- Confirm every 1099 vendor has a name and TIN on file — the last chance to chase missing W-9s.
- Run the 1099 summary and detail reports and review totals against the threshold (generally $600 for the year — confirm the current figure).
- Check for miscoded payments and vendors that should or shouldn’t be included.
- 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.
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