I want to create Trail Balance, Profit & Loss & Balance sheet in QlikView.
I have a requirement where i have take Closing Balance Amount of Previous Year will be the Opening Balance for Next Year on the basis of GL Account (Primary Key).
Suppose,
In 2009 GL Account No (110001) has Closing balance of 50,000 /- the balance comes from
Closing Balance = [Opening amount +Debit Amount - Credit Amount],
Before 2009 there is no data .
I have to create a field named ''Closing Balance'' in which Closing Balance of Previous Year will be the Opening Balance for Next Year .
(For 2010, Closing Balance of 2009 will become opening balance for 2010)
Year | GL Account | GL Name | Opening Amount | Debit Amount | Credit Amount | Closing Amount(Op+Dr-Cr) |
2009 | 110001 | Share Capital | 0 | 0 | 50000 | -50000 |
2009 | 110002 | Reserve and Surplus | 0 | 0 | 100000 | -100000 |
2010 | 110001 | Share Capital | -50000 | 0 | 100000 | -150000 |
2010 | 110002 | Reserve and Surplus | -100000 | 0 | 100000 | -200000 |
2011 | 110001 | Share Capital | -150000 | 0 | 0 | -150000 |