Sheet1Bill No Bill DateAvg due dateCustomer Bill Amount1st Amt %1st Amt Due Date1st Recd Date1st Amt Allco2nd Amt %2nd Amt Ndays2nd Due Amt2nd Amt Due Date2nd Recd Amt2nd Recd Date3rd Amt %3rd Amt Ndays3rd Due Amt3rd Amt Due Date3rd Recd Amt3rd Recd Date4th Amt %4th Amt Ndays4th Due Amt4th Amt Due Date4th Recd Amt4th Recd DateTotal RecdBal372621-Jul-1319-Aug-13BGR ENERGY (NPCIL-RAPP)2080597.0010.006-Apr-1313-Aug-12185172.0090451872537.304-Sep-131666552.0030-Oct-13000.00-0.000.000.0021-Jul-131851724.00228873.00419431-Jul-1328-Aug-13BGR ENERGY (NPCIL-RAPP)718470.0010.006-Apr-1313-Aug-1263944.009045646623.0014-Sep-13575492.0030-Oct-13000.00-0.000.000.0031-Jul-13639436.0079034.00419331-Jul-1328-Aug-13BGR ENERGY (NPCIL-RAPP)1048038.0010.006-Apr-1313-Aug-1293275.009045943234.2014-Sep-13839475.0030-Oct-13000.00-0.000.000.0031-Jul-13932750.00115288.00533131-Aug-1325-Sep-13BGR ENERGY (NPCIL-RAPP)1891353.0010.006-Apr-1313-Aug-12168330.0090451702217.7015-Oct-131514967.0027-Dec-13000.00-0.000.000.0031-Aug-131683297.00208056.00533331-Aug-1325-Sep-13BGR ENERGY (NPCIL-RAPP)4050690.0010.006-Apr-1313-Aug-12360510.0090453645621.0015-Oct-133244590.0027-Dec-13000.00-0.000.000.0031-Aug-133605100.00445590.00539931-Aug-1325-Sep-13BGR ENERGY (NPCIL-RAPP)2179559.0010.006-Apr-1313-Aug-12193980.0090451961603.1015-Oct-131745820.0027-Dec-13000.00-0.000.000.0031-Aug-131939800.00239759.0010652107.001316600.00

Sheet2DateAmount Bank24-Dec-123,240.0ICICI Bank3,240.0Q3 FY201329.5%29.5%2-Jan-132,700.0Axis BankQ4 FY201324.5%30-Jan-132,000.0Axis Bank4,700.0Q4 FY201318.2%42.7%28-Jun-13260.0ICICI BankQ1 FY20142.4%28-Jun-131,240.0Central Bank of India1,500.0Q1 FY201411.3%13.6%30-Sep-131,000.0Central Bank of India1,000.0Q2 FY20149.1%9.1%24-Dec-13260.0Central Bank of IndiaQ3 FY20142.4%24-Dec-1345.0Axis BankQ3 FY20140.4%24-Dec-1360.0Bank of IndiaQ3 FY20140.5%24-Dec-1390.0Syndicate BankQ3 FY20140.8%24-Dec-13105.0Vijaya Bank560.0Q3 FY20141.0%5.1%11,000.011,000.0100.0%100.0%- 011,000.0

Sheet3