CN115907938A - Financial management system - Google Patents

Abstract

The invention discloses a financial management system, which comprises: the user authority module is built according to data and role dimensions, authority management is carried out on organization information, employee information and authority, and the fact that all organization users can only access data of the organization is achieved, and all responsibility users can only operate the data in the authority of the organization; the financial institution database comprises financial institution main data, contact persons, product information, cooperation cases and an evaluation system; the financial institution main page is used for providing institution list information which can be classified or searched according to institution types; the bank account management module is used for standardizing the opening, canceling and changing processes of the bank account, perfecting a management system of main data of the bank account, realizing full life cycle management from opening to canceling of the bank account and automatically generating a bank management ledger. According to the invention, the manual workload is reduced by automatically calculating the data. And the automatic data statistics is realized by standardizing data specifications.

Description

Financial management system

Technical Field

The invention relates to the technical field of financial information, in particular to a financial management system.

Background

In recent years, enterprise investment business is rapidly increased, investment areas are expanded, some enterprises develop overseas, and the sharp increase of investment on demands brings higher challenges and development opportunities for financing departments. To support the financing needs and sustainable development of the group. In the future, the finance department will further develop into business department and even stock control group to better support the group financing requirement.

The current business process is dispersed, and the front end and the back end of the whole business process cannot be communicated, so that the basic information management of the information verification before and after the business takes more time, and the information collection at each time takes a lot of time because no credible mechanism and item information source are centralized.

Disclosure of Invention

In order to overcome the defects in the prior art, the invention provides a financial management system which realizes automatic data statistics by standardizing data.

The invention is realized by the following technical scheme:

a financial management system, comprising:

the user authority module is built according to data and role dimensions, the data is used for shielding the data, the roles are responsible for distinguishing different responsibilities and functions, authority management is carried out on organization information, employee information and authority, and the fact that all organization users can only access data organized by themselves is achieved, and all responsibility users can only operate the data in the authority of themselves;

the financial institution database comprises financial institution main data, contacts, product information, cooperation cases and an evaluation system, wherein the evaluation system is an evaluation result obtained by integrating the financial institution main data and the cooperation case historical evaluation;

the financial institution main page is used for providing institution list information which can be classified or searched according to institution types;

the bank account management module is used for standardizing the opening, canceling and changing processes of the bank account, perfecting a management system of main data of the bank account, realizing full life cycle management from opening to canceling of the bank account and automatically generating a bank management ledger.

The system of the invention is further improved in that the organization comprises a project implementation main body and a project signing main body organization, and service data information shielding is carried out according to the organization;

the system of the invention is further improved in that an organization hierarchical relationship is established among the organizations, and the organizations at the parent level have access to all the organized data contained under the hierarchy.

The system of the invention is further improved in that the organization comprises an association organization of people, the relationship of users and the organization is established, and after the organization is assigned to a user, the user is allowed to access the organization.

The system is further improved in that the employee information is the basic information of the employee, the employee is bound with the account, the duty is bound with the account, and meanwhile, the duty is bound with the organization, so that the dual-permission limitation of the employee on the duty permission and the data permission is realized.

The system of the invention is further improved in that the responsibility authority is set according to different service types.

The system is further improved in that the financial institution database is provided with financial institution main data maintenance specifications, the submitted data is checked against the business card image information uploaded by scanning, the integrity and the normalization are checked, and the business card image information is checked to be passed and is stored in a warehouse after the system checks the integrity.

Due to the adoption of the technical scheme, the invention has the beneficial effects that:

data filling is automatically performed in a default mode, and the time for manually collecting data is reduced; mandatory filling data management is carried out, and data filling quality is improved; and data calculation is automatically carried out, and the manual workload is reduced. And the automatic data statistics is realized by standardizing the data specifications.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

Fig. 1 is a system architecture diagram of a financial management system according to an embodiment of the present invention.

Detailed Description

Some terms referred to herein are to be interpreted as follows:

OA: office Automation (OA for short) is a new Office mode formed by applying modern technologies such as computer and communication to the traditional Office mode.

ERP: enterprise Resource Planning (Enterprise Resource Planning) is the next generation of manufacturing systems and Resource Planning software for MRP II (Enterprise manufacturing Resource Planning). In addition to the functions of production resource planning, manufacturing, finance, sales, procurement, etc. already existing in MRP II, the system also has quality management, laboratory management, business process management, product data management, inventory, distribution and transportation management, human resource management and periodic reporting systems.

SQL Server: is a comprehensive database platform that provides enterprise-level data management using integrated Business Intelligence (BI) tools. The SQL Server database engine provides a safer and more reliable storage function for the relational data and the structured data, so that a high-availability and high-performance data application program for business can be constructed and managed.

Angular: the method is characterized by being the rewrite of AngularJS, being a front-end frame for constructing a user interface, being an application design frame and a development platform, being used for creating efficient, complex and exquisite single-page application, expanding HTML through new attributes and expressions, and realizing a set of frames, multiple platforms, a mobile end and a desktop end.

A Spire component: is an enterprise-level NET Office operations component.

And (3) a View layer: are some display pages (jsp, html, etc.) at the front end.

Spring Boot: is a completely new framework provided by the Pivotal team, designed to simplify the initial set-up and development process of new Spring applications. The SpringBoot completes the integration of various frameworks, so that the frameworks are integrated more simply, and the complicated template configuration in the integration process is simplified.

Vue 3: is a library written in TypeScript that can enjoy automatic type-defined hints.

JSON: (JavaScript Object Notation, JS Object Notation) is a lightweight data exchange format.

SpreadJS: the control is a pure front-end table control, is compatible with more than 450 Excel formulas based on HTML5, and has the product characteristics of high performance, cross-platform and high compatibility with Excel. The SpreadJS is highly similar to Excel in interface and function, but is not limited to Excel, and provides application scene support of form document collaborative editing, data filling and Excel report-like design for an enterprise information system, so that enterprise research and development cost and project delivery risk are greatly reduced.

WCF: the Windows Communication Foundation is a series of application program frameworks developed by microsoft and supporting data Communication, and can be translated into a Windows Communication development platform.

DM: the tables of the database can be divided into two types, namely an internal table and an external table of the database, wherein the internal table of the database is automatically organized and managed by a database management system, and the external table is organized outside the database and is an operating system file. Wherein the internal table includes: database normal table, partition table, temporary table, heap table (rowid), and inventory table (HUGE).

The following description of the embodiments of the present invention will be made with reference to the accompanying drawings. It should be noted that the description of the embodiments is provided to help understanding of the present invention, and is not intended to limit the present invention. In addition, the technical features involved in the embodiments of the present invention described below may be combined with each other as long as they do not conflict with each other.

The financial management system of the embodiment of the invention has a core module which mainly comprises:

1. user authority module

The user authority scheme of the financial management system is built according to data and role dimensions.

The data is mainly used for shielding the data, different company personnel cannot access the data of other companies, and the responsible personnel of different services cannot access the data of other services.

Roles are responsible for distinguishing different roles and functions, such as application and approval interfaces, business execution, and query-only roles, from each other.

Through the design of the access rights in the two aspects, each organization user can only access the data organized by the organization user, and each responsibility user can only operate the data in the authority of the organization user.

1. Organizing information

(1) The organization information mainly refers to the operation units and legal persons to which the project belongs, the organization information of the financial management system is all obtained from an ERP system, and the organization is classified as the organization of business entities in the ERP. The organization has two main roles in the financial management system:

(2) The organization as the project implementation body and the project contract body can shield the business data information according to the organization. Meanwhile, an organization hierarchical relationship is established among organizations, and the organizations in a parent layer can have access to all the organized data contained in the hierarchy. This organizational hierarchy is also obtained from ERP. Organizations that are not currently managed in ERP, such as some project companies in overseas utilities and real estate, also need to supplement complete organization and organizational information in ERP.

(3) As a person association organization, in a financial business management system, a relationship between a user and an organization is established, and the user can access the organization after the organization is allocated to the user.

The users at the bottom layer of the system are three-level company users, namely, the users can access all project information of the company and the subordinate companies thereof. For example, the project finance of a third-tier company may access and operate all projects below that company.

2. Employee information

The employee information is the basic information of all the personnel of the enterprise, and comprises information of names, mailboxes, positions, affiliated departments and the like. The employee information is obtained from a human resource system, and in the financial management system, the employee is bound with the account, the duty is bound with the account, and the duty is bound with the organization, so that the dual authority limit of the employee on the duty authority and the data authority is realized.

3. Responsibility rights

The employee duty authority is set according to different service types, and a specific function list needs to be determined when the function is designed.

2. Financial institution database

At present, financial institution and personnel information are maintained in manual Excel, a uniform coding system is lacked, the institution type and the business type engaged in by personnel cannot be judged from institution codes or personnel information, the data maintenance workload is large, the information maintenance is not standard, and the real-time updating of the information is difficult to realize. In addition, as the organization information and the contact person information are maintained in the Excel, when a user wants to inquire a certain organization and a certain contact person, the user can not check the organization and the contact person at any time and any place, and much inconvenience is brought to actual business operation.

The embodiment of the invention builds a financial institution personnel information base, a product base and a case base into a main data management system, and establishes a set of main data management specifications, so that the system not only provides a data storage and query function, but also is used as a main data source system when other businesses use financial institutions and products and perform institution evaluation, and realizes 360-degree management of the financial institutions.

Meanwhile, the master data management system can also carry out operation of a mobile APP terminal, and on one hand, business cards can be scanned from a mobile phone terminal, so that personnel in a financial management department can conveniently input and maintain the contact information of the financial institution at any time when carrying out business activities outside an office; on the other hand, when the business needs, the organization, the contact and the product information can be inquired at any time and any place, and the appropriate organization is selected for communication by referring to the comprehensive evaluation score of the organization.

The overall design framework of the financial institution database is as follows:

the database expands the content of the existing Excel management, and mainly comprises the following four aspects: financial institution master data and contacts, institution products, collaboration cases, evaluation systems. The four aspects are organically combined and closely associated with each other, related products can be seen on a cooperation mechanism, cooperation cases (if any) of the products can be traced back in the products, and an evaluation system is an evaluation result obtained by integrating basic information of the mechanism and historical evaluation of the cooperation cases.

The financial institution home page provides institution list information that may be sorted or retrieved by institution type, where the financial institution's organization and contact information is shared globally. The main data information of the financial institution, the main contact information of the institution, new products provided by the institution, historical success cases and the evaluation information of the institution can be seen by logging in a specific institution page, and a specific product or a specific case can be selected and linked to a product library or a case library page to inquire detail information and download accessories. In addition, other information linked to the organization's main page query organization may be queried by clicking on the organization name in the page. And the information management authority of the secondary unit is transferred to each secondary unit for maintenance, and the secondary unit can carry out authority distribution on specific personnel.

The financial management system of the embodiment of the invention is also provided with a financial institution main data maintenance standard, which is as follows:

financial institution master data maintenance authority: in order to ensure the normative and the accuracy of the maintenance data, the financial institution database personnel need to recheck the image information of the business card uploaded by the data reference scanning submitted by the financial institution database personnel, check the integrity and the normative of the business card, and can put the business card in storage after the system passes the audit and the system checks the error.

3. Bank account management module

Bank account management basically requires a head office to perform unified auditing of opening, revocation and change or other management and control of bank account balance, for example. The current management is realized by manually collecting the bank account information of each subordinate unit and compiling the information into a ledger for management, and the processes of opening and canceling are applied and approved on OA. For subordinate subsidiaries, the subordinate subsidiaries have the authority to independently open, cancel and change bank accounts, and the management and control are difficult to comprehensively grasp, so that the bank account information contained in the current ledger is not all account information.

The module has the advantages that the module is required to standardize the opening, canceling and changing processes of the bank account, perfect the management system of the main data of the bank account, realize the full life cycle management from opening to canceling of the bank account, automatically generate the bank management ledger and reduce the workload of manual maintenance ledger.

The module sets a bank account data maintenance standard, and the specific content is as follows:

sources of bank account data: the module needs to establish a standard, all bank accounts need to be managed in a unified and centralized way in the system, after a subordinate unit applies for a newly added bank account and is approved by a headquarter, the bank account in the table is opened and automatically led into an ERP to generate the bank account, and the bank account outside the table is not led in any more; and after the subordinate unit applies for the revocation of the bank account and is approved by the headquarter, automatically importing the failure information into the ERP.

Bank account maintenance personnel: all bank accounts of units are uniformly and centrally maintained in the system so as to avoid the condition of irregular account information, and after the system is maintained, the account information needs to be synchronized into the ERP through an interface. Because bank accounts are closely related to the collection and payment activities, the impact on outstanding payment transactions needs to be taken into account before maintenance, particularly revocation of bank accounts, can be performed. The headquarters of the subsidiaries respectively need to appoint special personnel to maintain the bank accounts, and the branch companies are maintained by the settlement centers.

And (3) reporting the balance of the bank account: the subordinate entity needs to fill in the balance on the bank statement up to the last day of the previous month in a "bank account balance" interface at a specified time per month (e.g., 5 per month). When the balance information is uploaded, a bank statement is required to be attached together, so that the headquarter can check the authenticity of the balance conveniently. The balance report will form a monthly balance ledger for inquiry and statistics.

The module also sets ERP bank account management specifications, which comprise the following contents:

the name of the bank: the use of official unified names is suggested, such as "chinese construction bank shares limited", rather than for short;

branch line name: please use the official name provided by the branch bank, for example, "shanghai liu branch bank of china construction bank stocks limited", if the bank name in ERP is not standardized, it needs to be combed;

the name of the bank account is as follows: OU code + OU name + bank account number 6 bits later (namely current bank account name specification);

the type of the bank account: general household (unrestricted)/agricultural and civil engineering pay-per-user/owner supervision account/credit and financing special-user/local production press-uncovering special-user/local production land refund special-user/local production house money special-user/project company restricted user/other restricted accounts, and the specific type list is set in ERP after being cleared;

bank account number: filling in a real bank account number;

the bank account is currency: the true bank account currency, including foreign currency, is maintained.

The storage system of the financial management system adopts SQL Server database technology, the logic processing adopts Springboot technology, the View layer is realized by Angular technology, the data transmission adopts a mode of transmitting lightweight JSON to realize the logic processing of each functional data in the financial management system, and the system architecture is shown in figure 1.

Further, the databases (including the financial institution database and other data storage databases) in the financial management system of the invention are designed as follows:

the database architecture uses a database design mode of one master and multiple slaves, and the design aims to enable data to have relevance and independence and improve data reading and writing efficiency. And when the servers are increased due to the increase of the traffic, the migration and the distribution deployment of data are facilitated.

The 1 OS library is designed as a master database, and is a source database (also referred to as master database) including all underlying data, and the library includes all data information of the system, such as an excellent plan data table, a plan template data table, personnel information, and organization information. The main database forms a plurality of levels according to the authority levels of the organizations, and different personnel organization levels obtain different source data information.

And the third-level user calls a system recommendation function, the system receives a user request and then calls data from an OSP sub-database selected by the user, the data are transmitted to a View logic layer for data analysis through a JSON data transmission mode, and finally the data are presented to the third-level user for selecting scheme data. And capturing the data of the corresponding table and the corresponding field from the corresponding OSP library through the storage relation of the basic logic data of the OS main library, analyzing the data into standard XML data and transmitting the standard XML data to the Sprie component, and merging and generating the Word version by the Sprie component according to the analysis style of the OS main library and the filling position of the data and the data.

And establishing an independent OSP sub-database for each item, establishing an item ID, and matching the item ID with the sub-database. The database comprises project characteristic data such as project data of project data, project table data tables, project headquartering authority and the like.

The system design principle of the invention is as follows: after the system WEB terminal collects data input and instructions, different database units are called to carry out data interaction after the data are screened, pre-analyzed and processed. And performing data interaction of the master database and the slave database and data interaction of the sub-databases according to different service function operations.

The system also has the function of plan compilation and approval, and the specific contents are as follows:

1. project template creation

According to six types (construction organization total design, unit engineering construction organization design, A type construction scheme, B type construction scheme, C type construction scheme and D type construction scheme, wherein the construction organization total design is divided into house construction organization total design, municipal engineering construction organization total design, highway engineering construction organization total design, railway engineering construction organization total design, EPC engineering construction organization total design, pipe gallery engineering construction organization total design, rail traffic engineering construction organization total design and the like) scheme standard templates, contents of sections, tables, scheme texts and the like in the scheme templates are subjected to data structuring to be used as templates and are input into an OS database through a background management tool, each table corresponds to one DM table in the database, and fields in the DM table correspond to cell contents in the scheme table one by one. The purpose of this step is to structure the schema table data for later use in word consolidation.

2. Plan source data pre-entry

Aiming at the existing excellent scheme, a scheme template stored in an OS library is called out through a system, the system automatically brings in information such as project names, filling personnel and the like according to a preset standard, and the residual content needs to be manually input according to the actual situation. After the entry is completed, the system converts the whole scheme content into a Json character string through the SpreadJS control, calls WCF service, and stores the Json character string into a respective project database (OSP).

3. Schema generation

The scheme generation data structure logic analysis is divided into two steps:

1) When the WEB side generates an operation scheme, the system converts the scheme template selected by the user in the UI interface into a parameter and transmits the parameter to a Business Logic Layer (BLL), and the system extracts the excellent scheme selected by the user from an OS library by calling WCF service according to the received template message selected by the user and inserts the excellent scheme into an OSP database of the project.

2) Screening out data nodes needing to be compiled and filled in the scheme table in the OSP sub-database, searching out a corresponding scheme table from the main database OS according to the screened data nodes, inserting the scheme table into a corresponding DM table in the OSP sub-database, returning corresponding results after the operation is finished, summarizing and processing the results, and then transmitting the results back to a WEB end page for displaying the results.

Example (c): generation scheme by taking standardized template scheme as template

And the WEB terminal acquires the current user information, obtains the organization structure of the user from the OS main database through screening analysis, and transmits the organization structure to a corresponding database table according to the association data table of the organization database and the WEB terminal transmission instruction operation. Data analysis is the execution of a modular schema generation for this operation for sub-database B.

Listing the list of corresponding form modules and chapter module directories which accord with the conditions in the main database according to the screening conditions (scheme types, engineering types and the like), executing copy operation, storing the copy operation in a corresponding table, and transmitting the copy operation to the sub-database B.

And the subdata B receives the transmitted data table, then executes the operation of writing in the data table, returns a corresponding instruction to the WEB terminal after the operation is finished, and simultaneously transmits a piece of record information to be stored in the table corresponding to the main database. And the WEB terminal processes the data and then displays a corresponding result to the user.

Example (c): scheme for generating template by using excellent scheme

And information such as user ID collected by the WEB side is screened and analyzed in the main database to obtain a corresponding organization structure, and the information is transmitted to a corresponding database table according to the association data table of the organization database and the WEB side transmission instruction operation. After data screening and analyzing, the operation takes the excellent scheme a as a template to generate a scheme for the sub-database B.

And finding the excellent scheme a in the sub-data A base through the excellent scheme a information in the main database. And obtaining a form module and a chapter module corresponding to the excellent scheme a in the sub-database A and corresponding data information, copying, and transmitting to the sub-database B.

And the subdata B receives the data table and the like transmitted by the subdatabase A, then executes the operation of writing in the data table, and returns a corresponding instruction to the WEB end after the operation is finished. And the WEB terminal processes the data and then displays a corresponding result to the user.

4. Plan compilation

Scheme compilation data logic: when a user opens a generated scheme compiling task 1, the system acquires an project library (OSP) corresponding to a mechanism where the user is located in a database from an organization table in a main database OS through current user information, acquires a scheme form required to be input into the project scheme from a sub-database (OSP) according to the task 1 information, transmits a Json character string converted in the system according to the form to a Business Logic Layer (BLL) through WCF service, and transmits the Json character string to a UI through front and back end interaction to display a specific scheme form, the system can automatically bring related information in according to a preset specification, other contents are required to be manually input, the one-to-one correspondence relationship between the related accessory information and the form is stored in a File database, and the uploaded accessory File is uploaded to a fixed File folder in a server in an MD5 encryption mode, so that later checking and downloading operations are facilitated.

And when the node is compiled in the compiling process, the background converts the table into a Json character string through a SpreadJS control displayed at the front section, transmits the Json character string to a background Business Logic Layer (BLL) through an Ajax technology, the system updates the Json character string to a database (OSP) corresponding to the project through a WCF service according to business logic, and the content of each cell is stored in a corresponding DM field for functions of ledger display, condition query and the like.

And in the closing operation, the system acquires the information from an item database (OSP) where the user is located according to the user information.

According to the template form of the project scheme, json character strings of the scheme form are transmitted to a business logic layer BLL by calling WCF service, the form is subjected to manuscript combination operation through Sprie components through background logic, a manuscript combination file is converted into Json character strings and transmitted to the front end after manuscript combination is completed, and the file after manuscript combination is displayed through SpreadJS controls.

5. Scheme review and approval

Approval process data logic: when a user initiates an approval request, the system automatically initiates approval according to approval process information preset in a process library (WF), determines specific information of a next approver according to a mechanism where the current user is located and a post to which the next approver belongs, and pushes the information to the approver.

After receiving the message, the approver opens the specific table content and the accessory information of the scheme by double-click, and after the specific table content and the accessory information are determined, the approver can perform approval operation, select approval results, input approval opinions and the like. And after the approval is finished, automatically transferring to the next approver according to the flow until the approval is finished.

6. Project browsing

Scheme browsing data logic: the system inquires the related information of the current user through the information of the current user and the WCF service, determines the level of the scheme browsing authority of the current user, displays different contents according to the authority, transmits the part which the user allows to see to a Business Logic Layer (BLL) through the WCF service, and transmits the part to a front end (UI) for displaying after background processing. When a user views a specific scheme c in the list, the corresponding c scheme information is inquired into a scheme in a sub-database (OSP) A according to a selected c scheme-main database (OS) corresponding table,

and transmitting the Json character string of the scheme to a Business Logic Layer (BLL) through WCF service, processing the Json character string through an Ajax technology, transmitting the Json character string to a front end, and displaying the Json character string to a user through a SpreadJS control.

The embodiments of the present invention have been described in detail with reference to the accompanying drawings, but the present invention is not limited to the described embodiments. It will be apparent to those skilled in the art that various changes, modifications, substitutions and alterations can be made in the embodiments without departing from the principles and spirit of the invention, and these embodiments are still within the scope of the invention.

Claims (7)

1. A financial management system, comprising:

the user authority module is built according to data and role dimensions, authority management is carried out on organization information, employee information and authority, and the fact that all organization users can only access data organized by themselves is achieved, and all responsibility users can only operate the data in the authority of themselves;

the financial institution database comprises financial institution main data, contact persons, product information, cooperation cases and an evaluation system, wherein the evaluation system is an evaluation result obtained by integrating the financial institution main data and the historical evaluation of the cooperation cases;

a financial institution home page for providing institution list information that can be classified or retrieved by institution type;

the bank account management module is used for standardizing the opening, canceling and changing processes of the bank account, perfecting a management system of main data of the bank account, realizing full life cycle management from opening to canceling of the bank account and automatically generating a bank management ledger.

2. The financial management system of claim 1 wherein the organization comprises a project implementation entity and a project contract entity organization, and the business data information shielding is performed according to the organization.

3. The financial management system of claim 1, wherein said organizations establish an organizational hierarchy between themselves, and organizations at a parent level have access to all organizational data contained under their hierarchy.

4. The financial management system of claim 1, wherein the organization includes an association organization of people, the relationship of users and organizations is established, and the users are allowed access to the organization after the organization is assigned to the users.

5. The financial management system of claim 1, wherein the employee information is employee basic information, and the employee is bound to the account, the duty is bound to the account, and the duty is bound to the organization at the same time, so that dual authority limits of the employee on duty authority and data authority are realized.

6. The financial management system of claim 1 wherein the responsibility authority is set according to different service types.

7. The financial management system of claim 1, wherein the financial institution database sets financial institution master data maintenance specifications, rechecks the submitted business card image information uploaded by the data reference scan, checks integrity and normalization, and stores the image information after passing the audit and system check.

Images