Spreadsheet: 390299d1429591431-countif-question-receivables-overdue
Sheet: Invoices

Current | 2016-07-01 00:00:00
Invoice Nbr | Company | Sales Rep | Sales Rep Commission | Invoice Date | Invoice Amount | Days Past Due | Current | 1-30 days | 31-60 days | 61-90 days | Over 90 days
10269 | Coalescent Technologies Corporation | Bright |  | 2016-06-02 00:00:00 | 676
10273 | Consortium for Ocean Leadership | [NAME] |  | 2016-05-28 00:00:00 | 2142.4
10274 | [NAME] | [NAME] |  | 2016-06-05 00:00:00 | 538.6
10282 | MRSI Group, Inc | Bright |  | 2016-06-09 00:00:00 | 155.4
10283 | Natural Environment Research Co | Newton |  | 2016-06-12 00:00:00 | 1414.8
10291 | Normandeau & Associates | Bright |  | 2016-05-17 00:00:00 | 552.8
10321 | Alpharma,Inc | Newton |  | 2016-05-05 00:00:00 | 144
10322 | Alternatives Res & Dev Fdtn | Bright |  | 2016-05-07 00:00:00 | 112
10323 | Cardio Tech International Inc. | Bright |  | 2016-05-08 00:00:00 | 164.4
10327 | Citizens for the Protection of Waverly Bay | [NAME] |  | 2016-06-10 00:00:00 | 2262.5
10329 | Image Acoustics, Inc. | Newton |  | 2016-06-27 00:00:00 | 4819.4
10356 | New Mexico Regional Turf Foundation | Bright |  | 2016-05-29 00:00:00 | 1106.4
10358 | Ocean Dynamics Inc. | Bright |  | 2016-06-02 00:00:00 | 452
10368 | Synergy Innovations, Inc. | Bright |  | 2016-06-06 00:00:00 | 1834.2
10370 | Materials Sciences Corporation | [NAME] |  | 2016-05-05 00:00:00 | 1174
10395 | Ekloff Marine Corp. | [NAME] |  | 2016-01-26 00:00:00 | 2333.2
10400 | Hazen Research Inc. | Bright |  | 2016-06-01 00:00:00 | 3063
10401 | [NAME], Inc. | Bright |  | 2016-06-01 00:00:00 | 3868.6
10406 | Mikel, Inc. | [NAME] |  | 2016-02-07 00:00:00 | 2018.2
10407 | Marine BioConversion, LLC | [NAME] |  | 2016-02-07 00:00:00 | 1194
10410 | New Medical Center | Bright |  | 2016-05-10 00:00:00 | 802
10413 | Advanced Scientific Concepts, Inc. | Newton |  | 2016-06-16 00:00:00 | 2123.2
10418 | American Heart Association | Newton |  | 2016-05-17 00:00:00 | 1814.8
10430 | Foster Corporation | Bright |  | 2016-05-02 00:00:00 | 5796
10432 | Jet Propulsion Laboratory | Bright |  | 2016-05-05 00:00:00 | 485
10436 | Lyme Disease Assoc of NJ | Bright |  | 2016-05-08 00:00:00 | 2210.8
10439 | Institute for Research & Evaluation | Bright |  | 2016-05-10 00:00:00 | 1078
10443 | Lincoln Institute of Policy | Newton |  | 2016-06-15 00:00:00 | 537.6
10463 | Pro Change Behavior Systems | [NAME] |  | 2016-06-06 00:00:00 | 713.3
10471 | American Psychology Foundation | Newton |  | 2016-06-11 00:00:00 | 1328
10473 | Boston Medical Center | [NAME] |  | 2016-06-15 00:00:00 | 230.4
10476 | CSCS Corp. | [NAME] |  | 2016-06-17 00:00:00 | 182.4
10480 | Promire Gas Company | Newton |  | 2016-05-20 00:00:00 | 756
10482 | Shire Development Inc. | Newton |  | 2016-06-21 00:00:00 | 147
10483 | Global Environment & Technology Foundation | Newton |  | 2016-05-26 00:00:00 | 704
10484 | Argonne National Laboratories | Newton |  | 2016-06-26 00:00:00 | 386.2
10496 | Lake Simco Conservation Authority | Newton |  | 2016-05-05 00:00:00 | 200
10500 | Perry Institute for Marine Science | Bright |  | 2016-05-10 00:00:00 | 550.8
10502 | Save the Lions | [NAME] |  | 2016-05-11 00:00:00 | 816.3
10520 | Army Corp | [NAME] |  | 2016-04-30 00:00:00 | 200
10527 | Cape Cod National Seashore NPS | [NAME] |  | 2016-06-05 00:00:00 | 1670
10539 | Emitech | Newton |  | 2016-06-16 00:00:00 | 355.5
10551 | Genix Therapeutics, Inc. | Newton |  | 2016-06-28 00:00:00 | 1836
10559 | Nationa Park and Recreation | Bright |  | 2016-06-06 00:00:00 | 547.8
10566 | NM  State Agricultural Experiment Station | Newton |  | 2016-06-15 00:00:00 | 2040
10567 | Northeast Fisheries Science Center | Newton |  | 2016-06-15 00:00:00 | 3109
10571 | SAECT | Newton |  | 2016-06-18 00:00:00 | 647.75
10575 | _x000D_ Environ Protection Agcy | [NAME] |  | 2016-06-21 00:00:00 | 2147.4
10577 | Altuna International Research Co. | Newton |  | 2016-06-26 00:00:00 | 569
10578 | Bigelow Laboratory for Mining | Newton |  | 2016-06-25 00:00:00 | 477
10586 | BoBell Flavors, Inc | [NAME] |  | 2016-05-20 00:00:00 | 28
10588 | Brossman Engineering | Bright |  | 2016-05-28 00:00:00 | 3900
10589 | Cadmus Group | [NAME] |  | 2016-05-29 00:00:00 | 72
10590 | Catalyst Foundation | Newton |  | 2016-05-30 00:00:00 | 1140
10622 | Evans Hamilton Inc. | Newton |  | 2016-06-02 00:00:00 | 605
10623 | Intervet International B.V. | [NAME] |  | 2016-06-05 00:00:00 | 1429.75
10625 | Laser Fare Advanced Technology Group | Newton |  | 2016-06-06 00:00:00 | 479.75
10629 | Medical Tech International, Inc | Newton |  | 2016-06-05 00:00:00 | 2775.05
10640 | NOMAD Limited | Bright |  | 2016-06-15 00:00:00 | 945
10667 | Northeast Regional Aquaculture Center | [NAME] |  | 2016-05-25 00:00:00 | 1921
10671 | Sensor Tech, Inc. | Bright |  | 2016-06-08 00:00:00 | 920.1
10676 | Sino Development Corporation Ltd. | Bright |  | 2016-06-15 00:00:00 | 534.85
10678 | SORICO | Bright |  | 2016-06-18 00:00:00 | 5256.5
10686 | Swedish Board of Fisheries SBF | Bright |  | 2016-06-16 00:00:00 | 1638.45
10687 | St Jeremy Hospital | [NAME] |  | 2016-06-19 00:00:00 | 6201.9
10689 | Acquisition Center | Bright |  | 2016-05-06 00:00:00 | 630
10702 | FM Global Research | Bright |  | 2016-06-25 00:00:00 | 330
10707 | Lamont-Doherty Earth Observatory | [NAME] |  | 2016-06-29 00:00:00 | 1704
10741 | Lemelson Foundation - NCIIA | Newton |  | 2016-06-30 00:00:00 | 285
10760 | Conrad | [NAME] |  | 2016-05-21 00:00:00 | 3304
10763 | Nalas Engineering Services, Inc. | Newton |  | 2016-06-05 00:00:00 | 616
10768 | [NAME] | Newton |  | 2016-01-08 00:00:00 | 1477
10776 | Chemo International Inc. | Bright |  | 2016-06-15 00:00:00 | 6984.5
10787 | Child Wilfare Institute | Bright |  | 2016-01-19 00:00:00 | 2760.8
10790 | Ecochlor | [NAME] |  | 2016-05-22 00:00:00 | 850
10807 | Emitech, Inc | [NAME] |  | 2016-05-31 00:00:00 | 18.4
10815 | Kent Electric | Newton |  | 2016-05-05 00:00:00 | 40
10831 | American Cancer Society | Bright |  | 2016-06-16 00:00:00 | 2684.4
10840 | DHS Medical Assistance | Bright |  | 2016-06-19 00:00:00 | 264
10858 | EA Engineering, Science & Technology, Inc. | [NAME] |  | 2016-02-29 00:00:00 | 649
10864 | KM Scientific Company | [NAME] |  | 2016-05-06 00:00:00 | 282
10881 | Russell Wisdom Foundation | Bright |  | 2016-05-15 00:00:00 | 150
10887 | Eknor Apex Company | [NAME] |  | 2016-05-15 00:00:00 | 70
10907 | Maxwell Technologies | Bright |  | 2016-05-27 00:00:00 | 108.5
10926 | Memory Pharmaceuticals, Inc | [NAME] |  | 2016-06-05 00:00:00 | 514.4
10935 | Alaska Department of Fish & Game | Bright |  | 2016-06-08 00:00:00 | 700
10946 | Ardane Therapeutics | [NAME] |  | 2016-06-11 00:00:00 | 1407.5
10957 | Frontier Technology. Inc. | Newton |  | 2016-04-17 00:00:00 | 1762.7
10960 | Institute of Technology | [NAME] |  | 2016-06-18 00:00:00 | 276.6
10962 | Merck Sharp & Dohme Corp. | Bright |  | 2016-04-18 00:00:00 | 3584
10963 | GreenFins LLC | Bright |  | 2016-06-18 00:00:00 | 68
10966 | Pam Roddick Housing Authority | Newton |  | 2016-06-19 00:00:00 | 1255.6
10967 | The Armore Corporation | Bright |  | 2016-06-22 00:00:00 | 910.4
10982 | Hudson River group | [NAME] |  | 2016-06-26 00:00:00 | 1014
10996 | IODP Management  International, Inc | Newton |  | 2016-05-02 00:00:00 | 560
10998 | IUCN-Washington Office | Newton |  | 2016-03-05 00:00:00 | 686
11007 | Optodot Corporation | Bright |  | 2016-05-08 00:00:00 | 2633.9
11026 | Adaptive Methods, Inc. | [NAME] |  | 2016-03-15 00:00:00 | 1030
11037 | Advanced Fuel Research | [NAME] |  | 2016-05-21 00:00:00 | 60
11064 | BAE Systems | [NAME] |  | 2016-05-31 00:00:00 | 4722.3
11068 | Baylor Research Institute | Bright |  | 2016-06-05 00:00:00 | 2384.8
11069 | CACI Technologies, Inc. | Bright |  | 2016-03-05 00:00:00 | 360