Design And Implementation Of VAT Audit System Based On ETL

With the rapid development and progress of modern network communication technology,database development and storage technology,it is promoting the rapid improvement of the level of information,automation and intelligent management of government and enterprise units.In e-government,e-commerce,power communications,Financial banking and other fields have been widely popularized and achieved remarkable results.During the application of the bank management information system,capital management,financial management,and loan management have been realized,which has effectively improved the real-time nature of bank office and business management and the scientific nature of bank decision-making.Before the "VAT reform",the banking industry implemented a parallel system of business tax and value-added tax,which made the tax deduction chain of the banking industry not smooth and the overall tax burden was heavy.Manufacturing enterprises,as VAT taxpayers,cannot obtain deductible input tax invoices when obtaining financial services such as loans from banks.To a certain extent,this type of enterprise reduces the demand for banking products,which is not conducive to the development of the banking industry.Therefore,based on the UAP(Unified Application Platform)development platform,this article adopts the current mainstream system development technology and uses ETL(Extract-Transform-Load,extraction-transform-load)technology for data processing to design and implement for the bank A set of value-added tax system was firstly analyzed for use cases and functional requirements,and a detailed requirements analysis report was prepared.On this basis,the overall architecture of the system is designed,and the overall architecture of the system is described and analyzed.After the framework design was proposed,the system's functional modules and database table design were further detailed designed,and the main fields of each logical table and the relationship between the logical tables were elaborated.Through the description of the framework design,module design and module implementation process of the value-added tax system,this article implements the core functions of tax public management,price-tax separation management,value-added tax management and audit management.Bank staff can log in to the system with authorization After logging in,the bank staff can fill in the taxpayer and price-tax separation rules and other information according to the pre-defined form template in the software system,submit the form and store it in the corresponding data table through data processing,and perform data extraction and conversion through the storage process And load,and then calculate the price and tax separation,get the result,and generate the price and tax separation manuscript form,declaration manuscript form,sales billing details and accounting data through the storage process.The designed and implemented VAT audit system can respond to the relevant policies and documents issued by the country in a timely manner,taking Circular 91 as an example to introduce the process of adapting the system,provide support for the future reform of the VAT audit system according to the policy,and adapt it to various policy implementations as a template.