Hi,

My company keeps track of and charges for the support time we offer to clients in desk. I want to be able to track how much time each customer against how long they have left on their contract, ideally this process will end up being fully automated and integrated in Zoho.

I have found the tickets data in Zoho Analytics and have set up a table showing how much support time each of our customers have used per month. However, I want to be able to track this against how much time they have available (since invoice was paid). 

At the moment I have manually added all our companies and their invoice dates in Excel, and taken the desk data out of Zoho into the Excel sheet. One of the main issues I have with this method is that I would have to manually update this info whenever I see fit. 

Is there a more efficient way I can automate this entire process? Any help would be great.