Spreadsheet: 814753d1674575957-deferred-revenue-waterfall-formula-help-example-def-rev-file
Sheet: Def Rev Waterfall

Source Date | Source Document Number | Source Type | Revenue Arrangement | Customer | Amount | Total Amount Billed | Total Amount Planned | Total Amount Recognized | Prior unrecognized | Total recognized | Total Amount Deferred | Revenue Element: Start Date | Revenue Element: End Date | Deferred | Unbilled | Keep DR | Keep UB | Comment | MRR |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | Greater than 12
2022-06-15 00:00:00 | SOUS2076 | [NAME] | REVA31448 | x | 376626.96 | 376626.96 | 376626.96 | 188313.48 | 0 | 188313.48 | 188313.48 | 2022-07-01 00:00:00 | 2023-06-30 00:00:00 | 188313.48 | 0 | yes | yes |  | 31385.58
2018-11-30 00:00:00 | SOUS023 | [NAME] | REVA3294 | x | 113198.63 | 113198.63 | 113198.63 | 88169.38 | 0 | 88169.38 | 25029.25 | 2018-11-30 00:00:00 | 2024-02-28 00:00:00 | 25029.25 | 0 | yes | yes |  | 1798.17
2018-11-30 00:00:00 | SOUS025 | [NAME] | REVA3295 | x | 178582.71 | 178582.71 | 178582.71 | 139095.86 | 0 | 139095.86 | 39486.85 | 2018-11-30 00:00:00 | 2024-02-28 00:00:00 | 39486.85000000001 | 0 | yes | yes |  | 2836.79
2018-11-30 00:00:00 | SOUS030 | [NAME] | REVA3365 | x | 62814.7 | 62814.7 | 62814.7 | 48925.95 | 0 | 48925.95 | 13888.75 | 2018-11-30 00:00:00 | 2024-02-28 00:00:00 | 13888.75 | 0 | yes | yes |  | 997.8199999999999
2018-11-30 00:00:00 | SOUS032 | [NAME] | REVA3282 | x | 1069818.47 | 877983.47 | 1069818.47 | 782826.74 | 0 | 782826.74 | 286991.73 | 2018-11-28 00:00:00 | 2024-06-30 00:00:00 | 95156.72999999998 | 0 | yes | yes |  | 15943.98
2018-11-30 00:00:00 | SOUS037 | [NAME] | REVA3303 | x | 23439.03 | 23439.03 | 23439.03 | 18256.39 | 0 | 18256.39 | 5182.64 | 2018-11-30 00:00:00 | 2024-02-28 00:00:00 | 5182.639999999999 | 0 | yes | yes |  | 372.33
2018-12-03 00:00:00 | SOUS056 | [NAME] | REVA3308 | x | 365400.52 | 365400.52 | 365400.52 | 284606.21 | 0 | 284606.21 | 80794.31 | 2018-11-30 00:00:00 | 2024-02-28 00:00:00 | 80794.31 | 0 | yes | yes |  | 5804.4
2021-12-31 00:00:00 | SOUS1945 | [NAME] | REVA28592 | x | 180250 | 180250 | 180250 | 135187.56 | 0 | 135187.56 | 45062.44 | 2022-04-01 00:00:00 | 2023-03-31 00:00:00 | 45062.44 | 0 | yes | yes |  | 15020.84
2022-12-16 00:00:00 | SOUS2383 | [NAME] | REVA35377 | x | 388081 | 121900 | 388081 | 1390.97 | 0 | 1390.97 | 386690.03 | 2022-12-28 00:00:00 | 2025-12-27 00:00:00 | 120509.03 | 0 | yes | yes |  | 10780.03
2022-12-29 00:00:00 | SOUS2453 | [NAME] | REVA35801 | x | 40517 | 40517 | 40517 | 108.92 | 0 | 108.92 | 40408.08 | 2022-12-31 00:00:00 | 2023-12-30 00:00:00 | 40408.08 | 0 | yes | yes |  | 3376.41
2018-12-01 00:00:00 | SOUS069 | [NAME] | REVA3732 | x | 261104.38 | 261104.38 | 261104.38 | 203371.06 | 0 | 203371.06 | 57733.32 | 2018-11-30 00:00:00 | 2024-02-28 00:00:00 | 57733.32000000001 | 0 | yes | yes |  | 4147.65
2018-12-20 00:00:00 | SOUS107 | [NAME] | REVA4028 | x | 83537.8 | 83537.8 | 83537.8 | 65066.58 | 0 | 65066.58 | 18471.22 | 2018-11-30 00:00:00 | 2024-02-28 00:00:00 | 18471.22 | 0 | yes | yes |  | 1327
2018-12-21 00:00:00 | SOUS103 | [NAME] | REVA3903 | x | 1869.15 | 1869.15 | 1869.15 | 1459.22 | 0 | 1459.22 | 409.93 | 2018-11-30 00:00:00 | 2024-02-24 00:00:00 | 409.9300000000001 | 0 | yes | yes |  | 29.76
2021-08-02 00:00:00 | SOUS1752 | [NAME] | REVA25411 | x | 93342 | 61918 | 93342 | 31197.59 | 0 | 31197.59 | 62144.41 | 2021-12-31 00:00:00 | 2024-12-30 00:00:00 | 30720.41 | 0 | yes | yes |  | 2592.83
2021-12-17 00:00:00 | SOUS1903 | [NAME] | REVA28257 | x | 95207 | 95207 | 95207 | 71405.28 | 0 | 71405.28 | 23801.72 | 2022-04-01 00:00:00 | 2023-03-31 00:00:00 | 23801.72 | 0 | yes | yes |  | 7933.92
2021-11-14 00:00:00 | SOUS1859 | [NAME] | REVA27502 | x | 108182 | 71050 | 108182 | 36157.68 | 0 | 36157.68 | 72024.32 | 2021-12-31 00:00:00 | 2024-12-30 00:00:00 | 34892.32 | 0 | yes | yes |  | 3005.06
2019-01-14 00:00:00 | SOUS198 | [NAME] | REVA6723 | x | 2728658 | 1660266 | 2728658 | 1545619.39 | 0 | 1545619.39 | 1183038.61 | 2019-01-14 00:00:00 | 2026-01-13 00:00:00 | 114646.6100000001 | 0 | Yes | yes |  | 32476.83
2019-01-14 00:00:00 | SOUS200 | [NAME] | [NAME] | x | 404419.76 | 269612.28 | 404419.76 | 229079.53 | 0 | 229079.53 | 175340.23 | 2019-01-14 00:00:00 | 2026-01-13 00:00:00 | 40532.75000000003 | 0 | Yes | yes |  | 4813.46
2019-12-27 00:00:00 | SOUS1149 | [NAME] | REVA15233 | x | 168000 | 102000 | 168000 | 83021.39 | 0 | 83021.39 | 84978.61 | 2020-01-14 00:00:00 | 2026-01-13 00:00:00 | 18978.61 | 0 | Yes | yes |  | 2333.33
2019-01-31 00:00:00 | SOUS325 | [NAME] | REVA7245 | x | 139905 | 131904.75 | 139905 | 109634.09 | 0 | 109634.09 | 30270.91 | 2019-01-31 00:00:00 | 2024-01-30 00:00:00 | 22270.66 | 0 | yes | yes |  | 2331.01
2019-10-18 00:00:00 | SOUS976 | [NAME] | REVA13675 | x | 658996 | 429780 | 658996 | 350720.43 | 0 | 350720.43 | 308275.57 | 2019-10-22 00:00:00 | 2025-10-21 00:00:00 | 79059.57 | 0 | yes | yes |  | 9150.37
2021-12-08 00:00:00 | SOUS1881 | [NAME] | REVA28052 | x | 128774 | 128774 | 128774 | 99003.69 | 0 | 99003.69 | 29770.31 | 2022-03-25 00:00:00 | 2023-03-24 00:00:00 | 29770.31 | 0 | yes | yes |  | 10731.17
2022-02-09 00:00:00 | SOUS1973 | [NAME] | REVA29343 | x | 124613 | 61690 | 124613 | 52849.18 | 0 | 52849.18 | 71763.82 | 2022-02-24 00:00:00 | 2024-02-23 00:00:00 | 8840.82 | 0 | yes | yes |  | 5192.200000000001
2019-03-26 00:00:00 | SOUS464 | [NAME] | REVA8135 | x | 146545 | 117236 | 146545 | 110035.57 | 0 | 110035.57 | 36509.43 | 2019-03-30 00:00:00 | 2024-03-29 00:00:00 | 7200.429999999993 | 0 | yes | yes |  | 2441.67
2019-09-12 00:00:00 | SOUS887 | [NAME] | REVA12722 | x | 13520 | 10520 | 13520 | 9782.08 | 0 | 9782.08 | 3737.92 | 2019-09-27 00:00:00 | 2024-03-29 00:00:00 | 737.9200000000001 | 0 | yes | yes |  | 249.98
2022-06-21 00:00:00 | SOUS2090 | [NAME] | REVA31620 | x | 480000 | 120000 | 480000 | 80000.01 | 0 | 80000.01 | 399999.99 | 2022-04-01 00:00:00 | 2026-09-30 00:00:00 | 39999.99000000001 | 0 | yes | yes |  | 8888.89
2022-06-23 00:00:00 | SOUS2093 | [NAME] | REVA31685 | x | 644664.15 | 203291.74 | 644664.15 | 109234.78 | 0 | 109234.78 | 535429.37 | 2022-06-28 00:00:00 | 2025-06-27 00:00:00 | 94056.95999999999 | 0 | yes | yes |  | 17907.34