cancel
Showing results for 
Search instead for 
Did you mean: 
DougSwain
Level 1

1099 Transaction Detail Report

When I run the 1099 Transaction Detail Report for last year (2020), no data populates the report.  The vendors that I would expect to appear have the "track payments for 1099" checkbox checked in their vendor record.  I can't figure out why no vendors are showing up in this report.

Solved
Best answer January 07, 2021

Best Answers
MonicaM3
Moderator

1099 Transaction Detail Report

Hi there @DougSwain,

 

I’m here to help with your 1099 Transaction Detail Report. In order to get that list populated, you will need to start the Prepare 1099’s process. The reason for this is to assign a form for the Vendors (ie: 1099-NEC, 1099-Misc, etc).  Here’s how:

 

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.

Once you have worked through adding that to the Vendor, you can cancel or exit out of the 1099 wizard, and your report will populate.

 

I’ll be here if you have any other questions or if there is anything else I can help with, just let me know!

View solution in original post

20 Comments 20
cmpatel2
Level 1

1099 Transaction Detail Report

I also have the same problem. 

MonicaM3
Moderator

1099 Transaction Detail Report

Hi there @DougSwain,

 

I’m here to help with your 1099 Transaction Detail Report. In order to get that list populated, you will need to start the Prepare 1099’s process. The reason for this is to assign a form for the Vendors (ie: 1099-NEC, 1099-Misc, etc).  Here’s how:

 

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.

Once you have worked through adding that to the Vendor, you can cancel or exit out of the 1099 wizard, and your report will populate.

 

I’ll be here if you have any other questions or if there is anything else I can help with, just let me know!

DougSwain
Level 1

1099 Transaction Detail Report

Now I see that I didn't check off enough ledger accounts in Step 2 (Accounts).  The sub-accounts are listed separate from the top-level accounts.  I had checked off Professional Fees but not the Accounting and Bookkeeping sub-accounts within Professional Fees.  Thank you for your clear writing.  -- Doug Swain, age 70.    

ehh1212
Level 1

1099 Transaction Detail Report

our vendors are marked for 1099 eligible and has FEIN, for some reason this year the Summary and Detail report are not populated.  What changed this year?  We have updated our QuickBooks still not showing the detail.  

ehh1212
Level 1

1099 Transaction Detail Report

I am not clear with your instruction.

Where is "expenses tab" that you are referring to?  Where can I find "Prepare 1099"? it's not under "Vendor" nor under "Reports"

Mark_R
QuickBooks Team

1099 Transaction Detail Report

Your issue ends here, @ehh1212.

 

As stated by my peer MonicaM3 above, the reason why the report doesn't populate data is that you haven't assigned a form for the vendors. Since you aren't able to find the "Prepare 1099" in your QuickBooks software, allow me to provide a screenshot for your visual reference. 

 

Depending on your QuickBooks version, may I know which one are you using? If you're using QuickBooks Online (QBO), you can find it in the Vendors menu.1.PNG

However, if you're using QuickBooks Desktop (QBDT), you can prepare 1099s by going to the Vendors menu and selecting 1099 Forms, then Print/E-file 1099 Forms. For more guidance, feel free to check out this article: Create and file 1099s with QuickBooks Desktop.

2.PNG

You might also want to read this article to learn which payments should be excluded from the 1099-MISC and 1099-NEC form: What payments are excluded from a 1099-NEC and 1099-MISC?

 

Please know that I'm just a reply away if you need any further assistance preparing your 1099. Wishing you and your business continued success.

ContractorsPlus
Level 2

1099 Transaction Detail Report

What if your version of QB doesn't have an expenses tab?

 

Mark_R
QuickBooks Team

1099 Transaction Detail Report

Thank you for joining the thread, @ContractorsPlus.

 

May I know what version of QuickBooks you're using? Please keep in mind that all QuickBooks versions (Desktop or Online) had an Expenses menu. If you can provide more details on your concern, it would be greatly appreciated. This way, we can provide the best resolution based on the QuickBooks version you're using.

 

Please know you can continue to reach me here with your additional questions. I'll be standing by for your response.

Steven41
Level 1

1099 Transaction Detail Report

I am not fond of this solution. I use an outside provider to run payroll and prepare my 1099's, but I want to run the 1099 transaction detail report to ensure that what I've entered in QB ties to what is in the payroll system by quarter. Is there any other way to generate data for this report based off the "Track payments for 1099" being checked? If the only solution is to go through the 1099 processing every time you want to reconcile this data this is a major inconvenience. I have other painfully manual ways to reconcile this (download ALL expense transactions then mark vendors as 1099 or not by transaction, then do a reconciliation of what is paid vs. not paid), but I'd like to see the 1099 reports work without going through prepare 1099 processing. 

Catherine_B
QuickBooks Team

1099 Transaction Detail Report

Hello there, Steven41.

 

If you're using QuickBooks Online, you still have the option to run the 1099 detailed report just make sure that the mapping of expense accounts are correct. To help you, you can use this link on how to run and modify your chart of accounts for your 1099-MISC and 1099-NEC filing.

 

Keep me posted if there's anything else that you need help with. Take care!

miniprincess
Level 2

1099 Transaction Detail Report

I know this is an older thread but what I find so strange is that 2 weeks ago (November 2021) we pulled a 1099 transaction detail report without any issue at all to double check a few things. This week we attempt to pull one for one of our agents that needs the report to provided to a mortgage lender and the report doesn't pull at all, it's blank....we've been using QBO and doing our 1099s out of it for 3 years now and all 100+ agents are in there and have been the whole time and this problem JUST started since November for us. So all the solutions that we need to start the entire 1099 process just cannot be accurate because how did I have it 2 weeks ago and now it's disappeared. I 110% know they're all checked for tracking 1099s because they've also received one through QB without any issue. I wish someone would stop telling us answers that are work arounds and that someone from Intuit could chime in and let us know how it just randomly stopped functioning. This is also in QB online and mine is always up to date so I know that isn't the issue either. Any word anyone else has found would be appreciated as well. Super Confused~Megan

AileneA
QuickBooks Team

1099 Transaction Detail Report

There are times that local internet cache files stored in the system can cause unexpected behavior in the product, miniprincess. 

 

When a browser's cache storage is full or corrupted, it can cause error messages or not loading on certain webpages in QuickBooks Online. Let's rule this out by using an incognito or private browser:

 

Here's how: 

 

  • For Google Chrome browser: Ctrl + Shift + N
  • For Mozilla Firefox browser: Ctrl + Shift + P
  • For Safari browser: Command + Option + P

 

If it works, go back to your regular browser and clear the cache to delete those temporarily stored files and browsing history. The overtime collection of data can create corruption, however, removing this should fix the issue. You can also use other supported, up-to-date browsers to roll out the possibility of a browser-related issue.  

 

If the same thing happens, I'd suggest reaching out to our QuickBooks Support team. They'll be able to pull up your account and screen share with you. 

 

Let me know if there's anything else I can help you with regards to your QBO account. I'm just a post away from you. Keep safe!

Coldham
Level 2

1099 Transaction Detail Report

I'm curious about having to prepare 1099s before being able run a 1099 Transaction Detail Report as well. 

I see that I ran it last year before we prepared our 1099s. 

🤦‍♀️

ReymondO
QuickBooks Team

1099 Transaction Detail Report

Hi there, @Coldham.

 

Yes, you can prepare your 1099s before running the 1099 Transaction Detail Report in QuickBooks Online Payroll.

 

Here’s how to get your 1099s ready to e-file or print. These steps walk you through organizing your contractors and payments so your filings are correct.

 

  1. Go to the Payroll menu, then select Contractors.
  2. Click Prepare 1099s and then Let’s get started.
  3. Make sure your company name, address, and tax ID is correct and matches what's found on tax notices or letters from the IRS.
  4. Select the boxes that represent the type of payments made to all of your contractors this year, then select Next
  5. Verify that all of your contractors show up and their personal info and email addresses are correct.
  6. Review the payment totals for each box you selected in step 4. The payments will be automatically separated between the 1099-NEC and 1099-MISC forms.
  7. Click Next.
  8. Select E-File for me to e-file your 1099s. Or select I’ll file myself to print and mail the forms yourself.

 

If you want to see what you’ve paid your contractors, you can run 1099 reports.

 

In case you have other 1099 queries, check out this article here: Get answers to your 1099 questions.

 

Let me know if you need further assistance with this. I'm always around to provide answers and clarifications to your questions. Have a great day ahead and take care.

girlboss111
Level 1

1099 Transaction Detail Report

If go to apps and features and run a repair on quick books 2021 it fixed the problem for some reason. Have no idea why but it worked.

Klarsenault1
Level 1

1099 Transaction Detail Report

Where is the expenses tab as noted below? I have the Desktop Pro 2020. I'm not able to go into my 1099 detail like normal.

 

I’m here to help with your 1099 Transaction Detail Report. In order to get that list populated, you will need to start the Prepare 1099’s process. The reason for this is to assign a form for the Vendors (ie: 1099-NEC, 1099-Misc, etc).  Here’s how:

 

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.

Once you have worked through adding that to the Vendor, you can cancel or exit out of the 1099 wizard, and your report will populate.

Where is the expenses tab? 

Klarsenault1
Level 1

1099 Transaction Detail Report

I don't have a 1099 tab under my vendors. Not able to run my 1099 report this year. Last time I ran it was last January.

LieraMarie_A
QuickBooks Team

1099 Transaction Detail Report

Hi there, @Klarsenault1. I'll show you how to pull up a 1099 report.

 

The steps provided by my colleague are for QuickBooks Online. To perform these in QuickBooks Desktop (QBDT), make sure to enable the 1099 option from your preferences. Doing this will allow you to access it from the Vendors menu.

 

Here's how:

  1. Go to the Edit menu and select Preferences.
  2. Select the Tax: 1099 tab and choose Company Preferences.
  3. Select Yes to file 1099-MISC forms.
  4. Click OK.

 

Once done, you'll be able to see the Print/E-file 1099s option under the Vendors menu. Also, make sure that your QBDT is updated. Then, follow these instructions on how to prepare the form:

  1. Go to Vendors, then select 1099 Forms, then Print/E-file 1099 Forms.
  2. Create a backup.
  3. Select Get started for the 1099 form you want to create.
  4. Select vendors that need a 1099 form and select Continue.
  5. Verify the vendor information is correct. You can edit any incorrect information by double-clicking on the section that needs updating. Select Continue.
  6. Map the vendor payment accounts. Go to the drop-down in the Apply payments to this 1099 box section. Select the account you want to link the payment to. If any boxes are gray, they are mapped to the other 1099 form. You only map accounts to one 1099 form. When complete, select Continue. Note: If you see a message in red stating your settings do not match the current IRS thresholds, select Show IRS 1099-MISC filing thresholds and choose Reset to IRS Thresholds.
  7. Review your payment information for exclusions. For more information on what can be excluded see What payments are excluded from a 1099-NEC and 1099-MISC?.
  8. Select View Included Payments or View Excluded Payments to see detailed reports. Select Continue.
  9. Review the vendors and amounts you're going to report. Select Continue. Note: If you want to see the vendors who don't meet the IRS threshold, select View Summary Report.
  10. Choose whether to print 1099s or e-file. If you choose to continue to e-file your 1099s, follow the steps in this article: Create and file 1099s.

 

Lastly, here's the steps on how to review your 1099 reports:

  1. Go to Reports.
  2. Select Vendors & Payables.
  3. Select either 1099 Summary or 1099 Detail.

 

I'm always around if you need further assistance with running your 1099 reports. It's my pleasure to help.

mccrayagency
Level 1

1099 Transaction Detail Report

did you ever figure this out? same thing happening to me right now. I was on the phone with QB support for over 30 minutes- cleared cache and everything they told me to do. The boxes are still not checked. It's going to take days to go through and recheck all of the boxes. They offered no further help and went as far as saying they'd never heard of this problem. It's interesting that we pay them monthly and pay to file 1099s on a deadline but they are no help and don't even offer a credit (I asked at the end). 

AnneMariee
QuickBooks Team

1099 Transaction Detail Report

This isn't the kind of experience we want you to have, @mccrayagency.

 

I appreciate you for performing troubleshooting steps to isolate the issue with your 1099s being unchecked. Let me now guide you towards the appropriate support to resolve this matter.

 

I understand that you've already contacted our live support team. However, I'd recommend reaching out to them once more. They possess the essential tools to investigate deeper into the unusual tracking behavior of your 1099 forms. Moreover, they can thoroughly review your account and offer real-time assistance in a safe and secure environment.

 

Here's a step-by-step guide on how to contact us:
 

  1. Go to the Help menu and select the Search tab.
  2. Then, click Contact Us.
  3. Then, enter a brief description of your concern and select Continue.
  4. Lastly, choose either Start a Chat or Get a Callback to start connecting with them.

 

You can check our support hours here: QuickBooks Online Support.

 

You can also check out this article on the frequently asked questions about 1099 forms: Get answers to your 1099 questions.

 

Your concerns are important to us. Please don't hesitate to use the reply button if you have any more questions about your 1099s. The Community is always ready to assist you. Keep safe.

Need to get in touch?

Contact us