Every vendor record in QuickBooks provides you with a place to indicate if a Vendor is eligible for a 1099 and a spot for you to enter the Vendors tax ID number and I highly recommend that you utilize this functionality along with the ability to attach a completed W-9 to the Vendor record.
You can enter this information by going to the Vendor Center, selecting and editing a Vendor record. Exactly where you enter this information will depend on what “year” version of QuickBooks you are using, I’ve included a couple of examples below to help point you in the right direction.
Really want to stay organized? Add a Custom Field to Vendor records indicating if a completed W-9 is on file for that Vendor or not —- here’s how:
- From the Vendor Center –> Edit a Vendor -> go to the Additional Info tab -> click the Define Fields button
- The Set up Custom Fields for Names window will appear. In the Label column –> type in W-9 on File? and place a checkmark in the Vend column (see below). Click OK
- QuickBooks will display an message window indicating that you have activated custom fields for this list. Click OK to dismiss this window.
- When you return to the Vendor record you’ll now see that the W-9 on file? field is available (see below). Use this field consistently to enter
- Yes – meaning yes a W-9 is on file for this vendor
- Need – meaning you need to get a W-9 from this vendor
- N/A – meaning that a W-9 is not applicable for this vendor
You can now create, utilize, and memorize a Vendor W-9 Information Report. To create the report:
- From the Reports menu –> List –> Vendor Phone List
- Click the Customize Report button (upper left corner) –> on the Display tab -> click into the Columns box and check the following options:
- (left margin)
- Main Phone
- Main Email
- Bill from
- Vendor Type
- Tax ID
- Eligible for 1099
- W-9 on File?
- Click on the Header/Footer tab –> in the Report Title field; type in Vendor W-9 Information and click Ok.
You now have a report that you can use to review and manage the information that you have on file about your vendors and to assign a valid Vendor Type, review Tax ID’s, review if a vendor is eligible for a 1099 and indicate if a W-9 is on file. I highly recommend that you memorize this report and review it every 6 months to keep this required information up to date.
If you want to take your data information management to the next level – scan Vendor W-9′s, turn them into pdf’s and attach it to the Vendor record using the Attach function.
On Tuesday November 26th, look for an article that will help you perform a 1099 self audit for your year end tasks.
Looking for other articles and tip on our site that relate to 1099′s – click here to view our Search results.
Did you find this article helpful? If so please let us know by leaving a comment or sharing this article on your favorite social media network.
One Response to QuickBooks Year-End Tip – Tracking 1099 & W-9 Information
- Using Account Numbers in Your QuickBooks Chart of Accounts
- Straight from the IRS - Social Security Tax Reduced to 4.2%
- QuickBooks 2012 - Frequently Asked Questions About Upgrading
- QuickBooks 2013 Upgrade Do's, Don'ts & Frequent Questions
- Calculating & Displaying Fringe Benefits on a Certified Payroll Report
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks Tip - Determing Cost of Goods Sold
- QuickBooks for Contractors Tip – Advanced Progress Invoicing
- QuickBooks Creating a More Meaningful Payroll Expenses Section
- QuickBooks 2012 Announced
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- New FHWA-1391 & 1392 Annual EEO Forms For Highway Contractors
- Frequently Asked Questions - California Prevailing Wage
- QuickBooks 2012 - Best Practices & Tips for Installing an Upgrade
- QuickBooks Tip - Child Support Garnishments
- QuickBooks 2011 - New Balance Sheet by Class Report - Part 1
- Create a QuickBooks Job Cost Report With Hours & Payroll Costs
- QuickBooks 2011 - Computer Requirements & Office Compatibility
Join us on the 2nd Wednesday of each month, from 5-6 p.m. EST, on Google+ for the QuickBooks for Contractors hangout!
Webinar - QuickBooks Job Costing from A-Z
Having trouble getting job costing reports out of QuickBooks? Or maybe you are wondering if the information you see is accurate. Setup is KEY! Join us for an intensive 1 1/2 hour webinar covering job costing techniques and procedures on Wednesday March 26, 2014 from 1-2:30 p.m. EST. Sign up here.