Rental Property 1099-NEC Vendor Tracking in Excel: The $600 Rule Expired

Most rental property 1099-NEC vendor tracking in Excel is built around a number that expired. The $600 threshold every landlord memorized applied to payments made through December 31, 2025. For anything you paid a vendor after that date, the line is $2,000, and it indexes for inflation starting in 2027. If your spreadsheet has 600 typed into a formula, it is wrong in the direction that feels safe.

The reasonable conclusion is that a higher threshold means fewer forms and less work. That is backwards. The threshold change removed exactly one form from the portfolio below and turned four settled answers into open questions that stayed open until the last week of December.

The line moved, and the 24 percent moved with it

The One Big Beautiful Bill Act amended Section 6041(a). The text now reads "$2,000 or more in any calendar year," effective for payments made after December 31, 2025. Section 6041(h) indexes that amount for calendar years after 2026, using 2025 as the base year. Two consequences you cannot skip:

• The threshold is a moving number. Hard-coding 2000 into a formula buys you fourteen months before it is stale. Put it in a cell.
• Backup withholding followed. Section 3406(b)(6) makes a payment reportable when "the aggregate amount of such payment and all previous payments" to that payee in the year "equals or exceeds the dollar amount in effect for such calendar year under section 6041(a)." The withholding trigger is not a separate number. It is the same number, and it moved on the same day.

The wording is "or more," so a running total of exactly $2,000.00 is over the line, not under it.

Here is why fewer forms means more exposure. At $600, almost every recurring vendor crossed by spring, so "when in doubt, send one" was a defensible policy and the answer was settled early. At $2,000 you get a wide band between $600 and $2,000 where the correct answer is genuinely no, and a thin band just underneath where one December call flips it. The number of vendors whose status you cannot determine in July went up, not down.

Nine payees, $35,080, four forms

A seven-door portfolio across four properties, $131,400 of gross scheduled rent, $35,080 paid out to vendors during calendar 2026. Here is every payee and what each one actually requires.

Four forms, covering $11,280 of the $35,080. The two largest checks you wrote all year, $8,900 to the roofer and $6,605 to the supply house, produce nothing. The law firm, which most landlords assume is exempt because "PC" is a corporation, produces one. The IRS instructions are explicit: the exemption from reporting payments made to corporations does not apply to payments for legal services.

Now run the same year under the old rule. By July 31, Mike was at $1,610, Ramirez at $2,100, TruClean at $1,120, Whitfield at $1,600, and Kyle at $1,520. Under $600, five of those answers were already locked. Under $2,000, exactly one was. That is the entire cost of the change, and it lands on the tracking, not on the filing.

How you paid decides before how much you paid

Amount is the second test. Payment method is the first, and it disqualifies payments before you ever total them.

The Zelle row is the one that catches people. Venmo and PayPal look like Zelle on a phone screen and behave completely differently in the tax code. Dana Pruitt got $2,240 on a card and needs nothing from you. If you had paid her the identical $2,240 by Zelle, she needs a form.

The goods rule has a wrinkle worth knowing. Materials billed alongside labor stay in the reportable amount when supplying them was incidental to the service. Mike Delgado's invoice for a $310 job that includes $84 of parts is $310 of reportable payment, not $226. Ridgeline Supply is different because Ridgeline sells you material and performs no service.

Build the vendor registry before you build the payment log

The failure mode is not arithmetic. It is that your books are organized by property and the IRS wants them organized by payee. Mike shows up in your records as "Mike" on Kessler in March, "Mike's Handyman" on Larkin in June, and "M. Delgado" on Fremont in October. No single property crosses $2,000. The payee does.

Fix it at the source. Never type a vendor name into the payment log. Type an ID.

Column H carries three states, not two:

=IF(F4="","NO W-9",IF(E4="Legal","YES",IF(COUNTIF(CorpTypes,D4)>0,"NO - corporate",IF(E4="Goods","NO - goods","YES"))))

CorpTypes is a named range holding the four classifications that exempt a payee: C Corporation, S Corporation, LLC taxed as C corp, LLC taxed as S corp. The order of the nesting is load-bearing. Legal is tested before corporate because the attorney rule overrides the corporate exemption, which is exactly the trap Whitfield & Ross represents.

"NO W-9" is not a no. It is an unknown, and unknown is the only state on this sheet with a price tag. A vendor you have decided is exempt costs you nothing. A vendor you have not classified costs you 24 percent of everything you pay them after they cross.

The payment log runs two tests, and you need to see which one failed

One flag column tells you a payment does not count. Two flag columns tell you why, which is what you need in December when somebody asks whether the answer would change.

Column I is the only column the threshold math ever reads. Everything above it is the audit trail that explains a zero.

Two more columns turn this from a ledger into a warning system. Column J is a running total per payee, which is the whole trick:

=SUMIFS($I$5:$I5,$B$5:$B5,$B5)

The anchored start and relative end make the range grow as you fill down, so row 40 sums every countable payment to that vendor from row 5 through row 40. Column K prices the missing W-9 on the day you write the check:

=IF(AND(J5>=Threshold,XLOOKUP($B5,Vendors!$A:$A,Vendors!$G:$G)="N"),I5*0.24,0)

Once the running total crosses, it stays crossed, so this fires on the payment that crosses and on every payment after it, which is precisely what Section 3406(b)(6) says. If the vendor has certified a TIN, it returns zero and you ignore it. If not, the number in column K is real money you are about to hand over and should have kept.

While you are in this log, add a column for whether the payment is a repair or an improvement. The same check gets classified twice for two unrelated reasons, and getting the 1099 answer right tells you nothing about whether the $9,000 roof section is deductible this year or capitalized over 27.5.

The 24 percent only exists while the year is still running

Here is the July 31 view of the threshold monitor, with the threshold sitting in cell $C$3 so it can be updated when the indexed amount is published:

=SUMIFS(Payments!$I:$I,Payments!$B:$B,$A4,Payments!$A:$A,">="&$C$1,Payments!$A:$A,"<="&$C$2)

=IF(C4>=$C$3,"OVER - file",IF(C4>=$C$3*0.75,"WATCH - get W-9 now","under"))

The WATCH band at 75 percent of the threshold is not a legal concept. It is operational. It gives you roughly $500 of runway to get a W-9 while you still have leverage, because the leverage is the next check and it expires when the work is done.

Run the two undocumented vendors through to year end. Ramirez crosses on the July payment and receives six more $300 payments, so $1,800 of reportable payments should have had 24 percent withheld: $432. Kyle sits at $1,940 through November, takes a $1,180 turnover in December, and that single payment becomes reportable in full: $283.20.

Catch it on July 31 and you withhold from checks you have not written yet. It costs you nothing. Catch it on January 20 and the money is gone, because you cannot withhold from a check that already cleared, and a payer who fails to withhold can be assessed the amount they failed to withhold.

The penalty tiers for returns due in 2026 are $60 if you fix it within 30 days, $130 through August 1, and $340 after that. Section 6721 covers the copy that goes to the IRS and Section 6722 covers the copy that goes to the vendor, and they stack, so a form you never filed at all is $680. Intentional disregard runs $680 per section with no annual cap. On a seven-door portfolio, $3,435 is 2.6 percent of gross rent, produced by four pieces of paper.

January becomes a sort instead of a scramble

Forms 1099-NEC for 2026 payments are due to the recipient and to the IRS on the same day. January 31, 2027 is a Sunday, so the deadline is Monday, February 1, 2027. There is no split deadline the way there is for some other information returns and no automatic extension worth planning around.

Four things the log should hand you on February 1 with no additional work:

1. The filing list. =COUNTIF(Status,"OVER - file"). If that number plus every other information return you file reaches 10 in aggregate, you must file electronically. A landlord with four 1099-NECs and six other returns is over the line.
2. A blocked list. =IF(OR(TIN="",Address=""),"BLOCKED","ready"). A vendor who is over the threshold with no TIN is not a filing problem, it is a withholding problem you already have.
3. TIN verification. Run the names and TINs through the IRS TIN Matching service before you transmit. A mismatch found in January is a correction. A mismatch found by the IRS is a CP2100 notice and a B-notice you have to send the vendor.
4. An honest answer to Schedule E. Line A asks whether you made payments that would require you to file Forms 1099, and line B asks whether you did or will file them. You sign that return under penalties of perjury. The log is what makes "yes" defensible.

One thing the federal change does not do is settle your state. States set their own information return thresholds and are not required to follow the move to $2,000. Several still operate at $600. Keep the log at the lower of the two numbers and decide at filing time, which costs nothing, instead of discovering in April that your state wanted a form you never tracked.

Do this before the next check goes out

You are reading this in September. Roughly a third of the calendar year is left, which means the withholding remedy still works and the W-9 chase still has leverage. In January neither is true.

1. List every payee you have paid in 2026 and collapse the aliases. One row per human or entity, not per name on a bank line.
2. Pull the W-9 for each one and record line 3 verbatim. If you do not have it, that vendor's row starts with "NO W-9" and stays there until a PDF exists.
3. Strike out every card payment and every goods-only payee. That is usually a third of the list and it is the cheapest work you will do all week.
4. Total the survivors by payee, year to date. Anyone over $1,500 gets a W-9 request today, before the next job, while you still hold a check.
5. Anyone already over $2,000 without a certified TIN: start withholding 24 percent on the next payment. Tell them why. "I cannot pay the full amount without a W-9" is a true sentence and the only version of this request that reliably works.
6. Put 2000 in a cell, not in a formula, and label the cell with the year.

The vendor log is one tab of a system that also has to produce cash flow, cap rate, depreciation schedules, and a Schedule E that ties to your bank. SheetCraft's Rental Property Analyzer ships with the payee-level expense ledger already wired to the property-level P&L, so a single payment lands once and rolls up two ways: to the property for your returns analysis, and to the payee for the threshold monitor described here. The running-total and withholding columns drop into the vendor tab in about ten minutes. Build it in September and February is a sort. Build it in February and you are paying the 24 percent yourself.