CN111798296A - Automatic account checking method, automatic account checking device and computer readable storage medium - Google Patents
Automatic account checking method, automatic account checking device and computer readable storage medium Download PDFInfo
- Publication number
- CN111798296A CN111798296A CN202010543530.6A CN202010543530A CN111798296A CN 111798296 A CN111798296 A CN 111798296A CN 202010543530 A CN202010543530 A CN 202010543530A CN 111798296 A CN111798296 A CN 111798296A
- Authority
- CN
- China
- Prior art keywords
- reconciliation
- transaction
- preset
- data
- accounting
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application discloses an automatic account checking method, automatic account checking equipment and a computer readable storage medium. The method comprises the following steps: receiving a preset account checking instruction; acquiring transaction data of a business from a target bank, and acquiring accounting data of the business corresponding to the target bank; and according to a preset reconciliation rule, checking the transaction data and the accounting data to generate a reconciliation result. By means of the method, quick and automatic account checking can be achieved, and account checking efficiency and accuracy of account checking data are improved.
Description
Technical Field
The present application relates to the field of financial management, and in particular, to an automatic reconciliation method, an automatic reconciliation device, and a computer-readable storage medium.
Background
The account checking refers to checking accounts, and in order to ensure the trueness, correctness and reliability of the records of the account book, the checking and checking of the account book and the related data recorded by the account book are the checking work.
At present, after an enterprise finishes a payment service, a manual account checking mode is usually adopted to check an account of a certain service, and cashiers of the enterprise are required to check the account data of the enterprise and transaction data of the enterprise in a bank one by one to find out an unreachable account so as to compile a bank balance adjustment table. The reconciliation mode needs a large amount of time consumption, has low accuracy rate and is very troublesome to check after errors occur.
Disclosure of Invention
The application provides an automatic account checking method, automatic account checking equipment and a computer readable storage medium, which can realize quick and automatic account checking, improve account checking efficiency and simultaneously improve accuracy of account checking data.
In order to solve the technical problem, the application adopts a technical scheme that: an automatic reconciliation method is provided. The method comprises the following steps: receiving a preset account checking instruction; acquiring transaction data of the enterprise from a target bank, and acquiring accounting data of the enterprise corresponding to the target bank; and according to a preset account checking rule, checking the transaction data and the accounting data to generate an account checking result.
In order to solve the above technical problem, another technical solution adopted by the present application is: an automatic reconciliation device is provided. The apparatus comprises a processor and a memory for storing a computer program for execution by the processor to implement the above-described automatic reconciliation method.
In order to solve the above technical problem, another technical solution adopted by the present application is: a computer-readable storage medium is provided. The computer-readable storage medium stores a computer program that is executed by a processor to implement the above-described automatic reconciliation method.
The beneficial effect of this application is: this application adopts robot flow automation technique to realize automatic reconciliation, after receiving and predetermine the reconciliation instruction, obtain the transaction data of enterprise from the target bank automatically to and obtain the accounting data of enterprise corresponding to the target bank and check one by one, in order to generate the reconciliation result, a large amount of reconciliation data of processing that can be automatic quick, improve reconciliation efficiency, simultaneously, need not the manual work and carry out the reconciliation, reduce the required overall cost of reconciliation, reduce the artifical mistake of reconciliation, improve the accuracy of reconciliation data.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative efforts.
FIG. 1 is a schematic flow chart diagram of a first embodiment of an automatic reconciliation method of the present application;
FIG. 2 is a schematic flow chart diagram of a second embodiment of the automatic reconciliation method of the present application;
FIG. 3 is a schematic structural diagram of a first embodiment of an automatic reconciliation device of the present application;
FIG. 4 is a schematic structural diagram of a second embodiment of the automatic reconciliation equipment of the present application;
fig. 5 is a schematic structural diagram of a computer-readable storage medium of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The terms "first", "second" and "third" in this application are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implying any indication of the number of technical features indicated. Thus, a feature defined as "first," "second," or "third" may explicitly or implicitly include at least one of the feature. In the description of the present application, "plurality" means at least two, e.g., two, three, etc., unless explicitly specifically limited otherwise. All directional indications (such as up, down, left, right, front, and rear … …) in the embodiments of the present application are only used to explain the relative positional relationship between the components, the movement, and the like in a specific posture (as shown in the drawings), and if the specific posture is changed, the directional indication is changed accordingly. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, article, or apparatus.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the application. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. Those skilled in the art will explicitly and implicitly appreciate that the embodiments described herein may be combined with other embodiments without conflict.
Referring to fig. 1, fig. 1 is a schematic flow chart of a first embodiment of an automatic reconciliation method according to the present application. The method comprises the following steps:
s110: and receiving a preset account checking instruction.
In the application, an automatic reconciliation method is realized by adopting a Robot Process Automation (RPA) technology, wherein the RPA is a software robot capable of simulating and integrating human behaviors in a system to optimize a business Process, and the RPA automatically captures data, runs an application program, triggers response and interacts with other systems to execute various tasks. Specifically, the RPA is implemented by a robot simulating manual operation, and automatically executes the service which originally needs to be repeatedly processed manually according to the algorithm rule preset by the program without changing the function of the existing service system. Taking the RPA robot as an example, the RPA robot can automatically check the account of a certain service to obtain the result of the account checking.
The preset account checking instruction can be an account checking instruction triggered by a user, and when the user triggers the preset account checking instruction of the RPA robot, the RPA robot can automatically check the account. The preset reconciliation instruction may also be a timing-triggered reconciliation instruction, and the reconciliation instruction of the relevant service may be automatically generated within a trigger time, for example, the reconciliation instruction of the previous day may be triggered within a fixed time of each day to reconcile the previous day, or the reconciliation instruction may be triggered on the first day of each month to reconcile the service of the previous month. Thus, the trigger time may be the first day of the week, the first day of the month, the first day of the year, and the like, and the application is not limited thereto.
S120: the method comprises the steps of obtaining transaction data of a business from a target bank, and obtaining accounting data of the business corresponding to the target bank.
When an enterprise needs to automatically check the payment service of a certain service, the RPA robot receives a preset checking instruction, acquires transaction data of the enterprise from a target bank and acquires accounting data of the enterprise corresponding to the target bank, wherein the target bank is a payment or receiving bank of the enterprise for the certain payment service, and the target bank can be a plurality of banks, that is, the target bank can correspond to a plurality of bank accounts of the plurality of banks.
Specifically, the RPA robot can simulate a user to automatically log in an online banking system of a target bank at regular time, and inquire transaction records within preset target inquiry time. For example, the RPA robot may simulate a user to log in an online banking system of a target bank, and query a transaction date on a specified date, where the specified date is a preset target query time of a payment service for a certain service that needs reconciliation, for example, the preset target query time is one week, one month, and the like, which is not limited in this application. The EPA robot can automatically download the inquired transaction record, and certainly, when the transaction record is inquired, element extraction can be carried out from an interface for displaying the transaction record so as to obtain the transaction record. In some application scenarios, the transaction record can be queried through the keyword to obtain the transaction record that the user needs to check account.
After obtaining the transaction record of the business from the target bank, the RPA robot may extract the first reconciliation information from the transaction record to obtain the transaction data. Wherein the first reconciliation information may include: one or a combination of transaction time, transaction account, transaction amount, transaction remarks and transaction order number. Specifically, the first reconciliation information may also be information such as a payer, a payment account, a payee, a collection account, a transaction time, a transaction amount, a transaction remark, and a transaction summary. This is not limited by the present application.
For obtaining the accounting records of the enterprise corresponding to the target bank, the RPA robot can store the address of the financial system of the enterprise, the robot simulates manual operation, automatically logs in the financial system, enters the function of inquiring the deposit journal of the bank, and inquires the accounting records corresponding to the target bank within the preset target inquiry time, wherein the preset target inquiry time is consistent with the preset target inquiry time for obtaining the transaction data of the enterprise from the target bank. In addition, in the event that the enterprise does not have a financial system, the accounting records of the enterprise that are recorded corresponding to the target bank may be stored in a designated directory so that the RPA robot may read the accounting records of the enterprise corresponding to the target bank. Specifically, the accounting record of the enterprise corresponding to the target bank within the preset target query time can be read according to the preset storage path of the accounting record. So that this application still can be carried out the reconciliation by RPA robot automatic acquisition accounting record under the no financial system's of enterprise condition to obtain the reconciliation result, do not influence reconciliation efficiency.
After the accounting records of the enterprise corresponding to the target bank are obtained, second accounting information can be extracted from the accounting records to obtain accounting data. Wherein, the second reconciliation information may include: one or a combination of transaction time, transaction account, transaction amount, transaction remarks and transaction order number. Specifically, the second account checking information may also be information such as a payer, a payment account, a payee, a collection account, a transaction time, a transaction amount, a transaction remark, and a transaction summary. This is not limited by the present application.
S130: and according to a preset account checking rule, checking the transaction data and the accounting data to generate an account checking result.
And setting reconciliation rules in advance, wherein the reconciliation rules can be set according to reconciliation requirements, the presetting reconciliation rules comprise the steps of judging whether the transaction data is consistent with the corresponding preset reconciliation information in the bookkeeping data, and if so, determining the reconciliation result as the reconciliation is consistent. For example, when one or a combination of the transaction time, the transaction account, the transaction time, the transaction remark or the transaction summary is consistent, the preset reconciliation information includes the transaction amount, for example, the preset reconciliation rule includes that whether the transaction amount is consistent with the corresponding transaction amount in the accounting data is judged, and if so, the reconciliation result is determined to be consistent.
Specifically, in this step, the preset reconciliation rule includes: and judging whether the transaction data with the same characteristic reconciliation information exists in the transaction data and the accounting data. The characteristic reconciliation information can be transaction time consistency, transaction account, transaction time, transaction remark or transaction abstract, if the characteristic reconciliation information exists, the reconciliation data can be judged to be the same transaction, and the transaction amount of the transaction data and the accounting data is compared according to the characteristic reconciliation information. And if the data does not exist, comparing the transaction account number, the transaction amount and the transaction time according to the transaction data and the accounting data. In the process of data comparison, if the transaction amount of the transaction data is consistent with that of the accounting data, the account can be judged to be reached, and the account checking result is determined to be consistent; if the account checking result is inconsistent, the account checking result can be determined to be consistent. In addition, if the reconciliation data of only one of the transaction data and the accounting data does not have the same characteristic reconciliation information, the reconciliation data can be judged to be an unaccounted item, and the reconciliation result can be determined to be inconsistent.
And according to a preset reconciliation rule, sequentially checking the obtained transaction data and the accounting data, and comparing each piece of transaction data with each piece of accounting data, namely comparing the transaction data with the accounting data one by one to obtain reconciliation data and storing a reconciliation result.
After the reconciliation is finished, a bank balance adjusting table can be generated according to the reconciliation result, and specifically, the robot registers the reconciliation result which is inconsistent with the reconciliation result according to the preset filling requirement and fills the reconciliation result in the bank balance adjusting table. The preset form filling requirement is a format requirement of a bank balance adjusting form, and the format requirement of the bank balance adjusting form can be set according to the specific requirement of a user. For example, after reconciliation is completed, a bank balance adjustment table is generated according to a reconciliation result of inconsistent transaction data and accounting data so as to display account unacknowledged of enterprises and target banks, the bank balance adjustment table can be checked, and a form of the bank balance adjustment table can be exported. In addition, besides the bank balance adjustment table can be generated according to the account checking result, other forms can be generated according to the requirement, such as a payment list unaccounted list detail table, a bank deposit table and/or an accounted form. This is not limited by the present application.
In this embodiment, a robot process automation technology is adopted to realize automatic reconciliation, the robot can automatically acquire transaction data of an enterprise from a target bank, acquire accounting data of the enterprise corresponding to the target bank and check the accounting data one by one to generate a reconciliation result, and can generate a bank balance adjustment table according to the reconciliation result so as to be convenient for a user to check. A large amount of reconciliation data of processing that can be quick improve reconciliation efficiency, simultaneously, need not the manual work and carry out the reconciliation, reduce the required overall cost of reconciliation, reduced the artifical mistake of reconciliation, improve the accuracy of reconciliation data.
Referring to fig. 2, fig. 2 is a schematic flowchart illustrating an automatic reconciliation method according to a second embodiment of the present application. The method comprises the following steps:
s210: the method comprises the steps of acquiring and saving first setting information input by a user, and acquiring and saving second setting information input by the user.
Before account checking is started by Robot Process Automation (RPA), relevant operation information can be set. The first setting information and the second setting information may be obtained through a user input mode, where the user input mode may also be a mode in which a user imports documents of the first setting information and the second setting information, and the like, and the application is not limited thereto.
The RPA robot acquires and stores first setting information input by a user, wherein the first setting information input by the user comprises at least one of the following: the system comprises a login account and a password of the online banking system, a login account and a password of the financial system, preset target query time, a storage path of acquired data and a file naming rule of the acquired data.
The RPA robot acquires and stores a login website of an online banking system of a target bank and user information of a user in the target bank, wherein the user information comprises information such as a login account and a password of the user, so that the robot can automatically log in the online banking system of the target bank to acquire transaction data. And acquiring and storing login website and user information of the financial system of the enterprise, wherein the user information comprises information such as a login account, a password and the like, so that the robot can automatically log in the financial system of the enterprise to acquire accounting data. If the enterprise does not have the financial system, the accounting data of the enterprise is obtained and saved, and the storage address or the storage path of the accounting data of the enterprise is saved, so that the robot can read the accounting data through the storage path. A target query time may also be set, for example, a preset target query time input by the user may be acquired and saved, and the preset target query time may be daily, weekly, monthly, and the like, so that the RPA robot automatically acquires the transaction data and the accounting data within the preset target query time for reconciliation. The preset target query time is not limited by the application. It is understood that the first setting information further includes a trigger time for triggering the reconciliation instruction, which may be selected according to a preset query time, for example, the trigger time for triggering the reconciliation instruction may be a certain time point of each day, a certain day of each week, a certain day of each month, and the like, without limitation.
The method and the device also set a storage path and a naming rule for the acquired data, and specifically, the storage path and the naming rule of the transaction record of the enterprise in the target bank can be acquired and stored, and the storage path and the naming rule of the transaction data are acquired after the first reconciliation information is extracted from the transaction record. Similarly, the storage path and the naming rule of the accounting record obtained from the enterprise are obtained and stored, and the storage path and the naming rule of the accounting data are obtained after the second accounting information is extracted from the accounting record. The RPA robot is used for acquiring data files from a storage path, wherein the storage path is used for storing the acquired data according to the storage path when the acquired data needs to be stored, and the naming rule is used for naming the acquired data according to the naming rule, so that the RPA robot automatically names the acquired data files according to the naming rule and automatically stores the data files under the designated path according to the storage path, and the data files can be acquired from the designated path subsequently.
In addition, second setting information input by a user is acquired and saved, wherein the second setting information comprises at least one of the following: presetting the content of a reconciliation rule, a storage path of a reconciliation result, a naming rule of the reconciliation result, a storage path of a balance adjustment table, a naming rule of the balance adjustment table and the content of a preset filling requirement. And if the transaction account, the transaction time, the transaction summary, the transaction amount and the like are consistent in the preset reconciliation rule, the reconciliation result can be confirmed to be consistent. The preset reconciliation rule can refer to the specific implementation process of the above embodiment, which is not described herein again. The storage path is used for storing the reconciliation result or the balance adjustment table according to the storage path, and the naming rule is used for naming the file containing the reconciliation result or the balance adjustment table according to the naming rule.
In some embodiments, the second setting information further includes a feedback mode and feedback information, so that the robot automatically sends the feedback information according to the feedback mode, where the feedback mode includes an Instant Messaging tool, where Instant Messaging (IM) is a real-time communication system, allowing two or more people to communicate text messages, files, voice and video in real time using a network. For example, the instant messaging tool may include messaging, email, telephone, fax, etc. The feedback information may include the captured transaction records, transaction data, accounting records, accounting data, reconciliation results, bank balance adjustment tables, and the like. The feedback transmission mode and the feedback information are not limited by the application.
S220: and receiving a preset account checking instruction.
The specific implementation of this step can refer to the implementation process of step S110 in the above embodiments, and is not described herein again.
S230: the method comprises the steps of obtaining transaction data of a business from a target bank, and obtaining accounting data of the business corresponding to the target bank.
The method comprises the steps of reading first setting information of an enterprise and a target bank for reconciliation, automatically logging in the online banking system of the target bank to obtain a transaction record according to a login address and user information of the online banking system of the inquired target bank, extracting first reconciliation information from the transaction record to obtain transaction data, naming the transaction record and the transaction data according to a naming rule, and storing the transaction record and the transaction data according to a storage path. According to the login address and the user information of the financial system of the enterprise, the financial system of the enterprise is automatically logged in to obtain the accounting record of the enterprise corresponding to the target bank, the second account checking information is extracted from the accounting record to obtain accounting data, the accounting data and the accounting data are named according to naming rules respectively, and the accounting data are stored according to storage paths respectively.
S240: and according to a preset account checking rule, checking the transaction data and the accounting data to generate an account checking result.
Reading the second setting information, obtaining the content of a preset reconciliation rule, reconciling the transaction data and the bookkeeping data according to the preset reconciliation rule, generating a reconciliation result, naming the reconciliation result according to the naming rule of the reconciliation result of the second setting information, and storing the reconciliation result under the specified path according to the storage path of the reconciliation result of the second setting information. The specific implementation of this step can refer to the implementation process of step S130 in the above embodiments, and is not described herein again.
S250: and filling the account checking result with inconsistent checking into a balance adjustment table according to a preset filling requirement.
Generating a bank balance adjusting table according to the account checking result, specifically, filling the inconsistent account checking result into the bank balance adjusting table according to the content of the preset filling requirement in the second setting information to generate the bank balance adjusting table, naming the bank balance adjusting table according to the naming rule of the balance adjusting table in the second setting information, and storing the bank balance adjusting table under the appointed path according to the storage path of the balance adjusting table. The specific implementation of this step can refer to the implementation process of step S130 in the above embodiments, and is not described herein again.
S260: and feeding back at least one of the account checking result and the balance adjustment table to the user according to a preset feedback mode.
The RPA robot can feed back the account checking result or the balance adjustment table to the user according to a preset feedback mode, wherein the feedback mode comprises the following steps: at least one of mail, short message, telephone and fax. The preset feedback mode can also be a display, printing, export and other feedback modes, so that a user can check account checking results or a bank balance adjustment table conveniently. In addition, feedback information can be sent in a preset feedback mode, and the feedback information can also comprise transaction records, transaction data, accounting records, accounting data, payment list unaccounted account detail tables, bank deposit tables and/or accounted forms and the like. The preset feedback mode and the feedback information are not limited.
The specific implementation of this embodiment can refer to the implementation process of the above embodiment, and is not described herein again.
In this embodiment, by acquiring and storing the first setting information and the second setting information, the RPA robot may automatically perform reconciliation according to the first setting information and the second setting information, name the obtained transaction record, transaction data, accounting record, accounting data, reconciliation result, or bank balance adjustment table, and store the naming result, the naming record, the accounting result, or the bank balance adjustment table in the specified path, so that the user may view the result in the specified path. Meanwhile, transaction data of the enterprise are automatically acquired from the target bank, accounting data of the enterprise corresponding to the target bank are automatically acquired, the transaction data and the recorded data are checked one by one to generate an account checking result, and meanwhile, a bank balance adjusting table or other forms are automatically generated according to the account checking result and fed back to the user, so that the user can quickly check the account checking result. The account checking method and the account checking device can automatically and quickly check the account keeping data of the enterprise and the transaction data of the bank, improve the account checking efficiency, simultaneously, do not need manual account checking, reduce the overall cost required by account checking, reduce the manual error of account checking, and improve the accuracy of account checking data.
For the above embodiments, the present application provides an automatic reconciliation device, please refer to fig. 3, and fig. 3 is a schematic structural diagram of a first embodiment of the automatic reconciliation device of the present application. The automatic reconciliation device 300 comprises: an acquisition module 310 and a reconciliation module 320. In this embodiment, the automatic reconciliation device may be a robot that realizes Robot Process Automation (RPA), or may be another terminal, such as a computer, and is not limited herein.
The obtaining module 310 is configured to obtain transaction data of the enterprise from the target bank after receiving the preset reconciliation instruction, and obtain accounting data of the enterprise corresponding to the target bank.
In some embodiments, the obtaining module 310 is configured to obtain transaction data of a business from a target bank, and includes: and acquiring a transaction record of the enterprise from the target bank, and extracting first reconciliation information from the transaction record to obtain transaction data. The obtaining module 310 is configured to obtain billing data of the enterprise corresponding to the target bank, and includes: and acquiring the accounting record of the enterprise corresponding to the target bank, and extracting second accounting information from the accounting record to obtain accounting data. Wherein, first reconciliation information and second reconciliation information include: one or a combination of transaction time, transaction account, transaction amount, transaction remarks and transaction order number.
In some embodiments, the obtaining module 310 is configured to obtain a transaction record of a business from a target bank, including: logging in an online banking system of a target bank, and inquiring transaction records within preset target inquiry time; and download the transaction record. In addition, element extraction can be carried out from the interface for displaying the transaction record so as to obtain the transaction record.
In some embodiments, the obtaining module 310 is configured to obtain the accounting record of the enterprise corresponding to the target bank, and includes: logging in the financial system of the enterprise, and inquiring accounting records corresponding to the target bank within the preset target inquiry time. Under the condition that the enterprise does not have a financial system, the accounting records of the enterprise corresponding to the target bank within the preset target query time can be read according to the preset storage path of the accounting records.
The reconciliation module 320 is configured to collate the transaction data and the accounting data according to a preset reconciliation rule to generate a reconciliation result.
In some embodiments, the reconciliation module 320 is configured to reconcile the transaction data with the accounting data according to a preset reconciliation rule to generate a reconciliation result, including: according to a preset reconciliation rule, comparing the transaction data with the accounting data one by one, namely comparing each transaction data with each accounting data, and acquiring and storing a reconciliation result; and filling the account checking result with inconsistent checking into a balance adjustment table according to a preset filling requirement. Wherein, presetting the reconciliation rule comprises: and judging whether the transaction data is consistent with the corresponding preset account checking information in the bookkeeping data, and if so, determining that the account checking result is consistent.
In some embodiments, the automatic tie-out apparatus 300 further includes a setup module 330 and a feedback module 340.
The setting module 330 is configured to obtain and store first setting information input by a user, and obtain and store second setting information input by the user.
Wherein the first setting information input by the user includes at least one of: the method comprises the steps that a login account and a password of an online banking system of a target bank, a login account and a password of a financial system, preset target query time, a storage path of acquired data and naming rules of the acquired data are set; the storage path is used for storing the acquired data according to the storage path when the acquired data needs to be stored; the naming rule is used to name the file containing the retrieved data according to the naming rule.
Wherein the second setting information includes at least one of: presetting the content of a reconciliation rule, a storage path of a reconciliation result, a naming rule of the reconciliation result, a storage path of a balance adjustment table, a naming rule of the balance adjustment table and the content of a preset filling requirement, wherein the storage path is used for storing the reconciliation result or the balance adjustment table according to the storage path; the naming rule is used for naming the file containing the account checking result or the balance adjustment table according to the naming rule.
In addition, the setting module 330 is further configured to obtain and store a preset feedback mode and feedback information input by the user. The preset feedback mode is an instant communication tool, such as a short message, a mail, a telephone, a fax and the like. The feedback information comprises transaction records, transaction data, accounting records, accounting data, account checking results or bank balance adjustment tables and the like.
The feedback module 340 is configured to feed back at least one of the reconciliation result and the balance adjustment table to the user according to a preset feedback manner. In addition, the feedback module 340 is further configured to feed back feedback information such as the transaction record, the transaction data, the accounting record, and the accounting data to the user according to a preset feedback manner.
The specific implementation of this embodiment can refer to the implementation process of the above embodiment, and is not described herein again.
For the above embodiments, the present application provides an automatic reconciliation device, please refer to fig. 4, where fig. 4 is a schematic structural diagram of a second embodiment of the automatic reconciliation device of the present application. The automatic reconciliation device 400 comprises: a processor 410 and a memory 420, wherein the processor 410 is connected to the memory 420, and the memory 420 is used for storing a computer program, which is executed by the processor 410 to implement the steps of the automatic reconciliation method described above. The automatic reconciliation device 400 of this embodiment may be a robot, for example, an RPA robot for implementing Robot Process Automation (RPA), or may be another terminal, such as a computer, and is not limited herein.
In the present embodiment, the processor 410 may also be referred to as a CPU (Central Processing Unit). The processor 410 may be an integrated circuit chip having signal processing capabilities. The processor 410 may also be a general purpose processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other programmable logic device, discrete gate or transistor logic, discrete hardware components. A general purpose processor may be a microprocessor or the processor 410 may be any conventional processor or the like. The specific implementation of this embodiment can refer to the implementation process of the above embodiment, and is not described herein again.
For the method of the above embodiment, it may exist in the form of a computer program, so that the present application provides a computer readable storage medium, please refer to fig. 5, and fig. 5 is a schematic structural diagram of the computer readable storage medium of the present application. The computer-readable storage medium 500 of the present embodiment has stored therein a computer program 510 that can be executed by a processor to implement the method in the above-described embodiments.
The computer-readable storage medium 500 of this embodiment may be a medium that can store program instructions, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk, or may be a server that stores the program instructions, and the server may send the stored program instructions to other devices for operation, or may self-execute the stored program instructions.
In the several embodiments provided in the present application, it should be understood that the disclosed method and apparatus may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a module or a unit is merely a logical division, and an actual implementation may have another division, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, a network device, or the like) or a processor (processor) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
It will be apparent to those skilled in the art that the modules or steps of the present application described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of multiple computing devices, and they may alternatively be implemented by program code executable by a computing device, such that they may be stored in a storage device and executed by a computing device, or fabricated separately as individual integrated circuit modules, or fabricated as a single integrated circuit module from multiple modules or steps. Thus, the present application is not limited to any specific combination of hardware and software.
The above description is only for the purpose of illustrating embodiments of the present application and is not intended to limit the scope of the present application, and all modifications of equivalent structures and equivalent processes, which are made by the contents of the specification and the drawings of the present application or are directly or indirectly applied to other related technical fields, are also included in the scope of the present application.
Claims (10)
1. An automatic reconciliation method, characterized in that the method comprises:
receiving a preset account checking instruction;
acquiring transaction data of a business from a target bank, and acquiring accounting data of the business corresponding to the target bank;
and according to a preset reconciliation rule, checking the transaction data and the accounting data to generate a reconciliation result.
2. The method of claim 1,
the acquiring of the transaction data of the enterprise from the target bank comprises:
acquiring a transaction record of the enterprise from the target bank, and extracting first reconciliation information from the transaction record to obtain the transaction data;
the acquiring of the accounting data of the enterprise corresponding to the target bank comprises:
and acquiring accounting records of the enterprise corresponding to the target bank, and extracting second account checking information from the accounting records to obtain the accounting data.
3. The method of claim 2,
the obtaining the transaction record of the enterprise from the target bank comprises:
logging in an online banking system of the target bank, and inquiring the transaction record within preset target inquiry time;
downloading the transaction record, or extracting elements from an interface for displaying the transaction record to obtain the transaction record;
the obtaining of the accounting record of the enterprise corresponding to the target bank includes:
logging in a financial system of the enterprise and querying the accounting record corresponding to the target bank within the preset target query time, or,
reading the accounting record of the enterprise corresponding to the target bank within the preset target query time according to a preset storage path;
the first reconciliation information and the second reconciliation information comprise: one or a combination of transaction time, transaction account, transaction amount, transaction remarks and transaction order number.
4. The method of claim 3, wherein prior to receiving the preset reconciliation instruction, the method further comprises:
acquiring and saving first setting information input by a user, wherein the first setting information input by the user comprises at least one of the following: the login account and the password of the online banking system, the login account and the password of the financial system, the preset target query time, the storage path of the acquired data and the naming rule of the acquired data; the storage path is used for storing the acquired data according to the storage path when the acquired data needs to be stored; the naming rule is used for naming the file containing the acquired data according to the naming rule.
5. The method of claim 1, wherein the reconciling the transaction data with the accounting data according to a preset reconciliation rule to generate a reconciliation result comprises:
comparing each piece of transaction data with each piece of accounting data respectively according to the preset accounting rule, and storing the accounting result;
and filling the account checking result with inconsistent checking into a balance adjustment table according to a preset filling requirement.
6. The method of claim 5, wherein the pre-set reconciliation rule comprises: judging whether the transaction data is consistent with corresponding preset reconciliation information in the bookkeeping data, and if so, determining that the reconciliation result is consistent;
and/or, the method further comprises:
and feeding back at least one of the reconciliation result and the balance adjustment table to the user according to a preset feedback mode.
7. The method of claim 6,
the preset feedback mode comprises the following steps: and adopting instant messaging tool feedback.
8. The method of claim 5, wherein prior to receiving the preset reconciliation instruction, the method further comprises:
acquiring and saving second setting information input by a user, wherein the second setting information comprises at least one of the following: the content of the preset reconciliation rule, the storage path of the reconciliation result, the naming rule of the reconciliation result, the storage path of the balance adjustment table, the naming rule of the balance adjustment table and the content of a preset filling requirement are set, wherein the storage path is used for storing the reconciliation result or the balance adjustment table according to the storage path; and the naming rule is used for naming the file containing the account checking result or the balance adjustment table according to the naming rule.
9. An automatic reconciliation device, characterized in that the reconciliation device comprises: a processor and a memory for storing a computer program for execution by the processor to implement the method of any one of claims 1 to 8.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program which is executed by a processor to implement the method according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010543530.6A CN111798296A (en) | 2020-06-15 | 2020-06-15 | Automatic account checking method, automatic account checking device and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010543530.6A CN111798296A (en) | 2020-06-15 | 2020-06-15 | Automatic account checking method, automatic account checking device and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111798296A true CN111798296A (en) | 2020-10-20 |
Family
ID=72804786
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010543530.6A Pending CN111798296A (en) | 2020-06-15 | 2020-06-15 | Automatic account checking method, automatic account checking device and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111798296A (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112288567A (en) * | 2020-10-28 | 2021-01-29 | 山东浪潮通软信息科技有限公司 | Bank account information processing method and device and readable medium |
| CN112529697A (en) * | 2020-12-25 | 2021-03-19 | 北京来也网络科技有限公司 | Bank pipelining processing method and device combining RPA and AI |
| CN112699137A (en) * | 2021-01-04 | 2021-04-23 | 远光软件股份有限公司 | Cross-system financial data processing method and device |
| CN112712421A (en) * | 2020-12-29 | 2021-04-27 | 山东浪潮通软信息科技有限公司 | Method, equipment and storage medium for automatically downloading running bill |
| CN112801792A (en) * | 2021-01-29 | 2021-05-14 | 上海微盟企业发展有限公司 | Information checking method, device, equipment and storage medium based on SaaS platform |
| CN113077234A (en) * | 2021-04-09 | 2021-07-06 | 远光软件股份有限公司 | Account checking method, device and storage medium |
| CN113256271A (en) * | 2021-06-24 | 2021-08-13 | 深圳市凯莱特科技股份有限公司 | RPA robot system for financial marketing reconciliation and working method |
| CN113469805A (en) * | 2021-07-21 | 2021-10-01 | 上海浦东发展银行股份有限公司 | Accounting data accounting method, device, equipment and storage medium |
| CN113516552A (en) * | 2021-07-29 | 2021-10-19 | 中国工商银行股份有限公司 | Account checking and clearing method and device for financial services |
| CN113592635A (en) * | 2021-08-10 | 2021-11-02 | 北京来也网络科技有限公司 | Account checking method, device, equipment and medium based on RPA and AI |
| CN113837881A (en) * | 2021-09-28 | 2021-12-24 | 中电金信软件有限公司 | Transaction data updating method and device, electronic equipment and storage medium |
| CN117314662A (en) * | 2023-09-06 | 2023-12-29 | 金网络(北京)数字科技有限公司 | Intelligent account checking method, system, equipment and storage medium |
| CN117437076A (en) * | 2023-12-19 | 2024-01-23 | 太平金融科技服务（上海）有限公司 | Account checking method, device, equipment and medium based on account checking code |
| CN118096340A (en) * | 2024-04-29 | 2024-05-28 | 深圳市银雁科技有限公司 | Bank automatic account checking method, system and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101887546A (en) * | 2010-06-28 | 2010-11-17 | 深圳市拜特科技股份有限公司 | Method for realizing audit verification of account, audit verification of account system and revenue audit system |
| CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
| CN109711801A (en) * | 2018-12-13 | 2019-05-03 | 平安普惠企业管理有限公司 | A kind of Internetbank account checking method and device |
| CN111144886A (en) * | 2019-12-17 | 2020-05-12 | 远光软件股份有限公司 | Automatic bank account-arriving record processing method, system, equipment and storage medium |
-
2020
- 2020-06-15 CN CN202010543530.6A patent/CN111798296A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101887546A (en) * | 2010-06-28 | 2010-11-17 | 深圳市拜特科技股份有限公司 | Method for realizing audit verification of account, audit verification of account system and revenue audit system |
| CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
| CN109711801A (en) * | 2018-12-13 | 2019-05-03 | 平安普惠企业管理有限公司 | A kind of Internetbank account checking method and device |
| CN111144886A (en) * | 2019-12-17 | 2020-05-12 | 远光软件股份有限公司 | Automatic bank account-arriving record processing method, system, equipment and storage medium |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112288567A (en) * | 2020-10-28 | 2021-01-29 | 山东浪潮通软信息科技有限公司 | Bank account information processing method and device and readable medium |
| CN112529697A (en) * | 2020-12-25 | 2021-03-19 | 北京来也网络科技有限公司 | Bank pipelining processing method and device combining RPA and AI |
| CN112712421B (en) * | 2020-12-29 | 2023-03-28 | 浪潮通用软件有限公司 | Method, equipment and storage medium for automatically downloading running bill |
| CN112712421A (en) * | 2020-12-29 | 2021-04-27 | 山东浪潮通软信息科技有限公司 | Method, equipment and storage medium for automatically downloading running bill |
| CN112699137A (en) * | 2021-01-04 | 2021-04-23 | 远光软件股份有限公司 | Cross-system financial data processing method and device |
| CN112699137B (en) * | 2021-01-04 | 2023-09-12 | 远光软件股份有限公司 | Cross-system financial data processing method and device |
| CN112801792B (en) * | 2021-01-29 | 2023-04-07 | 上海微盟企业发展有限公司 | Information checking method, device, equipment and storage medium based on SaaS platform |
| CN112801792A (en) * | 2021-01-29 | 2021-05-14 | 上海微盟企业发展有限公司 | Information checking method, device, equipment and storage medium based on SaaS platform |
| CN113077234A (en) * | 2021-04-09 | 2021-07-06 | 远光软件股份有限公司 | Account checking method, device and storage medium |
| CN113256271A (en) * | 2021-06-24 | 2021-08-13 | 深圳市凯莱特科技股份有限公司 | RPA robot system for financial marketing reconciliation and working method |
| CN113469805A (en) * | 2021-07-21 | 2021-10-01 | 上海浦东发展银行股份有限公司 | Accounting data accounting method, device, equipment and storage medium |
| CN113516552A (en) * | 2021-07-29 | 2021-10-19 | 中国工商银行股份有限公司 | Account checking and clearing method and device for financial services |
| CN113592635A (en) * | 2021-08-10 | 2021-11-02 | 北京来也网络科技有限公司 | Account checking method, device, equipment and medium based on RPA and AI |
| CN113837881A (en) * | 2021-09-28 | 2021-12-24 | 中电金信软件有限公司 | Transaction data updating method and device, electronic equipment and storage medium |
| CN117314662A (en) * | 2023-09-06 | 2023-12-29 | 金网络(北京)数字科技有限公司 | Intelligent account checking method, system, equipment and storage medium |
| CN117437076A (en) * | 2023-12-19 | 2024-01-23 | 太平金融科技服务（上海）有限公司 | Account checking method, device, equipment and medium based on account checking code |
| CN117437076B (en) * | 2023-12-19 | 2024-03-19 | 太平金融科技服务（上海）有限公司 | Account checking method, device, equipment and medium based on account checking code |
| CN118096340A (en) * | 2024-04-29 | 2024-05-28 | 深圳市银雁科技有限公司 | Bank automatic account checking method, system and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111798296A (en) | Automatic account checking method, automatic account checking device and computer readable storage medium | |
| KR101805383B1 (en) | Launching a client application based on a message | |
| CN113222555B (en) | Data processing method, device, equipment and system | |
| CN108564462A (en) | Acquisition methods, terminal device and the medium of collage-credit data | |
| CN114358923A (en) | Business data processing method and device, storage medium and electronic equipment | |
| CN110738784B (en) | Invoice management method, device, server and system | |
| CN108734566A (en) | Collage-credit data querying method, terminal device and medium | |
| CN110659971B (en) | Transaction data processing method and device | |
| CN113806400A (en) | Financial data processing method and device, storage medium and electronic equipment | |
| CN113239400A (en) | Asset management method, device and system and electronic equipment | |
| KR100983478B1 (en) | Method and system for making housekeeping account book using messaging service of mobile terminal | |
| CN113112709A (en) | Method, device, self-service terminal and system for managing bill image pictures | |
| JP6307641B1 (en) | Banking system and the method implemented in the banking system | |
| CN113837855B (en) | Cloud network-based cross-border value-added tax batch intelligent processing method, device and equipment | |
| CN109598575B (en) | Bill generation method and device, electronic equipment and medium | |
| CN112559646A (en) | Report downloading method and device | |
| CN107730380B (en) | Method, system and server for processing joint account | |
| CN114742547A (en) | Internet online collection control method, device, medium and electronic equipment | |
| CN111461798B (en) | Big data-based ticket business processing method, device, medium and equipment for individual user | |
| CN113450166A (en) | Sales invoice processing method and corresponding business management system | |
| CN113946723A (en) | Data query method, device, server, system and storage medium | |
| CN112801842A (en) | Tax information sharing platform | |
| CN113468886A (en) | Work order processing method and device and computer equipment | |
| CN112801765A (en) | Generating method, device and system of reimbursement file, electronic equipment and storage medium | |
| CN109544785A (en) | A kind of automatic vending machine and transaction system |
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 |