Split Item Income into two Income Accounts

Bisho · ‎December 29, 2018

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,

Rustler · ‎December 30, 2018

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

Rustler · ‎December 30, 2018

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 · ‎December 30, 2018

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

Thank you very very much Rustler.

Bisho · ‎December 30, 2018

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

Thank you very very much Rustler.

ERLAW1028 · ‎September 15, 2023

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 · ‎September 18, 2023

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 · ‎September 21, 2023

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 · ‎September 21, 2023

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.

Topics

Training

Community

Resources

Split Item Income into two Income Accounts