Your Cart
Loading

1099 Contractor Payment Tracker for Landlords, Excel Template, W-9 Flag, 1099-NEC $2,000 Limit

On Sale
$7.00
$7.00
Added to cart

Which vendors do you need a W-9 from before year end? This sheet tells you. Log what you pay each plumber, painter, handyman or turnover crew, and it adds up the total per vendor and shows how much is left before the 1099-NEC filing threshold of $2,000 (payments made in 2026).

How it works:

  • Payments tab: one row per payment (date, vendor, property, what for, amount).
  • Totals tab: type each vendor name once. You get paid so far, left before the threshold, a status (ok, CLOSE: get W-9, OVER: file 1099-NEC) and a Yes/No for whether you need a W-9 and a 1099.
  • Warning amount starts at $1,800 and is one editable cell. Want a bigger buffer in December? Type 1,500 and every vendor flags earlier.
  • Threshold is also one cell, so it follows the rule if it changes.

Good to know: count payments by the date you paid, not the invoice date. Payments by credit card or payment app are generally reported by the card company on a 1099-K, not on your 1099-NEC, so log those only if your preparer asks.

Works in Excel and Google Sheets. No macros, no external links. Yellow cells are inputs. A sample vendor is included so you can see it work, then clear it.

Recordkeeping tool, not tax advice. Check current IRS rules or ask your tax preparer.

If the file does not work as described and we cannot fix it within 3 days, we refund the order.

You will get a XLSX (10KB) file