Vendor and 1099 Setup in Sage 100 Contractor: Avoiding Year-End Surprises
Construction companies work with dozens or hundreds of subcontractors, and the IRS requires a 1099-NEC form for each one paid $600 or more during the tax year. Sage 100 Contractor has built-in 1099 tracking, but it only works if vendors are set up correctly from the start. The most common problem: vendors with a 1099 type of “Undetermined.”
What “Undetermined” Means and Why It’s a Problem
When you create a new vendor in Sage 100 Contractor (4-4 Vendors), the 1099 type field defaults to Undetermined. This means Sage does not know whether this vendor should receive a 1099 form. At year-end, when you run the 1099 processing routine, these vendors are excluded — even if they are subcontractors who legally require one.
The result: missed 1099 filings, potential IRS penalties, and a scramble in January to fix vendor records retroactively.
The Correct 1099 Types
- 1099-NEC (Non-Employee Compensation) — For subcontractors, freelancers, and independent contractors. This is the most common type for construction companies.
- 1099-MISC — For rent payments, royalties, prizes, and other non-compensation payments.
- None — For corporations (C-Corp and S-Corp are generally exempt), material suppliers, and other vendors who do not require a 1099.
- Undetermined — Should never remain on a vendor record. This is a temporary placeholder only.
How to Set Up Vendors Correctly
- Set the 1099 type when creating the vendor. In 4-4 Vendors, on the main tab, change the 1099 type from “Undetermined” to the correct value before entering any invoices.
- Collect a W-9 before the first payment. The W-9 tells you the vendor’s tax classification (sole proprietor, LLC, corporation) and their Federal Tax ID (EIN or SSN). Use this to determine the correct 1099 type.
- Enter the Federal Tax ID. In Sage, enter the tax ID in the vendor record. This is required for 1099 filing and is printed on the form.
- Complete the address. The 1099 form requires a mailing address. Incomplete addresses will cause the form to be rejected by the IRS e-file system.
- Review the $600 threshold. At any point during the year, you can check which vendors have received $600+ in payments. Those with “Undetermined” type need immediate attention.
How DataXcel Flags These Issues
The Sage Setup and End of Year Close alerts in your CEO Briefing automatically detect:
- Vendors with 1099 type still set to “Undetermined”
- Vendors with payments exceeding $600 who may need a 1099
- Vendors missing tax ID or address information
The Fix
Pull the list of flagged vendors and update each record in 4-4 Vendors. For vendors you’re unsure about, request a W-9 immediately. Establish a company policy: no AP invoice is entered for a new vendor until the W-9 is on file and the 1099 type is set. This simple gate prevents the year-end 1099 scramble entirely.