Design And Achievement Of Financial Software In Liaoyang Commercial Banks

Accounting computerization is computer-based electronics and information technology applied to the accounting practice and uses computer as a tool to replace manual bookkeeping, scores, accounting, etc. in order to achieve collection, collation, output, analysis, forecasting, and decision-making of the accounting information. With the popularity of computer in international and domestic sectors, many of our accounting software come into being. But the majority of accounting software is founded on accounting system. A large number of users must be passively escalated when accounting system is updating. And something needs to be adjusted because of the difference of accounting subjects between application software. To do so for users and software development companies is a waste of resources. Therefore Liaoyang Commercial Banks decide to develop fitting financial software regarding our banks'specific conditions.This article has completed design and achievement of financial software of Liaoyang Commercial Banks regarding commercial banks'specific conditions. This article describes the ideas regarding reform of accounting computerization. Although most of computer software in our banks adopt simulation (manual simulation), but accounting theories under the manual conditions which are based on abacus, pen and ink, account book must match modern technology which is based on computer information. So the impact of accounting computerization to the traditional accounting theories is inevitable. The basic idea of accounting system's reform is that a new accounting system should fully consider the transformation of modern accounting functions under the conditions of accounting computerization from"accounting"to"management", play down the traditional book-centered concept of financial organization, take the evidence for keeping account, each kind of classified and by stages occurrence volume and the remaining sum as the master data, directly deal with, mix and output a variety of books, statements and information relating to management and decision-making.This article carries on the analysis and the research to system's development from technology, economy, society and other aspects regarding specific conditions of Liaoyang Commercial Banks in order to avoid taking a bath and ensure the successful development of the system and also build the environment based on foundation of the banks'hardware for the development.The system has been totally designed according to the requirement of the system functions and each module of this system has been established. The system has seven function modules which include loan charge (input document, the revision of evidences for keeping account, the settlemen t of the account, the printing of evidences for keeping account, the accounting entry, automatic billing, the cancellation of automatic billing), the printing of the account table (the blotter, the general ledger, the Statement of Account, the detail ledger, the material detail ledger, the trial balance [cumulative], the trial balance [the same month], the trial balance [today], the detailed list of debtor-creditor, the code tables of subjects, the auxiliary code tables, the retrieval tables of lending money), the inquiry (the inquiry of the detail ledger, the inquiry of the subject balance, the browsing of the subject balance, the inquiry of evidences for keeping account), the subject management (edition subjects, increase index in batches, deleting index in batches), the data backup (accounting document, accounting subject, forming the Excel document), the system administration (password management, system establishment, transfer year, remaining sum reset, extensive authority) and accounting statement.The Database Design is an important part of the financial software. If a reasonable database model can not be designed, not only will the difficulty of the client side, the server end programming and the maintenance but also the actual movement of the system will be affected. Therefore the database design is very important. The system's operation flow will be first analyzed before system database design and understand entity in the database as well as entity relation. The financial system's operation flow of the banks has been seriously studied and carefully analyzed. The main flow of the service: Economic transactions occur; Accounting vouchers are established; Accounting elements are divided and confirmed; The costs are calculated and recorded in the diary books; The ledger accounts are made till the end of the period; The accounting statements are compiled according to the balance and occurrence of the ledger accounts, meanwhile, report forms are analyzed. Financial system's service should comprehensively reflect the fund operation of enterprises'economic activities. It includes fund investment and withdrawal, circulation and turnover, consumption and reclamation, use and assignment, meanwhile, carry on information forecast, decision-making, budget and analysis to these fund movement. The detailed structure of the database is designed according to the design principle of the database and the main parts of the database-the remaining sum storehouse, the certificate storehouse and accounting entry storehouse are described.Afterward, this article has introduced the main function and sub-function of the banks'financial software achievement, which include bookkeeping processing, printing account table, inquiry, subject management, data backup, and system administration and so on.Finally, this article has narrated the limitation of the financial software and will look into the further work... ERP system achieves the real-time transmission of various modules'information, unified the entire system sets, realize high integration in all aspects in supply chains, reflect the real-time operating status and provide timely and accurate information for managing decision-making. Therefore, using ERP to achieve enterprise informatization is the development of our further work...