cancel
Showing results for 
Search instead for 
Did you mean: 
Sharon_W
Occasional Member - Level 2

How to Create an Expense Report with Amount with Transaction/Reimbursement/Credit Card Currency

Hi All,

 

Could you please advise how do I create an expense report that contains expense amount in transaction, reimbursement and credit card currency? The reimbursement currency is different from credit card currency

5 REPLIES 5
PoojaKumatkar
Frequent Member - Level 2

Hi @Sharon_W ,

 

Creating expense report with credit card transaction is same as you create any other expense report. Once credit card transactions get available under Available Expenses section, you can move those transactions to your expense report, fill in the required field and save. If credit card currency is different then system will automatically convert it into reimbursement currency.

 

Below is the similar article, adding it for your reference purpose.

PoojaKumatkar_0-1740650258771.png

PoojaKumatkar_1-1740650280518.png

 

If this answers your query, then please mark solution as accepted.

 

 

 

Thanks!
Regards,
Pooja
Sharon_W
Occasional Member - Level 2

@PoojaKumatkar, I tried to add credit card transaction amount to the report but the amount doesn't seem to be correct, the amount shown looks like credit card statement amount, not the transaction amount, is there anything I missed out for pulling the correct data?

PoojaKumatkar
Frequent Member - Level 2

Hi @Sharon_W ,

 

Once you move credit card transaction to expense report most of the information such as transaction date, vendor name, amount, currency such fields get auto populated and will be read only mode. You need to fill in remaining required fields and then save expense entry.

 

In case if credit card transaction currency is other than reimbursement currency then system will auto convert transaction currency into reimbursement currency. This is how it works.

 

Attaching sample screenshot for your further reference.

PoojaKumatkar_0-1740726953686.png

 

If you are getting any specific error, then you can provide here. If there is no error, then I think you can add remaining expense entries in report if there are any and can submit expense report.

 

Thanks!
Regards,
Pooja
Sharon_W
Occasional Member - Level 2

@PoojaKumatkar, sorry for confusion, I guess I didn't explain properly in my question. What I'm trying to do is to pull the report using BI, I need a expense report with credit card currency, reimbursement currency & transaction currency. I'm wondering if it is possible to get this report in BI

PoojaKumatkar
Frequent Member - Level 2

Hi @Sharon_W ,

 

I am assuming that you know how to build reports in Cognos Intelligence:

 

Follow below folder navigation:

  • Under Expense folder >> Expense Reports >> Report Header Information >> Amount (Reimbursement Currency) 
  • Under Expense folder >> Expense Reports >> Credit Card >> Credit Card Transactions >> Amounts

You can drag and drop the required fields as per your requirement in your report and run the report. 

 

PoojaKumatkar_0-1740741810987.png

 

PoojaKumatkar_1-1740741887795.png

If this answers your query, then please mark the solution as accepted.

 

Thanks!
Regards,
Pooja