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)
- Vendor
- 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.
I’m so glad 🙂
This is an amazing article, thank you!! Exactly what I was hoping to find!!
[…] QuickBooks Year-End Tip – Tracking 1099 & W-9 Information […]
[…] Archives by Month Select Month November 2013 (4) October 2013 (3) September 2013 (3) August 2013 (2) July 2013 (3) June 2013 (6) May 2013 (7) April 2013 (5) March 2013 (3) February 2013 (1) January 2013 (1) November 2012 (2) October 2012 (2) September 2012 (4) August 2012 (6) July 2012 (7) June 2012 (10) May 2012 (14) April 2012 (10) March 2012 (14) February 2012 (10) January 2012 (19) December 2011 (4) November 2011 (4) October 2011 (8) September 2011 (14) August 2011 (11) July 2011 (12) June 2011 (21) May 2011 (16) April 2011 (11) March 2011 (21) February 2011 (20) January 2011 (13) December 2010 (11) November 2010 (17) October 2010 (10) September 2010 (17) August 2010 (10) July 2010 (17) June 2010 (17) May 2010 (14) April 2010 (21) January 2010 (3) October 2009 (5) September 2009 (9) August 2009 (3) July 2009 (2) June 2009 (2) May 2009 (2) April 2009 (4) March 2009 (8) February 2009 (9) January 2009 (8) December 2008 (13) « QuickBooks Year-End Tip – Tracking 1099 & W-9 Information […]