Splitting Liability on two balancing segments

Hi,

We have two balancing entities SBU and SITE in our CoA. So the CoA is like

LE.SBU.SITE.CENTER.ACCOUNT.SUB ACCOUNT.......

At the moment, our automatic offset method is set as 'Balancing'. However, using this offset method, we are finding that the liability lines for an AP Invoice with multiple lines across SBUs and SITEs. We would like the AP Liability lines to be splitted based on SBU.SITE and not just SBU. How can we achieve this?

Regards

Bhavesh