Skip to main content
lhawkins1
Dec 11, 2018 5:27 AM UTC
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 -

Original commenter did not share additional details
ShiellaGraceAAnswer
Dec 11, 2018 5:27 AM UTC

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.

View in thread

41 replies

ShiellaGraceAAnswer
Dec 11, 2018 5:27 AM UTC

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.

lhawkins1Author
Dec 11, 2018 5:27 AM UTC
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
Dec 11, 2018 5:27 AM UTC

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.

    FWtreas
    Jan 4, 2019 3:06 AM UTC

    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.

     
      ROZA
      Jan 10, 2019 12:55 AM UTC

      The best answer.  Thanks

        qbteachmt
        qbteachmt
        Jan 10, 2019 5:12 PM UTC

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

          ReliableRoofing
          Jul 28, 2023 7:35 PM UTC

          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