Construction Plan for Financial Treasury Cash Management SystemcatalogueChapter 1 Treasury Cash Ma

Construction Plan for Financial Treasury Cash Management System
catalogue
Chapter 1 Treasury Cash Management 3
1.1 Design Framework 3
1.2 Functional Design 4
1.2.1 Account Balance Management 4
1.2.2 Account Details Management 6
1.2.3 Account Cash Flow Report 8
1.2.4 Bank Reconciliation 8
1.2.5 Cash Flow Forecast Management 9
1.2.6 Cash Operation Management 16
1.2.7 Interface Design 25
1.3 Relationship with Other Modules 25
1.4 Difficulty Handling 26
Chapter 1 Treasury Cash Management
1.1 Design framework
By predicting and analyzing the income and expenditure data of the national treasury funds, a cash flow forecast table for the national treasury can be obtained, so as to know the idle situation of the national treasury cash in the future. When there is a lot of idle cash in the national treasury, investment and financial management can be carried out, mainly through fixed deposit operations. If the national treasury is short of cash, financing operations such as issuing bonds are needed to raise funds to meet expenditure needs.
The design framework is shown in the following figure:
Figure 1: Design framework for treasury cash management
The system obtains the expenditure data of treasury cash from the central treasury fund allocation system, obtains the income and expenditure details and account balance information of the account through the bank interface, and obtains the treasury bond information from the treasury bond system. According to these data information, it uses the prediction analysis model to forecast and analyze the treasury fund.
Figure 12 Application Architecture of Treasury Cash Management
1.2 Functional Design
1.2.1 Account Balance Management
1.2.1.1 Business Description
By opening an interface with the opening bank of the fiscal account, real-time account balance information can be collected, and an account balance change curve table can be formed in chronological order. At the same time, the collection of account income and expenditure transaction details data is achieved through the bank interface, forming a detailed cash flow statement for the inflow and outflow of financial funds in the account.
1.2.1.2 Business Process
The finance department sends account balance query transaction requests to the account opening bank through the bank interface, and the account opening bank returns the account balance query results to the finance department.
After receiving the account balance query results returned by the bank, the finance department forms an account balance table.
Figure 13 Business Process Diagram for Balance Management of National Treasury Cash Accounts
1.2.1.3 Interface Prototype
Main interface for querying:
Function button area:
Main data items: query, export to Excel, hide query conditions
Query criteria area:
Main data items:
Opening bank (auxiliary input);
Account type (auxiliary input);
Supervisory department (auxiliary input);
Account opening unit (auxiliary input);
Account inquiry (auxiliary entry).
Condition combination requirements:
(1) Users can query all accounts under one account opening bank;
(2) Users can query all accounts of a specified account type under an account opening bank;
(3) Users can query all accounts of a specified department or unit with a specified account type under an account opening bank;
(4) Users can query all accounts of all banks with specified account types;
(5) Users can query all accounts of all banks in a specified unit;
(6) Users can query all accounts of all banks in a specified department;
Query result list:
Main data items: department, unit, account type, opening bank, account name, account number, account balance.
1.2.2 Account Details Management
1.2.2.1 Business Description
By opening an interface with the opening bank of the fiscal account, query the transaction details of the account, including income and expenditure details, as well as the account balance after each income and expenditure transaction.
1.2.2.2 Business Process
The finance department opens an interface with the opening bank of the finance account to achieve real-time query of account transaction details.
The finance department sends an account transaction details query message to the opening bank, and the bank returns the account transaction details data. After receiving the transaction details data, the finance department forms an account transaction details table.
Figure 14 Business Process Diagram for Detailed Management of Treasury Cash Accounts
1.2.2.3 Interface Prototype
Main interface for querying:
Function button area:
Main data items: query, export to Excel, hide query conditions
Query criteria area:
Main data items:
Opening bank (auxiliary input);
Account type (auxiliary input);
Supervisory department (auxiliary input);
Account opening unit (auxiliary input);
Account inquiry (auxiliary entry).
Condition combination requirements:
(1) Users can query all accounts under one account opening bank;
(2) Users can query all accounts of a specified account type under an account opening bank;
(3) Users can query all accounts of a specified department or unit with a specified account type under an account opening bank;
(4) Users can query all accounts of all banks with specified account types;
(5) Users can query all accounts of all banks in a specified unit;
(6) Users can query all accounts of all banks in a specified department;
Query result list:
Main data items: department, unit, account type, opening bank, account name, account number, transaction date, transaction type, transaction amount, and balance after income and expenditure.
(This table supports flipping and fixed rows and columns)
1.2.3 Account Cash Flow Report
By opening the interface with the opening bank of the fiscal account, the detailed income and expenditure data and account balance data of the bank account can be obtained. This can form a table of account income and expenditure cash flow and account balance for a period of time, and can also generate daily income and expenditure cash flow and account balance information for some accounts.
1.2.4 Bank reconciliation
1.2.4.1 Business Description
By opening a bank interface, obtain account income and expenditure data and account balance data from the bank as bank reconciliation data, obtain account fund disbursement data from the central treasury fund disbursement system, and obtain account accounting data from the general ledger system as financial reconciliation data, perform bank account reconciliation, and form a bank account reconciliation variance table. Through bank account reconciliation, improve the correspondence and verification of bank income and expenditure information, general ledger income and expenditure information, and account balance change information, and form account reconciliation statements that correspond to account fund information, cash flow changes, and accounting processing information.
1.2.4.2 Business Process
The system opens a bank interface with the account opening bank to obtain account transaction details and balance data, and obtains transaction and accounting data from the financial business system and general ledger system for bank account reconciliation operations.
Figure 15 Business Process Diagram of Treasury Cash Bank Reconciliation Management
1.2.4.3 Interface Prototype
In the bank reconciliation interface, it is possible to display the financial outstanding data listed by the bank and the financial outstanding data listed by the bank, as well as the detailed data for forming a unilateral account. At the same time, two methods of automatic and manual reconciliation can be provided.
Figure 16 Treasury Cash Bank Reconciliation Interface
1.2.5 Cash flow forecast management
1.2.5.1 Prediction data collection
1. Business Description
The accurate prediction data collection of national treasury cash flow includes the collection of account income and expenditure data and balance data collected from the opening bank through the bank interface, as well as the collection of various income and expenditure plans, large payment reports, accounts receivable and payable, debt issuance and redemption plans, and fixed deposit operation plans obtained from the business system. These data should be calculated based on the actual occurrence of cash inflows and outflows from the national treasury. Including: sorting out the inflow and outflow of funds during the period, and recording them into the daily income and expenditure of funds based on the date of occurrence; The pre allocated funds are included in the current day's treasury expenditures based on the allocation date.
The accurate prediction data of national treasury cash is mainly obtained from the general ledger system and the business system of the People's Bank of China.
Treasury cash trend prediction is based on years of historical data for trend analysis. Therefore, the system needs to collect years of historical data for trend prediction and analysis. These historical data include: (1) treasury bond issuance and redemption data. Including "domestic debt income" and "treasury bond repayment expenditure", data source is treasury bond system; (2) Central level expenditure. The data sources include: central and local monthly payment plans for sub sectors and departmental large payment reporting data; (3) Central and local transfer payments. The data source is the budget execution information system; (4) Econometric model data, etc.
2. Business processes
When collecting predictive data, a method is to open an interface (or database script) and collect predictive data through the interface. If the interface is not opened, the system provides input or batch import to collect business data.
Figure 17 Business Process Diagram of Data Collection for Treasury Cash Forecast
3. Interface prototype
In the prediction data collection interface, manual input and batch collection functions are provided. Batch collection includes various methods such as interfaces and importing data files. The following figure shows an interface for batch collection.
Figure 18: Interface for Collecting Cash Forecast Data from National Treasury
1.2.5.2 Treasury Cash Flow Forecast Report
1. Business Description
Prepare daily treasury cash flow forecast reports on a monthly basis, quarterly and monthly treasury cash flow forecast reports, and annual and monthly treasury cash flow forecast reports. Predictive report data is a trend prediction analysis based on collected historical data. Add a correction column for predicted values in the forecast report, and the system supports data correction for predicted values in the forecast report. Therefore, the predicted data should include trend predicted values, correction values, and predicted display values. Among them, the correction value column only displays the corrected data (with positive and negative signs), while the predicted display value is the trend predicted data after data correction.
The initial value of the predicted data can be derived through parameter selection. For projects without parameters, such as "domestic debt income" and "domestic debt repayment", their values remain unchanged.
2. Business processes
Figure 19 Business Process Diagram of Treasury Cash Flow Forecast
Users can create several prediction schemes in the system, and each prediction scheme can set different model parameters. The model parameters of the prediction scheme can be gradually adjusted based on the deviation between the prediction results and the execution results, improving the accuracy of the prediction results.
3. Interface prototype
Figure 1-10 Business Process Diagram of Treasury Cash Flow Forecast
The above figure shows the trend prediction of treasury cash expenditures in the treasury cash flow forecast. There are two types of cycles that can be used, one is the current year trend and the other is the historical trend. The chart shows the trend for this year.
Figure 111: Interface diagram for predicting the optimal balance of treasury cash flow
Use professional predictive analysis models to predict and analyze the optimal balance of treasury cash flow.
1.2.5.3 Error Management of Treasury Cash Flow Forecast
1. Business Description
Prepare daily treasury cash flow forecast reports on a monthly basis, quarterly and monthly basis, and annually and monthly basis. Compare them with actual execution results, calculate deviation errors, and use them as a basis for adjusting forecast analysis parameters, in order to make subsequent forecast analysis more accurate.
2. Business processes
Figure 12 Business Process Diagram for Error Management in Treasury Cash Flow Forecast
Users can create several prediction schemes in the system, and each prediction scheme can set different model parameters. The model parameters of the prediction scheme can be gradually adjusted based on the deviation between the prediction results and the execution results, improving the accuracy of the prediction results.
1.2.5.4 Quarterly report on inventory inquiry
Automatically prepare inventory query reports based on the first, middle, and last ten days of each month.
1.2.5.5 Release and Management of Funds
1. Business Description
Publish payment data information based on payment prediction and execution status, and achieve payment data sharing.
The published content includes:
(1) Publish the balance status, warning level, and response measures of central government treasury funds. The warning level is divided into three levels: Level III warning, Level II warning, and Level I warning.
Measures: Level III early warning: remind the treasury fund to enter the early warning status, inform the budget implementation, audit, treasury bond management, payment, cash management and other relevant departments to prepare for the relevant work in advance; Level II early warning: increase the frequency of fund adjustment in the special financial account, increase the amount of treasury bond issued in the current period, and withdraw the undue treasury cash management deposits in advance; Level I warning: reduce the scale of current treasury cash management operations, adjust the central and local subsidy fund scheduling plan, and appropriately control the progress of central level expenditure payments.
(2) Release the status of fixed deposits in central government treasury cash commercial banks. Publish the balance, maturity, and distribution of fixed deposits in commercial banks.
(3) Publish the status of local treasury funds.
(4) Release the forecast of central government treasury cash flow.
2. Business processes
Figure 13: Business Process Diagram for Publishing and Managing National Treasury Cash Deposits
When publishing data, it can go through multiple job reviews to ultimately push and publish the published data.
1.2.5.6 Large amount payment reporting management
1. Business Description
When the budget unit needs to make large payments (the specific amount is set by the system), it needs to be reported step by step, so that the payment bank can arrange payment funds in advance to meet the large payment needs of the budget unit.
At the same time, in order to evaluate and provide the accuracy of the large payment reporting data of the budget unit, it is necessary to compare the large payment data reported by the budget unit with the actual large payment data executed, calculate the deviation degree, and use it as the evaluation basis for the budget unit's large payment reporting.
2. Business processes
Figure 114 Business Process Diagram for Reporting and Management of Large Cash Payments from National Treasury
The person in charge of the budget unit enters the large payment plan, which is reviewed by the leader in charge of the budget unit and submitted to the finance department for review. The finance department completes the final review of the large payment reporting business process.
1.2.6 Cash Operation Management
1.2.6.1 Operation Plan Management
1. Business Description
Based on the predicted cash flow of the national treasury and the cash inflow and outflow situation of the national treasury, while meeting the payment needs of budget units and transfer payments, a national treasury cash operation plan is formulated as a reference for executing national treasury cash operations.
The treasury cash operation plan includes information such as operation date, operation type, operation amount, reference interest rate, and expiration date.
At the same time, the operation plan reporting management module supports the function of local finance gradually summarizing national treasury cash operation plans.
2. Business processes
Figure 1-15 Business Process Diagram of Treasury Cash Management Operation Plan Management
The business process of managing the treasury cash operation plan is carried out by the entry post, who inputs the treasury cash operation plan based on the predicted results of the treasury cash flow, etc. After review, it serves as the basis for treasury cash operations.
3. Interface prototype
Main interface for querying:
Function button area:
Main data items: query, export to Excel, hide query conditions
Query criteria area:
Main data items:
Operation plan name, operation plan formulation date, operation date, operation amount, expected interest rate, operation direction, due date, due interest, and remarks.
Figure 116: Interface diagram of treasury cash operation plan management
1.2.6.2 Fixed deposit account management
1. Business Description
The management of fixed deposit accounts mainly includes setting up accounts as fixed deposits, checking the status of fixed deposits in accounts, including details of fixed deposits, etc.
2. Business processes
Figure 117 Business Process of Treasury Cash Fixed Deposit Management
The account management personnel manage the fixed deposit account, which takes effect after being reviewed and approved by the supervisor.
1.2.6.3 Bid winning management for fixed-term deposits
1. Business Description
The system has opened an interface with the Central Treasury Cash Management Fixed Deposit Tendering and Bidding Business System, which enables the acquisition of fixed deposit winning information from the Central Treasury Cash Management Fixed Deposit Tendering and Bidding Business System, including winning bank, winning interest rate, winning amount, winning date and period, and other information. After the bidding for fixed deposits is completed, the system automatically obtains the winning bid information for fixed deposits through the interface and displays it in real-time in this module. At the same time, it uses message reminders to remind users of their fixed deposits