Vendor Reports and Filtering by Payment Date

Jaclyn Maloney

I am trying to find a report that will show me which vendors were Paid and the total amount they were Paid within certain time frames. I have tried every report that is listed in FE NXT and even tried just exporting the vendor list with certain filters. However, I have not been able to filter by the payment date ... only the transaction or post date which appears to be the invoice date and not the actual date the check was printed. Is there a way to run a report that will show me the vendors we paid and the total we paid them?? 


Thanks,

Jaclyn 

Christy Anderson

In NXT, you could run the Cash Disbursement Journal.  The report is set to filter by payment date.

You will want to make sure you sort by Payee Name and when selecting what to sort by, make sure you also select to 'Break' by Payee.  This will give you a subtotal per Vendor.  

It is a detail report per check, but will give you the totals per vendor you are looking for.


If you just want a Vendor list with total amount paid, then you could go to the Database View (FE7) and create a Vendor Query.  (Queries do not give a grand total, but could easily export to Excel.)   On the Output tab, select Vendor Name and under the 'Summary' section select 'Total Payment Amount'.  When you pick a summary field it allows you to have some additional parameters for that field.  So you can select payment date is between X and X (or whatever date frame you need).  

Note: If you only want to see vendors that were paid in the selected time frame, then add that Summary field to your Criteria tab as well: Total Payment Amount_1 is Greater than 0. This will give you only those paid in that time frame.

Can Sort however you need as well, by Vendor or Amount.