Currency problems when exporting Company Card expenses into Quickbooks Desktop
I have been working with the import spreadsheet option with the Company Cards. The mapping is working correctly; and if I look at the expenses in Expensify, it shows the amount in CAD as the expense amount, and underneath, in italics, it shows the amount in USD (original currency). The total matches the statement balance for a given period.
But when the completed report is imported into QuickBooks, it imports the CAD total into the USD amount field, and then applies an arbitrary exchange rate, making the expense drastically higher (I should say probably QB is applying the arbitrary exchange rate). I will also note that I can't figure out how to import the exchange rate, which is part of the problem, as I think QB needs that to be populated.
Is there any way to fix this?