cancel
Showing results for 
Search instead for 
Did you mean: 
Karentrz
Level 1

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 -

This did not work for me. I can’t get it to print for just 2019

Emily M
QuickBooks Team

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 -

Thanks for joining in, @Karentrz.

 

I know how finding the right report can be tricky. I’m here to give you a few recommendations on which report may suit you and your business. 

 

You first want to start by looking at the Expenses by Vendor Summary and Expenses by Vendor Detail. Both of these reports show the company’s total expense. The Detail report gives you more information from where the totals were coming from. 

 

The next report you can check out is the Purchases by Vendor Summary and Purchases by Vendor Detail as these reports show the company’s total purchases. 

 

Lastly, you can also view the Transaction List by Vendor. This will show all transactions per vendor. 

 

For further information check out these articles below:

 

Customize reports 

Customize supplier reports

 

Don’t hesitate to reach back out to me if you have other questions. Take care.

Plinkr
Level 2

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 -

I too am in need to print a report, by TOTAL preferably, what was actually PAID to each of my vendors in a year's time.  Bills don't help because any number of bills may have NOT been paid for one reason or another.  I tried your report above, thought it was what I was looking for, but saw an amount that just wasn't right knowing we just issued several checks to said vendor within the last three months of the dates I entered, when I click on said TOTAL, it shows a list of BILLS, not the payments.  I do not need the bills to be on the report, JUST A TOTAL PAID TO VENDOR (check, online, auto deduct) whatever the payment process was.  I find it hard to believe this is so difficult for QuickBooks.  This should be an easy report....I've tried a few different ways, tried to filter JUST PAYMENTS, coming up with nothing.

EJ16
Level 1

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 -

When I select customize and filters, the only options are "vendor" "terms" and "due date"

AlcaeusF
Moderator

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 -

Hello @EJ16,

 

We want to help you with your concern about customizing a report. However, we need more information about it to provide the right resolution and to get this sorted out promptly.

 

Can you share with us the name of the report and the information you need to show? Any additional details will help us provide more accurate information.

 

In the meantime, you can check the following article for some information about how to personalize a report in QuickBooks: Customize reports in QuickBooks Desktop.

 

Drop me a comment below if you have any other questions regarding running reports. I'll be happy to help you some more.

StaceyKay76
Level 1

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 -

A couple of notes to this.

 

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.

 

Click Display, add amount to the column. It will add the bill/payment amount.

You can also select the Report date range

PrecisionJeff
Level 1

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 -

This does not work

JoesemM
Moderator

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 -

Good day, @PrecisionJeff.

 

I'd like to make sure we're on the same page so I can give you the right information. May I ask for extra details of your concern or screenshots would be greatly appreciated.

 

Don't hesitate and come back to the Community. I'm always here to help you. Have a great day, @PrecisionJeff.

PrecisionJeff
Level 1

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 -

The "Expenses By Vendor Detail" report is the report the person who originally posted this question was looking for, and that is the answer that all of the rest of us frustrated quickbooks users came here looking for.  All the other answers provided by intuit team members and moderators should be deleted from this thread to avoid further confusion and frustration.  None of us want to read through numerous answers from supposedly trusted sources because they have "team member" or "moderator" titles attached to their profiles, only to find out that their suggestions do not work.  So we continue scrolling through this thread to finally find the correct answer provided by another member. 

 

The thread is 4 years old and people are still coming here looking for the same answer, obviously keeping the thread open serves a purpose.  Dont you think wiping the wrong answers from here would be helpful?

heazim1
Level 3

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 -

I followed this.  All of the vendors say zero for amt paid. I'm trying to see which vendors I paid $600 to for a calendar year.

MichelleBh
Moderator

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 -

Let's review your vendor's transactions by running other reports, @heazim1.

 

I appreciate all the steps you've taken so far. I have ways to check which vendors paid $600 for a calendar year in QuickBooks Desktop. 

 

Ensure that you select the correct report period when running the reports so it'll show the accurate vendor amount paid. 

 

Once confirmed and the issue persists, I'd recommend running the Expenses By Vendor Summary or Transaction Details report one at a time. Then customize it to show all the specific information. For the complete steps, follow the instructions outlined by Fritz in the first thread. 

 

You can also run other reports mentioned in this thread. This way, you can review all the necessary details of your vendors. 

 

Further, check out these articles below on how to memorize and schedule reports in QuickBooks: 

 

 

If you have any other questions or concerns about reports, please let me know. I'm always here to assist you further. Take care, heazim1.

Nonee
Level 2

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 -

You are not understanding the question.  I have many vendors.  Five of them are employees, but my accountant does my payroll but I need to verify their numbers with mine.  So when I go to one particular vendor and go to quick report, it shows me every check I made out to him and the amount of that check.  What it doesn't do is give me the TOTAL of those checks.  Why?  Where can I get that total from ONE vendor?  Otherwise I have to print it and add it up my self.  It seems like something quickbooks should do.  Is there a way to do that?

DebSheenD
QuickBooks Team

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 -

Hi, @Nonee.

 

I see a duplicate post about your issue. My colleague has already responded and shared some information about this matter. 

 

Please check this link for your reference: https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/re-how-i-can-get-a-grand-to...

 

The Community is always here to help you out. Don't hesitate to drop a reply below.

JariC
Level 1

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 -

Thank you so much! Call to QB did not yield this simple answer like you did. Customer Service rep took charge of my screen and everything and couldn't figure out how to do this. I knew it had to be possible!

ReliableRoofing
Level 2

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 -

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. 

n1hipski
Level 1

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 -

This link does not work

Rasa-LilaM
QuickBooks Team

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 -

Thank you for joining this thread, n1hipski.

 

Your concern is important to us and we're committed to helping you. To ensure we address it correctly, we kindly ask for additional details. Our goal is to resolve this promptly and provide you with the assistance you need.

 

Before we proceed, could you specify which link you're referring to? Also, may I know the specific assistance you need? Additionally, did you face any difficulties while carrying out the task? Providing as many details as possible will enable me to assist you better in resolving the issue.

 

I'll be on the lookout for your response, n1hipski. Have a great rest of the day, n1hipski.

Need to get in touch?

Contact us