cancel
Showing results for 
Search instead for 
Did you mean: 
Bisho
Level 2

Split Item Income into two Income Accounts

Hello,

 

I'm trying to accomplish the following through this example:

Item A costs $475 for production and $25 for packaging = $500 total item's cost price.

I add profit of $175  on the production and $25 on the packaging =  $200 total profit.

Hence the item's sales price will be $700.

 

I pay the production vendor and packaging vendor separately, each bill goes into separate expense account (production expense and packaging expense).

I would like to invoice my customer one line as Item A = $700 only without  showing it split as Item A production = $650 ($475 cost +$175 profit) and Item A packaging =  $50 ($25 cost + $25 profit).

But in the same time I DO want to know by the end of  the month or year via P&L or another kind of reports how much I made profit from each phase separately, production and packaging. 

Is there a way  to associate an item with 2 income account? if not, is there a workaround to achieve what I am trying to accomplish without splitting the Item on the customer's invoice into two sub-items?

 

Thank you,

 

Solved
Best answer December 30, 2018

Best Answers
Rustler
Level 15

Split Item Income into two Income Accounts

not really

to do that you would have to sell the two items separately, sell the item, sell the processing, since you do not want to do that then all you could do is create a group item, list those two service items in the group, and set the group to not print all items.

the above is doable but will take some attention to detail on a daily basis depending on sales volumn

View solution in original post

7 Comments 7
Rustler
Level 15

Split Item Income into two Income Accounts

not really

to do that you would have to sell the two items separately, sell the item, sell the processing, since you do not want to do that then all you could do is create a group item, list those two service items in the group, and set the group to not print all items.

the above is doable but will take some attention to detail on a daily basis depending on sales volumn

Bisho
Level 2

Split Item Income into two Income Accounts

Group item, what a brilliant workaround. It solved my problem and exactly achieved what I wanted.

Thank you very very much Rustler.

Bisho
Level 2

Split Item Income into two Income Accounts

Group item, what a brilliant workaround. It solved my problem and exactly achieved what I wanted.

Thank you very very much Rustler.

ERLAW1028
Level 1

Split Item Income into two Income Accounts

Thank for you this solution. I have a follow-up question to this. It is currently September. If I wanted to go back to January of this year and make changes to paid invoices to replace the original non-inventory item with the new bundle I created to show the split, is there a simple way to do this? How would you recommend Note: I will obviously not change the price simply the product or services that were listed in the invoice. Thank you, E from Canada

JamesM4
QuickBooks Team

Split Item Income into two Income Accounts

Hi there. Thanks for chiming in on this thread. In order to edit the previous paid invoices you'll have to manually locate and open the invoices and make the appropriate adjustments. Make sure your changes are saved after doing this. Is this what you've been doing before? 

ERLAW1028
Level 1

Split Item Income into two Income Accounts

Hello James,

 

Yes, this is what I have been doing. Will the customers be notified of these changes? No change to the amt of the invoice simply just the item will be changed from a non-inventory item to a bundle with the same name. I just want to make sure I have considered everything before I make modifications to paid invoices.

 

Thank you

JamesM4
QuickBooks Team

Split Item Income into two Income Accounts

I see what you're saying. When making edits such as the ones described above, the customer won't receive an update until you send the invoice again to them. Feel free to ask other questions, I'll be here. 

Need to get in touch?

Contact us