Spreadsheet: 759823d1639752750-create-a-sum-based-on-a-date-entered-deferred-income-change-period-end-date
Sheet: Dec 21

Deferred Income Calculation
2021-12-31 00:00:00
ID | Organisation | First Joined | Invoice Date | Invoice Number | Start Date | End Date | Currency | Curr. Inv. Value | Inv Value GBP | Days Billed | Years Billed | Inv MRR (Yearly) | Inv MRR (Monthly) | Inv MRR Daily | Days Elapsed | Days Remaining | Revenue Recognised | Deferred Income | Recognised to 30/11/2021 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 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 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
 |  | 2017-01-04 00:00:00 | 2021-02-28 00:00:00 | INV-191217808 | 2021-01-31 00:00:00 | 2022-01-30 00:00:00 | USD | 9000 | 6666.66 |  |  |  |  |  |  |  |  |  | 5573.809999999999
 |  | 2014-01-02 00:00:00 | 2021-01-26 00:00:00 | INV-191217790 | 2021-02-28 00:00:00 | 2022-02-27 00:00:00 | GBP |  | 7350 |  |  |  |  |  |  |  |  |  | 5532.639999999999
 |  | 2021-03-02 00:00:00 | 2021-06-01 00:00:00 | INV-191217778 | 2021-03-02 00:00:00 | 2022-03-01 00:00:00 | CAD$ |  |  |  |  |  |  |  |  |  |  |  | 5224.58
 |  | 2015-03-31 00:00:00 | 2021-05-17 00:00:00 | INV-191217850 | 2021-04-16 00:00:00 | 2022-04-15 00:00:00 | GBP |  | 7350 |  |  |  |  |  |  |  |  |  | 4589.55
 |  | 2019-05-07 00:00:00 | 2021-05-12 00:00:00 | INV-191217849 | 2021-05-07 00:00:00 | 2022-05-06 00:00:00 | GBP |  | 2205 |  |  |  |  |  |  |  |  |  | 1253.53
 |  | 2021-06-02 00:00:00 | 2021-05-05 00:00:00 | INV-191217841 | 2021-06-02 00:00:00 | 2022-06-01 00:00:00 | EUR | 4000 | 3453.56 |  |  |  |  |  |  |  |  |  | 1713.36
 |  | 2017-06-15 00:00:00 | 2021-07-26 00:00:00 | INV-191217919 | 2021-07-06 00:00:00 | 2022-07-05 00:00:00 | CAD$ | 9900 | 5755.81 |  |  |  |  |  |  |  |  |  | 2328.61
 |  | 2021-08-02 00:00:00 | 2021-06-17 00:00:00 | INV-191217881 | 2021-08-02 00:00:00 | 2022-08-01 00:00:00 | USD | 8000 | 5925.92 |  |  |  |  |  |  |  |  |  | 1968.52
 |  | 2018-09-03 00:00:00 | 2021-06-15 00:00:00 | INV-191217879 | 2021-09-03 00:00:00 | 2022-09-02 00:00:00 | USD | 14700 | 10436.53 |  |  |  |  |  |  |  |  |  | 2540.04
 |  | 2018-10-05 00:00:00 | 2021-09-20 00:00:00 | INV-191217949 | 2021-10-07 00:00:00 | 2022-10-06 00:00:00 | USD | 8400 | 6144.81 |  |  |  |  |  |  |  |  |  | 932.920000000001
 |  | 2016-10-31 00:00:00 | 2021-09-21 00:00:00 | INV-191217951 | 2021-11-03 00:00:00 | 2022-11-02 00:00:00 | GBP |  | 8820 |  |  |  |  |  |  |  |  |  | 676.6000000000004
 |  | 2018-12-05 00:00:00 | 2021-11-25 00:00:00 | INV-191217998 | 2021-12-06 00:00:00 | 2022-12-05 00:00:00 | USD | 11000 | 8148.14 |  |  |  |  |  |  |  |  |  | 0
 |  | 2020-01-10 00:00:00 | 2019-10-23 00:00:00 | INV-190925554 | 2021-01-10 00:00:00 | 2023-01-01 00:00:00 | CAD$ | 22800 | 13255.81 |  |  |  |  |  |  |  |  |  | 5927.11
 |  | 2019-02-03 00:00:00 | 2021-02-09 00:00:00 | INV-191217798 | 2021-02-03 00:00:00 | 2023-02-02 00:00:00 | GBP |  | 15960 |  |  |  |  |  |  |  |  |  | 6553.440000000001
 |  | 2019-04-11 00:00:00 | 2021-04-13 00:00:00 | INV-191217832 | 2021-04-11 00:00:00 | 2023-04-10 00:00:00 | GBP |  | 16800 |  |  |  |  |  |  |  |  |  | 5360.27
 |  | 2017-03-01 00:00:00 | 2021-03-16 00:00:00 | INV-191217819 | 2021-05-02 00:00:00 | 2023-05-01 00:00:00 | GBP |  | 14700 |  |  |  |  |  |  |  |  |  | 4279.110000000001
 |  | 2019-06-05 00:00:00 | 2020-10-28 00:00:00 | INV-191217741 | 2021-06-05 00:00:00 | 2023-06-04 00:00:00 | GBP |  | 14000 |  |  |  |  |  |  |  |  |  | 3415.359999999999
 |  | 2016-12-05 00:00:00 | 2020-08-12 00:00:00 | INV-191217698-700 | 2020-07-25 00:00:00 | 2023-07-24 00:00:00 | USD |  |  |  |  |  |  |  |  |  |  |  | 5570.47
 |  | 2019-08-18 00:00:00 | 2021-08-02 00:00:00 | INV-191217928 | 2021-08-18 00:00:00 | 2023-08-17 00:00:00 | USD | 19950 | 14777.76 |  |  |  |  |  |  |  |  |  | 2130.630000000003
 |  | 2018-09-10 00:00:00 | 2021-08-02 00:00:00 | INV-191217926 | 2021-09-11 00:00:00 | 2023-09-10 00:00:00 | USD | 16000 | 11851.84 |  |  |  |  |  |  |  |  |  | 1312.289999999999