Financial Statement Analysis by using Report Painter
I am writing my first blog on SDN keeping in view financial reporting requirements of client. Report painter is an excellent reporting tool that is equipped with useful features which can help us in designing analytical reports quickly without ABAP help.Financial reporting requirement varies as per local accounting practices and GAAPS. In order to cope up with these requirements report painter let us design reports like
- Profit & Loss Accounts
- Balance Sheet
- Cash Flow Statements
- Ratio Analysis
- Sources & Application of Working Capital
- Consolidated Financial statements
In order to make the user familiar with this reporting tool i would restrict this blog to Ratio Analysis. While designing ratio analysis for ratios based on profit and loss figures and balance sheet , one thing has to kept in mind that profit and loss figures are period based and balance sheet figures are taken on To Date basis. Hence we need to handle this behavior while designing ratio analysis report in report painter. I will use start with designing the form and the setting necessary parameters for a classified report output.
Step 1: Transaction Code FGI4 (create form)
In next screen you will see an unstructured form with four rows and four columns.My recommendation here is to have such a report that is meaningful at a glance & provides a comparative view of ratios for all months in the fiscal year. Here i will make 13 columns, 1st columns will be for Year to Date and rest of 12 will be for respective posting periods. Text of any row or column can be edited using shortcut key SHIFT + F1 or from menu.
Now in next step you need to set the columns. Since most of the ratios are based on Balance sheet figures i will recommend to make use of key figure “Accumulated balance” KUMSL for every column you add. Following images will show the Year to date column for report.
Now the process for month columns will be a bit different than year to date column. Double click the Column 2 and then key figure with characteristics.Key figure will always be Accumulated Balance for every column. Fiscal year setting will be same as of year to date column.Do not select variable button against posting period and hard code 1 in TO to FROM . 1 will stand here as first posting period which may differ if your fiscal year is not calendar year dependent. I will take Jan to December as fiscal year. Hence here January is fist posting period as shown in the coming snap
Repeat the same process for next 11 , do not forget to change the posting period for every period column i-e for February it should be 2 , for March 3 and so on..Now columns for your report have designed. You can copy the column created by selecting it pressing F9 and then F7. A new column will be added next to old the one.
Step2 : Define General Data Selection
This is very important step . In this step you select parameters that will govern your report’s data . Like Financial statement version & Chart of accounts used. Ideally financial statement version for ratio analysis should be the one which is assigned to financial statements. However you can create your own using OB59.
Step3: Define Rows
In this step you assign the FS items or accounts to the rows so that once report is executed their output can be displayed in the columns. I will first start with liquidity ratios which are based on balance sheet figures. First is current ratio which is current asset times current liabilities. I will first insert a blank line from Menu–edit—rows to name Liquidity ratios as shown in following snap
Now i will start assigning FS nodes for current assets and current liabilities to the rows..Double click on Row 1 and select characteristics. In next screen perform the action as indicated in following snap
You can see in the following screen shot that current assets node has been created, you need to repeat the same process for current liabilities node. Double click the next row..select characteristics and select the FS item for current liabilities by expanding hierarchy and confirm it.
Next we will set formula for current ratio , follows the process as shown in the coming screen shot
Now your current ratio has been computed. In order to make current ratio row distinguished form other you can select color for it. Select the row and in menu go to formatting..color settings…choose any you want.
Now your form is completed for one ratio, you can repeat the same process for calculating other ratios. Next we will now develop report.
Step 4: Define Report ( T code FGI1)
Our next step is to develop report based on the form we have created. You can create report from t code FGI1 as well as from form as well. In the form you can see the Report button, click it. In next screen you will see that form is automatically assigned and you can give name to your report.Press create button. In new screen characteristics tab , fetch the FS Items and assign it financial statement version.In variable tab you can set ledger 0L as default.In Output tab select classic drill down and then basic list:detail. Save and run the report. Cheers 🙂
Please note that there is a little mistake in number 6 screen shot. Variables like 1PF,1PT can be configured using FGIV not the FGIR.
- To hide any row or column , just click on it and go to menu …edit…rows..hide..You can display the hidden rows from the same path by selecting hidden rows and setting them display.
- When you try to edit name of any element , you have thee names, Short text, medium text and long text. You can set which one to display in report from menu…formatting…all rows..text length.
- Column width can be changed from menu..formatting..column width.
- You can import forms created in other client sharing the same instance number using FGIR.
- Forms can be deleted using FGIZ.
- Forms can be transported from development to live server using FGIP.
- Report can imported from one client to another client using FGIQ provided that client shares the same instance number.
- Reports can be transported to live server using FGIO.
- FGIX will let you delete report data.
This is the one topic among few which i am trying to get command and save user time.
When an expert takes initiative and think about the user for a minute, one can imagine what will be the outcome. It will not only save the Users's time, it will save a Consultant life when he is not sure on those areas.
But when i am downloading it, the screen shots are not coming into the PDF file.
Could you please have a look and re-upload it if needed dear?
Thanks a lot for your contribution.
Hope you will be looking into SCN and assisting the users 🙂
Thanks for appreciation. Actually ultimate intent of putting effort in this one was to familiarize the users with this reporting tool for making useful financial reports. As far as downloading is concerned i am having the same issue, one idea is to copy this blog and paste it into a word file, from where you can convert it into PDF. Kindly rate this article if you find it helpful .
Good Job Atif 🙂
Your blog is really good and understandable because you explained it step by step with screenshots.
I have gone through your blog, it is really help full to me. So far PDF is concern just press CTRL + P at Destination field of that select "Save as PDF" and then Save.
Thanks for appreciation..Kindly rate the article and please note that saving in PDF is not an issue. Screen shots are not coming in PDF when saving in PDF format.
Thanks for your reply, regarding PDF in my case Screen Shots are also coming by following above mention steps.
You may save the same in word file by coping the precious content posted by Atif.
I did the same way.
It is wonderful document. Thanks to you for sharing this. I will try to create similar kind of report for learning purpose, if struck somewhere will share with you.
I am obliged for the appreciation. Yes i will be glad to help you. Please note that ratios based on profit and loss will behave differently under the column with key figure KUMSL "Accumulated balance". You need to set special processing for every element in row. When you get to these P &L based ratio. Should you face any ambiguity, please feel free to contact.
Gr8 work Atif,specially screenshot concept it will definitely help me alot in future.
~~ Gaurav 🙂
Nice work atif. Keep it up
Really a good job done. it has been observed that this tool is merely used and most of the time company 's accountants used to download the data and derive Ratio analysis in Excel sheets.
There is very rare writing on this topic on SCN/SDN
It is fantastic style and elaborated the things in very easy way. good luck once again.
i am sending you link posted in April 2011 , can you help me in this regard
I have checked your link and since it is marked as answered so i can not reply there. I am posting reply here.
For average collection period for debtors i assume you have already calculated debtor's turnover ratio.Now for number of days for debtors you need to go to each element one by one for debtors turnover ratio for every month, double click it and choose "selected" . Give name to every element of debtors turnover ratio by pressing SHIFT+F1on it. Once you are done with it. Create a row with characteristics "formula". In formula write 31/(the row for debtor turnover ratio. Your entire row is generated for average collection period, but every row will be displaying average collection period based on 31 days and that is wrong.Leave the element of months which have 31 days. Your issue is to correct the average collection period of months with 30 days or 28 days. Go to September 's element , double click on it, select formula. In formula screen you will see IDs you have selected on top. Now there you can write 30/Selected ID for September month.This will do the job. Hope it helps you.
Thanks for the initiative to guide about report painter.
Very helpful content.
Good Job, keep it up, the document is really helpful.
good job atif. keep posting the good stuff like that
Nice one. Thanks for sharing.
you have done a great job
keep it up!
Very good work! I'm glad you are back on SCN!
Small remark: if you are going to post some more information of this kind, please, select more proper domain and type. For example, this useful information you have published, should be posted in 'Financial Management' rather than in 'Assets'. Also, the type for such an information would be 'document' and not 'blog'.
Thanks for your cooperation and keep posting!
Thanks for your suggestion and appreciation. Well you are right that this "document" should have been posted on right forum to maximize its utility. The moment i posted it i realized my mistake , i emailed at 3rd May to SDN support team to transfer this document to the Financial forum. I did not get any reply from there. Lets see when do they consider it.
I think you can move this post to your self by the option MOVE under Actions tab.
Thanks but in blog you do not have such option. You can verify 🙁
Thanks, Atif. I hope they'll do it. Unfortunately, I can move only discussions, but not the blogs.
Ok thankx and no problem , i am going to send them reminder against the email i send them 😉 .
you have done a great job.
Thanks for your contribution.
Nice WORK, Mr. Atif
very very useful
expecting these type of creative works.
Also, rated full
Thanks and obliged..
Great Job...it really good...
Thanks for this blog.
i want financial statement by day wise & not by period wise. e.g. today is 31st march i want financial statement as on 10th Feb. How can i get FSV on perticular date? What customisation required in it? Kindly suggest me what to do in report painter.
I do not see any option of day wise reporting in report painter so better ask ABAPER for it. If you get any update do update here.
Atif, great job. This is very helpful. However, I have one question. I have created a balance sheet form and then a report using that form. When I run the report, a blank column is printing (or spooling) between the lead column and the key figures. I have a hunch that the report is TRYING to print account names even though I didn't ask for them. I am using groups of accounts(like current assets), so I have no individual accounts showing up. But it looks like the report is "reserving" a space for account names. How can I turn that off so that I don't get a blank column? Thanks for your help.
Pllease attach screen shot of problematic area here.
This is very helpful. As an beginner in SAP I have prepared Income Statement & Balance Sheet following your tool. I'm facing problem to prepare Cash flow statement. Would you help me to form for Cash Flow Statement. Another issue, is it possible to create formula within two column?
My email ID is firstname.lastname@example.org
Very very useful guide for beginners and for experts.
Wonderful document Atif... I had prepared 3-4 reports on report painter last year. Now i am facing one issue.
My one report is having Current month Vs last month comparison.
For last month figure I have created formula variable(current month-1) and system showing always current month and last month figure for the period and year entered in the selection screen.
Now issue is for Jan 2013 period 1 there is no prevoius month but system calulating current month-1 i.e 0 peirod and throughing error.
Is there any way to resole that permanently ..
Nice Document, Thank You
Wonderful document, thank you so much. But i have a question that we usually use report painter tool with tcode start with GR* serio. they are very familar. What's the different between them?
its really good work keep going 🙂
Thanks & Regards
To be very frank I tried to develop report using Report painter twice but could not succeed and left it but your Documentation is superb and I tried and bingo......... 🙂 .
The way you have documented the whole process is superb and thanks for doing that.
Please do keep posting such a good documents.
Would love to see some more like this. 😉
Best of Luck. 🙂
You are welcome 🙂 .
Thanks for wonderful document.
Thanks and obliged. Kindly rate my document too 🙂 .
Expecting more knowledge sharing
Nice document and it's very help full.
Excellent. Very useful for my current requirement
Thanks and obliged . 🙂
Thanks for sharing the document on Report Painter.
i am in the middle of developing a report on ratio analysis. My client wants to know the sales per associate/employee for which i need to have a headcount coming from HCM tables like PA0000 etc. Pls advice how do i get that data and how to include these tables in FGI report.
I was looking for this report, thanks for sharing the nice documents..
Good Solution for report painter.
Great Job. Nice explanation on this report painter. It is really appreciatable one 🙂
Thanks & Regards,
Good Document, thanks for sharing...
Very nice document. Thanks.
Thanks for sharing valuable knowledge......
Can anyone tell the process to add notes to the bottom of financial statement(b/s & p/l) by using report painter?
Nice overview; one question.
If I use a FS item with a debit indicator: It still shows the debit or the credit balance.
Does report painter not take the debit/credit filter of the FS not into account?
In FGI5 or FGI4 you have an option to select Debit and Credit indicator in General data selection.
Good document !!
Great document and very easy to follow! Thank you!
Have you ever created a comparative profit center report? At a high-level, I'm trying to report on profit center amounts (one per column) across the report with the associated accounts assigned to the rows. Any suggestions?
Hi Farooq ,
Thank you very much for sharing this document last week i got a requirement from our client Month to Month FSV (sourse Tcode :F.01), I am new to report painter when i search in SCN i found your Document which helped me alot for creating report .soon i will present in SCN . ➕ 🙂 ➕
Can we add user name in FAGLFLEXT table?
Great job Atif. Very useful document.
Hi Farooq ,
Nice explanation. Thank you so much.
Could you please help me with a document, if you have, how to create Balance sheet and P&L using report painter. It would be really helpful if you can share with me.
Very good Atif,
The document is very very useful and its presentation is very nice, every new user can learn / create report painter using your document.
This document is very helpful, I was looking for this since long, but I have a problem, I want P& L report month wise comparison like 12 months on same page, how can I get that, this shows Balance Sheet Version. If I want comparison of Periods, Sale & Purchase even expenses. All P&L accounts.
hey sir this is really fabulous mashalah great efforts by you may allah bless you..................fakhar sap financial consultant
Great work bhai
Keep posting such blocks
Thanks for sharing the blog.
i follow all step which is provided by you.after successful configuration value(Figure not displayed).
Please see attached image and suggest where am wrong.