Create Taxable Transactions in Spreadsheet functionality for multiple legal entities in one ledger

Summary:

Create Taxable Transactions in Spreadsheet functionality creates unwanted intercompany balancing lines when multiple legal entities are assigned to one ledger

Content (required):

We have an enterprise structure setup where multiple legal entities are assigned to one single ledger. And we would like to use the Create Taxable Transactions in Spreadsheet functionality to do some manual adjustments to the VAT declaration.

Based on the documentation of the Create Taxable Transactions in Spreadsheet functionality, we understand that the tax rate accounts should be entered on the ledger without specifying the business unit. In that case we can only choose one BSV for one specific legal entity. However when we then load taxable transactions for other legal entities this creates unwanted intercompany balancing lines in the journals as the BSV of the tax line is different from the BSV on all the other lines.