How to import multi currency transactions into QuickBooks Online

If you are using QuickBooks Online (QBO) and need to import multi currency transactions (ie currencies that are not your home currency) then you can do that with Zed Axis.  When importing it is important to make sure that you have the following items set:
  • Ensure that the multi currency feature is enabled in your QBO Company File
When importing multi currency transactions please check the following:
  • That the Customer record in QuickBooks Online that you are importing the transaction to is set to receive payments in the currency you are importing.
  • That you map the field for Currency Ref that would be the three letter abbreviation for the currency ie (EUR, USD, CAD, AUD)
  • That you set the Exchange Rate that you would like to use for the transaction, this is the number of units of the home currency it takes to equal the foreign currency unit.  (by default QBO will set that to 1 if you do not set this)
 

Add Feedback