cancel
Showing results for 
Search instead for 
Did you mean: 
mruffo
New Member - Level 1

p-card report for expense by vendor

Hi,

does anyone know how to generate a report that lists all purchases made in a given time frame and is sorted by vendor? 

I am looking to use this for year-end and month-end tracking.

Thanks!

1 REPLY 1
cjmarimo
Super User
Super User

Hello @mruffo ,

 

If you have Analysis or Intelligence (Cognos)

SAP Concur includes standard reports that support spend analysis and display vendor information. Two reports that could work well for this requirement are:

 

These reports provide transaction-level detail and include information such as Vendor Name, Transaction Date, Amount, and Employee.

 

You can access these reports by navigating to:

Reporting > Analysis - Standard Reports > Expense Processing

cjmarimo_0-1787610214992.png

 

Export the report to Excel (select the Excel Data format).

cjmarimo_1-1787610301038.png

 

Once the report is open in Excel, you can sort the data by Vendor Name or create a Pivot Table to analyze all purchases made within the desired date range.



✔️Hope this helps! Let me know if you have any questions✔️

  Best Regards,

  CJ