Exporting Concur Expense

[zhengh35]

Hello Everyone,

is there a way on Concur for me to extract and export all the expense reports for the month/yeah that have been processed for payment into one excel file?

Thanks

Tim

[KevinD · Accepted solution]

@zhengh35 from the Processor screen you can create a query with the specified date range and the Approved status. When you run the query from the Processor screen, the results will appear. At the bottom of the screen there is an Export to Excel option. 

Have you built your own queries from the Processor screen before?

[lweinzap]

I am having the same issue.  I see how to do this and I have done for INVOICES.  I now need to get my credit card EXPENSES for the year exported to Excel and cannot see where/how to do this.  I was able to pull up the list but do not find the export to excel option at the bottom.

[KevinD]

@lweinzap there isn't an option to export your card transactions to Excel.

May I ask, why you need a list of credit card expenses for the year in Excel?

Also, can you provide a screenshot of where you pulled up the list of transactions, please?

[amykoch]

Hi!  I am not the original poster, but I have the same question.  I would like to export all of my year's expenses into excel so I can easily add up how much I have spent by category.  My budget is categorized (TeamBuilding, Meals, etc), so keeping up with it by category is important.    Without an export option, I will need to manually copy over each expense into excel so I can sort and add, as it doesn't even appear that there is a copy/paste option in the "View Transactions" section. 

[KevinD]

@amykoch the only way you can do what you are asking is if you have access to Cognos reporting and build out this report. That is the only way to use categories and see all the data in one file. 

The alternative is if you are a processor and build a query that returns only your reports. Then you can use the Export to Excel option.

Cognos is a better option and can show a lot more details than what you would see exporting from the processor screen.

[amykoch]

Thanks for the response.  I ended up manually re-typing all 94 expenses into excel.  It would be super helpful if exporting was an option, or at least the ability to highlight, copy and paste.  I am sure that anyone who works with a budget would find this extremely useful!