Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i am trying to do something like in following excel. so i followed everything according to this concept
How to Create a Profit and Loss Statement in QlikView
but i cant able to achieve what i need.
can anyone tell me how to achieve this
Thanks
like this i have to create reporting_code in DB
ACNT_FLEX_04 reporting_code
1- Gross premiums | 1 |
2- Reinsures share of gross premiums | 2 |
XOL Protection costs | 3 |
3- Movement in unexpired premium | 4 |
4- Net Commision | 5 |
5- Gross claims | 6 |
6- Reinsurance and other recoveries | 7 |
8- Movement in outstanding claims | 8 |
Operative and administrative expenses | 9 |
Provision for doubtful debts | 10 |
Depreciation of property and equipment | 11 |
Group shared expenses | 12 |
Investment income | 13 |
Intercompany Facility interest | 14 |
Intercompany Dividend | 15 |
Rental income | 16 |
Advisory fee income | 17 |
Other Income | 18 |
Thanks
Almost. If you want to know the logic behind what I'm going to explain, reread the technical brief. It would be even more instructive if you rebuild step-by-step the P&L as documented by Jennell, based on her data instead of jumping straight into your own challenges.
The Reporting Codes that you should assign to the accounts in your chart of accounts are taken from your Excel (see income_statement_new.xls). The Excel has two columns ExecPLStart and ExecPLEnd. All lines that have identical values in both columns are carrying Reporting Codes. This is almost identical to the list you supplied above, except that the last one, BOD Remuneration & expenses (19) is missing.
Now go back to your list of accounts and assign a single Reporting Code to each account number. This is where you can do with some information from your accounting dept.
Peter
Thank you very much i will check and comeback
Thanks Peter it works...
Hi Peter,
just one doubt space between rows is not coming. i checked the excel the 's' is available.
Thanks
See Technical Brief, p8, first bullet. Did you put spaces in ...?
yes i did