cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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 -

 
Solved
Best answer 12-10-2018

Accepted Solutions
QuickBooks Team

Hi lhawkins, Thanks for visiting the Community. QuickBook...

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.

17 Comments
QuickBooks Team

Hi lhawkins, Thanks for visiting the Community. QuickBook...

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.

Not applicable

Hi and thanks for the feedback, I did the customization a...

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....?
Not applicable

I got the amounts in the report now but it is giving me p...

I got the amounts in the report now but it is giving me payables back to 2007, can't get it to do last fiscal year.  Should not be this difficult to figure out how much I paid each vendor last year!
Not applicable

did you ever get it figured out?  I sure can't.

did you ever get it figured out?  I sure can't.
Established Community Backer ***

This has been answered: Your 1099 reports can be used to...

This has been answered:

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. I just did this today, in a real file. It works great. Run the 1099 Summary or Detail report and change the settings at the top to All Vendors and All Accounts.

1099-Misc is a Calendar Year activity.
Established Community Backer ***

Your 1099 reports can be used to meet this need. Once you...

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.

Established Member

Re: 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 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.

 
Active Member

Re: 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 best answer.  Thanks

Established Community Backer ***

Re: 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 don't want Net Expense. You want Gross.

Established Member

Re: 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 -

For my purposes, I would want net, not gross. Net reflects credits for returned items and for other refunded amounts and would therefore be my final cost expended for that vendor. That is all that matters.

Established Community Backer ***

Re: 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 -

"Net" is usually the Banking amount. But Gross includes reductions for Returns. What it should not include is, for instance Deductions for Prepayments or Holdbacks such as vendor Tax needing to be passed to an Agency, such as construction Contractor tax is held back from the Gross construction payout and sent to the State.

 

Obviously, it depends on the Purpose. For example, 1099-Reporting doesn't include payments to suppliers of Products, unless the product costs are incidental to the services provided. And debt principal is not included.

Active Member

Re: Hi lhawkins, Thanks for visiting the Community. QuickBook...

i tried that but nothing came up in the report I need it one vendor

QuickBooks Team

Re: Hi lhawkins, Thanks for visiting the Community. QuickBook...

Thanks for joining this conversation, @Sharon19.

 

Allow me to chime in for a moment and help make sure you'll get the report that you need in QuickBooks Desktop (QBDT).

 

Are you trying to pull up a report that'll show the total amount paid for your vendor as well? If so, you can pull up either the Expense by Vendor Detail or the Summary report. Here's how:

 

1. Go back to the Reports menu, then pick Company & Financial on the drop-down.
2. Choose either the Expense by Vendor Detail or the Summary.
3. Click the Customize Report option at the upper left, then enter your preferred date in the Report Date Range section on the Display tab.
4. Now, go to the Filters tab.
5. On the Choose Filter section, select the following:

  • Name - Vendor name.
  • Paid Status - Closed.

6. Click OK.

 

That should give you the report that you need. I also added some sample screenshot for your guide.

 

58.PNG 59.PNG 60.PNG


For future reference, you can also check out this article for more information: Customize vendor reports.

 

Please let me know how it goes or if you're referring to something else in the comment section. I'll be here should you need further assistance. Wishing you all the best!

Active Member

Re: Hi lhawkins, Thanks for visiting the Community. QuickBook...

Thanks but No total on the QB report!  Been working with this software for 15 years and never have been able (not a prolonged try :-)) to get a total to print for payments (checks) unless I shoot it over to Excel.  Have QB Pro - do I need Enterprise or something?  Lost Sales Orders when I went from Ent to Pro.  Thanks for your help, much appreciated!  Alex   [email address removed]

QuickBooks Team

Re: Hi lhawkins, Thanks for visiting the Community. QuickBook...

Thanks for joining this conversation, @Alexann.

 

In QuickBooks Desktop (QBDT) Pro, you can create a custom transaction detail report that will show all the vendor payments checks. You don't need the Enterprise version to do this.

 

Here's how:

 

1. Open QuickBooks, then go to the Reports menu located at the top bar.
2. On the drop-down, Custom Reports and Transaction Detail.
3. Once pulled up, click the Customize Report option on the upper left.

4. On the Display tab, enter your preferred date in the Report Date Range section.
5. On the Total by drop-down, select Day.

277.PNG
6. Now, go the Filters tab and choose the following:

  • Name - Vendor name.
  • Account - All bank accounts.
  • Transaction Type - Bill payment.

7. Hit OK once done.

278.PNG

 

 

 

 

279.PNG

 

To learn more about customizing vendor reports in QuickBooks Desktop (QBDT): Customize vendor reports.

 

Please keep me posted if you have any other issues in the comment section. I'm more than willing to help. Have a wonderful day!

Active Member

Re: did you ever get it figured out? I sure can't.

I'm looking for the same report.  Want to create file folder labels for each vendor whom I paid within the last fiscal year.  Don't need those vendors whom we paid nothing, and don't need going back several years.  The Unpaid Bills report does not seem like it would be the natural report.  I need those bills that HAVE been paid over a specific time.

 

If anyone finds a way to run THIS report, please post.  

-Teresa

Madison,WI

QuickBooks Team

Re: did you ever get it figured out? I sure can't.

Hi there, Teresa.

 

The steps provided by my colleague above will help you pull up a report and get the data you needed. Pulling up and customizing the Transaction Detail report will show the bills that been paid for a specific time. 

 

By following the steps, you'll just need to change the Report Date Range to the Last Fiscal Year. This way, the report will show all the bill payment with a specific day.

 

Here's a screenshot on how it looks like.1.PNG

You might also want to read this article to learn more on how to customize reports: Customize Reports in QuickBooks Desktop.

 

As always, you can visit our QuickBooks Community help website in case you need tips and related articles in the future. 

 

Please know that you can always get back into this post if you have more questions. I'll keep an eye out on your response.