Development and Application of Financial Analysis Report Robot Based on RPA and VBA Technology

Financial analysis is an important basis for managers and stakeholders to make scientific decisions, and plays a pivotal role in financial management. Financial analysis not only needs to extract data and analyze indicators, but also needs to analyze the causes of data formation, which is time-consuming and laborious. This paper develops financial analysis report robot with RPA, VBA and other technologies, and practices. Practice has proved that the use of new technology for financial analysis saves a lot of time for financial personnel, and the extracted and calculated data are very correct, in order to provide reference for financial analysis work of financial personnel.