How can I efficiently manage multiple GL's for different products?

[jqueenSCFTA]

I don't know if anyone has dealt with this or not. I have multiple products whose sales go to different department GL's. Currently, we have the GL's setup as custom product types. We export a sales report, sort by product type, and make the calculations as to the amounts that go into each GL account. Is there a better or easier way of doing this?

Thank you!