allocate items sold to different income account?

Question

Hi there,&nbsp;My scenario is we sell same product (item) to domestic market and overseas. We would like to track the sales of these two markets. I set up 2 income accounts which are 4-1100 Domestic and 4-1200 Export. But it seems I can only attribut one to the item. Do I have to set up another item to record for the other income account? Thanks in advance.&nbsp;

fivegeesewines · Accepted Answer

Allright, I get it. It's a default account for non-item sales. Cheers...

steven_m · Answer

Hi&nbsp;fivegeesewines&nbsp;
&nbsp;
AccountRight will only allow for one account to be set up as the linked Income Account for Tracking Sales per item.&nbsp;
If you are wishing to use a different account you do have the following options:

Record a journal entry to transfer the required amount across to the new account after recording the invoice
Create a new item and use that for those transactions.
Change the linked account each time prior to recording an invoice

fivegeesewines · Answer

Thanks Steven,&nbsp;Among your suggestions, I choose option 3. Thanks again.

jennifer_kelly · Answer

Hi&nbsp;fivegeesewines&nbsp;&nbsp;As you can see MYOB posts all sales of the same item to the one GL Income account.&nbsp;However the GL is not the only place you can track things like the type of Customer or Market you sell into. Infact I would suggest that if using MYOB the GL is most definitely not the best place to do this type of tracking.I would not recommend changing the GL account attached to an item prior each sale, that is not efficient and will be prone to error.&nbsp;You can determine if each Customer is an Export or Domestic customer when you setup the Customer Card. Simply setup a Custom List called Customer Type and allocate each Customer to either Export or Domestic. See link below for how to use Custom Lists.Then invoice all wine sales using the one Item for each product.&nbsp;&nbsp;You will be able to run a Customer Sales report in MYOB and Filter to select only Export Customers etc.&nbsp;You may also like to look at the Advanced Reporting MYOB App Market Place&nbsp; for addon solutions that also provide very flexible reporting over Sales, Inventory, Margins etc&nbsp;As an example our Business Intelligence solution BI4Cloud will let you report over Sales and Margins by:Customer and Item Custom listsCustomer Location ( State, Country)Salesperson etc.See the following links for more details.Use Custom Lists to Categorise Customers and Items togetherSales - Understand your MarginsI hope this helps.

fivegeesewines · Answer

Hi Steven,&nbsp;In order to track different market sales figure, I found there is an Income Account setting in the Customer Card (see screen shot). I tried to set it as an different income account from the income account set in the item card. But when I press Ctrl-R to do a recap, it's still allocated to the income account set in the item card. My question is, then what is the function for this income account setting in the customer card? Thanks.&nbsp;

Forum Discussion

allocate items sold to different income account?

5 Replies

Related content

Manually allocating costs to different divisions

Account cannot be duplicated. Please select a different Account

Super account allocation

One line invoice with multiple accounting allocations

Updating item to a different income account

How to allocate bank transaction from personal account to business account

Double payment to different bank accounts

Importing QIF file and allocating accounts