how can i show the net profit/loss in a custom saved search replicating income statement

AI generated answer (using internal Slack threads):

To show the net profit/loss in a custom saved search replicating the income statement, you can use formulas and groupings based on account types. Here's a general approach: 1. Create a new Transaction Saved Search. 2. In the Criteria tab, you can set the following filters: - Period is This Fiscal Year - Account Type is Other Income, Other Expense, Income, Expense, COGS - Posting is Yes - Subsidiary is your desired subsidiary 3. In the Results tab, you can add the following fields: - Period (Group) - Amount (Sum) - net income/loss - Formula (Numeric) - total corporate tax 4. For the Formula (Numeric) field, you can use a formula like this: -

CASE WHEN {accounttype}='Income' THEN {amount} ELSE 0 END - CASE WHEN {accounttype}='Cost of Goods Sold' THEN {amount} ELSE 0 END

- This formula calculates the gross profit by subtracting the total cost of goods sold from the total income. Please note that this approach might not work perfectly if you're not using the out-of-the-box Income Statement, as the formulas might need to be more complex and list out individual accounts or account groups. Also, this approach might not be able to replicate subtotals like gross profit line, net operating income, etc. as rows in the saved search, they would appear as columns. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******