CN104021454B - Method and system for monitoring fund account data of group enterprises - Google Patents
Method and system for monitoring fund account data of group enterprises Download PDFInfo
- Publication number
- CN104021454B CN104021454B CN201410283247.9A CN201410283247A CN104021454B CN 104021454 B CN104021454 B CN 104021454B CN 201410283247 A CN201410283247 A CN 201410283247A CN 104021454 B CN104021454 B CN 104021454B
- Authority
- CN
- China
- Prior art keywords
- data
- account
- risk
- monitoring
- abnormal
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
- 238000012544 monitoring process Methods 0.000 title claims abstract description 172
- 238000000034 method Methods 0.000 title claims abstract description 33
- 230000005611 electricity Effects 0.000 claims abstract description 36
- 238000012545 processing Methods 0.000 claims abstract description 33
- 238000001914 filtration Methods 0.000 claims abstract description 6
- 239000000463 material Substances 0.000 claims abstract description 6
- 230000002159 abnormal effect Effects 0.000 claims description 67
- 230000005856 abnormality Effects 0.000 claims description 5
- 239000003999 initiator Substances 0.000 claims description 5
- 238000004364 calculation method Methods 0.000 claims description 4
- 238000012216 screening Methods 0.000 claims description 4
- 238000010276 construction Methods 0.000 claims description 3
- 238000013480 data collection Methods 0.000 claims description 3
- 238000012827 research and development Methods 0.000 claims description 3
- 230000009466 transformation Effects 0.000 claims description 3
- 230000009286 beneficial effect Effects 0.000 abstract description 2
- 238000005516 engineering process Methods 0.000 description 3
- 238000009440 infrastructure construction Methods 0.000 description 3
- 230000003993 interaction Effects 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 229910003460 diamond Inorganic materials 0.000 description 1
- 239000010432 diamond Substances 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000246 remedial effect Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
Description
技术领域technical field
本发明涉及财务管控领域,尤其涉及一种用于集团企业资金账户数据监控的方法及系统。The invention relates to the field of financial management and control, in particular to a method and system for monitoring fund account data of a group enterprise.
背景技术Background technique
目前,由于县公司上划时间并不长,五大体系支撑机构也刚刚设立,部分单位风险意识比较淡薄,基础工作还不扎实,银行账户管理与使用中,不少单位账户使用中存在账户管理风险,个别单位甚至存在账外账的情况,使公司资金出现了诸多风险隐患。依靠现有财务管理系统以报表、账务为主要内容的信息系统下,上级单位对下级单位的账户监控,只能开展事后的监督、检查。这种方式的时效性很差,出现问题时很难及时采取补救措施,在外部检查中也存在较大的风险隐患。At present, due to the fact that the county company has not been registered for a long time, and the five major system support institutions have just been established, some units have relatively weak risk awareness, and the basic work is not solid. In the management and use of bank accounts, many units have account management risks in the use of accounts. , Some units even have off-book accounts, which has caused many hidden risks in the company's funds. Relying on the existing financial management system under the information system with reports and accounts as the main content, the account monitoring of the subordinate units by the superior unit can only carry out post-event supervision and inspection. The timeliness of this method is very poor, and it is difficult to take remedial measures in time when problems arise, and there are also great risks and hidden dangers in external inspections.
发明内容Contents of the invention
本发明的目的就是为了解决上述问题,提出了一种用于集团企业资金账户数据监控的方法及系统,该方法及系统依托现代信息网络手段,对各级、各类资金信息开展集成,并立足实战,研究建立好用、管用的账户管理风险监控规则,对账户使用行为进行在线筛查,发现问题时可以马上预警,并采取及时、有效的干预措施,主动排除并化解风险,推动风险有效落地。The purpose of the present invention is to solve the above problems, and propose a method and system for data monitoring of fund accounts of group enterprises. The method and system rely on modern information network means to integrate all levels and types of fund information, and based Actual combat, research and establish easy-to-use and effective account management risk monitoring rules, conduct online screening of account usage behavior, immediately warn when problems are found, and take timely and effective intervention measures to proactively eliminate and resolve risks, and promote the effective implementation of risks .
为了实现上述目的,本发明采用如下技术方案:In order to achieve the above object, the present invention adopts the following technical solutions:
一种用于集团企业资金账户数据监控的方法,包括以下步骤:A method for monitoring fund account data of a group enterprise, comprising the following steps:
(1)数据采集:(1) Data collection:
通过资金监控与中电财数据接口调取中电财数据并存入中电财数据服务器;Retrieve CEC Finance data through fund monitoring and CEC Finance data interface and store it in CEC Finance data server;
通过资金监控与财务管控数据接口调取财务管控数据并存入财务管控数据服务器;Retrieve financial control data through the fund monitoring and financial control data interface and store it in the financial control data server;
通过资金监控与SAP项目数据接口调取SAP项目数据并存入SAP项目数据服务器;Retrieve SAP project data through the fund monitoring and SAP project data interface and store it in the SAP project data server;
(2)数据过滤:判断所采集的数据是否在集团企业监控范围内,剔除不属于监控范围内的数据;(2) Data filtering: judge whether the collected data is within the monitoring scope of the group enterprise, and eliminate the data that does not belong to the monitoring scope;
(3)数据调用:按一定的取数规则和取数频率分别对采集到的数据进行调用,通过对所调用数据进行风险判断,实现对集团企业电费账户、农网账户、闲置账户、资金余额安全备付情况、资金归集情况、账外账及未达账数据的实时监控。(3) Data call: Call the collected data according to certain access rules and access frequency, and realize the group enterprise electricity account, rural network account, idle account, and fund balance by making risk judgments on the called data. Real-time monitoring of safety reserve status, fund collection status, off-book account and unpaid data.
所述步骤(1)中In the step (1)
中电财数据包括:受中电财监控的所有银行的历史与当日交易、余额数据;CLP Finance data includes: historical and current day transactions and balance data of all banks monitored by CEC Finance;
财务管控数据包括:核算账务、现金预算、报表、业务单据、融资台账、电子支付数据;Financial control data include: accounting, cash budget, reports, business documents, financing ledger, electronic payment data;
SAP系统数据为包括基本建设、技术改造、大修理、研究开发、信息化在内的项目相关数据。SAP system data is project-related data including capital construction, technological transformation, overhaul, research and development, and informatization.
所述步骤(3)中对集团企业电费账户的监控方法具体为:The method for monitoring the electricity account of the group enterprise in the step (3) is specifically as follows:
调用中电财数据服务器数据,筛查各监控单位的电费上缴单位与其上级单位不一致的异常支付记录,根据异常支出金额的大小判定电费账户异常支出数据的风险等级,同时生成电费账户支出异常监控数据,并根据客户端具体的查询条件进行相应的展示;Invoke the data of the CEC Finance data server, screen the abnormal payment records of the electricity bill payment units of each monitoring unit that are inconsistent with their superior units, determine the risk level of the abnormal expenditure data of the electricity account according to the size of the abnormal expenditure amount, and generate abnormal monitoring data of the electricity account expenditure at the same time , and perform corresponding display according to the specific query conditions of the client;
对所述电费账户支出异常监控数据进行风险判断:Carry out risk judgment on the abnormal monitoring data of the electricity account expenditure:
如果是风险数据,则自动生成电费账户支出异常监控风险处理操作单,并根据风险处理操作单的内容自动生成督办单,所述督办单的反馈信息经审核通过后,取消风险状态;如果不是风险数据,则直接取消风险状态。If it is risk data, it will automatically generate an electricity bill account expenditure abnormal monitoring risk processing operation sheet, and automatically generate a supervision sheet according to the content of the risk processing operation sheet. After the feedback information of the supervision sheet is approved, the risk status will be canceled; if it is not a risk data, the risk status will be canceled directly.
所述步骤(3)中对集团企业农网账户的监控方法具体为:The method of monitoring the rural network account of the group enterprise in the step (3) is as follows:
分别调用财务管控数据服务器和SAP项目数据服务器数据,筛查各监控单位农网账户的异常支付数据,根据异常支付金额的大小判定农网账户异常支出数据的风险等级,同时生成农网账户支出异常监控数据,并根据客户端具体的查询条件进行相应的展示;Call the financial control data server and SAP project data server data respectively, screen the abnormal payment data of the rural network accounts of each monitoring unit, determine the risk level of the abnormal payment data of the rural network accounts according to the size of the abnormal payment amount, and generate abnormal rural network account expenditures at the same time Monitor the data and display it according to the specific query conditions of the client;
对所述农网账户支出异常监控数据进行风险判断:Carry out risk judgment on the abnormal monitoring data of rural network account expenditure:
如果是风险数据,则自动生成农网账户支出异常监控风险处理操作单,并根据风险处理操作单的内容自动生成督办单,所述督办单的反馈信息经审核通过后,取消风险状态;如果不是风险数据,则直接取消风险状态。If it is risk data, automatically generate a rural network account expenditure abnormal monitoring risk processing operation sheet, and automatically generate a supervision sheet according to the content of the risk processing operation sheet, and cancel the risk status after the feedback information of the supervision sheet is approved; if not If there is no risk data, the risk status will be canceled directly.
所述步骤(3)中对集团企业账外账数据的监控方法具体为:The method for monitoring the off-book data of the group enterprise in the step (3) is specifically as follows:
调用中电财数据服务器数据,筛查各监控单位交易时对方单位名称为本单位而对方账号为非本单位账户的交易记录,根据交易金额的大小判定账外账异常数据的风险等级,同时生成账外账异常监控数据,并根据客户端具体的查询条件进行相应的展示;Invoke the data of the China Electronics Finance data server, screen the transaction records of the counterparty’s unit name and the other party’s account is not the unit’s account during the transaction of each monitoring unit, determine the risk level of the abnormal data of the off-book account according to the size of the transaction amount, and generate Abnormal monitoring data of off-ledger accounts, and corresponding display according to the specific query conditions of the client;
对所述账外账异常监控数据进行风险判断:Carry out risk judgment on the abnormal monitoring data of off-book accounts:
如果是风险数据,则自动生成账外账异常监控风险处理操作单,并根据风险处理操作单的内容自动生成督办单,所述督办单的反馈信息经审核通过后,取消风险状态;如果不是风险数据,则直接取消风险状态。If it is risk data, it will automatically generate an off-book account abnormality monitoring risk processing operation sheet, and automatically generate a supervision sheet according to the content of the risk processing operation sheet. After the feedback information of the supervision sheet is approved, the risk status will be canceled; if it is not a risk data, the risk status will be canceled directly.
所述步骤(3)中对集团企业闲置账户的监控方法具体为:The method for monitoring idle accounts of the group enterprise in the step (3) is specifically as follows:
调用财务管控数据服务器数据,筛查各监控单位在设定时间内收支记录小于一定数量的银行账户,生成闲置账户监控数据并根据客户端查询条件进行相应的展示。Call the data of the financial control data server, screen the bank accounts whose income and expenditure records of each monitoring unit are less than a certain number within the set time, generate idle account monitoring data and display it according to the query conditions of the client.
所述步骤(3)中对集团企业资金余额安全备付情况的监控方法具体为:In the step (3), the monitoring method for the safety reserve of the fund balance of the group enterprise is specifically as follows:
分别调用中电财数据服务器和财务管控数据服务器数据,筛查各监控单位月末银行存款超过备付额度的账户,根据监控单位月末银行存款科目期末余额超出安全备付额度的数目以及账号类型,判定账户是否存在风险,同时生成备付额度监控数据并根据客户端查询条件进行相应的展示。Respectively call the data of the China Electronics Finance data server and the financial control data server to screen the accounts with bank deposits exceeding the reserve limit at the end of each monitoring unit, and determine the number and account type based on the number of bank deposit subjects at the end of the monitoring unit that exceed the safety reserve limit and the type of account Whether there is a risk in the account, and at the same time generate the monitoring data of the reserve amount and display it according to the query conditions of the client.
所述步骤(3)中对集团企业未达账数据的监控方法具体为:The monitoring method for the unreconciled data of the group enterprise in the step (3) is specifically as follows:
调用财务管控数据服务器数据,筛查各监控单位月末筛查各监控单位月末企业已入账而银行未入账或者银行已入账而企业未入账的数据,生成未达账数据并根据客户端查询条件进行相应的展示。Call the data of the financial control data server, screen each monitoring unit at the end of the month and screen the data of each monitoring unit that the enterprise has entered the account but the bank has not entered the account or the bank has entered the account but the enterprise has not entered the account, generate unaccounted data and respond according to the client query conditions display.
所述步骤(3)中对集团企业资金归集情况的监控方法具体为:The methods for monitoring the fund collection of the group enterprise in the step (3) are as follows:
分别调用中电财数据服务器和财务管控数据服务器数据,设定各监控单位的考核时点,按照不同的考核时点提取各监控单位所有账户的资金余额信息,判断所调用数据是否为合作金融机构账户数据,如果是,则以中电财数据作为银行账户余额,如果否,则以财务管控中的账务余额作为银行账户余额;分别计算各监控单位在设定考核时点的资金实时归集比率及月内平均归集比率数据并显示。Respectively call the data of the China Electronics Finance data server and the financial control data server, set the assessment time points of each monitoring unit, extract the fund balance information of all accounts of each monitoring unit according to different assessment time points, and judge whether the called data is a cooperative financial institution For the account data, if yes, use the CLP financial data as the bank account balance; if not, use the account balance in the financial control as the bank account balance; respectively calculate the real-time collection of funds of each monitoring unit at the set assessment time point Ratio and monthly average collect and display the ratio data.
所述风险处理操作单信息包括:The risk treatment operation sheet information includes:
业务信息:付款单位信息、项目相关信息、收款单位信息以及支付内容相关信息;Business information: payment unit information, project-related information, payee unit information, and payment content-related information;
风险规则:判断风险产生的预定规则;Risk rules: predetermined rules for judging the occurrence of risks;
风险处理信息:风险等级、风险判断、判断人、生成督办单、风险处理操作单发出时间、信息反馈人、反馈时间、佐证材料、处理状态;Risk treatment information: risk level, risk judgment, judgment person, generation of supervision form, time of issuing risk treatment operation order, information feedback person, feedback time, supporting materials, processing status;
督办单内容主要包括:发现风险的单位、时间、风险原因、具体账户信息、账户交易信息、建议整改期限、联系人、发起单位信息。The content of the supervision form mainly includes: the unit where the risk was discovered, the time, the cause of the risk, specific account information, account transaction information, suggested rectification period, contact person, and information on the initiator.
一种用于集团企业资金账户数据监控的系统,包括:A system for data monitoring of capital accounts of group enterprises, including:
(1)数据采集装置:(1) Data acquisition device:
用于通过资金监控与中电财数据接口调取中电财数据并存入中电财数据服务器的装置;A device for retrieving data from CEC Finance through the fund monitoring and CEC Finance data interface and storing it in the CEC Finance data server;
用于通过资金监控与财务管控数据接口调取财务管控数据并存入财务管控数据服务器的装置;A device for retrieving financial control data through the fund monitoring and financial control data interface and storing it in the financial control data server;
用于通过资金监控与SAP项目数据接口调取SAP项目数据并存入SAP项目数据服务器的装置;A device for retrieving SAP project data through the fund monitoring and SAP project data interface and storing it in the SAP project data server;
(2)用于判断所采集的数据是否在集团企业监控范围内,剔除不属于监控范围内的数据过滤装置;(2) It is used to judge whether the collected data is within the monitoring scope of the group enterprise, and eliminate the data filtering devices that do not belong to the monitoring scope;
(3)数据调用装置:(3) Data calling device:
用于按一定的取数规则和取数频率分别对采集到的数据进行调用的装置,A device for invoking the collected data according to certain access rules and access frequencies,
通过对所调用数据进行风险判断,分别实现对集团企业电费账户、农网账户、闲置账户、资金余额安全备付情况、资金归集情况、账外账及未达账数据的实时监控的装置;Through the risk judgment of the transferred data, it is a device to realize the real-time monitoring of the group enterprise's electricity account, rural network account, idle account, fund balance security reserve, fund collection, off-book account and unaccounted data;
对各级单位账户的银行余额和账务余额为基础计算每月四个时间点的资金归集比率;包括15日、21日、25日、月末日的资金归集比率,计算出来后作为对各单位资金归集考核的依据;具体方法为:以纳入中电财核算的银行账户资金余额作为分子,以所有账户余额剔除农网账户和保证金账户资金后的余额作为分母。Based on the bank balance and account balance of the unit accounts at all levels, the fund collection ratio at four time points per month is calculated; including the fund collection ratio on the 15th, 21st, 25th, and the end of the month, the calculation is used as a comparison The basis for the collection and assessment of the funds of each unit; the specific method is: take the fund balance of the bank account included in the accounting of China Electronics Finance as the numerator, and use the balance of all account balances after excluding the funds in the rural power grid account and the margin account as the denominator.
所述said
中电财数据包括:受中电财监控的所有银行的历史与当日交易、余额数据;CLP Finance data includes: historical and current day transactions and balance data of all banks monitored by CEC Finance;
财务管控数据包括:核算账务、现金预算、报表、业务单据、融资台账、电子支付数据;Financial control data include: accounting, cash budget, reports, business documents, financing ledger, electronic payment data;
SAP系统数据为包括基本建设、技术改造、大修理、研究开发、信息化在内的项目相关数据。SAP system data is project-related data including capital construction, technological transformation, overhaul, research and development, and informatization.
所述用于对集团企业电费账户进行监控的装置包括:The device for monitoring the electricity account of the group enterprise includes:
用于调用中电财数据服务器数据的装置,A device for invoking the data of the China Electronics Finance data server,
用于筛查各监控单位的电费上缴单位与其上级单位不一致的异常支付记录,根据异常支出金额的大小判定电费账户异常支出数据的风险等级,同时生成电费账户支出异常监控数据,并根据客户端具体的查询条件进行相应的展示的装置;It is used to screen the abnormal payment records of the electricity bill payment unit of each monitoring unit that is inconsistent with its superior unit, determine the risk level of the abnormal expenditure data of the electricity account according to the size of the abnormal expenditure amount, and generate the abnormal monitoring data of the electricity account expenditure at the same time. A device for displaying corresponding query conditions;
用于对所述电费账户支出异常监控数据进行风险判断:如果是风险数据,则自动生成电费账户支出异常监控风险处理操作单,并根据风险处理操作单的内容自动生成督办单,所述督办单的反馈信息经审核通过后,取消风险状态;如果不是风险数据,则直接取消风险状态的装置。It is used for risk judgment on the abnormal electricity account expenditure monitoring data: if it is risk data, automatically generate an electricity account expenditure abnormality monitoring risk processing operation sheet, and automatically generate a supervision sheet according to the content of the risk processing operation sheet, and the supervision sheet After the feedback information is approved, the risk status will be canceled; if it is not risk data, the risk status device will be canceled directly.
所述用于对集团企业农网账户进行监控的装置包括:The device for monitoring the rural network account of the group enterprise includes:
用于分别调用财务管控数据服务器和SAP项目数据服务器数据的装置,A device for invoking the data of the financial control data server and the SAP project data server respectively,
用于筛查各监控单位农网账户的异常支付数据,根据异常支付金额的大小判定农网账户异常支出数据的风险等级,同时生成农网账户支出异常监控数据,并根据客户端具体的查询条件进行相应的展示的装置;It is used to screen the abnormal payment data of the rural network accounts of each monitoring unit, determine the risk level of the abnormal payment data of the rural network accounts according to the size of the abnormal payment amount, and generate abnormal rural network account expenditure monitoring data at the same time, and according to the specific query conditions of the client The device for the corresponding display;
用于对所述农网账户支出异常监控数据进行风险判断:如果是风险数据,则自动生成农网账户支出异常监控风险处理操作单,并根据风险处理操作单的内容自动生成督办单,所述督办单的反馈信息经审核通过后,取消风险状态;如果不是风险数据,则直接取消风险状态的装置。It is used for risk judgment on the abnormal rural network account expenditure monitoring data: if it is risk data, automatically generate a rural network account expenditure abnormal monitoring risk processing operation sheet, and automatically generate a supervision sheet according to the content of the risk processing operation sheet. After the feedback information of the supervision form is approved, the risk status will be canceled; if it is not the risk data, the device in the risk status will be canceled directly.
所述用于对集团企业账外账数据进行监控的装置包括:The device for monitoring the off-book account data of the group enterprise includes:
用于调用中电财数据服务器数据的装置,A device for invoking the data of the China Electronics Finance data server,
用于筛查各监控单位交易时对方单位名称为本单位而对方账号为非本单位账户的交易记录,根据交易金额的大小判定账外账异常数据的风险等级,同时生成账外账异常监控数据,并根据客户端具体的查询条件进行相应的展示的装置;It is used to screen the transaction records in which the name of the counterparty is the unit and the account number of the counterparty is not the account of the unit during the transaction of each monitoring unit. According to the size of the transaction amount, the risk level of the abnormal data of the off-book account is determined, and the abnormal monitoring data of the off-book account is generated at the same time. , and display the device according to the specific query conditions of the client;
用于对所述账外账异常监控数据进行风险判断:如果是风险数据,则自动生成账外账异常监控风险处理操作单,并根据风险处理操作单的内容自动生成督办单,所述督办单的反馈信息经审核通过后,取消风险状态;如果不是风险数据,则直接取消风险状态的装置。It is used for risk judgment on the abnormal monitoring data of off-book accounts: if it is risk data, an operation sheet for abnormal monitoring of off-book accounts is automatically generated, and a supervision sheet is automatically generated according to the content of the risk processing operation sheet, and the supervision sheet After the feedback information is approved, the risk status will be canceled; if it is not risk data, the risk status device will be canceled directly.
所述用于对集团企业闲置账户进行监控的装置包括:The device for monitoring idle accounts of the group enterprise includes:
用于调用财务管控数据服务器数据的装置,means for invoking data from a financial control data server,
用于筛查各监控单位在设定时间内收支记录小于一定数量的银行账户,生成闲置账户监控数据并根据客户端查询条件进行相应展示的装置。It is a device for screening the bank accounts whose income and expenditure records are less than a certain number within the set time of each monitoring unit, generating idle account monitoring data and displaying them according to the query conditions of the client.
所述用于对集团企业资金余额安全备付情况进行监控的装置包括:The device for monitoring the safety reserve of the fund balance of the group enterprise includes:
用于分别调用中电财数据服务器和财务管控数据服务器数据的装置,A device for invoking the data of the CEC financial data server and the financial control data server respectively,
用于筛查各监控单位月末银行存款超过备付额度的账户,根据监控单位月末银行存款科目期末余额超出安全备付额度的数目以及账号类型,判定账户是否存在风险,同时生成备付额度监控数据并根据客户端查询条件进行相应展示的装置。It is used to screen the accounts whose bank deposits exceed the reserve amount at the end of the month of each monitoring unit. According to the number of bank deposit subjects at the end of the month of the monitoring unit exceeding the safety reserve amount and the type of account, determine whether the account is at risk, and generate monitoring data of the reserve amount at the same time And according to the query conditions of the client to display the device accordingly.
所述用于 对集团企业未达账数据进行监控的装置包括:The device for monitoring unreconciled data of the group enterprise includes:
用于调用财务管控数据服务器数据的装置,means for invoking data from a financial control data server,
用于筛查各监控单位月末筛查各监控单位月末企业已入账而银行未入账或者银行已入账而企业未入账的数据,生成未达账数据并根据客户端查询条件进行相应展示的装置。It is used to screen the data of each monitoring unit at the end of the month that the enterprise has entered the account but the bank has not, or the bank has entered the account but the enterprise has not entered the account, generates unaccounted data and displays it according to the client query conditions.
所述用于对集团企业资金归集情况进行监控的装置包括:The device for monitoring the fund collection of the group enterprise includes:
用于分别调用中电财数据服务器和财务管控数据服务器数据的装置,A device for invoking the data of the CEC financial data server and the financial control data server respectively,
用于设定各监控单位的考核时点,按照不同的考核时点提取各监控单位所有账户的资金余额信息,判断所调用数据是否为合作金融机构账户数据,如果是,则以中电财数据作为银行账户余额,如果否,则以财务管控中的账务余额作为银行账户余额的装置;It is used to set the assessment time point of each monitoring unit, extract the fund balance information of all accounts of each monitoring unit according to different assessment time points, and judge whether the called data is the account data of a cooperative financial institution. As the bank account balance, if not, the account balance in the financial control as the means of the bank account balance;
用于分别计算各监控单位在设定考核时点的资金实时归集比率及月内平均归集比率数据并显示的装置。A device for calculating and displaying the real-time fund collection ratio and monthly average collection ratio data of each monitoring unit at the set assessment time point.
所述风险处理操作单信息包括:The risk treatment operation sheet information includes:
业务信息:付款单位信息、项目相关信息、收款单位信息以及支付内容相关信息;Business information: payment unit information, project-related information, payee unit information, and payment content-related information;
风险规则:判断风险产生的预定规则;Risk rules: predetermined rules for judging the occurrence of risks;
风险处理信息:风险等级、风险判断、判断人、生成督办单、风险处理操作单发出时间、信息反馈人、反馈时间、佐证材料、处理状态;Risk treatment information: risk level, risk judgment, judgment person, generation of supervision form, time of issuing risk treatment operation order, information feedback person, feedback time, supporting materials, processing status;
督办单内容主要包括:发现风险的单位、时间、风险原因、具体账户信息、账户交易信息、建议整改期限、联系人、发起单位信息。The content of the supervision form mainly includes: the unit where the risk was discovered, the time, the cause of the risk, specific account information, account transaction information, suggested rectification period, contact person, and information on the initiator.
本发明的有益效果是:The beneficial effects of the present invention are:
通过系统对海量数据进行加工与甄别,提高了集团本部对资金风险的快速反应和干预能力,对于三级重大风险,可以由本部直接下达问题风险处理操作单,并将基层单位的整改情况记录在系统中,从而有效形成管理闭环,对防范账户使用风险、确保企业资金安全起到了重要作用。Through the processing and screening of massive data through the system, the rapid response and intervention capabilities of the group headquarters to capital risks have been improved. For three-level major risks, the headquarters can directly issue problem risk treatment operation orders, and record the rectification of grassroots units in the In the system, a management closed loop is effectively formed, which plays an important role in preventing account use risks and ensuring the safety of corporate funds.
附图说明Description of drawings
图1为本发明整体方法流程图;Fig. 1 is the overall method flowchart of the present invention;
图2(a)为本发明资金账户监控方法流程图一;Fig. 2(a) is a flow chart 1 of the capital account monitoring method of the present invention;
图2(b)为本发明资金账户监控方法流程图二。Fig. 2(b) is the second flow chart of the capital account monitoring method of the present invention.
具体实施方式:detailed description:
下面结合附图与实施例对本发明做进一步说明:Below in conjunction with accompanying drawing and embodiment the present invention will be further described:
如图1所示,一种用于集团企业资金账户数据监控的方法,包括以下步骤:As shown in Figure 1, a method for monitoring data of a group enterprise capital account includes the following steps:
(1)数据采集:(1) Data collection:
通过资金监控与中电财数据接口调取中电财数据并存入中电财数据服务器;Retrieve CEC Finance data through fund monitoring and CEC Finance data interface and store it in CEC Finance data server;
通过资金监控与财务管控数据接口调取财务管控数据并存入财务管控数据服务器;Retrieve financial control data through the fund monitoring and financial control data interface and store it in the financial control data server;
通过资金监控与SAP项目数据接口调取SAP项目数据并存入SAP项目数据服务器;Retrieve SAP project data through the fund monitoring and SAP project data interface and store it in the SAP project data server;
中电财(中国电力财务公司)数据:包括受中电财监控的十三家银行的历史与当日交易、余额数据,通过接口获取数据后,按照抵销规则与画线规则,自动展示各单位的月曲线、日曲线、时曲线。China Power Finance (China Power Finance Corporation) data: including the history and current day transactions and balance data of 13 banks monitored by China Power Finance. After obtaining the data through the interface, it will automatically display each unit according to the offset rules and line drawing rules The monthly curve, daily curve, and hourly curve.
财务管控数据:包括核算账务、现金预算、报表、业务单据、融资台账、电子支付等数据,通过接口获取数据后,按照展示方式,自动展示各单位的现金预算分析、融资分析、电子支付分析情况等。Financial control data: including accounting, cash budget, reports, business documents, financing ledger, electronic payment and other data, after obtaining the data through the interface, according to the display method, automatically display the cash budget analysis, financing analysis, electronic payment of each unit Analyze the situation, etc.
SAP系统数据:主要包括基建、技改、大修理、研究开发、信息化在内的项目相关数据。。通过接口获取数据后,按项目编码、项目类型等规则,结合预算、电子支付等数据,展示各单位支出情况。SAP system data: mainly includes project-related data such as infrastructure construction, technical transformation, overhaul, research and development, and informatization. . After obtaining the data through the interface, according to the project code, project type and other rules, combined with budget, electronic payment and other data, the expenditure situation of each unit is displayed.
接口说明Interface Description
资金监控与中电财数据接口:以连接数据库和WebService相结合技术实现资金监控与中电财数据交互。Fund monitoring and CEC Finance data interface: Realize fund monitoring and CEC Finance data interaction by combining the technology of connecting database and WebService.
资金监控与财务管控数据接口:以连接数据库技术实现资金监控平台与财务管控数据交互。Fund monitoring and financial control data interface: realize the interaction between the fund monitoring platform and financial control data by connecting to the database technology.
资金监控与SAP系统数据接口:以WebService接口技术实现资金监控平台与SAP数据交互。Fund monitoring and SAP system data interface: use WebService interface technology to realize the data interaction between the fund monitoring platform and SAP.
(2)数据过滤:判断所采集的数据是否在集团企业监控范围内,剔除不属于监控范围内的数据;(2) Data filtering: judge whether the collected data is within the monitoring scope of the group enterprise, and eliminate the data that does not belong to the monitoring scope;
(3)数据调用:按一定的取数规则和取数频率分别对采集到的数据进行调用,通过对所调用数据进行风险判断,实现对集团企业电费账户、农网账户、闲置账户、资金余额安全备付情况、资金归集情况、账外账及未达账数据的实时监控。(3) Data call: Call the collected data according to certain access rules and access frequency, and realize the group enterprise electricity account, rural network account, idle account, and fund balance by making risk judgments on the called data. Real-time monitoring of safety reserve status, fund collection status, off-book account and unpaid data.
农网账户是指用于农网工程收支的专户。The rural power grid account refers to the special account used for the income and expenditure of the rural power grid project.
图2(a)和(b)为本发明资金账户监控方法流程图,具体包括:Figure 2 (a) and (b) are flowcharts of the capital account monitoring method of the present invention, specifically including:
调用中电财数据服务器的中电财数据,分别筛查基层单位的电费上缴单位与其上级单位不一致的账户异常支出数据以及交易单位相同时但对方单位账户为非本单位账户的账外账数据,根据电费账户的支出金额和账外账金额分别判定电费账户异常支出数据和账外账数据风险等级,同时生成电费账户支出异常监控数据、账外账监控数据并显示,对所述监控数据分别进行风险判断:如果是风险数据,则自动生成电费账户支出异常或账外账监控风险处理操作单,并根据风险处理操作单的内容自动生成督办单,所述督办单的反馈信息经审核通过后,取消风险状态;如果不是风险数据,则直接取消风险状态;Call the CEC Finance data of the CEC Finance data server, respectively screen the abnormal expenditure data of the account of the grass-roots unit’s electricity payment unit and its superior unit, and the off-book account data when the transaction unit is the same but the account of the other party’s unit is not the account of the unit, Determine the abnormal expenditure data of the electricity account and the risk level of the off-book account data respectively according to the expenditure amount of the electricity account and the amount of the off-book account, and simultaneously generate and display the abnormal electricity account expenditure monitoring data and the off-book account monitoring data, and carry out the monitoring data respectively Risk judgment: if it is risk data, it will automatically generate an operation sheet for abnormal electricity account expenditure or monitoring risk of off-book accounts, and automatically generate a supervision sheet based on the content of the risk processing operation sheet. After the feedback information of the supervision sheet is approved, Cancel the risk status; if it is not risk data, directly cancel the risk status;
账户异常支出数据中将支付金额小于10万元以下的风险级别标记为一级,支付金额小于100万元的监控级别标记为二级,支付金额大于100万元的风险级别标记为三级。In the abnormal account expenditure data, the risk level of the payment amount less than 100,000 yuan is marked as the first level, the monitoring level of the payment amount of less than 1 million yuan is marked as the second level, and the risk level of the payment amount of more than 1 million yuan is marked as the third level.
支付记录中需剔除以下记录:一是将对方账号开户单位是内部单位的或对方单位开头包含“国网山东”。二是摘要中包括手续费、退电费的记录。The following records need to be excluded from the payment records: First, the counterparty’s account opening unit is an internal unit or the counterparty’s unit starts with “State Grid Shandong”. The second is that the summary includes the records of handling fees and electricity refund fees.
账外账数据根据银行交易记录进行判断。The off-book data is judged based on bank transaction records.
调用财务管控数据服务器的财务管控账务数据,分别筛查各单位在监控在3个月内收支低于3笔的银行闲置账户数据和月末企业已达银行未达、银行已达企业未达的未达账数据,同时生成闲置账户监控数据或未达账数据并显示;Call the financial control account data of the financial control data server, and screen the bank idle account data of each unit monitoring the income and expenditure of less than 3 transactions within 3 months, and the end of the month. Unreceived account data, while generating idle account monitoring data or unreceived account data and displaying it;
将银行账户在三个月内收支低于3笔的风险级别标记为一级,未达账数据根据银行交易记录与账务发生数据进行判断。The risk level of the bank account with less than 3 payments within three months is marked as the first level, and the unreceived account data is judged according to the bank transaction records and account occurrence data.
分别调用中电财数据服务器和财务管控数据服务器数据,筛查各单位的月末银行存款科目期末余额是否超出安全备付额度20%以及本部四个重要账户(尾号34567、3139、1079、3501)是否低于2亿进行判断,并生成备付监控数据并显示。Respectively call the data of the China Electronics Finance data server and the financial control data server to screen whether the end-of-month balance of the bank deposit accounts of each unit exceeds the safety reserve amount by 20% and the four important accounts of the department (tail numbers 34567, 3139, 1079, 3501) It is judged whether it is lower than 200 million, and the reserve monitoring data is generated and displayed.
分别调用财务管控数据服务器和第四数据缓存区数据,筛查各单位农网账户的异常支出数据,根据农网账户支出金额判定数据风险等级,同时生成农网账户支出异常监控数据并显示,对所述监控数据进行风险判断:如果是风险数据,则自动生成农网账户支出异常监控风险处理操作单,并根据风险处理操作单的内容自动生成督办单,所述督办单的反馈信息经审核通过后,取消风险状态;如果不是风险数据,则直接取消风险状态。Invoke the data of the financial control data server and the fourth data cache area respectively, screen the abnormal expenditure data of the rural network accounts of each unit, determine the data risk level according to the expenditure amount of the rural network accounts, and generate and display the abnormal expenditure monitoring data of the rural network accounts. The monitoring data is used for risk judgment: if it is risk data, a rural network account expenditure abnormality monitoring risk processing operation sheet is automatically generated, and a supervision sheet is automatically generated according to the content of the risk processing operation sheet, and the feedback information of the supervision sheet is reviewed and approved After that, cancel the risk status; if it is not risk data, cancel the risk status directly.
支付记录中剔除以下核算科目发生的数据,对方科目是“预付账款、其他保证金、财务费用/手续费、应付账款、财务费用/利息支出、应付利息/长期借款利息、在建工程/基建工程支出/待摊基建支出”,同时若工程项目编号在农网项目范围内的也进行剔除。The data of the following accounting subjects are excluded from the payment records, and the opposite subjects are "accounts paid in advance, other deposits, financial expenses/handling fees, accounts payable, financial expenses/interest expenses, interest payable/long-term loan interest, construction in progress/infrastructure Construction expenditure/expenses to be amortized infrastructure construction", and if the project number is within the scope of the rural power network project, it will also be excluded.
将支付金额小于10万元的风险级别标记为一级,支付金额小于100万元的风险级别标记为二级,支出金额超过100万元的风险级别标记为三级。Mark the risk level with the payment amount less than 100,000 yuan as the first level, the risk level with the payment amount less than 1 million yuan as the second level, and the risk level with the payment amount exceeding 1 million yuan as the third level.
对各级单位账户的银行余额和账务余额为基础计算每月四个时间点的资金归集比率。包括15日、21日、25日、月末日的资金归集比率,计算出来后作为对各单位资金归集考核的依据。具体方法为:以纳入中电财核算的银行账户资金余额作为分子,以所有账户余额剔除农网账户和保证金账户资金后的余额作为分母。Based on the bank balance and account balance of unit accounts at all levels, the fund collection ratio at four time points per month is calculated. Including the fund collection ratio on the 15th, 21st, 25th, and the end of the month, after calculation, it will be used as the basis for the assessment of the fund collection of each unit. The specific method is: take the fund balance of the bank account included in the accounting of China Electronics Finance as the numerator, and use the balance of all account balances after excluding the funds in the rural network account and the margin account as the denominator.
在处理风险状态时,包括以下几种情况:When dealing with risk states, the following situations are included:
1.发现问题,尚未处理;此时风险级别标记显示为红色星星;1. The problem has been found and has not been dealt with; at this time, the risk level mark is displayed as a red star;
2.发出警示,正在处理;此时风险级别标记显示为黄色菱形;2. A warning is issued and it is being processed; at this time, the risk level mark is displayed as a yellow diamond;
3.已有反馈,处理完毕;此时风险级别标记显示为绿色圆形;3. There has been feedback and the processing has been completed; at this time, the risk level mark is displayed as a green circle;
4.柜台发现问题,但后期确认不是风险的,此时风险级别标记的红色星星改为灰色。4. The counter found a problem, but it was later confirmed that it was not a risk. At this time, the red star marked with the risk level changed to gray.
风险处理操作单包括:The risk treatment operation sheet includes:
业务信息:付款单位信息、项目相关信息、收款单位信息以及支付内容相关信息等;Business information: payment unit information, project-related information, payee unit information, payment content-related information, etc.;
风险规则:判断风险产生的预定规则;Risk rules: predetermined rules for judging the occurrence of risks;
风险处理信息:风险等级、风险判断、判断人、生成督办单、督办单发出时间、信息反馈人、反馈时间、佐证材料、处理状态等。Risk treatment information: risk level, risk judgment, judgment person, generation of supervision form, time of issuance of supervision form, information feedback person, feedback time, supporting materials, processing status, etc.
督办单内容主要包括:发现风险的单位、时间、原因、具体账户信息、账户交易信息、建议整改期限、联系人、发起单位等信息。The content of the supervision form mainly includes: the unit that discovered the risk, time, reason, specific account information, account transaction information, suggested rectification period, contact person, initiator and other information.
上述虽然结合附图对本发明的具体实施方式进行了描述,但并非对本发明保护范围的限制,所属领域技术人员应该明白,在本发明的技术方案的基础上,本领域技术人员不需要付出创造性劳动即可做出的各种修改或变形仍在本发明的保护范围以内。Although the specific implementation of the present invention has been described above in conjunction with the accompanying drawings, it does not limit the protection scope of the present invention. Those skilled in the art should understand that on the basis of the technical solution of the present invention, those skilled in the art do not need to pay creative work Various modifications or variations that can be made are still within the protection scope of the present invention.
Claims (2)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410283247.9A CN104021454B (en) | 2014-06-23 | 2014-06-23 | Method and system for monitoring fund account data of group enterprises |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410283247.9A CN104021454B (en) | 2014-06-23 | 2014-06-23 | Method and system for monitoring fund account data of group enterprises |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104021454A CN104021454A (en) | 2014-09-03 |
CN104021454B true CN104021454B (en) | 2017-09-01 |
Family
ID=51438194
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410283247.9A Expired - Fee Related CN104021454B (en) | 2014-06-23 | 2014-06-23 | Method and system for monitoring fund account data of group enterprises |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104021454B (en) |
Families Citing this family (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105446875B (en) * | 2014-11-18 | 2017-12-26 | 国网山东省电力公司 | The monitoring method and monitoring system of interface and system based on SAP platforms |
CN105447069B (en) * | 2014-11-18 | 2017-10-13 | 国网山东省电力公司 | Reconciliation platform data synchronous method and system based on BW platforms |
CN104866957A (en) * | 2015-05-11 | 2015-08-26 | 国家电网公司 | Monitoring system of finance business data |
CN105184477A (en) * | 2015-08-31 | 2015-12-23 | 武汉博楷管理咨询有限公司 | Finance business data monitoring and management system |
CN106296384A (en) * | 2016-08-15 | 2017-01-04 | 国家电网公司 | One connects electricity charge processing method temporarily |
CN107341211B (en) * | 2017-06-26 | 2020-09-01 | 北京火眼神算数据科技有限公司 | Service data collection management method and system |
CN107492031B (en) * | 2017-07-06 | 2020-05-29 | 兴业数字金融服务(上海)股份有限公司 | Quasi-real-time financial system account checking method based on function contract bypass analysis |
CN108269182B (en) * | 2017-08-24 | 2021-04-02 | 平安科技(深圳)有限公司 | Balance calculation method and calculation equipment based on fund collection |
CN107562416A (en) * | 2017-08-31 | 2018-01-09 | 深圳市瑞福登信息技术服务有限公司 | A kind of management system processing method, device, storage device and terminal device |
CN107767105A (en) * | 2017-11-27 | 2018-03-06 | 郑州云海信息技术有限公司 | A kind of automatic system and method for obtaining BOM information |
CN109284887A (en) * | 2018-03-08 | 2019-01-29 | 中国平安人寿保险股份有限公司 | A kind of risk control method, equipment and the storage medium of insurance kind sale |
CN111080236B (en) * | 2019-11-28 | 2023-08-04 | 上海金仕达软件科技股份有限公司 | Enterprise operation management system based on financial account system |
CN113159943A (en) * | 2021-02-23 | 2021-07-23 | 国网山东省电力公司 | Bank account transaction behavior portrait construction method and system |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2011068800A1 (en) * | 2009-12-01 | 2011-06-09 | Bank Of America Corporation | Comprehensive suspicious activity monitoring and alert system |
CN102789618A (en) * | 2011-12-28 | 2012-11-21 | 焦点科技股份有限公司 | Monitoring system and monitoring method for generating market business index |
CN103679373A (en) * | 2013-04-12 | 2014-03-26 | 国家电网公司 | Full chain budget data processing system and method for production infrastructure standard cost system |
-
2014
- 2014-06-23 CN CN201410283247.9A patent/CN104021454B/en not_active Expired - Fee Related
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2011068800A1 (en) * | 2009-12-01 | 2011-06-09 | Bank Of America Corporation | Comprehensive suspicious activity monitoring and alert system |
CN102789618A (en) * | 2011-12-28 | 2012-11-21 | 焦点科技股份有限公司 | Monitoring system and monitoring method for generating market business index |
CN103679373A (en) * | 2013-04-12 | 2014-03-26 | 国家电网公司 | Full chain budget data processing system and method for production infrastructure standard cost system |
Also Published As
Publication number | Publication date |
---|---|
CN104021454A (en) | 2014-09-03 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104021454B (en) | Method and system for monitoring fund account data of group enterprises | |
CN104021457A (en) | Method and system for monitoring group enterprise cost expenditure data | |
CN104021456A (en) | Method and system used for all-around enterprise group capital data monitoring | |
CN113095712A (en) | Enterprise credit granting score obtaining method and device and computer equipment | |
CN105469308A (en) | Financing risk evaluation system and method of middle and small-sized enterprises | |
US12039594B1 (en) | Systems and methods for generating account forecast alerts | |
JP2009193449A (en) | Financial transaction monitoring system and method | |
CN115082075A (en) | A payment abnormal risk monitoring system and method | |
CN110288038A (en) | Method and device for classifying enterprises | |
WO2014194582A1 (en) | Financial tax integrated resources planning system | |
US11276065B2 (en) | Transaction lifecycle monitoring | |
CN113034258A (en) | Tax data processing method and device, electronic equipment and storage medium | |
JP6760875B2 (en) | Account management equipment and programs | |
JP6760874B2 (en) | Information processing equipment and programs | |
CN116934131A (en) | A method, device and equipment for evaluating enterprise operating conditions | |
TWI585709B (en) | Financial management diagnosis method and system thereof | |
JP6766023B2 (en) | Information processing equipment and programs | |
CN114742634A (en) | Method and device for processing data of same-industry deposit receipt and electronic equipment | |
CN114357523A (en) | Method, device, equipment, storage medium and program product for identifying risk object | |
CN111105154A (en) | Stock market operation risk assessment method and device, electronic equipment and storage medium | |
JP7016394B2 (en) | Information processing equipment and programs | |
JP7049417B2 (en) | Account management equipment and programs | |
CN107436956B (en) | Method, device and system for transmitting social security collection data | |
CN114240610B (en) | Automatic fund collection method, device, computer equipment and storage medium | |
KR102135457B1 (en) | Apparatus for supporting invest banking |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
CB03 | Change of inventor or designer information | ||
CB03 | Change of inventor or designer information |
Inventor after: Ma Ruixia Inventor after: Jiang Yan Inventor after: Wang Duanrui Inventor after: Mao Yudong Inventor after: Wu Jian Inventor after: Xue Liang Inventor after: Pan Shuyi Inventor after: Cui Feng Inventor after: Bu Xiaoqian Inventor after: Li Junyang Inventor before: Shang Qide Inventor before: Wang Duanrui Inventor before: Mao Yudong Inventor before: Pan Shuyi Inventor before: Cui Feng Inventor before: Bu Xiaoqian Inventor before: Hu Xiaoning Inventor before: Gao Xiangyu |
|
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20170901 |