Construction Plan for Bank Account Management Systemcatalogue1. Bank account management 31.1 Busi

Construction Plan for Bank Account Management System
catalogue
1. Bank account management 3
1.1 Business Description 3
1.2 Business Process 3
1.3 Functional Structure 4
1.4 Preliminary Design 4
1.4.1 Basic Data Maintenance 4
1.4.2 Role Permission Management 5
1.4.3 Bank Communication Interface 5
1.4.4 Daily Maintenance of Bank Communication Interface 7
1.4.5 Account Supervision Analysis Report 7
1.4.6 Account Opening, Change, and Cancellation Management 10
1. Bank account management
1.1 Business Description
Account management refers to the electronic management of accounts, including the establishment of a budget unit account management information system based on existing financial regulations and business processes. This system enables electronic management of budget unit accounts, including opening, changing, revoking, filing approval, annual inspection, and querying statistical reports. It eliminates previous manual management methods and provides comprehensive and real-time monitoring of unit bank account information. Implement electronic information verification with the People's Bank of China and commercial banks, and enhance the supervision and inspection of budget unit bank accounts by the government.
1.2 Business Process
1.3 Functional structure
Function Name Function Description
Submit the application form for account opening, change, or cancellation. The budget unit shall submit the application form for account opening, change, or cancellation to the finance department in accordance with regulations.
The opening, changing, and closing of accounts shall be approved by various financial departments.
After maintaining the account opening, changing, and closing information in the system for financial approval, the relevant person in charge of the national treasury will maintain the account opening, changing, and closing information in the system.
Send account opening and closing information to the bank system, which automatically sends the account opening and closing information to the opening bank.
After the bank receives and verifies the confirmation information of opening or closing an account, it will automatically confirm. Only accounts that have indeed been opened or closed in the bank's core system will the bank send the confirmation information to the finance department. If the account has not yet been opened or closed in the bank system, the bank needs to confirm the account on a regular basis every day.
After registration confirmation, the account closure information system automatically registers the confirmed account opening and closure information upon receiving confirmation information from the bank.
1.4 Preliminary design
1.4.1 Basic Data Maintenance
The system provides basic data maintenance functions for the maintenance of relevant basic data. In the initial stage of system construction, all basic data sources and their maintenance functions were independently developed by the account supervision system. After implementing the interface with the application support platform, some basic data should be obtained from the platform, and related functions need to be modified and an interface with the platform needs to be established. Part of the basic data is unified throughout the province, while some data is maintained by the finance departments at all levels.
Main data item notes for basic data related functions
Budget unit: Name, unit code, unit level, organizational code, unit nature, legal representative, financial manager, address, phone number, etc. of the budget unit management unit. Partition maintenance
Bank name, bank name management, bank name, bank code, contact person, contact phone number
Account Type Account Type Management Account Type Name
Account Nature Account Nature Management Account Nature Name
Currency Management Currency Name, Currency Code
Project Classification Project Classification Management Project Classification Name
Fund Source Fund Source Management Fund Source Name
Business Department Business Department Management Business Department Name Regional Maintenance
Regional Regional Management Region Name, Region Code
1.4.2 Role permission management
The system provides a role permission management module for system maintenance personnel to define users, roles, permissions, etc. It mainly includes the following functional modules:
User management: including adding, deleting, and modifying users (codes, names, passwords, affiliations, role assignments, permission assignments, etc.). After connecting with the application support platform, the user management function needs to be modified to establish a synchronization interface with platform users.
Role management: including adding, deleting, modifying, and authorizing role menus. The system should preset some roles, including system administrator role, account supervision query role, and account management role.
Permission Management: The system provides a permission management module that can assign permissions to each user. The permission mechanism will be applied to every functional module of the system.
System permissions can be configured through two levels: role menu permissions and data permissions.
Through role menu permissions, different menu functions can be assigned to different users; If user A can view a certain report, user B cannot view it.
Through data permissions, different data query restrictions can be set for different users; Like a report, user A can view all accounts, while user B can only view some accounts. Data permissions can be set for "budget units", which means that a user can have limited or no access to all accounts of a certain budget unit. The setting of system preset permissions is mainly based on the following principles:
System maintenance personnel are able to use system settings related functions.
The relevant management personnel of the treasury can use the account management function.
Department leaders, treasury departments, budget departments, and related business departments can use the account query function.
Department leaders, some leaders of the Treasury Department, and the Budget Department have the authority to query the accounts of all financial units at the same level and lower levels.
Department leaders, some leaders of the Treasury Department and Budget Department, as well as relevant personnel of the Business Department, have the authority to query the accounts of local and subordinate financial units.
1.4.3 Bank communication interface
To achieve data communication between finance and banks, the system establishes a data exchange center and customizes interface messages based on the exchange center. The function of the exchange center is shown in the following figure:
Schematic diagram of exchange center deployment
Each bank can use financial and tax dedicated networks or dial-up methods for data transmission according to the actual situation.
The data packets provided by the system are shown in the table below:
Message number, message name, message content
2601 Single transaction flow request: The bank sends a single transaction flow to the finance department
1601 Single transaction receipt: The financial department sends a single transaction receipt to the bank
2603 Historical transaction flow request: Multiple transaction flow requests sent by the bank to the finance department
1603 Historical transaction receipt Multiple transaction receipts sent by the finance department to the bank
2604 Unit Account Request Bank sends unit account request to finance
1604 Unit Account Receipt: The request receipt for the unit account sent by the finance department to the bank
2605 Unit Fixed Deposit Certificate Request The bank sends a unit fixed deposit certificate request to the finance department
1605 Unit Fixed Deposit Receipt The receipt of a unit fixed deposit issued by the finance department to a bank
2606 Account Change Request The bank sends an account opening or closing request to the finance department
1606 Account Change Receipt The request for opening or closing an account sent by the finance department to a bank
2607 Account Change Confirmation Request The bank sends a confirmation request for opening or closing an account to the finance department
1607 Account Change Confirmation Receipt The confirmation receipt for opening or closing an account sent by the finance department to the bank
1.4.4 Daily maintenance of bank communication interfaces
For abnormal situations that occur in communication between finance and banks, the system provides relevant maintenance functions for system management personnel to solve abnormal problems.
Transaction reminder for sending bank statements: This function displays transaction reminders on the main interface of the system. If the bank did not send any transaction statements to the finance department the previous day, a reminder will be given. Reminder content such as "2 banks have not sent transaction records".
Bank transaction record sending absence table: This function, in conjunction with transaction reminders, lists the absence status of bank transaction records in a table format. The table style is as follows:
Bank transaction flow sending absence status table
Bank: All dates: 2010-07-26
Date Bank Name Contact Phone Number
Exchange Center Message Log Query: This function records all abnormal messages in the exchange center and provides a query function to view the list of abnormal messages by bank, date, and category, and thus query the content of a certain abnormal message.
1.4.5 Account Supervision Analysis Report
The system provides several report functions for financial personnel at all levels to query and analyze the status of account funds. All reports provide export to Excel and printing functions. All reports integrate system permission mechanisms and work in conjunction with the system role permission management module to achieve data filtering by permission.
Distribution Table of Financial Funds Departments:
This report summarizes fund income, expenditure, and current balance by department (primary budget unit) and currency.
Distribution Table of Financial Funds Departments
Account status: Activation query date: June 27, 2010 Department name: All
Currency Name: All
Unit: Yuan
Number, Department Code, Department Name, Currency Name, Revenue and Expenditure, End of Period Balance
Distribution Table of Budget Units for Financial Funds:
This report calculates fund income, expenditure, and current balance by budget unit and currency.
Distribution Table of Budget Units for Financial Funds
Balance greater than balance less than: Query date: June 27, 2010
Budget Unit: All Currency Name: All Account Status: Activated
Unit: Yuan
Number Budget Unit Code Budget Unit Name Currency Name Revenue and Expenditure End of Period Balance
Distribution Table of Financial Funds by Banks:
This report calculates the number of accounts, fund income, fund expenditure, and current balance by bank name and currency.
Distribution Table of Financial Funds and Banks
Unit: Yuan
Number, Bank, Currency Name, Number of Accounts, Beginning Balance, Income and Expenditure, End of Period Balance
Budget unit bank account initialization balance composition table:
This report queries the initial fund composition of a certain account.
Budget unit account initialization balance composition table
Budget unit: All bank names: All account numbers: All
Funding source: All balance date: Account purpose: All
Budget unit code Budget unit name Bank name Account balance date Account purpose Fund source Currency name Amount
Budget unit account transaction details table:
This report queries the transaction flow details of a certain account for a certain period of time.
Budget Unit Account Transaction Flow Details Table
Trading time greater than: 2010-06-27 Trading time less than: 2010-06-27
Budget unit: All bank names: All account numbers: All
Unit: Yuan
Number Budget Unit Code Budget Unit Name Organization Code Account Type Unit Nature Bank Name Account Opening Bank Account Name Account Transaction Date Currency Name Revenue and Expenditure Balance
Budget unit account balance detailed table:
This report queries all accounts of a certain unit, including account related attributes and the current balance of the account.
Budget Unit Bank Account Balance Details Table
Budget unit: All
Account: All
Unit: Yuan
Number Budget Unit Code Budget Unit Name Zone Code Bank Name Opening Bank Account Nature Account Purpose Account Type Account Accounting Content Unit Nature Account Name Account Status Currency Balance
Budget unit account statistics table:
This report summarizes the number of accounts by unit and currency.
Number of physical fund accounts of budget units
Account Status: Activated Budget Unit: All
Number Budget Unit Code Budget Unit Name Account Status Currency Name Account Quantity
Statistical table of changes in budget unit accounts:
This report counts the number of changes over a period of time based on the type of change.