Spreadsheet: 106205d1303389823-simultaneous-updating-worksheets-overdue-ageing-1-
Sheet: MASTTER SHEET

NAME OF THE COMPANY
DETAILS OF AGE-WISE DEBTORS REPORT AS ON
 |  |  | 2011-04-15 00:00:00 | ABC & CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL OVERDUE
Name of the Party | Zone | Party Status | Invoice Date | Invoice No. | Credit Period | Due Date | Delay (Days) | Invoice Amount | Outstanding Invoice Amount (Rs.) | < 0 | <0 - 30> | <31 - 60> | <61 - 90> | <91 - 120> | <121 - 150> | <151 - 180> | > 180 Days |  | TEST
ALFAEX EXIM | WH1 | DIRECT PARTY | 2010-09-04 00:00:00 | 141 | 60 | 2010-11-03 00:00:00 | 163 |  | 239 | 0 | 0 | 0 | 0 | 0 | 0 | 239 | 0 | 239
CLASSIC CLASSIDYY | WH1 | DIRECT PARTY | 2011-01-20 00:00:00 | 342 | 60 | 2011-03-21 00:00:00 | 25 | 33264 | 33264 | 0 | 33264 | 0 | 0 | 0 | 0 | 0 | 0 | 33264
ALUTEX COATING | WH1 | DEALER | 2011-02-23 00:00:00 | 395 | 60 | 2011-04-24 00:00:00 | -9 | 26611 | 2760 | 2760 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ROSEX BINDERS | WH1 | DEALER | 2011-03-08 00:00:00 | 417 | 60 | 2011-05-07 00:00:00 | -22 | 83160 | 1970 | 1970 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JUMANJEE HARDWARE | WH2 | DEALER | 2011-04-04 00:00:00 | 4 | 60 | 2011-06-03 00:00:00 | -49 | 75707 | 75707 | 75707 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
RAKSON STEEL TUBE | WH2 | DEALER | 2010-10-20 00:00:00 | 26 | 60 | 2010-12-19 00:00:00 | 117 | 120776 | 120776 | 0 | 0 | 0 | 0 | 120776 | 0 | 0 | 0 | 120776
ALEX PIPES | WH2 | DEALER | 2010-12-27 00:00:00 | 81 | 60 | 2011-02-25 00:00:00 | 49 | 48311 | 48311 | 0 | 0 | 48311 | 0 | 0 | 0 | 0 | 0 | 48311
LOPAX UTENSILS | WH2 | DEALER | 2011-01-07 00:00:00 | 93 | 60 | 2011-03-08 00:00:00 | 38 | 100368 | 100368 | 0 | 0 | 100368 | 0 | 0 | 0 | 0 | 0 | 100368
ZIP ACIDS | EAST | DIRECT PARTY | 2011-01-03 00:00:00 | 461 | 60 | 2011-03-04 00:00:00 | 42 | 35726 | 35726 | 0 | 0 | 35726 | 0 | 0 | 0 | 0 | 0 | 35726
RAINT O PLASTCIS | EAST | DEALER | 2011-01-31 00:00:00 | 510 | 60 | 2011-04-01 00:00:00 | 14 | 751680 | 53222 | 0 | 53222 | 0 | 0 | 0 | 0 | 0 | 0 | 53222
PESTICIDE KEEPER | EAST | DEALER | 2011-02-19 00:00:00 | 551 | 60 | 2011-04-20 00:00:00 | -5 | 102720 | 17124 | 17124 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AUROMA AUTO PARTS | WH3 | DEALER | 2011-01-15 00:00:00 | 39 | 60 | 2011-03-16 00:00:00 | 30 | 102720 | 17124 | 0 | 17124 | 0 | 0 | 0 | 0 | 0 | 0 | 17124
HALLMARK AGENCY | WH3 | DEALER | 2011-01-24 00:00:00 | 46 | 60 | 2011-03-25 00:00:00 | 21 | 102720 | 17124 | 0 | 17124 | 0 | 0 | 0 | 0 | 0 | 0 | 17124
[NAME] | WH3 | DEALER | 2011-01-25 00:00:00 | 47 | 60 | 2011-03-26 00:00:00 | 20 | 102720 | 17124 | 0 | 17124 | 0 | 0 | 0 | 0 | 0 | 0 | 17124
ATLAS COPCO | WEST | Dealer | 2010-10-31 00:00:00 | 361 | 60 | 2010-12-30 00:00:00 | 106 | 302400 | 100000 |  |  |  |  |  |  |  |  | 0
SYNTHTHETIC RESGINS | WEST | Dealer | 2010-10-06 00:00:00 | 294 | 60 | 2010-12-05 00:00:00 | 131 | 1410338 | 894380 |  |  |  |  |  |  |  |  | 0
HIPPO GREASE | WEST | Dealer | 2010-12-06 00:00:00 | 419 | 60 | 2011-02-04 00:00:00 | 70 | 894511 | 894511 |  |  |  |  |  |  |  |  | 0
HANIF PAINTS | WH4 | DIRECT PARTY | 2010-12-07 00:00:00 | 17 | 60 | 2011-02-05 00:00:00 | 69 | 21840 | 840 | 0 | 0 | 0 | 840 | 0 | 0 | 0 | 0 | 840
NATIONAL ART | WH4 | DIRECT PARTY | 2011-03-24 00:00:00 | 85 | 60 | 2011-05-23 00:00:00 | -38 | 28083 | 28083 | 28083 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GOMEZ CHEMICALS | WH4 | DIRECT PARTY | 2011-03-22 00:00:00 | 82 | 60 | 2011-05-21 00:00:00 | -36 | 119948 | 119948 | 119948 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TRINITY ASSOCIATES | CENTRAL | DEALER | 2010-12-19 00:00:00 | 450 | 60 | 2011-02-17 00:00:00 | 57 | 1439282 | 48639 | 0 | 0 | 48639 | 0 | 0 | 0 | 0 | 0 | 48639
GLASSWARE SHOPPING | CENTRAL | DEALER | 2011-01-11 00:00:00 | 477 | 60 | 2011-03-12 00:00:00 | 34 | 125040 | 38 | 0 | 0 | 38 | 0 | 0 | 0 | 0 | 0 | 38
HYDRA PLATE AGENCY | CENTRAL | DEALER | 2011-01-31 00:00:00 | 506 | 60 | 2011-04-01 00:00:00 | 14 | 2087462 | 2087462 | 0 | 2087462 | 0 | 0 | 0 | 0 | 0 | 0 | 2087462
ROCKY COATINGS | CENTRAL | DEALER | 2011-02-22 00:00:00 | 570 | 60 | 2011-04-23 00:00:00 | -8 | 72000 | 180 | 180 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GOLANG FABRICAION | CENTRAL | DEALER | 2011-03-20 00:00:00 | 620 | 60 | 2011-05-19 00:00:00 | -34 | 316800 | 316800 | 316800 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 8504187 | 5031720 | 562572 | 2225320 | 233082 | 840 | 120776 | 0 | 239 | 0 | 2580257
ALFAEX EXIM | WH1 | DIRECT PARTY | 40425 | 141 | 60 | 40485 | 163 | 0 | 239 | 0 | 0 | 0 | 0 | 0 | 0 | 239 | 0 | 0
CLASSIC CLASSIDYY | WH1 | DIRECT PARTY | 40563 | 342 | 60 | 40623 | 25 | 33264 | 33264 | 0 | 33264 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ALUTEX COATING | WH1 | DEALER | 40597 | 395 | 60 | 40657 | -9 | 26611 | 2760 | 2760 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Some Guy | WH1 | Dealer | 40597 | 911 | 60 | 40657 | -9 | 10 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ROSEX BINDERS | WH1 | DEALER | 40610 | 417 | 60 | 40670 | -22 | 83160 | 1970 | 1970 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JUMANJEE HARDWARE | WH2 | 40637 | 4 | 60 | 40697 | -49 | 75707 | 75707 | 75707 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
RAKSON STEEL TUBE | WH2 | 40471 | 26 | 60 | 40531 | 117 | 120776 | 120776 | 0 | 0 | 0 | 0 | 120776 | 0 | 0 | 0 | 0 | 0
ALEX PIPES | WH2 | 40539 | 81 | 60 | 40599 | 49 | 48311 | 48311 | 0 | 0 | 48311 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LOPAX UTENSILS | WH2 | 40550 | 93 | 60 | 40610 | 38 | 100368 | 100368 | 0 | 0 | 100368 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL |  |  |  |  |  |  |  | 17496581 | 10177390 | 1129884 | 4632583 | 466164 | 122456 | 241552 | 0 | 717 | 0 | 5160514 | 0