Based Excel Accounting Information Systems Design And Implementation,

The Accounting Information System (AIS) is an important component of financial information in enterprises. AIS is an accounting management system which adopt systematology to assist to analyze financial information, design fiscal budget and even forecast possible fiscal consequence so as to improve enterprises'financial manage and financial decisions-making. Due to financial capability and scale, SMEs are unable to purchase commercial software. However, accounting information system is essential in routine management. Therefore a relatively small accounting information system is indispensable for SMEs.The technical route and plan designed by this system use the formidable Function and the VBA programming language provided by Excel. Regarding simple functions of AIS, it is unnecessary to device codes. Excel can handle just right with its own functions ranging from the easy date and time function, the financial analysis function, the statistical analysis function and the supposition analytic function. For the complex, programming language - Visual Basic for Application (VBA) will help. All menu operation can be achieved through the VBA programming as VBA is able to insert Excel directly in the work book, including various functions, methods, objects, attributes and sentences. In addition, VBA may also realize the function which Excel itself does not have, like API function transfer and so on. Therefore, mastering a great deal of methods, objects and attributes in VBA is the key technology carried on the re-development in the Excel platform.The AIS's design is to divide the system into various basic and concrete functional modules building up the whole system through appropriate organization. Generally speaking, there are five basic function modules: certificate processing module, book processing functional module, report processing module, settlement processing module and system maintenance module. Each basic function module possesses several sub-functional modules. In this way, the system can accomplish the entire processing from certificate processing, to book operation processing, to settlement processing, to inquiry retrieval, to fiscal statement, and to fiscal statement analysis. In the course of designing and achieving the system, steady and mature technologies are adopted rather than relatively advanced ones, as it ensures lower cost of system development and proficiency of personnel's skills. In the long run, the system will be very effective and lucrative in the application process.