multi subsidiary balance sheet report

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that you can create a multi-subsidiary balance sheet report in NetSuite by selecting "subsidiary" from the column list when your consolidated base currency is in USD. This will show everything in USD in consolidated mode. However, if you are already using Departments at the column level, it's not possible to use two columns, one for Subsidiary and one for Departments, within the same report. One workaround suggested is to use the Multi-Book feature, but it's not recommended to turn it on just for this purpose as there are other impacts from that feature. Alternatively, you can mimic the desired output in saved searches or new suite analytics with multiple columns, as it's not possible with reports. For OneWorld, NetSuite requires 4 lines per advanced intercompany journal entry to maintain a balanced general ledger for each subsidiary. If you have the Intercompany AP/AR accounts configured and set as the defaults under Accounting Preferences, you can use the Auto Balance feature for NetSuite to make the offsetting posting for each entity. For a consolidated trial balance report, one approach is to run the Income Statement page and set the column to subsidiary, and do the same for the Balance Sheet. This will show each subsidiary's currency, and auditors can create their own trial balance from that. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******