Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
lindab2810
Level 3

Reply to message

Thank you for your reply.  I had already discovered that the Information Sheet under Prepare 1099's would only list last year's 1099 recipients.  That report was helpful for historical purposes.
I did the customization per your instructions for the Transaction List by Vendor.  The only change that I needed to make was that "payment" needed to be changed to "Bill Payment(Check)", since payment is specifically for Customer payments received.  
We have hundreds of vendors, so selecting the 1099 vendors was somewhat a process.  In addition, the Transaction List does not total the payments.  

My work-around was this:  I ran the Vendor Contact List, and customized the columns to include "Track 1099" ( I really had to do some searching for that).   I deleted the columns that I did not need for this report, and saved the customized report.  I exported it to Excel and re-sorted to only include the vendors that were Tracked for 1099's.  
Then I ran the Expenses by Vendor Summary (which has totals), and used my list from the previous report to filter the vendors that were tracked for 1099's  Using that list made it easier to identify the correct vendor from the very long selection list.  

This gave me a report for total YTD amounts paid to our 1099 vendors!

Quite a process for something that should be so simple.  

My suggestion would be to add a filter to the Vendor Summary List to "Track 1099."  That simple option would have saved me having to customize and run two separate reports.  
Better yet, why not just have a dedicated report for a 1099 summary?

Thanks for your help......it actually got me on the track for dong the work-around above.

Need to get in touch?

Contact us