1. Navigate to Reports > New Financial Report.
2. Click any Standard Income Statement Layout (depends upon the availability due to NetSuite editions).
3. Under the Edit Layout section, on the Add Row/Section... drop-down field, select Add Financial Section.
4. In the New Section Row pop-up, Select Create New Section radio button and click OK.
5. Delete other sections in this particular order (assuming a Standard Income Statement Layout(US).
- Net Income.
- Other Income and Expenses.
- Ordinary Income and Expenses.
6. On the right hand side of your screen, set the following:
- Header Label = Put any label you prefer.
- Display = Expanded.
- Group By = Account.
- Show Hierarchy = Unchecked.
- Section tab.
- Filter = Account Type.
- Description = (All Account Types except Bank).
7. On the Add Row/Section... drop-down field, select Add Financial Section.
8. In the New Section Row pop-up, Select Create New Section radio button and click OK.
- Header Label = Put any label you prefer.
- Display = Expanded.
- Group By = Account.
- Show Hierarchy = Unchecked
- Section tab.
- Filter = Account Type.
- Description = (Bank Account Types).
- Format Tab>Account Row Format segment.
- Check the Reverse Sign box.
9. On the Add Row/Section... drop-down field, select Add Formula Row.
- Add up the two Financial Rows we have created.
10. Go to Edit Columns.
- Click on the Amount column.
- Uncheck the Add Grand Total box.
11. Click Save.
No comments:
Post a Comment