Account checking method and device, equipment, storage medium and product
By introducing account merge rules and unified visual view generation technology into the interbank reconciliation system, the problem of inefficient processing of complex reconciliation relationships in the existing technology is solved, and efficient, flexible and accurate reconciliation results are achieved.
Patent Information
- Application Number
- CN202411199526.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-29
- Publication Date
- 2024-12-06
AI Technical Summary
The existing inter-bank reconciliation systems and software are inefficient in handling complex reconciliation relationships, have a long response time, and lack a unified view, which leads to users needing to view different reconciliation results separately, which takes a lot of time.
A method of account reconciliation is proposed. When determining that the reconciliation relationship is a preset relationship, the account information is pulled according to the account merge rules, a unified visual reconciliation view is generated, and the account reconciliation is performed based on the view, including pulling modules and determining modules , merge module and generation module, use account merge rules to merge information and view generation, and support the processing of complex reconciliation relationships.
It improves reconciliation efficiency, meets the needs of different scenarios, improves the flexibility and accuracy of reconciliation, and simplifies the user's reconciliation process.
Smart Images

Figure CN119090613A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to account reconciliation methods, devices, equipment, storage media and products. Background Art
[0002] Account reconciliation often exists in financial institutions, such as banks. Currently, inter-bank reconciliation mainly relies on each bank's own reconciliation system or third-party reconciliation software. However, the above systems and software can only handle reconciliation of simple reconciliation relationships, such as one-to-one. There are obvious defects when handling complex reconciliation relationships, such as long response time. In addition, the above systems and software lack a unified view when displaying reconciliation results. Users need to view the results of different reconciliation relationships separately, which takes a lot of time. Therefore, the efficiency of reconciliation in the above method is low.
[0003] The above contents are only used to assist in understanding the technical solution of the present application and do not constitute an admission that the above contents are prior art. Summary of the invention
[0004] The main purpose of this application is to provide an account reconciliation method, device, equipment, storage medium and product, aiming to solve the technical problem of low efficiency of reconciliation in the prior art.
[0005] To achieve the above purpose, the present application proposes an account reconciliation method, which includes:
[0006] Determine a reconciliation relationship between the first object and the second object, and when the reconciliation relationship is a preset relationship, respectively pull the account information of the first object and the account information of the second object according to the account merging rule;
[0007] Determine, based on the reconciliation relationship, a target object whose number of accounts is greater than a preset value;
[0008] When the target object is a first object, merging the account information of the first object according to the account merging rule to obtain first account information;
[0009] A unified visual reconciliation view is generated according to the first account information and the account information of the second object, and account reconciliation is performed according to the unified visual reconciliation view.
[0010] In one embodiment, the step of determining the reconciliation relationship between the first object and the second object, and respectively pulling the account information of the first object and the account information of the second object according to the account merging rule when the reconciliation relationship is a preset relationship, includes:
[0011] Acquire the account entry column of the first object and the account entry column of the second object based on the target account reconciliation relationship configuration module, wherein the target account reconciliation relationship configuration module is composed of an original account reconciliation relationship configuration module and an account column expansion unit;
[0012] Determine the first account quantity according to the account entry column of the first object and the preset account separator;
[0013] Determine the number of second accounts according to the account entry column of the second object and the preset account separator;
[0014] Determine a reconciliation relationship between a first object and a second object according to the first account quantity and the second account quantity;
[0015] When the number of the first accounts and / or the number of the second accounts is greater than a preset value, determining the reconciliation relationship to be a preset reconciliation relationship;
[0016] The account information of the first object is pulled according to the account identification information of the first object, and the account information of the second object is pulled according to the account identification information of the second object.
[0017] In one embodiment, when the target object is a first object, the step of merging the account information of the first object according to the account merging rule to obtain the first account information includes:
[0018] When the target object is the first object, determining a current account record field;
[0019] Determine the target merge object according to the current account record field;
[0020] Determining a target merging method according to the target merging object;
[0021] Generate account consolidation rules according to the target consolidation object and the target consolidation method;
[0022] The account information of the first object is merged according to the account merging rule to obtain first account information.
[0023] In one embodiment, the step of merging the account information of the first object according to the account merging rule to obtain the first account information includes:
[0024] Obtaining a first beginning balance, a first ending balance, and first account flow information according to the account information of the first object;
[0025] Generate a first account transaction list according to the first account transaction information;
[0026] According to the account consolidation rule, sum and consolidate the first beginning balance and the first ending balance respectively;
[0027] The first account transaction list is directly merged according to the account merging rule.
[0028] In one embodiment, the step of generating a unified visual reconciliation view according to the first account information and the account information of the second object, and performing account reconciliation according to the unified visual reconciliation view includes:
[0029] Setting the first account information to a first area of a preset view, and setting the account information of the second object to a second area of the preset view;
[0030] Generate a unified visual reconciliation view according to the set first area and the set second area;
[0031] Obtain the actual reconciliation needs of target users;
[0032] Generate a target reconciliation script according to the actual reconciliation requirements;
[0033] Account reconciliation is performed according to the unified visual reconciliation view by executing the target reconciliation script.
[0034] In one embodiment, after the step of determining the target object whose number of accounts is greater than a preset value according to the reconciliation relationship, the step further includes:
[0035] When the target object is a first object and a second object, the account information of the first object and the account information of the second object are respectively merged according to an account merging rule to obtain first account information and second account information;
[0036] Setting the first account information to a first area of a preset view, and setting the second account information to a second area of the preset view;
[0037] Generate a new unified visual reconciliation view based on the set areas;
[0038] Account reconciliation is performed based on the new unified visual reconciliation view by executing the target reconciliation script.
[0039] In addition, to achieve the above purpose, the present application also proposes an account reconciliation device, the account reconciliation device comprising:
[0040] A pulling module, used to determine the reconciliation relationship between the first object and the second object, and when the reconciliation relationship is a preset relationship, respectively pull the account information of the first object and the account information of the second object according to the account merging rule;
[0041] A determination module, configured to determine, based on the reconciliation relationship, a target object whose number of accounts is greater than a preset value;
[0042] a merging module, configured to merge the account information of the first object according to the account merging rule to obtain first account information when the target object is the first object;
[0043] A generation module is used to generate a unified visual reconciliation view according to the first account information and the account information of the second object, and perform account reconciliation according to the unified visual reconciliation view.
[0044] In addition, to achieve the above-mentioned purpose, the present application also proposes an account reconciliation device, which includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, and the computer program is configured to implement the steps of the account reconciliation method described above.
[0045] In addition, to achieve the above-mentioned purpose, the present application also proposes a storage medium, which is a computer-readable storage medium, and a computer program is stored on the storage medium. When the computer program is executed by the processor, the steps of the account reconciliation method described above are implemented.
[0046] In addition, to achieve the above-mentioned purpose, the present application also provides a computer program product, which includes a computer program, and when the computer program is executed by a processor, it implements the steps of the account reconciliation method described above.
[0047] One or more technical solutions proposed in the present application have at least the following technical effects: by determining the reconciliation relationship between the first object and the second object, when the reconciliation relationship is a preset relationship, respectively pulling the account information of the first object and the account information of the second object according to the account merging rule; determining the target object whose account number is greater than the preset value according to the reconciliation relationship; when the target object is the first object, merging the account information of the first object according to the account merging rule to obtain the first account information; generating a unified visual reconciliation view according to the first account information and the account information of the second object, and performing account reconciliation according to the unified visual reconciliation view; through the above method, when it is determined that the reconciliation relationship between the first object and the second object is a complex preset relationship, merging the information according to the account merging rule, and then using the unified visual reconciliation view to perform reconciliation, thereby effectively improving the reconciliation efficiency, meeting the needs of different scenarios, and improving the flexibility and accuracy of reconciliation. BRIEF DESCRIPTION OF THE DRAWINGS
[0048] The accompanying drawings herein are incorporated in and constitute a part of the specification, illustrate embodiments consistent with the present application, and together with the description, are used to explain the principles of the present application.
[0049] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.
[0050] Figure 1 A flowchart of the first embodiment of the account reconciliation method of the present application is provided;
[0051] Figure 2 A schematic diagram of a unified visual reconciliation view of the account reconciliation method provided in Example 1 of the present application;
[0052] Figure 3 A flowchart of the second embodiment of the account reconciliation method of the present application is provided;
[0053] Figure 4 This is a schematic diagram of the module structure of the account reconciliation device according to an embodiment of the present application;
[0054] Figure 5 This is a schematic diagram of the device structure of the hardware operating environment involved in the account reconciliation method in the embodiment of the present application.
[0055] The purpose, features and advantages of this application will be further described in conjunction with the embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION
[0056] It should be noted that the execution subject of this embodiment can be a computing service device with data processing, network communication and program running functions, such as a tablet computer, a personal computer, a mobile phone, etc., or an electronic device capable of realizing the above functions, an account reconciliation device, etc. The following takes the account reconciliation device as an example to illustrate this embodiment and the following embodiments.
[0057] Based on this, the present application embodiment provides an account reconciliation method, referring to Figure 1 , Figure 1 This is a flowchart of the first embodiment of the account reconciliation method of the present application.
[0058] In this embodiment, the account reconciliation method includes steps S10 to S40:
[0059] Step S10, determining the reconciliation relationship between the first object and the second object, and when the reconciliation relationship is a preset relationship, respectively pulling the account information of the first object and the account information of the second object according to the account merging rule.
[0060] It should be noted that both the first object and the second object can be banks. For example, the first object is a commercial bank and the second object is a commercial bank. The account to be reconciled in this embodiment can be a Nostro account. The preset relationship includes but is not limited to a one-to-many reconciliation relationship, a many-to-one reconciliation relationship, and a many-to-many reconciliation relationship. When the reconciliation relationship between the first object and the second object is determined to be a preset relationship, it indicates that the reconciliation work at this time is relatively complicated, and the own reconciliation system and third-party reconciliation software cannot meet the reconciliation requirements in the current scenario, that is, the reconciliation method of this embodiment needs to be adopted. Account information includes but is not limited to account flow information, opening balance, and closing balance.
[0061] Further, step S10 includes: obtaining an account entry column of the first object and an account entry column of the second object based on a target account reconciliation relationship configuration module, wherein the target account reconciliation relationship configuration module is composed of an original account reconciliation relationship configuration module and an account column expansion unit; determining the number of first accounts according to the account entry column of the first object and a preset account separator; determining the number of second accounts according to the account entry column of the second object and a preset account separator; determining the reconciliation relationship between the first object and the second object according to the first account number and the second account number; when the first account number and / or the second account number is greater than a preset value, determining that the reconciliation relationship is a preset reconciliation relationship; pulling the account information of the first object according to the account identification information of the first object, and pulling the account information of the second object according to the account identification information of the second object.
[0062] It should be understood that the account entry column refers to a column for entering accounts. Multiple accounts can be entered in the account entry column, and the multiple accounts are separated by a preset account separator, which can be an English comma. In order to expand the account entry column of the first object and the account entry column of the second object, this embodiment adds an account column expansion unit to the original account reconciliation relationship configuration module to facilitate more convenient and accurate extraction of all account information of the object. The first account quantity refers to the total number of all accounts that need to be reconciled in the first object. Similarly, the second account quantity refers to the total number of all accounts that need to be reconciled in the second object.
[0063] It can be understood that the preset value can be 2. When the total number of all accounts that need to be reconciled is greater than the preset value, it indicates that the reconciliation relationship at this time is the preset reconciliation relationship, that is, a one-to-many reconciliation relationship or a many-to-many reconciliation relationship. At the same time, when obtaining the account flows of all parties, the account identification information of the first object of the reconciliation relationship and the account identification information of the second object will be marked to facilitate unified data extraction and matching.
[0064] Step S20, determining the target object whose number of accounts is greater than a preset value according to the reconciliation relationship.
[0065] It can be understood that the target object refers to the object whose number of accounts is greater than a preset value between the first object and the second object. The target object can be at least one of the first object and the second object. For example, when the number of accounts of the first object is greater than a preset value, the first object is determined to be the target object.
[0066] Furthermore, after step S20, it also includes: when the target object is the first object and the second object, respectively merging the account information of the first object and the account information of the second object according to the account merging rule to obtain the first account information and the second account information; setting the first account information to the first area of the preset view, and setting the second account information to the second area of the preset view; generating a new unified visual reconciliation view according to the set areas; and performing account reconciliation according to the new unified visual reconciliation view by executing the target reconciliation script.
[0067] It should be understood that when the target object is determined to be the first object and the second object, it indicates that the reconciliation relationship between the first object and the second object is many-to-many. At this time, the account information of the first object is merged using the account merging rule, and at the same time, the account information of the second object is merged using the account merging rule. For example, the beginning balances and ending balances of multiple accounts of the first object are merged and calculated to obtain the final beginning and ending balances. Similarly, the beginning balances and ending balances of the accounts of the first object are merged and calculated to obtain the final beginning and ending balances.
[0068] It can be understood that the first area can be the left side of the preset view, and the second area can be the right side of the preset view. After the first account information and the second account information are merged, the first account information is set to the first area of the preset view, and the second account information is set to the second area of the preset view, that is, a new unified visual reconciliation view is generated. The target reconciliation script refers to an automatically matched reconciliation script. The target control script can be directly generated according to the actual reconciliation needs of the target user to improve the user experience.
[0069] For example, reference Figure 2 , Figure 2 This is a schematic diagram of the unified visual reconciliation view. Specifically, taking a many-to-many reconciliation relationship as an example, for account information, the unified visual reconciliation view is divided into left and right sides, where the left side is the first area and the right side is the second area. The first area is used to set the first account information and the second area is used to set the second account information. After the settings are completed, a unified visual reconciliation view is generated.
[0070] Step S30, when the target object is the first object, the account information of the first object is merged according to the account merging rule to obtain the first account information.
[0071] It should be understood that when the target object is determined to be the first object, it indicates that the reconciliation relationship between the first object and the second object is many-to-one. At this time, it is necessary to use the account merging rule to merge the account information of the first object into the first account information. For example, account a and account b of the first object are reconciled with account C of the second account.
[0072] Step S40: generating a unified visual reconciliation view according to the first account information and the account information of the second object, and performing account reconciliation according to the unified visual reconciliation view.
[0073] It is understandable that after the account information of the first object is merged into the first account information, a unified visual reconciliation view is generated. At this time, no matter how the reconciliation relationship changes, the following elements will be combined and displayed: the account of the first object, the account of the second object, the beginning balance, the list of unmatched account flow, the list of matched account flow, the ending balance, the total amount of unmatched account flow, and the matched account verification value. It also supports the configuration of which accounts' beginning, end, and account flow to exclude when merging views, which is more flexible.
[0074] Further, step S40 includes: setting the first account information to the first area of the preset view, and setting the account information of the second object to the second area of the preset view; generating a unified visual reconciliation view based on the set first area and the set second area; obtaining the actual reconciliation requirements of the target user; generating a target reconciliation script based on the actual reconciliation requirements; and performing account reconciliation according to the unified visual reconciliation view by executing the target reconciliation script.
[0075] It should be understood that the target reconciliation script refers to a template generated based on the script generation template according to the actual reconciliation needs of the target user. The target reconciliation script can perform reconciliation according to the actual reconciliation needs of the target user, thereby effectively improving the reconciliation efficiency and accuracy, as well as improving the user experience. The target user may be a staff member of the financial department within the bank. After generating the target reconciliation script, the target reconciliation script is executed. At this time, a unified visual reconciliation view can be used for matching to achieve account reconciliation between the first object and the second object.
[0076] This embodiment determines the reconciliation relationship between the first object and the second object, and when the reconciliation relationship is a preset relationship, pulls the account information of the first object and the account information of the second object respectively according to the account merging rule; determines the target object whose account number is greater than the preset value according to the reconciliation relationship; when the target object is the first object, merges the account information of the first object according to the account merging rule to obtain the first account information; generates a unified visual reconciliation view according to the first account information and the account information of the second object, and performs account reconciliation according to the unified visual reconciliation view; through the above method, when it is determined that the reconciliation relationship between the first object and the second object is a complex preset relationship, merges the information according to the account merging rule, and then uses the unified visual reconciliation view to perform reconciliation, thereby effectively improving the reconciliation efficiency, meeting the needs of different scenarios, and improving the flexibility and accuracy of reconciliation.
[0077] Based on the first embodiment of the present application, in the second embodiment of the present application, the same or similar contents as those in the above-mentioned embodiment 1 can be referred to the above introduction, and will not be repeated in the following. Figure 3 , step S30 includes steps S301 to S305:
[0078] Step S301, when the target object is the first object, determine the current account record field.
[0079] It should be noted that the current account record fields refer to the fields recorded in the account in the current scenario. The current account record fields include but are not limited to IS_GET_ENTRY (whether to pull account flow), IS_GET_OPEN_BLC (whether to calculate the beginning balance when merging), IS_GET_CLS_BLC (whether to calculate the ending balance when merging), etc.
[0080] Step S302: determining a target merge object according to the current account record field.
[0081] It can be understood that the target merge object refers to the object for information merging. For example, when the current account record field is determined to be IS_GET_OPEN_BLC, it indicates that the ending balance needs to be calculated during the merge. At this time, the target merge object is the ending balance.
[0082] Step S303: determining a target merging method according to the target merging object.
[0083] It should be understood that the target merging method refers to a method for merging information, which includes but is not limited to a sum merging method, a direct merging method, etc., and there are differences in the merging methods used for different merging objects.
[0084] Step S304: Generate account merging rules according to the target merging object and the target merging method.
[0085] It is understandable that since the account merging rules are attached to the account records, it is necessary to generate the account merging rules based on the target merging object determined by the current account record field and the target merging method determined in turn. The account merging rules can be used to merge the opening balances of multiple accounts. For example, if an account is configured with IS_GET_OPEN_BLC=0, the opening balance of this account will not be calculated into the final opening balance.
[0086] Step S305: Merge the account information of the first object according to the account merging rule to obtain first account information.
[0087] It should be understood that after the account merging rule is generated, the account information of the first object is merged into the first account information using the account merging rule.
[0088] Further, step S305 includes: obtaining a first beginning balance, a first ending balance and first account flow information according to the account information of the first object; generating a first account flow list according to the first account flow information; summing and merging the first beginning balance and the first ending balance respectively according to the account merging rule; and directly merging the first account flow list according to the account merging rule.
[0089] It can be understood that after pulling the account information of the first object, the first account flow list is generated according to the first account flow information in the account information of the first object. For the first beginning balance and the first ending balance, the information is merged by a summation and merging method. For the first account flow list, the information is merged by a direct merging method. In addition, if the target object is the first object and the second object, the information needs to be merged in the same way. Specifically, the second beginning balance, the second ending balance and the second account flow information are obtained according to the account information of the second object, and the first account flow list is generated according to the second account flow information. Then, for the second beginning balance and the second ending balance, the information is merged by a summation and merging method. For the second account flow list, the information is merged by a direct merging method.
[0090] This embodiment determines the current account record field when the target object is the first object; determines the target merge object according to the current account record field; determines the target merge method according to the target merge object; generates an account merge rule according to the target merge object and the target merge method; merges the account information of the first object according to the account merge rule to obtain the first account information; through the above method, when it is determined that the target object is the first object, it indicates that the reconciliation relationship between the first object and the second object is a many-to-one reconciliation relationship, and the account information of the first object needs to be merged at this time, and before the merging, the account merge rule is generated according to the current account record field, and then the information is merged using the account merge rule, thereby effectively improving the accuracy of the information merging.
[0091] This application also provides an account reconciliation device, please refer to Figure 4 , the account reconciliation device comprises:
[0092] The pulling module 10 is used to determine the reconciliation relationship between the first object and the second object, and when the reconciliation relationship is a preset relationship, respectively pull the account information of the first object and the account information of the second object according to the account merging rule.
[0093] The determination module 20 is used to determine the target object whose number of accounts is greater than a preset value according to the reconciliation relationship.
[0094] The merging module 30 is used to merge the account information of the first object according to the account merging rule to obtain the first account information when the target object is the first object.
[0095] The generating module 40 is used to generate a unified visual reconciliation view according to the first account information and the account information of the second object, and perform account reconciliation according to the unified visual reconciliation view.
[0096] This embodiment determines the reconciliation relationship between the first object and the second object, and when the reconciliation relationship is a preset relationship, pulls the account information of the first object and the account information of the second object respectively according to the account merging rule; determines the target object whose account number is greater than the preset value according to the reconciliation relationship; when the target object is the first object, merges the account information of the first object according to the account merging rule to obtain the first account information; generates a unified visual reconciliation view according to the first account information and the account information of the second object, and performs account reconciliation according to the unified visual reconciliation view; through the above method, when it is determined that the reconciliation relationship between the first object and the second object is a complex preset relationship, merges the information according to the account merging rule, and then uses the unified visual reconciliation view to perform reconciliation, thereby effectively improving the reconciliation efficiency, meeting the needs of different scenarios, and improving the flexibility and accuracy of reconciliation.
[0097] The account reconciliation device provided by the present application adopts the account reconciliation method in the above embodiment, which can solve the technical problem of low efficiency of reconciliation in the prior art. Compared with the prior art, the beneficial effects of the account reconciliation device provided by the present application are the same as the beneficial effects of the account reconciliation method provided by the above embodiment, and other technical features in the account reconciliation device are the same as the features disclosed in the above embodiment method, which will not be repeated here.
[0098] In one embodiment, the pulling module 10 is also used to obtain the account entry column of the first object and the account entry column of the second object based on the target account reconciliation relationship configuration module, wherein the target account reconciliation relationship configuration module is composed of an original account reconciliation relationship configuration module and an account column expansion unit; determine the number of first accounts according to the account entry column of the first object and a preset account separator; determine the number of second accounts according to the account entry column of the second object and the preset account separator; determine the reconciliation relationship between the first object and the second object according to the first account number and the second account number; when the first account number and / or the second account number is greater than a preset value, determine that the reconciliation relationship is a preset reconciliation relationship; pull the account information of the first object according to the account identification information of the first object, and pull the account information of the second object according to the account identification information of the second object.
[0099] In one embodiment, the determination module 20 is further used to, when the target object is the first object and the second object, merge the account information of the first object and the account information of the second object according to the account merging rule to obtain the first account information and the second account information; set the first account information to the first area of the preset view, and set the second account information to the second area of the preset view; generate a new unified visual reconciliation view according to the set areas; and perform account reconciliation according to the new unified visual reconciliation view by executing the target reconciliation script.
[0100] In one embodiment, the merging module 30 is further used to determine the current account record field when the target object is the first object; determine the target merging object according to the current account record field; determine the target merging method according to the target merging object; generate an account merging rule according to the target merging object and the target merging method; merge the account information of the first object according to the account merging rule to obtain the first account information.
[0101] In one embodiment, the merging module 30 is further used to obtain a first beginning balance, a first ending balance and a first account flow information according to the account information of the first object; generate a first account flow list according to the first account flow information; sum and merge the first beginning balance and the first ending balance respectively according to the account merging rule; and directly merge the first account flow list according to the account merging rule.
[0102] In one embodiment, the generation module 40 is also used to set the first account information to the first area of the preset view, and set the account information of the second object to the second area of the preset view; generate a unified visual reconciliation view based on the set first area and the set second area; obtain the actual reconciliation requirements of the target user; generate a target reconciliation script based on the actual reconciliation requirements; and perform account reconciliation according to the unified visual reconciliation view by executing the target reconciliation script.
[0103] The present application provides an account reconciliation device, which includes: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the account reconciliation method in the above-mentioned embodiment 1.
[0104] Reference below Figure 5 , which shows a schematic diagram of the structure of an account reconciliation device suitable for implementing the embodiment of the present application. The account reconciliation device in the embodiment of the present application may include but is not limited to mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (Portable Application Descriptions), PMPs (Portable Media Players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Figure 5 The account reconciliation device shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.
[0105] like Figure 5As shown, the account reconciliation device may include a processing device 1001 (e.g., a central processing unit, a graphics processor, etc.), which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM: Read Only Memory) 1002 or a program loaded from a storage device 1003 to a random access memory (RAM: Random Access Memory) 1004. In RAM1004, various programs and data required for the operation of the account reconciliation device are also stored. The processing device 1001, ROM1002, and RAM1004 are connected to each other through a bus 1005. An input / output (I / O) interface 1006 is also connected to the bus. Generally, the following systems can be connected to the I / O interface 1006: an input device 1007 including, for example, a touch screen, a touch pad, a keyboard, a mouse, an image sensor, a microphone, an accelerometer, a gyroscope, etc.; an output device 1008 including, for example, a liquid crystal display (LCD: Liquid Crystal Display), a speaker, a vibrator, etc.; a storage device 1003 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 1009. The communication device 1009 can allow the account reconciliation device to communicate with other devices wirelessly or by wire to exchange data. Although the figure shows an account reconciliation device with various systems, it should be understood that it is not required to implement or have all the systems shown. More or fewer systems can be implemented or have alternatively.
[0106] In particular, according to the embodiments disclosed in the present application, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present application include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication device, or installed from a storage device 1003, or installed from a ROM 1002. When the computer program is executed by the processing device 1001, the above-mentioned functions defined in the method of the embodiment disclosed in the present application are executed.
[0107] The account reconciliation device provided by the present application adopts the account reconciliation method in the above embodiment, which can solve the technical problem of low efficiency of reconciliation in the prior art. Compared with the prior art, the beneficial effects of the account reconciliation device provided by the present application are the same as the beneficial effects of the account reconciliation method provided by the above embodiment, and the other technical features in the account reconciliation device are the same as the features disclosed in the method of the previous embodiment, which will not be repeated here.
[0108] It should be understood that the various parts disclosed in this application can be implemented by hardware, software, firmware or a combination thereof. In the description of the above embodiments, specific features, structures, materials or characteristics can be combined in any one or more embodiments or examples in a suitable manner.
[0109] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.
[0110] The present application provides a computer-readable storage medium having computer-readable program instructions (ie, computer programs) stored thereon, and the computer-readable program instructions are used to execute the account reconciliation method in the above-mentioned embodiment.
[0111] The computer-readable storage medium provided in the present application may be, for example, a USB flash drive, but is not limited to electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, systems or devices, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM: Random Access Memory), a read-only memory (ROM: Read Only Memory), an erasable programmable read-only memory (EPROM: Erasable Programmable ReadOnly Memory or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM: CD-Read Only Memory), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this embodiment, the computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, system or device. The program code contained on the computer-readable storage medium may be transmitted using any appropriate medium, including but not limited to: wires, optical cables, RF (Radio Frequency: Radio Frequency), etc., or any suitable combination of the above.
[0112] The computer-readable storage medium may be included in the account reconciliation device; or may exist independently without being assembled into the account reconciliation device.
[0113] Computer program code for performing the operations of the present application may be written in one or more programming languages or a combination thereof, including object-oriented programming languages such as Java, Smalltalk, C++, and conventional procedural programming languages such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).
[0114] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present application. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0115] The modules involved in the embodiments described in this application may be implemented by software or hardware, wherein the name of the module does not constitute a limitation on the unit itself in some cases.
[0116] The readable storage medium provided in the present application is a computer-readable storage medium, which stores computer-readable program instructions (i.e., computer programs) for executing the above-mentioned account reconciliation method, and can solve the technical problem of low efficiency of reconciliation in the prior art. Compared with the prior art, the beneficial effects of the computer-readable storage medium provided in the present application are the same as the beneficial effects of the account reconciliation method provided in the above-mentioned embodiment, and will not be repeated here.
[0117] The present application also provides a computer program product, including a computer program, which implements the steps of the above-mentioned account reconciliation method when executed by a processor.
[0118] The computer program product provided by the present application can solve the technical problem of low efficiency of reconciliation in the prior art. Compared with the prior art, the beneficial effects of the computer program product provided by the present application are the same as the beneficial effects of the account reconciliation method provided by the above embodiment, which will not be repeated here.
[0119] The above descriptions are only some embodiments of the present application, and are not intended to limit the patent scope of the present application. All equivalent structural changes made using the contents of the present application specification and drawings under the technical concept of the present application, or direct / indirect applications in other related technical fields are included in the patent protection scope of the present application.
Claims
1. An account reconciliation method, characterized in that: The method comprises: Determine a reconciliation relationship between the first object and the second object, and when the reconciliation relationship is a preset relationship, respectively pull the account information of the first object and the account information of the second object according to the account merging rule; Determine, based on the reconciliation relationship, a target object whose number of accounts is greater than a preset value; When the target object is a first object, merging the account information of the first object according to the account merging rule to obtain first account information; A unified visual reconciliation view is generated according to the first account information and the account information of the second object, and account reconciliation is performed according to the unified visual reconciliation view.
2. The method according to claim 1, characterized in that The step of determining the reconciliation relationship between the first object and the second object, and respectively pulling the account information of the first object and the account information of the second object according to the account merging rule when the reconciliation relationship is a preset relationship, includes: Acquire the account entry column of the first object and the account entry column of the second object based on the target account reconciliation relationship configuration module, wherein the target account reconciliation relationship configuration module is composed of an original account reconciliation relationship configuration module and an account column expansion unit; Determine the first account quantity according to the account entry column of the first object and the preset account separator; Determine the number of second accounts according to the account entry column of the second object and the preset account separator; Determine a reconciliation relationship between a first object and a second object according to the first account quantity and the second account quantity; When the number of the first accounts and / or the number of the second accounts is greater than a preset value, determining the reconciliation relationship to be a preset reconciliation relationship; The account information of the first object is pulled according to the account identification information of the first object, and the account information of the second object is pulled according to the account identification information of the second object.
3. The method according to claim 1, characterized in that When the target object is the first object, the step of merging the account information of the first object according to the account merging rule to obtain the first account information includes: When the target object is the first object, determining a current account record field; Determine the target merge object according to the current account record field; Determining a target merging method according to the target merging object; Generate account consolidation rules according to the target consolidation object and the target consolidation method; The account information of the first object is merged according to the account merging rule to obtain first account information.
4. The method according to claim 3, characterized in that The step of merging the account information of the first object according to the account merging rule to obtain the first account information includes: Obtaining a first beginning balance, a first ending balance, and first account flow information according to the account information of the first object; Generate a first account transaction list according to the first account transaction information; According to the account consolidation rule, the first beginning balance and the first ending balance are summed and consolidated respectively; The first account transaction list is directly merged according to the account merging rule.
5. The method according to any one of claims 1 to 4, characterized in that The step of generating a unified visual reconciliation view according to the first account information and the account information of the second object, and performing account reconciliation according to the unified visual reconciliation view includes: Setting the first account information to a first area of a preset view, and setting the account information of the second object to a second area of the preset view; Generate a unified visual reconciliation view according to the set first area and the set second area; Obtain the actual reconciliation needs of target users; Generate a target reconciliation script according to the actual reconciliation requirements; Account reconciliation is performed according to the unified visual reconciliation view by executing the target reconciliation script.
6. The method according to claim 1, characterized in that After the step of determining the target object whose number of accounts is greater than a preset value according to the reconciliation relationship, the method further includes: When the target object is a first object and a second object, the account information of the first object and the account information of the second object are respectively merged according to an account merging rule to obtain first account information and second account information; Setting the first account information to a first area of a preset view, and setting the second account information to a second area of the preset view; Generate a new unified visual reconciliation view based on the set areas; Account reconciliation is performed based on the new unified visual reconciliation view by executing the target reconciliation script.
7. An account reconciliation device, characterized in that: The device comprises: A pulling module, used to determine the reconciliation relationship between the first object and the second object, and when the reconciliation relationship is a preset relationship, respectively pull the account information of the first object and the account information of the second object according to the account merging rule; A determination module, configured to determine, based on the reconciliation relationship, a target object whose number of accounts is greater than a preset value; a merging module, configured to merge the account information of the first object according to the account merging rule to obtain first account information when the target object is the first object; A generation module is used to generate a unified visual reconciliation view according to the first account information and the account information of the second object, and perform account reconciliation according to the unified visual reconciliation view.
8. An account reconciliation device, characterized in that: The device comprises: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program is configured to implement the steps of the account reconciliation method according to any one of claims 1 to 6.
9. A storage medium, characterized in that: The storage medium is a computer-readable storage medium, and a computer program is stored on the storage medium. When the computer program is executed by a processor, the steps of the account reconciliation method according to any one of claims 1 to 6 are implemented.
10. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the steps of the account reconciliation method according to any one of claims 1 to 6 are implemented.
Citation Information
Cited By
Transaction application and fund flow account checking method, system and device and medium
CN117952761A
