Skip to main content
L
lindab2810
October 16, 2018
Solved

How can I print a YTD report of payments to 1099 vendors in QBO

  • October 16, 2018
  • 2 replies
  • 0 views

I need to print a YTD payments report for all 1099-identified vendors.  How can I do this in QBO?  

Best answer by arkvalleyinfo

Hello there lindab2810, 

If these vendor payments were from last year, you can follow these steps on generating the year-to-date report:

  1. Click Expenses on the left navigation panel.
  2. Select Vendors tab and click Prepare 1099s.
  3. Click the Continue your 1099s button.
  4. Follow the on screen instructions until you reach the Review 1099 vendors and payments window.
  5. Click the Print Information Sheet button.

If this is for the current year’s vendor payment, there isn’t a way to generate a report to show the payments made to your 1099 vendors. However, you can customize the Transaction List by Vendor report.

Here’s how:

  1. Click Reports on the left navigation panel.
  2. In the search field, type in Transaction List by Vendor.
  3. Click the Customize button.
  4. Select your preferred date on the Report period drop down arrow.
  5. Select Filter and click the Transaction Type drop down arrow.
  6. Put a checkmark in the Payment box.
  7. Put a checkmark in the Vendor box and click the drop down arrow to select your 1099 vendors.
  8. Click Run report.

Don’t hesitate to get back to me if you have further questions about customizing the report. 

2 replies

A
arkvalleyinfoAnswer
October 16, 2018

Hello there lindab2810, 

If these vendor payments were from last year, you can follow these steps on generating the year-to-date report:

  1. Click Expenses on the left navigation panel.
  2. Select Vendors tab and click Prepare 1099s.
  3. Click the Continue your 1099s button.
  4. Follow the on screen instructions until you reach the Review 1099 vendors and payments window.
  5. Click the Print Information Sheet button.

If this is for the current year’s vendor payment, there isn’t a way to generate a report to show the payments made to your 1099 vendors. However, you can customize the Transaction List by Vendor report.

Here’s how:

  1. Click Reports on the left navigation panel.
  2. In the search field, type in Transaction List by Vendor.
  3. Click the Customize button.
  4. Select your preferred date on the Report period drop down arrow.
  5. Select Filter and click the Transaction Type drop down arrow.
  6. Put a checkmark in the Payment box.
  7. Put a checkmark in the Vendor box and click the drop down arrow to select your 1099 vendors.
  8. Click Run report.

Don’t hesitate to get back to me if you have further questions about customizing the report. 

    L
    lindab2810Author
    October 16, 2018
    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.
      R
      RuthO
      November 28, 2018

      Thanks for sharing your work around. Have any suggestions for extracting out reimbursements that should not go on their 1099? Desktop had a way to remove payments that were not taxable income. I am regretting moving from Desktop to Online. I whole heartedly agree with you on your report suggestions!

       

      R
      radically_simple_accounting
      October 16, 2018

      I agree, this really needs to be fixed. It's a routine accounting task.. 

      We need a report of 1099 vendors, (any vendors with the 1099 box checked off), amounts paid to date (including checks, expenses and bill pay), limited to 1099 accounts or all accounts, and total for each vendor. 

      Plus, total of that report. 

      Referring to earlier post, I don't see the "print" option any longer under 1099's at all. Is it still there, and I'm missing it? 

      I'm going to try and create a report that works, or if anyone else does it first, please do tell. 

       

        L
        lindab2810Author
        October 16, 2018
        Good to see another user who recognized the absolute need for this simple report!  We don't need a "work-around that has to be tweaked every time it is run."  We just need a basic report EXACTLY like the one that can be produced in QB Desktop in a matter of seconds.  I can't imagine any valid reason that this cannot be done in QBO.  Even if you are using the automatic filing in QBO, you still need an easy report to verify total payments.
          Terms & ConditionsAccessibility statement