ReymondO
Moderator

Account management

Thanks for providing additional information, @PRSacct.

 

For now, the option to run a 1099 report with vendor's full name, email, and phone number is unavailable in QuickBooks Desktop. I'll send feedback to our developers so they can review this and check if can add this feature in the future.

 

In the meantime, you can run two separate reports, then export them to excel file and merge them to view them as one. Here's how:

 

First, customize the 1099 Detail report to show the full name of the customer and the total amount.

 

  1. Go to Reports menu and click Vendors and Payables.
  2. Select 1099 Detail, then click Customize Report.
  3. Go to the Filters section and select the names of the customers you want to include in the report.
  4. Click Ok.

QBDT VENDORS 1099.PNG

Then, customize the Vendor Contact List  by phone and email.

 

  1. Go to Reports menu and click Vendors and Payables.
  2. Select Vendor Contact List, then click Customize Report.
  3. In the Display section, put a check mark next to each column that you want to appear in the report.
  4. Click Ok.

QBDT VENDORS and payables.PNG

Once done, you can export this transaction to excel and merge them. 

 

  1. Go back to those reports and click the Excel drop-down arrow.
  2. Select Create New Worksheet.
  3. Once done, merge them in your excel file.

export1.PNG

You can also memorize reports in QuickBooks if you want the same settings of the customized report to be available for future use.

 

Don't hesitate to tag my name in the comment section below if you have other concerns or questions. I'm always ready to help.