Financial Statement Analysis by using Report Painter

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

1. Profit & Loss Accounts
2. Balance Sheet
3. Cash Flow Statements
4. Ratio Analysis
5. Sources & Application of Working Capital
6. 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.

KP06 Excel Upload

Creation of Planning Layout

Go to t.code: KP65

Click on Create

Select the Version, Period and Fiscal year in the General Data Selection in the Menu Bar Edit --> Gen data selection --> Gen data selection