Short Accounting Intercompnay transfer journal entry problem

This is accounting for Intercompany transfers for equipment  which is between a Parent company and a Subsidiary

Excel document is attached below.