hello to the whole team.
when a product is sold abroad and the same product is sold domestically, and I want to track these sales separately in the balance sheet, which control account should I put in the field of the product tab in the inventory item?
i need an account check for foreign sales and an account check for domestic sales for the same product!!
I must be doing something wrong.
thanks
For sales in another currency you need to setup customers using that currency. You then issue sales invoices to that customer in their currency.
i am in EU i dont nees another currency but another account check. thanks
Sorry if I’m not clear, but when I sell the product named “product1”, I’ve linked it to a “domestic sales” checking account. when i sell it to another country it should go through the checking account to “foreign sales”. how? I’m missing something
You can create multiple inventory control accounts in Settings. It is up to you how you name these such as Inventory items Spain, Inventory items France, etc. You sell as per usual.
Thank you EKO.
do you mean that I can get several checking accounts for the same product or that I will get several names of the same product and there I will differentiate the checking accounts?
I do not understand what you mean by “checking accounts” - there is no such thing in Manager.
Please use terminology that is used in Manager - otherwise we have to guess what you are talking about
Again, there is no product in Manager only Inventory Items
sorry i mean controll acounts
Sales will not appear in the balance sheet, only inventory on hand shows in the balance sheet.
Sales appear on the P&L statement.
You do not use control accounts for the P&L statements but you can create separate inventory sales income accounts and then select these “Custom Income Accounts” when creating/editing inventory items.
1 Like
you are absolutely right
this means that for an Inventory Item named for example “box”, I should rename “box1” with Custom Income Accounts = internal sales and “box2” with Custom Income Accounts = external sales.
st it right?
Yes, but only if you also purchase the inventory separately for internal and external.
Using Custom fields and a Custom report may be a better option. (use “Classic Custom Fields” as the other type of custom fields do not yet work with Custom Reports).
I disagree with that.
I allocate all my stock purchases to the default inventory cost account but allocate sales to either online or shopfront.
Been working fine that way and gives me the reports I need as well.
@VACUUMDOG, that does not differentiate sales. All sales of the item shown will appear in your Store Sales account. @eperion is trying to distinguish sales by market.
Sure, but when you purchase the inventory how do you decide how to classify the item as LB775 or OS-LB775?
Yeah, I just looked deeper into that. Might have to rethink a few things. Looks like Batch Update is going to get one hell of a workout once I get it figured out. Inventory Locations might be the way to go??? 
just that. is there a solution or should I go with a different code in the inventory item?
thanks
You could try using an Inventory kit for the online sales - the sales could be recorded to a different income account but a single Inventory Item to record stock
when a product is sold abroad and the same product is sold domestically, and I want to track these sales separately in the balance sheet, which control account should I put in the field of the product tab in the inventory item?
Sales do not show up on the Balance Sheet but on the Profit & Loss statement
The Control Account is for the Inventory Items on the Balance Sheet - I don’t think you should distinguish between items held for domestic sales and items held for export sales if they are identical items - otherwise, how would you distinguish what was what when you purchase them
thanks at all