Skip to main content
L
lhawkins1
December 11, 2018
Solved

I need to generate a report on what I paid vendors last year, with a total per vendor. This ought to be easy but I'm sure stuck -

  • December 11, 2018
  • 4 replies
  • 0 views
Original commenter did not share additional details
Best answer by ShiellaGraceA

Hi lhawkins,

Thanks for visiting the Community.

QuickBooks Desktop has a report called Unpaid Bills Detail that can be filtered to paid status.

  1. Click Reports at the top.
  2. Click Vendors & Payables, then Unpaid Bills Detail.
  3. Click Customize Report button, then Filters tab.
  4. Search filters to Paid Status.
  5. Choose Closed radio button.
  6. Click OK.
  7. Set the appropriate Transaction Date range.

Let me know if you need anything, and I'll be happy to help however I can.

4 replies

S
ShiellaGraceAAnswer
December 11, 2018

Hi lhawkins,

Thanks for visiting the Community.

QuickBooks Desktop has a report called Unpaid Bills Detail that can be filtered to paid status.

  1. Click Reports at the top.
  2. Click Vendors & Payables, then Unpaid Bills Detail.
  3. Click Customize Report button, then Filters tab.
  4. Search filters to Paid Status.
  5. Choose Closed radio button.
  6. Click OK.
  7. Set the appropriate Transaction Date range.

Let me know if you need anything, and I'll be happy to help however I can.

L
lhawkins1Author
December 11, 2018
Hi and thanks for the feedback, I did the customization and am getting close but it does not give me a total amount paid for each vendor, it has all zeroes....?
qbteachmt
qbteachmt
December 11, 2018

Your 1099 reports can be used to meet this need. Once you open one of the reports (summary or detail), at the top you can remove the filters, to allow this to show for All names and All accounts.

    F
    FWtreas
    January 4, 2019

    Go to the Reports menu, click Company & Financial, and then click Expenses by Vendor Summary.
    This report shows your company's net expenses with each vendor.
    To see a list of the transactions that make up an amount, double-click the amount.

     
      R
      ROZA
      January 10, 2019

      The best answer.  Thanks

        qbteachmt
        qbteachmt
        January 10, 2019

        You don't want Net Expense. You want Gross.

          R
          ReliableRoofing
          July 28, 2023

          Go to Reports, Company Financials, Expenses by Vendor Summary.   Put your date range in and refresh. Then go to  customize report and change the report basis from accrual to cash. It will now show only what was paid and it will not include open payables. 

          Terms & ConditionsAccessibility statement