CN111402022A - Merchant account checking method and device - Google Patents
Merchant account checking method and device Download PDFInfo
- Publication number
- CN111402022A CN111402022A CN202010163077.6A CN202010163077A CN111402022A CN 111402022 A CN111402022 A CN 111402022A CN 202010163077 A CN202010163077 A CN 202010163077A CN 111402022 A CN111402022 A CN 111402022A
- Authority
- CN
- China
- Prior art keywords
- reconciliation
- data
- request information
- source
- checking
- 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
- 238000000034 method Methods 0.000 title claims abstract description 48
- 238000004590 computer program Methods 0.000 claims description 8
- 238000000605 extraction Methods 0.000 claims description 5
- 230000006870 function Effects 0.000 claims description 3
- 230000008569 process Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The utility model provides a merchant reconciliation method, which comprises the steps of receiving reconciliation request information and determining a source database from at least one transaction database according to the reconciliation request information; extracting source data from the source database; downloading target data corresponding to the account checking request information from a target server; and checking accounts according to the source data and the target data to generate a checking account result. The method can safely, quickly and efficiently finish the account checking operation of the merchant, ensure the accuracy of the account checking result, reduce the labor cost required in the account checking operation, and has the usability and feasibility of the operation. The disclosure also provides a merchant account checking device.
Description
Technical Field
The disclosure relates to the technical field of intelligent hardware and mobile payment, in particular to a merchant account checking method and device.
Background
In the prior art, along with the popularization of electronic payment methods, more and more electronic payment methods (such as WeChat, Paibao, Unionpay and the like) are accepted by consumers, and meanwhile, great convenience is brought to people.
However, in the process of checking the bill, the electronic payment mode causes great inconvenience to the account checking work of financial staff, the checking process is very complicated and inefficient, and due to the inconclusive nature of manual operation, the checking process is inevitable to cause errors and cause inaccuracy of the checking result.
Disclosure of Invention
In order to solve technical problems in the prior art, embodiments of the present disclosure provide a merchant account checking method and device, which can safely, quickly, and efficiently complete account checking operations of merchants, ensure accuracy of account checking results, reduce labor cost required in account checking operations, and have ease and feasibility of operations.
In a first aspect, an embodiment of the present disclosure provides a merchant reconciliation method, which receives reconciliation request information, and determines a source database from at least one transaction database according to the reconciliation request information; extracting source data from the source database; downloading target data corresponding to the account checking request information from a target server; and checking accounts according to the source data and the target data to generate a checking account result.
In one embodiment, the method further comprises the following steps: determining a source database from at least one transaction database according to a channel database identifier in the reconciliation request information; determining a source data table from the source database according to the table tag in the reconciliation request information; and extracting the source data from the source data table.
In one embodiment, the reconciliation request information includes: channel information and statement type.
In one embodiment, the channel information includes: payment treasure, WeChat, Unionpay, third party acquirer with collection license authority function and prepaid card.
In one embodiment, the reconciling according to the source data and the target data, and the generating a reconciliation result includes: extracting effective data of the source data to define as first characteristic data; extracting effective data of the target data to define as second characteristic data; checking the first characteristic data with the second characteristic data; and if the checking is consistent, the generated reconciliation result is correct.
In one embodiment, the method further comprises the following steps: and if the checking is inconsistent, the generated reconciliation result is an error and the error type is judged, wherein the error type is a lost data type and a difference data type.
In one embodiment, the method further comprises the following steps: the method comprises the steps of establishing at least one transaction database in advance, and setting channel library identification of the at least one transaction database and table labels of at least one data table in each channel database.
In a second aspect, the disclosed embodiments provide a computer-readable storage medium, on which a computer program is stored, which when executed by a processor, implements the steps of the method described above.
In a third aspect, the disclosed embodiments provide a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the method described above when executing the program.
In a fourth aspect, an embodiment of the present disclosure provides a merchant reconciliation device, where the device includes: the receiving and determining module is used for receiving the reconciliation request information and determining a source database from at least one transaction database according to the reconciliation request information; the extraction module is used for extracting source data from the source database; the downloading module is used for downloading target data corresponding to the account checking request information from a target server; and the reconciliation module is used for performing reconciliation according to the source data and the target data to generate a reconciliation result.
The invention provides a merchant reconciliation method and device, which are characterized in that reconciliation request information is received, and a source database is determined from at least one transaction database according to the reconciliation request information; extracting source data from the source database; downloading target data corresponding to the account checking request information from a target server; and checking accounts according to the source data and the target data to generate a checking account result. The method can safely, quickly and efficiently finish the account checking operation of the merchant, ensure the accuracy of the account checking result, reduce the labor cost required in the account checking operation, and has the usability and feasibility of the operation.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present disclosure, the drawings needed to be used in the description of the embodiments are briefly introduced as follows:
fig. 1 is a schematic flow chart illustrating steps of a merchant reconciliation method according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of a merchant reconciliation device in an embodiment of the present invention.
Detailed Description
The present application will now be described in further detail with reference to the accompanying drawings and examples.
In the following description, the terms "first" and "second" are used for descriptive purposes only and are not intended to indicate or imply relative importance. The following description provides embodiments of the disclosure, which may be combined or substituted for various embodiments, and this application is therefore intended to cover all possible combinations of the same and/or different embodiments described. Thus, if one embodiment includes feature A, B, C and another embodiment includes feature B, D, then this application should also be considered to include an embodiment that includes one or more of all other possible combinations of A, B, C, D, even though this embodiment may not be explicitly recited in text below.
In order to make the objects, technical solutions and advantages of the present invention more clearly apparent, the following describes in detail a specific implementation of the merchant reconciliation method and device according to the present invention by way of an embodiment with reference to the accompanying drawings. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
As shown in fig. 1, a schematic flow chart of a merchant reconciliation method in an embodiment specifically includes the following steps:
In addition, it should be further noted that, in an embodiment, the merchant reconciliation method according to the present disclosure further includes: the method comprises the steps of establishing at least one transaction database in advance, and setting channel library identification of the at least one transaction database and table labels of at least one data table in each channel database. Therefore, the account checking accuracy of the commercial tenant is improved.
And 104, extracting source data from the source database.
In one embodiment, a merchant reconciliation method related to the present disclosure further includes: determining a source database from at least one transaction database according to a channel database identifier in the reconciliation request information; determining a source data table from the source database according to the table tag in the reconciliation request information; and extracting the source data from the source data table. Therefore, the accuracy of source data extraction is improved.
And 106, downloading target data corresponding to the account checking request information from a target server.
And 108, checking accounts according to the source data and the target data to generate a checking account result.
Specifically, reconciling the source data with the target data, and generating a reconciliation result comprises: extracting effective data of the source data to define as first characteristic data; extracting effective data of the target data to define as second characteristic data; checking the first characteristic data with the second characteristic data; and if the checking is consistent, the generated reconciliation result is correct. In addition, in one embodiment, the merchant reconciliation method related to the present disclosure further includes: and if the checking is inconsistent, the generated reconciliation result is an error and the error type is judged, wherein the error type is a lost data type and a difference data type.
Further, it should be noted that, in the reconciliation process according to the source data and the target data, the reconciliation monitoring message is generated in real time. Therefore, the promptness and the usability of account checking are improved.
The invention provides a merchant reconciliation method, which comprises the steps of receiving reconciliation request information, and determining a source database from at least one transaction database according to the reconciliation request information; extracting source data from the source database; downloading target data corresponding to the account checking request information from a target server; and checking accounts according to the source data and the target data to generate a checking account result. The method can safely, quickly and efficiently finish the account checking operation of the merchant, ensure the accuracy of the account checking result, reduce the labor cost required in the account checking operation, and has the usability and feasibility of the operation.
Based on the same invention concept, the invention also provides a merchant account checking device. Because the principle of solving the problems of the device is similar to that of the merchant reconciliation method, the implementation of the device can be realized according to the specific steps of the method, and repeated parts are not repeated.
Fig. 2 is a schematic structural diagram of a merchant reconciliation apparatus in an embodiment. This merchant reconciliation device 10 includes: a reception and determination module 200, an extraction module 400, a download module 600, and a reconciliation module 800.
The receiving and determining module 200 is configured to receive reconciliation request information, and determine a source database from at least one transaction database according to the reconciliation request information; the extraction module 400 is configured to extract source data from the source database; the downloading module 600 is configured to download target data corresponding to the reconciliation request information from a target server; the reconciliation module 800 is configured to perform reconciliation according to the source data and the target data, and generate a reconciliation result.
The invention provides a merchant reconciliation device, which comprises a receiving and determining module, a transaction database and a source database, wherein the receiving and determining module is used for receiving reconciliation request information and determining the source database from at least one transaction database according to the reconciliation request information; extracting source data from the source database through an extraction module; downloading target data corresponding to the account checking request information from a target server through a downloading module; and finally, checking accounts according to the source data and the target data through a checking account module to generate a checking account result. The device can safely, quickly and efficiently complete account checking operation of the merchant, guarantee accuracy of account checking results, reduce labor cost required in account checking operation, and has usability and feasibility of operation.
An embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and the computer program is executed by the processor in fig. 1.
The embodiment of the invention also provides a computer program product containing the instruction. Which when run on a computer causes the computer to perform the method of fig. 1 described above.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.
The foregoing describes the general principles of the present disclosure in conjunction with specific embodiments, however, it is noted that the advantages, effects, etc. mentioned in the present disclosure are merely examples and are not limiting, and they should not be considered essential to the various embodiments of the present disclosure. Furthermore, the foregoing disclosure of specific details is for the purpose of illustration and description and is not intended to be limiting, since the disclosure is not intended to be limited to the specific details so described.
The block diagrams of devices, apparatuses, systems referred to in this disclosure are only given as illustrative examples and are not intended to require or imply that the connections, arrangements, configurations, etc. must be made in the manner shown in the block diagrams. These devices, apparatuses, devices, systems may be connected, arranged, configured in any manner, as will be appreciated by those skilled in the art. Words such as "including," "comprising," "having," and the like are open-ended words that mean "including, but not limited to," and are used interchangeably therewith. The words "or" and "as used herein mean, and are used interchangeably with, the word" and/or, "unless the context clearly dictates otherwise. The word "such as" is used herein to mean, and is used interchangeably with, the phrase "such as but not limited to".
Also, as used herein, the use of "or" in a list of items beginning with "at least one" indicates a separate list, e.g., "A, B or at least one of C" means A or B or C, or AB or AC or BC, or ABC (i.e., A and B and C). Furthermore, the word "exemplary" does not mean that the described example is preferred or better than other examples.
The foregoing description has been presented for purposes of illustration and description. Furthermore, this description is not intended to limit embodiments of the disclosure to the form disclosed herein. While a number of example aspects and embodiments have been discussed above, those of skill in the art will recognize certain variations, modifications, alterations, additions and sub-combinations thereof.
Claims (10)
1. A merchant reconciliation method, characterized in that the method comprises:
receiving reconciliation request information, and determining a source database from at least one transaction database according to the reconciliation request information;
extracting source data from the source database;
downloading target data corresponding to the account checking request information from a target server;
and checking accounts according to the source data and the target data to generate a checking account result.
2. The merchant reconciliation method of claim 1, further comprising:
determining a source database from at least one transaction database according to a channel database identifier in the reconciliation request information;
determining a source data table from the source database according to the table tag in the reconciliation request information;
and extracting the source data from the source data table.
3. The merchant reconciliation method of claim 1, wherein the reconciliation request information comprises: channel information and statement type.
4. The merchant reconciliation method of claim 3 wherein the channel information comprises: payment treasure, WeChat, Unionpay, third party acquirer with collection license authority function and prepaid card.
5. The merchant reconciliation method according to claim 1, wherein the reconciliation according to the source data and the target data, and the generating a reconciliation result comprises:
extracting effective data of the source data to define as first characteristic data;
extracting effective data of the target data to define as second characteristic data;
checking the first characteristic data with the second characteristic data;
and if the checking is consistent, the generated reconciliation result is correct.
6. The merchant reconciliation method of claim 5, further comprising: and if the checking is inconsistent, the generated reconciliation result is an error and the error type is judged, wherein the error type is a lost data type and a difference data type.
7. The merchant reconciliation method of claim 1, further comprising: the method comprises the steps of establishing at least one transaction database in advance, and setting channel library identification of the at least one transaction database and table labels of at least one data table in each channel database.
8. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 7.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1-7 are implemented when the program is executed by the processor.
10. A merchant reconciliation apparatus, the apparatus comprising:
the receiving and determining module is used for receiving the reconciliation request information and determining a source database from at least one transaction database according to the reconciliation request information;
the extraction module is used for extracting source data from the source database;
the downloading module is used for downloading target data corresponding to the account checking request information from a target server;
and the reconciliation module is used for performing reconciliation according to the source data and the target data to generate a reconciliation result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010163077.6A CN111402022A (en) | 2020-03-10 | 2020-03-10 | Merchant account checking method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010163077.6A CN111402022A (en) | 2020-03-10 | 2020-03-10 | Merchant account checking method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111402022A true CN111402022A (en) | 2020-07-10 |
Family
ID=71413307
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010163077.6A Pending CN111402022A (en) | 2020-03-10 | 2020-03-10 | Merchant account checking method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111402022A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111951091A (en) * | 2020-08-13 | 2020-11-17 | 金蝶软件（中国）有限公司 | Transaction flow reconciliation method, system and related equipment |
| CN112801792A (en) * | 2021-01-29 | 2021-05-14 | 上海微盟企业发展有限公司 | Information checking method, device, equipment and storage medium based on SaaS platform |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160171121A1 (en) * | 2014-10-06 | 2016-06-16 | Fujitsu Limited | Method, Controller, Program, and Data Storage System for Performing Reconciliation Processing |
| CN106874389A (en) * | 2017-01-11 | 2017-06-20 | 腾讯科技（深圳）有限公司 | The moving method and device of data |
| CN110298740A (en) * | 2019-06-24 | 2019-10-01 | 深圳乐信软件技术有限公司 | Data account checking method, device, equipment and storage medium |
| CN110415095A (en) * | 2019-07-24 | 2019-11-05 | 深圳乐信软件技术有限公司 | A kind of account checking method, device, terminal and storage medium |
| CN110765162A (en) * | 2019-09-06 | 2020-02-07 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Data comparison method and device, computer equipment and storage medium |
| CN110765179A (en) * | 2019-10-18 | 2020-02-07 | 京东数字科技控股有限公司 | Distributed account checking processing method, device, equipment and storage medium |
-
2020
- 2020-03-10 CN CN202010163077.6A patent/CN111402022A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160171121A1 (en) * | 2014-10-06 | 2016-06-16 | Fujitsu Limited | Method, Controller, Program, and Data Storage System for Performing Reconciliation Processing |
| CN106874389A (en) * | 2017-01-11 | 2017-06-20 | 腾讯科技（深圳）有限公司 | The moving method and device of data |
| CN110298740A (en) * | 2019-06-24 | 2019-10-01 | 深圳乐信软件技术有限公司 | Data account checking method, device, equipment and storage medium |
| CN110415095A (en) * | 2019-07-24 | 2019-11-05 | 深圳乐信软件技术有限公司 | A kind of account checking method, device, terminal and storage medium |
| CN110765162A (en) * | 2019-09-06 | 2020-02-07 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Data comparison method and device, computer equipment and storage medium |
| CN110765179A (en) * | 2019-10-18 | 2020-02-07 | 京东数字科技控股有限公司 | Distributed account checking processing method, device, equipment and storage medium |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111951091A (en) * | 2020-08-13 | 2020-11-17 | 金蝶软件（中国）有限公司 | Transaction flow reconciliation method, system and related equipment |
| CN111951091B (en) * | 2020-08-13 | 2023-12-29 | 金蝶软件（中国）有限公司 | Transaction flow reconciliation method, system and related equipment |
| CN112801792A (en) * | 2021-01-29 | 2021-05-14 | 上海微盟企业发展有限公司 | Information checking method, device, equipment and storage medium based on SaaS platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111062713B (en) | Payment system, method, server device, medium and device | |
| US11087371B2 (en) | Blockchain-based invoice creation method apparatus, and electronic device | |
| CN113222723B (en) | Bill processing method, device, equipment and storage medium | |
| CN111402022A (en) | Merchant account checking method and device | |
| CN104753909A (en) | Updated information authentication method, device and system | |
| CN109003071B (en) | Payment method, device and equipment | |
| EP3362968A1 (en) | Adaptable messaging | |
| CN110766392B (en) | Transaction processing method and device | |
| CN106201153B (en) | Operation entry display method and device | |
| CN113516479A (en) | Method, device and equipment for quick payment and storage medium thereof | |
| CN112347110B (en) | Data difference determining method, device, equipment and storage medium | |
| US11562361B2 (en) | Entity identification based on a record pattern | |
| CN110782310A (en) | Method, device and system for asynchronously acquiring user attribute information from third-party platform | |
| CN116308333A (en) | Method, system, device and storage medium for determining payment channel | |
| CN113419794B (en) | Payment processing method and device | |
| KR101832166B1 (en) | Method for processing payment, payment server and payment terminal thereof | |
| CN106815014B (en) | Information input prompting method and device | |
| US20220292505A1 (en) | Eliminating Transactions from Connected Accounts from False Answer Choices in Transaction Questions | |
| KR101636975B1 (en) | Method for Registering Card Information for Near Field Communication Payment, System And Payment Apparatus | |
| CN105378772A (en) | Dynamic currency conversion transaction system | |
| US20170352036A1 (en) | Methods and apparatus for authorizing a transaction | |
| CN112235395A (en) | Data distribution method and system based on network routing | |
| US20180322496A1 (en) | System and Method for Automated Switching of Payment Devices in a Payment Transaction | |
| EA041717B1 (en) | AUTOMATED SYSTEM AND METHOD FOR LINKING CASH CHECKS TO PAYMENT TRANSACTIONS | |
| US20190213590A1 (en) | Merchant payment system for crytpocurrency |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200710 |
|
| WD01 | Invention patent application deemed withdrawn after publication |