Disclosure of Invention
The technical problem to be solved by the invention is to provide an analysis method of bank flow data, which can comprehensively and accurately analyze the operation condition of an enterprise.
In order to solve the technical problem, the invention provides a method for analyzing bank pipelining data, which comprises the following steps: acquiring bank flow data generated in the enterprise operation process; identifying operational flow, financing flow, investing flow, money, abnormal transaction and associated transaction from bank flow data respectively; eliminating the forward money, abnormal transactions and related transactions from bank running data managed by enterprises; and automatically analyzing the operation condition of the enterprise in the whole process according to the bank running data after the removal of the incoming money, the abnormal transaction and the associated transaction.
In some embodiments, acquiring bank flow data generated during the business operation process includes: and acquiring bank running data managed by the enterprise through a plurality of different accounts of the enterprise.
In some embodiments, acquiring bank flow data generated in the enterprise operation process further comprises: after acquiring bank flow data managed by an enterprise from a plurality of different accounts of the enterprise, splicing the bank flow data of the same bank account at different times; the same six key fields are extracted through a key word matching technology, wherein the key fields comprise: transaction time, opposite account name, credit generation amount, debit generation amount, balance and abstract.
In some embodiments, identifying from the bank flow data, an operational flow, a financing flow, a round trip, an anomalous transaction, a correlation transaction, respectively, comprises: screening out the associated transactions by taking the name of the opposite party as an index according to the enterprise associated list; according to the characteristics of transaction amount, transaction frequency, transaction time, refund and re-payment and the like, screening abnormal transactions, wherein the abnormal transactions comprise: high-volume transfer, public transfer in non-working time and refund repayment; and screening out the money to be paid according to the transaction characteristics and the matching result of the abstract information and the keywords.
In some embodiments, the whole-course automatic analysis of the business condition of the enterprise according to the bank running data after clearing the money, the abnormal transaction and the associated transaction comprises the following steps: and in the transaction time dimension, the business operation condition is counted.
In some embodiments, the method for automatically analyzing the operation condition of the enterprise in the whole course according to the bank running data after clearing the money from the incoming and the abnormal transactions and the associated transactions further comprises the following steps: performing fluctuation analysis of the operating cost according to the bank running data; and carrying out wage analysis on the enterprise staff according to the bank flow data.
In some embodiments, payroll analysis of enterprise employees is performed, including: and comparing the salary analysis result of the enterprise staff with salary statistical data published by each province statistical bureau.
In some embodiments, the statistics of business operations include: the average daily balance, and the first ten counter-parties.
In some embodiments, the statistics of the top ten counterparties include: statistics of the outflow of funds, and statistics of the inflow of funds.
After adopting such design, the invention has at least the following advantages:
the invention can eliminate the adverse effect of the running data related to the current money, the abnormal transaction and the associated transaction in the running data of the bank on the final analysis result, and more truly and scientifically reflect the operation condition of the enterprise.
Detailed Description
The preferred embodiments of the present invention will be described in conjunction with the accompanying drawings, and it will be understood that they are described herein for the purpose of illustration and explanation and not limitation.
FIG. 1 illustrates various data items in the banking pipeline data provided by the present invention. Referring to fig. 1, the bank pipelining data includes: banking data relating to the business is collected from four banks, each commercial bank, and each different city merchant bank.
It should be noted that the system is compatible with bank flow data in different formats. Therefore, the system can be compatible no matter from which bank the data source of the pipeline data comes.
By screening and summarizing the bank running data from different data sources, key fields in the bank running data are identified from the running data in different formats. Referring to fig. 1, these key fields may have: time of transaction, name of the opposite party, amount of credit, amount of debit, balance, summary, etc.
Through further analysis of the data characteristics in the various key fields described above, bank flow data can be distinguished into six categories. These six categories are: management flow, financing flow, investment flow, associated transaction, money to go, and abnormal transaction.
Through the analysis of the characteristics, six types of flow data are identified, and the most typical case is that the forward and backward money is identified through the characteristics of the summary data. Because, the running data of the current money is explicitly stated in the abstract.
The analysis method of the bank flow book provided by the invention classifies the six types of flow data respectively in the analysis process, so that the analysis result of the operation condition obtained by analyzing the flow data classified according to the classification is more comprehensive and accurate.
In addition, among the six types of flow data, some types of flow data have adverse effects on the final analysis result if no special processing is performed. For example, anomalous transactions, due to their own data characteristics, should not be taken into account during the analysis process. Similar categories also include: to and from and associated transactions.
The abnormal transactions, the money to be sent and the related transactions are cleared in the analysis process, and the final analysis result is not adversely affected, so that the analysis result of the operation condition is more accurate.
The system has higher compatibility. An enterprise has multiple bank accounts, each with different functions. If an account is analyzed, the data is too single. The system supports multiple accounts of one enterprise, the flow of different banks can be analyzed simultaneously and uniformly, the flow formats of different banks can be automatically adjusted, the data of each account in the same time period are collected and analyzed, the system is automatic in the whole process, and a complete analysis report can be automatically generated once the report is submitted.
The system has comprehensiveness and accuracy in data analysis. The bank running data is divided into six categories and two statistics, wherein the six categories comprise management running, financing running, investment running, money to go, abnormal transactions and related transactions. Both statistics are daily balance statistics, and the top ten counterparties (including inflow/outflow). Here, the counterparty refers to the counterparty in the transaction.
The detail of the commercial flowing water is sales return, income outside the business and others. The operating running water flow details are purchase money, salary, water, electricity, gas, rent, tax and others.
The salary part is analyzed and compared in combination with the wage level of the region where the enterprise is located, the hydropower gas is analyzed and whether large fluctuation exists or not in the time dimension, and the salary part and the water gas part can greatly reflect whether the enterprise normally operates or not.
The financing pipelining module counts the proportion of the liabilities of the enterprises and can fully reflect the liabilities of the enterprises. And adding lists of various large-scale financial mechanisms for matching, and ensuring the accuracy of data.
The associated transactions comprise transactions of shareholders, enterprises with invested out-of-shareholders, enterprises invested out-of-business, director of invested out-of-business and the like. The proportion of the associated transaction flow occupying the flow is large, and the probability of false transactions is also large, so the system independently divides the transactions into one block.
The association transaction mainly involves the corporate legal person and the company associated with the board of director. Aiming at each enterprise, the system can automatically generate an associated enterprise list, and the user name is compared with the associated enterprise list.
Abnormal transactions are screened in dimensions such as wrong refund, public transactions in non-working time, high-frequency and large-amount (non-top ten suppliers) transactions, and account which does not have transactions for a long time suddenly enters large-amount funds. High frequency: more than 30% of the daily average number of strokes. Large amount: the monthly income is more than 15 percent.
The system can provide data such as inflow/outflow proportion, management water flow detail and proportion, liability rate, net inflow, daily average balance and the like, and can comprehensively and truly reflect the enterprise management condition.
After an enterprise uploads a bank flow to the system, the system starts to read bank flow documents (xls or xlsx formats), data splicing is carried out on flow of the same account at different times, the difference of the flow document formats among different banks is large, and the system extracts the same six fields through a keyword matching technology: 1. transaction time 2, opposite account name 3, credit generation amount 4, debit generation amount 5, balance 6 and summary. The transaction time field is extracted from fields such as transaction time, transaction date or date and the like into a field containing date and time; the opposite account name field is named uniformly by the opposite account name, the opposite name and the like; the credit generation amount field is named uniformly by the fields of credit generation amount, income and the like; the debit generation amount field is named uniformly by the debit generation amount field, the debit expenditure field and other fields; the balance field is named uniformly by account balance, transaction balance and the like; the abstract fields are named uniformly by abstract, epilogue, transaction information, transaction purpose, remarks and the like.
And analyzing the business operation condition on the transaction time dimension, wherein the business transaction and the daily average balance/minimum balance are counted from the relation of money and time. The opposite account name is used for transaction detail statistics of the first ten counter parties and each module, and similar financial institutions/banks in the related transaction and the financing transaction are matched from the opposite account name. The credit generation amount, the debit generation amount and the balance can be counted from the inflow/outflow of each module and the proportion of the amount. Most transaction classifications are matched through keywords in the summary information, and mainly comprise wages, rent, payment, water, electricity, gas, tax, commission fees, interest and the like.
The modules are overlapped, for example, one transaction may belong to related transaction, abnormal transaction, and transaction money, so that the analysis sequence of the data and the data screening logic have a large influence on the final analysis result and the operation speed, and the system performs key design on the data analysis logic. The system preferentially extracts data with high extraction definition by using data which is easy to scatter. Firstly, a data pivot table is adopted, the name of the opposite user is used as an index, and the related transaction is screened out, so that the data accuracy is high. Secondly, the refund in the abnormal transaction is paid again, if part of the data is classified into other types, the data cannot be screened subsequently, and if the data is forged, the amount of the refund is larger, so that the data is screened preferentially. Thirdly, transferring accounts in non-working time, and sorting data with high accuracy through time checking; fourthly, the money to be exchanged has clear remarks in the abstract and the transaction characteristics are obvious. Fifthly, financing the running water. And sixthly, the outflow part of the business transaction comprises compensation, house renting, water, electricity, gas and tax. The abstract characteristics are also obvious. Seventh, the rest of the commercial effluent, which mainly includes money (low value consumables, office supplies, deposit, etc.). And eighthly, dividing the rest transaction flow into a sales return and a purchase of an operational flow according to income and expenditure.
Fig. 2 shows an execution flow chart of the analysis method of the bank flow data provided by the invention. Referring to fig. 2, the method for analyzing the bank flow data may include the following operation steps:
s201, the user logs in.
S202, the user uploads the bank flow data.
The system is compatible with bank flow data in various formats, so that the source bank of the uploaded bank flow data is not limited to one bank.
And S203, uploading the bank flow data to a background database.
And uploading the data to a background database, wherein the data consistency of the data in the analysis process is mainly required to be ensured.
And S204, triggering the background code to calculate.
The calculation process may be keyword matching, category identification, and the like.
And S205, unifying and splicing the format of the pipeline data.
Here, splicing refers to splicing of the pipeline data of the same account in different time periods.
S206, a plurality of data tables are generated according to the pipeline data.
For the generation of the data table, the original pipeline data has been processed considerably. Thus, these data tables may already be manually analyzed for some assessment of the business' operational status.
And S207, drawing a chart according to the data table.
The purpose of graphing is to make the presentation of the final generated report more intuitive.
And S208, generating an excel report according to the set format.
S209, converting the excel report into a PDF format.
The conversion here only involves the conversion of the data format and does not further process the report content.
And S210, uploading the report in the PDF format to a background database.
The purpose of uploading the database is to do data persistence work.
And S211, downloading the running water analysis report by the user.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the present invention in any way, and it will be apparent to those skilled in the art that the above description of the present invention can be applied to various modifications, equivalent variations or modifications without departing from the spirit and scope of the present invention.