Spreadsheet: 68290d1268827854-show-billing-cycle-for-a-month-datamarch2010
Sheet: Data Entry

S.No | Transaction Date | Month | Amount | Billing  Cycle | Billed Date | Due Date | Remarks
1 | 2007-05-19 00:00:00 | [NAME] | 6767 | 21/04/07 - 20/05/07 | 21/05/2007 | 2007-06-04 00:00:00
2 | 2007-05-19 00:00:00 | [NAME] | 203.01 | 21/04/07 - 20/05/07 |  | 2007-06-04 00:00:00
3 | 2007-05-24 00:00:00 | [NAME] | 25.09 | 21/05/07 - 20/06/07 |  | 2007-07-05 00:00:00
4 | 2007-06-24 00:00:00 | [NAME] | 250 | 21/06/07 - 20/07/07 |  | 2007-08-04 00:00:00
5 | 2007-06-24 00:00:00 | [NAME] | 2255.66 | 21/06/07 - 20/07/07 |  | 2007-08-04 00:00:00
6 | 2007-07-24 00:00:00 | July'2007 | 2255.67 | 21/07/07 - 20/08/07 |  | 2007-09-04 00:00:00
7 | 2007-08-24 00:00:00 | August'2007 | 2255.67 | 21/08/07 - 20/09/07 |  | 2007-10-05 00:00:00
8 | 2007-09-23 00:00:00 | September'2007 | 11990 | 21/09/07 - 20/10/07 |  | 2007-11-04 00:00:00
9 | 2007-10-13 00:00:00 | October'2007 | 760 | 21/09/07 - 20/10/07 |  | 2007-11-04 00:00:00
10 | 2007-10-24 00:00:00 | October'2007 | 2132 | 21/10/07 - 20/11/07 |  | 2007-12-05 00:00:00
11 | 2007-12-02 00:00:00 | December'2007 | 1373.28 | 21/11/07 - 20/12/07 |  | 2008-01-04 00:00:00
12 | 2007-12-02 00:00:00 | December'2007 | 1263.34 | 21/11/07 - 20/12/07 |  | 2008-01-04 00:00:00
13 | 2007-12-12 00:00:00 | December'2007 | 788 | 21/11/07 - 20/12/07 |  | 2008-01-04 00:00:00
14 | 2007-12-18 00:00:00 | December'2007 | 1147 | 21/11/07 - 20/12/07 |  | 2008-01-04 00:00:00
15 | 2008-04-05 00:00:00 | April'2008 | 1395 | 21/03/08 - 20/04/08 |  | 2008-05-05 00:00:00
16 | 2008-04-21 00:00:00 | April'2008 | 141.68 | 21/04/08 - 20/05/08 |  | 2008-06-04 00:00:00
17 | 2008-04-21 00:00:00 | April'2008 | 17.51 | 21/04/08 - 20/05/08 |  | 2008-06-04 00:00:00
18 | 2008-05-05 00:00:00 | May'2008 | 895 | 21/04/08 - 20/05/08 |  | 2008-06-04 00:00:00
19 | 2008-05-21 00:00:00 | May'2008 | 14.4 | 21/05/08 - 20/06/08 |  | 2008-07-05 00:00:00
20 | 2008-08-13 00:00:00 | August'2008 | 3290 | 21/07/08 - 20/08/08 |  | 2008-09-04 00:00:00
21 | 2008-09-24 00:00:00 | September'2008 | 414 | 21/09/08 - 20/10/08 |  | 2008-11-04 00:00:00
22 | 2008-09-25 00:00:00 | September'2008 | 3290 | 21/09/08 - 20/10/08 |  | 2008-11-04 00:00:00
23 | 2008-09-25 00:00:00 | September'2008 | 250 | 21/09/08 - 20/10/08 |  | 2008-11-04 00:00:00
24 | 2008-11-16 00:00:00 | November'2008 | 1216.51 | 21/10/08 - 20/11/08 |  | 2008-12-05 00:00:00
25 | 2008-11-16 00:00:00 | November'2008 | 1216.51 | 21/10/08 - 20/11/08 |  | 2008-12-05 00:00:00
26 | 2008-11-16 00:00:00 | November'2008 | 208.69 | 21/10/08 - 20/11/08 |  | 2008-12-05 00:00:00
27 | 2008-11-16 00:00:00 | November'2008 | 208.69 | 21/10/08 - 20/11/08 |  | 2008-12-05 00:00:00
28 | 2008-11-16 00:00:00 | November'2008 | 1350.89 | 21/10/08 - 20/11/08 |  | 2008-12-05 00:00:00
29 | 2008-11-16 00:00:00 | November'2008 | 1350.89 | 21/10/08 - 20/11/08 |  | 2008-12-05 00:00:00
30 | 2008-11-16 00:00:00 | November'2008 | 683.08 | 21/10/08 - 20/11/08 |  | 2008-12-05 00:00:00
31 | 2008-11-30 00:00:00 | November'2008 | 950 | 21/11/08 - 20/12/08 |  | 2009-01-04 00:00:00
32 | 2008-11-30 00:00:00 | November'2008 | 2350 | 21/11/08 - 20/12/08 |  | 2009-01-04 00:00:00
33 | 2008-11-26 00:00:00 | November'2008 | 402 | 21/11/08 - 20/12/08 |  | 2009-01-04 00:00:00
34 | 2009-01-01 00:00:00 | January'2009 | 11526 | 21/12/08 - 20/01/09 |  | 2009-02-04 00:00:00