Can I create a trial balance report that breaks up all balances by subsidiary across columns?

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that NetSuite does not provide a trial balance report that breaks up all balances by subsidiary across columns out of the box. However, there are a few workarounds that you can consider: 1. You can run the Balance Sheet and Income Statement reports with one column included by subsidiary. This might be the fastest way to get the data exported, but you would need to export two reports. 2. Another user mentioned creating a matrix report for GL data, using a web query to pull it into Excel, and then recreating the Trial Balance in Excel with sumifs. The 'Transactions' report was used for this, with the only filter being the date. All subsidiaries were included, and there was a column for subsidiary which allowed the Excel logic to split by subsidiary. 3. You can customize the Trial Balance report to group by each subsidiary. Here are the steps: • Go to Reports > Financial > Trial Balance > Customize • Name the report as 'Custom Trial Balance by Subsidiary' • In the 'Edit Column' tab, expand ‘Trial Balance’ > + Subsidiary > Expand > Click ‘Name’ • Move the new column to the far left so it’s the first column • Click on the first column (Subsidiary) > Check ‘Group’ if not already checked • Click on the second column (Account) > Check ‘Group with previous column’ if not already checked • In the 'Sorting' tab, expand ‘Trial Balance’ > + Subsidiary > Expand > Click ‘Name’ • Click ‘Add’ on the row that appeared on the right • Click on the row you added and move to top > Click Ok • Click ‘Save’ and you should see a full trial balance grouped by each Subsidiary. If you click on ‘collapse’ in the bottom right you will have a neat table of all the subsidiaries and totals. The new report should now be in Reports > Saved Reports and also available in the search Please note that these are workarounds and may not fully meet your requirements. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******