CN111951091B - Transaction flow reconciliation method, system and related equipment - Google Patents
Transaction flow reconciliation method, system and related equipment Download PDFInfo
- Publication number
- CN111951091B CN111951091B CN202010811829.5A CN202010811829A CN111951091B CN 111951091 B CN111951091 B CN 111951091B CN 202010811829 A CN202010811829 A CN 202010811829A CN 111951091 B CN111951091 B CN 111951091B
- Authority
- CN
- China
- Prior art keywords
- identification field
- store identification
- order data
- bill
- bill data
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000012795 verification Methods 0.000 claims description 15
- 238000004590 computer program Methods 0.000 claims description 11
- 230000000875 corresponding effect Effects 0.000 description 31
- 230000008569 process Effects 0.000 description 13
- 238000012545 processing Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 6
- 238000004891 communication Methods 0.000 description 3
- 230000002596 correlated effect Effects 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 1
- 238000000802 evaporation-induced self-assembly Methods 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/38—Payment protocols; Details thereof
- G06Q20/389—Keeping log of transactions for guaranteeing non-repudiation of a transaction
-
- 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
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/12—Hotels or restaurants
Abstract
The embodiment of the invention provides a transaction flow checking method, a transaction flow checking system and related equipment, which are used for improving the transaction flow checking efficiency. The method of the embodiment of the invention comprises the following steps: acquiring order data of a plurality of stores, wherein each piece of order data comprises a store identification field and a collection account number, and the order data with the same store identification field value is associated and stored into the same order data packet, and the collection account numbers in the order data of the plurality of stores are all target account numbers; acquiring bill data corresponding to the target account number from a financial server, wherein each bill data comprises a store identification field; splitting the bill data corresponding to the target account number according to a store identification field, and splitting the bill data with the same value of the store identification field into the same bill data packet; and checking the bill data package and the order data package with the same value of the store identification field.
Description
Technical Field
The invention relates to the technical field of transaction flow reconciliation, in particular to a transaction flow reconciliation method, a system and related equipment.
Background
And when the settlement is carried out at the end of each month, financial staff needs to check out the POS system order (paid in a WeChat and Payment method) data with a transaction bill of a WeChat and Payment platform, and then obtains a check report to facilitate making financial certificates.
In the conventional transaction flow reconciliation technical implementation scheme, for example, in a Jin Dieyun starry sky (CLOUD) platform, weChat or Payment treasury bill data is compared with POS order payment data respectively according to the corresponding relation of WeChat order number, payment treasury order number and POS order payment data, and a reconciliation report is obtained according to the matching condition of the order number.
In the existing scheme, when the number of the customers stores is large, the same WeChat/Payment treasury account is used, the time span is one month, the transaction bill data size is large, each WeChat order number and Payment treasury order number are respectively matched by adopting a single process in series, the consumption time is long, the existing catering customers are taken as an example, the data size of WeChat/Payment treasury transaction flow of 300 stores for one month is in the tens of millions, the account checking process needs to last for 1 hour, the efficiency is low, and the user experience is poor.
Disclosure of Invention
The embodiment of the invention provides a transaction flow checking method, a transaction flow checking system and related equipment, which are used for improving the transaction flow checking efficiency.
A first aspect of an embodiment of the present invention provides a transaction flow reconciliation method, which may include:
acquiring order data of a plurality of stores, wherein each piece of order data comprises a store identification field and a collection account number, and the order data with the same store identification field value is associated and stored into the same order data packet, and the collection account numbers in the order data of the plurality of stores are all target account numbers;
acquiring bill data corresponding to the target account number from a financial server, wherein each bill data comprises a store identification field;
splitting the bill data corresponding to the target account number according to a store identification field, and splitting the bill data with the same value of the store identification field into the same bill data packet;
and checking the bill data package and the order data package with the same value of the store identification field.
Optionally, as a possible implementation manner, in an embodiment of the present invention, reconciling the bill data packet and the order data packet with the same value of the store identifier field includes:
and checking the bill data packet and the order data packet with the same value of the store identification field by adopting a plurality of threads.
Optionally, as a possible implementation manner, in an embodiment of the present invention, when the number of order data exceeds a preset threshold, the method further includes:
and checking the bill data package and the order data package with the same value of the store identification field in parallel by adopting a distributed server.
Optionally, as a possible implementation manner, the transaction flow reconciliation method in the embodiment of the present invention may further include:
and sending a payment request message to a financial server through a cashing device, wherein the request message at least comprises a store identification field and verification information, so that bill data are generated after the financial server passes verification, and each bill data comprises the store identification field.
Optionally, as a possible implementation manner, in the transaction flow reconciliation method in the embodiment of the present invention, the financial server is a server corresponding to a payment bank or WeChat payment service.
Optionally, as a possible implementation manner, in the transaction flow reconciliation method in the embodiment of the present invention, the payment request message includes a remark field, and the method further includes: filling a preset store identification field in the remark field.
A second aspect of an embodiment of the present invention provides a transaction flow reconciliation system, which may include:
the first acquisition module is used for acquiring order data of a plurality of stores, each piece of order data comprises a store identification field and a collection account number, the order data with the same store identification field value are associated and stored into the same order data packet, and the collection account numbers in the order data of the stores are all target account numbers;
the second acquisition module is used for acquiring bill data corresponding to the target account number from the financial server, and each bill data comprises a store identification field;
the splitting module is used for splitting the bill data corresponding to the target account number according to the shop identification field, and splitting the bill data with the same shop identification field value into the same bill data packet;
and the checking module checks the bill data package and the order data package with the same value of the store identification field.
Optionally, as a possible implementation manner, the reconciliation module in the embodiment of the present invention may include:
and the first checking unit adopts a plurality of threads to check the bill data packet and the order data packet with the same store identification field value.
Optionally, as a possible implementation manner, the reconciliation module in the transaction flow reconciliation system in the embodiment of the present invention may further include:
and when the number of the order data exceeds a preset threshold value, the second reconciliation unit adopts a distributed server to reconcile the bill data packets and the order data packets with the same store identification field value in parallel.
Optionally, as a possible implementation manner, the transaction flow reconciliation system in the embodiment of the present invention may further include:
and the control module is used for sending a payment request message to the financial server through the cashing equipment, wherein the request message at least comprises a store identification field and verification information, so that bill data are generated after the financial server passes verification, and each bill data comprises the store identification field.
Optionally, as a possible implementation manner, in the transaction flow reconciliation system in the embodiment of the present invention, the payment request message includes a remark field, and may further include: and the calling module is used for filling a preset store identification field in the remark field.
A third aspect of the embodiments of the present invention provides a computer apparatus comprising a processor for implementing the steps as in any one of the possible implementations of the first aspect and the first aspect when executing a computer program stored in a memory.
A fourth aspect of the embodiments of the present invention provides a computer readable storage medium having stored thereon a computer program which when executed by a processor performs steps as in any one of the possible implementations of the first aspect and the first aspect.
From the above technical solutions, the embodiment of the present invention has the following advantages:
in the embodiment of the invention, the transaction flow checking system can acquire order data of a plurality of shops and store the order data with the same shop identification field value in a same order data packet in a correlated way; then acquiring bill data corresponding to the target account number from a financial server, wherein each bill data comprises a store identification field; splitting bill data corresponding to the target account number according to a store identification field, and splitting the bill data with the same value of the store identification field into the same bill data packet; and finally checking the bill data package and the order data package with the same value of the store identification field. Compared with the prior art, one order data does not need to be matched with the bill data of all stores one by one, and only the bill data in the bill data packet with the same value as the identification field value of the store is matched one by one, so that the data matching times in the checking process can be greatly reduced, the checking efficiency is improved, and the user experience is improved.
Drawings
FIG. 1 is a schematic diagram of an embodiment of a transaction flow reconciliation method in accordance with an embodiment of the invention;
FIG. 2 is a schematic diagram of an embodiment of a transaction flow reconciliation method in accordance with an embodiment of the invention;
FIG. 3 is a schematic diagram of a packet splitting flow in an embodiment of a transaction flow reconciliation method in accordance with an embodiment of the invention;
FIG. 4 is a schematic diagram of a distributed reconciliation process in a specific application embodiment of a transaction flow reconciliation method in accordance with an embodiment of the invention;
FIG. 5 is a schematic diagram of one embodiment of a transaction flow reconciliation system in accordance with an embodiment of the invention;
FIG. 6 is a diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The embodiment of the invention provides a transaction flow checking method, a transaction flow checking system and related equipment, which are used for improving the transaction flow checking efficiency.
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
The terms first, second, third, fourth and the like in the description and in the claims and in the above drawings are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments described herein may be implemented in other sequences than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
In the existing transaction flow checking process, each order data needs to be matched with a plurality of bill data one by one, for example, when 10 orders data and 10 bill data are checked, one order data needs to be matched with 10 bill data respectively, 100 times of matching is needed, time and labor are wasted, and efficiency is low. In the embodiment of the application, the store identification field is added into the order data and the bill data, and the order data and the bill data are classified according to the store identification field, so that the reconciliation efficiency is improved.
For ease of understanding, a specific flow in the embodiment of the present invention is described below with reference to fig. 1, and an embodiment of a transaction flow checking method in the embodiment of the present invention may include:
101. acquiring order data of a plurality of stores, and storing the order data with the same store identification field value in a same order data packet in an associated manner, wherein collecting account numbers in the order data of the plurality of stores are all target account numbers;
in practical application, the collection accounts of stores belonging to the same company are often the same, and in order to distinguish the source of each order data, in the embodiment of the present invention, an identification field is allocated to each store in advance, and the field value of the identification field of each store is different, so as to uniquely identify each store. When order data of a plurality of stores are acquired, each piece of order data comprises a store identification field and a collection account number, the transaction flow checking system can store the order data with the same store identification field value in a correlated mode into the same order data package, and therefore all the order data are split into a plurality of order data packages.
Optionally, the financial server in the embodiment of the present invention may be a server corresponding to a payment device or a WeChat payment service, or may be a server corresponding to each financial institution (e.g. a bank), which is not limited herein.
102. Acquiring bill data corresponding to a target account number from a financial server, wherein each bill data comprises a store identification field;
after the cashing equipment of the store sends the payment request message to the financial server, the financial server records a transaction bill after verification is passed, so that in the process of checking, the transaction flow checking system can acquire bill data corresponding to the target account number from the financial server, and each bill data comprises a store identification field.
Optionally, as a possible implementation manner, the transaction running reconciliation system in the embodiment of the present invention may send a payment request message to the financial server through the cashier device, where the request message includes at least a store identifier field and verification information, so that the financial server generates bill data after verification, and each piece of bill data includes the store identifier field.
103. Splitting bill data corresponding to the target account number according to a store identification field, and splitting the bill data with the same value of the store identification field into the same bill data packet;
after the bill data corresponding to the target account is obtained, the transaction flow reconciliation system can split the bill data corresponding to the target account according to the store identification field, and the bill data with the same value of the store identification field is split into the same bill data packet.
104. And checking the bill data package and the order data package with the same value of the store identification field.
After the statement data is split according to the store identification field, the transaction flow reconciliation system can reconcile the statement data packet with the order data packet having the same store identification field value. For example, 10 order data of 5 stores are split into 5 data packets, and 2 order data of each data packet are matched for only 10 times in the reconciliation process, so that the reconciliation efficiency is greatly improved.
In the embodiment of the invention, the transaction flow checking system can acquire order data of a plurality of shops and store the order data with the same shop identification field value in a same order data packet in a correlated way; then acquiring bill data corresponding to the target account number from a financial server, wherein each bill data comprises a store identification field; splitting bill data corresponding to the target account number according to a store identification field, and splitting the bill data with the same value of the store identification field into the same bill data packet; and finally checking the bill data package and the order data package with the same value of the store identification field. Compared with the prior art, one order data does not need to be matched with the bill data of all stores one by one, and only the bill data in the bill data packet with the same value as the identification field value of the store is matched one by one, so that the data matching times in the checking process can be greatly reduced, the checking efficiency is improved, and the user experience is improved.
In addition, in the method of dividing the data packet according to time periods, such as dates, to compare the bill data with the order data, if the generation time of the bill data is inconsistent with that of the order data, the order data corresponding to the bill data is distributed to different data packets, so that the checking cannot be completed.
Alternatively, as a possible implementation manner, the transaction flow reconciliation system in the embodiment of the present invention may use multiple threads to reconcile the bill data packet and the order data packet with the same value of the store identification field. For example, the order data package of each store may be checked out by a single thread, or may be checked out by a process for serially processing order data of two or more stores, which is not limited herein.
Optionally, as a possible implementation manner, in the embodiment of the present invention, when the number of order data exceeds a preset threshold, in order to shorten the time required for reconciliation, and improve the user experience, the transaction flow reconciliation system may use a distributed server to reconcile the bill data packet and the order data packet with the same value of the store identification field in parallel.
For ease of understanding, referring to fig. 2, a transaction flow reconciliation method in accordance with an embodiment of the invention will be described.
First, the time of generating the POS system order is different from the time of generating the bill by the micro-letter/payment treasury system account, but many restaurant shops are 24 hours open, which causes a date to cross days, so that the shops more or less have the POS order and the micro-letter/payment treasury bill in the bill of the same day, and once the number of the shops is increased, the data volume of the differential bill is large. Second, the nature of restaurant business has the concept of "business date", and customer-defined business date is not standard natural day 0-24 hours, possibly 10:00-10:00 (the next day) so that the POS order and WeChat/Payment treasury account split the data package by date has no dimension of standard time, so it is clearly not feasible to reconcile the split by date.
Aiming at the efficiency problem of the existing scheme, the scheme utilizes the reverse writing field of the payment API of WeChat/Payment treasured to split the data packet into data packets of different stores, and then utilizes the technologies of multithreading, distributed and the like to provide a solution. The method specifically comprises the following steps:
A. the identification field of store distinction is defined firstly, the input field in the payment API of the WeChat/payment treasured is utilized, for example, the remark field, the WeChat is the device_info equipment number, the payment treasured is the store_id equipment number, in the process of generating a bill in store transaction, the cashier equipment transmits the store distinction identification which is defined in advance to the financial server corresponding to the WeChat/payment treasured, so that the original bill in the WeChat/payment treasured account carries the store identification which is defined by us;
B. downloading an original bill in a WeChat/payment treasury account during the settlement at the end of the month, splitting the original bill into different data packets according to a custom store identifier, and dividing the different data packets into a plurality of stores;
specifically, as shown in fig. 3, bill data of the WeChat/Payment treasury account is a completed data packet, by using remark fields in the WeChat/Payment treasury Payment API interface, when the store transaction is paid, the system calls the payment API to transmit in the custom store identifier, and the identifier and the store in the POS order form are mapped, so that the generated original bill of the WeChat/Payment treasury is provided with the corresponding store identifier, and when the settlement is carried out at the end of the month, the downloaded bill can be split into small data packets according to the store according to the custom store identifier
C. The store POS system orders are transmitted into the golden butterfly cloud sky system, store identifications of the store POS system are carried, the store identifications are corresponding to the store identifications of WeChat/payment treasury bills, a mapping corresponding relation is established, the POS orders are also split into data packets corresponding to the stores, and the number of stores is equal to the number of data packets;
D. and when the servers are deployed, if the number of the client stores reaches hundreds of thousands, the servers are deployed in a distributed mode, so that the data (organization isolation and account checking data are not influenced by each other) of different stores can be checked at the same time, and account checking can be completed quickly and efficiently, so that account checking difference reports are obtained.
Specifically, as shown in fig. 4, the isolated small data packet services do not affect each other, a multithreading mode is adopted, the number of threads of corresponding data can be started according to the number of shops, and if the number of shops is particularly large, a server CPU is not enough, a distributed server and multiple threads can be adopted for checking accounts.
Referring to fig. 5, the embodiment of the present invention further provides a transaction flow reconciliation system, which may include:
the first obtaining module 501 is configured to obtain order data of a plurality of stores, where each piece of order data includes a store identification field and a collection account number, and store the order data with the same value of the store identification field in the same order data packet in an associated manner, where the collection account numbers in the order data of the plurality of stores are all target account numbers;
a second obtaining module 502, configured to obtain bill data corresponding to the target account number from the financial server, where each bill data includes a store identifier field;
a splitting module 503, configured to split the bill data corresponding to the target account number according to a store identifier field, where the bill data having the same value of the store identifier field is split into the same bill data packet;
the reconciliation module 504 reconciles the billing data packet and the order data packet with the same value of the store identification field.
Optionally, as a possible implementation manner, the reconciliation module in the embodiment of the present invention may include:
and the first checking unit adopts a plurality of threads to check the bill data packet and the order data packet with the same store identification field value.
Optionally, as a possible implementation manner, the reconciliation module in the transaction flow reconciliation system in the embodiment of the present invention may further include:
and when the number of the order data exceeds a preset threshold value, the second reconciliation unit adopts a distributed server to reconcile the bill data packet and the order data packet with the same shop identification field value in parallel.
Optionally, as a possible implementation manner, the transaction flow reconciliation system in the embodiment of the present invention may further include:
and the control module is used for sending a payment request message to the financial server through the cashing equipment, wherein the request message at least comprises a store identification field and verification information, so that the financial server generates bill data after verification passes, and each bill data comprises the store identification field.
Optionally, as a possible implementation manner, the payment request message in the transaction flow reconciliation system in the embodiment of the present invention includes a remark field, which may further include: and the calling module is used for filling a preset store identification field in the remark field. For example, a remark field in the WeChat/Payment API interface is utilized, and when a store transaction pays, a preset store identification field is transferred in the process of calling the payment API.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein.
The transaction flow accounting system in the embodiment of the present invention is described above from the point of view of the modularized functional entity, please refer to fig. 6, and the following describes the computer device in the embodiment of the present invention from the point of view of hardware processing:
the computer device 1 may include a memory 11, a processor 12, and an input-output bus 13. The steps of the embodiment of the transaction flow checking method shown in fig. 1 described above, such as steps 101 to 104 shown in fig. 1, are implemented when the processor 11 executes a computer program. In the alternative, the processor may implement the functions of the modules or units in the above-described embodiments of the apparatus when executing the computer program.
In some embodiments of the present invention, the processor is specifically configured to implement the following steps:
acquiring order data of a plurality of stores, wherein each piece of order data comprises a store identification field and a collection account number, and the order data with the same store identification field value is associated and stored into the same order data packet, and the collection account numbers in the order data of the plurality of stores are all target account numbers;
acquiring bill data corresponding to a target account number from a financial server, wherein each bill data comprises a store identification field;
splitting bill data corresponding to the target account number according to a store identification field, and splitting the bill data with the same value of the store identification field into the same bill data packet;
and checking the bill data package and the order data package with the same value of the store identification field.
In the alternative, as a possible implementation, the processor may be further configured to implement the following steps:
and checking the bill data packet and the order data packet with the same value of the store identification field by adopting a plurality of threads.
In the alternative, as a possible implementation, the processor may be further configured to implement the following steps:
and checking the bill data package and the order data package with the same value of the store identification field in parallel by adopting a distributed server.
In the alternative, as a possible implementation, the processor may be further configured to implement the following steps:
and sending a payment request message to the financial server through the cashing equipment, wherein the request message at least comprises a store identification field and verification information, so that bill data are generated after the financial server passes verification, and each bill data comprises the store identification field.
In the alternative, as a possible implementation, the processor may be further configured to implement the following steps:
filling a preset store identification field in a remark field in the payment request message.
The memory 11 includes at least one type of readable storage medium including flash memory, a hard disk, a multimedia card, a card type memory (e.g., SD or DX memory, etc.), a magnetic memory, a magnetic disk, an optical disk, etc. The memory 11 may in some embodiments be an internal storage unit of the computer device 1, such as a hard disk of the computer device 1. The memory 11 may also be an external storage device of the computer apparatus 1 in other embodiments, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card) or the like, which are provided on the computer apparatus 1. Further, the memory 11 may also include both an internal storage unit and an external storage device of the computer apparatus 1. The memory 11 may be used not only for storing application software installed in the computer apparatus 1 and various types of data, for example, codes of the computer program 01, but also for temporarily storing data that has been output or is to be output.
The processor 12 may in some embodiments be a central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor or other data processing chip for executing program code or processing data stored in the memory 11, e.g. executing a computer program 01 or the like.
The input/output bus 13 may be a peripheral component interconnect standard (peripheral component interconnect, PCI) bus, or an extended industry standard architecture (extended industry standard architecture, EISA) bus, among others. The bus may be classified as an address bus, a data bus, a control bus, etc.
Further, the computer apparatus may also comprise a wired or wireless network interface 14, and the network interface 14 may optionally comprise a wired interface and/or a wireless interface (e.g. WI-FI interface, bluetooth interface, etc.), typically used to establish a communication connection between the computer apparatus 1 and other electronic devices.
Optionally, the computer device 1 may further comprise a user interface, which may comprise a Display (Display), an input unit such as a Keyboard (Keyboard), and optionally a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch, or the like. The display may also be referred to as a display screen or display unit, as appropriate, for displaying information processed in the computer device 1 and for displaying a visual user interface.
Fig. 6 shows only a computer device 1 with components 11-14 and a computer program 01, it being understood by a person skilled in the art that the structure shown in fig. 6 does not constitute a limitation of the computer device 1, and may comprise fewer or more components than shown, or may combine certain components, or a different arrangement of components.
The present invention also provides a computer readable storage medium having a computer program stored thereon, which when executed by a processor, can implement the steps of:
acquiring order data of a plurality of stores, wherein each piece of order data comprises a store identification field and a collection account number, and the order data with the same store identification field value is associated and stored into the same order data packet, and the collection account numbers in the order data of the plurality of stores are all target account numbers;
acquiring bill data corresponding to a target account number from a financial server, wherein each bill data comprises a store identification field;
splitting bill data corresponding to the target account number according to a store identification field, and splitting the bill data with the same value of the store identification field into the same bill data packet;
and checking the bill data package and the order data package with the same value of the store identification field.
In the alternative, as a possible implementation, the processor may be further configured to implement the following steps:
and checking the bill data packet and the order data packet with the same value of the store identification field by adopting a plurality of threads.
In the alternative, as a possible implementation, the processor may be further configured to implement the following steps:
and checking the bill data package and the order data package with the same value of the store identification field in parallel by adopting a distributed server.
In the alternative, as a possible implementation, the processor may be further configured to implement the following steps:
and sending a payment request message to the financial server through the cashing equipment, wherein the request message at least comprises a store identification field and verification information, so that bill data are generated after the financial server passes verification, and each bill data comprises the store identification field.
In the alternative, as a possible implementation, the processor may be further configured to implement the following steps:
filling a preset store identification field in a remark field in the payment request message. In the several embodiments provided in this application, it should be understood that the disclosed systems, apparatuses, and methods may be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown 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 may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. A transaction flow reconciliation method, comprising:
acquiring order data of a plurality of stores, wherein each piece of order data comprises a store identification field and a collection account number, and the order data with the same store identification field value is associated and stored into the same order data packet, and the collection account numbers in the order data of the plurality of stores are all target account numbers;
acquiring bill data corresponding to the target account number from a financial server, wherein each bill data comprises a store identification field;
splitting the bill data corresponding to the target account number according to a store identification field, and splitting the bill data with the same value of the store identification field into the same bill data packet;
and checking the bill data package and the order data package with the same value of the store identification field.
2. The method of claim 1, wherein reconciling the billing data packet with the order data packet having the same value for the store identification field comprises:
and checking the bill data packet and the order data packet with the same value of the store identification field by adopting a plurality of threads.
3. The method of claim 2, wherein when the number of order data exceeds a preset threshold, the method further comprises:
and checking the bill data package and the order data package with the same value of the store identification field in parallel by adopting a distributed server.
4. A method according to any one of claims 1 to 3, further comprising:
and sending a payment request message to a financial server through a cashing device, wherein the request message at least comprises a store identification field and verification information, so that bill data are generated after the financial server passes verification, and each bill data comprises the store identification field.
5. The method of claim 4, wherein the financial server is a server corresponding to a payment treasures or WeChat payment service.
6. The method of claim 4, wherein the payment request message includes a remark field therein, the method further comprising: filling a preset store identification field in the remark field.
7. A transaction flow reconciliation system comprising:
the first acquisition module is used for acquiring order data of a plurality of stores, each piece of order data comprises a store identification field and a collection account number, the order data with the same store identification field value are associated and stored into the same order data packet, and the collection account numbers in the order data of the stores are all target account numbers;
the second acquisition module is used for acquiring bill data corresponding to the target account number from the financial server, and each bill data comprises a store identification field;
the splitting module is used for splitting the bill data corresponding to the target account number according to the shop identification field, and splitting the bill data with the same shop identification field value into the same bill data packet;
and the checking module checks the bill data package and the order data package with the same value of the store identification field.
8. The system of claim 7, wherein the reconciliation module comprises:
and the first checking unit adopts a plurality of threads to check the bill data packet and the order data packet with the same store identification field value.
9. A computer device comprising a processor for implementing the steps of the method according to any one of claims 1 to 6 when executing a computer program stored in a memory.
10. A computer-readable storage medium having stored thereon a computer program, characterized by: the computer program implementing the steps of the method according to any one of claims 1 to 6 when executed by a processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010811829.5A CN111951091B (en) | 2020-08-13 | 2020-08-13 | Transaction flow reconciliation method, system and related equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010811829.5A CN111951091B (en) | 2020-08-13 | 2020-08-13 | Transaction flow reconciliation method, system and related equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111951091A CN111951091A (en) | 2020-11-17 |
| CN111951091B true CN111951091B (en) | 2023-12-29 |
Family
ID=73331650
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010811829.5A Active CN111951091B (en) | 2020-08-13 | 2020-08-13 | Transaction flow reconciliation method, system and related equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111951091B (en) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112418933A (en) * | 2020-11-24 | 2021-02-26 | 深圳市新系区块链技术有限公司 | Transaction data processing method, system and related equipment |
| CN112800127A (en) * | 2021-01-30 | 2021-05-14 | 河南信安通信技术股份有限公司 | Data mining analysis method and device based on transaction bill |
| CN113947397A (en) * | 2021-03-09 | 2022-01-18 | 同济大学 | Account checking method, system, storage medium and terminal of unified mobile payment platform |
| CN113240499A (en) * | 2021-06-08 | 2021-08-10 | 京东数科海益信息科技有限公司 | Order processing method and device based on system switching |
| CN115205000B (en) * | 2022-06-27 | 2023-04-18 | 深圳市数帝网络科技有限公司 | Account checking method, account checking terminal and account checking system |
| CN117077994B (en) * | 2023-10-18 | 2024-01-09 | 国网浙江省电力有限公司 | Transaction management method and management platform |
| CN117437076B (en) * | 2023-12-19 | 2024-03-19 | 太平金融科技服务（上海）有限公司 | Account checking method, device, equipment and medium based on account checking code |
Citations (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2007240205A1 (en) * | 2006-12-13 | 2008-07-03 | Australia And New Zealand Banking Group Limited | Automated Reconciliation of Transaction Records |
| CN101710410A (en) * | 2009-10-28 | 2010-05-19 | 金蝶软件（中国）有限公司 | Method and system for checking accounting data |
| CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
| CN103310311A (en) * | 2013-06-29 | 2013-09-18 | 国家电网公司 | Electric charge finance management system and account checking method |
| CN103903137A (en) * | 2012-12-26 | 2014-07-02 | 远光软件股份有限公司 | Automatic payment and account-checking method and system |
| CN105405007A (en) * | 2015-11-19 | 2016-03-16 | 成都连银信息技术有限公司 | Unified account processing system supporting multiple types of payment channels |
| CN105631737A (en) * | 2015-12-18 | 2016-06-01 | 金蝶软件（中国）有限公司 | Account checking method and account checking system |
| CN107508901A (en) * | 2017-09-04 | 2017-12-22 | 北京京东尚科信息技术有限公司 | Distributed data processing method, apparatus, server and system |
| CN107729398A (en) * | 2017-09-19 | 2018-02-23 | 深圳金融电子结算中心有限公司 | The automatic account checking method of transaction data, server and storage medium |
| CN107833122A (en) * | 2017-10-17 | 2018-03-23 | 安徽广行通信科技股份有限公司 | A kind of reconciliation processing method |
| CN108229925A (en) * | 2018-02-01 | 2018-06-29 | 金蝶软件（中国）有限公司 | The data matching method and system of electronic receipt |
| CN108280754A (en) * | 2018-02-13 | 2018-07-13 | 平安科技（深圳）有限公司 | A kind of routing sub-control account checking method and system |
| CN109615495A (en) * | 2018-10-11 | 2019-04-12 | 阿里巴巴集团控股有限公司 | A kind of account checking method of data, device, equipment and system |
| CN109816501A (en) * | 2018-12-26 | 2019-05-28 | 天翼电子商务有限公司 | Intelligent reconciliation system, method and server |
| CN110046977A (en) * | 2019-02-27 | 2019-07-23 | 阿里巴巴集团控股有限公司 | Bookkeeping methods, account checking method, device and server |
| CN110276672A (en) * | 2019-05-23 | 2019-09-24 | 全球能源互联网研究院有限公司 | A kind of account checking method, device, equipment and computer readable storage medium |
| CN110288454A (en) * | 2019-06-25 | 2019-09-27 | 江苏梦嘉控股集团有限公司 | A kind of financial management method and system |
| CN110390586A (en) * | 2019-07-23 | 2019-10-29 | 中国工商银行股份有限公司 | Account checking method, device and server |
| CN110619562A (en) * | 2019-08-02 | 2019-12-27 | 上海联众网络信息有限公司 | Full-channel bidirectional account checking method |
| CN110738479A (en) * | 2019-09-16 | 2020-01-31 | 口碑(上海)信息技术有限公司 | Order management method and system based on multi-person ordering |
| CN110765179A (en) * | 2019-10-18 | 2020-02-07 | 京东数字科技控股有限公司 | Distributed account checking processing method, device, equipment and storage medium |
| CN110852747A (en) * | 2019-10-31 | 2020-02-28 | 支付宝(杭州)信息技术有限公司 | Order reconciliation system, method and device |
| CN111402020A (en) * | 2020-03-09 | 2020-07-10 | 广东轻工职业技术学院 | Automatic account checking system for enterprise account receivable/payment |
| CN111402022A (en) * | 2020-03-10 | 2020-07-10 | 北京意锐新创科技有限公司 | Merchant account checking method and device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8121941B2 (en) * | 2000-03-07 | 2012-02-21 | American Express Travel Related Services Company, Inc. | System and method for automatic reconciliation of transaction account spend |
-
2020
- 2020-08-13 CN CN202010811829.5A patent/CN111951091B/en active Active
Patent Citations (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2007240205A1 (en) * | 2006-12-13 | 2008-07-03 | Australia And New Zealand Banking Group Limited | Automated Reconciliation of Transaction Records |
| CN101710410A (en) * | 2009-10-28 | 2010-05-19 | 金蝶软件（中国）有限公司 | Method and system for checking accounting data |
| CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
| CN103903137A (en) * | 2012-12-26 | 2014-07-02 | 远光软件股份有限公司 | Automatic payment and account-checking method and system |
| CN103310311A (en) * | 2013-06-29 | 2013-09-18 | 国家电网公司 | Electric charge finance management system and account checking method |
| CN105405007A (en) * | 2015-11-19 | 2016-03-16 | 成都连银信息技术有限公司 | Unified account processing system supporting multiple types of payment channels |
| CN105631737A (en) * | 2015-12-18 | 2016-06-01 | 金蝶软件（中国）有限公司 | Account checking method and account checking system |
| CN107508901A (en) * | 2017-09-04 | 2017-12-22 | 北京京东尚科信息技术有限公司 | Distributed data processing method, apparatus, server and system |
| CN107729398A (en) * | 2017-09-19 | 2018-02-23 | 深圳金融电子结算中心有限公司 | The automatic account checking method of transaction data, server and storage medium |
| CN107833122A (en) * | 2017-10-17 | 2018-03-23 | 安徽广行通信科技股份有限公司 | A kind of reconciliation processing method |
| CN108229925A (en) * | 2018-02-01 | 2018-06-29 | 金蝶软件（中国）有限公司 | The data matching method and system of electronic receipt |
| CN108280754A (en) * | 2018-02-13 | 2018-07-13 | 平安科技（深圳）有限公司 | A kind of routing sub-control account checking method and system |
| CN109615495A (en) * | 2018-10-11 | 2019-04-12 | 阿里巴巴集团控股有限公司 | A kind of account checking method of data, device, equipment and system |
| CN109816501A (en) * | 2018-12-26 | 2019-05-28 | 天翼电子商务有限公司 | Intelligent reconciliation system, method and server |
| CN110046977A (en) * | 2019-02-27 | 2019-07-23 | 阿里巴巴集团控股有限公司 | Bookkeeping methods, account checking method, device and server |
| CN110276672A (en) * | 2019-05-23 | 2019-09-24 | 全球能源互联网研究院有限公司 | A kind of account checking method, device, equipment and computer readable storage medium |
| CN110288454A (en) * | 2019-06-25 | 2019-09-27 | 江苏梦嘉控股集团有限公司 | A kind of financial management method and system |
| CN110390586A (en) * | 2019-07-23 | 2019-10-29 | 中国工商银行股份有限公司 | Account checking method, device and server |
| CN110619562A (en) * | 2019-08-02 | 2019-12-27 | 上海联众网络信息有限公司 | Full-channel bidirectional account checking method |
| CN110738479A (en) * | 2019-09-16 | 2020-01-31 | 口碑(上海)信息技术有限公司 | Order management method and system based on multi-person ordering |
| CN110765179A (en) * | 2019-10-18 | 2020-02-07 | 京东数字科技控股有限公司 | Distributed account checking processing method, device, equipment and storage medium |
| CN110852747A (en) * | 2019-10-31 | 2020-02-28 | 支付宝(杭州)信息技术有限公司 | Order reconciliation system, method and device |
| CN111402020A (en) * | 2020-03-09 | 2020-07-10 | 广东轻工职业技术学院 | Automatic account checking system for enterprise account receivable/payment |
| CN111402022A (en) * | 2020-03-10 | 2020-07-10 | 北京意锐新创科技有限公司 | Merchant account checking method and device |
Non-Patent Citations (1)
| Title |
|---|
| 电网企业智能账务建设的可行性分析;陈湘媛;;大众用电(第12期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111951091A (en) | 2020-11-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111951091B (en) | Transaction flow reconciliation method, system and related equipment | |
| US8768802B2 (en) | System and method of matching financial transaction records to merchant records of a merchant profile database | |
| US20070233597A1 (en) | Least cost network routing for electronic transactions | |
| AU2012202593B2 (en) | Interchange reporting manager | |
| CN109447607B (en) | Transaction method and device for unit account | |
| WO2012012421A3 (en) | System and method for instant issue of personalized financial transaction cards | |
| CN110019774B (en) | Label distribution method, device, storage medium and electronic device | |
| CN109544266A (en) | Product data method for pushing, device and computer readable storage medium | |
| US20190251605A1 (en) | Smart fundraising system using kiosk | |
| US20150066750A1 (en) | Payments Perfection and Processing System | |
| CN105931090A (en) | Electronic bill sending method and device | |
| CN109918385A (en) | Tripartite's account checking method, electronic device and readable storage medium storing program for executing | |
| WO2017032056A1 (en) | Point-of-sale-based cash-out determining method and apparatus | |
| WO2009120884A1 (en) | System and method of determining the quality of enhanced transaction data | |
| CN110689333B (en) | Block chain automatic account checking method, device, system and storage medium | |
| US20150051915A1 (en) | Systems and methods for allocating payments across multiple healthcare accounts | |
| US20160148179A1 (en) | Apparatus and method for monitoring transactions involving a conserved resource | |
| CN111914548A (en) | Intelligent document filling method and system and related equipment | |
| US11854032B1 (en) | Merchant services statements and pricing | |
| CN109214911A (en) | The treating method and apparatus of bill reconciliation exception | |
| CN111752662A (en) | Bank transaction interface display method and device | |
| US20150278974A1 (en) | Systems and methods for determining and communicating a lost revenue opportunity | |
| CN110717747B (en) | Settlement method, settlement device, settlement terminal and computer storage medium | |
| US8478689B1 (en) | Debit card processing | |
| JP2002352167A (en) | Utilization limited card system and method |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |