How to import multi currency transactions into QuickBooks

You can import transactions into QuickBooks desktop (click here for QuickBooks Online) that contain a currency that is different from your home currency using Zed Axis. You must have multi currency switched on in the company preferences and be using a version of QuickBooks that supports multi currency.

When importing transactions that contain multiple currencies, QuickBooks will determine the currency to use based on the currency set on the Customer or Vendor record, it is not necessary to specify the currency (although you can map it as Axis uses this if it needs to create a new non home currency Customer or Vendor see screen shot above) however it is possible to specify an Exchange Rate that should be used for that particular transaction.  The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the "home" currency.

Troubleshooting common error messages

Error: The currency of the account must be either in home currency or the transaction currency.

Cause:  When importing a non "home currency" transaction then the Account Payable, Account Receivable, or Bank Account mapped and specified used must be the same currency as the Customer or Vendor used on the transaction you are importing, 

Resolution:  Check to make sure the APAccount (Accounts Payable) or AR Account (Accounts Receivable) or Bank Account that has been mapped has the same currency as the Vendor or Customer that is used on the transaction ie Canadian Dollar Accounts Receivable for a Canadian Customer.

 

Note The multi currency feature in pre-2010 non US editions of QuickBooks (ie Canadian, UK, Australian, etc). Old Multi-currency Module (applies to Canadian (pre 2010), UK (pre 2010) & Australian (all) Editions of Reckon Accounts). When importing transaction data into non US editions of QuickBooks you cannot have a combination of currencies in the one import file you must only import transactions that are of the same currency.  So that means all the Customers or Suppliers names must have the same currency on the QuickBooks record.  Also it is not possible to map the Exchange Rate field and specify a different exchange rate to use other then what is set in the currency list in QuickBooks.

If you experience a problem please raise a support ticket.