x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 2 replies
  • Subscribers 20 subscribers
  • Users 0 members are here
  • Views 816 views
Browse Forums
Announcements
122
topics
111
replies
General Discussion
5k
topics
12k
replies
Payroll & Tax
508
topics
690
replies
Reporting and Analytics
518
topics
1k
replies
Service Alerts
2
topics
0
replies
Software Development Kit (SDK)
413
topics
645
replies
Year End
68
topics
170
replies
Stephanie White 2010

How to print a report that give you the total spend by vendor

Posted By

I am trying to print a report that shows what we have paid (total spend) to each vendor by year. I know this information pulls if it is a 1099 vendor but how to I get these details for my vendors that I purchase all of my inventory from that do not require a 1099? I have tried and tried to put something together and export to excel but all the reports I have found zero out the totals. I am running out of ideas, please help! 

Parents
  • 0

    If you are interested in a simple report that shows you dollars only, then change your Accounting Period to the last period of your fiscal year, i.e. Period 12, and then run the Vendor List Report from the Accounts Payable Reports Menu. Using the Columns icon at the top of the report screen, add the columns for Payments for each of the 12 months of your Fiscal Year. You can then export this report to Excel, and total the 12 columns, or do any other sorting that you may need. https://pcosupport.com 800-780-0700 954-961-0600

Reply
  • 0

    If you are interested in a simple report that shows you dollars only, then change your Accounting Period to the last period of your fiscal year, i.e. Period 12, and then run the Vendor List Report from the Accounts Payable Reports Menu. Using the Columns icon at the top of the report screen, add the columns for Payments for each of the 12 months of your Fiscal Year. You can then export this report to Excel, and total the 12 columns, or do any other sorting that you may need. https://pcosupport.com 800-780-0700 954-961-0600

Children
No Data