A cash flow analysis method and device based on income and expenditure item mapping

Abstract

The present application belongs to the field of income and expenditure data processing, and provides a cash flow analysis method and device based on income and expenditure item mapping. The method comprises the following steps: calling an extraction engine and performing an extraction operation to extract cash flow statistical basis 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 mappings under the preset fund organization, then calling a matching rule generation engine and performing a generation operation to generate matching rules under the preset fund organization based on the income and expenditure items, the income and expenditure item mappings, and the relationship between the income and expenditure item mapping fields and the matching fields; calling a matching engine and performing a matching operation to match the income and expenditure items with the cash flow statistical basis data based on the matching rules under the preset fund organization, and generate matching records; calling a statistical engine and performing a statistical operation to statistically analyze the matching records according to business dimensions, and generate an income and expenditure item cash flow statistical table in a management dimension, which can provide timely and accurate information for management.

Description

Technical Field

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

[0002] The statements in this section are merely background information related to the present invention and do not necessarily constitute prior art.

[0003] Currently, cash flow statements obtained from financial analysis have certain timeliness issues. While they clearly show a company's cash inflows and outflows over a specific period, they are insufficient for in-depth analysis of the profitability and capital utilization efficiency of various business activities, and cannot comprehensively reflect the company's true financial situation. Furthermore, current cash flow statements typically only provide aggregate data, lacking detailed analysis of specific businesses and projects, resulting in limitations in information transparency. Moreover, existing cash flow statements are relatively coarse in their statistical dimensions; managers may need to analyze cash flows according to payment methods (such as check payments, bill payments, and bank-enterprise payments) or business categories. Although information on payment methods can be obtained from bank statements, it is difficult to directly derive information from existing bank statement data based on the company's specific business categories.

[0004] In conclusion, existing cash flow statement analysis techniques cannot generate personalized cash flow statements based on the characteristics of a company's business, which may lead to management decision-making errors due to the lag in cash flow information. Summary of the Invention

[0005] To address the aforementioned technical problems, this invention provides a cash flow analysis method and apparatus based on the mapping of revenue and expenditure items. By establishing revenue and expenditure items based on business dimensions and mapping these items to cash flow data such as bank statements, a connection is established between business dimensions and the business classification of cash flow data such as bank statements. This enables the generation of cash flow statements that conform to the characteristics of the enterprise's business at any time, providing timely and accurate information for management and helping to avoid decision-making errors caused by information lag.

[0006] To achieve the above objectives, the present invention adopts the following technical solution:

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

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

[0009] Call the extraction engine and perform the extraction operation to extract basic cash flow statistics data within a set time range from the cash flow-related data of the preset funding organization;

[0010] Get all income and expenditure items and income and expenditure item mappings under the preset fund organization, then call the matching rule generation engine and perform the generation operation. Based on the income and expenditure items, income and expenditure item mappings and the relationship between income and expenditure item mapping fields and matching fields, generate matching rules under the preset fund organization.

[0011] Call the matching engine and perform matching operations. Based on the matching rules under the preset financial organization, match the income and expenditure items and cash flow statistics of the preset financial organization to generate matching records.

[0012] Call the statistics engine and perform statistical operations to perform statistics on the matched records according to the business dimension, and generate a cash flow statistics table for income and expenditure items in the management dimension.

[0013] As one implementation method, the attributes of the cash flow statistics basic data include cash flow statistics basic data identifier, fund organization, local account, transaction date, transaction amount, payment method, business category, business category name, remarks, counterparty unit, counterparty account, payment status, source type, and business activity type.

[0014] In one implementation, 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.

[0015] In one implementation, the revenue and expenditure item mapping is used to define the mapping relationship between revenue and expenditure items and the cash flow statistics basis; the attributes of the revenue and expenditure item mapping include revenue and expenditure item mapping identifier, belonging revenue and expenditure item, several mapping fields and their corresponding mapping relationship and mapping value.

[0016] As one implementation, the attributes of the matching rule include a matching rule identifier, a fund organization, an income and expenditure item identifier, an income and expenditure item mapping identifier, and a matching rule name.

[0017] In one implementation, the attributes of the matching record include a matching record identifier, a fund organization, an income and expenditure item identifier, a cash flow statistics basis identifier, an income and expenditure item mapping identifier, and a matching rule identifier.

[0018] As one implementation method, the relationship between the income and expenditure item mapping field and the matching field includes the following attributes: the relationship identifier between the income and expenditure item mapping field and the matching field, the mapping symbol, the mapping field, and the corresponding field of the statistical basis.

[0019] As one implementation method, the cash flow statistics table for revenue and expenditure items includes the following attributes: cash flow statistics table identifier for revenue and expenditure items, revenue and expenditure item identifier, revenue and expenditure item number, revenue and expenditure item name, fund organization, business category, payment method, revenue and expenditure type, business activity type, transaction date, number of transactions on the same day, number of transactions in the current month, and number of transactions in the previous year and the current month.

[0020] A second aspect of the present invention provides a cash flow analysis apparatus based on the mapping of income and expenditure items.

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

[0022] The basic data extraction module is used to call the extraction engine and perform extraction operations to extract basic cash flow statistics data within a set time range from the cash flow-related data of the preset financial organization.

[0023] The matching rule generation module is used to obtain all income and expenditure items and income and expenditure item mappings under the preset fund organization, and then call the matching rule generation engine to perform the generation operation. Based on the income and expenditure items, income and expenditure item mappings, and the relationship between income and expenditure item mapping fields and matching fields, it generates matching rules under the preset fund organization.

[0024] The matching record generation module is used to call the matching engine and perform matching operations. It matches income and expenditure items with basic cash flow statistics data based on the matching rules under the preset fund organization to generate matching records.

[0025] The matching record statistics module is used to call the statistics engine and perform statistical operations, statistically analyze the matching records according to business dimensions, and generate a cash flow statistics table for income and expenditure items in the management dimension.

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

[0027] A computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps in the cash flow analysis method based on the mapping of income and expenditure items as described above.

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

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

[0030] A 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, wherein the processor, when executing the program, implements the steps in the cash flow analysis method based on income and expenditure item mapping as described above.

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

[0033] This invention generates a cash flow statistics table for income and expenditure items required for management by sequentially calling an extraction engine, a matching rule generation engine, a matching engine, and a statistics engine. This cash flow statistics table constructs income and expenditure items in both business and management dimensions and achieves precise mapping with cash flow data such as bank statements, establishing a dynamic, business-driven cash flow analysis system. It can generate cash flow reports that reflect the specific business characteristics of an enterprise in real time, providing management with detailed and timely financial information, significantly improving the accuracy and timeliness of decision-making, and effectively avoiding decision-making risks caused by information delays. Attached Figure Description

[0034] The accompanying drawings, which form part of this invention, are used to provide a further understanding of the invention. The illustrative embodiments of the invention and their descriptions are used to explain the invention and do not constitute an improper limitation of the invention.

[0035] Figure 1 This is a flowchart illustrating the cash flow analysis method based on income and expenditure item mapping according to an embodiment of the present invention.

[0036] Figure 2 This is a schematic diagram of the cash flow analysis process based on the mapping of income and expenditure items in an embodiment of the present invention;

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

[0038] Figure 4 This is a schematic diagram of an electronic device according to an embodiment of the present invention. Detailed Implementation

[0039] The present invention will be further described below with reference to the accompanying drawings and embodiments.

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

[0041] It should be noted that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit the scope of exemplary embodiments according to the invention. As used herein, the singular form is intended to include the plural form as well, unless the context clearly indicates otherwise. Furthermore, it should be understood that when the terms "comprising" and / or "including" are used in this specification, they indicate the presence of features, steps, operations, devices, components, and / or combinations thereof.

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

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

[0044] In step S101, the extraction engine is used to transform cash flow-related data such as bank statements, checks, and bills into a cash flow statistical basis. It includes an operation called "extraction," which is described in detail in Table 1.

[0045] Table 1 Extraction Operations

[0046]

[0047] In this embodiment, the basic data for cash flow statistics is used as the basic data standard for management-based cash flow statistics. It is the basis for subsequent cash flow statistics and has multiple sources, such as bank statements, checks, bills, and other data sources related to cash flow. After being extracted by the extraction engine, the multiple data sources are transformed into a unified data format, which is the basic data for cash flow statistics.

[0048] Specifically, the attributes of the basic data for cash flow statistics include the basic data identifier for cash flow statistics, fund organization, local account, transaction date, transaction amount, payment method, business category, business category name, remarks, counterparty, counterparty account, payment / receipt status, source type, and business activity type.

[0049] For example, the detailed structure of the basic data for cash flow statistics is shown in Table 2:

[0050] Table 2. Structural Description of Basic Data for Cash Flow Statistics

[0051]

[0052]

[0053] S102, obtain all income and expenditure items and income and expenditure item mappings under the preset fund organization, then call the matching rule generation engine and perform the generation operation, and generate matching rules under the preset fund organization based on income and expenditure items, income and expenditure item mappings and the relationship between income and expenditure item mapping fields and matching fields.

[0054] In step S102, the operation "Get" is used to obtain the income and expenditure items and combinations of income and expenditure item mappings for a specific organization. The operation "Get" includes one input parameter, namely the funding organization; the returned data is a list of income and expenditure items and combinations of income and expenditure item mappings.

[0055] In step S102, the revenue and expenditure items, that is, the business division of cash flow statistics management dimensions, are used to perform trap flow statistics based on these management dimensions, and the statistical results will also be statistically analyzed based on these management divisions. They are divided into global revenue and expenditure items and revenue and expenditure items of specific financial organizations. Specific revenue and expenditure items need to be introduced from global revenue and expenditure items. If a specific financial organization has not defined its specific revenue and expenditure items, then global revenue and expenditure items are used for business statistics. Revenue and expenditure items are hierarchical, and the statistical data of lower-level revenue and expenditure items need to be summarized into higher-level revenue and expenditure items.

[0056] Specifically, the attributes of 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. A detailed description of revenue and expenditure items is shown in Table 3:

[0057] Table 3. Structural Description of Revenue and Expenditure Items

[0058]

[0059]

[0060] Income and expenditure item mapping is used to define how income and expenditure items are matched with cash flow accounting bases so that a specific cash flow accounting base is assigned to a specific income and expenditure item. An income and expenditure item contains multiple income and expenditure item mappings, which means that meeting one of the mapping rules is sufficient to assign the cash flow accounting base to a specific income and expenditure item.

[0061] Specifically, the revenue and expenditure item mapping is used to define the mapping relationship between 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 revenue and expenditure item to which it belongs, several mapping fields and their corresponding mapping relationships and mapping values. A detailed 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 income and expenditure items, income and expenditure item mappings, income and expenditure item mappings and matching relationships, so as to perform subsequent matching.

[0066] The "Matching Rule Generation Engine" includes an operation called "Generate," the details of which are shown in Table 5.

[0067] Table 5 Generation Operation

[0068]

[0069] In this embodiment, the relationship between the income and expenditure item mapping field and the matching field is a pre-built data used to record which field of the statistical basis is matched when the income and expenditure item is matched with the cash flow statistical basis. The same mapping field may correspond to different statistical basis fields when the mapping symbol is different.

[0070] Specifically, the relationship between the mapping fields and matching fields for income and expenditure items includes the following attributes: the identifier of the relationship between the mapping fields and matching fields, the mapping symbol, the mapping field, and the corresponding field in the statistical basis. A detailed description is shown in Table 6.

[0071] Table 6 Relationship between Mapping Fields and Matching Fields for Income and Expenditure Items

[0072]

[0073] S103, call the matching engine and perform the matching operation. Based on the matching rules under the preset fund organization, match the income and expenditure items and cash flow statistics of the preset fund organization to generate matching records.

[0074] In step S103, the matching engine matches income and expenditure items with the cash flow statistics basis and generates matching records. The matching engine includes an operation called "match," as detailed in Table 7:

[0075] Table 7 Matching Operations

[0076]

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

[0078] Specifically, the attributes of a matching rule include the matching rule identifier, funding organization, income / expenditure item identifier, income / expenditure item mapping identifier, and matching rule name. A 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 as the basis for cash flow statistics and is matched with the income and expenditure item according to the mapping rules of that income and expenditure item, serving as the basis for subsequent statistics.

[0083] The attributes of a matched record include the matched record identifier, funding organization, income and expenditure item identifier, cash flow statistics basis identifier, income and expenditure item mapping identifier, and matching rule identifier. The specific structure of a matched record is shown in Table 9.

[0084] Table 9 Matching Records

[0085] logo A matching record is uniquely identified. Funding organization That is, the matching record belongs to which funding organization? Income and expenditure item identification If a record matches, it will be matched to that income / expense item. Income and expenditure item mapping identifier This matching record was generated by the income and expenditure item mapping translation. Basic identifiers for cash flow statistics It matches that cash flow statistics basis. Matching rule identifier Which matching rule was used?

[0086] S104, call the statistics engine and perform statistical operations to perform statistics on the matched records according to the business dimension, and generate a cash flow statistics table for income and expenditure items in the management dimension.

[0087] In step S104, the statistics engine is used to perform statistics on the matched records according to business dimensions and generate statistical results. The statistics engine includes an operation called "Statistics," which is described in detail in Table 10:

[0088] Table 10 Statistical Operations

[0089]

[0090] In step S104, the cash flow statistics table for income and expenditure items is used to record the statistical results of cash flow according to management dimensions, and is a data standard for statistical results.

[0091] Specifically, the cash flow statement for revenue and expenditure items includes the following attributes: cash flow statement 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 transactions on the current day, number of transactions in the current month, and number of transactions in the previous year and the current month. A detailed description of the cash flow statement for revenue and expenditure items is shown in Table 11.

[0092] Table 11 Cash Flow Statistics for Income and Expenditure Items

[0093]

[0094] Combination Figure 2 The present invention provides a specific implementation process for the cash flow analysis method based on the mapping of revenue and expenditure items provided in the embodiments of the present invention:

[0095] First, pre-define the relationship between the mapping fields and matching fields of income and expenditure items, income and expenditure items, income and expenditure item mapping, extraction engine, matching rule generation engine, matching engine, and statistics engine.

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

[0097] Table 12 shows the relationship between the pre-built revenue and expenditure item mapping fields and the matching fields.

[0098] 0001 equal Business Categories BusinessCategory 0002 Include Business Categories BusinessCategory_Name 0003 Include Bank Remarks BankMemo ... ... ... ...

[0099] This table records which field of the cash flow statistics basis is matched when an income or expenditure item is matched. The same mapping field may correspond to different statistical basis fields when the mapping symbol is different. For example, for the mapping field "Business Category", when the mapping symbol is "equal to", it matches the "Business Category" field of "Cash Flow Statistics Basis", while when the mapping symbol is "contains", it matches the "Business Category Name" field of "Cash Flow Statistics Basis".

[0100] Table 13 shows the pre-defined revenue and expenditure items, which are business divisions for cash flow statistics management. These management dimensions are used for trap flow statistics, and the statistical results will also be based on these management divisions. The revenue and expenditure items are divided into global revenue and expenditure items and revenue and expenditure items of specific financial organizations. Specific revenue and expenditure items need to be introduced from global revenue and expenditure items. If a specific financial organization has not defined its specific revenue and expenditure items, then global revenue and expenditure items are used for business statistics. Revenue and expenditure items are hierarchical, and the statistical data of lower-level revenue and expenditure items need to be summarized into higher-level revenue and expenditure items.

[0101] Table 13 Pre-prepared income and expenditure items

[0102]

[0103]

[0104] The mapping of pre-constructed revenue and expenditure items is shown in Table 14:

[0105] Table 14 Pre-made Revenue and Expenditure Item Mapping

[0106]

[0107] The pre-built extraction engine, matching rule generation engine, matching engine, and statistics engine are shown in Table 15:

[0108] Table 15 Pre-built extraction engine, matching rule generation engine, matching engine, and statistics engine

[0109]

[0110] The cash flow analysis process based on the mapping of income and expenditure items provided in this embodiment of the invention includes the following steps:

[0111] Step 1: When the user selects the fund organization, from date, and to date, the "Extraction Engine" is invoked to extract the fund organization and from date. This operation converts cash flow-related data such as bank statements, checks, and bills into cash flow statistical data, thus obtaining the cash flow statistical data of a specific fund organization within a specific time range.

[0112] For example, when a user selects the funding organization (Company X), from date (20240101) to date (20241031), and calls the "extract" operation of the "extraction engine (com.inspur.gs.ExtractionEngine)," the funding organization (Company X), from date 20240101 to date (20241031) will be passed. This operation will convert data related to cash flow, such as bank statements, checks, and bills, into the basis for cash flow statistics, thus obtaining the basic data for cash flow statistics of a specific funding organization within a specific time range, as shown in Table 16.

[0113] Table 16 shows the basic data extracted for cash flow statistics.

[0114]

[0115]

[0116] Step 2: Pass the "Funds Organization" parameter to the "Get" operation of "Income and Expenditure Items". The operating system will obtain a list of combinations of income and expenditure items and their mappings. Then, the pre-made data of "Relationship between Income and Expenditure Item Mapping Fields and Matching Fields" and the above data are passed to the "Generate" operation of the "Matching Rule Generation Engine" to obtain the matching rules under the specific funds organization.

[0117] For example, the "Funds Organization (Company X)" parameter is passed to the "Get" operation of "Income and Expenditure Items". This operation will obtain a list of combinations of income and expenditure items and their mappings, as shown in Table 16. However, since income and expenditure items for a specific organization are not pre-configured, global income and expenditure items and their mappings are obtained.

[0118] Table 16 lists the combinations of income and expenditure items and their mappings.

[0119] 01 Business activities GLOBAL Business activities other 0101 Revenue-related operating activities GLOBAL 01 Business activities income 010101 Bank and corporate revenue GLOBAL 0101 Business activities income 010102 Accounts Receivable Notes GLOBAL 0101 Business activities income ... 0102 Operating activities related to expenditures GLOBAL 01 Business activities expenditure 010201 Bank-enterprise payment GLOBAL 0102 Business activities expenditure ... Investment activities ... fundraising activities

[0120] The returned income and expenditure item mapping is shown in Table 17:

[0121] Table 17 returns the income and expenditure item mappings.

[0122]

[0123]

[0124] The pre-built data showing the relationship between the mapping fields and matching fields for income and expenditure items is shown in Table 18:

[0125] Table 18 Relationship between Mapping Fields and Matching Fields for Income and Expenditure Items (Pre-built Data)

[0126] 0001 equal Business Categories BusinessCategory 0002 Include Business Categories BusinessCategory_Name 0003 Include Bank Remarks BankMemo ... ... ... ...

[0127] The above data is passed to the "generate" operation of the "matching rule generation engine (com.inspur.gs.RuleMatchingGenerationEngine)" to obtain matching rules for specific funding organizations, as shown in Table 19:

[0128] Table 19 Matching Rules for Funding Organizations

[0129]

[0130] Step 3: Pass the above matching rules and the cash flow statistics basis obtained in the previous steps to the "Matching" operation of the "Matching Engine". This will generate matching records between income and expenditure items and the cash flow statistics basis, which will serve as the foundation for subsequent statistics. The resulting matching records are shown in Table 20:

[0131] Table 20 shows the matching records obtained from the matching operation.

[0132]

[0133]

[0134] Step 4: Pass the above matching records, income and expenditure items, and income and expenditure item mappings to the "Statistics" operation of the "Statistics Engine" to obtain the income and expenditure item cash flow statistics table, which is the income and expenditure item cash flow statistics table required for management purposes, as shown in Table 21:

[0135] Table 21: Cash Flow Statistics for Revenue and Expenditure Items Required for Management Dimensions

[0136] logo 1 2 Income and expenditure item identification 010101 010101 Revenue and expenditure item number 010101 010101 Name of income and expenditure items Bank and corporate revenue Bank and corporate revenue Funding organization Company X ... Business Categories 0011005 Payment methods ... ... Income and expenditure types income income Business activity types Business activities Business activities Transaction date 20240101 20240102 Data for the day 1600 1200 Monthly number 1600 2800 Last year's monthly figures ... ...

[0137] The daily count for January 1, 2024 is 1600 = Statistical Base 100 (Identifier 1) + 300 (Identifier 3) + 500 (Identifier 5, matches rule 1002, but belongs to the 010101 income and expenditure item) + 700 (Identifier 7); the daily count for January 2, 2024 is 1200 = 200 (Statistical Base Identifier 2) + 400 (Statistical Base Identifier 4) + 600 (Statistical Base Identifier 6); the monthly cumulative count for January 2, 2024 is 2800 = 1600 (the daily count for January 1, 2024) + 1200 (the daily count for January 2, 2024).

[0138] The cash flow analysis method of this invention solves the problem of detailed analysis of specific business and projects, and provides timely and accurate information for management, which helps to avoid decision-making errors caused by information lag.

[0139] like Figure 3 As shown, the cash flow analysis device based on income and expenditure item mapping provided in this embodiment of the invention can be implemented in software. The cash flow analysis device 300 based on income 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 income and expenditure item mapping are described below:

[0141] The basic data extraction module 301 is used to call the extraction engine and perform extraction operations to extract basic cash flow statistics data within a set time range from the cash flow-related data of the preset financial organization.

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

[0143] The matching record generation module 303 is used to call the matching engine and perform matching operations. It matches income and expenditure items with basic cash flow statistics 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 perform statistical operations, statistically analyze the matching records according to the business dimension, and generate a cash flow statistics table for income and expenditure items in the management dimension.

[0145] It should be noted here that, Figure 3 The various modules in the cash flow analysis device based on income and expenditure item mapping, and Figure 1 Each step in the cash flow analysis method based on the mapping of income and expenditure items corresponds to the previous one, and their specific implementation process is the same, so it will not be repeated here.

[0146] The structure of the electronic device according to an embodiment of the present invention will be described in detail below. Figure 4 This is a schematic diagram of the composition structure of an electronic device provided in an embodiment of the present invention. It can be understood that... Figure 4 The diagram shows only an exemplary structure of the electronic device, not the entire structure. Some or all of the structures shown may be implemented as needed.

[0147] The electronic device provided in this embodiment of the invention includes: at least one processor 401, a memory 402, a user interface 403, and at least one network interface 404. The various components in the cash flow analysis device based on income and expenditure item mapping are coupled together via a bus system 405. It can be understood that the bus system 405 is used to realize the connection and communication between these components. In addition to a data bus, the bus system 405 also includes a power bus, a control bus, and a status signal bus. However, for clarity, in... Figure 4 The general designated all buses as Bus System 405.

[0148] The user interface 403 may include a monitor, keyboard, mouse, trackball, click wheel, buttons, touchpad, or touch screen.

[0149] It is understood that memory 402 can be volatile memory or non-volatile memory, or both. In this embodiment of the invention, memory 402 is capable of storing data to support the operation of the terminal. Examples of this data include any computer programs used to operate on the terminal, such as operating systems and applications. The operating system includes various system programs, such as framework layers, core library layers, driver layers, etc., used to implement various basic services and handle hardware-based tasks. Applications can include various applications.

[0150] In some embodiments, the cash flow analysis device 300 based on revenue and expenditure item mapping provided in this invention can be implemented using a combination of hardware and software. For example, the cash flow analysis device 300 based on revenue and expenditure item mapping provided in this invention can be a processor in the form of a hardware decoding processor, programmed to execute the cash flow analysis method based on revenue and expenditure item mapping provided in this invention. For instance, the 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, 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., wherein the general-purpose processor can be a microprocessor or any conventional processor, etc.

[0152] As an example of the hardware implementation of the cash flow analysis device 300 based on income and expenditure item mapping provided in this embodiment of the invention, the device provided in this embodiment of the invention can be directly executed by a processor 401 in the form of a hardware decoding processor. For example, it can be executed 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 income and expenditure item mapping provided in this embodiment of the invention.

[0153] The memory 402 in this embodiment of the invention is used to store various types of data to support the operation of the cash flow analysis device 300 based on income and expenditure item mapping, or to store data for execution. Figure 1The program code for the method shown. Examples of this data include: any executable instructions for operation on a cash flow analysis device based on income and expenditure item mapping, such as executable instructions that can be included in a program implementing the cash flow analysis method based on income and expenditure item mapping of embodiments of the present invention.

[0154] Specifically, according to embodiments of this application, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of this application include a computer program product comprising a computer program carried on a computer-readable medium, the computer program including functions for executing... Figure 1 The program code for the method shown. In such an embodiment, the computer program can be downloaded and installed from a network via a communication component, and / or installed from a removable medium. When the computer program is executed by the central processing unit, it performs the various functions defined in the apparatus of this application.

[0155] in, Figure 1 The computer program instructions corresponding to the method shown may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to operate in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in the process. Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0156] The above description is merely a preferred embodiment of the present invention and is not intended to limit the invention. Various modifications and variations can be made to the present invention by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A cash flow analysis method based on the mapping of income and expenditure items, characterized in that, include: Call the extraction engine and perform the extraction operation to extract basic cash flow statistics data within a set time range from the cash flow-related data of the preset funding organization; Get all income and expenditure items and income and expenditure item mappings under the preset fund organization, then call the matching rule generation engine and perform the generation operation. Based on the income and expenditure items, income and expenditure item mappings and the relationship between income and expenditure item mapping fields and matching fields, generate matching rules under the preset fund organization. Call the matching engine and perform the matching operation. Based on the matching rules under the preset financial organization, match the income and expenditure items and cash flow statistics of the preset financial organization to generate matching records. Call the statistics engine and execute statistical operations to perform statistics on the matching records according to the business dimension, and generate a cash flow statistics table of income and expenditure items in the management dimension; The relationship between the mapping fields and matching fields of the income and expenditure items includes the following attributes: the identifier of the relationship between the mapping fields and matching fields of income and expenditure items, the mapping symbol, the mapping fields, and the corresponding fields of the statistical basis; The relationship between the mapping field and the matching field of income and expenditure items is a pre-built data used to record which field of the statistical basis is matched when the income and expenditure items are matched with the cash flow statistical basis. The cash flow statistics table for income and expenditure items includes the following attributes: cash flow statistics table identifier for income and expenditure items, income and expenditure item identifier, income and expenditure item number, income and expenditure item name, funding organization, business category, payment method, income and expenditure type, business activity type, transaction date, number of transactions on the same day, number of transactions in the current month, and number of transactions in the previous year and the current month.

2. The cash flow analysis method based on revenue and expenditure item mapping as described in claim 1, characterized in that, The attributes of the basic cash flow statistics data include cash flow statistics data identifier, fund organization, local account, transaction date, transaction amount, payment method, business category, business category name, remarks, counterparty, counterparty account, 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 as described in claim 1, characterized in that, The revenue and expenditure item mapping is used to define the mapping relationship between revenue and expenditure items and the cash flow statistics basis; the attributes of the revenue and expenditure item mapping include revenue and expenditure item mapping identifier, belonging revenue and expenditure item, several mapping fields and their corresponding mapping relationship and mapping value; The attributes of the matching rule include the matching rule identifier, fund organization, income and expenditure item identifier, income and expenditure item mapping identifier, and matching rule name.

4. The cash flow analysis method based on revenue and expenditure item mapping as described in claim 1, characterized in that, The attributes of the matched record include the matching record identifier, fund organization, income and expenditure item identifier, cash flow statistics basic identifier, income and expenditure item mapping identifier, and matching rule identifier.

5. A cash flow analysis device based on income and expenditure item mapping using the method described in claim 1, characterized in that, include: The basic data extraction module is used to call the extraction engine and perform extraction operations to extract basic cash flow statistics data within a set time range from the cash flow-related data of the preset financial organization. The matching rule generation module is used to obtain all income and expenditure items and income and expenditure item mappings under the preset fund organization, and then call the matching rule generation engine to perform the generation operation. Based on the income and expenditure items, income and expenditure item mappings, and the relationship between income and expenditure item mapping fields and matching fields, it generates matching rules under the preset fund organization. The matching record generation module is used to call the matching engine and perform matching operations. It matches income and expenditure items with basic cash flow statistics data based on the matching rules under the preset fund organization to generate matching records. The matching record statistics module is used to call the statistics engine and perform statistical operations, statistically analyze the matching records according to business dimensions, and generate a cash flow statistics table for income and expenditure items in the management dimension.

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

7. A computer program product comprising a computer program / instructions, characterized in that, When the computer program / instructions are executed by the processor, they implement the steps in the cash flow analysis method based on income and expenditure item mapping as described in any one of claims 1-4.

8. An electronic device comprising a memory, a processor, and a computer program stored in 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 income and expenditure item mapping as described in any one of claims 1-4.

Images