Disclosure of Invention
On the basis, it is necessary to provide a multi-mechanism account checking method, a multi-mechanism account checking system, a computer device and a storage medium for the defects that the traditional account checking system only supports a single mechanism, account checking results are inconsistent in each core, the flow of checking is checked item by item, the efficiency is low, account checking elements are single, and the like.
A multi-mechanism account checking method comprises the following specific steps:
s1: analyzing the standard reconciliation file format; the standard reconciliation file format is a standard format generated after the reconciliation file provided by the reconciliation party is analyzed;
s2: configuring a reconciliation model according to the standard reconciliation file format, and acquiring a reconciliation result;
s3: and dynamically configuring a reconciliation result file according to the reconciliation result.
In one embodiment, the step S1 includes:
s101: generating a task list to be analyzed into a standard reconciliation file format, selecting a service system needing reconciliation, setting an uploading operation interface at the front end of the service system, uploading the reconciliation file needing reconciliation by using the uploading operation interface, and generating the task list to be analyzed into the standard file format in a mode of interface triggering or timing task triggering;
s102: setting an import interface at the front end of the business system, importing a template in a standard reconciliation file format into the business system by using the import interface, and storing the template in a memory;
s103: acquiring corresponding configuration required by a required standard reconciliation format from a reconciliation file to be reconciled according to a standard reconciliation file template stored in a memory;
s104, acquiring a realization logic list for analyzing the standard reconciliation file format according to the task list to be analyzed into the standard reconciliation file format and the configuration;
s105: and executing the implementation logic list, analyzing the account checking file, and acquiring a standard account checking file format.
In one embodiment, the step S2 includes:
s201: generating a reconciliation task list, and generating the reconciliation task list in a timing task triggering mode according to the analyzed standard reconciliation file format;
s202: the account checking model is imported into the business system by using an import interface at the front end of the business system and is stored in a memory of the business system;
s203: selecting a corresponding account checking model according to the generated account checking task list, and acquiring a configuration corresponding to the selected account checking model from the account checking task list;
s204: judging whether a rolling reconciliation mode is adopted or not according to the obtained reconciliation model and the configuration;
s205: and according to the judgment result of the step S204, checking the account by inquiring the account checking task list and acquiring an account checking result.
In one embodiment, the reconciliation model comprises a double-reconcilier full-volume reconciliation, a double-reconcilier rolling reconciliation and a three-reconcilier full-volume reconciliation.
In one embodiment, the step S3 includes:
s301: generating a task list of a dynamic configuration reconciliation result file, and generating the task list of the dynamic configuration reconciliation result file through a timing task triggering mode according to the obtained reconciliation result;
s302: setting an input interface in the business system, and inputting a format requirement of a reconciliation result file of a receiving reconciliation file side by using the input interface;
s303: according to the format requirement, acquiring configuration corresponding to the format requirement from the reconciliation result file;
s304: and dynamically configuring the reconciliation result file and converting the format of the reconciliation result file by inquiring the task list of the dynamically configured reconciliation result file and the acquired configuration, so as to acquire the reconciliation result file.
In one embodiment, the multi-institution reconciliation method further comprises the steps of acquiring multi-institution reconciliation permission, wherein the acquiring multi-institution reconciliation permission is used for registering institution numbers, and the method comprises the following steps: registering the organization number by calling an interface parameter of a service system, wherein the interface parameter is an unique identification ID of the organization;
and the account checking party acquires the organization number after the registration is finished and the unique organization name is marked by the organization generated in the registration request.
In one embodiment, the storage comprises NAS storage and cloud storage.
Based on the same technical concept, the invention also provides a multi-mechanism reconciliation system, which comprises an analysis unit, a reconciliation unit and a dynamic configuration reconciliation result file unit;
the analysis unit is used for analyzing a standard reconciliation file format, and the standard reconciliation file format is used for analyzing a reconciliation file provided by a reconciliation party;
the account checking unit is used for configuring an account checking model according to the standard account checking file format and acquiring an account checking result;
and the dynamic configuration reconciliation result file unit is used for dynamically configuring the format of the reconciliation result file according to the reconciliation result.
Based on the same technical concept, the invention further provides a computer device, which comprises a memory and a processor, wherein the memory stores computer readable instructions, and the computer readable instructions, when executed by the processor, cause the processor to execute the steps of the multi-mechanism reconciliation method.
Based on the same technical concept, the present invention also provides a storage medium storing computer-readable instructions, which, when executed by one or more processors, cause the one or more processors to perform the steps of the above-mentioned multi-mechanism reconciliation method.
According to the multi-mechanism reconciliation method, the system, the computer equipment and the storage medium, the task list to be analyzed into the standard reconciliation file format is generated, the standard reconciliation file format is imported into the business system by utilizing the import interface on the business system, the corresponding configuration required by the standard reconciliation file format is acquired from the reconciliation file to be reconciled according to the standard reconciliation file format, the path for analyzing the standard reconciliation file format and the realization logic list corresponding to the path are generated through the task list and the configuration, and the realization logic list is executed to acquire the standard reconciliation file format. And generating a reconciliation task list through a timing task triggering mode according to the analyzed standard reconciliation file format, importing a reconciliation model at the front end of the business system, acquiring the reconciliation model and the required configuration according to the reconciliation task list, completing the reconciliation and acquiring a reconciliation result. And generating a task list of a dynamic configuration reconciliation file format by a timing task triggering mode, importing a requirement required by the party receiving the reconciliation file at the front end of the business system, acquiring the configuration, finishing the dynamic configuration reconciliation result file, converting the format of the reconciliation result file, and acquiring the reconciliation result file. Compared with the prior art, the technical scheme has the advantages that when account checking is needed, the account checking file provided by a client can be analyzed into a standard account checking file format according to the multi-mechanism account checking method as long as the corresponding account checking file is provided, an obtained account checking model is obtained according to the standard account checking file format, so that account checking is completed, dynamic output is realized according to the account checking result, the account checking workload is reduced, and the account checking efficiency is improved.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
As shown in fig. 1, an embodiment of the present invention provides a multi-institution reconciliation method, where the multi-institution reconciliation method may include the following steps:
step S1: analyzing the standard reconciliation file format; the method comprises the steps that an account checking file provided by a client is obtained at the front end of the business system, a task list to be analyzed into a standard account checking file format is generated, corresponding configuration is obtained through an imported standard account checking file format template, a path for analyzing the standard account checking file format and a realization logic list corresponding to the path are generated through the task list and the configuration, and the realization logic list is executed to obtain the standard account checking file format;
step S2: configuring a reconciliation model according to the standard reconciliation file format, and acquiring a reconciliation result; generating a reconciliation task list through a timing task triggering mode according to the analyzed standard reconciliation file format, importing a reconciliation model at the front end of the business system, acquiring the reconciliation model and required configuration according to the reconciliation task list, completing reconciliation and acquiring a reconciliation result;
step S3: according to the account checking result, dynamically configuring an account checking result file; and generating a task list of a dynamic configuration reconciliation file format by a timing task triggering mode, importing a format requirement required by the party receiving the reconciliation file at the front end of the business system, acquiring configuration, finishing the dynamic configuration reconciliation result file, converting the format of the reconciliation file, and acquiring the reconciliation result file.
Fig. 2 is a flowchart of parsing into a standard reconciliation file format according to an embodiment of the present invention, and as shown in fig. 2, the parsing process in step S1 includes generating a task list to be parsed into the standard reconciliation file format, importing the standard reconciliation file format, generating a path for parsing the standard reconciliation file format and an implementation logic list corresponding to the path, and executing the implementation logic list to obtain the standard reconciliation file format. Step S1 may include the following steps:
step S101: generating a task list to be analyzed into a standard reconciliation file format, selecting a service system needing reconciliation, setting an uploading operation interface at the front end of the service system, uploading the reconciliation file needing reconciliation by using the uploading operation interface, and generating the task list to be analyzed into the standard reconciliation file format by using an interface triggering or timing task triggering mode.
The interface triggering mode is a mode of calling triggering by using a peripheral interface. For example, when an external person sends a request, after the multi-mechanism reconciliation method receives the request, a task is triggered according to the request to generate a task list to be parsed into a standard reconciliation file format.
The timing task triggering mode is that the client appoints time. For example, the client reserves seven morning spots, and the multi-mechanism reconciliation method automatically triggers tasks at the seven morning spots reserved to generate a task list to be analyzed into a standard reconciliation file format, so that the tasks do not need to be triggered by using a peripheral interface.
Step S102: setting an import interface at the front end of the business system, importing a standard reconciliation file format template into the business system by using the import interface, and storing the template in a memory; the storage comprises NAS storage and cloud storage.
The NAS, namely a Network Attached Storage (Network Attached Storage), is a data transmission implemented by the Network Storage based on a standard Network protocol. The data is taken as a center, the storage equipment and the server are thoroughly separated, and the data is managed in a centralized manner, so that the bandwidth is released, the performance is improved, the total cost of ownership is reduced, and the investment is protected.
The cloud storage is a concept extended and developed from a cloud computing concept, is an emerging network storage technology, and is a system which integrates various different types of storage devices in a network through application software to cooperatively work only through functions such as cluster application, network technology or a distributed file system and the like, and provides data storage and service access functions to the outside.
Step S103: acquiring corresponding configuration required by a standard reconciliation file format from a reconciliation file required to be reconciled according to a standard reconciliation file format template stored in a memory; the configuration comprises the convention of timing task trigger time, the convention of a reconciliation file format and whether the first line in the reconciliation detail has the total number of strokes and the total number of bars; and a convention for delimiters for each field in the ledger detail.
Step S104: acquiring a logic list for realizing the analysis of the standard reconciliation file format according to the task list to be analyzed into the standard reconciliation file format and the configuration, wherein the logic list comprises: the business system checks whether the account checking file is generated by using the account checking method, and if the account checking file is not generated, the multi-mechanism account checking method stops working; and if the reconciliation file is generated, downloading the reconciliation file to a cloud storage according to the generated reconciliation file, uploading the reconciliation file to an NAS storage for file sharing and data backup, and analyzing the reconciliation file to be analyzed and converting the reconciliation file into a standard reconciliation file format according to the acquired configuration and the standard reconciliation file format. The sequence for implementing the execution logic list comprises informing a client to generate a reconciliation file required to be reconciled;
step S105: executing the implementation logic list for analyzing the standard reconciliation file format, analyzing the reconciliation file, and acquiring the standard reconciliation file format, wherein the implementation logic list comprises the following steps: generating a task list to be analyzed into a standard reconciliation file format in a service system, importing the standard reconciliation file format, generating a path for analyzing the reconciliation file needing reconciliation into the standard reconciliation file format, executing a realization logic list for analyzing the standard reconciliation file format, analyzing the reconciliation file, and acquiring the standard reconciliation file format.
Fig. 3 is a flowchart of obtaining a reconciliation result in an embodiment of the present invention, and as shown in fig. 3, step S2 is to configure a reconciliation model according to the standard reconciliation file format to obtain a reconciliation result; and generating a reconciliation task list through a timing task triggering mode according to the analyzed standard reconciliation file format, importing a reconciliation model at the front end of the business system, acquiring the reconciliation model and the required configuration according to the reconciliation task list, completing the reconciliation and acquiring a reconciliation result. Step S2 may include the following steps:
step S201: generating a reconciliation task list, and generating the reconciliation task list in a timing task triggering mode according to the analyzed standard reconciliation file format; the timed task triggering mode needs to check accounts according to the time appointed by the client. For example, when a client reserves 7 am, the multi-mechanism reconciliation method can automatically trigger a reconciliation task at the reserved 7 am, so that a peripheral interface is not needed to trigger the task.
Step S202: and importing the account checking model into the business system by using an import interface at the front end of the business system, and placing the account checking model in a memory for storage. The memory comprises an NAS memory, a leading-in interface is arranged on the service system, the account checking model is led into the service system by using the leading-in interface, and the account checking model is placed in the NAS memory for storage.
Step S203: selecting a corresponding account checking model according to the generated account checking task list, and acquiring configuration corresponding to the selected account checking model from the account checking task list, wherein the configuration comprises an agreement on the trigger time of a timing task, an agreement on the format of an account checking file, and whether the first line in the account checking detail has the total number of strokes and the total number of bars; and a convention for delimiters for each field in the ledger detail. And after an account checking model is selected according to the generated account checking task list, acquiring corresponding configuration from the account checking task list according to information such as timing task trigger time, total number and the like.
Step S204: judging whether a rolling reconciliation mode is adopted or not according to the obtained reconciliation model and the configuration; the rolling reconciliation mode is determined by the obtained reconciliation model and configuration, and can be started only when the previous reconciliation is completely finished if the rolling reconciliation mode is adopted; if the rolling reconciliation mode is not adopted, plug-ins with batch insertion function need to be called for warehousing operation, and warehousing operation can be carried out in batches according to a certain quantity. For example, 50 accounting records may be inserted into the warehouse for processing each time. After all the files are inserted into the database, the batch number is used for checking whether the total number in the files is consistent with the total number in the database or not, and if not, error reporting processing is carried out.
Step S205: and according to the account checking model, the configuration and the judgment result of whether a rolling account checking mode is adopted, the account checking task list is inquired, the account checking is completed, and an account checking result is obtained. And after determining whether a rolling reconciliation mode is used or not according to the model and the configuration, reconciliation is carried out by utilizing the reconciliation model so as to obtain a reconciliation result. And after the account checking result is obtained, synchronizing the account checking result into the list table according to the account checking configuration, and updating the state of the collection table. The list represents that the records needing account checking in the aggregation table are combined into one record. And in the aggregation table, the data in the table is in one-to-one correspondence with the data in the reconciliation file.
For example, there are two records in the aggregation table, record A: serial number (0001), amount (100), reference party; b, recording: the serial number (0001), the amount (101) and the account checking party give a record according to the A record and the B record, and the list table gives the account checking, namely the serial number (0001) and the amount (100). And when the amounts in the A record and the B record are different, the multi-mechanism account checking method carries out remark, and the remark is 'please find the reason and process'.
Fig. 4 is a schematic diagram of a reconciliation model in an embodiment of the present invention, and as shown in fig. 4, the reconciliation model includes a double-reconciliation-side full-volume reconciliation, a double-reconciliation-side rolling reconciliation, and a three-reconciliation-side full-volume reconciliation.
Specifically, the double-reconciliation side full-volume reconciliation is that the client a and the client B provide full-volume records every day according to the appointed time and then summarize the records of the client a and the client B. For example, customer A provides a serial number (0002), a monetary amount (2000); the client B provides the serial number (0003) and the amount (3000), and the multi-mechanism reconciliation method can record and reconcile the total amount according to the information provided by the client A and the client B.
Specifically, the rolling reconciliation of the double reconciliation parties comprises the following specific steps: acquiring a reconciliation sequence number, wherein the reconciliation sequence number can determine whether the reconciliation sequence number needs to be provided according to the requirements of the multi-mechanism reconciliation method; discarding the pre-day doubt data; synchronizing the account checking result into an account checking list; for example, the client a chooses to provide the record of the full amount of reconciliation according to the reserved time, while the client B cannot provide the record of the full amount of reconciliation according to the reserved time, and the record which needs to be provided today may need to be delayed to be provided tomorrow.
Specifically, the three-account checking party full-amount account checking is used in the situation that the number of clients needing account checking is large, in the situation, the three-position clients needing account checking are put together to be grouped for account checking, the three-position clients provide the full-amount account checking records according to the reserved time for account checking, and finally the account checking results are recorded together.
Fig. 5 is a flowchart of acquiring multi-institution reconciliation permission in an embodiment of the present invention, and as shown in fig. 5, step S4 is to acquire multi-institution reconciliation permission for the multi-institution reconciliation method, where the acquiring multi-institution reconciliation permission is used for registering an institution number and acquiring reconciliation permission. Step S4 may include the following steps:
step S401: and registering by calling an interface parameter in the multi-mechanism reconciliation method, wherein the interface parameter is a mechanism unique identification ID which consists of numbers and letters.
Step S402: after the account checking party completes the registration link in the multi-mechanism account checking method, the multi-mechanism account checking method provides the distributed structure number, the mechanism unique mark and the mechanism name in the original message request. The owner of the organization number is the multi-organization reconciliation method, and the owner of the organization name is the name of the client, and is input by Chinese characters and used for explaining and explaining the unique mark.
For example, a company needs to be checked out, and first the company needs to provide three pieces of information, namely, the unique identifier of the organization: abcd0011, if the company does not provide the corresponding unique mechanism marking information, the multi-mechanism reconciliation method is automatically distributed; the name of the organization is as follows: XXX Ltd; if the company is the third customer that the multi-institution reconciliation method receives, the multi-institution reconciliation method will assign a reconciliation institution number to the company, with institution number 000001; thus, the following three pieces of information, namely unique labels, can be obtained: abcd 0011; the name of the organization is as follows: XXX Ltd; agency number 000001.
Fig. 6 is a flowchart of dynamically configuring a reconciliation result file in an embodiment of the present invention, and as shown in fig. 6, step S3 is that, according to the reconciliation result, dynamically configuring the reconciliation result file includes: and generating a task list of a dynamic configuration reconciliation file format by a timing task triggering mode, importing a format requirement required by the party receiving the reconciliation file at the front end of the business system, acquiring a configuration corresponding to the format requirement, finishing the dynamic configuration reconciliation result file, converting the format of the reconciliation result file, and acquiring the reconciliation result file. Step S3 may include the following steps:
step S301: and generating a task list of the dynamic configuration reconciliation result file, and generating the task list of the dynamic configuration reconciliation result file through a timing task triggering mode according to the obtained reconciliation result.
The timing task triggering mode is that the client appoints time. For example, if the client reserves 7 am, the multi-mechanism reconciliation method will automatically trigger the reconciliation task at 7 am of the reservation, so that the task does not need to be triggered by using the peripheral interface.
Step S302: setting an input interface in the business system, and inputting a format requirement of a reconciliation result file of a receiving reconciliation file side by using the input interface; the format requirements comprise a line format requirement, a sending organ, a sending character number and the like.
Step S303: according to the format requirement, acquiring the configuration corresponding to the format requirement from the reconciliation result file; the configuration comprises an agreement on the trigger time of the timing task, an agreement on the format of the account checking file, and whether the first line in the account checking detail has the total number of strokes and the total number of bars; and a convention for delimiters for each field in the ledger detail.
Step S304: and dynamically configuring the reconciliation result file and converting the format of the reconciliation result file by inquiring the task list of the dynamically configured reconciliation result file and the acquired configuration, so as to acquire the reconciliation result file. After the account checking result file is dynamically configured, the multi-mechanism account checking method checks whether account checking on the current day is finished; if the account checking on the current day is finished, one or more end files can be generated according to the configuration and the requirements of the client; and if the account checking of the current day is not played, the multi-mechanism account checking method stops, and the process is ended. The multi-mechanism reconciliation method generates a manifest file format for the reconciliation result, wherein the manifest file format is that the reconciliation file of the client can complete the reconciliation in the reconciliation model, and finally generates a corresponding reconciliation list.
Based on the same technical concept, the invention also provides a multi-mechanism reconciliation system, as shown in fig. 7, which comprises an analysis unit, a reconciliation unit and a dynamic configuration reconciliation result file unit;
specifically, the parsing unit is configured to parse a standard reconciliation file format, where the standard reconciliation file format is a parsing of a reconciliation file provided by a reconciliation party;
specifically, the reconciliation unit is configured to configure a reconciliation model according to the standard reconciliation file format, and obtain a reconciliation result;
specifically, the dynamic configuration reconciliation result file unit is configured to dynamically configure a format of a reconciliation result file according to a reconciliation result.
Based on the same technical concept, the invention also provides a computer device, which comprises a memory and a processor, wherein the memory stores computer readable instructions, and the computer readable instructions, when executed by the processor, cause the processor to execute the steps of the multi-mechanism reconciliation method. The specific steps of the multi-mechanism account checking method comprise: the method comprises the steps of generating a task list to be analyzed into a standard reconciliation file format, utilizing an importing interface on a service system to import a standard reconciliation file format template into the service system, acquiring corresponding configuration required by the standard reconciliation file format from a reconciliation file to be reconciled according to the standard reconciliation file format template, generating a path for analyzing the standard reconciliation file format and a realization logic list corresponding to the path according to the task list and the configuration, and executing the realization logic list to acquire the standard reconciliation file format. And generating a reconciliation task list through a timing task triggering mode according to the analyzed standard reconciliation file format, importing a reconciliation model at the front end of the business system, acquiring the reconciliation model and the required configuration according to the reconciliation task list, completing the reconciliation and acquiring a reconciliation result. And generating a task list of a dynamic configuration reconciliation file format by a timing task triggering mode, importing a format requirement required by the party receiving the reconciliation file at the front end of the business system, acquiring configuration, finishing the dynamic configuration reconciliation result file, converting the format of the reconciliation result file, and acquiring the reconciliation result file.
Based on the same technical concept, the present invention also provides a storage medium storing computer-readable instructions, which, when executed by one or more processors, cause the one or more processors to perform the steps of a multi-mechanism reconciliation method, the steps of the multi-mechanism reconciliation method comprising: the method comprises the steps of generating a task list to be analyzed into a standard reconciliation file format, utilizing an importing interface on a service system to import a standard reconciliation file format template into the service system, acquiring corresponding configuration required by the standard reconciliation file format from a reconciliation file to be reconciled according to the standard reconciliation file format template, generating a path for analyzing the standard reconciliation file format and a realization logic list corresponding to the path according to the task list and the configuration, and executing the realization logic list to acquire the standard reconciliation file format. And generating a reconciliation task list through a timing task triggering mode according to the analyzed standard reconciliation file format, importing a reconciliation model at the front end of the business system, acquiring the reconciliation model and the required configuration according to the reconciliation task list, completing the reconciliation and acquiring a reconciliation result. And generating a task list of a dynamic configuration reconciliation file format by a timing task triggering mode, importing a format requirement required by the party receiving the reconciliation file at the front end of the business system, acquiring configuration, finishing the dynamic configuration reconciliation result file, converting the format of the reconciliation result file, and acquiring the reconciliation result file.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the computer program is executed. The storage medium may be a non-volatile storage medium such as a magnetic disk, an optical disk, a Read-Only Memory (ROM), or a Random Access Memory (RAM).
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.