How can I create a trial balance report that'll list out the subsidiaries in their own columns, the accounts being the leftmost column, and in local currency?

AI generated answer (using internal Slack threads):

To create a trial balance report that lists out the subsidiaries in their own columns, the accounts being the leftmost column, and in local currency, you can follow these steps: 1. Navigate to Reports > Financial > Trial Balance > Customize. 2. Name your report, for example, "Custom Trial Balance by Subsidiary". 3. Go to 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. 4. Go to 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. 5. Click ‘Save’. You should now 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 this will give you one column of data per subsidiary. If you want a side-by-side comparison of each subsidiary, you might need to export the data and manipulate it in Excel or another tool. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

How do I get it in local currency?

Thank you for your feedback