I think it's me who is not explaining this very well.
The problem: We have a parent subsidiary that records and pays the bills that are actually expenses of its child subsidiaries.
Transactions:
Vendor Bill recorded by the parent:
Debit: Expense
Credit: A/P
Vendor Bill Payment recorded by the parent:
Dr. A/P
Cr. Cash
We need to move the expenses from the parent to the child subsidiary and recognize intercompany due from and due to.
Parent:
Debit: Intercompany Due From
Credit: Expenses
Child:
Debit: Expenses
Credit: Intercompany Due To
Yes, we can manually record these as advanced intercompany JEs but we are looking for a more automated way.
In the vendor bills, we are tagging them to dummy Departments that represent the child subsidiary where the expense should go.
We created an intercompany allocation schedule per child subsidiary with the following Source details:
From Subsidiary: Parent
Intercompany Account: Intercompany Due From
Account: All Expenses
Department: Child A (dummy department)
Destination details:
Use Source Account/Credit: Checked
Subsidiary: Child A
Weight: 100%
The problem with this is we can elect to use the Intercompany Due To account for the child subsidiary. We are forced to use the Intercompany Due From from the source tab because we checked the Use Source Account/Credit box. But, if we don't check that box, then we would have to create separate intercompany allocation schedules per subsidiary and per expense account which is not sustainable.