Spreadsheet: 668665d1584970187-deferred-revenue-schedule-for-saas-excelforumhelp
Sheet: Revenue

Customer Number | Start Date | End Date | Annual Rate | Term (Corrected) | Term(Days) | Daily Rate |  |  | Customer Number | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | Total | [NAME]
10001 | 2019-10-01 00:00:00 | 2020-09-30 00:00:00 | 320000 | 12 |  |  |  |  | 10001 | 27103.82513661202 | 26229.50819672131 | 27103.82513661202 | 27103.82513661202 | 25355.1912568306 | 27103.82513661202 | 26229.50819672131 | 27103.82513661202 | 26229.50819672131 | 27103.82513661202 | 27103.82513661202 | 26229.50819672131
10002 | 2019-10-01 00:00:00 | 2020-09-30 00:00:00 | 80000 | 12 |  |  |  |  | 10002
10003 | 2019-10-01 00:00:00 | 2020-02-05 00:00:00 | 25000 | 5 |  |  |  |  | 10003
10004 | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 20000 | 3 |  |  |  |  | 10004
10005 | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 30000 | 3 |  |  |  |  | 10005
10006 | 2019-10-01 00:00:00 | 2020-09-30 00:00:00 | 60000 | 12 |  |  |  |  | 10006
10007 | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 75000 | 3 |  |  |  |  | 10007
10008 | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 40000 | 3 |  |  |  |  | 10008
10009 | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 100000 | 3 |  |  |  |  | 10009
10010 | 2019-10-02 00:00:00 | 2020-01-01 00:00:00 | 80000 | 3 |  |  |  |  | 10010 | 26086.95652173913 | 26086.95652173913 | 26956.52173913044 | 869.5652173913044
10011 | 2019-10-02 00:00:00 | 2020-10-01 00:00:00 | 250000 | 12 |  |  |  |  | 10011
10012 | 2019-10-02 00:00:00 | 2020-04-01 00:00:00 | 50000 | 6 |  |  |  |  | 10012
10013 | 2019-10-03 00:00:00 | 2020-04-02 00:00:00 | 50000 | 6 |  |  |  |  | 10013
10014 | 2019-10-03 00:00:00 | 2020-10-02 00:00:00 | 30000 | 12 |  |  |  |  | 10014
10015 | 2019-10-05 00:00:00 | 2020-04-04 00:00:00 | 50000 | 6 |  |  |  |  | 10015
10016 | 2019-10-05 00:00:00 | 2020-01-06 00:00:00 | 180000 | 3 |  |  |  |  | 10016
10017 | 2019-10-07 00:00:00 | 2020-10-06 00:00:00 | 50000 | 12 |  |  |  |  | 10017
10018 | 2019-10-10 00:00:00 | 2020-04-09 00:00:00 | 130000 | 6 |  |  |  |  | 10018
10019 | 2019-10-10 00:00:00 | 2020-04-09 00:00:00 | 100000 | 6 |  |  |  |  | 10019
10020 | 2019-10-11 00:00:00 | 2020-05-10 00:00:00 | 30000 | 7 |  |  |  |  | 10020
10021 | 2019-10-12 00:00:00 | 2020-04-11 00:00:00 | 70000 | 6 |  |  |  |  | 10021
10022 | 2019-10-12 00:00:00 | 2020-10-11 00:00:00 | 200000 | 12 |  |  |  |  | 10022
10023 | 2019-10-15 00:00:00 | 2020-04-14 00:00:00 | 50000 | 6 |  |  |  |  | 10023
10024 | 2019-10-15 00:00:00 | 2020-02-14 00:00:00 | 75000 | 4 |  |  |  |  | 10024
10025 | 2019-10-15 00:00:00 | 2020-04-14 00:00:00 | 100000 | 6 |  |  |  |  | 10025
10026 | 2019-10-15 00:00:00 | 2020-10-14 00:00:00 | 90000 | 12 |  |  |  |  | 10026
10027 | 2019-10-16 00:00:00 | 2020-04-15 00:00:00 | 180000 | 6 |  |  |  |  | 10027
10028 | 2019-10-17 00:00:00 | 2020-04-16 00:00:00 | 40000 | 6 |  |  |  |  | 10028
10029 | 2019-10-17 00:00:00 | 2020-04-16 00:00:00 | 75000 | 6 |  |  |  |  | 10029
10030 | 2019-10-19 00:00:00 | 2020-01-18 00:00:00 | 100000 | 3 |  |  |  |  | 10030
10031 | 2019-10-20 00:00:00 | 2020-10-19 00:00:00 | 50000 | 12 |  |  |  |  | 10031
10032 | 2019-10-20 00:00:00 | 2020-01-19 00:00:00 | 20000 | 3 |  |  |  |  | 10032
10033 | 2019-10-22 00:00:00 | 2020-04-21 00:00:00 | 220000 | 6 |  |  |  |  | 10033
10034 | 2019-10-23 00:00:00 | 2020-10-22 00:00:00 | 85000 | 12 |  |  |  |  | 10034
10035 | 2019-10-24 00:00:00 | 2020-04-23 00:00:00 | 40000 | 6 |  |  |  |  | 10035
10036 | 2019-10-26 00:00:00 | 2020-10-25 00:00:00 | 90000 | 12 |  |  |  |  | 10036
10037 | 2019-10-26 00:00:00 | 2020-04-25 00:00:00 | 30000 | 6 |  |  |  |  | 10037
10038 | 2019-10-26 00:00:00 | 2020-10-25 00:00:00 | 760000 | 12 |  |  |  |  | 10038
10039 | 2019-10-27 00:00:00 | 2020-01-26 00:00:00 | 40000 | 3 |  |  |  |  | 10039
10040 | 2019-10-29 00:00:00 | 2020-10-28 00:00:00 | 70000 | 12 |  |  |  |  | 10040