Automatic transaction flow query method

Abstract

The invention relates to the technical field of finance and accounting, in particular to an automatic transaction flow query method which comprises the following steps: S1, setting a timed task for an RPA robot in advance; s2, after the RPA robot reaches the timed task, a bottom Python uiautomation automation interface is called, and financial software is automatically logged in; s3, after the RPA robot logs in the financial software, a keyboard and a mouse are automatically operated by simulating a mode of manually querying the transaction flow, and a document corresponding to the transaction flow is exported; s4, the RPA robot is automatically in butt joint with a back-end database, and the exported document is analyzed and stored; and S5, the RPA robot automatically sends the documents in the rear-end database to a front-end display screen. According to the invention, on the basis of an RPA (robot process automation) robot and by taking Python Uiautomation as a technical system, automatic query of transaction flow is realized, so that the operation process and the operation complexity of financial and accounting personnel are reduced, the probability of errors in the operation process is reduced, and the operation time is saved.

Description

technical field [0001] The invention relates to the technical field of accounting, in particular to an automatic transaction flow query method. Background technique [0002] Accounting personnel of most companies on the market need to insert the Ukey of the corresponding bank one by one to inquire about the transaction flow, and then log in to the client software of the corresponding online banking, perform frequent and repeated queries, and then export the file corresponding to the transaction flow, and then pass Open the files one by one to view and verify. In this way, repeated operations in the case of a large amount of data are likely to cause errors. [0003] Therefore, there are deficiencies in the prior art and need to be improved. Contents of the invention [0004] In view of the above-mentioned defects in the prior art, the object of the present invention is to provide an automatic transaction flow query method. [0005] In order to achieve the above purpose, t...

AI Technical Summary

Problems solved by technology

[0002] Accounting personnel of most companies on the market need to insert the Ukey of the corresponding bank one by one to inquire about the transaction flow, and then log in to the client software of the corresponding online banking, perform frequent and repeated queries, and then export the file corresponding to the transaction flow, and then pass Open the files one by one to view and verify. In this way, repeated operations in the case of a large amount of data are likely to cause errors

Images