Cash flow analysis method and device based on income and expenditure project mapping

Abstract

The invention belongs to the field of income and expenditure data processing, and provides a cash flow analysis method and device based on income and expenditure project mapping. The method comprises the steps of calling an extraction engine and executing extraction operation, and extracting cash flow statistics basic data within a set time range from cash flow related data of a preset fund organization; obtaining all income and expenditure items and income and expenditure item mapping under a preset fund organization, calling a matching rule generation engine and executing a generation operation, and generating a matching rule under the preset fund organization based on the income and expenditure items, the income and expenditure item mapping and a relation between income and expenditure item mapping fields and matching fields; calling a matching engine and executing a matching operation, matching the income and expenditure items with the cash flow statistics basic data based on a matching rule under a preset fund organization, and generating a matching record; and calling a statistical engine and executing statistical operation, carrying out statistics on the matching records according to the business dimension, and generating an income and expenditure item cash flow statistical table of the management dimension, which can provide timely and accurate information for a management layer.

Description

Technical Field

[0001] The present invention belongs to the field of revenue and expenditure data processing, and particularly relates to a cash flow analysis method and device based on revenue and expenditure item mapping. Background Art

[0002] The statements in this part only provide background technical information related to the present invention and do not necessarily constitute prior art.

[0003] Currently, there are certain timeliness problems with the cash flow statement obtained from financial analysis. Although it can clearly show the cash inflows and outflows of an enterprise within a certain period, it is not sufficient to deeply analyze the profitability and capital use efficiency of each business activity and cannot fully display the true financial status of the enterprise. In addition, the current cash flow statement usually only provides total data and lacks detailed analysis of specific businesses and projects, resulting in limitations in information transparency. Moreover, the existing cash flow statement is also relatively rough in statistical dimensions. Managers may need to analyze the cash flow according to the payment method (such as check payment, bill payment, bank-enterprise payment) or business classification. Although the information on the payment method may be obtained from bank statements, it is difficult to directly obtain the information according to the unique business classification of the enterprise from the existing bank statement information.

[0004] In summary, the existing cash flow statement analysis technology cannot generate a personalized cash flow statement according to the business characteristics of the enterprise, and may lead to decision-making mistakes by managers due to the lag of cash flow information. Summary of the Invention

[0005] To solve the above technical problems, the present invention provides a cash flow analysis method and device based on revenue and expenditure item mapping. By establishing revenue and expenditure items based on the business dimension and mapping these items to cash flow data such as bank statements, a connection is established between the business dimension and the business classification of cash flow data such as bank statements, so that a cash flow statement that conforms to the business characteristics of the enterprise can be generated at any time, providing timely and accurate information for the management and helping to avoid decision-making mistakes caused by information lag.

[0006] To achieve the above object, the present invention adopts the following technical solutions:

[0007] The first aspect of the present invention provides a cash flow analysis method based on revenue and expenditure item mapping.

[0008] In one or more embodiments, a cash flow analysis method based on revenue and expenditure item mapping is provided, including:

[0009] Invoking an extraction engine and performing an extraction operation to extract the basic cash flow statistical data within a set time range from the cash flow-related data of a preset fund organization;

[0010] Obtain all revenue and expenditure items and their mappings under the preset fund organization, then call the matching rule generation engine and execute the generation operation. Based on the relationship between the revenue and expenditure items, their mappings, and the mapping fields and matching fields, generate the matching rules under the preset fund organization;

[0011] Call the matching engine and execute the matching operation. Based on the matching rules under the preset fund organization, match the revenue and expenditure items of the preset fund organization with the basic cash flow statistical data to generate matching records;

[0012] Call the statistical engine and execute the statistical operation. Statistically analyze the matching records by business dimension to generate the cash flow statistical table of revenue and expenditure items in the management dimension.

[0013] As an implementation manner, the attributes of the basic cash flow statistical data include the basic cash flow statistical data identifier, fund organization, own account, transaction date, transaction amount, payment method, business category, business category name, postscript, counterparty unit, counterparty account, receipt and payment status, source type, and business activity type.

[0014] As an implementation manner, the attributes of the revenue and expenditure items include the revenue and expenditure item identifier, revenue and expenditure item number, revenue and expenditure item name, fund organization, superior revenue and expenditure item, level, and business activity type.

[0015] As an implementation manner, the revenue and expenditure item mapping is used to define the mapping relationship for matching the revenue and expenditure items with the basic cash flow statistics; the attributes of the revenue and expenditure item mapping include the revenue and expenditure item mapping identifier, the affiliated revenue and expenditure item, several mapping fields, and their corresponding mapping relationships and mapping values.

[0016] As an implementation manner, the attributes of the matching rules include the matching rule identifier, fund organization, revenue and expenditure item identifier, revenue and expenditure item mapping identifier, and matching rule name.

[0017] As an implementation manner, the attributes of the matching records include the matching record identifier, fund organization, revenue and expenditure item identifier, basic cash flow statistical identifier, revenue and expenditure item mapping identifier, and matching rule identifier.

[0018] As an implementation manner, the relationship between the revenue and expenditure item mapping fields and the matching fields includes the following attributes: the relationship identifier between the revenue and expenditure item mapping fields and the matching fields, mapping symbol, mapping field, and the corresponding statistical basis field.

[0019] As an implementation manner, the cash flow statistical table of revenue and expenditure items includes the following attributes: the identifier of the cash flow statistical table of revenue and expenditure items, the identifier of the revenue and expenditure item, the number of the revenue and expenditure item, the name of the revenue and expenditure item, the fund organization, the major business category, the payment method, the revenue and expenditure type, the business activity type, the transaction date, the number of days of the current day, the number of the current month, and the number of the same month of the previous year.

[0020] The second aspect of the present invention provides a cash flow analysis device based on revenue and expenditure item mapping.

[0021] In one or more embodiments, a cash flow analysis device based on revenue and expenditure item mapping includes:

[0022] A basic data extraction module, which is used to call an extraction engine and execute an extraction operation to extract basic cash flow statistical data within a set time range from the cash flow-related data of a preset fund organization;

[0023] A matching rule generation module, which is used to obtain all revenue and expenditure items and revenue and expenditure item mappings under a preset fund organization, and then call a matching rule generation engine and execute a generation operation to generate matching rules under the preset fund organization based on the relationship between the revenue and expenditure items, the revenue and expenditure item mappings, and the mapping fields and matching fields of the revenue and expenditure items;

[0024] A matching record generation module, which is used to call a matching engine and execute a matching operation to match the revenue and expenditure items with the basic cash flow statistical data based on the matching rules under the preset fund organization to generate matching records;

[0025] A matching record statistics module, which is used to call a statistics engine and execute a statistics operation to statistically process the matching records by business dimension to generate a cash flow statistical table of revenue and expenditure items in the management dimension.

[0026] The third aspect of the present invention provides a computer-readable storage medium.

[0027] A computer-readable storage medium, on which a computer program is stored, and when the program is executed by a processor, the steps in the cash flow analysis method based on revenue and expenditure item mapping as described above are implemented.

[0028] The fourth aspect of the present invention provides a computer program product.

[0029] A computer program product includes computer programs / instructions, and when the computer programs / instructions are executed by a processor, the steps in the cash flow analysis method based on revenue and expenditure item mapping as described above are implemented.

[0030] The fifth aspect of the present invention provides an electronic device.

[0031] An electronic device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, the steps in the cash flow analysis method based on revenue and expenditure item mapping as described above are implemented.

[0032] Compared with the prior art, the beneficial effects of the present invention are as follows:

[0033] By sequentially invoking an extraction engine, a matching rule generation engine, a matching engine, and a statistical engine, the present invention generates a revenue and expenditure item cash flow statistical table required for the management dimension. This revenue and expenditure item cash flow statistical table establishes a precise mapping with cash flow data such as bank statements by constructing revenue and expenditure items in the business dimension and the management dimension, thereby establishing a dynamic, business-driven cash flow analysis system. It can generate a cash flow statement reflecting the specific business characteristics of an enterprise in real time, provide detailed and timely financial information for the management level, significantly improve the accuracy and timeliness of decision-making, and effectively avoid decision-making risks caused by information delay. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] The schematic diagrams in the specification forming a part of the present invention are used to provide a further understanding of the present invention. The illustrative embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention.

[0035] Figure 1 is a schematic flowchart of the cash flow analysis method based on revenue and expenditure item mapping according to an embodiment of the present invention;

[0036] Figure 2 is a schematic diagram of the cash flow analysis process based on revenue and expenditure item mapping according to an embodiment of the present invention;

[0037] Figure 3 is a schematic structural diagram of the cash flow analysis device based on revenue and expenditure item mapping according to an embodiment of the present invention;

[0038] Figure 4 is a schematic diagram of an electronic device according to an embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0039] The present invention will be further described below in conjunction with the drawings and embodiments.

[0040] It should be noted that the following detailed description is illustrative and is intended to provide further explanation of the present invention. Unless otherwise specified, all technical and scientific terms used herein have the same meaning as commonly understood by those of ordinary skill in the technical field to which the present invention belongs.

[0041] It should be noted that the terms used herein are only for describing specific embodiments and are not intended to limit the exemplary embodiments according to the present invention. As used herein, unless the context clearly indicates otherwise, the singular forms are also intended to include the plural forms. In addition, it should also be understood that when the terms "comprise" and / or "include" are used in this specification, they specify the presence of features, steps, operations, devices, components, and / or combinations thereof.

[0042] Figure 1 is a schematic flowchart of a cash flow analysis method based on revenue and expenditure item mapping in an embodiment of the present invention. As Figure 1 shown, the cash flow analysis method based on revenue and expenditure item mapping in this embodiment may include the following steps S101 to S104.

[0043] S101, call the extraction engine and perform an extraction operation to extract the basic cash flow statistical data within a set time range from the cash flow-related data of a preset funding organization.

[0044] In step S101, the extraction engine is used to convert data related to cash flow such as bank statements, checks, and bills into the basic cash flow statistics. It includes an operation "extraction", and the specific description is shown in Table 1:

[0045] Table 1 Extraction operation

[0046]

[0047] In this embodiment, the basic cash flow statistical data is used for the basic data specification of cash flow statistics based on management. It is the basis for subsequent cash flow statistics. It has multiple sources, such as multiple data sources related to cash flow, such as bank statements, checks, and bills. After being extracted by the extraction engine, they become a unified data format, that is, the basic cash flow statistics.

[0048] Specifically, the attributes of the basic cash flow statistical data include the basic cash flow statistical data identifier, funding organization, our account, transaction date, transaction amount, payment method, business category, business category name, postscript, counterparty unit, counterparty account, receipt and payment status, source type, and business activity type.

[0049] For example, the detailed structure of the basic cash flow statistical data is specifically described in Table 2:

[0050] Table 2 Structure description of the basic cash flow statistical data

[0051]

[0052]

[0053] S102. Obtain all revenue and expenditure items and their mappings under a preset fund organization, then call the matching rule generation engine and execute the generation operation. Based on the relationship between the revenue and expenditure items, their mappings, and the mapping fields and matching fields, generate the matching rules under the preset fund organization.

[0054] In step S102, the operation "obtain" is used to obtain the combination of revenue and expenditure items and their mappings of a specific organization. Among them, the operation "obtain" includes an input parameter, namely the fund organization; the returned data is a list of the combination of revenue and expenditure items and their mappings.

[0055] In step S102, the revenue and expenditure items are the business divisions of the cash flow statistics management dimension, that is, the trap circulation statistics are carried out based on these management dimensions, and the statistical results will also be counted according to these management divisions; they are divided into global revenue and expenditure items and revenue and expenditure items of specific fund organizations. The specific revenue and expenditure items of a specific fund organization need to be introduced from the global revenue and expenditure items. If a specific fund organization does not define its specific revenue and expenditure items, the global revenue and expenditure items will be used for business statistics; the revenue and expenditure items are hierarchical, and the statistical data of lower-level revenue and expenditure items need to be summarized to the upper-level revenue and expenditure items.

[0056] Specifically, the attributes of the revenue and expenditure items include the revenue and expenditure item identifier, revenue and expenditure item number, revenue and expenditure item name, fund organization, upper-level revenue and expenditure item, level, and business activity type. The detailed description of the revenue and expenditure items is shown in Table 3:

[0057] Table 3 Structural description of revenue and expenditure items

[0058]

[0059]

[0060] The revenue and expenditure item mapping is used to define how the revenue and expenditure items match the cash flow statistics basis, so as to divide the specific cash flow statistics basis into specific revenue and expenditure items. One revenue and expenditure item contains multiple revenue and expenditure item mappings, that is, as long as one meets the mapping rules, the cash flow statistics basis can be divided into specific revenue and expenditure items.

[0061] Specifically, the revenue and expenditure item mapping is used to define the mapping relationship between the revenue and expenditure items and the cash flow statistics basis; the attributes of the revenue and expenditure item mapping include the revenue and expenditure item mapping identifier, the affiliated revenue and expenditure item, several mapping fields and their corresponding mapping relationships and mapping values. The specific description of the revenue and expenditure item mapping is shown in Table 4:

[0062] Table 4 Structural description of revenue and expenditure item mapping

[0063]

[0064]

[0065] In this embodiment, the matching rule generation engine is used to generate matching rules based on revenue and expenditure items, revenue and expenditure item mappings, and the relationships between revenue and expenditure item mappings and matching relationships for subsequent matching.

[0066] The "matching rule generation engine" includes an operation "generate" and the specific description is shown in Table 5:

[0067] Table 5 Generation operation

[0068]

[0069] In this embodiment, the relationship between the revenue and expenditure item mapping field and the matching field is a prefabricated data, which is used to record which field of the statistical basis is matched when the revenue and expenditure item matches the cash flow statistics basis. For the same mapping field, when the mapping symbols are different, the corresponding statistical basis fields may be different.

[0070] Specifically, the relationship between the revenue and expenditure item mapping field and the matching field includes the following attributes: the relationship identifier between the revenue and expenditure item mapping field and the matching field, the mapping symbol, the mapping field, and the corresponding field of the statistical basis. The specific description is shown in Table 6:

[0071] Table 6 Relationship between revenue and expenditure item mapping field and matching field

[0072]

[0073] S103. Invoke the matching engine and execute the matching operation to match the revenue and expenditure items of the preset fund organization with the cash flow statistics basic data based on the matching rules under the preset fund organization, and generate matching records.

[0074] In step S103, the matching engine is used to match the revenue and expenditure items with the cash flow statistics basis and generate matching records. The matching engine includes an operation "match", and the specific description is shown in Table 7:

[0075] Table 7 Matching operation

[0076]

[0077] In step S103, the matching rules are used to record the specific matching rules, that is, the rules for matching the revenue and expenditure items with the cash flow statistics basis, that is, how the specific cash flow statistics basis is divided into specific revenue and expenditure items.

[0078] Specifically, the attributes of the matching rules include the matching rule identifier, the fund organization, the revenue and expenditure item identifier, the revenue and expenditure item mapping identifier, and the matching rule name. The detailed description of the matching rules is shown in Table 8:

[0079] Table 8 Matching Rules

[0080]

[0081]

[0082] In this embodiment, the matching record is used for the cash flow statistics basis to match with that revenue and expenditure item, and it is matched according to the mapping rule of that revenue and expenditure item, serving as the basis for subsequent statistics.

[0083] Among them, the attributes of the matching record include the matching record identifier, the fund organization, the revenue and expenditure item identifier, the cash flow statistics basis identifier, the revenue and expenditure item mapping identifier, and the matching rule identifier. The specific structure of the matching record is shown in Table 9 as follows:

[0084] Table 9 Matching Record

[0085] Attribute Name Meaning Identifier Uniquely identify a matching record Fund Organization That is, which fund organization does this matching record belong to Revenue and Expense Item Identifier If it meets this matching record, it will be matched to that revenue and expense item Revenue and Expense Item Mapping Identifier This matching record is translated and matched from that revenue and expense item mapping Cash Flow Statistical Basis Identifier Which cash flow statistical basis is matched Matching Rule Identifier Which matching rule is used for matching

[0086] S104, call the statistical engine and execute the statistical operation, and statistically analyze the matching records according to the business dimension to generate a revenue and expenditure item cash flow statistical table in the management dimension.

[0087] In step S104, the statistical engine is used to statistically analyze the matching records according to the business dimension and generate a statistical result. The statistical engine includes an operation "statistics", and the specific description is shown in Table 10:

[0088] Table 10 Statistical Operation

[0089]

[0090] In step S104, the revenue and expenditure item cash flow statistical table is used to record the statistical result of the cash flow according to the management dimension, and it is a data specification of the statistical result.

[0091] Specifically, the revenue and expenditure item cash flow statistical table includes the following attributes: the revenue and expenditure item cash flow statistical table identifier, the revenue and expenditure item identifier, the revenue and expenditure item number, the revenue and expenditure item name, the fund organization, the business category, the payment method, the revenue and expenditure type, the business activity type, the transaction date, the number of days in the day, the number of days in the month, and the number of days in the same month of the previous year. The specific description of the revenue and expenditure item cash flow statistical table is shown in Table 11:

[0092] Table 11 Description of the Revenue and Expenditure Item Cash Flow Statistical Table

[0093]

[0094] Combined with Figure 2 , the specific implementation process of the cash flow analysis method based on the revenue and expenditure item mapping provided by the embodiment of the present invention is given:

[0095] First, prefabricate the relationship between the revenue and expenditure item mapping fields and the matching fields, revenue and expenditure items, revenue and expenditure item mapping, extraction engine, matching rule generation engine, matching engine, and statistical engine.

[0096] Specifically, the relationship between the prefabricated revenue and expenditure item mapping fields and the matching fields is shown in Table 12, which is used to record which field of the statistical basis is matched when the revenue and expenditure items are matched with the cash flow statistical basis. For the same mapping field, when the mapping symbols are different, the corresponding statistical basis fields may be different.

[0097] Table 12 Relationship between Prefabricated Revenue and Expenditure Item Mapping Fields and Matching Fields

[0098] Identifier Mapping Symbol [[ID= ​ 0001 ​ ​ ​ 0002 ​ ​ ​ 0003 ​ ​ ​ ... ... ... ...

[0099] This table is used to record which field of the statistical basis is matched when the revenue and expenditure items are matched with the cash flow statistical basis. For the same mapping field, when the mapping symbols are different, the corresponding statistical basis fields may be different; for example, for the mapping field "major business category", when the mapping symbol is "equal to", it matches the "major business category" (BusinessCategory) field of the "cash flow statistical basis", while when the mapping symbol is "contains", it matches the "major business category name" (BusinessCategory_Name) field of the "cash flow statistical basis";

[0100] As shown in Table 13 are the prefabricated revenue and expenditure items, that is, the business division of the cash flow statistical management dimension. That is, the trap circulation statistics are carried out based on these management dimensions, and the statistical results will also be statistically counted based on these management divisions; it is divided into global revenue and expenditure items and revenue and expenditure items of specific funding organizations. The specific revenue and expenditure items need to be introduced from the global revenue and expenditure items. If a specific funding organization does not define its specific revenue and expenditure items, the global revenue and expenditure items will be used for business statistics; the revenue and expenditure items are hierarchical, and the statistical data of the lower-level revenue and expenditure items need to be summarized to the upper-level revenue and expenditure items.

[0101] Table 13 Prefabricated Revenue and Expenditure Items

[0102]

[0103]

[0104] The prefabricated revenue and expenditure item mapping is shown in Table 14:

[0105] Table 14 Prefabricated Revenue and Expenditure Item Mapping

[0106]

[0107] The prefabricated extraction engine, matching rule generation engine, matching engine, and statistical engine are shown in Table 15:

[0108] Table 15 Prefabricated Extraction Engine, Matching Rule Generation Engine, Matching Engine and Statistical Engine

[0109]

[0110] The cash flow analysis process based on revenue and expenditure item mapping provided by the embodiments of the present invention includes the following steps:

[0111] Step 1: After the user selects the fund organization, start date, and end date, call the "extract" operation of the "extraction engine" to pass the fund organization, start date, and end date. After this operation is completed, data related to cash flow such as bank statements, checks, and bills will be converted into the basis for cash flow statistics, that is, the basic data for cash flow statistics of a specific fund organization within a specific time range is obtained;

[0112] For example, after the user selects the fund organization (Company X), start date (20240101), and end date (20241031), and calls the "extract" operation of the "extraction engine (com.inspur.gs.ExtractionEngine)", the fund organization (Company X), start date (20240101), and end date (20241031) will be passed. After this operation is completed, data related to cash flow such as bank statements, checks, and bills will be converted into the basis for cash flow statistics, that is, the basic data for cash flow statistics of a specific fund organization within a specific time range is obtained, as shown in Table 16;

[0113] Table 16 Extracted Basic Data for Cash Flow Statistics

[0114]

[0115]

[0116] Step 2: Pass the "fund organization" parameter to the "get" operation of the "revenue and expenditure items". Through this operation system, a list of combinations of revenue and expenditure items and their mappings will be obtained. Then, pass the prefabricated data of the "relationship between revenue and expenditure item mapping fields and matching fields" and the above data to the "generate" operation of the "matching rule generation engine" to obtain the matching rules under a specific fund organization.

[0117] For example, the parameter of "fund organization (Company X)" is passed to the "get" operation of the "revenue and expenditure items". Through this operation, a list of combinations of revenue and expenditure items and their mappings will be obtained, as shown in Table 16. However, since the revenue and expenditure items of a specific organization are not prefabricated and configured, the global-level revenue and expenditure items and their mappings are obtained.

[0118] Table 16 List of Combinations of Obtained Revenue and Expenditure Items and Their Mappings

[0119] ​ ​ ​ ​ ​ ​ 01 ​ ​ ​ ​ 0101 ​ ​ 01 ​ ​ 010101 ​ ​ 0101 ​ ​ 010102 ​ ​ 0101 ​ ​ ... 0102 ​ ​ 01 ​ ​ 010201 ​ ​ 0102 ​ ​ ... ​ ... ​

[0120] The mapped income and expenditure items returned are shown in Table 17:

[0121] Table 17 Mapped Income and Expenditure Items Returned

[0122]

[0123]

[0124] The prefabricated data of the relationship between the mapped fields of income and expenditure items and the matching fields are shown in Table 18:

[0125] Table 18 Prefabricated Data of the Relationship between the Mapped Fields of Income and Expenditure Items and the Matching Fields

[0126] ​ ​ ​ ​ 0001 ​ ​ ​ 0002 ​ ​ ​ 0003 ​ ​ ​ ... ... ... ...

[0127] The above data is passed to the "generate" operation of the "Rule Matching Generation Engine (com.inspur.gs.RuleMatchingGenerationEngine)", and the matching rules under the specific fund organization obtained are shown in Table 19:

[0128] Table 19 Matching Rules of Fund Organizations

[0129]

[0130] Step 3: Pass the above matching rules and the cash flow statistics basis obtained in the previous steps to the "match" operation of the "matching engine", and the matching records of the income and expenditure items and the cash flow statistics basis will be obtained, which are the basis for subsequent statistics. The obtained matching records are shown in Table 20:

[0131] Table 20 Matching Records Obtained from the Matching Operation

[0132]

[0133]

[0134] Step 4: Pass the above matching records, income and expenditure items, and mapped income and expenditure items to the "statistics" operation of the "statistics engine", and the cash flow statistics table of income and expenditure items will be obtained, that is, the cash flow statistics table of income and expenditure items required for the management dimension is obtained, as shown in Table 21:

[0135] Table 21 Cash Flow Statistics Table of Income and Expenditure Items Required for the Management Dimension

[0136] ​ ​ ​ ​ 1 2 ​ 010101 010101 ​ 010101 010101 ​ ​ ​ ​ ​ ... ​ 0011005 ​ ... ... ​ ​ ​ ​ ​ ​ ​ 20240101 20240102 ​ 1600 1200 ​ 1600 2800 ​ ... ...

[0137] Among them, the daily figure 1600 on January 1, 2024 = statistical basis 100 (identifier 1) + 300 (identifier 3) + 500 (identifier 5, matching rule 1002, but belonging to revenue and expenditure item 010101) + 700 (identifier 7); the daily figure 1200 on January 2, 2024 = 200 (statistical basis identifier 2) + 400 (statistical basis identifier 4) + 600 (statistical basis identifier 6); the cumulative figure 2800 for the month of January 2, 2024 = 1600 (daily figure on January 1, 2024) + 1200 (daily figure on January 2, 2024).

[0138] The cash flow analysis method of the present invention solves the problem of detailed analysis of specific operations and projects, and provides timely and accurate information for management, helping to avoid decision-making mistakes caused by information lag.

[0139] As ​ shown, the cash flow analysis device based on revenue and expenditure item mapping provided by the embodiment of the present invention can be implemented in software. The cash flow analysis device 300 based on revenue and expenditure item mapping includes the following software modules: basic data extraction module 301, matching rule generation module 302, matching record generation module 303, and matching record statistics module 304.

[0140] The functions of each software module in the cash flow analysis device 300 based on revenue and expenditure item mapping are introduced below:

[0141] The basic data extraction module 301 is used to call the extraction engine and execute the extraction operation to extract the cash flow statistical basic data within a set time range from the cash flow related data of the preset fund organization;

[0142] The matching rule generation module 302 is used to obtain all revenue and expenditure items and revenue and expenditure item mappings under the preset fund organization, and then call the matching rule generation engine and execute the generation operation to generate the matching rules under the preset fund organization based on the revenue and expenditure items, revenue and expenditure item mappings, and the relationship between revenue and expenditure item mapping fields and matching fields;

[0143] The matching record generation module 303 is used to call the matching engine and execute the matching operation to match the revenue and expenditure items with the cash flow statistical basic data based on the matching rules under the preset fund organization to generate matching records;

[0144] The matching record statistics module 304 is used to call the statistics engine and execute the statistics operation to statistically analyze the matching records according to the business dimension to generate the revenue and expenditure item cash flow statistical table in the management dimension.

[0145] It should be noted here that ​ each module in the cash flow analysis device based on revenue and expenditure item mapping, and​ Each step in the cash flow analysis method based on revenue and expenditure item mapping in [reference] corresponds one by one, and their specific implementation processes are the same, which will not be elaborated here.

[0146] The structure of the electronic device according to the embodiment of the present invention will be described in detail below. ​ FIG. [figure number] is a schematic diagram of the composition structure of the electronic device provided by the embodiment of the present invention. It can be understood that ​ only the exemplary structure of the electronic device is shown, rather than all structures. According to needs, some or all of the shown structures can be implemented.

[0147] The electronic device provided by the embodiment of the present invention includes: at least one processor 401, a memory 402, a user interface 403, and at least one network interface 404. Each component in the cash flow analysis device based on revenue and expenditure item mapping is coupled together through a bus system 405. It can be understood that the bus system 405 is used to implement connection and communication between these components. In addition to the data bus, the bus system 405 also includes a power bus, a control bus, and a status signal bus. However, for the sake of clarity, in ​ all kinds of buses are labeled as the bus system 405.

[0148] Among them, the user interface 403 may include a display, a keyboard, a mouse, a trackball, a click wheel, a button, a touchpad, or a touch screen, etc.

[0149] It can be understood that the memory 402 may be a volatile memory or a non-volatile memory, or may include both volatile and non-volatile memories. The memory 402 in the embodiment of the present invention can store data to support the operation of the terminal. Examples of these data include: any computer program for operating on the terminal, such as an operating system and an application program. Among them, the operating system includes various system programs, such as a framework layer, a core library layer, a driver layer, etc., for implementing various basic services and processing hardware-based tasks. The application program may include various application programs.

[0150] It should be noted that the content in [reference] and [figure number] in the above translation needs to be filled in according to the actual situation in the original text.In some embodiments, the cash flow analysis device 300 based on revenue and expenditure item mapping provided by the embodiments of the present invention can be implemented in a combination of software and hardware. As an example, the cash flow analysis device 300 based on revenue and expenditure item mapping provided by the embodiments of the present invention can be a processor in the form of a hardware decoding processor, which is programmed to execute the cash flow analysis method based on revenue and expenditure item mapping provided by the embodiments of the present invention. For example, a processor in the form of a hardware decoding processor can employ one or more application specific integrated circuits (ASICs), DSPs, programmable logic devices (PLDs), complex programmable logic devices (CPLDs), field-programmable gate arrays (FPGAs), or other electronic components.

[0151] As an example, the processor 401 can be an integrated circuit chip with signal processing capabilities, such as a general-purpose processor, a digital signal processor (DSP), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. Among them, the general-purpose processor can be a microprocessor or any conventional processor, etc.

[0152] As an example of the cash flow analysis device 300 based on revenue and expenditure item mapping provided by the embodiments of the present invention being implemented in hardware, the device provided by the embodiments of the present invention can be directly executed and completed by a processor 401 in the form of a hardware decoding processor. For example, it can be executed and implemented by one or more application specific integrated circuits (ASICs), DSPs, programmable logic devices (PLDs), complex programmable logic devices (CPLDs), field-programmable gate arrays (FPGAs), or other electronic components to implement the cash flow analysis method based on revenue and expenditure item mapping provided by the embodiments of the present invention.

[0153] The memory 402 in the embodiments of the present invention is used to store various types of data to support the operation of the cash flow analysis device 300 based on revenue and expenditure item mapping, or to store data for execution ​The program code of the method shown. Examples of such data include: any executable instructions for operating on a cash flow analysis device based on item mapping of receipts and payments, such as executable instructions. The program for implementing the embodiments of the present invention from the cash flow analysis method based on item mapping of receipts and payments may be included in the executable instructions.

[0154] In particular, according to an embodiment of the present application, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present application includes a computer program product that includes a computer program carried on a computer-readable medium, the computer program including instructions for performing ​ the program code of the method shown. In such an embodiment, the computer program can be downloaded and installed from a network through a communication part and / or installed from a removable medium. When the computer program is executed by a central processing unit, various functions defined in the device of the present application are performed.

[0155] Wherein, ​ The computer program instructions corresponding to the method shown can also be stored in a computer-readable memory that can direct a computer or other programmable data processing device to work in a specific manner, such that the instructions stored in the computer-readable memory produce a manufactured article including an instruction device that implements the functions specified in ​ one process or multiple processes and / or ​ one block or multiple blocks.

[0156] The above is only the preferred embodiment of the present invention and is not intended to limit the present invention. For those skilled in the art, the present invention can have various changes and modifications. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A cash flow analysis method based on mapping of revenue and expenditure items, characterized in that including: Invoking an extraction engine and performing an extraction operation to extract basic cash flow statistical data within a set time range from the cash flow related data of a preset funding organization; Obtaining all revenue and expenditure items and their mappings under a preset funding organization, then invoking a matching rule generation engine and performing a generation operation to generate matching rules under the preset funding organization based on the revenue and expenditure items, the revenue and expenditure item mappings, and the relationship between the revenue and expenditure item mapping fields and the matching fields; Invoking a matching engine and performing a matching operation to match the revenue and expenditure items of a preset funding organization with the basic cash flow statistical data based on the matching rules under the preset funding organization, and generating matching records; Invoking a statistical engine and performing a statistical operation to statistically analyze the matching records by business dimension, and generating a revenue and expenditure item cash flow statistical table in the management dimension.

2. The cash flow analysis method based on revenue and expenditure item mapping according to claim 1, wherein The attributes of the basic cash flow statistical data include basic cash flow statistical data identifier, funding organization, own account, transaction date, transaction amount, payment method, business category, business category name, postscript, counterparty unit, counterparty account, receipt and payment status, source type, and business activity type; Or / and the attributes of the revenue and expenditure items include revenue and expenditure item identifier, revenue and expenditure item number, revenue and expenditure item name, funding organization, superior revenue and expenditure item, level, and business activity type.

3. The cash flow analysis method based on revenue and expenditure item mapping according to claim 1, characterized in that The revenue and expenditure item mapping is used to define the mapping relationship for matching revenue and expenditure items with the basic cash flow statistics; the attributes of the revenue and expenditure item mapping include revenue and expenditure item mapping identifier, the revenue and expenditure item to which it belongs, several mapping fields and their corresponding mapping relationships and mapping values; Or / and the attributes of the matching rules include matching rule identifier, funding organization, revenue and expenditure item identifier, revenue and expenditure item mapping identifier, and matching rule name.

4. The cash flow analysis method based on revenue and expenditure item mapping according to claim 1, characterized in that The attributes of the matching records include matching record identifier, funding organization, revenue and expenditure item identifier, basic cash flow statistical identifier, revenue and expenditure item mapping identifier, and matching rule identifier.

5. The cash flow analysis method based on revenue and expenditure item mapping according to claim 1, wherein The relationship between the revenue and expenditure item mapping fields and the matching fields includes the following attributes: relationship identifier between the revenue and expenditure item mapping fields and the matching fields, mapping symbol, mapping field, and corresponding field in the statistical basis.

6. The cash flow analysis method based on mapping of income and expenditure items according to claim 1, characterized in that The revenue and expenditure item cash flow statistical table includes the following attributes: revenue and expenditure item cash flow statistical table identifier, revenue and expenditure item identifier, revenue and expenditure item number, revenue and expenditure item name, funding organization, business category, payment method, revenue and expenditure type, business activity type, transaction date, number of days in the day, number of days in the month, and number of days in the same month of the previous year.

7. A cash flow analysis device based on mapping of income and expenditure items, characterized in that including: A basic data extraction module, which is used to invoke an extraction engine and perform an extraction operation to extract basic cash flow statistical data within a set time range from the cash flow related data of a preset funding organization; A matching rule generation module, which is used to obtain all revenue and expenditure items and their mappings under a preset funding organization, then invoke a matching rule generation engine and perform a generation operation to generate matching rules under the preset funding organization based on the revenue and expenditure items, the revenue and expenditure item mappings, and the relationship between the revenue and expenditure item mapping fields and the matching fields; A matching record generation module, which is used to invoke a matching engine and perform a matching operation to match the revenue and expenditure items with the basic cash flow statistical data based on the matching rules under the preset funding organization, and generate matching records; A matching record statistics module, which is used to call a statistics engine and perform statistical operations, statistically analyze the matching records according to business dimensions, and generate a cash flow statement of revenue and expenditure items in the management dimension.

8. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the program is executed by a processor, it implements the steps in the cash flow analysis method based on revenue and expenditure item mapping as described in any one of claims 1-6.

9. A computer program product, comprising a computer program / instructions, characterized in that, When the computer program / instructions are executed by a processor, it implements the steps in the cash flow analysis method based on revenue and expenditure item mapping as described in any one of claims 1-6.

10. An electronic device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that, When the processor executes the program, it implements the steps in the cash flow analysis method based on revenue and expenditure item mapping as described in any one of claims 1-6.

Images