CN114358903A - RPA-based multi-system accounting checking method and device and computer equipment - Google Patents
RPA-based multi-system accounting checking method and device and computer equipment Download PDFInfo
- Publication number
- CN114358903A CN114358903A CN202210003430.3A CN202210003430A CN114358903A CN 114358903 A CN114358903 A CN 114358903A CN 202210003430 A CN202210003430 A CN 202210003430A CN 114358903 A CN114358903 A CN 114358903A
- Authority
- CN
- China
- Prior art keywords
- checking
- report data
- rpa
- result
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application relates to a RPA-based multi-system accounting checking method, device, computer equipment, storage medium and computer program product. The method comprises the following steps: acquiring first report data of a first accounting system and second report data of a second accounting system based on RPA; checking the first report data and the second report data based on a preset checking rule to obtain a checking result; and prompting the verification information related to each verification organization and each verification organization through a mail based on the verification result. By adopting the method, the financial institution account checking efficiency can be improved.
Description
Technical Field
The present application relates to the field of artificial intelligence, and in particular, to a method, an apparatus, a computer device, a storage medium, and a computer program product for multi-system accounting based on RPA.
Background
Accounts generated by the businesses such as transfer, deposit and withdrawal, loan and settlement of the bank are recorded in the core system of the bank. At present, banks have the parallel current situation of multi-core systems, and each core system is connected with a plurality of product systems, such as a credit card product system, an order receiving product system, a financial market production system, a credit product system and the like. When the product systems generate transactions, the core system is driven to carry out accounting, the core system can return accounting data recorded in a certain period (such as a working day) to the product systems, and the product systems can check the accounting data generated according to the transactions and the accounting data returned by the core system so as to ensure that the accounting records are correct.
However, at present, the accounting checking work of each product system is completed by a person dedicated to each system, and each product system needs to develop and maintain each accounting checking system, so that a large amount of repeated work exists, the personnel investment cost and the operation and maintenance cost are high, and the checking efficiency is low.
Disclosure of Invention
In view of the above, it is necessary to provide a RPA-based multi-system accounting checking method, apparatus, computer device, computer-readable storage medium, and computer program product capable of improving checking efficiency.
In a first aspect, the present application provides a method for RPA-based multi-system accounting checking. The method comprises the following steps:
acquiring first report data of a first accounting system and second report data of a second accounting system based on RPA;
checking the first report data and the second report data based on a preset checking rule to obtain a checking result;
and prompting the verification information related to each verification organization and each verification organization through a mail based on the verification result.
In one embodiment, the acquiring, based on the RPA, first reporting data of the first accounting system and second reporting data of the second accounting system includes:
acquiring first manual process information of manually acquiring first report data of a first accounting system and second manual process information of manually acquiring second report data of a second accounting system;
writing an RPA executive program according to the first manual flow information and the second manual flow information;
and setting storage positions of the first report data and the second report data, and acquiring the first report data and the second report data based on the RPA executive program.
In one embodiment, the checking the first report data and the second report data based on a preset checking rule, and obtaining a checking result includes:
on the basis of a preset checking rule, checking the first report data and the second report data according to the account numbers, and judging whether each checking account in the first report data is consistent with each checking account in the second report data;
if the result is consistent, the checking result is that the financial affairs are checked to be correct;
and if the account checking result is inconsistent, the checking result is that the account checking is wrong, and the first report data and the second report data are subjected to drill-down analysis until wrong mechanism information and subject number information are obtained.
In one embodiment, the prompting, by mail, the collation information related to each collation organization based on the collation result includes:
if the checking result is that the financial affairs are checked to be correct, sending a prompt mail to each checking organization to inform the checking to be correct;
if the checking result is that the account is checked wrongly, sending a prompting mail to a checking mistake mechanism to inform the mechanism of the checking mistake, and asking the mechanism to check and process.
In one embodiment, the prompting, by mail, the collation information related to each collation organization based on the collation result further includes:
and if the first report data and/or the second report data are not updated completely when the first report data and/or the second report data are obtained, sending a mail to the checking mechanism to inform the checking mechanism of manual account checking.
In one embodiment, the performing drill-down analysis on the first report data and the second report data until obtaining error mechanism information and subject number information includes:
and sequentially checking each branch mechanism of the error checking mechanism layer by layer until the error mechanism information of the minimum unit and the corresponding subject number information are obtained.
In a second aspect, the application further provides a multi-system accounting checking device based on the RPA. The device comprises:
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring first report data of a first accounting system and second report data of a second accounting system based on RPA;
the checking module is used for checking the first report data and the second report data based on a preset checking rule to obtain a checking result;
and the notification module is used for prompting the verification information of each verification organization and each verification organization through a mail based on the verification result.
In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the following steps when executing the computer program:
acquiring first report data of a first accounting system and second report data of a second accounting system based on RPA;
checking the first report data and the second report data based on a preset checking rule to obtain a checking result;
and prompting the verification information related to each verification organization and each verification organization through a mail based on the verification result.
In a fourth aspect, the present application further provides a computer-readable storage medium. The computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of:
acquiring first report data of a first accounting system and second report data of a second accounting system based on RPA;
checking the first report data and the second report data based on a preset checking rule to obtain a checking result;
and prompting the verification information related to each verification organization and each verification organization through a mail based on the verification result.
In a fifth aspect, the present application further provides a computer program product. The computer program product comprising a computer program which when executed by a processor performs the steps of:
acquiring first report data of a first accounting system and second report data of a second accounting system based on RPA;
checking the first report data and the second report data based on a preset checking rule to obtain a checking result;
and prompting the verification information related to each verification organization and each verification organization through a mail based on the verification result.
According to the RPA-based multi-system financial checking method, the RPA-based multi-system financial checking device, the computer equipment, the storage medium and the computer program product, the first report data of the first financial system and the second report data of the second financial system are obtained based on the RPA, the first report data and the second report data are checked based on the preset checking rule to obtain the checking result, the checking information related to each checking organization and each checking organization is prompted through a mail based on the checking result, the RPA robot is used for obtaining the first report data and the second report data and checking the financial affairs according to the preset checking rule, and the financial institution financial checking efficiency is improved.
Drawings
FIG. 1 is a diagram of an embodiment of an application environment of an RPA-based multi-system accounting reconciliation method;
FIG. 2 is a flow diagram illustrating a RPA-based multi-system accounting checking method according to an embodiment;
FIG. 3 is a flowchart illustrating the steps of obtaining the first report data and the second report data in one embodiment;
FIG. 4 is a block diagram of an RPA-based multi-system accounting checking apparatus in one embodiment;
FIG. 5 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application 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 present application and are not intended to limit the present application.
The RPA-based multi-system accounting checking method provided by the embodiment of the application can be applied to the application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104, or may be located on the cloud or other network server. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices and portable wearable devices, and the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart car-mounted devices, and the like. The portable wearable device can be a smart watch, a smart bracelet, a head-mounted device, and the like. The server 104 may be implemented as a stand-alone server or as a server cluster comprised of multiple servers.
In one embodiment, as shown in fig. 2, there is provided a RPA-based multi-system accounting checking method, which is described by taking the method as an example applied to the server in fig. 1, and includes the following steps:
step 202, acquiring first report data of a first accounting system and second report data of a second accounting system based on the RPA.
The Robot Process Automation (RPA) is a business Process Automation technology based on a software robot, wherein the robot is a virtual concept, does not need an actual robot, and is only an execution unit or an execution entity of the Process. For example, the present invention uses a computer program as an executable of the flow.
In the prior art, a plurality of accounting processing systems are mutually independent and cannot be directly connected. For example, the accounting staff extracts the balance data of each subject in the last day from the report of the 'bill financing integrated management system' every day, and then extracts corresponding mechanisms and corresponding subject data from the CS2002 system respectively for checking one by one; if a certain subject is wrong, data of all branches and branches under the jurisdiction are respectively extracted from 2 systems to be searched until the branches and branches with the errors are found, and the problem troubleshooting workload is large.
Specifically, when acquiring first report data of a first accounting system and second report data of a second accounting system based on an RPA, taking the first accounting system as a comprehensive bill financing management system and the second accounting system as a CS2002 system as an example, it is first necessary to determine all operation steps of manually acquiring the first report data of the first accounting system and the second report data of the second accounting system, and ensure that operations in sequence according to the steps can be successfully executed, and then list lists of all the steps are fixed. And then writing an RPA executive body to simulate all the processes of manually acquiring the first report data and the second report data. The RPA executive body is a specially developed computer program, programs such as python or java and the like are utilized by a computer programming language, the manual operation steps are all automatically realized through the programs, a storage path of a file in the FTP is set, a data file exported from a target system is automatically uploaded to a target file directory, and the file uploading is realized through writing bat or shell scripts. And acquiring the user identity and the password information of the current mechanism according to the preset parameters, logging in a comprehensive bill management system by the RPA executive body by using the user identity information and the password information, finding the page position of the preset report field according to the preset menu path, and finishing capturing the report field information set by the current date. The program can automatically judge the data size of the currently captured data object, and if the data size reaches a preset threshold value, the tasks are executed in batches, so that flow interruption caused by overlong flow is prevented. And after all data of the first report data and the second report data are acquired, carrying out data integrity check on the acquired data, checking the integrity of the derived report according to the preset mechanism number and the report template field, and acquiring again until the data is complete if the data is incomplete.
By applying the RPA technology and utilizing common computer programming language customized development, the manual operations are all automated, and automatic timing execution is set, so that automatic extraction of data from a bill financing comprehensive management system and a report system is realized, the checking of the correctness of the financial affairs is completed, the checking efficiency of the financial affairs is improved, and the financial affairs risk caused by directly using the report of the bill system is avoided.
The RPA robot structure is composed of a robot component, a flow unit, a robot task unit and a robot management unit. Robot assembly and flow cell: the component unit is used for forming a single-step independent development component, capturing element field information on a browser webpage system in a script code compiling mode, and simulating a manual daily operation flow by using methods such as mouse clicking, keyboard simulation, copying \ pasting and the like, so that automation of the operation flow is realized. The script writing language supports common script languages such as python and js. The process unit is used for serially connecting the independent component units into a full-step process to form a service process closed loop and realize the process automation of rule design.
Robot task unit: the robot flow unit is used for configuring the time of the automatic task and automatically executing the robot flow unit according to the set task time parameters, so that the automatic flow task execution operation is realized.
A robot management unit: the method is used for scheduling and monitoring management of resources of the plurality of robots, and monitoring and tracking the current running condition and the historical execution condition of the robots in a visual view mode. Meanwhile, for the historical process executed by the robot each time, the operation log records all operation records such as the execution result, the execution time and the like of each node of the robot, and the operation records are used for tracking and viewing by a user.
And 204, checking the first report data and the second report data based on a preset checking rule to obtain a checking result.
Specifically, the first report data and the second report data are checked based on a preset checking rule to obtain a checking result; the preset checking rule is set according to a comparison rule set according to the contents of fields of the first report data and the second report data derived by the first accounting system and the second accounting system. For example, the Ticket System balance Table subject 1 today's balance field should equal the CS2002 System subject 1.1 balance + subject 1.2 balance; the billing system subject 2 balance field CS2002 system subject 2 balance. The preset rule is to compare the consistency of each field value in the report of the 'comprehensive bill financing management system' of the organization A and the report of the CS2002 system. For example, the first report data of the first accounting system and the second report data of the second accounting system are compared.
And step 206, prompting the verification information of each verification organization and each verification organization through a mail based on the verification result.
Specifically, after the collation result is acquired, corresponding collation information is transmitted to each mechanism according to whether or not there is a collation error mechanism. If the checking is correct, the sent checking information is used for prompting each organization that the checking accounts are correct; if the error exists in the checking, sending information to a mechanism for checking the error to prompt the mechanism for checking the error to have the error and carrying out checking treatment; if the mechanism fails to check due to the data uploading problem, sending information to the mechanism to prompt the mechanism to upload the data to be checked as soon as possible.
In the RPA-based multi-system financial checking method, the first report data of the first financial system and the second report data of the second financial system are obtained based on the RPA, the first report data and the second report data are checked based on the preset checking rule to obtain the checking result, the checking information related to each checking organization and each checking organization is prompted through a mail based on the checking result, the first report data and the second report data are obtained through the RPA robot, and the financial checking is carried out according to the preset checking rule, so that the financial institution financial checking efficiency is improved.
In one embodiment, the acquiring the first reporting data of the first accounting system and the second reporting data of the second accounting system based on the RPA includes:
step 302, acquiring first manual process information of manually acquiring first report data of a first accounting system and second manual process information of manually acquiring second report data of a second accounting system;
step 304, writing an RPA execution program according to the first manual flow information and the second manual flow information;
step 306, setting storage positions of the first report data and the second report data, and acquiring the first report data and the second report data based on the RPA executive program.
Specifically, fig. 3 is a schematic flow diagram of a step of acquiring first report data and second report data in an embodiment, as shown in fig. 3, first acquiring all flows of manually acquiring first report data of a first accounting system as first manual flow information, and acquiring second manual flow information of manually acquiring second report data of a second accounting system, writing an RPA executive program according to the first manual flow information and the second manual flow information, then setting storage locations of the first report data and the second report data, and acquiring the first report data and the second report data based on the RPA executive program and storing the first report data and the second report data to corresponding storage locations.
In this embodiment, first manual flow information for manually acquiring first report data of a first accounting system and second manual flow information for manually acquiring second report data of a second accounting system are acquired, an RPA executive program is compiled according to the first manual flow information and the second manual flow information, storage positions of the first report data and the second report data are set, the first report data and the second report data are acquired based on the RPA executive program, modeling of manual operation is achieved, through an RPA automatic operation scheme, efficiency of accounting checking is improved, and human resource investment is reduced.
In an embodiment, the checking the first report data and the second report data based on a preset checking rule, and obtaining a checking result includes:
on the basis of a preset checking rule, checking the first report data and the second report data according to the account numbers, and judging whether each checking account in the first report data is consistent with each checking account in the second report data;
if the result is consistent, the checking result is that the financial affairs are checked to be correct;
and if the account checking result is inconsistent, the checking result is that the account checking is wrong, and the first report data and the second report data are subjected to drill-down analysis until wrong mechanism information and subject number information are obtained.
Specifically, when the first report data and the second report data are checked, the first report data and the second report data are checked according to the account numbers based on a preset checking rule, for example, the data consistency of the first report data and the second report data is checked, whether each checked account in the first report data is consistent with each checked account in the second report data is judged, and when the first report data is consistent with the second report data, the checking result of the current account checking is that the account is checked to be correct; when the first report data and the second report data are inconsistent, the checking result of the account checking is that the account checking is wrong, and the account numbers and the like which are wrong in the first report data and the second report data are subjected to drill-down analysis until wrong mechanism information and corresponding wrong account number information are obtained.
In this embodiment, based on a preset checking rule, the first report data and the second report data are checked according to the account number, whether each checked account in the first report data is consistent with each checked account in the second report data is determined, and a corresponding checking result is obtained, so that a method for mutual evidentiary use of multiple system data is implemented, an account data problem caused by a system problem is found, an account management and control level of an account network is improved, and an account risk occurrence rate is reduced.
In one embodiment, said prompting, by mail, the collation information related to each collation organization based on the collation result includes:
if the checking result is that the financial affairs are checked to be correct, sending a prompt mail to each checking organization to inform the checking to be correct;
if the checking result is that the account is checked wrongly, sending a prompting mail to a checking mistake mechanism to inform the mechanism of the checking mistake, and asking the mechanism to check and process.
In the embodiment, after the first report data and the second report data are checked and the check result is obtained, if the check result is that the financial affairs are checked to be correct, a prompt mail is sent to each checking mechanism to inform the checking to be correct; if the checking result is that the account is checked wrongly, sending a prompting mail to a checking mistake mechanism to inform the mechanism of the checking mistake, and asking the mechanism to check and process. For example, if the account check is correct, a mail prompt is sent: the date ticket is checked against the balance of the financial comprehensive management system. If the account check is wrong, if only 1 mail prompt with inconsistent subject data is given: the robot automatic risk monitoring finds that the subject balance of the integrated management system for financing date and year does not accord with the data of the foreground host, and the person is prompted to check the reason and process in time as soon as possible. If there are 2 (including) mail prompts with inconsistent subject data: "the robot automated risk monitoring finds" branch row "year" month "day ticket data integrated management system balance table" subject.
In the embodiment, according to the account checking result, when the checking result is that the account checking is correct, a prompt mail is sent to each checking organization to inform that the checking is correct; when the checking result is that the financial affairs are checked wrongly, a prompt mail is sent to the error checking mechanism to inform the mechanism of error checking, the mechanism is requested to check and process, manual operation is modeled to form an RPA automatic operation scheme, the financial affairs checking efficiency is improved, and human resource input is reduced.
In one embodiment, the prompting, by mail, the collation information related to each collation organization based on the collation result further includes:
and if the first report data and/or the second report data are not updated completely when the first report data and/or the second report data are obtained, sending a mail to the checking mechanism to inform the checking mechanism of manual account checking.
Specifically, if the first report data is not updated when the first report data is acquired, sending a mail to a mechanism corresponding to the first report data to inform the checking mechanism of manual account checking; if the second report data is not updated when the second report data is acquired, sending a mail to the mechanism corresponding to the second report data to inform the checking mechanism to carry out manual account checking; and if the first report data and the second report data are not updated completely, sending mails to mechanisms corresponding to the first report data and the second report data to inform the checking mechanism to carry out manual account checking.
In this embodiment, when the first report data and/or the second report data are obtained and the first report data and/or the second report data are not updated, a mail is sent to the checking mechanism to notify the checking mechanism to perform manual account checking, so that the combination of RPA automatic checking and manual checking is realized, and not only can the efficiency of account checking be ensured, but also the accuracy of account checking can be ensured.
In one embodiment, the performing drill-down analysis on the first report data and the second report data until obtaining error mechanism information and subject number information includes:
and sequentially checking each branch mechanism of the error checking mechanism layer by layer until the error mechanism information of the minimum unit and the corresponding subject number information are obtained.
Specifically, when the first report data and the second report data are subjected to drill-down analysis, after an error checking mechanism is found, further checking is started from a next-level branch mechanism of the error checking mechanism, after an error is found by the next-level branch mechanism, analysis is started from a next-level branch mechanism of the next-level branch mechanism with the error, and so on until the error mechanism information of the minimum unit and the corresponding subject number information are obtained.
In the embodiment, after the error mechanism is found through the accounting check, all branches of the error mechanism are sequentially checked layer by layer until the error mechanism information of the minimum unit and the corresponding account number information are obtained, and the error mechanism is subjected to drill-down analysis through the RPA automatic program, so that the accounting check efficiency is improved, and the human resource input is reduced.
It should be understood that, although the steps in the flowcharts related to the embodiments as described above are sequentially displayed as indicated by arrows, the steps are not necessarily performed sequentially as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the flowcharts related to the embodiments described above may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the execution order of the steps or stages is not necessarily sequential, but may be rotated or alternated with other steps or at least a part of the steps or stages in other steps.
Based on the same inventive concept, the embodiment of the application also provides a multi-system accounting checking device based on the RPA, which is used for realizing the multi-system accounting checking method based on the RPA. The implementation scheme for solving the problem provided by the apparatus is similar to the implementation scheme described in the above method, so specific limitations in one or more embodiments of the RPA-based multi-system accounting checking apparatus provided below may refer to the limitations in the above RPA-based multi-system accounting checking method, and are not described herein again.
In one embodiment, as shown in fig. 4, there is provided an RPA-based multi-system accounting checking apparatus, including: an acquisition module 401, a collation module 402 and a notification module 403, wherein:
an obtaining module 401, configured to obtain, based on the RPA, first reporting data of a first accounting system and second reporting data of a second accounting system;
a checking module 402, configured to check the first report data and the second report data based on a preset checking rule, and obtain a checking result;
a notifying module 403, configured to prompt, by mail, verification information of each verification organization and each verification organization based on the verification result.
In an embodiment, the obtaining module 401 is specifically configured to: acquiring first manual process information of manually acquiring first report data of a first accounting system and second manual process information of manually acquiring second report data of a second accounting system; writing an RPA executive program according to the first manual flow information and the second manual flow information; and setting storage positions of the first report data and the second report data, and acquiring the first report data and the second report data based on the RPA executive program.
In one embodiment, the verification module 402 is specifically configured to: on the basis of a preset checking rule, checking the first report data and the second report data according to the account numbers, and judging whether each checking account in the first report data is consistent with each checking account in the second report data; if the result is consistent, the checking result is that the financial affairs are checked to be correct; and if the account checking result is inconsistent, the checking result is that the account checking is wrong, and the first report data and the second report data are subjected to drill-down analysis until wrong mechanism information and subject number information are obtained.
In an embodiment, the notification module 403 is specifically configured to: if the checking result is that the financial affairs are checked to be correct, sending a prompt mail to each checking organization to inform the checking to be correct; if the checking result is that the account is checked wrongly, sending a prompting mail to a checking mistake mechanism to inform the mechanism of the checking mistake, and asking the mechanism to check and process.
In one embodiment, the notification module 403 is further configured to: and if the first report data and/or the second report data are not updated completely when the first report data and/or the second report data are obtained, sending a mail to the checking mechanism to inform the checking mechanism of manual account checking.
In one embodiment, the verification module 402 is further configured to: and sequentially checking each branch mechanism of the error checking mechanism layer by layer until the error mechanism information of the minimum unit and the corresponding subject number information are obtained.
According to the multi-system financial checking device based on the RPA, the first report data of the first financial system and the second report data of the second financial system are obtained based on the RPA, the first report data and the second report data are checked based on the preset checking rule to obtain the checking result, the checking information related to each checking organization and each checking organization is prompted through a mail based on the checking result, the first report data and the second report data are obtained through the RPA robot, the financial checking is carried out according to the preset checking rule, and the financial institution financial checking efficiency is improved.
All or part of each module in the RPA-based multi-system accounting checking device can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 5. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement an RPA-based multi-system accounting checking method.
Those skilled in the art will appreciate that the architecture shown in fig. 5 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having a computer program stored therein, the processor implementing the following steps when executing the computer program:
acquiring first report data of a first accounting system and second report data of a second accounting system based on RPA;
checking the first report data and the second report data based on a preset checking rule to obtain a checking result;
and prompting the verification information related to each verification organization and each verification organization through a mail based on the verification result.
In one embodiment, the processor, when executing the computer program, further performs the steps of: acquiring first manual process information of manually acquiring first report data of a first accounting system and second manual process information of manually acquiring second report data of a second accounting system; writing an RPA executive program according to the first manual flow information and the second manual flow information; and setting storage positions of the first report data and the second report data, and acquiring the first report data and the second report data based on the RPA executive program.
In one embodiment, the processor, when executing the computer program, further performs the steps of: on the basis of a preset checking rule, checking the first report data and the second report data according to the account numbers, and judging whether each checking account in the first report data is consistent with each checking account in the second report data; if the result is consistent, the checking result is that the financial affairs are checked to be correct; and if the account checking result is inconsistent, the checking result is that the account checking is wrong, and the first report data and the second report data are subjected to drill-down analysis until wrong mechanism information and subject number information are obtained.
In one embodiment, the processor, when executing the computer program, further performs the steps of: if the checking result is that the financial affairs are checked to be correct, sending a prompt mail to each checking organization to inform the checking to be correct; if the checking result is that the account is checked wrongly, sending a prompting mail to a checking mistake mechanism to inform the mechanism of the checking mistake, and asking the mechanism to check and process.
In one embodiment, the processor, when executing the computer program, further performs the steps of: and if the first report data and/or the second report data are not updated completely when the first report data and/or the second report data are obtained, sending a mail to the checking mechanism to inform the checking mechanism of manual account checking.
In one embodiment, the processor, when executing the computer program, further performs the steps of: and sequentially checking each branch mechanism of the error checking mechanism layer by layer until the error mechanism information of the minimum unit and the corresponding subject number information are obtained.
The computer equipment acquires the first report data of the first financial system and the second report data of the second financial system based on the RPA, checks the first report data and the second report data based on the preset checking rule, acquires the checking result, prompts the checking information related to each checking organization and each checking organization through mails based on the checking result, acquires the first report data and the second report data through the RPA robot and checks the financial affairs according to the preset checking rule, and improves the efficiency of checking the financial affairs of the financial institutions.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of:
acquiring first report data of a first accounting system and second report data of a second accounting system based on RPA;
checking the first report data and the second report data based on a preset checking rule to obtain a checking result;
and prompting the verification information related to each verification organization and each verification organization through a mail based on the verification result.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring first manual process information of manually acquiring first report data of a first accounting system and second manual process information of manually acquiring second report data of a second accounting system; writing an RPA executive program according to the first manual flow information and the second manual flow information; and setting storage positions of the first report data and the second report data, and acquiring the first report data and the second report data based on the RPA executive program.
In one embodiment, the computer program when executed by the processor further performs the steps of: on the basis of a preset checking rule, checking the first report data and the second report data according to the account numbers, and judging whether each checking account in the first report data is consistent with each checking account in the second report data; if the result is consistent, the checking result is that the financial affairs are checked to be correct; and if the account checking result is inconsistent, the checking result is that the account checking is wrong, and the first report data and the second report data are subjected to drill-down analysis until wrong mechanism information and subject number information are obtained.
In one embodiment, the computer program when executed by the processor further performs the steps of: if the checking result is that the financial affairs are checked to be correct, sending a prompt mail to each checking organization to inform the checking to be correct; if the checking result is that the account is checked wrongly, sending a prompting mail to a checking mistake mechanism to inform the mechanism of the checking mistake, and asking the mechanism to check and process.
In one embodiment, the computer program when executed by the processor further performs the steps of: and if the first report data and/or the second report data are not updated completely when the first report data and/or the second report data are obtained, sending a mail to the checking mechanism to inform the checking mechanism of manual account checking.
In one embodiment, the computer program when executed by the processor further performs the steps of: and sequentially checking each branch mechanism of the error checking mechanism layer by layer until the error mechanism information of the minimum unit and the corresponding subject number information are obtained.
The storage medium acquires first report data of a first financial system and second report data of a second financial system based on RPA, checks the first report data and the second report data based on a preset checking rule, acquires a checking result, prompts checking information related to each checking organization and each checking organization through mails based on the checking result, acquires the first report data and the second report data through the RPA robot and checks the financial affairs according to the preset checking rule, and improves the efficiency of checking the financial affairs of the financial institutions.
In one embodiment, a computer program product is provided, comprising a computer program which, when executed by a processor, performs the steps of:
acquiring first report data of a first accounting system and second report data of a second accounting system based on RPA;
checking the first report data and the second report data based on a preset checking rule to obtain a checking result;
and prompting the verification information related to each verification organization and each verification organization through a mail based on the verification result.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring first manual process information of manually acquiring first report data of a first accounting system and second manual process information of manually acquiring second report data of a second accounting system; writing an RPA executive program according to the first manual flow information and the second manual flow information; and setting storage positions of the first report data and the second report data, and acquiring the first report data and the second report data based on the RPA executive program.
In one embodiment, the computer program when executed by the processor further performs the steps of: on the basis of a preset checking rule, checking the first report data and the second report data according to the account numbers, and judging whether each checking account in the first report data is consistent with each checking account in the second report data; if the result is consistent, the checking result is that the financial affairs are checked to be correct; and if the account checking result is inconsistent, the checking result is that the account checking is wrong, and the first report data and the second report data are subjected to drill-down analysis until wrong mechanism information and subject number information are obtained.
In one embodiment, the computer program when executed by the processor further performs the steps of: if the checking result is that the financial affairs are checked to be correct, sending a prompt mail to each checking organization to inform the checking to be correct; if the checking result is that the account is checked wrongly, sending a prompting mail to a checking mistake mechanism to inform the mechanism of the checking mistake, and asking the mechanism to check and process.
In one embodiment, the computer program when executed by the processor further performs the steps of: and if the first report data and/or the second report data are not updated completely when the first report data and/or the second report data are obtained, sending a mail to the checking mechanism to inform the checking mechanism of manual account checking.
In one embodiment, the computer program when executed by the processor further performs the steps of: and sequentially checking each branch mechanism of the error checking mechanism layer by layer until the error mechanism information of the minimum unit and the corresponding subject number information are obtained.
According to the computer program product, the first report data of the first financial institution and the second report data of the second financial institution are obtained based on the RPA, the first report data and the second report data are checked based on the preset check rule, the check result is obtained, check information related to each check institution and each check institution is prompted through a mail based on the check result, the first report data and the second report data are obtained through the RPA robot, and the financial affairs are checked according to the preset check rule, so that the financial institution financial affair check efficiency is improved.
It should be noted that, the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party.
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 hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high-density embedded nonvolatile Memory, resistive Random Access Memory (ReRAM), Magnetic Random Access Memory (MRAM), Ferroelectric Random Access Memory (FRAM), Phase Change Memory (PCM), graphene Memory, and the like. Volatile Memory can include Random Access Memory (RAM), external cache Memory, and the like. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others. The databases referred to in various embodiments provided herein may include at least one of relational and non-relational databases. The non-relational database may include, but is not limited to, a block chain based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic devices, quantum computing based data processing logic devices, etc., without limitation.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as 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 application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present application shall be subject to the appended claims.
Claims (10)
1. A multi-system accounting checking method based on RPA is characterized by comprising the following steps:
acquiring first report data of a first accounting system and second report data of a second accounting system based on RPA;
checking the first report data and the second report data based on a preset checking rule to obtain a checking result;
and prompting the verification information related to each verification organization and each verification organization through a mail based on the verification result.
2. The method of claim 1, wherein the obtaining the first reporting data of the first accounting system and the second reporting data of the second accounting system based on the RPA comprises:
acquiring first manual process information of manually acquiring first report data of a first accounting system and second manual process information of manually acquiring second report data of a second accounting system;
writing an RPA executive program according to the first manual flow information and the second manual flow information;
and setting storage positions of the first report data and the second report data, and acquiring the first report data and the second report data based on the RPA executive program.
3. The method according to claim 2, wherein the first report data and the second report data are checked based on a preset checking rule, and obtaining a checking result comprises:
on the basis of a preset checking rule, checking the first report data and the second report data according to the account numbers, and judging whether each checking account in the first report data is consistent with each checking account in the second report data;
if the result is consistent, the checking result is that the financial affairs are checked to be correct;
and if the account checking result is inconsistent, the checking result is that the account checking is wrong, and the first report data and the second report data are subjected to drill-down analysis until wrong mechanism information and subject number information are obtained.
4. The method according to claim 1, wherein said prompting, by mail, collation information relating to each collation organization based on the collation result includes:
if the checking result is that the financial affairs are checked to be correct, sending a prompt mail to each checking organization to inform the checking to be correct;
if the checking result is that the account is checked wrongly, sending a prompting mail to a checking mistake mechanism to inform the mechanism of the checking mistake, and asking the mechanism to check and process.
5. The method according to claim 4, wherein said prompting, by mail, collation information relating to each collation organization based on said collation result further comprises:
and if the first report data and/or the second report data are not updated completely when the first report data and/or the second report data are obtained, sending a mail to the checking mechanism to inform the checking mechanism of manual account checking.
6. The method of claim 3, wherein the combining the first reporting data and the second reporting data for drill-down analysis until obtaining error agency information and subject number information comprises:
and sequentially checking each branch mechanism of the error checking mechanism layer by layer until the error mechanism information of the minimum unit and the corresponding subject number information are obtained.
7. An RPA-based multi-system accounting checking apparatus, the apparatus comprising:
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring first report data of a first accounting system and second report data of a second accounting system based on RPA;
the checking module is used for checking the first report data and the second report data based on a preset checking rule to obtain a checking result;
and the notification module is used for prompting the verification information of each verification organization and each verification organization through a mail based on the verification result.
8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 6.
9. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 6.
10. A computer program product comprising a computer program, characterized in that the computer program realizes the steps of the method of any one of claims 1 to 6 when executed by a processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210003430.3A CN114358903A (en) | 2022-01-04 | 2022-01-04 | RPA-based multi-system accounting checking method and device and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210003430.3A CN114358903A (en) | 2022-01-04 | 2022-01-04 | RPA-based multi-system accounting checking method and device and computer equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114358903A true CN114358903A (en) | 2022-04-15 |
Family
ID=81106713
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210003430.3A Pending CN114358903A (en) | 2022-01-04 | 2022-01-04 | RPA-based multi-system accounting checking method and device and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114358903A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114677206A (en) * | 2022-05-27 | 2022-06-28 | 深圳市赢向量科技有限公司 | Data checking system for performing autonomous financial checking through data checking |
-
2022
- 2022-01-04 CN CN202210003430.3A patent/CN114358903A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114677206A (en) * | 2022-05-27 | 2022-06-28 | 深圳市赢向量科技有限公司 | Data checking system for performing autonomous financial checking through data checking |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10698795B2 (en) | Virtual payments environment | |
| CN110782240B (en) | Business data processing method and device, computer equipment and storage medium | |
| US20050080821A1 (en) | System and method for managing collections accounts | |
| CN109816503A (en) | Financial details data creation method, device, computer equipment and storage medium | |
| EP2672437A1 (en) | Systems and methods for context understanding for developing a software solution for a project | |
| CN114298804A (en) | Intelligent account checking method, system and computer readable storage medium | |
| CN113918738B (en) | Multimedia resource recommendation method and device, electronic equipment and storage medium | |
| CN114358903A (en) | RPA-based multi-system accounting checking method and device and computer equipment | |
| CN104484275A (en) | Method and system capable of remotely testing smart cards | |
| CN109542764A (en) | Webpage automated testing method, device, computer equipment and storage medium | |
| CN116797345A (en) | Task processing method, device, computer equipment and storage medium | |
| US20220019566A1 (en) | System and method for integrating systems to implement data quality processing | |
| CN114490415A (en) | Service testing method, computer device, storage medium, and computer program product | |
| US20210166312A1 (en) | Systems and Methods for Autonomous Portfolio Management and Funding Using Smart Contracts | |
| US20220342780A1 (en) | Interprocess communication for asynchronous tasks | |
| CN114637672A (en) | Automatic data testing method and device, computer equipment and storage medium | |
| CN112965986A (en) | Service consistency processing method, device, equipment and storage medium | |
| CN113779132A (en) | Data import method and device, computer equipment and storage medium | |
| CN111626868A (en) | Account checking method, account checking device, account checking equipment and computer readable storage medium | |
| Felix | Bank Customers Management System | |
| CN116091239A (en) | Commission issuing method, apparatus, computer device and storage medium | |
| CN117076781A (en) | Policy data processing method and device, computer equipment and storage medium | |
| US20200273096A1 (en) | System and method for implementing a community development production reporting application | |
| CN116340330A (en) | Method, device, equipment, medium and product for complement of transfer data | |
| CN115098441A (en) | Database parameter management method and device and computer equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |