Pool-based automated reimbursement system and method
By using a pool-based automated reconciliation system with bidirectional queues and timed reconciliation, the system solves the problem of low efficiency in manual reconciliation, achieving efficient and stable reconciliation processing, and is suitable for enterprise financial and operational business systems.
Patent Information
- Application Number
- CN202310662996.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2023-06-06
- Publication Date
- 2026-11-17
- Estimated Expiration
- 2043-06-06
AI Technical Summary
In corporate finance and operations systems, as the number of customers and business volume increases, manual reconciliation operations are prone to errors, resulting in a large workload, high costs, and low efficiency, especially when multiple people are operating complex accounts.
An automated reconciliation system based on a pool design includes an accounts receivable generation module, a payment receipt generation module, a reconciliation pool, first and second storage units, and a reconciliation unit. It utilizes bidirectional queue storage and timed reconciliation to reduce manual operations and improve reconciliation efficiency and system stability.
The automated reconciliation system reduces manual operations, improves reconciliation efficiency, enhances system robustness and stability, reduces information processing delays and message blocking probability, and ensures the stable operation of online business.
Smart Images

Figure CN116578394B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of data processing, specifically to an automated reconciliation system and method based on pool design. Background Technology
[0002] In a company's financial and operational IT systems, it's often necessary to link customer settlement and payment information so that both the operational and financial systems can track settlement status. In the initial stages of a company, when the number of customers and business volume is small, this information linking and reconciliation can be done manually. However, as the number of customers and business volume increases, manual intervention reveals significant drawbacks: it's prone to errors, multiple people simultaneously operating on a single customer's information, linking it with every transaction or payment, resulting in excessively high operation frequency, increased workload and labor costs, and low efficiency. Furthermore, the process becomes complex when dealing with multiple customer accounts. Summary of the Invention
[0003] To improve the efficiency of reconciliation, this application provides an automated reconciliation system and method based on pool design.
[0004] The technical solution adopted by the present invention to solve the above problems is:
[0005] Pool-based automated reconciliation systems include:
[0006] Accounts Receivable Generation Module: Used to generate accounts receivable based on business order information;
[0007] Payment receipt generation module: Used to generate payment receipts based on payment information;
[0008] Reconciliation pool: Used to store reconciliation records for accounts receivable and receipts;
[0009] First storage unit: used to retrieve and store accounts receivable that have not been fully cleared by the customer entity;
[0010] Second storage unit: used to retrieve and store receipts that have not been fully cleared by the customer entity;
[0011] Verification unit: Used to verify amounts based on the information stored in the first storage unit and the second storage unit.
[0012] Furthermore, the accounts receivable and payment receipts are stored in chronological order.
[0013] Furthermore, the first storage unit and the second storage unit employ a bidirectional queue.
[0014] Furthermore, it also includes a notification module, which is used to inform external systems of the amount reconciliation status.
[0015] The pool-based automated reconciliation method, applied to a pool-based automated reconciliation system, includes:
[0016] Step 1: Obtain accounts receivable and receipts that have not been fully reconciled based on the reconciliation pool;
[0017] Step 2, Amount Reconciliation: When neither the first storage unit nor the second storage unit is empty, retrieve an accounts receivable in the first storage unit and calculate the first unreconciled amount; retrieve a receipt in the second storage unit and calculate the second unreconciled amount.
[0018] If the first unreconciled amount is less than or equal to the second unreconciled amount, the reconciled amount is the first unreconciled amount, the reconciliation record is written to the reconciliation pool, and the reconciliation status of the current accounts receivable is updated to full reconciliation; if the first unreconciled amount is equal to the second unreconciled amount, the reconciliation status of the current receipt is updated to full reconciliation; if the first unreconciled amount is less than the second unreconciled amount, the reconciliation status of the current receipt is updated to partial reconciliation, and the receipt is retrieved first during the next amount reconciliation.
[0019] If the first unreconciled amount is greater than the second unreconciled amount, then the reconciled amount is the second unreconciled amount, the reconciliation record is written to the reconciliation pool, the reconciliation status of the current receivable is updated to partial reconciliation, and the receivable is retrieved first during the next amount reconciliation, and the reconciliation status of the current receipt is updated to full reconciliation.
[0020] Step 3: Repeat step 2 until the first storage unit is empty or the second storage unit is empty.
[0021] Furthermore, when the first storage unit is a doubly linked queue qR and the second storage unit is a doubly linked queue qS,
[0022] Step 2 specifically involves: when qR and qS are not empty, retrieving the accounts receivable Ri and the payment receipt Si from the head of the queues qR and qS respectively; and obtaining the unreconciled amount HRiLeft of accounts receivable Ri and the unreconciled amount HSiLeft of payment receipt Si based on the reconciliation pool.
[0023] If HRiLeft is less than or equal to HSiLeft, then the write-off amount of Ri is HRiLeft, the write-off amount of Si is HRiLeft, the write-off record is written to the write-off pool, and the write-off status of Ri is updated to full write-off; when HRiLeft is equal to HSiLeft, the write-off status of Si is updated to full write-off; when HRiLeft is less than HSiLeft, then Si is inserted into the head of qS again, and the write-off status of Si is updated to partial write-off.
[0024] If HRiLeft is greater than HSiLeft, then the write-off amount of Ri is HSiLeft, the write-off amount of Si is HSiLeft, the write-off record is written to the write-off pool, the write-off status of Si is updated to full write-off, the write-off status of Ri is updated to partial write-off, and Ri is inserted into the head of qR again.
[0025] Furthermore, step 2 also includes informing the external system of the amount reconciliation status.
[0026] Furthermore, the amounts are reconciled periodically.
[0027] The advantages of this invention compared to existing technologies are as follows: Resettlement is based on two storage units and a resettlement pool, reducing manual operations and thus improving resettlement efficiency; the storage units use message queues, improving system robustness and stability, ensuring messages are consumed and processed by consumer services, reducing message blocking probability, and lowering information processing latency. Scheduled resettlement avoids impacting online business. Attached Figure Description
[0028] Figure 1 A block diagram of an automated reconciliation method based on pool design;
[0029] Figure 2 Flowchart of an automated reconciliation method based on pool design;
[0030] Figure 3 This is a diagram of the architecture of a timed automatic reconciliation system. Detailed Implementation
[0031] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the invention.
[0032] Pool-based automated reconciliation systems include:
[0033] Accounts Receivable Generation Module: Used to generate accounts receivable based on business order information; business orders are information transmitted from the operating business system, including operating business system information, business number, business amount, customer entity ID, etc.; accounts receivable are information generated based on business orders, used to isolate business transactions, including business number, business amount, reconciliation status (unreconciled, partially reconciled, fully reconciled), customer entity ID, etc.
[0034] The receipt generation module is used to generate receipts based on receipt information. Receipt information includes receipt information from various channels, including receipt amount, receiving account, and receiving channel (bank, WeChat, Alipay, etc.). The receipt is generated based on the receipt information and is used to isolate finances. It includes receipt amount, receiving account, reconciliation status (not reconciled, partially reconciled, fully reconciled), customer entity ID, etc.
[0035] Reconciliation pool: Used to store reconciliation records for accounts receivable and receipts. The pool refers to a storage medium that can be queried and written back; it can be a relational database, Redis, in-memory map, etc.
[0036] First storage unit: used to retrieve and store accounts receivable that have not been fully cleared by the customer entity;
[0037] Second storage unit: used to retrieve and store receipts that have not been fully cleared by the customer entity;
[0038] Verification unit: Used to verify amounts based on the information stored in the first storage unit and the second storage unit.
[0039] To facilitate the reconciliation of amounts, accounts receivable and receipts are stored in chronological order.
[0040] To improve reconciliation efficiency, the first and second storage units employ bidirectional queues.
[0041] Furthermore, it also includes a notification module, which is used to inform external systems of the amount reconciliation status.
[0042] like Figure 1 As shown, the pool-based automatic reconciliation method is applied to a pool-based automatic reconciliation system, including:
[0043] Step 1: Obtain accounts receivable and receipts that have not been fully reconciled based on the reconciliation pool;
[0044] Step 2, Amount Reconciliation: When neither the first storage unit nor the second storage unit is empty, retrieve an accounts receivable in the first storage unit and calculate the first unreconciled amount; retrieve a receipt in the second storage unit and calculate the second unreconciled amount.
[0045] If the first unreconciled amount is less than or equal to the second unreconciled amount, the reconciled amount is the first unreconciled amount, the reconciliation record is written to the reconciliation pool, and the reconciliation status of the current accounts receivable is updated to full reconciliation; if the first unreconciled amount is equal to the second unreconciled amount, the reconciliation status of the current receipt is updated to full reconciliation; if the first unreconciled amount is less than the second unreconciled amount, the reconciliation status of the current receipt is updated to partial reconciliation, and the receipt is retrieved first during the next amount reconciliation.
[0046] If the first unreconciled amount is greater than the second unreconciled amount, then the reconciled amount is the second unreconciled amount, the reconciliation record is written to the reconciliation pool, the reconciliation status of the current receivable is updated to partial reconciliation, and the receivable is retrieved first during the next amount reconciliation, and the reconciliation status of the current receipt is updated to full reconciliation.
[0047] Step 3: Repeat step 2 until the first storage unit is empty or the second storage unit is empty.
[0048] To facilitate orderly data access and improve reconciliation efficiency, the first storage unit uses a doubly linked queue qR, and the second storage unit uses a doubly linked queue qS, as follows: Figure 2 As shown, step 2 specifically involves: when qR and qS are not empty, retrieving the accounts receivable Ri and payment receipt Si from the head of the queues qR and qS respectively; and obtaining the unreconciled amount HRiLeft of accounts receivable Ri and the unreconciled amount HSiLeft of payment receipt Si based on the reconciliation pool.
[0049] Step 3 specifically involves: if HRiLeft is less than or equal to HSiLeft, then the reimbursement amount of Ri is HRiLeft, the reimbursement amount of Si is HRiLeft, the reimbursement record is written to the reimbursement pool, and the reimbursement status of Ri is updated to full reimbursement; when HRiLeft is equal to HSiLeft, the reimbursement status of Si is updated to full reimbursement; when HRiLeft is less than HSiLeft, Si is inserted into the head of qS again, and the reimbursement status of Si is updated to partial reimbursement.
[0050] If HRiLeft is greater than HSiLeft, then the write-off amount of Ri is HSiLeft, the write-off amount of Si is HSiLeft, the write-off record is written to the write-off pool, the write-off status of Si is updated to full write-off, the write-off status of Ri is updated to partial write-off, and Ri is inserted into the head of qR again.
[0051] Furthermore, step 2 also includes informing the external system of the amount reconciliation status.
[0052] To avoid conflicts with other matters, you can also set a reconciliation time to reconcile the amount at regular intervals.
[0053] Example
[0054] Taking accounts receivable and payments as an example, in this embodiment, the pool-based automated reconciliation system has multiple customer entities. A scheduled task starts at 2 AM daily, and customer entities are evenly distributed to different application service groups based on the number of application service groups. Figure 3 As shown, the scheduled task St is used to assign customer principal IDs to different reimbursement service groups;
[0055] Message queues MQ1 and MQ2 are mainly used to decouple the scheduled task service and the reconciliation service. When the number of customer entities is large and the processing time is long, they can reduce the pressure on the reconciliation service while ensuring the stability and reliability of the service.
[0056] MQe is also a message queue, mainly used to notify other systems, and its purpose is also to decouple systems.
[0057] Each application service performs reimbursement for each customer entity consumed:
[0058] Retrieve the accounts receivable for this customer entity from the accounts receivable pool, sort them by time, and put them into a two-way queue qR;
[0059] The payment receipts for this customer entity are retrieved from the payment receipt pool, sorted by time, and placed into a two-way queue qS;
[0060] When qR or qS is empty, the current write-off of the customer entity is terminated;
[0061] When both qR and qS are not empty:
[0062] Take the first receivable Ri from the head of the qR queue, retrieve the amount HRi that has been reimbursed from the reimbursement pool, and calculate the amount HRiLeft that has not been reimbursed.
[0063] Take the first receipt Si from the head of the qS queue, retrieve the amount HSi that has been cleared from the clearing pool, and calculate the amount HSiLeft that has not been cleared.
[0064] Compare the current write-off amount of Ri (HRiLeft) and Si (HSiLeft):
[0065] ① If HRiLeft is less than or equal to HSiLeft, then the reimbursement amount for Ri is HRiLeft, the reimbursement amount for Si is HRiLeft, the reimbursement record is written to the reimbursement pool, and the reimbursement status of Ri is updated to full reimbursement. When HRiLeft equals HSiLeft, the reimbursement status of Si is updated to full reimbursement; when HRiLeft is less than HSiLeft, Si needs to be inserted back into the head of qS, and the reimbursement status of Si is updated to partial reimbursement.
[0066] ② If HRiLeft is greater than HSiLeft, then the write-off amount of Ri is HSiLeft, the write-off amount of Si is HSiLeft, write the write-off record to the write-off pool, update the write-off status of Si to full write-off, update the write-off status of Ri to partial write-off, and insert Ri back into the head of qR.
[0067] After the client's transaction is terminated, the application server needs to push the transaction information to the MQ service MQe, which will then inform external systems, such as the financial system and the operations system, of the transaction information.
[0068] Write-off processing can also be used for the write-off of accounts payable and payments, leave requests and cancellations, advances and reimbursements, etc. The specific processing procedure is similar to that of accounts receivable and receipts, and will not be elaborated here.
[0069] The reimbursement system is technically designed using a microservices architecture, and business processing is done by serving one customer entity at a time. The advantages of this approach are as follows:
[0070] 1. The routing of scheduled services is based on the number of service groups and is evenly distributed. This allows for horizontal scaling of processing capacity when business volume increases.
[0071] 2. Application service groups, i.e. microservice groups of message queue consumers, can improve the robustness and stability of the system, ensure that messages are consumed and processed by consumer services, reduce the probability of message blocking, and reduce the latency of information processing.
[0072] 3. One reconciliation service serves one customer entity at a time. This design allows the reconciliation logic to focus on one entity, the scope of transaction processing will be smaller and the time will be shorter. Even if a transaction is rolled back, it will only affect the processing of that customer entity, and the reconciliation processing of other customer entities will not be affected.
[0073] 4. Separate external push notification design: MQe is used to push information to the operation business system and the financial system, which is separated from the reconciliation logic to ensure that the reconciliation process is simple, complete and efficient;
[0074] 5. Scheduled reconciliation design, rather than real-time reconciliation. Real-time reconciliation, when business volume is high, has a very high reconciliation frequency, which will affect online business. If it is one-way reconciliation, reconciliation cannot be initiated again if it fails. Scheduled reconciliation is processed in the early morning when online business is low. The reconciliation processes the current full reconciliation of the customer entity. Even if the reconciliation process fails this time, it can be corrected and processed in the next scheduled start.
Claims
1. An automated reconciliation system based on a pool design, characterized in that, include: Accounts Receivable Generation Module: Used to generate accounts receivable based on business order information; Payment receipt generation module: Used to generate payment receipts based on payment information; Reconciliation pool: Used to store reconciliation records for accounts receivable and receipts; First storage unit: used to retrieve and store accounts receivable that have not been fully cleared by the customer entity; Second storage unit: used to retrieve and store receipts that have not been fully cleared by the customer entity; The first storage unit and the second storage unit adopt a bidirectional queue, the first storage unit is denoted as qR, and the second storage unit is denoted as qS; Reconciliation Unit: Used to reconcile amounts based on the information stored in the first storage unit and the second storage unit: When qR and qS are not empty, the accounts receivable Ri and the receipt Si at the head of the queues qR and qS respectively are retrieved; the unreconciled amount HRiLeft of accounts receivable Ri and the unreconciled amount HSiLeft of receipt Si are obtained based on the reconciliation pool. If HRiLeft is less than or equal to HSiLeft, then the write-off amount of Ri is HRiLeft, the write-off amount of Si is HRiLeft, the write-off record is written to the write-off pool, and the write-off status of Ri is updated to full write-off; when HRiLeft is equal to HSiLeft, the write-off status of Si is updated to full write-off; when HRiLeft is less than HSiLeft, then Si is inserted into the head of qS again, and the write-off status of Si is updated to partial write-off. If HRiLeft is greater than HSiLeft, then the write-off amount of Ri is HSiLeft, the write-off amount of Si is HSiLeft, write the write-off record to the write-off pool, update the write-off status of Si to full write-off, the write-off status of Ri to partial write-off, and insert Ri back into the head of qR. Repeat the above steps until the first storage unit is empty or the second storage unit is empty.
2. The automated reconciliation system based on pool design according to claim 1, characterized in that, The accounts receivable and payment receipts are stored in chronological order.
3. The automated reconciliation system based on pool design according to claim 1 or 2, characterized in that, It also includes a notification module, which is used to inform external systems of the amount reconciliation status.
4. A pool-based automatic reconciliation method, applied to the pool-based automatic reconciliation system according to any one of claims 1-3, characterized in that, include: Step 1: Obtain accounts receivable and receipts that have not been fully reconciled based on the reconciliation pool; Step 2, Amount Reconciliation: When neither the first storage unit nor the second storage unit is empty, retrieve an accounts receivable in the first storage unit and calculate the first unreconciled amount; retrieve a receipt in the second storage unit and calculate the second unreconciled amount. If the first unreconciled amount is less than or equal to the second unreconciled amount, the reconciled amount is the first unreconciled amount, the reconciliation record is written to the reconciliation pool, and the reconciliation status of the current accounts receivable is updated to full reconciliation; if the first unreconciled amount is equal to the second unreconciled amount, the reconciliation status of the current receipt is updated to full reconciliation; if the first unreconciled amount is less than the second unreconciled amount, the reconciliation status of the current receipt is updated to partial reconciliation, and the receipt is retrieved first during the next amount reconciliation. If the first unreconciled amount is greater than the second unreconciled amount, then the reconciled amount is the second unreconciled amount, the reconciliation record is written to the reconciliation pool, the reconciliation status of the current receivable is updated to partial reconciliation, and the receivable is retrieved first during the next amount reconciliation, and the reconciliation status of the current receipt is updated to full reconciliation. Step 3: Repeat step 2 until the first storage unit is empty or the second storage unit is empty; When the first storage unit is a doubly linked queue qR and the second storage unit is a doubly linked queue qS Step 2 specifically involves: when qR and qS are not empty, retrieving the accounts receivable Ri and the payment receipt Si from the head of the queues qR and qS respectively; and obtaining the unreconciled amount HRiLeft of accounts receivable Ri and the unreconciled amount HSiLeft of payment receipt Si based on the reconciliation pool. If HRiLeft is less than or equal to HSiLeft, then the write-off amount of Ri is HRiLeft, the write-off amount of Si is HRiLeft, the write-off record is written to the write-off pool, and the write-off status of Ri is updated to full write-off; when HRiLeft is equal to HSiLeft, the write-off status of Si is updated to full write-off; when HRiLeft is less than HSiLeft, then Si is inserted into the head of qS again, and the write-off status of Si is updated to partial write-off. If HRiLeft is greater than HSiLeft, then the write-off amount of Ri is HSiLeft, the write-off amount of Si is HSiLeft, the write-off record is written to the write-off pool, the write-off status of Si is updated to full write-off, the write-off status of Ri is updated to partial write-off, and Ri is inserted into the head of qR again.
5. The automatic reconciliation method based on pool design according to claim 4, characterized in that, Step 2 also includes informing the external system of the amount reconciliation status.
6. The automatic reconciliation method based on pool design according to claim 4 or 5, characterized in that, Regularly verify the amount.
Citation Information
Patent Citations
Regular cancel-after-verification method and system for business contact orders and computer equipment
CN111507798A
Receivable and payable automatic cancel-after-verification processing method and device and computer readable storage medium
CN114358751A
