by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks at Year-End: Getting Ready for 1099’s

Print Friendly

Here we are almost at year end and one of the tasks that we will soon be faced with in QuickBooks is getting ready to issue 1099’s.

1099_MISCAccording to the IRS, business owners must file Form 1099-MISC for each person to whom you have paid at least $10.00 in royalties or broker payments in lieu of dividends or tax-exempt interest; at least $600 in rents, services (including parts and materials), prizes and awards, other income payments, medical and health care payments, crop insurance proceeds, cash payments for fish (or other aquatic life) you purchase from anyone engaged in the trade or business of catching fish, or, generally, the cash paid from a notional principal contract to an individual, partnership, or estate; any fishing boat proceeds, or gross proceeds of $600, or more paid to an attorney during the year.

For many of us, the most common box that we use on a Form 1099 is Box 7 – Nonemployee Compensation, where we report nonemployee compensation of $600 or more. Included in this box are fees, commissions, prizes and awards for services performed as a nonemployee, other forms of compensation for services performed for your trade or business by an individual who is not your employee, and fish purchases for cash. Include oil and gas payments for a working interest, whether or not services are performed. Also include expenses incurred for the use of an entertainment facility that you treat as compensation to a nonemployee. Federal executive agencies that make payments to vendors for services, including payments to corporations, must report the payments in this box.  See Rev. Rul. 2003-66, which is on page 1115 of Internal Revenue Bulletin 2003-26 at www.irs.gov/pub/irs-irbs/irb03-26.pdf.

QuickBooks also provides us with several reports that we can generate to help us make sure that we issue our Vendor’s and Subcontractors 1099’s.

The first thing that I do is create a Custom Transaction Detail Report that shows me absolutely every payment I’ve made to each of my vendors – that way I can “see” how much I paid who throughout the year.

To create this report:

  • From the Reports menu –> Custom Reports -> Transaction Detail
  • When the report displays, I immediately go to the Total by dropdown menu and choose Vendor
  • Click the Customize Report button (upper left)
  • On the Display tab, change the Dates to This Fiscal Year.  Select Cash or Accrual based
  • In the Columns box, place checkmarks by the following options
    • Left Margin
    • Type
    • Date
    • Number
    • Name
    • SSN/Tax ID
    • Account
    • Class (optional)
    • Debit
    • Credit
  • Now click on the Header/Footer tab and in the Report Title Field type in Vendor Payments for 1099 Verification and click OK

Below is a sample of what this report looks like.  You can now scan it Vendor by Vendor to see who you already have Tax ID’s for and how much money you paid to each vendor, and which Vendor record needs to be updated.  I also highly recommend that you memorize this report so that you can easily create it each year.

custom vendor report-1099 verification

The next report that I run is the Vendor 1099 Detail Report found from the Reports menu –> Vendors –> 1099 Detail.  Be sure to set the Dates to be This Fiscal Year.

The last report that I run is a Purchases by Vendor Detail report; found from the Reports menu –> Purchases –> Purchases by Vendor Detail.  Again, make sure to set the Dates to be This Fiscal Year.

With these reports in hand, I can now audit my Vendor payments and look for things that might be out of whack.  Looking at the screen shot below, I can immediately see that I have a Tax ID on file for Amber’s Power Equipment and that I paid them $8,548.00 in the current calendar year from the Vendor Payments for 1099 Verification report, yet they do not show up on either the Vendor 1099 Detail Report or the Purchases by Vendor Detail report.

audit your 1099 payments

Now I can perform a self-audit, verify that the transactions were coded to the appropriate accounts and that I have the account included in my 1009 preference setup up.

Did you find this article helpful?  Please let us know.

2 Responses to QuickBooks at Year-End: Getting Ready for 1099’s

Leave a Reply

About Your Host:

Nancy Smyth, Certified QuickBooks ProAdvisor

Nancy Smyth, Sunburst Software Solutions, Inc.
QuickBooks Construction & Payroll Expert


I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.


QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

Search…….
Loading
Stay updated!

Sign up to receive our latest QuickBooks Tips, Tricks & News via email:


Enter your email address:

Delivered by FeedBurner


We promise NOT to sell, rent, or otherwise distribute your name and email address!

FREE 30-Day Trials

Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

Certified Payroll Training:
Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour live webinar - $89.00 per person. Click here for more info.

certified payroll requirements webinar
QuickBooks Training

Frustrated with QuickBooks?

QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

QuickBooks Time Tracking


Save 10%/FREE 14-day trial!


QuickBooks Time Tracker