Hi,
Can I see the sample of the Bill/PDF file?
Do we need to create excel file for each user on the bill ?
Fine, For the reports we can achieve it by calculating the current and previous amount usage ?
I will provide you the PDF scrapper program, And dashboard which will have the PDF bill import capability and report generation feature.
I am C#/ASP.net expert, I can provide you right solution on your server with training and guideline program.
Thanks
Chetan