Spreadsheet: 586601d1534458563-need-formula-that-provides-deferred-revenue-for-sas-maintenance-revenue-amortization-schedule
Sheet: Sheet1

Renewal Date | Expiration Date (License) | Created On (Order) | Service Date | Sales Account Number (Product) | Deferral Account Number (Product) | Order Number (Order) | Peachtree ID# (Order) | PO Number (Order) | Owner (Order) | [NAME] | Product | Quantity | License | Unit Price | Tax | Extended Amount | [NAME] | License Term | PP Calculation Method | Description (Order) | License Term (Product) | Freight |  | Account (Order) | Extended Amount w/adj for Perp | MTHLY $ | PMT Terms (was PT GL) | PT GL | COMPARE VELA SHEETS | bs | rev | bs | 2015-10-31 00:00:00 | 2015-11-30 00:00:00 | 2015-12-31 00:00:00 | 2016-01-31 00:00:00 | 2016-02-29 00:00:00 | 2016-03-31 00:00:00 | 2016-04-30 00:00:00 | 2016-05-31 00:00:00 | 2016-06-30 00:00:00 | 2016-07-31 00:00:00 | 2016-08-31 00:00:00 | 2016-09-30 00:00:00 | 2016-10-31 00:00:00 | 2016-11-30 00:00:00 | 2016-12-31 00:00:00 | 2017-01-31 00:00:00 | 2017-02-28 00:00:00 | 2017-03-31 00:00:00 | 2017-04-30 00:00:00 | 2017-05-31 00:00:00 | 2017-06-30 00:00:00 | 2017-07-31 00:00:00 | 2017-08-31 00:00:00 | 2017-09-30 00:00:00 | 2017-10-31 00:00:00 | 2017-11-30 00:00:00 | 2017-12-31 00:00:00 | 2018-01-31 00:00:00 | 2018-02-28 00:00:00 | 2018-03-31 00:00:00 | 2018-04-30 00:00:00 | 2018-05-31 00:00:00 | 2018-06-30 00:00:00 | 2018-07-31 00:00:00 | 2018-08-31 00:00:00 | 2018-09-30 00:00:00 | 2018-10-31 00:00:00 | 2018-11-30 00:00:00 | 2018-12-31 00:00:00 | 2019-01-31 00:00:00 | 2019-02-28 00:00:00 | 2019-03-31 00:00:00 | 2019-04-30 00:00:00 | 2019-05-31 00:00:00 | 2019-06-30 00:00:00 | 2019-07-31 00:00:00 | 2019-08-31 00:00:00 | 2019-09-30 00:00:00 | 2019-10-31 00:00:00 | 2019-11-30 00:00:00 | 2019-12-31 00:00:00 | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | Total | Check | YTD 2016 | YTD 2017 | YTD 2018 | YTD 2019 | YTD 2020 | YTD 2021 | YTD 2022
2019-06-30 00:00:00 | 2019-06-30 00:00:00 | 2018-05-02 09:43:29 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1240 | 11 | 12 | 2
2019-05-31 07:00:00 | 2019-05-31 07:00:00 | 2018-05-02 10:50:56 |  |  |  |  |  |  |  |  |  |  |  |  |  | 240 | 11 | 12 | 2 |  |  | 0
2019-05-31 00:00:00 | 2019-05-31 00:00:00 | 2018-05-02 12:41:37 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1485 | 11 | 12 | 2
2019-05-31 00:00:00 | 2019-05-31 00:00:00 | 2018-05-02 12:41:37 |  |  |  |  |  |  |  |  |  |  |  |  |  | 744 | 11 | 12 | 2
2019-05-31 00:00:00 | 2019-05-31 00:00:00 | 2018-05-02 12:41:37 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1488 | 11 | 12 | 2
2019-05-31 00:00:00 | 2019-05-31 00:00:00 | 2018-05-02 12:41:37 |  |  |  |  |  |  |  |  |  |  |  |  |  | 744 | 11 | 12 | 2
2019-02-28 00:00:00 | 2019-02-28 00:00:00 | 2018-06-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 144 | 11 | 12 | 2 |  |  |  |  |  | 393
2019-05-31 00:00:00 | 2019-05-31 00:00:00 | 2018-05-02 12:03:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24750 | 11 | 12 | 2
2019-06-30 00:00:00 | 2019-06-30 00:00:00 | 2018-05-02 11:37:58 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2475 | 11 | 12 | 2