Spreadsheet: 749619d1632932378-aging-schedule-formula-add-on-aging-example
Sheet: AR Aging - 7.31.21

 |  |  |  |  | 2021-07-31 00:00:00
 | Amount | Service Date | Date Paid |  | Days Outstanding | 0-30 Days | 31-60 Days | 61-90 Days | 91+ Days
Invoice 1 | 1761.75 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 2 | 1221.75 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 3 | 66.23 | 2021-02-28 00:00:00 | 2021-07-27 00:00:00
Invoice 4 | 265.14 | 2020-12-31 00:00:00 | 2021-02-23 00:00:00
Invoice 5 | 2119.5 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 6 | 881.2 | 2020-12-31 00:00:00 | 2021-02-23 00:00:00
Invoice 7 | 748.31 | 2021-05-31 00:00:00 | 2021-07-27 00:00:00
Invoice 8 | 845.68 | 2021-04-30 00:00:00 | 2021-07-27 00:00:00
Invoice 9 | 1039.51 | 2021-05-31 00:00:00 | 2021-07-27 00:00:00
Invoice 10 | 823.03 | 2021-05-31 00:00:00 | 2021-07-27 00:00:00
Invoice 11 | 671.26 | 2021-05-31 00:00:00 | 2021-07-27 00:00:00
Invoice 12 | 1337.36 | 2021-03-31 00:00:00 | 2021-07-27 00:00:00
Invoice 13 | 280 | 2020-11-30 00:00:00 | 2021-02-23 00:00:00
Invoice 14 | 750 | 2021-01-31 00:00:00 | 2021-02-23 00:00:00
Invoice 15 | 1000 | 2020-06-30 00:00:00 | 2020-10-15 00:00:00
Invoice 16 | 1215 | 2021-08-31 00:00:00 | 00:00:00
Invoice 17 | 1215 | 2021-01-31 00:00:00 | 2021-04-26 00:00:00
Invoice 18 | 1215 | 2020-12-31 00:00:00 | 2021-02-23 00:00:00
Invoice 19 | 1215 | 2021-08-31 00:00:00 | 00:00:00
Invoice 20 | 1215 | 2021-01-31 00:00:00 | 2021-04-26 00:00:00
Invoice 21 | 1215 | 2020-12-31 00:00:00 | 2021-02-23 00:00:00
Invoice 22 | 2430 | 2021-03-31 00:00:00 | 2021-04-26 00:00:00
Invoice 23 | 2430 | 2021-06-30 00:00:00 | 2021-07-27 00:00:00
Invoice 24 | 1215 | 2021-08-31 00:00:00 | 00:00:00
Invoice 25 | 1215 | 2020-12-31 00:00:00 | 2021-02-23 00:00:00
Invoice 26 | 1215 | 2021-06-30 00:00:00 | 2021-07-27 00:00:00
Invoice 27 | 1215 | 2021-01-31 00:00:00 | 2021-04-26 00:00:00
Invoice 28 | 1215 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 29 | 1215 | 2021-01-31 00:00:00 | 2021-04-26 00:00:00
Invoice 30 | 1215 | 2021-07-31 00:00:00 | 2021-08-30 00:00:00
Invoice 31 | 1215 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 32 | 1215 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 33 | 1215 | 2021-04-30 00:00:00 | 2021-07-27 00:00:00
Invoice 34 | 1215 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 35 | 1215 | 2021-07-31 00:00:00 | 2021-08-30 00:00:00
Invoice 36 | 6075 | 2021-04-30 00:00:00 | 2021-04-26 00:00:00
Invoice 37 | 4860 | 2021-05-31 00:00:00 | 2021-07-27 00:00:00
Invoice 38 | 2430 | 2021-06-30 00:00:00 | 2021-07-27 00:00:00
Invoice 39 | 2430 | 2021-03-31 00:00:00 | 2021-04-26 00:00:00
Invoice 40 | 5000 | 2021-04-30 00:00:00 | 2021-07-27 00:00:00
Invoice 41 | 3483 | 2020-12-31 00:00:00 | 2021-02-23 00:00:00
Invoice 42 | 1400 | 2021-01-31 00:00:00 | 2021-02-23 00:00:00
Invoice 43 | 350 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 44 | 700 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 45 | 700 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 46 | 350 | 2021-04-30 00:00:00 | 2021-07-27 00:00:00
Invoice 47 | 1000 | 2021-01-31 00:00:00 | 2021-02-23 00:00:00
Invoice 48 | 900 | 2021-03-31 00:00:00 | 2021-04-26 00:00:00
Invoice 49 | 200 | 2021-04-30 00:00:00 | 2021-04-26 00:00:00
Invoice 50 | 700 | 2021-04-30 00:00:00 | 2021-07-27 00:00:00
Invoice 51 | 100 | 2021-04-30 00:00:00 | 2021-07-27 00:00:00
Invoice 52 | 14150 | 2020-09-30 00:00:00 | 2020-10-15 00:00:00
Invoice 53 | 1215 | 2020-11-30 00:00:00 | 2020-12-18 00:00:00
Invoice 54 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 55 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 56 | 100 | 2021-01-31 00:00:00 | 2021-04-26 00:00:00
Invoice 57 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 58 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 59 | 100 | 2021-01-31 00:00:00 | 2021-04-26 00:00:00
Invoice 60 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 61 | 100 | 2021-01-31 00:00:00 | 2021-04-26 00:00:00
Invoice 62 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 63 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 64 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 65 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 66 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 67 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00
Invoice 68 | 100 | 2021-01-31 00:00:00 | 2021-04-26 00:00:00
Invoice 69 | 100 | 2021-01-31 00:00:00 | 2021-04-26 00:00:00
Invoice 70 | 100 | 2021-02-28 00:00:00 | 2021-04-26 00:00:00