Location and Yard Based GL Mapping for Freight

We need a way to map the freight revenue for each location/yard to the appropriate GL account so we do not have to manually go into every invoice and move it to the correct GL account in our accounting system. Right now, everything is lumped into one GL account so you can not see PnL by location. Just company as a whole. It would also be helpful if we could do this using the "Class" feature in QBO but a work around would be to have a freight product in QBO for each location/yard and can default the QBO product to the correct class.

Desperately need this feature!