Financial reporting is one of the topmost and statutory requirements in every organization. Having to report branch-wise, region-wise, month-wise, quarter-wise, year-to-date, trending analysis, etc is an extremely challenging and tedious task. A smart use of Excel can make our lives easier and promote efficient behavior. We can also build lot of interactive charts that catches your eyes while repairing financial statements.
π 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