September 27, 2023
Excel Entertainment (Excel) is a leading Indian production company, founded by Ritesh Sidhwani and Farhan Akhtar. Excel was using Tally for accounting, but all MIS was prepared manually. The company needed to have automated MIS using Tally and EasyReports was selected for implementation of the MIS structures in Tally and the automated generation of the required reports and dashboards.
Business Problems
- Tally used as accounting solution only and MIS generated manually
- For film, web series and other projects there was a need to capture Project-wise and Budget Code-wise (e.g. Set Construction, Digital Marketing) data
- Spends needed to classified as Above the Line (ATL) and Below the line (BTL)
- Need to capture budgets for projects and specific activities (budget code) within projects
- Automated reporting of imprests pending, vendor advances pending, advances ageing to ensure timely expense booking
Solution Provided
- Consulting and structuring of Tally entry system to capture the required dimensions of projects, budget codes and ATL / BTL spends
- Generation of exception report to provide ready information for entries which are made incorrectly
- Upload of budgets for projects and budget codes – automated reporting of budget vs actual
- Flexible MIS reports and dashboard providing summarised and drill down reporting for projects
- Automated reporting of pending advances, cash vs bank payment, advance and imprest ageing
Benefits
- Harmonized system of entries across projects
- High quality of source data within Tally which is ready for reporting and analytics
- Reduction of manual labour and time from report request to delivery