Question
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.