Skip to main content
K
Kaylamariem33
April 25, 2025
Question

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

  • April 25, 2025
  • 1 reply
  • 0 views

Our tax accountant is in a separate company from ours and prepares our 1099’s each tax year. They have requested that we provide them with a report of all vendors that we paid over $600.00 in that tax year. This would need to be a grand total of expenses over $600.00, and not individual expenses. They also requested that in the report of the grand totals there should also be columns for the EIN/SSN and address of the vendor.

 

Can you please advise if there is a way to create this report? I have only found an expense report that lists all the transactions but then I have to calculate the grand total myself.

 

Thank you so much.

 

Example below: 

 

Vendors: Total paid in 2024TaxID: Paid for Address
Example vendor name$$$$EIN or SSNExample category (rent, supplies, etc) Example address 
Example vendor name$$$$EIN or SSNExample  category (rent, supplies, etc) Example address 
Example vendor name$$$$EIN or SSNExample  category (rent, supplies, etc) Example address 
Example vendor name$$$$EIN or SSNExample  category (rent, supplies, etc) Example address 

 

1 reply

B
BabyB
April 25, 2025

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.

K
Kaylamariem33Author
April 25, 2025

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! 

 

 

FishingForAnswers
FishingForAnswers
April 25, 2025

@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.

Terms & ConditionsAccessibility statement