Skip to main content
R
rltidd27
October 30, 2021
Question

Quickbooks desktop, vendor transaction list with totals

  • October 30, 2021
  • 2 replies
  • 0 views

Want to run a report showing monies spent with vendors, with totals by vendor for this fiscal year.
Seems that when I do a search, the answer always applies to QBO, not desktop.

TIA for any help!

    2 replies

    M
    Mark_R
    October 30, 2021

    I've got you covered, @rltidd27.

     

    The Purchases by Vendor Detail is the best report you can run to view your vendor transactions with total. Let me guide you through the process.

     

    1. Open your QuickBooks Desktop company file.
    2. Go to the Reports menu, then select Purchases and choose Purchases by Vendor Detail.
    3. In the Dates drop-down, select This Fiscal Year.
    4. Then, click Refresh. 

     

    From there, you'll be able to see the total amount by vendor, and their balance as well. I'm adding this article to learn how to customize vendor reports in QuickBooks Desktop: Customize vendor reports.

     

    You might also want to memorize reports in QuickBooks Desktop. This way, you do not have to go through the customization process again.

     

    Should you need any assistance running reports in QuickBooks Desktop, I'm available here to help any time!

      R
      rltidd27Author
      October 31, 2021

      Thanks for the response!

      However, when I look at my transaction list by vendor, I have bills that do not show in the purchases by vendor.
      I had one transaction that was $3100, and in the purchases by vendor detail, that vendor shows a total for the year of only $311.

       

      LieraMarie_A
      LieraMarie_A
      October 31, 2021

      Let me share some info about these reports, @rltidd27.

       

      The Transaction List by Vendor report displays all transactions entered for each vendor. The Purchases by Vendor Detail report only shows the total amount for all of your vendors' purchases. These are transactions that involve inventory items. Hence, rather than the Items tab, any entries entered in the Expenses tab won't show.

       

      You can verify this by running the Transaction List by Vendor report and opening the bill of $3,100.

       

      Here's how:

      1. Go to the Reports menu.
      2. Choose Vendors & Payables and select Transaction List by Vendor.
      3. In the Dates drop-down, select This Fiscal Year.
      4. Double-click the bill to view its detail.

       

      You can also export your reports so they can be saved, stored, and transferred digitally if needed.

       

      Please let me know if I can be of any further help with understanding reports. I look forward to being able to help you again in the future.

      R
      rauder
      January 31, 2024

      Well after extensive searching for an answer, I finally solved the issue for my use case. To run a Vendor Transaction List with totals, go to Reports -- Company & Financials -- Expenses by Vendor Summary or Vendor Detail. I found that no custom filtering was required.

      Terms & ConditionsAccessibility statement