Hotel receipt does not match credit card charge

[E10173398]

Hello. I recently made a business trip to Germany and used my corporate card to pay for the hotel. The receipt I received is in Euros, but the credit card charge is in USD and they do not match. I am getting an error that my itemizations do not add up to the card charge and will not allow me to submit the expense report. How do I reconcile this on my expense report?

Thanks.

[cjmarimo · Accepted solution]

Hello @E10173398 ,

I would take the corporate card amount (USD) as the correct amount to reconcile, since it is the actual amount that will be posted.

To ensure the report can be submitted correctly, you should base the itemization on the total card amount by following these steps:

Take:

The total amount of the receipt in EUR.

The total amount charged to the card in USD.

Calculate an effective exchange rate:

Exchange rate = USD amount (card) / EUR amount (receipt).

Adjust the exchange rate on the receipt to reflect the effective exchange rate: modify the exchange rate so that the total in USD matches exactly the credit card charge.

Create the itemization:

Enter each line in EUR.

This way, the total of the itemizations will match the card charge exactly.

Hope this helps! ✔️ 

Best Regards,
CJ