Profit And Loss Report

1. Profit And Loss Report R-FA Designed by Ashwan Saini (EDP) Ahmedabad

2. Profit & Loss (P & L) • This report helps us to see what is our profit/loss for the selected period. • We can generate it on various fields, locations, period, Ledger, Sub ledger, Group, Parent group etc. • Total of credit side and debit side can be auto calculated from the system. • It can be displayed branch wise, monthly, quarterly, yearly. • Can be generated for single branch or multiple branches. • To generate this report we will use Pivot Report style of the report. Designed by Ashwan Saini (EDP) Ahmedabad

3. To open this report click on Reports in RFA main screen A new window is displayed on the screen. Now click on Voucher Reports to open the sub menu. From sub menu click on Voucher Details to open that report Designed by Ashwan Saini (EDP) Ahmedabad

4. Report form will open now we will enter various filter details so that this report can be generated Designed by Ashwan Saini (EDP) Ahmedabad

5. We will start by entering the date to select the period of our report. For this example I will from 1/1/2013 to 31/12/2013 Now we will select nature as this is Profit and Loss report we will select Account nature as Income and expense. Designed by Ashwan Saini (EDP) Ahmedabad

6. Now we will enter the format of Pivot so that we can generate this report. For this at the bottom click on radio button against Pivot Report When you select this option more details will be displayed on the screen. Designed by Ashwan Saini (EDP) Ahmedabad

7. Now we will enter the details of all the fields we will need to be displayed on the screen. Designed by Ashwan Saini (EDP) Ahmedabad

8. When we generate Pivot report we have to remember the concept of Columns, Rows and data like in a chart Columns Sno Debit Branch Name Credit Rows Voucher number Data Area So we will select what information will be displayed in Columns, Rows and in Data Area Designed by Ashwan Saini (EDP) Ahmedabad

9. We will start by selecting the location from Column name, in Area Type I have selected Column Area where it will be displayed and in Area Index leave default 0. if you are adding more then 1 column then first column will be 0 second column will be 1 and so on. In second select Voucher date and in Group Interval select DateMonth so report is displayed monthly Designed by Ashwan Saini (EDP) Ahmedabad

10. Similarly I have entered Account Nature, Account Group, Ledger name, Sub Ledger Name in Row Area with Area Index 0,1,2,3 Designed by Ashwan Saini (EDP) Ahmedabad

11. Now that we have selected the Columns and Rows we will select the data to be displayed here I will be selecting Net Amount, Debit, Credit and will also selected sum so that system will automatically give me a total also. Designed by Ashwan Saini (EDP) Ahmedabad

12. Now that we have entered all the details lets click on Show button to display this report Designed by Ashwan Saini (EDP) Ahmedabad

13. Designed by Ashwan Saini (EDP) Ahmedabad

14. A Detailed report is generated and shown on the screen. Depending what conditions we have selected information is displayed in various Columns, Rows and Data area • We can generate this report on Groups, Type of Expense, Ledgers, Sub Ledgers, Date, Voucher number etc. • When we select date then it can be Date, Date Month, Date Quarter and Date year. • System can do Sum, Average, Count, Minimum, Maximum on numeric fields. • This is a very customizable report and can be displayed as per user’s preferences. • Depending on what date range and how many branches we have selected it can take some time to get displayed. Designed by Ashwan Saini (EDP) Ahmedabad