Is it possible to create a trial balance by subsidiary report using SuiteAnalytics Workbook? We need to workbooks, one in local currency and the other in USD, the subsidiaries will be in the columns.

AI generated answer (using internal Slack threads):

Yes, it is possible to create a trial balance by subsidiary report using SuiteAnalytics Workbook. You can create two separate workbooks, one for local currency and the other for USD. Here's a step-by-step guide on how to create a custom trial balance by subsidiary: 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’ 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. However, please note that this will still give you one column of data. If you want a side by side comparison of each subsidiary, you might need to use the Balance Sheet or Income Statement report instead. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******