π Introduction and need of Automation of Financials
π Financial Statements - Challenges to have reporting on BranchWise/RegionWise/Consolidated/MonthWise/QtrWise/YTD/Trending etc
π Issue with Trial Balance from different ERPs
πPreparationn organising TBs to ease out Automation
π Consolidation of TBs with Utility/Power Query
π Creating different Masters- Why Masters are important for any automation
π 10 Most used formuals one need to master before starting automation
π Currency Conversion when multiple currencies are involved
π Reporting based on Thousands/Lakhs/Crores/Absolute
π Customization for Last Year figures/Comparison with Budgets
π Reporting with Charts to make it more user friendly/Interactive
π Navigation of Reporting with the help of dropdowns/slicers
π Dashboarding/Formatting/Presentation/PPTs - How to do it
π Update New Data and everything will be updates within seconds
π Q&A