How to customize a cash statement report to show the cash balance at the end of a period in the currency of that bank in the chart of accounts?

AI generated answer (using internal Slack threads):

To customize a cash statement report to show the cash balance at the end of a period in the currency of that bank in the chart of accounts, you can follow these steps: 1. Customize a Trial Balance report that uses date (instead of period) as a filter. Select your specific account and add the Date to that filter. This will give you the balance of the bank account at the end of a specific date. 2. To show the balance in the currency of the bank, you may not be able to run a balance sheet that shows balances in foreign currency only. However, you can add an "Amount (Foreign Currency)" column to your balance sheet. This will show the balance in the currency of the bank. 3. If you want to create a summarized version of a balance sheet, you can use the Collapse, Expand options in the bottom right. Then you can set those on the Customize to give the initial opening expand position. 4. After that, go to the Edit Layout and edit your existing layout. This is where you can move accounts between sections, display sections by department instead of GL. 5. You can also add entire new Financial Section if needed. Adding a formula row is where you might give the summary some additional calcs like an EBITA or a GP%. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******