{"id":35086,"date":"2024-09-27T09:17:17","date_gmt":"2024-09-27T09:17:17","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=35086"},"modified":"2025-06-19T06:56:44","modified_gmt":"2025-06-19T06:56:44","slug":"account-wise-income-statement-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2024\/09\/27\/account-wise-income-statement-report\/","title":{"rendered":"Account-wise Income Statement Report"},"content":{"rendered":"\n

In Sage 300 ERP<\/a>, An explanation of how the company’s realized net revenue is converted into net earnings (profit or loss) is provided by the income statement. Four essential items must be reported in order to do this: revenue, expenses, gains, and losses.<\/p>\n\n\n\n

Revenue can include Sales, rent revenue, Dividend revenue, Interest revenue, sales return, sales discounts, etc. Expenses can include the cost of sales, utility expenses, cleaning expenses, income tax expenses, rent expenses, salaries and wages expenses, etc. Gains could be assets accrued from the sale of land or an old vehicle, etc. Losses could be costs that produce no benefit, a decrease in resource value, excess expenditure over income, etc.<\/p>\n\n\n\n

In this blog, we are going to discuss the working of the Income Statement report. The report will export all the data regarding revenue, expense, profit, and loss accounts. To organize the data as per the user\u2019s requirement we have provided the filters on accounts as well as the dates. The user needs to define the output file name and the above-mentioned filters to get the required results upon clicking of export button.<\/p>\n\n\n\n

Please refer below screenshot of the user interfaces for the \u201cIncome Statement Report<\/strong>\u201d.<\/p>\n\n\n\n

New Stuff: –<\/strong> Sending Email using Microsoft Graph in Sage 300<\/a><\/p>\n\n\n\n

\"Income<\/a><\/center>\n
Figure 1 : Income Statement Report – User Interface<\/center><\/font>\n\n\n\n

<\/p>\n\n\n\n

The report will be exported in a selected folder as an Excel file-based format with parameters as of from & To GL Accounts and from & To Date.<\/p>\n\n\n\n

Below is the screenshot of the Excel-based generated output of the \u201cIncome Statement\u201d report: –<\/strong><\/p>\n\n\n\n

\"Output<\/a><\/center>
Figure 2: Output – Income Statement Report<\/center><\/font>\n\n\n\n

<\/p>\n\n\n\n

This report includes the following fields and can be modified according to requirements.<\/strong><\/p>\n\n\n\n