Help with a creating a report to provide to our tax accountant? Grand total of expenses including addresses & EIN/SSN

You can pull up multiple reports, export them, and consolidate them outside QuickBooks, Kayla. I'll provide details on this alternative to help you extract the specific data you need.

The option to generate a report that includes expenses over $600, EIN/SSN, and addresses for your vendors is currently unavailable in QuickBooks Online (QBO). With this, you'll have to run different reports and combine them manually.

To begin with, let's generate a Vendor Contact List to view and save your vendor's Tax ID and addresses. It's important to select the appropriate filter to get the specific information. I'll show you how:

1. Go to Reports.
2. In the search field, type and select Vendor Contact List.
3. On the report page, click Switch to classic view.
4. Click the small Gear icon, then select Show More at the bottom left.
5. Check the Vendor, Tax ID, and Address box, and click Run report to apply the changes.
   
   

    

After that, to view the total expenses and corresponding categories, let's pull up the 1099 Transaction Detail report. Here's how:

1. Go to Reports.
2. In the search field, type and select 1099 Transaction Detail report.
3. Click the small Gear icon to customize the filters.
   
   

Lastly, export them to Excel by clicking the Export icon located on the left side of the small Gear icon. Then, manually modify the data to combine the reports and include the information you need.

I'll share this article to help you prepare your 1099s seamlessly, using the information you already have: Create and file 1099s.

Keep us notified if you require additional details regarding your reports of all vendors in QBO. Just add the details below and we'll address them promptly.

Thank you for your reply. "1099 Transaction Detail Report" but I no information came up. There is a note at the bottom of the report that says "NOTE: The report will pull the transactions that have been mapped to a box when preparing the 1099 forms. To map transactions to boxes, go to Payroll, Contractors, and click on "Prepare 1099s". The second step of the 1099 preparation exerience will let you map your accounts to the 1099 boxes" 

Our tax accountant prepares out 1099's so I do not think that is the route I want to take. 

Is there anything I can do in the "Vendor" or "Contractor" tab that would make information show up in the "1099 Transaction Detail Report"? 

Thank you! 

@Kaylamariem33  "Is there anything I can do in the "Vendor" or "Contractor" tab that would make information show up in the "1099 Transaction Detail Report"?"

Yes; you can follow the instructions you listed.

Regardless of whether you prepare the 1099s yourself, the system is not going to know that the transactions in question should go on a 1099 unless you tell it that it is so.

Thanks for following up on this thread, Kaylamariem33.

I'm happy to provide some additional info about the 1099 report in QuickBooks Online.

At this time the steps mentioned by my colleague above are the best way to achieve the desired report results. You may consider either you or your accountant completing the prompted steps to map the accounts to the 1099 boxes.

For additional ways to edit the report, I recommend submitting feedback to the Product Development Team for review. This can be done directly through your QuickBooks account by clicking the Gear icon in the top right corner then select Feedback.

Please feel free to drop a comment below if you have any other questions. I'll be here to help in any way that I can.