Spreadsheet: 133282d1324314410-not-to-include-the-finalise-deal-in-pivot-table-staff-deduction
Sheet: RawData

No. | Name | Desc | Type of Deduction | No of Payment | Payment Date | Principal | Interest | Total Payable Amount | Opening Balance | Payment Due | Closing Balance | Fully Paid
1 | Martin | AIA Personal Insurance starting in June 2011 | Insurance | 1 | 2011-05-31 00:00:00 | 279 | 0 |  | 279.9 | -28
1 | Martin | AIA Personal Insurance starting in June 2011 | Insurance | 2 | 2011-06-30 00:00:00 | 279 | 0 |  |  | -28
1 | Martin | AIA Personal Insurance starting in June 2011 | Insurance | 3 | 2011-07-31 00:00:00 | 279 | 0 |  |  | -28
1 | Martin | AIA Personal Insurance starting in June 2011 | Insurance | 4 | 2011-08-31 00:00:00 | 279 | 0 |  |  | -29
1 | Martin | AIA Personal Insurance starting in June 2011 | Insurance | 5 | 2011-09-30 00:00:00 | 279 | 0 |  |  | -28
1 | Martin | AIA Personal Insurance starting in June 2011 | Insurance | 6 | 2011-10-31 00:00:00 | 279 | 0 |  |  | -23
1 | Martin | AIA Personal Insurance starting in June 2011 | Insurance | 7 | 2011-11-30 00:00:00 | 279 | 0 |  |  | -23
1 | Martin | AIA Personal Insurance starting in June 2011 | Insurance | 8 | 2011-12-31 00:00:00 | 279 | 0 |  |  | -23
1 | Martin | AIA Personal Insurance starting in June 2011 | Insurance | 9 | 2012-01-31 00:00:00 | 279 | 0 |  |  | -23
1 | Martin | AIA Personal Insurance starting in June 2011 | Insurance | 10 | 2012-02-29 00:00:00 | 279 | 0 |  |  | -23
1 | Martin | AIA Personal Insurance starting in June 2011 | Insurance | 11 | 2012-03-31 00:00:00 | 279 | 0 |  |  | -23.9
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 1 | 2011-05-31 00:00:00 | 279 | 0 |  | 279.9 | -25
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 2 | 2011-06-30 00:00:00 | 279 | 0 |  |  | -25
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 3 | 2011-07-31 00:00:00 | 279 | 0 |  |  | -25
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 4 | 2011-08-31 00:00:00 | 279 | 0 |  |  | -25
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 5 | 2011-09-30 00:00:00 | 279 | 0 |  |  | -25
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 6 | 2011-10-31 00:00:00 | 279 | 0 |  |  | -25
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 7 | 2011-11-30 00:00:00 | 279 | 0 |  |  | -25
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 8 | 2011-12-31 00:00:00 | 279 | 0 |  |  | -25
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 9 | 2012-01-31 00:00:00 | 279 | 0 |  |  | -25
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 10 | 2012-02-29 00:00:00 | 279 | 0 |  |  | -25
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 11 | 2012-03-31 00:00:00 | 279 | 0 |  |  | -14.95
2 | Rose | AIA Personal Insurance starting in May 2011 | Insurance | 12 | 2012-04-30 00:00:00 | 279 | 0 |  |  | -14.95
3 | Suri | Payment for penalty | Others | 1 | 2011-09-30 00:00:00 | 121.5 | 0 |  | 121.5 | -40.5
3 | Suri | Payment for penalty | Others | 2 | 2011-10-31 00:00:00 | 121.5 | 0 |  |  | -40.5
3 | Suri | Payment for penalty | Others | 3 | 2011-11-30 00:00:00 | 121.5 | 0 |  |  | -40.5