cancel
Showing results for 
Search instead for 
Did you mean: 
lhawkins1
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 -

 
Solved
Best answer December 10, 2018

Best Answers
ShiellaGraceA
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 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 solution in original post

41 Comments 41
ShiellaGraceA
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 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.

lhawkins1
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 -

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....?
lhawkins1
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 -

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!
minijsmith
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 -

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

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 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.
qbteachmt
Level 15

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 -

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

qbteachmt
Level 15

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.

FWtreas
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 -

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.

qbteachmt
Level 15

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.

Sharon19
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 -

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

FritzF
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 -

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.PNG59.PNG60.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!

Alexann
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 -

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]

FritzF
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 -

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!

Teresa401
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 -

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

Mark_R
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 -

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.

GalinMcMahon
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 -

Be very careful with this report.  I ran it exactly as suggested.  Customer "ABC" appeared with 3,428.00 total for the year.  I set a filter to only show amounts >= 600 and it removes ABC.  Now I get to start this project all over and do it manually!  

Nick_PDX
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 -

I'm sorry; however, that did not report what each and every vendor paid us for a date range.  This might work for vendors that you record a BILL for and then get paid. But it excludes all vendors that you've paid without creating a bill. These would include office supply shops, utilities, individuals, or stores that you physically go into to make purchases. All those vendors are recorded when you download your bank transactions, but don't have a bill created. I want to be able to get a list of all vendors and what they've paid us.

 

RCV
QuickBooks Team
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 -

We appreciate you for coming back and clarifying on what report you need, Nick_PDX.

 

You can run the Transaction List by Vendor report to run a list of vendors. Then, customize the Transaction Type option to show the list of vendor payments paid on you.

 

For more details, you can follow the steps below:

 

  1. Click Reports on the top menu.
  2. Choose Vendors and Payables.
  3. Tick Transaction List by Vendor.
  4. Hit Customize Report.
  5. Select Filters.
  6. Under Choose Filter, look for Transaction Type.
  7. Tap Transaction Type drop-down and tick Multiple Transaction Types. Then, place a checkmark on the vendor payment transactions (like Check, Payment, Bill Payment, etc.).
  8. Click OK. Then, press OK again.
  9. Adjust the period in the Dates field. Then, tap Refresh.

vendor 01.PNGvendor 02.PNG

I have an article here about running vendor reports and how you can customize them: Customize vendor reports.

 

To learn more about how QuickBooks generates the reports, you can check out this article: Understand reports.

 

Feel free to go back to this thread if you need anything else in running vendor reports. I'll be here to wait.

PRSadmin
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 -

I have been able to run the report with the solutions suggested, my only problem is I need the vendor contact information in the report to (address, email, phone) but I cannot find any way to get the YTD total paid AND the contact info, it is either one or the other :-(

JamesDuanT
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 PRSadmin,

 

Aside from the customization provided on the earlier replies, we can add columns to see the address and the phone number. Here's how:

  1. Open the report and click the Customize Report button.
  2. Select the Display tab and go to the COLUMNS section.
  3. Type address and mark the addresses you want to appear on the report.

     
  4. Type phone and mark Name Phone #.
  5. Click OK.

For the email address, you'll need to pull up and customize a separate report. 

  1. Click Reports at the top and select Vendors & Payables > Vendor Contact List.
  2. Click the Customize Report button and go to the Display tab.
  3. Type email and mark the email address fields you want to appear.
  4. Click OK.

After that, you can compare the data on both reports. You can also export and further customize them in Excel.

 

If you have a different report in mind, please let us know. We'll help you customize it to achieve the data you need.

PRSacct
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 was not helpful, when I run a report with YTD totals the columns option is not available.   This is exactly what I need, I need to be able to run the 1099 report (or a report that gives me what was paid to the vendor in a "total" and not a summary) WITH vendor's first and last name AND email & Phone number.  It seems like such a simple report, I cannot figure out why it is so hard to create.

ReymondO
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 providing additional information, @PRSacct.

 

For now, the option to run a 1099 report with vendor's full name, email, and phone number is unavailable in QuickBooks Desktop. I'll send feedback to our developers so they can review this and check if can add this feature in the future.

 

In the meantime, you can run two separate reports, then export them to excel file and merge them to view them as one. Here's how:

 

First, customize the 1099 Detail report to show the full name of the customer and the total amount.

 

  1. Go to Reports menu and click Vendors and Payables.
  2. Select 1099 Detail, then click Customize Report.
  3. Go to the Filters section and select the names of the customers you want to include in the report.
  4. Click Ok.

QBDT VENDORS 1099.PNG

Then, customize the Vendor Contact List  by phone and email.

 

  1. Go to Reports menu and click Vendors and Payables.
  2. Select Vendor Contact List, then click Customize Report.
  3. In the Display section, put a check mark next to each column that you want to appear in the report.
  4. Click Ok.

QBDT VENDORS and payables.PNG

Once done, you can export this transaction to excel and merge them. 

 

  1. Go back to those reports and click the Excel drop-down arrow.
  2. Select Create New Worksheet.
  3. Once done, merge them in your excel file.

export1.PNG

You can also memorize reports in QuickBooks if you want the same settings of the customized report to be available for future use.

 

Don't hesitate to tag my name in the comment section below if you have other concerns or questions. I'm always ready to help.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us