Pulling a 1099 report

Hello, @suzannek1.

Currently, there's no single report available that displays the vendor, amount paid, tax ID, and address all together. However, I have a workaround for you. You can generate two separate reports: the Vendor Contact List, which includes the tax ID and address, and the Transaction List by Vendor, which shows the amount paid. Once you have both reports, export the data to Excel and merge the required information as needed.

Here's how:

1. Go to the Reports menu.
2. From the Find Report by Name drop-down, choose Vendor Contact List.
3. Select Switch to Classic View.
4. Click the Gear icon of the transaction.
5. Tick the Columns you wish to view.

6. Hit Save Customization.

Let's proceed with the Transaction List by Vendor report.

Here's how:

1. Go back to the Reports.
2. Type the Transaction List by Vendor in the Find Report by Name field.
3. Click Switch to Classic View.
4. Under the Transaction List by Vendor Report, filter the Report Period, and the Rows/Columns.
5. Hit Save Customization.

For more details, you can check this article that will help you personalize your reports: Customize Reports in QuickBooks Online.

Once done, you can now export your reports to Excel from QuickBooks Online. From there, you can then merge the information needed you wish to view when running a report.

Furthermore, you can utilize this article for your future reference when running a report.

Additionally, I'd like to recommend a service that I believe could be highly advantageous for you and your business. It's called QuickBooks Live Bookkeeping, a subscription-based service that offers ongoing support including assistance with the chart of accounts, monthly reconciliation, transaction categorization, proper monthly closure of books, and generating essential financial reports such as Profit and Loss and Balance Sheets. This could significantly streamline your accounting processes.

If you encounter any issues while running a report, feel free to leave a comment below and I'll be happy to assist you.

Thanks.  I have pulled those reports.  Is there a way to pull a vendor report with addresses for only the vendors paid in 2024?

Thanks for coming back here, @suzannek1.

At the moment, a report showing all 1099-paid vendors only in 2024 with their addresses isn't possible. I agree with my colleague's suggestion to pull up the Vendor Contact List and 1099 Transaction Detail reports. Then, export and modify the data in Excel to achieve your goal.

In the meantime, I recommend submitting feedback to our Product Development Team so they can review your suggestion about this kind of report. Once they see its utilization, they can consider adding this to our future product updates.

Here's how:

1. Go to the Gear icon and select Feedback.
2. Type in your comments or product suggestions. Then, choose Next to submit feedback.

Consider reading this article to learn how you can secure a report's customization copy for future use: Save a customized report in Quickbooks Online.

You might want to be reminded of your memorized report on a recurring schedule. Check out this article: Set schedule and email information for a memorized report in QuickBooks Online.

Never hesitate to reply to this post if you have additional questions about vendor transaction reports or any related concerns. We'll be willing to lend a hand. Keep safe, and have a good one.