Intuit Home | Intuit Products | QuickBooks Payroll


bookmark icon   print icon Print

Reports: 1099 Summary and 1099 Detail

The QuickBooks 1099 Summary and 1099 Detail reports can help you verify Form 1099-MISC information and whether you have set up your independent contractors correctly. Checking this information throughout the year might save you some headaches come tax time when you prepare and print your Forms 1099-MISC.

1099 Summary Report

The 1099 Summary report summarizes the cash outflows to each vendor for whom your company files a 1099-MISC form. If you think an amount is incorrect, double-click the amount to see a list of the transactions that make up the amount. Pay special attention to the Uncategorized column on the report, as these are your payments for accounts that are not set up for any 1099 box.

To create the 1099 Summary report:

  • In QuickBooks 2006 and QuickBooks 2005 R6 or later: From the Vendors menu, select Print 1099s/1096. Under 3. Run a summary report to review your 1099 data, click Run Report.
  • In QuickBooks 2004: From the Reports menu, choose Vendors & Payables and then 1099 Summary.

Quick Tip: The report initially shows only the vendors specified as 1099 vendors. To list all vendors in the report, regardless of their 1099 status, choose All Vendors from the drop-down list in the report buttonbar.

Quick Tip: The report also initially shows only amounts that are above the 1099 thresholds set by the federal government. To include amounts below the thresholds, choose Ignore Thresholds from the drop-down list in the report buttonbar.

1099 Detail Report

This report also helps you verify the information that QuickBooks prints on the 1099-MISC tax form. It provides more detail than the 1099 Summary report.

To create the 1099 Detail report:

  • In QuickBooks 2006: From the Reports menu, select Report Center. Choose Vendors & Payables from the left menu and then 1099 Detail.
  • In QuickBooks 2005 and 2004: From the Reports menu, choose Vendors & Payables and then 1099 Detail.

For each vendor, the report lists the individual transactions that contribute to the vendor's 1099 total. The totals themselves appear in the Balance column.

Quick Tip: The report initially shows only the vendors specified as 1099 vendors. To list all vendors in the report, regardless of their 1099 status, choose All Vendors from the 1099 Options drop-down list in the report buttonbar.

Quick Tip: Likewise, the report initially shows only transactions assigned to 1099 accounts. To list transactions that may have been assigned erroneously to non-1099 accounts, choose All Allowed Accounts from the 1099 Options drop-down list in the report buttonbar.

To go directly to one of the transactions listed, double-click the transaction.

Using the 1099 Reports

If you've set up your 1099 accounts and vendors, but your reports don't show you the information you're expecting, here are some ways to troubleshoot the problems.

To verify that all your independent contractors are correctly set up:

  1. In QuickBooks 2006: From the Reports menu, select Report Center. Choose Vendors & Payables from the left menu and then 1099 Summary.
    In QuickBooks 2005 and 2004: From the Reports menu, choose Vendors & Payables, and then choose 1099 Summary.
  2. If necessary, change the date range in the Dates field.
  3. Examine the report for missing 1099 vendors, and then select All Vendors from the left 1099 Options drop-down list. Any 1099 vendor not appearing on the report needs to be set up correctly. See the instructions in the article 5 Tips for Tracking Independent Contractors in QuickBooks.

To verify that your accounts are correctly mapped to your 1099 categories:

  1. If all missing 1099 vendors uncovered in the previous step have been set up, yet some 1099 vendors are still missing, select Only 1099 vendors from the left 1099 Options drop-down list and All allowed accounts from the middle drop-down list.
  2. Double-click any amount in the Uncategorized column of the report to open the 1099 Detail report.
  3. Check to see if any accounts need to be set up as 1099 accounts by examining the Account column of the 1099 Detail report. To learn more about setting up accounts, see the instructions in the article 5 Tips for Tracking Independent Contractors in QuickBooks. (If you happen to notice any transactions that should have been assigned to a different account, double-click the account to edit it.)
  4. When you are finished with the previous step, close the 1099 Detail report to return to the 1099 Summary report.
  5. Select Only 1099 accounts from the middle 1099 Options drop-down list. You should now see all expected 1099 vendors to whom you have paid amounts that total or exceed the threshold for the 1099 category.

If your vendor is properly set up and still doesn't appear on your report:

  • If a vendor is still missing, select Ignore thresholds from the right 1099 Options drop-down list. The vendor may not have met the threshold for the year.

Note: The 1099 Summary report covers actual payments (checks and bill payments) made during the year, regardless of the original date of the vendor's bill.

















The information contained in the QuickBooks Payroll Bulletin is meant to provide general information about the payroll process and is not intended to provide tax or legal advice. Always consult your tax professional when preparing tax documents.

Terms and conditions, features, support, pricing and service options subject to change without notice.

© 2006 Intuit Inc. All rights reserved.
Intuit Inc., Customer Communications, 2800 E. Commerce Center Place, Tucson, AZ 85706