CN115170260A - Financial certification making method and device, storage medium and computer equipment - Google Patents

Abstract

The embodiments of the present application disclose a financial certificate preparation method, device, storage medium and computer equipment, which relate to the field of office automation. This application interconnects the production management system, financial management and control system and online banking system, and forms a unified data flow channel for invoice list data, current ledger and bank flow data, so as to complete the entire financial processing process and realize the integration of financial data. Auto-pass and auto-approval, and generate various types of financial documents. Compared with the existing calculation of manual data collection and manual certification, it can improve the efficiency of financial certification and reduce the possibility of errors.

Description

Financial certification method, device, storage medium and computer equipment

technical field

The present application relates to the field of office automation, and in particular, to a method, device, storage medium and computer equipment for making financial certificates.

Background technique

With the improvement of the degree of informatization of enterprises, more and more enterprises use financial management and control systems, and financial personnel perform financial processing work in the financial management and control system. Due to the particularity and complexity of financial processing, at present, many links need to be completed manually by financial personnel, such as: financial personnel manually maintain invoice data, check invoice data, and create financial vouchers. This method is inefficient and prone to errors. Certain management security risks are difficult to trace when encountering problems.

SUMMARY OF THE INVENTION

The embodiments of the present application provide a financial certificate preparation method, device, storage medium and computer equipment, which can solve the problems of low efficiency and error-prone financial certificate preparation in the prior art. The technical solution is as follows:

In a first aspect, an embodiment of the present application provides a method for producing financial certificates, the method comprising:

Log in to the production management system and obtain invoice list data in the production management system;

Log in to the financial management and control system and obtain the current ledger in the financial management and control system;

Checking the current account and the invoice list data according to a preset check rule, and updating the current account according to the check result;

reading the current ledger in the financial management and control system;

Generate financial vouchers according to the read transaction ledger; wherein, each financial voucher is associated with a voucher temporary number;

Write back the voucher temporary number of each financial voucher to the read transaction ledger;

Read the temporary number of each voucher in the current ledger;

Reviewing and printing the financial vouchers associated with the temporary numbers of each voucher;

After the audit is successful, assign a voucher fixed number to each financial voucher, write back the voucher fixed number of each financial voucher to the current account, and upload the written back account to the production management system;

Log in to the online banking system and obtain bank flow data in the online banking system;

Obtain voucher data representing attributes of each financial voucher from the current account of the financial management and control system;

Checking the bank flow data and the voucher data, and updating the bank flow data according to the check result;

Generate account receipt vouchers according to the updated bank flow data, and review the generated account receipt vouchers.

In a second aspect, an embodiment of the present application provides a financial certification device, the device comprising:

an acquisition unit for logging into the production management system and acquiring invoice list data in the production management system;

The obtaining unit is further configured to log in to the financial management and control system and obtain the current ledger in the financial management and control system;

a checking unit, configured to check the current account and the invoice list data according to a preset check rule, and update the current account according to the check result;

The acquisition unit is further configured to read the current ledger in the financial management and control system;

The generating unit is used to generate financial vouchers according to the read transaction ledger; wherein, each financial voucher is associated with a voucher temporary number;

The write-back unit is used to write back the voucher temporary number of each financial voucher to the read transaction ledger;

The obtaining unit is also used to read the temporary number of each voucher in the current ledger;

an auditing unit, configured to audit and print the financial vouchers associated with the temporary numbers of each voucher;

The write-back unit is also used for assigning a voucher fixed number to each financial voucher after the audit is successful, writing back the voucher fixed number of each financial voucher to the current account, and uploading the written-back account. to the production management system;

The obtaining unit is also used to log in to the online banking system and obtain bank flow data in the online banking system;

The obtaining unit is further configured to obtain voucher data representing the attributes of each financial voucher in the current ledger of the financial management and control system;

The checking unit is further configured to check the bank flow data and the voucher data, and update the bank flow data according to the check result;

The auditing unit is further configured to generate an account receipt voucher according to the updated bank flow data, and to audit the generated account receipt voucher.

In a third aspect, an embodiment of the present application provides a computer storage medium, where the computer storage medium stores a plurality of instructions, and the instructions are suitable for being loaded by a processor and executing the above method steps.

In a fourth aspect, an embodiment of the present application provides a computer device, which may include: a processor and a memory; wherein, the memory stores a computer program, and the computer program is adapted to be loaded by the processor and execute the above method steps .

The beneficial effects brought by the technical solutions provided by some embodiments of the present application include at least:

The production management system, the financial management and control system and the online banking system are interconnected to form a unified data flow channel, so as to complete the entire financial processing process and realize the automatic transmission of financial data. and automated auditing, as well as generating various types of financial documents. Compared with the existing calculation of manual data collection and manual certification, it can improve the efficiency of financial certification and reduce the possibility of errors.

Description of drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the accompanying drawings required for the description of the embodiments or the prior art. Obviously, the drawings in the following description are only These are some embodiments of the present application. For those of ordinary skill in the art, other drawings can also be obtained based on these drawings without any creative effort.

1 is a schematic diagram of a network architecture provided by an embodiment of the present application;

Fig. 2 is the schematic flow chart of the financial certificate preparation method provided by the embodiment of the present application;

3 is a schematic diagram of the deployment of an RPA robot provided by an embodiment of the present application;

4 is a schematic structural diagram of a financial certificate-making device provided by the application;

FIG. 5 is a schematic structural diagram of a computer device provided by the present application.

Detailed ways

In order to make the objectives, technical solutions and advantages of the present application clearer, the embodiments of the present application will be described in further detail below with reference to the accompanying drawings.

It should be noted that the financial certification method provided in this application is generally performed by computer equipment, and correspondingly, the financial certification device is generally set in the computer equipment.

FIG. 1 shows an exemplary system architecture that can be applied to the financial certification method or the financial certification device of the present application.

As shown in FIG. 1 , the system architecture may include: a computer device 101 and a server 102 . Communication between the computer device 101 and the server 102 may be performed through a network, and the network is used as a medium for providing communication links between the above-mentioned various units. The network may include various types of wired communication links or wireless communication links, for example: wired communication links include optical fibers, twisted pair or coaxial cables, etc. -FIdelity, Wi-Fi) communication link or microwave communication link, etc.

Among them, the number of servers 102 is multiple, and a financial management and control system, an online banking system and a production management system are respectively deployed, and a plurality of different RPA (robotic process automation) robots are deployed in the computer device 101. By calling the RPA robot Realize the collection, audit and certification of financial data across the system.

It should be noted that the computer device 101 and the server 102 may be hardware or software. When the computer device 101 and the server 102 are hardware, they may be implemented as a distributed server cluster composed of multiple servers, or may be implemented as a single server. When the computer device 101 and the server 102 are software, they may be implemented as multiple software or software modules (for example, for providing distributed services), or may be implemented as a single software or software module, which is not specifically limited herein.

Various communication client applications can be installed on the computer equipment of the present application, such as video recording applications, video playback applications, voice interaction applications, search applications, instant communication tools, email clients, social platform software, and the like.

Computer equipment can be hardware or software. When the computer device is hardware, it can be a variety of computer devices having a display screen, including but not limited to smartphones, tablet computers, laptop computers, desktop computers, and the like. When the computer equipment is software, it can be installed in the computer equipment listed above. It can be implemented as multiple software or software modules (for example, used to provide distributed services), or can be implemented as a single software or software module, which is not specifically limited here.

When the computer device is hardware, a display device and a camera can also be installed on it. The display device can be a variety of devices that can realize the display function, and the camera is used to capture video streams; for example, the display device can be a cathode ray tube display ( Cathode ray tube display (CR), light-emitting diode display (LED), electronic ink screen, liquid crystal display (LCD), plasma display panel (PDP), etc. . The user can use the display device on the computer device to view the displayed text, picture, video and other information.

It should be understood that the numbers of computer devices, networks, and servers in FIG. 1 are merely illustrative. There can be any number of computer devices, networks, and servers, depending on the implementation needs.

The financial certificate preparation method provided by the embodiment of the present application will be described in detail below with reference to FIG. 2 . Wherein, the financial certification device in the embodiment of the present application may be the computer device shown in FIG. 1 .

Please refer to FIG. 2 , which is a schematic flowchart of a method for producing financial certificates according to an embodiment of the present application. As shown in FIG. 2 , the method of the embodiment of the present application may include the following steps:

S201, log in to the production management system and obtain invoice list data in the production management system.

Among them, when the financial certificate is required, the computer equipment sends a login request to the production management system, and the login request carries the account information of the invoicing person. After the production management system verifies that the account information is passed, it returns a successful login response to the computer equipment, and then the computer equipment succeeds. Log in to the production management system. The production management system is a system for employees of the company to perform reimbursement and invoicing, such as employee reimbursement and invoicing, and invoicing in the process of corporate receipt and payment. The production management system can obtain paper invoices or electronic invoices through OCR. The algorithm collects structured invoice data, and then stores the collected multiple invoice data in the production management system to form invoice list data. The invoice data represents the attributes of the invoice, and the types of invoices include but are not limited to: airplane invoices, train invoices, automobile invoices, accommodation invoices, etc. The status of the invoice list data includes processed and unprocessed. The computer equipment obtains the unprocessed invoice list data in the production management system. Further, each invoice data included in the invoice list data includes the following fields: buyer unit, total price and tax, Contract number, contract name, department, and estimated time of collection.

In this embodiment, the computer device executes S201 by calling the first RPA robot, and the first RPA robot obtains the login interface of the production management system through the computer device, enters account information in the login interface, and then triggers the login button and sends the message to the production management system After the login request is passed and the production management system is verified, the first RPA robot obtains the invoice list data through the invoice module in the production management system.

S202, log in to the financial management and control system and obtain the current ledger in the financial management and control system.

Among them, the financial management and control system is a system for financial personnel to conduct financial audit and management. The computer equipment sends a login request to the financial management and control system, and the login request carries the account information of the financial personnel. After the financial management and control system verifies that the account information is passed, the computer equipment is allowed to log in to the The financial management and control system, and then obtain the current ledger in the financial management and control system. The current ledger is the basic financial data recorded by the financial personnel. The current ledger includes a number of ledger data, for example: the current ledger is a spreadsheet, and the Each row stores a piece of ledger data. The ledger data includes the following fields: Account, Financial Control Object, Contract Number, Contract Amount, Invoice Number, Billing Amount, Payment Amount, Book Balance, Voucher Temporary Number, Voucher Fixed Number, Arrival payment date, billing date, business unit, reconciliation result and reversal amount.

Further, the computer device can execute S202 by calling the second RPA robot, and the second RPA robot obtains the login interface of the financial management and control system, and then enters the account information of the financial personnel in the login interface, clicks the login button, and sends the login to the financial management and control system. After the financial management and control system verifies the login request, the second RPA robot successfully logs in to the financial management and control system, and then obtains the current ledger in the ledger module of the financial management and control system.

S203. Check the current ledger and the invoice list data according to a preset check rule, and update the current account according to the check result.

Among them, the financial management and control system will record the invoice data in the current ledger when issuing or receiving the invoice, and the computer equipment will check whether the amounts of the current ledger and the invoice list data are consistent according to the preset checking rules. The non-compliant ledger data in the current ledger is corrected.

Further, the current ledger includes multiple pieces of ledger data, and the invoice list data includes multiple pieces of invoice data;

The checking of the current ledger and the invoice list data according to a preset checking rule includes:

Obtain the invoice data associated with each piece of ledger data; for example, each piece of ledger data includes an invoice number, and one or more related invoice data is determined in the invoice list data according to the invoice number.

If the amount of the ledger data is greater than the amount of the associated invoice data, is it consistent? Specifically, if the amount of the ledger data is greater than the amount of the associated invoice data, it indicates that the invoice is missing, and the ledger data is updated according to the missing invoice; If the amount of the ledger data is less than the amount of the associated invoice data, it indicates that there is an over-issued invoice, and the invoice data of the over-issued invoice is added to the ledger data.

S204, read the current ledger in the financial management and control system.

Among them, the computer equipment automatically logs into the financial management and control system, and reads the latest current ledger in the financial management and control system, that is, the current ledger is checked and processed.

S205, generating a financial voucher according to the read transaction ledger.

Among them, financial vouchers are generated according to the various ledger data in the current ledger, and the financial vouchers include receivable vouchers and payable vouchers, and each financial voucher is associated with a voucher temporary number.

S206, write back the voucher temporary number of each financial voucher to the read transaction ledger.

S207: Read the temporary number of each voucher in the current ledger.

Among them, the computer equipment automatically logs into the financial management and control system, and reads the temporary number of each voucher in the current ledger.

S208 , reviewing and printing the financial vouchers associated with the temporary numbers of each voucher.

Among them, the auditing method is: auditing whether the value of each field in the financial voucher is within the preset range and whether the value of each field is empty, after the audit is passed, print the financial voucher into an electronic version, and then the electronic version of the financial voucher Push to the to-do list of the designated financial staff.

S209 , after the audit is successful, assign a voucher fixed number to each financial voucher, write back the voucher fixed number of each financial voucher to the current account, and upload the written-back account to the production management system.

Among them, after the audit is successful, each financial voucher is assigned a voucher fixed number, and the voucher fixed number is the primary key, which is used to uniquely represent the identity of the financial voucher. The value of the field is hashed to generate a voucher fixed number, which can ensure the uniqueness of the voucher fixed number. Then write back the voucher fixed number of each financial voucher to the current ledger, and upload the written back ledger to the production management system.

S210, log in to the online banking system and obtain bank flow data in the online banking system.

Among them, the bank flow data of enterprise users is stored in the online banking system. The bank flow data includes multiple pieces of sub-flow data. One piece of flow data may correspond to one or more invoices. The financial management and control system will store the mapping between the sub-flow data and the invoices. relation. The computer equipment can automatically log in to the online banking system through the RPA robot and automatically obtain the bank flow data in the bank flow module of the webpage system.

S211. Obtain voucher data representing attributes of each financial voucher from the current account of the financial management and control system.

Wherein, the voucher data includes a field of a voucher fixed number, and the voucher data corresponds to one or more financial vouchers generated in S209.

S212 , check the bank flow data and the voucher data, and update the bank flow data according to the check result.

Among them, the computer equipment checks whether the amounts of the bank flow data and the voucher data are consistent, the financial management and control system pre-stores the mapping relationship between the bank flow and the financial voucher, and the computer equipment determines and determines the sub vouchers associated with each sub flow data according to the mapping relationship. data;

Check whether the amount of the sub-running water data is consistent with the amount of the associated sub-voucher data. If they are inconsistent, update the sub-running water data or the associated sub-voucher data until the amounts of the two are consistent.

S213 , generating an account receipt voucher according to the updated bank flow data, and reviewing the generated account receipt voucher.

Among them, the receipt voucher represents a successful and positive voucher, and the audit of the receipt voucher includes whether the value of the field is within the preset range, whether the value of the field is empty, etc., whether the value of each field satisfies the preset association relationship, etc., and will be reviewed and approved. The subsequent receipt voucher is passed to the person in charge of the process node for processing, and the to-do list of the person in charge is generated.

It should be noted that, each step of S210 to S213 of the present application can be automatically performed by a daemon thread or automatically performed by an RPA robot. When automatically performed by an RPA robot, each step is performed by a different RPA robot.

For example, referring to the schematic diagram shown in Figure 3, the following RPA robots are deployed in the financial management and control system: a robot for obtaining invoice list, a robot for checking billing data, a robot for auditing A/R certificates, a robot for auditing payable certificates, and a robot for obtaining and downloading , upload and update robot, bank flow acquisition robot, account data verification robot, invoice list robot is used to log in to the production management system and obtain invoice list data, billing data verification robot is used to verify the consistency of invoice list data and current ledgers, The A/R certificate production audit robot and the A/P certificate production audit robot are used to review financial vouchers and receipt vouchers, the download robot is used to obtain the current account in the production management system, the upload update robot is used to update the current account, and the updated The transaction ledger is uploaded to the production management system. The bank flow robot is used to obtain bank flow data in the online banking system, and the arrival data verification robot is used to check the consistency of bank flow data and voucher data. The above RPA robots can be executed in parallel to improve the execution efficiency, or start the corresponding RPA robots in sequence according to the preset start time sequence, so as to avoid the excessive number of RPA robots started at the same time, resulting in excessive processing overhead. large, to ensure the reliability of process execution.

Implementing the embodiments of the present application has the following advantages:

First, through the refined management of billing data, sort out the management process of online VAT invoice issuance, and realize online form filling, online review, online issuance, and online voiding. Open up the data channel with the business system, extend the business process to the front-end department of the business, and standardize the refined management process of the whole business. Open up the data channel with the tax invoicing system to achieve interconnection and complete automatic one-click invoicing.

Secondly, according to the established rules, establish an online transaction ledger data management center, and automatically register transaction information according to billing information, contract information, and accounting information, and realize dynamic association of contracts, invoices, payments, and accounts. Ensure the timely, accurate and objective real-time reflection of data. Based on the ledger information, we can comprehensively control and grasp the business situation, and provide important data basis for business decision-making and financial management. Through RPA technology, the data link between the financial system and the business system is connected, and the financial data is shared with the business department to provide a value reference for it. Realize the automatic bookkeeping of the current ledger to ensure the accuracy of the data.

Third, sort out the accounting rules, extract the invoicing information and business information according to the invoicing situation and contract information, carry out data verification, and realize the auxiliary generation of accounting vouchers and automatic audit vouchers. The current ledger and the daily transaction details of the bank are extracted from the production management system, processed and checked, and finally the current ledger data is generated to realize the automation and intelligence of the transaction management.

Finally, through the application of RPA technology in all aspects of the overall business, from the refined automatic management of billing data to the intelligent automatic verification of transaction ledger data, to the intelligent automatic audit of billing vouchers, and finally the verification of payment data and vouchers Full-process automation of automatic certification and intelligent auditing. The core content of automated processing of capital transactions is different from multi-person and multi-post collaborative processing work. The application of RPA technology can greatly reduce the labor burden, and can also quickly improve the accuracy of business processing. time can be easily traced back.

The following are apparatus embodiments of the present application, which can be used to execute the method embodiments of the present application. For details not disclosed in the device embodiments of the present application, please refer to the method embodiments of the present application.

Please refer to FIG. 4 , which shows a schematic structural diagram of a financial certificate preparation device provided by an exemplary embodiment of the present application, hereinafter referred to as device 4 . The apparatus 4 can be implemented by software, hardware or a combination of the two to become all or a part of computer equipment. The apparatus 4 includes: an acquisition unit 401 , a verification unit 402 , a generation unit 403 , a write-back unit 404 , and a review unit 405 .

an obtaining unit 401, used to log in to the production management system and obtain invoice list data in the production management system;

The obtaining unit 401 is further configured to log in to the financial management and control system and obtain current ledger in the financial management and control system;

A checking unit 402, configured to check the current account and the invoice list data according to a preset check rule, and update the current account according to the check result;

The obtaining unit 401 is further configured to read the current ledger in the financial management and control system;

The generating unit 403 is used to generate financial vouchers according to the read transaction ledger; wherein, each financial voucher is associated with a voucher temporary number;

The write-back unit 404 is used to write back the voucher temporary number of each financial voucher into the read transaction ledger;

The obtaining unit 401 is also used to read the temporary number of each voucher in the current ledger;

The auditing unit 405 is configured to audit and print the financial vouchers associated with the temporary numbers of the various vouchers;

The write-back unit 404 is further configured to assign a voucher fixed number to each financial voucher after the audit is successful, and to write back the voucher fixed number of each financial voucher to the current ledger, and to write back the written transaction ledger. Upload to the production management system;

The obtaining unit 401 is further configured to log in to the online banking system and obtain bank flow data in the online banking system;

The obtaining unit 401 is further configured to obtain voucher data representing the attributes of each financial voucher from the current ledger of the financial management and control system;

The checking unit 402 is further configured to check the bank flow data and the voucher data, and update the bank flow data according to the check result;

The auditing unit 405 is further configured to generate an account receipt voucher according to the updated bank flow data, and to audit the generated account receipt voucher.

In one or more possible embodiments, the logging in to the production management system and the obtaining of invoice list data in the production management system include:

Log in to the production management system through the first RPA robot and obtain invoice list data in the production management system; wherein, the invoice list data includes the following fields: buyer unit, total price and tax, contract number, contract name, department and forecast Payment time.

In one or more possible embodiments, the logging in to the financial management and control system and obtaining the current ledger in the financial management and control system include:

Log in to the financial management and control system through the second RPA robot, and read the current ledger in the financial management and control system; wherein, the current ledger includes the following fields: account, financial control object, contract number, contract amount, billing amount , Invoice Number, Payment Amount, Book Balance, Voucher Temporary Number, Voucher Fixed Number, Receipt Date, Billing Date, Business Department, Reconciliation Result and Reversal Amount.

In one or more possible embodiments, the current ledger includes multiple pieces of ledger data, and the invoice list data includes multiple pieces of invoice data;

The checking of the current ledger and the invoice list data according to a preset checking rule includes:

Obtain the invoice data associated with each ledger data;

Check whether the amount in the ledger data is greater than the amount in the associated invoice data.

In one or more possible embodiments, the bank flow data includes multiple pieces of sub-flow data, and the voucher data includes multiple pieces of sub voucher data;

Wherein, the checking of the bank flow data and the voucher data includes:

Determine the sub-credential data associated with each sub-flow data;

Check whether the amount of the sub-flow data is consistent with the amount of the associated sub-voucher data.

In one or more possible embodiments, assigning a voucher fixed number to each financial voucher:

Get the timestamp of the financial document and the value of each field;

Hash operation is performed according to the obtained content to obtain the fixed number of the certificate.

In one or more possible embodiments, the auditing of the financial voucher includes: whether the value of the field is empty, whether the value of the field is within a preset range, and whether the values of the two associated fields have a preset value relationship.

It should be noted that, when the device 4 provided in the above embodiment executes the method for producing financial certificates, only the division of the above functional modules is used as an example for illustration. In practical applications, the above functions can be allocated to different functional modules as required , that is, dividing the internal structure of the device into different functional modules to complete all or part of the above functions. In addition, the financial certificate preparation device and the financial certificate preparation method provided by the above embodiments belong to the same concept, and the implementation process of the financial certificate preparation method is described in the method embodiment, which will not be repeated here.

The above-mentioned serial numbers of the embodiments of the present application are only for description, and do not represent the advantages or disadvantages of the embodiments.

Embodiments of the present application further provide a computer storage medium, where the computer storage medium can store multiple instructions, and the instructions are suitable for being loaded by a processor and executing the method steps of the embodiment shown in FIG. 2 above. For the process, reference may be made to the specific description of the embodiment shown in FIG. 2 , which will not be repeated here.

The present application also provides a computer program product, the computer program product stores at least one instruction, and the at least one instruction is loaded and executed by the processor to implement the financial certification method described in each of the above embodiments.

Please refer to FIG. 5 , which provides a schematic structural diagram of a computer device according to an embodiment of the present application. As shown in FIG. 5 , the computer device 500 may include: at least one processor 501 , at least one network interface 504 , user interface 503 , memory 505 , and at least one communication bus 502 .

Among them, the communication bus 502 is used to realize the connection and communication between these components.

The user interface 503 may include a display screen (Display) and a camera (Camera), and the optional user interface 503 may also include a standard wired interface and a wireless interface.

Wherein, the network interface 504 may optionally include a standard wired interface and a wireless interface (eg, a WI-FI interface).

The processor 501 may include one or more processing cores. The processor 501 uses various interfaces and lines to connect various parts of the entire computer device 500, and executes by running or executing the instructions, programs, code sets or instruction sets stored in the memory 505, and calling the data stored in the memory 505. Various functions of the computer device 500 and processing data. Optionally, the processor 501 may adopt at least one of a digital signal processing (Digital Signal Processing, DSP), a field-programmable gate array (Field-Programmable GateArray, FPGA), and a programmable logic array (Programmable Logic Array, PLA). implemented in hardware. The processor 501 may integrate one or a combination of a central processing unit (Central Processing Unit, CPU), a graphics processing unit (Graphics Processing Unit, GPU), a modem, and the like. Among them, the CPU mainly handles the operating system, user interface, and application programs; the GPU is used to render and draw the content that needs to be displayed on the display screen; the modem is used to handle wireless communication. It can be understood that, the above-mentioned modem may not be integrated into the processor 501, but is implemented by a single chip.

The memory 505 may include random access memory (Random Access Memory, RAM), or may include read-only memory (Read-Only Memory). Optionally, the memory 505 includes a non-transitory computer-readable storage medium. Memory 505 may be used to store instructions, programs, codes, sets of codes, or sets of instructions. The memory 505 may include a stored program area and a stored data area, wherein the stored program area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playback function, an image playback function, etc.), Instructions and the like used to implement the above method embodiments; the storage data area may store the data and the like involved in the above method embodiments. The memory 505 can optionally also be at least one storage device located away from the aforementioned processor 501 . As shown in FIG. 5 , the memory 505 as a computer storage medium may include an operating system, a network communication module, a user interface module and an application program.

In the computer device 500 shown in FIG. 5 , the user interface 503 is mainly used to provide an input interface for the user, and obtain the data input by the user; and the processor 501 can be used to call the application program stored in the memory 505, and specifically execute the following steps: For the method shown in FIG. 2, reference may be made to the specific process shown in FIG. 2, and details are not repeated here.

Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be implemented by instructing relevant hardware through a computer program, and the program can be stored in a computer-readable storage medium. During execution, the processes of the embodiments of the above-mentioned methods may be included. Wherein, the storage medium can be a magnetic disk, an optical disk, a read-only storage memory, or a random storage memory, and the like.

The above disclosures are only the preferred embodiments of the present application, and of course, the scope of the rights of the present application cannot be limited by this. Therefore, equivalent changes made according to the claims of the present application are still within the scope of the present application.

Claims (10)

1. A method for making financial certificates, characterized in that, comprising: Log in to the production management system and obtain invoice list data in the production management system; Log in to the financial management and control system and obtain the current ledger in the financial management and control system; Checking the current account and the invoice list data according to a preset check rule, and updating the current account according to the check result; reading the current ledger in the financial management and control system; Generate financial vouchers according to the read transaction ledger; wherein, each financial voucher is associated with a voucher temporary number; Write back the voucher temporary number of each financial voucher to the read transaction ledger; Read the temporary number of each voucher in the current ledger; Reviewing and printing the financial vouchers associated with the temporary numbers of each voucher; After the audit is successful, assign a voucher fixed number to each financial voucher, write back the voucher fixed number of each financial voucher to the current account, and upload the written back account to the production management system; Log in to the online banking system and obtain bank flow data in the online banking system; Obtain voucher data representing attributes of each financial voucher from the current account of the financial management and control system; Checking the bank flow data and the voucher data, and updating the bank flow data according to the check result; Generate account receipt vouchers according to the updated bank flow data, and review the generated account receipt vouchers. 2. The method according to claim 1, wherein the logging in to the production management system and the acquisition of invoice list data in the production management system comprise: Log in to the production management system through the first RPA robot and obtain invoice list data in the production management system; wherein, the invoice list data includes the following fields: buyer unit, total price and tax, contract number, contract name, department and forecast Payment time. 3. The method according to claim 1 or 2, wherein the logging into the financial management and control system and obtaining the current ledger in the financial management and control system comprise: Log in to the financial management and control system through the second RPA robot, and read the current ledger in the financial management and control system; wherein, the current ledger includes the following fields: account, financial control object, contract number, contract amount, billing amount , Invoice Number, Payment Amount, Book Balance, Voucher Temporary Number, Voucher Fixed Number, Receipt Date, Billing Date, Business Department, Reconciliation Result and Reversal Amount. 4. The method according to claim 3, wherein the current ledger comprises multiple pieces of ledger data, and the invoice list data comprises multiple pieces of invoice data; The checking of the current ledger and the invoice list data according to a preset checking rule includes: Obtain the invoice data associated with each ledger data; Check whether the amount in the ledger data is greater than the amount in the associated invoice data. 5. The method according to claim 4, wherein the bank flow data comprises a plurality of sub-flow data, and the voucher data comprises a plurality of sub voucher data; Wherein, the checking of the bank flow data and the voucher data includes: Determine the sub-credential data associated with each sub-flow data; Check whether the amount of the sub-flow data is consistent with the amount of the associated sub-voucher data. 6. The method according to claim 4 or 5, characterized in that, assigning a voucher fixed number to each financial voucher: Get the timestamp of the financial document and the value of each field; Hash operation is performed according to the obtained content to obtain the fixed number of the certificate. 7. The method according to claim 6, wherein the auditing of financial vouchers includes: whether the value of the field is empty, whether the value of the field is within a preset range, and whether the value of the two associated fields has a preset value relation. 8. A financial certificate-making device, characterized in that, comprising: an acquisition unit for logging into the production management system and acquiring invoice list data in the production management system; The obtaining unit is further configured to log in to the financial management and control system and obtain the current ledger in the financial management and control system; a checking unit, configured to check the current account and the invoice list data according to a preset check rule, and update the current account according to the check result; The acquisition unit is further configured to read the current ledger in the financial management and control system; The generating unit is used to generate financial vouchers according to the read transaction ledger; wherein, each financial voucher is associated with a voucher temporary number; The write-back unit is used to write back the voucher temporary number of each financial voucher to the read transaction ledger; The obtaining unit is also used to read the temporary number of each voucher in the current ledger; an auditing unit, configured to audit and print the financial vouchers associated with the temporary numbers of each voucher; The write-back unit is also used for assigning a voucher fixed number to each financial voucher after the audit is successful, writing back the voucher fixed number of each financial voucher to the current account, and uploading the written-back account. to the production management system; The obtaining unit is also used to log in to the online banking system and obtain bank flow data in the online banking system; The obtaining unit is further configured to obtain voucher data representing the attributes of each financial voucher in the current ledger of the financial management and control system; The checking unit is further configured to check the bank flow data and the voucher data, and update the bank flow data according to the check result; The auditing unit is further configured to generate an account receipt voucher according to the updated bank flow data, and to audit the generated account receipt voucher. 9. A computer storage medium, characterized in that the computer storage medium stores a plurality of instructions, the instructions are suitable for being loaded by a processor and performing the method steps of any one of claims 1-7. 10. A computer device, comprising: a processor and a memory; wherein the memory stores a computer program, the computer program is adapted to be loaded by the processor and execute any one of claims 1 to 7 method steps for the item.

Images