Skip to main content
January 7, 2021
Solved

1099 Transaction Detail Report

  • January 7, 2021
  • 3 replies
  • 0 views

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.

Best answer by MonicaM3

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!

3 replies

January 7, 2021

I also have the same problem. 

MonicaM3
MonicaM3Answer
January 7, 2021

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!

DougSwainAuthor
January 8, 2021

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.    

January 20, 2022

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.