Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

 
62 Comments
Moderator

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

It's my pleasure to assist you today, suzannek.

 

I'm here to help you run your desired 1099 report that includes amount in QuickBooks Online (QBO).

 

We can run the 1099 Transaction Detail Report in QBO. This shows all transactions and total amount for each contractor and their account number, tax ID, with splits. I'd be happy to walk you through on how to run this report:

  1. Go to Reports.
  2. Under Expenses and Vendors, click 1099 Transaction Detail Report.
  3. Click Run report.

You may want to check out this guide on preparing 1099 in QuickBooks Online: Prepare and file 1099s.

 

Following the steps when preparing 1099's, you'll select the accounts whose transactions will populate the 1099 Transaction Detail Report.

 

You may want to visit this article on how to create 1099 report s in QuickBooks Online: Create a 1099 report for vendors and vendor payments.

 

I also recommend checking out our 1099 video tutorial for more information: youtube.com/watch?v=Izr-7XC6PQY

 

There you have it. I'm always here whenever you have questions while working with 1099's in QBO. I'd be glad to answer them for you.

Level 1

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

Your response doesn't address my issue.  I've done the steps you said, but there is no data on the report.  I have double checked that the vendors have the 1099 box checked and expenses are > $600, indicating that a 1099 is required.  

QuickBooks Team

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

Good Afternoon, @JenZr

 

Thank you for your feedback. Let's work together and get this resolved. 

 

If you're having issues viewing the correct amount for your 1099  report, let's try some troubleshooting steps to get you back to business. 

 

Make sure the correct Tax Year is selected in the Preview 1099 information

  • When opening the Prepare 1099-MISC Forms screen you will see a drop-down menu for Tax Year under the Company Information box. 

If this is a bill payment, make sure it's attached to the bill: 

  • If it's not, you can fix it by following these steps:
  1. Choose the Create icon. 
  2. Under Vendors, select Pay Bills.
  3. Pick the Filter drop-down. 
  4. Go to All for Payee and Location and click on Apply
  5. Check the appropriate bill. 
  6. Select Save or Save and Close

Once you complete these steps and it's still not showing the correct information, check that the payments are assigned to a vendor and not an employee. 

 

If the vendor paid by credit card, those will be reported on a 1099K form submitted by the payment processor. 

 

Also, the 1099 Transaction Detail Report requires the vendor's transaction accounts to be selected as well. To fulfill this, see below:

 

Choosing Accounts for 1099 Tracking and Reports

  1. Select the Expenses tab, then the Vendors section. 
  2. Click on Prepare 1099's
  3. On Step 2 - Accounts, check the option for whichever type of 1099 you're filing. 
  4. In the drop-down menu, check off each Ledger Account that holds transactions for your 1099 vendors. 

If you have any more questions, please don't hesitate to Reply to this thread. Happy Thursday! 

Level 2

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

This report is not working. Is there an estimate of when it will be fixed?

Moderator

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

Hi there, tstruminger.

 

Let's get this escalated to our engineers by contacting us. This way, we'll be able to check the cause of this issue. 

 

Here's how to reach us:

  1. Click on the Help icon.
  2. Select Contact us.
  3. Enter a topic and click on Let's talk.
  4. Choose either messaging an agent or requesting for a callback.

If you have other questions, we are here to help. 

Level 2

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

When will this report start working? It still does not work for me either.

QuickBooks Team

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

Let me help you with this 1099 report, Nathan-K.

 

I tried to pull up the 1099 Transaction Detail Report and I was able to see the data. Please be guided that we can only see the details in this report once you successfully filed the 1099 forms. If you filed the 1099 forms outside QuickBooks Online, we can toggle it so we can pull up this report. You can follow these steps:

  1. From the Workers tab, select Contractors and click on Prepare 1099s.
  2. Select Continue your 1099s. Make sure your Company details are correct, then hit Next.
  3. On the Accounts section, select the box for the types of payments you made and the expense accounts you use to track the payments. Click Next.
  4. Make sure to complete all the details needed for the Contractors, then Next.
  5.  Verify if all your contractors are showing on the Review sections. Once done, click on Finish preparing 1099s button.
  6. Click on I'll file myself > Yes, looks good! > Next > Done.

After performing all these steps, let's go back to the Reports tab and open the said report. If you've done all these steps already or you submitted it within QuickBooks Online, we can perform some troubleshooting steps. Let's pull up the 1099 Transaction Detail Report using an incognito window. We can also clear the browser's cache since it can also cause errors in QuickBooks. Aside from that, please update your browser or use another one if there's available.

 

I've added these articles for more details:

Please reply again and tag my name if you have more questions. I'll be here to assist.

Level 2

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

I see. Thank you. Is there a report that simply shows the payments you have made to your contractors that doesn't require filing your 1099s? Or maybe one that can be customized to do so? It would be nice to see this when reviewing my expenses every week. 

QuickBooks Team

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

Let me assist you this time, @Nathan-K.

 

Through the Contractor Balance Detail report, you can view payments you have made to your contractors. I’ll show you how:

 

  1. Select Reports in your left navigation pane.
  2. Enter/ select 1099 Contractor Balance Detail in the field.
  3. Click Customize and select the details you want to show on the report.
  4. Under Filter, choose paid.
  5. Hit Run report button.

 

To learn more about managing your QuickBooks account, feel free to visit this article: Help articles.

 

You can count on me if you have any other concerns.

Level 2

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

That doesn't work. The report is still blank. Even though I'm running it for this year. And there's no way to change the reporting year - why is it ignoring me when I tell it to run the report for this year?

Level 1

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

I am having the same problem.  No information shows up at all, even though I know I have paid them.

QuickBooks Team

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

Thanks for joining this thread, @kjcgoins.

 

Let's make sure that the Track Payments for 1099 box on the vendor's information is checked. Also, you'll need to ensure that they already reach the threshold. Please know that those payments made by credit card, debit card, gift card, or a third-party network like PayPal are excluded.

 

Your vendor's info will show on the 1099 Transaction Detail report if they reach the threshold. Here's how to open the report:

 

  1. From the left menu, select Reports, then enter 1099 on the search bar.
  2. Choose 1099 Transaction Detail Report.

If the issue persists after the troubleshooting steps above, I recommend reaching out to our QuickBooks Online care team. This way, we'll be able to investigate the root cause of the issue and generate steps to fix it for you. 

 

  1. Go to the (?) Help menu.
  2. Click on Contact Us.
  3. Type the keyword of your concern in the What can we help you with? box.
  4. Select Let's talk
  5. On the next screen, scroll down to the Choose a way to connect with us section.
  6. Choose Start messaging to initiate a discussion with a live agent or Get a call for callbacks.

contactqbosupport.JPG

For more info, please visit these articles:

 

 

Please keep me posted if you have any other concerns about the 1099 report. I want to make sure everything is taken care of for you. Have a good one. 
 

Level 1

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

I am having the same problem.  I have contractors set up, the 1099 box is checked, the account is assigned, their ssn is entered and I know they are over the threshold, but the report is blank.  Can you please make this report work?  I notice this has been a problem since January 2019.  We pay good money for this product.  It needs to work correctly.

QuickBooks Team

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

Thanks for letting us know in advance that you already made sure that all requirements for 1099 requirements were already met, Blackbelt3d. 

 

Please take note that there are types of vendor payments that are automatically excluded from 1099-MISC calculations. This includes payments made via credit card, debit card, or third party system, such as PayPal. More details about this are discussed here: Vendor Payments To Exclude On Form 1099-MISC.

 

If the payments are made using regular bill payments and checks, I would recommend reaching out to our phone or chat support teams. They can take a closer look at this and use a screen-sharing tools to determine what's causing the issue. Here's how:

 

Option 1

 

  1. Go to the Help menu and click Contact Us
  2. Type in the description box that you need help with your 1099 reports, then click Continue.
  3. Select between Send a message or Get a callback.

Option 2

 

  1. Click the Help menu in the upper-right hand corner.
  2. Type in "Talk to a human", then press Enter.
  3. Look for I still need a human and click on it.
  4. Click Contact Us.
  5. Select between Send a messageSchedule an appointment, or Get a callback.

Please take note that their operating hours are limited at the moment due to the ongoing pandemic. You can see the full details here: Support Hours And Types.

 

Let me know if you need anything else. 

 

contact us.PNG

Level 1

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

@Kendra H, the requirement to "Also, the 1099 Transaction Detail Report requires the vendor's transaction accounts to be selected as well." makes this report useless. This report should be able to tell us which vendors will require a 1099 - if we have to select them in order for the report to display them, then what is the use of this report?

QuickBooks Team

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

Hey there, @LillyR

 

Thanks for sharing your concerns with us. I'll be sure to take note of them. 

 

I understand how frustrating it can be having to select the vendor's transaction accounts for the report. However, at this time, this is the only way to gather the information on the report. Please know our product engineers work continuously to improve QuickBooks. I've submitted feedback on your behalf to have the 1099 report gather the information automatically, so this can be considered in a future update. 

 

Please let me know if there's anything else that I can do for you. It's our goal to make your experience the best possible. You can reach out to the Community at any time. Take care and have a wonderful weekend! 

Level 1

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

I am having the same problem.  No information shows up at all, even though I know I have paid them. This program worked correctly in 2019.  I believe an update has messed up this report.  Do you have a fix for it?

 

Level 2

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

I am trying to run the 1099 Transaction Report--I get a pop-up "Report is not working--we are working on it"

Could it be the change by the IRS from 1099 Misc to 1099 NEC ?  Did Intuit try a software update? Or is there any information for why it is not working?

QuickBooks Team

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

Thanks for joining this thread to let us know your concern, @Alison44233.

 

To start, make sure to check the box next to Track Payments for 1099 on the vendor's information. Then, you'll need to ensure that they already reach the threshold. 

 

Also, there are varieties of vendor payments that are excluded from 1099-MISC calculations. This includes payments made via credit card, debit card, or third party system, such as PayPal.

 

Your vendor's info will display on the 1099 Transaction Detail report if they reach the threshold. Here's how to open the report:

 

  1. Sign in to your account.
  2. Go to the left menu and choose Reports.
  3. In the Find by report by name field search 1099 on the search bar.
  4. Choose 1099 Transaction Detail Report.

If the same thing happens after the troubleshooting steps above, I suggest reaching out to our QuickBooks Online care team. This way, we'll be able to investigate the root cause of the issue and generate steps to fix it for you. 

 

I've also added these articles that can guide you more with the 1099 report: 

Let me know if you have other queries about the 1099 report. I'll be glad to help you. Have a nice day.

Level 2

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

@Alison44233 

 

Your article did not address the issue...I have done all the steps suggested. Are you sure the report is working?

 

Level 2

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

I'm having the same problem. It works fine in QB Desktop, which is why so many of us do not like QB Online! I just want a simple 1099 Transaction (or Summary) by Vendor so that I can review BEFORE filing 1099s.

Level 2

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

I agree - I just need a simple report that detail the vendors that I checked in the Vendor Setup of needing a 1099.  I want to see everything for them - not just if it is 1099 reportable.  For Example, on the Transaction List by Vendor Report, if there was a way to only show the vendors that had the check box checked on the setup without me having to go in and check every individual vendor - what is the point of the check box on the vendor if we can't use it to filter reports.

QuickBooks Team

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

Hi @Rebecca33,

 

Thanks for your input regarding the 1099 reports. Checking the box in Vendor set up allows you to track any contractor/vendor that will need to be issued a 1099. You can see 1099 totals, accounts, amounts, and other details here:

  1. Go to Reports.
  2. Search for 1099 Transaction Detail Report1099 Contractor Balance Detail, or 1099 Contractor Balance Summary.

You can also customize these reports by click on the vertical ellipsis (three dots) next to the report name.

 

We have some great resources for Year-end available on our 2020 Year-End Resource page located here: 2020 Year End Resources

 

 

I appreciate you dropping in to the QuickBooks Community, let me know if you need anything else or have any other questions.

Level 2

I am trying to run a 1099 report. I have tried all the steps in the help suggestions. nothing is running a report that includes amounts. No filter for amounts. Help.

@MonicaM3 

 

Hey Monica--the online 1099 detail transaction report is still giving me an error message " Something went wrong--we are working on it"

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us