HI, I have since found out that if you go to Project Reports within the project , then Project profitability, then Total Cost of sales (click on actual value) it brings up listing which can be exported to excel with the split amount of  the bill showing to the actual project.

It shows full amount of bill in the Transaction section only so if you export from transactions the full amount shows.

Bizarre, I know, but easier to get the info via Project Report within Project than all the work arounds QB are suggesting.