Revenue allocation and Churn Analyses based on periodic Billing Cycle

We are trying to Build Revenue dashboard derived from Billing Amount and also trying to carry out Revenue Churn Analyses in the same Dashboard.

Current Problems

1. we have customer paying (Monthly/Annually/Semi-Annually/Quarterly/Biennially/Triennially/one time/Null (1 month). How to capture and distribute revenue based on billing cycle.  

2. If service start somewhere in middle of the month. we want to allocate revenue in the that month and deffered the revenue to another month revenue based on service date we are offering.

3. How to Analyze Churn Hard "lost"/Soft"Downgrade in service"/ Add " Upgrade in service"/ New "new client". We want to see the churn trend to forecast the revenue more accuaretly for each service line. 

Hard Churn

As you see I go back 90 days to see the trasaction and compare any trasaction from the client in 31days to identify chrun. But this misses triennially/annuall churn. 

New Churn

Same logic is been implied here and again same problem due to billing cycle

Soft/Add service: How can i measure this churn because I'm not able to distribute the Churn on table because of no correlation between the dates.

We carrying out manually on excel but it slow and not able to analyze based on service line/ country/state and all. so want to automate the process to slice and dice the data analyses. Attaching data sample link https://docs.google.com/spreadsheets/d/1BPJG8MWxfgg-hqxrfhQG1tKeTVO-4-W9iUcV6EGkftQ/edit?usp=sharing 

Expected output

This reconciles Revenue ( monthly revenue, allocated deffered revenue, classify revenue churn).