Spreadsheet: 470229d1468404250-comparison-of-two-years-collection-data-in-one-graph-sample
Sheet: Sheet1

S. No | ID | [NAME] | School Name | Support Anchor | HUB | NET Billing | Due Pending 2012-17 | Opening Balance | Due Pending 2016-17 | April VAT Billing | May Vat Billing | June VAT Billing | July VAT Billing | August VAT Billing | September VAT Billing | October [NAME] | November VAT Billing | December VAT Billing | January  VAT Billing | February VAT Billing | March VAT Billing | YTD  [NAME] | April ST Billing | May ST Billing | June ST Billing | July ST Billing | August ST Billing | September ST Billing | October ST Billing | November ST Billing | December ST Billing | January  ST Billing | February ST Billing | March ST Billing | YTD ST Billing | April Other Billing | May Other Billing | June Other Billing | July Other Billing | August Other Billing | September Other Billing | October Other Billing | November Billing Other Billing | December Billing Other Billing | January Billing Other Billing | February Billing Other Billing | March Billing Other Billing | YTD Other Billing | Partnership Fee | Service Tax | [NAME] | [NAME] | YTD BILLING | Advance collected - 2015-16 | April Collection | May Collection | June Collection | July Collection | August Collection | September Collection | October Collection | November Collection | December Collection | January Collection | February Collection | March Collection | April Y2 Collection | May Y2  Collection | June Y2 Collection | TDS Entry on March 31st | Excess Payment adjusted to 17-18 | YTD Collection | April Credit Note with [NAME] | May Credit Note with [NAME] | June Credit Note with [NAME] | July Credit Note with [NAME] | August Credit Note with [NAME] | September Credit Note with [NAME] | October Credit Note with [NAME] | November Credit Note with [NAME] | December Credit Note with [NAME] | January Credit Note with [NAME] | February Credit Note with [NAME] | March Credit Note with [NAME] | April Y2  Credit Note with [NAME] | May Y2  Credit Note with [NAME] | YTD Credit Note with VAT | April Credit Note With ST | May Credit Note With ST | June Credit Note With ST | July Credit Note With ST | August Credit Note With ST | September Credit Note With ST | October Credit Note With ST | November Credit Note with ST | December Credit Note with ST | January Credit Note with ST | February Credit Note with ST | March Credit Note with ST | April Y2  Credit Note with ST | May Y2  Credit Note with ST | YTD Credit Note with ST | TOTAL Credit Note on Material Return | Service Tax - Credit  Note | Service Tax | Discount | Other / PY Return | MOU Change | YTD Credit Note
1 | KAGLA00046 |  | St James School | [NAME] | North | 3490325 |  | 46200 |  |  |  | 2299500 |  |  |  |  |  |  |  |  |  | 2299500 |  |  | 1190825 |  |  |  |  |  |  |  |  |  | 1190825 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 3490325 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
2 | KAGLA00027 |  | NSN School | [NAME] | North | 2274220 |  | 0 |  | 1441650 |  | 37800 |  |  |  |  |  |  |  |  |  | 1479450 | 776139 |  | 18631 |  |  |  |  |  |  |  |  |  | 794770 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 2274220 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
3 | TNTPR00050 |  | National Matric | Stephen | South | 2095278 |  | 0 |  | 1388340 |  | 16964 |  |  |  |  |  |  |  |  |  | 1405304 | 681608 |  | 8366 |  |  |  |  |  |  |  |  |  | 689974 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 2095278 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
4 | TNKNM00187 |  | Jones School | Guru | South | 1917070 |  | 0 |  | 1269716 |  | 6720 |  |  |  |  |  |  |  |  |  | 1276436 | 614423 | 22900 | 3311 |  |  |  |  |  |  |  |  |  | 640634 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 1917070 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
5 | TNKNM00186 |  | Government High School | Guru | South | 1912767 |  | 2.182787284255028e-11 |  | 1272488 |  | 1120 |  |  |  |  |  |  |  |  |  | 1273608 | 615708 | 22900 | 551 |  |  |  |  |  |  |  |  |  | 639159 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 1912767 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
6 | KAHSN00054 |  | Holy Cross School | Param | North | 1895404 |  | 10459 |  | 1189150 |  | 82550 |  |  |  |  |  |  |  |  |  | 1271700 | 582965 |  | 40739 |  |  |  |  |  |  |  |  |  | 623704 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 1895404 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
7 | KABGR01397 |  | Suburban Secondary School | Ertiga | North | 1767026 |  | 0 |  | 1146950 |  |  |  |  |  |  |  |  |  |  |  | 1146950 | 620076 |  |  |  |  |  |  |  |  |  |  |  | 620076 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 1767026 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
8 | UAGHA00097 |  | BHSS | [NAME] | West | 1578982 |  | 176385 |  |  | 1032197 |  |  |  |  |  |  |  |  |  |  | 1032197 |  | 546785 |  |  |  |  |  |  |  |  |  |  | 546785 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 1578982 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
9 | POPNY00011 |  | Apple Angels School | Akil | West | 1691638 |  | 0 |  | 663495 |  | 470610 |  |  |  |  |  |  |  |  |  | 1134105 | 325588 |  | 231945 |  |  |  |  |  |  |  |  |  | 557533 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 1691638 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0