In Xero I need my Sales and Cost of Goods sold captured in different GL accounts based on product line items and customer location from my Shopify sales.
How do I used Shopify customer location (country)/ shipping address with product line item to allocate to relevant GL account? Below target Xero GL accounts are what I am trying to achieve:
GL Sales acc1: Product A (US Sales)
GL Sales acc2: Product B (US Sales)
GL Sales acc3: Product A (EU Sales)
GL COGS acc1: Product A (US Sales)
GL COGS acc2: Product B (US Sales)
GL COGS acc3: Product A (US Sales)
Appreciate your help!
Thanks!