I am looking for a way to split expenses amongst people in our company without duplicating the total. We purchase company merch/promo items and that expense goes under our expense table and is assigned to 1 of our 7 offices, or corporate. We assign all promo expenses to "corporate". We then have an Inventory and an orders table. I add the inventory in as we buy more and add that to our expenses. Then, as the items are distributed to employees and partners those go under the orders table. The issue is the full expense amount remains under "corporate" instead of splitting it amongst the employees (who are assigned to a branch in the employees table) based on what is distributed to them in the orders table.
