Buy now and save 90% off today
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
ABDUL-BASITH
Level 1

Why are USD Amazon Seller transactions not converting to HKD during reconciliation in QuickBooks, and why can’t they be auto-classified using existing product items?

My Amazon Seller account transactions are denominated in USD, while the home/reporting currency of my QuickBooks account is Hong Kong Dollars (HKD). During the reconciliation process, the USD amounts are not being automatically converted into HKD using the applicable exchange rates. The transactions appear in USD, and QuickBooks does not apply currency conversion when matching or reconciling these transactions, which results in incorrect balances in HKD reports. In addition, I am unable to automate the classification of Amazon transactions based on the existing product/service items already set up in QuickBooks. The transactions do not map correctly to the corresponding product items, preventing automated posting of sales and related fees to the appropriate accounts. This setup is making reconciliation and reporting difficult, as both currency conversion and item-level classification require manual intervention.
2 Comments 2
TrixieD
QuickBooks Team

Why are USD Amazon Seller transactions not converting to HKD during reconciliation in QuickBooks, and why can’t they be auto-classified using existing product items?

Hello there, Abdul.

Thank you for bringing this to our attention. I understand the importance of managing your currencies properly to ensure accurate reconciliation and reporting, especially when working with multiple currencies. 

QuickBooks is designed to allow users flexibility in managing foreign currency transactions, such as USD from your Amazon Seller account, when reconciling into your home currency (HKD). As part of this process, exchange rates can be manually applied to ensure accuracy in your reports. 

The multi-currency feature in QuickBooks allows you to set up and manage exchange rates, giving you control over your transactions. However, these rates are not automatically applied to transactions imported from third-party platforms like Amazon. Furthermore, Amazon uses its own exchange rates for processing, which may result in slight differences in balances when compared to QuickBooks. 

We recommend continuing to manually manage these transactions, especially when working with different currencies, to ensure accurate reconciliation and reporting. This process ensures that balances in QuickBooks fully align with the actual amounts reflected in your Amazon account.

If you have any additional concerns, please notify us. We're here to help.

SIAB
Level 7

Why are USD Amazon Seller transactions not converting to HKD during reconciliation in QuickBooks, and why can’t they be auto-classified using existing product items?

You may need a 3rd party connector to do so.