Transaction Search to Replicate the Income Statement (Profit and Loss) Report

Applies To

Product:  NetSuite 2020

Scenario

This article provides a replica of amounts shown on your Income Statement report through Saved Search

Solution

1. Navigate to List > Search > Saved Searches > New
2. Click Transactions
3. Search Title: Enter the Name of the Saved Search
   Example: Transaction Saved Search - Income Statement (Jan 2020)
4. Click Criteria
5. Go to Standard > Filter
   Note: Always click Add after selecting the Filter/s.
   
   • Select Account Type
   1. Select Any Of
   2. Highlight the following:
      
      • Income
      • Cost of Goods Sold
      • Expense
      • Other Income
      • Other Expense
   3. Click Set
   • Select Posting
   1. Mark Yes
   2. Click Set
   • Select Period
   1. Click the Drop-Down Field
   2. Select the Accounting Period needed for the report (ex. Jan 2020)
   3. Click Set
6. Click Results
7. Output Type: Report
8. Mark Show Totals Checkbox
9. Go to Columns > Field
   Note: Always Click Add after selecting the Field/s.
   
   • Select Date
   • Select Period
   • Select Account
   • Select Document Number
   • Select Amount
   • Select Memo
     Note: Add or Remove other fields as needed.
10. Click Save and Run or Preview
    
    
    Notes: For One World Account, there might be a need to add the Subsidiary Filter in the Criteria and the select an appropriate option in the Consolidated Exchange Rate Dropdown under Results.