Intelligent matching and selling method, system and equipment based on multi-dimensional data and medium

Abstract

The invention belongs to the technical field of artificial intelligence, and particularly relates to an intelligent matching and selling method, system and device based on multi-dimensional data and a medium. Setting a spreading and selling rule; comprising the steps of determining a sales-spreading dimension, determining a sales-spreading mode, defining sales-spreading items, formulating a sales-spreading formula and setting a matching rule; screening the assets meeting the sales spreading requirements in the multi-dimensional data according to a formulated sales spreading rule; intelligently matching an accounting book and an asset category of the asset according to the asset information, and matching a distribution mode in a rule base according to the matched accounting book and the asset category; and analyzing the matched amortization mode, obtaining an amortization formula, and calculating amortization expense details of the assets according to the obtained amortization formula. According to the invention, by using the preset spreading rule and the intelligent matching center, the corresponding spreading mode can be quickly matched according to the accounting book of the asset and the asset category information, so that the processing time is greatly shortened.

Description

Technical Field

[0001] The present invention belongs to the technical field of artificial intelligence, and particularly relates to an intelligent matching amortization method, system, device and medium based on multi-dimensional data. Background Art

[0002] In the field of financial accounting, amortization is an important link in dealing with the end-of-period business of intangible assets and long-term deferred expenses. However, traditional asset amortization work faces many challenges, and these problems become more prominent with the diversification of enterprise business and the expansion of scale.

[0003] For different accounting books and different categories of assets, their corresponding amortization methods vary significantly. Taking a large enterprise group as an example, different subsidiaries under it use different accounting books, and the amortization methods of various intangible assets (such as patent technologies, trademark rights) and long-term deferred expenses (such as large-scale decoration expenses, long-term lease expenses) are different. Even for the same amortization method, the amortization ratios and amounts of different individual assets are not the same. This complexity makes the retrieval and matching of asset amortization methods an extremely cumbersome task. This not only affects the efficiency of financial work but also may lead to inaccurate financial data, thus affecting the decision-making judgment of the enterprise.

[0004] With the rapid development of big data and artificial intelligence technologies, all industries are actively exploring the use of these emerging technologies to improve business efficiency and quality. The development of these technologies provides new ideas and means for solving the problems of traditional amortization work, prompting financial personnel to seek an intelligent amortization method to reduce the manual burden, improve the accuracy and efficiency of amortization processing, and better meet the needs of enterprise digital transformation. Summary of the Invention

[0005] In order to solve the problems that traditional amortization work affects the efficiency of financial work and may also lead to inaccurate financial data, the present invention provides an intelligent matching amortization method, system, device and medium based on multi-dimensional data.

[0006] In the first aspect, the technical solution of the present invention provides an intelligent matching amortization method based on multi-dimensional data, including: Collect multi-dimensional data of assets, where the multi-dimensional data includes amortization dimension information, amortization method information, amortization item information, and asset item information of different items; Formulate amortization rules; including determining amortization dimensions, clarifying amortization methods, defining amortization items, formulating general amortization formulas for single amortization items and multiple amortization items, setting matching rules, and generating a rule library; Screen the assets that meet the amortization requirements from the multi-dimensional data according to the formulated amortization rules; Match the amortization method in the rule library according to the amortization dimension of the asset; Analyze the amortization method that is matched, obtain the amortization formula, and calculate the detailed amortization expenses of the asset based on the obtained amortization formula.

[0007] As an optimization of the technical solution of the present invention, the steps of setting the matching rules include: Set the rule for allocating the amortization method according to the amortization dimension, set the amortization formula for the amortization method, set the mapping relationship between the amortization item and the asset item and the mapping relationship between the asset details and the amortization item details, and set the mapping relationship between the asset and the amortization dimension.

[0008] As an optimization of the technical solution of the present invention, the steps of setting the mapping relationship between the amortization item and the asset item and the mapping relationship between the asset details and the amortization item details include: Find the corresponding asset item for each amortization item according to the established amortization rule, associate different amortization items with the corresponding asset items, and establish a mapping relationship; Associate each expense item with the corresponding amortization item details to establish the mapping relationship between the asset details and the amortization item details.

[0009] As an optimization of the technical solution of the present invention, the amortization dimension of the asset includes the accounting ledger and the asset category; The steps of matching the amortization method in the rule library according to the amortization dimension of the asset include: Divide the assets into several data regions of a single accounting ledger plus the asset category according to the accounting ledger and the asset category; Traverse each data region in turn, and match the amortization method in the rule library according to the information of the accounting ledger and the asset category in each data region.

[0010] As an optimization of the technical solution of the present invention, the steps of dividing the assets into several data regions of a single accounting ledger plus the asset category according to the accounting ledger and the asset category include: Combine the accounting ledger and the asset category according to the Cartesian product, and each combination includes a single accounting ledger plus the asset category; Divide the assets into several data regions according to the combination of the accounting ledger and the asset category.

[0011] As an optimization of the technical solution of the present invention, the method further includes: When matching the amortization method in the rule library according to the information of the accounting ledger and the asset category in each data region, if the matching result is empty, obtain the general amortization formula according to the amortization item information, and calculate the detailed amortization expenses of the assets in this data region based on the general amortization formula.

[0012] As an optimization of the technical solution of the present invention, the steps of analyzing the matched amortization method, obtaining the amortization formula, and calculating the detailed amortization expenses of the asset based on the obtained amortization formula include: Analyze the amortization method obtained by matching, and obtain the amortization formula under the amortization method; According to the amortization formula, calculate the amortization expense details of the assets in the corresponding data area according to the amortization formula.

[0013] In a second aspect, the technical solution of the present invention further provides an intelligent matching amortization system based on multi-dimensional data, including a data collection module, a rule formulation module, an asset screening module, and an intelligent matching center; the intelligent matching center includes an intelligent matching module and an intelligent amortization module; The data collection module is used to collect multi-dimensional data of assets, and the multi-dimensional data includes amortization dimension information, amortization method information, amortization item information, and asset item information of different projects; The rule formulation module is used to formulate amortization rules; including determining the amortization dimension, clarifying the amortization method, defining the amortization item, formulating general amortization formulas for single amortization items and multiple amortization items, setting matching rules, and generating a rule library; The asset screening module is used to screen the assets that meet the amortization requirements in the multi-dimensional data according to the formulated amortization rules; The intelligent matching module is used to match the amortization method in the rule library according to the amortization dimension of the asset; The intelligent amortization module is used to analyze the matched amortization method, obtain the amortization formula, and calculate the amortization expense details of the assets according to the obtained amortization formula.

[0014] As a preference of the technical solution of the present invention, the rule formulation module includes a matching rule setting unit, which is used to set the rule for allocating the amortization method according to the amortization dimension, set the amortization formula for the amortization method, set the mapping relationship between the amortization item and the asset item, and the mapping relationship between the asset details and the amortization item details, and set the mapping relationship between the asset and the amortization dimension.

[0015] As a preference of the technical solution of the present invention, the matching rule setting unit is specifically used to find the corresponding asset item for each amortization item according to the established amortization rules, associate different amortization items with the corresponding asset items, and establish a mapping relationship; associate each expense item with the corresponding amortization item details, and establish a mapping relationship between the asset details and the amortization item details.

[0016] As a preference of the technical solution of the present invention, the asset screening module is specifically used to preliminarily classify the assets according to the combination relationship of the accounting books and asset categories in the amortization rules, form a preliminary asset subset; in the preliminary asset subset, screen according to the amortization items defined in the amortization rules to obtain the assets that meet the amortization requirements.

[0017] Preferably, as the technical solution of the present invention, the amortization dimension of the asset includes the accounting ledger and the asset category; An intelligent matching module, configured to divide the assets into several data regions of a single accounting ledger plus asset categories according to the accounting ledger and the asset category; traverse each data region in sequence, and match the amortization method in the rule library according to the information of the accounting ledger and the asset category in each data region; specifically, combine the accounting ledger and the asset category according to the Cartesian product, and each combination includes a single accounting ledger plus asset category; divide the assets into several data regions according to the combination of the accounting ledger and the asset category. When matching the amortization method in the rule library according to the information of the accounting ledger and the asset category in each data region, if the matching result is empty, obtain a general amortization formula according to the amortization item information, and calculate the amortization expense details of the assets in this data region according to the general amortization formula.

[0018] In a third aspect, the technical solution of the present invention further provides an electronic device, where the electronic device includes: at least one processor; and a memory communicatively connected to the at least one processor; the memory stores computer program instructions executable by the at least one processor, and the computer program instructions are executed by the at least one processor so that the at least one processor can execute the intelligent matching amortization method based on multi-dimensional data as described in the first aspect.

[0019] In a fourth aspect, the technical solution of the present invention further provides a non-transitory computer-readable storage medium, where the non-transitory computer-readable storage medium stores computer instructions, and the computer instructions cause the computer to execute the intelligent matching amortization method based on multi-dimensional data as described in the first aspect.

[0020] It can be seen from the above technical solutions that the present application has the following advantages: Through data collection and screening, using the preset amortization rules and the intelligent matching center, the corresponding amortization method can be quickly matched according to the accounting ledger and asset category information of the assets, greatly shortening the processing time. It realizes automated processing, reduces the dependence on a large amount of manual work, avoids manual calculation errors, reduces the error of financial data, and improves the reliability of financial statements. The rules of the intelligent amortization method can be flexibly adjusted according to the needs of the enterprise. In the later stage, when new amortization methods are added or amortization dimensions are modified, only the rule library needs to be updated to quickly adapt to the changes, with stronger flexibility and adaptability. Description of the Drawings

[0021] In order to more clearly illustrate the technical solutions of the present application, the drawings required for description will be briefly introduced below. Obviously, the drawings in the following description are only some embodiments of the present application. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0022] Figure 1 It is a schematic flowchart of the method provided by the embodiment of the present invention.

[0023] Figure 2 It is a schematic connection block diagram of the system provided by the embodiment of the present invention. Detailed implementation manners

[0024] To make the application purpose, features, and advantages of the present application more obvious and understandable, the technical solutions protected by the present application will be clearly and completely described below by using specific embodiments and the accompanying drawings. Obviously, the embodiments described below are only a part of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in this patent, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of this patent.

[0025] To make the purpose, features, and advantages of the present invention more obvious and understandable, the technical solutions in the present invention will be clearly and completely described below in conjunction with the accompanying drawings in this specific embodiment. Obviously, the embodiments described below are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments in this application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of this application.

[0026] As Figure 1 shown, the embodiment of the present invention provides an intelligent matching amortization method based on multi-dimensional data, including: S1: Collect multi-dimensional data of assets, where the multi-dimensional data includes amortization dimension information, amortization method information, amortization item information, and asset item information of different projects; S2: Whether there is an amortization rule; If it exists, execute S4; otherwise, execute S3; S3: Formulate an amortization rule; including determining the amortization dimension, clarifying the amortization method, defining the amortization item, formulating general amortization formulas for single amortization items and multiple amortization items, setting matching rules, and generating a rule library; the amortization dimension includes the accounting ledger and the asset category; 1. Amortization dimension: The accounting ledger and the asset category are automatically included in the amortization item as the basic information of the asset; the amortization dimension is a public amortization dimension: accounting ledger (ledger), asset category (category); 2. Amortization method: The basic amortization methods are the one-time amortization method, the fifty-fifty amortization method, the installment amortization method, and the net value amortization method. Therefore, the above 4 amortization methods are used as common amortization methods. At the same time, there are special amortization methods for different projects. That is, the amortization method is the common amortization method (pubmethod) and the special amortization method (method).

[0027] 3. Amortization items: The main content of the amortization method is the amortization item (dim), and there are multiple detailed contents for the amortization item (dim1-1, dim1-2); 4. General amortization formula: The main content of the amortization method is the amortization item (dim), and by combining different proportions of the details of the amortization item, a general amortization formula is formed.

[0028] The amortization formula for a single amortization item is: (dim1-1 * 60%) + (dim1-2 * 40%) = amortization expense; The amortization formula for multiple amortization items is: (dim1-1 * 40%) + (dim2-1 *40%) + (dim1-2* 60%) + (dim2-2 * 60%) = amortization expense.

[0029] 5. Matching rules: Rule 1: Allocate the amortization method according to the common amortization dimension for the accounting book and asset category. The rules are as follows: a. The amortization methods for the assets of a certain asset category under a certain accounting book are the same. At this time, the allocation plan is: ledger1*category1=method1 b. The amortization methods for the assets of all asset categories under a certain accounting book are the same. At this time, the allocation plan is: ledger1*all=method1 c. The amortization methods for the assets of all accounting books under a certain asset category are the same. At this time, the allocation plan is: all*category1=method1 d. The amortization methods for the assets of all asset categories under all accounting books are the same. At this time, the allocation plan is: all*all=method1 Rule 2: Set the amortization formula: (dim1-1 * 40%+dim1-2 * 40%)+( dim2-1 * 60%+dim2 -2* 60%)=method1 Rule 3: Set the mapping relationship between amortization items and asset items: dim1 <=> item1 dim2 <=> item2 Rule 4: Set the mapping relationship between asset information and common amortization dimensions: a. For case a in Rule 1, the allocation scheme at this time is: ledger1 * category1 = asset1 b. For case b in Rule 1, the allocation scheme at this time is: ledger1 = asset1 c. For case c in Rule 1, the allocation scheme at this time is: category1 = asset1 d. For case d in Rule 1, the allocation scheme at this time is: all = asset1 Rule 4: Set the mapping relationship between the details of asset information and the details of amortization items: asset1 <=> item1-1 <=> dim1-1 asset1 <=> item1-2 <=> dim1-2 asset1 <=> item2-1 <=> dim2-1 asset1 <=> item2-2 <=> dim2-2.

[0030] Set rules for allocating amortization methods based on accounting books and asset categories. According to the enterprise's past experience and financial standards, for example, stipulate that fixed assets used in the workshop department adopt the installment amortization method under a specific accounting book, and office equipment adopts the one-time amortization method under another accounting book, etc. Then, set the amortization formula for the amortization method. For the installment amortization method, set the formula "Amortization expense per period = (Original value of the asset - Estimated net residual value) ÷ Estimated useful life"; for the one-time amortization method, directly set the formula "Amortization expense = Original value of the asset". Next, set the mapping relationship between amortization items and asset items. Associate the asset item of production equipment with the production equipment depreciation and amortization item, and associate the asset item of office desks and chairs with the office furniture amortization item. At the same time, set the mapping relationship between the asset information details and the amortization item details, and associate the information details such as the purchase value and useful life of the production equipment with the corresponding details under the production equipment depreciation and amortization item. Finally, set the mapping relationship between asset information and amortization dimensions. Map the assets in the production workshop to the corresponding accounting book and fixed asset category of the production workshop, and map the assets in the management department to the management accounting book and office equipment category, thus constructing a complete matching rule system to ensure the orderly progress of the asset amortization work.

[0031] In the embodiment of the present invention, the steps of setting the mapping relationship between amortization items and asset items and the mapping relationship between asset details and amortization item details include: S31: According to the established amortization rules, find the corresponding asset items for each amortization item, associate different amortization items with the corresponding asset items, and establish a mapping relationship; Before setting the mapping relationship, it is necessary to clearly define the amortization items and asset items. In this application, the main content of the amortization method is the amortization item (dim), and there are multiple detailed contents (dim1 - 1, dim1 - 2), and these detailed contents are the key elements constituting the amortization formula. The asset items cover various intangible assets and long-term prepaid expenses, etc. that need to be amortized in the enterprise, and each asset has specific attributes, such as information on the affiliated accounting book, asset category, etc.

[0032] Set the rules for the mapping relationship between amortization items and asset items, that is, "dim1 <=> item1", "dim2 <=> item2". This means that in actual operation, according to this rule, different amortization items are associated with the corresponding asset items. Suppose the asset item "item1" represents a technology of the enterprise, and "dim1" is the item related to the amortization of this technology, then a two-way corresponding relationship between "dim1" and "item1" is established, indicating that when calculating the amortization of this technology, the amortization rules and formulas related to "dim1" will be used.

[0033] S32: Associate each expense item with the corresponding details of the amortization item to establish the mapping relationship between the asset details and the amortization item details.

[0034] To calculate the amortization expense more precisely, the mapping relationship between the asset information details and the amortization item details is also set up, such as "asset1 <=> item1 - 1 <=> dim1 - 1", "asset1 <=> item1 - 2 <=> dim1 - 2", "asset1 <=> item2 - 1 <=> dim2 - 1", "asset1 <=> item2 - 2 <=> dim2 - 2". This refined mapping relationship can correspond the specific details of the asset with the details of the amortization item one by one. For example, for a long-term deferred expense "asset1", associate its subdivided expense items (item1 - 1, item1 - 2, etc.) with the corresponding amortization item details (dim1 - 1, dim1 - 2, etc.) to ensure that when calculating the amortization expense, it can be accurately calculated according to the proportion of each detailed item, improving the accuracy of the amortization calculation.

[0035] S4: Screen the assets that meet the amortization requirements from the multi-dimensional data according to the formulated amortization rules; This step specifically includes: S41: According to the combination relationship between the accounting ledger and the asset category in the amortization rules, initially classify the assets by accounting ledger and asset category to form a preliminary asset subset; According to the combination relationship between the accounting ledger and the asset category in the amortization rules, initially classify the assets by ledger and category. For example, if the rule stipulates that assets in the "category1" asset category under the "ledger1" accounting ledger adopt a specific amortization method, first screen out the assets that belong to the "ledger1" accounting ledger and the "category1" category to form a preliminary asset subset.

[0036] S42: In the preliminary asset subset, screen according to the amortization items defined in the amortization rules to obtain the assets that meet the amortization requirements.

[0037] In the initially screened asset subset, further screen in combination with the requirements for amortization items in the amortization rules. If the rule has regulations on specific amortization items, such as certain items apply to specific amortization formulas, only retain the assets that contain these qualified amortization items to obtain the final asset set that meets all dimensional requirements.

[0038] Taking an enterprise as an example, first, according to the combination relationship between the accounting books and asset categories in the amortization rules, the assets are preliminarily classified by accounting books and asset categories. The construction equipment in the engineering project is classified into the mechanical equipment asset category under the engineering project accounting book, and the office assets of the enterprise headquarters are classified into the office equipment asset category under the enterprise management accounting book, forming a preliminary asset subset. Then, in the preliminary asset subset, screening is carried out in combination with the amortization items defined in the amortization rules. For the mechanical equipment asset category under the engineering project accounting book, according to its usage characteristics and amortization rules, the assets that meet the requirements of the construction equipment amortization project are screened out, and some temporarily borrowed and short-term leased equipment that does not involve amortization is excluded; for the office equipment asset category under the enterprise management accounting book, the assets that meet the requirements of the office equipment depreciation and amortization project are screened out, and the assets that have been scrapped or have a low value and are directly included in expenses are removed, so as to obtain the assets that meet the amortization requirements and lay a foundation for accurate amortization in the follow-up.

[0039] S5: Match the amortization method in the rule library according to the amortization dimension matching rule of the asset; All the screened asset data are entered into the intelligent matching center to ensure that the information such as the accounting book, category, and amortization project of the asset is entered completely and accurately, providing a data basis for the subsequent matching operation.

[0040] The intelligent matching center automatically searches for and matches the accounting book information corresponding to the asset according to the asset information. For example, the accounting book information of the asset "asset1" is "ledger1", and the matching center locates the relevant rules and information related to "ledger1" in the rule library. After matching the accounting book information, the asset category information is then matched. If the category of "asset1" is "category1", the relevant rules under the combination of "ledger1" and "category1" are determined through the rule library. According to the accounting book and asset category information matched in the previous two steps, based on the matching rule one in the amortization rules, the amortization method of the asset is determined. If the rule stipulates that "ledger1 * category1 = method1", then the amortization method of "asset1" is "method1".

[0041] In this step, the specific process includes: First, retrieve in the amortization dimension data according to the basic attributes of the asset to preliminarily determine the accounting ledger and asset category of the asset. For a high-performance computer used in the trading department, based on its usage and procurement department information, it is preliminarily judged that it may belong to the electronic equipment asset category under the trading business accounting ledger. Then, combined with the financial data of the asset, further confirm the asset category. By checking the financial data such as the acquisition cost and depreciation method of this computer, it is found that it conforms to the depreciation policy of high-value electronic equipment, and further confirm that it belongs to the electronic equipment asset category; based on the business-related data of the asset, finally determine the accounting ledger. Since this computer is specifically used for trading business and is closely related to the trading department, it is determined that it belongs to the trading business accounting ledger. Finally, using the determined accounting ledger and asset category as retrieval conditions, find and obtain the corresponding amortization method in the rule library. In the rule library, the rule "trading business accounting ledger * electronic equipment asset category = accelerated depreciation method" is found, and it is determined that this computer uses the accelerated depreciation method for amortization to ensure that the asset amortization conforms to the actual business and financial norms of the enterprise.

[0042] S6: Analyze the matched amortization method, obtain the amortization formula, and calculate the detailed amortization expenses of the asset according to the obtained amortization formula.

[0043] After finding the amortization method, determine the corresponding amortization formula according to Rule 2. At the same time, determine the mapping relationships between the amortization items and asset items, asset information and public amortization dimensions, and asset information details and amortization item details according to Rules 3 and 4. For example, the rules stipulate "dim1 <=> item1", "asset1 <=> item1 - 1 <=> dim1 - 1", etc., to establish the corresponding relationships between the asset and each element of the amortization formula, preparing for intelligent amortization.

[0044] In some embodiments, the asset information includes the basic attributes, financial data, and business-related data of the asset; the step of matching the amortization method in the rule library according to the amortization dimension of the asset includes: S51: Retrieve in the amortization dimension data according to the basic attributes of the asset to preliminarily determine the accounting ledger and asset category of the asset; S52: Combine the financial data of the asset to further confirm the asset category, and finally determine the accounting ledger based on the business-related data of the asset; S53: Use the determined accounting ledger and asset category as retrieval conditions to find and obtain the corresponding amortization method in the rule library.

[0045] Retrieve in the rule library based on the sorted accounting books and asset category information. If the rule library is stored in the form of a database, SQL query statements can be used for retrieval. Use a statement like "SELECT amortization method FROM amortization rule table WHERE accounting book ='specific accounting book name' AND asset category ='specific asset category name'" to find the eligible amortization method from the "amortization rule table". If the rule library is managed through a configuration file, a program can be written to read the content of the configuration file, compare the accounting book and asset category information line by line, and find the matching records.

[0046] If the retrieval result is empty, check whether there is a "general rule", that is, a rule stating that "the amortization methods of assets under all asset categories in all accounting books are the same". If such a rule exists, use the corresponding general amortization method as the result. If there is no general rule, it indicates that the rule library lacks rules for the combination of this accounting book and asset category, and it is necessary to feedback to relevant personnel for rule supplementation or correction. When one record is retrieved, directly obtain the amortization method therein as the result. If multiple records are retrieved, judge according to the priority of the rules. The rule that "the amortization methods of assets of a certain asset category under a certain accounting book are the same" has a higher priority than the rule that "the amortization methods of assets of all asset categories under a certain accounting book are the same". If there are multiple rules with different priorities that all match, preferentially select the amortization method corresponding to the rule with a higher priority.

[0047] Different from the above embodiments, the step of matching the amortization method in the rule library according to the amortization dimension of the asset includes: SS51: Divide the assets into several data regions of a single accounting book plus asset category according to the accounting book and asset category; this step specifically includes: combining the accounting book and asset category according to the Cartesian product, and each combination includes a single accounting book plus asset category; dividing the assets into several data regions according to the combination of the accounting book and asset category.

[0048] SS52: Traverse each data region in turn, and match the amortization method in the rule library according to the information of the accounting book and asset category in each data region.

[0049] Correspondingly, the steps of parsing the matched amortization method, obtaining the amortization formula, and calculating the amortization expense details of the asset based on the obtained amortization formula include: parsing the matched amortization method to obtain the amortization formula under the amortization method; calculating the amortization expense details of the assets in the corresponding data region according to the amortization formula.

[0050] According to Rule 2 in the amortization rules, the amortization formula is: dim1-1(40%) + dim2-1(40%) + dim1-2(60%) + dim2-2(60%) According to the amortization items and asset information, the amortization formula of the asset is obtained after intelligent matching as follows: item1-1(40%) + item2-1(40%) + item1-2(60%) + item2-2(60%) According to the amortization formula of the asset, the detailed amortization expenses of the asset are calculated: expense1 = item1-1(40%) + item1-2(60%) expense2 = item2-1(40%) + item2-2(60%) Asset A found amortization method 1 in the previous step. The rule of amortization method 1 is that item 1 is allocated 40% and item 2 is allocated 60%. In this way, the final amortization plan of Asset A is obtained. Then, I obtain the value information of the asset. Suppose it is 100. Multiply this information by 40% and 60% respectively, and finally get the amortized results: item 1: 40, item 2: 60.

[0051] The specific process is as follows: First, collect multi-dimensional data of the asset. Collect data from the asset management system, financial statements, and each business department, such as equipment purchase contracts, invoice information, usage department records, etc., to obtain asset information such as asset name, purchase time, value, etc., as well as amortization dimension data such as accounting books of different business items, asset categories, different amortization method data, and relevant amortization item information. Next, formulate amortization rules. Determine the accounting book and asset category as amortization dimensions, clarify that the straight-line amortization method, the 50-50 amortization method, etc. are common amortization methods, define each amortization item in detail, formulate general formulas for single and multiple amortization items, and set matching rules, and organize these rules into a rule library. Then, screen assets according to the formulated amortization rules. Screen the collected asset data according to the accounting book and asset category, exclude asset information that does not conform to the current enterprise accounting system and asset classification, and leave the qualified asset data to enter the subsequent process. After that, perform intelligent matching. Utilize the basic attributes, financial data, and business-related data of the asset, retrieve and match in the data by writing programs, determine the accounting book and asset category of the asset, and then find the corresponding amortization method in the rule library based on these two pieces of information. Finally, analyze the matched amortization method, obtain the corresponding amortization formula, calculate the detailed amortization expenses of the asset, complete the intelligent amortization of the asset, and greatly improve the efficiency and accuracy of financial work.

[0052] Such as Figure 2As shown in the figure, an embodiment of the present invention further provides an intelligent matching amortization system based on multi-dimensional data, including a data collection module, a rule formulation module, an asset screening module, and an intelligent matching center; the intelligent matching center includes an intelligent matching module and an intelligent amortization module; The data collection module is used to collect multi-dimensional data of assets, and the multi-dimensional data includes amortization dimension information, amortization method information, amortization item information, and asset item information of different projects; The rule formulation module is used to formulate amortization rules; it includes determining amortization dimensions, clarifying amortization methods, defining amortization items, formulating general amortization formulas for single amortization items and multiple amortization items, setting matching rules, and generating a rule library; The asset screening module is used to screen assets that meet the amortization requirements from the multi-dimensional data according to the formulated amortization rules; The intelligent matching module is used to match the amortization method in the rule library according to the amortization dimension of the asset; The intelligent amortization module is used to parse the matched amortization method, obtain the amortization formula, and calculate the amortization expense details of the asset according to the obtained amortization formula.

[0053] Enter the asset data to be amortized into the intelligent matching. In the intelligent matching center, match the amortization method according to the accounting ledger of the asset and the asset category information, completely relying on the matching rules. For example, Rule 1 clarifies the amortization method allocation plan for different ledger and category combinations, such as "ledger1 * category1 = method1". The system compares the ledger and category information of the asset with the rule library according to this rule, quickly finds the corresponding amortization method, and realizes the accurate matching of the asset and the amortization method. During intelligent amortization, determine the amortization formula of the asset according to Rule 2 in the amortization rules. For example, the formula given by Rule 2 is "(dim1-1 * 40% + dim1-2 * 40%) + (dim2-1 * 60% + dim2 -2* 60%) = method1". Combining the actual amortization item details corresponding to the asset, the specific amortization formula of the asset can be obtained, and then the amortization expense details can be calculated.

[0054] In some embodiments, the rule formulation module includes a matching rule setting unit, which is used to set rules for allocating amortization methods according to amortization dimensions, set amortization formulas for amortization methods, set the mapping relationship between amortization items and asset items and the mapping relationship between asset details and amortization item details, and set the mapping relationship between assets and amortization dimensions.

[0055] The matching rule setting unit is specifically configured to find the corresponding asset item for each amortization item according to the established amortization rule, associate different amortization items with the corresponding asset items, and establish a mapping relationship; associate each expense item with the corresponding amortization item details, and establish a mapping relationship between the asset details and the amortization item details.

[0056] In some embodiments, the asset screening module is specifically configured to preliminarily classify assets according to the combination relationship of the accounting books and asset categories in the amortization rule, forming a preliminary asset subset; in the preliminary asset subset, screen in combination with the amortization items defined in the amortization rule to obtain assets that meet the amortization requirements. The asset information includes the basic attributes, financial data, and business association data of the asset; the intelligent matching module retrieves in the amortization dimension data according to the basic attributes of the asset, and preliminarily determines the accounting book and asset category of the asset; in combination with the financial data of the asset, further confirm the asset category, and finally determine the accounting book based on the business association data of the asset; use the determined accounting book and asset category as the retrieval conditions to find and obtain the corresponding amortization method in the rule library. When retrieving in the rule library with the determined accounting book and asset category as the retrieval conditions, if the retrieval result is empty, obtain the general amortization formula according to the amortization item information, and calculate the amortization expense details of the asset based on the general amortization formula.

[0057] In some embodiments, the asset screening module is specifically configured to preliminarily classify assets according to the combination relationship of the accounting books and asset categories in the amortization rule, forming a preliminary asset subset; in the preliminary asset subset, screen in combination with the amortization items defined in the amortization rule to obtain assets that meet the amortization requirements.

[0058] The asset information includes the basic attributes, financial data, and business association data of the asset; the intelligent matching module retrieves in the amortization dimension data according to the basic attributes of the asset, and preliminarily determines the accounting book and asset category of the asset; in combination with the financial data of the asset, further confirm the asset category, and finally determine the accounting book based on the business association data of the asset; use the determined accounting book and asset category as the retrieval conditions to find and obtain the corresponding amortization method in the rule library. When retrieving in the rule library with the determined accounting book and asset category as the retrieval conditions, if the retrieval result is empty, obtain the general amortization formula according to the amortization item information, and calculate the amortization expense details of the asset based on the general amortization formula.

[0059] Different from the above embodiments, in this embodiment, the intelligent matching module is used to divide assets into several data regions of a single accounting book plus asset categories according to the accounting book and asset category; traverse each data region in turn, and match the amortization method in the rule library according to the information of the accounting book and asset category in each data region; specifically, the accounting book and asset category are combined according to the Cartesian product, and each combination includes a single accounting book plus asset category; the assets are divided into several data regions according to the combination of the accounting book and asset category. When matching the amortization method in the rule library according to the information of the accounting book and asset category in each data region, if the matching result is empty, obtain the general amortization formula according to the amortization item information, and calculate the amortization expense details of the assets in this data region according to the general amortization formula.

[0060] An embodiment of the present invention further provides an electronic device, which includes: a processor, a communication interface, a memory, and a communication bus. Among them, the processor, the communication interface, and the memory complete mutual communication through the communication bus. The communication bus can be used for information transmission between the electronic device and the sensor. The processor can call the logical instructions in the memory to execute the following methods: collect multi-dimensional data of assets, where the multi-dimensional data includes asset information and asset amortization-related data. Among them, the asset amortization-related data includes amortization dimension data, amortization method data, and amortization item information of different items; formulate amortization rules; including determining amortization dimensions, clarifying amortization methods, defining amortization items, formulating general amortization formulas for single amortization items and multiple amortization items, and setting matching rules to generate a rule library; the amortization dimensions include accounting books and asset categories; screen the assets that meet the amortization requirements in the multi-dimensional data according to the formulated amortization rules; intelligently match the accounting books and asset categories of the assets according to the asset information, and match the amortization method in the rule library according to the matched accounting books and asset categories; analyze the matched amortization method, obtain the amortization formula, and calculate the amortization expense details of the assets according to the obtained amortization formula.

[0061] In addition, when the logic instructions in the above-mentioned memory can be implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or a part of this technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in various embodiments of the present invention. The aforementioned storage medium includes: various media such as USB flash drives, mobile hard disks, read-only memories (ROM, Read-Only Memory), random access memories (RAM, Random Access Memory), magnetic disks, or optical discs that can store program codes.

[0062] An embodiment of the present invention provides a non-transitory computer-readable storage medium. The non-transitory computer-readable storage medium stores computer instructions, and these computer instructions cause the computer to execute the method provided by the above method embodiment. For example, it includes: collecting multi-dimensional data of assets, where the multi-dimensional data includes asset information and asset amortization-related data. Among them, the asset amortization-related data includes amortization dimension data, amortization method data, and amortization item information for different items; formulating amortization rules; including determining amortization dimensions, clarifying amortization methods, defining amortization items, formulating general amortization formulas for single amortization items and multiple amortization items, and setting matching rules to generate a rule library; the amortization dimensions include accounting books and asset categories; screening the assets that meet the amortization requirements in the multi-dimensional data according to the formulated amortization rules; intelligently matching the accounting books and asset categories of the assets according to the asset information, and matching the amortization methods in the rule library according to the matched accounting books and asset categories; parsing the matched amortization method to obtain an amortization formula, and calculating the detailed amortization expenses of the assets based on the obtained amortization formula.

[0063] The above description of the disclosed embodiments enables those skilled in the art to implement or use the present invention. Various modifications to these embodiments will be obvious to those skilled in the art, and the general principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention will not be limited to these embodiments shown herein, but will be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. An intelligent matching amortization method based on multi-dimensional data, characterized in that: include: Collecting multi-dimensional data of assets, the multi-dimensional data including amortization dimension information, amortization method information, amortization project information, and asset project information of different projects; Formulate amortization rules, including determining amortization dimensions, clarifying amortization methods, defining amortization items, formulating general amortization formulas for single and multiple amortization items, setting matching rules, and generating a rule base; Screening assets that meet amortization requirements in the multi-dimensional data according to the established amortization rules; Match the amortization method in the rule base according to the amortization dimension of the asset; Parse the matched depreciation method, obtain the depreciation formula, and calculate the depreciation expense details of the asset based on the obtained depreciation formula.

2. The intelligent matching amortization method based on multi-dimensional data according to claim 1, characterized in that: The steps to set matching rules include: Set rules for assigning amortization methods based on amortization dimensions, set amortization formulas for amortization methods, set the mapping relationship between amortization items and asset items, the mapping relationship between asset details and amortization item details, and set the mapping relationship between assets and amortization dimensions.

3. The intelligent matching amortization method based on multi-dimensional data according to claim 2 is characterized in that: The steps for setting the mapping relationship between amortization items and asset items and the mapping relationship between asset details and amortization item details include: Find the corresponding asset item for each amortization item according to the established amortization rules, associate different amortization items with the corresponding asset items, and establish a mapping relationship; Associate each expense item with the corresponding amortization item details to establish a mapping relationship between asset details and amortization item details.

4. The intelligent matching amortization method based on multi-dimensional data according to claim 3 is characterized in that: The amortization dimension of the asset includes an accounting book and an asset category; and the step of matching the amortization method in the rule base according to the amortization dimension of the asset includes: The assets are divided into a single accounting book plus an asset class data area according to the accounting book and asset class; Each data area is traversed in turn, and the amortization method in the rule base is matched according to the information of the accounting books and asset categories in each data area.

5. The intelligent matching amortization method based on multi-dimensional data according to claim 4 is characterized in that: The steps for separating assets into data areas of a single accounting book plus asset class based on accounting books and asset classes include: The accounting books and asset classes are combined according to the Cartesian product, and each combination includes a single accounting book plus an asset class; Assets are divided into several data areas based on a combination of accounting books and asset categories.

6. The intelligent matching amortization method based on multi-dimensional data according to claim 5 is characterized in that: The steps of parsing the matched amortization method, obtaining the amortization formula, and calculating the amortization expense details of the asset according to the obtained amortization formula include: Analyze the matched amortization method and obtain the amortization formula under the amortization method; The assets in the corresponding data area are calculated according to the amortization formula, and the amortization expense details of the assets are calculated according to the amortization formula.

7. The intelligent matching amortization method based on multi-dimensional data according to claim 6 is characterized in that: The method further includes: According to the information of accounting books and asset categories in each data area, when matching the amortization method in the rule base, if the matching result is empty, obtain the general amortization formula according to the amortization item information, and calculate the amortization expense details of the assets in the data area according to the general amortization formula.

8. An intelligent matching amortization system based on multi-dimensional data, characterized in that: It includes a data collection module, a rule formulation module, an asset screening module and an intelligent matching center; the intelligent matching center includes an intelligent matching module and an intelligent amortization module; A data collection module, used to collect multi-dimensional data of assets, wherein the multi-dimensional data includes amortization dimension information, amortization method information, amortization project information and asset project information of different projects; The rule-making module is used to make amortization rules, including determining amortization dimensions, clarifying amortization methods, defining amortization items, making general amortization formulas for single and multiple amortization items, setting matching rules, and generating a rule base. An asset screening module, used to screen assets that meet amortization requirements in the multi-dimensional data according to the established amortization rules; An intelligent matching module, used for matching the amortization method in the rule base according to the amortization dimension of the asset; The intelligent amortization module is used to parse the matched amortization method, obtain the amortization formula, and calculate the amortization expense details of the asset based on the obtained amortization formula.

9. An electronic device, characterized in that: The electronic device includes: at least one processor; and a memory communicatively connected to the at least one processor; the memory stores computer program instructions executable by the at least one processor, and the computer program instructions are executed by the at least one processor so that the at least one processor can execute the intelligent matching amortization method based on multi-dimensional data as described in any one of claims 1 to 7.

10. A non-transitory computer-readable storage medium, characterized in that: The non-transitory computer-readable storage medium stores computer instructions, and the computer instructions enable the computer to execute the intelligent matching amortization method based on multi-dimensional data as described in any one of claims 1 to 7.

Images