CN112270537A - Multi-channel bill storage method, system and storage medium - Google Patents

Multi-channel bill storage method, system and storage medium Download PDF

Info

Publication number
CN112270537A
CN112270537A CN202011180734.4A CN202011180734A CN112270537A CN 112270537 A CN112270537 A CN 112270537A CN 202011180734 A CN202011180734 A CN 202011180734A CN 112270537 A CN112270537 A CN 112270537A
Authority
CN
China
Prior art keywords
files
file
warehoused
storage
warehousing
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.)
Granted
Application number
CN202011180734.4A
Other languages
Chinese (zh)
Other versions
CN112270537B (en
Inventor
吴确林
仇远程
叶贺忠
周游
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangdong Tongguan Technology Co ltd
Original Assignee
Guangdong Tongguan Technology Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Guangdong Tongguan Technology Co ltd filed Critical Guangdong Tongguan Technology Co ltd
Priority to CN202011180734.4A priority Critical patent/CN112270537B/en
Publication of CN112270537A publication Critical patent/CN112270537A/en
Application granted granted Critical
Publication of CN112270537B publication Critical patent/CN112270537B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Payment architectures, schemes or protocols
    • G06Q20/08Payment architectures
    • G06Q20/10Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
    • G06Q20/102Bill distribution or payments
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Payment architectures, schemes or protocols
    • G06Q20/04Payment circuits
    • G06Q20/06Private payment circuits, e.g. involving electronic currency used among participants of a common payment scheme
    • G06Q20/065Private payment circuits, e.g. involving electronic currency used among participants of a common payment scheme using e-cash
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Payment architectures, schemes or protocols
    • G06Q20/08Payment architectures
    • G06Q20/085Payment architectures involving remote charge determination or related payment systems
    • G06Q20/0855Payment architectures involving remote charge determination or related payment systems involving a third party

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a multi-channel bill warehousing method, a multi-channel bill warehousing system and a storage medium, wherein the multi-channel bill warehousing method comprises the steps of obtaining reconciliation files corresponding to a plurality of target channels of a target object; synchronously analyzing the account checking files corresponding to the target channels to obtain files to be put in storage corresponding to the account checking files; determining aggregate order files to be put in storage, which are matched with files to be put in storage corresponding to each account file in the system; and warehousing the matched aggregated order files to be warehoused and files to be warehoused in a pair by pair. The invention aims to synchronously acquire and analyze a plurality of account checking files corresponding to a plurality of channels in parallel, thereby saving time, meeting the multi-channel processing requirement, ensuring successful warehousing, ensuring data accuracy and improving warehousing efficiency.

Description

Multi-channel bill storage method, system and storage medium
Technical Field
The invention relates to the technical field of bills, in particular to a multi-channel bill storage method, a multi-channel bill storage system and a storage medium.
Background
With the continuous increase of the number of bill docking channels, the bill formats and the generation time of each channel are inconsistent, the corresponding data scale is increased in a geometric series manner, the number of channels is increased day by day, the data volume is huge day by day, a large amount of manpower, material resources and financial resources are consumed in a single account checking processing and storing mode, the efficiency is low, the requirement for processing the bill data of multiple channels cannot be met, and great difficulty is brought to the storage processing and storing of the data.
Accordingly, the prior art is yet to be developed and improved.
Disclosure of Invention
Therefore, it is necessary to provide a method, a system and a storage medium for warehousing multi-channel bills for solving the above technical problems.
A multi-channel bill warehousing method comprises the following steps:
acquiring account checking files corresponding to a plurality of target channels of a target object;
synchronously analyzing the account checking files corresponding to the target channels to obtain files to be put in storage corresponding to the account checking files;
determining aggregate order files to be put in storage, which are matched with files to be put in storage corresponding to each account file in the system;
and warehousing the matched aggregated order files to be warehoused and files to be warehoused in a pair by pair.
The multi-channel bill warehousing method includes the following specific steps of:
determining a plurality of target channels corresponding to the target object;
acquiring account checking files corresponding to a plurality of target channels of a target object through a network at intervals of first preset time;
if the account checking files corresponding to the target channels of the target object are successfully acquired, updating the acquisition task flag of the account checking files to be complete;
if the account checking files corresponding to the target channels of the target object are not successfully acquired, waiting for second preset time and then executing the task of acquiring the account checking files again;
and if the account checking files corresponding to the target channels of the target object are not successfully acquired, updating the acquisition task flag of the account checking files to be failure, recording the failure reason, and performing manual processing.
The warehousing method of the multi-channel bill is characterized in that the step of synchronously analyzing the reconciliation files corresponding to the target channels to obtain the files to be warehoused corresponding to the reconciliation files specifically comprises the following steps:
acquiring the state of an acquisition task mark of the account checking file;
if the task mark of acquiring the account checking file is complete, analyzing the account checking files corresponding to the target channels in parallel according to a preset configuration file;
if the account checking files corresponding to all the target channels are analyzed, obtaining files to be put in storage corresponding to the account checking files; wherein, each file to be put in storage has the same file format and structure;
and updating the analysis task of the account checking file to be finished.
The method for warehousing the multi-channel bills comprises the following steps of determining aggregate order files to be warehoused, which are matched with files to be warehoused corresponding to each account file in the system, specifically:
acquiring the analysis task state of each account file;
if the analysis task state of the reconciliation file is completed, acquiring a file to be put in storage corresponding to the reconciliation file, and determining the payment category and the target channel of the file to be put in storage;
acquiring a plurality of candidate aggregation order files with the same payment type and the same target channel as the file to be put in storage in a system;
and respectively associating and comparing the candidate aggregate order files with files to be put in storage, and determining the aggregate order files to be put in storage, which are correspondingly matched with the files to be put in storage in the system, according to the association comparison result.
The multi-channel bill warehousing method comprises the step of selecting one or more of mobile payment, offline card swiping and unionpay according to payment types.
The multi-channel bill warehousing method comprises the following steps of respectively associating and comparing the candidate aggregate order files with files to be warehoused, and determining the aggregate order files to be warehoused, which are correspondingly matched with the files to be warehoused in the system, according to the association comparison result, and specifically comprises the following steps:
determining a bill identification corresponding to the payment category according to the payment category of the file to be put in storage;
extracting first information corresponding to the bill identification in the file to be put in storage and second information corresponding to the same bill identification in a plurality of candidate aggregated order files;
if the second information of any candidate aggregation order file is different from the first information of the file to be put in storage, prompting through a third-party application, and manually processing;
if the second information of at least one candidate aggregate order file is the same as the first information of the file to be warehoused, whether the payment states of the candidate aggregate order file and the file to be warehoused are consistent or not is continuously determined;
if the candidate aggregate order file is consistent with the payment state in the file to be warehoused, the candidate aggregate order file is the file to be warehoused aggregate order matched with the file to be warehoused;
and if the payment state of the candidate aggregate order file is inconsistent with that of the file to be warehoused, storing the candidate aggregate order file and the file to be warehoused in an warehousing exception list, and manually processing the candidate aggregate order file and the file to be warehoused through an automatic reconciliation platform until the candidate aggregate order file is matched with the file to be warehoused.
The warehousing method of the multi-channel bills comprises the following specific steps of warehousing the matched aggregated order files to be warehoused and files to be warehoused in a pair-by-pair mode:
acquiring a plurality of aggregated order files to be put into a warehouse, which are correspondingly matched with all files to be put into the warehouse;
sorting the matched files to be put in storage and the matched aggregated order files to be put in storage according to preset conditions;
and warehousing the sorted files to be warehoused and the aggregated order files to be warehoused in a pair by pair.
The multi-channel bill warehousing method comprises the following steps of warehousing the matched aggregated order files to be warehoused and files to be warehoused in a pair-by-pair mode:
and constructing a monthly account table, a quarterly account table and an annual account table corresponding to different channels of the same target object.
The application also provides a multi-channel bill warehousing system, which comprises a timer, a bill acquisition module, an analysis module and a bill comparison processing module, wherein the bill acquisition module, the analysis module and the bill comparison processing module are respectively connected with the timer;
the timer is used for configuring time for each module and establishing related tasks for each module when the time is up;
the bill acquisition module is used for acquiring reconciliation files corresponding to a plurality of target channels of a target object;
the analysis module is used for synchronously analyzing the reconciliation files corresponding to the target channels to obtain files to be put in storage corresponding to the reconciliation files;
the bill comparison processing module is used for determining aggregate order files to be put in storage matched with files to be put in storage corresponding to each account file in the system; and warehousing the matched aggregated order files to be warehoused and files to be warehoused in a pair by pair.
The application also provides a computer temporary storage medium, which stores one or more programs, wherein the programs are executed by a processor to realize the steps in the multi-channel bill warehousing method.
The embodiment of the invention has the following beneficial effects:
the invention discloses a multi-channel bill warehousing method, a multi-channel bill warehousing system and a storage medium, wherein the multi-channel bill warehousing method comprises the steps of obtaining reconciliation files corresponding to a plurality of target channels of a target object; synchronously analyzing the account checking files corresponding to the target channels to obtain files to be put in storage corresponding to the account checking files; determining aggregate order files to be put in storage, which are matched with files to be put in storage corresponding to each account file in the system; and warehousing the matched aggregated order files to be warehoused and files to be warehoused in a pair by pair. The invention aims to synchronously acquire and analyze a plurality of account checking files corresponding to a plurality of channels in parallel, thereby saving time, meeting the multi-channel processing requirement, ensuring successful warehousing, ensuring data accuracy and improving warehousing efficiency.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Wherein:
fig. 1 is a flowchart of an embodiment of a method for warehousing a multi-channel bill according to the present invention.
Fig. 2 is a block diagram of a multi-channel bill warehousing system according to the present invention.
Fig. 3 is a block diagram of a structure of an intelligent terminal in a multi-channel bill warehousing system provided by the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, fig. 1 is a flowchart illustrating an embodiment of a method for warehousing a multi-channel bill according to the present invention. As shown in fig. 1, the method for warehousing a multi-channel bill includes:
and S10, obtaining account checking files corresponding to the target channels of the target object.
In this embodiment, the target object refers to an object that needs to be checked and warehoused. When a plurality of target objects exist, the user ID is used to distinguish different target objects. That is, the user ID uniquely identifies the target object. In this embodiment, the user ID refers to an operation and maintenance number that is automatically created for each target object by the system. The operation and maintenance number is not only used for determining the target object, but also used for determining the third party application such as WeChat bound to the target object, so that once the association matching is abnormal, the operation and maintenance number is informed through the WeChat to remind the user of timely processing.
The target channel refers to the manner in which the user makes payment. The target channel can be a music brush, WeChat, Paibao, Fukuai Payment, Unionpay, cloud flash payment, and the like. The payment categories for different target channels may be the same or different. The bill information in the reconciliation files formed by different payment categories is different, and naturally, the bill information stored when bills are put in storage is also different. Therefore, the payment category of the target channel needs to be divided, and in this embodiment, the payment category is divided into 3 payment modes, namely, mobile payment, offline card swiping and unionpay. Of course, the payment category is not limited to only these 3 payment methods, which can be updated as the need for subsequent development arises. For example, payment categories also include monetary payments, and the like.
It can be understood that mobile payment is a novel payment mode in the internet era, and accounts payment is performed on purchased products through a mobile terminal by taking the mobile terminal as a center, and the main expression form of mobile payment is mobile phone payment. The mobile payment is a derivative of the third party payment. The third party payment means that after a buyer purchases a commodity in the transaction through a third party payment platform, the buyer pays the payment of the commodity through an account provided by the third party platform, and the third party informs a seller that the payment of the commodity arrives and the delivery of the commodity is carried out; after the buyer verifies the goods, the seller is notified of the payment, and the third party transfers the payment to the seller account. The Unionpay payment comprises Unionpay online payment, which refers to a bank card online transaction transfer clearing platform created by the union of China Unionpay and various commercial banks.
Obviously, the same payment category may also correspond to multiple target channels. For example: the target channels corresponding to the mobile payment categories comprise WeChat payment channels, Paibao payment channels and the like.
Illustratively, the obtaining the reconciliation files corresponding to the plurality of target channels of the target object specifically includes:
s11, determining a plurality of target channels corresponding to the target object;
s12, acquiring reconciliation files corresponding to a plurality of target channels of the target object through the network at intervals of first preset time;
s13, if the reconciliation files corresponding to the target channels of the target object are successfully acquired, updating the acquisition task flag of the reconciliation files to be complete;
s14, if the account checking files corresponding to the target channels of the target object are not successfully acquired, waiting for a second preset time and then executing the task of acquiring the account checking files again;
and S15, if the reconciliation files corresponding to the target channels of the target object are not successfully acquired, updating the acquisition task flag of the reconciliation files to be failure, recording the failure reason, and performing manual processing.
Specifically, the timer sets the bill acquiring time (i.e. the first predetermined time) of the bill acquiring module, such as every 25 minutes, and may also be set to operate at two points in the morning every day, which is not limited, and may also be set differently according to the billing time of each bank, and is usually set according to the latest billing time of the supported bank. Then, the bill acquiring module performs an operation of acquiring reconciliation files of a plurality of target channels of the target object once every first predetermined time, for example, 25 minutes. Due to the fact that target channels adopted for payment are various, the target channels corresponding to business requirements can be customized, and therefore the method not only contains the requirements of popular basic target channels, improves marketability, but also can meet the requirements of personalized target channels and expands application range.
And then, after receiving an acquiring task of the reconciliation file set by the timer, the bill acquiring module acquires the reconciliation files corresponding to a plurality of target channels of the target object in a mode of network, Http/https link downloading interface, ftp uploading, bank active pushing and the like. And if the task is completely executed, updating the mark of the planning task on the current day. Specifically, if the reconciliation files corresponding to the target channels of the target object are successfully acquired, that is, the situations of abnormal downloading, such as disconnection in the middle of downloading, incomplete downloading and the like do not occur, the acquisition task flag of the reconciliation file is updated to be completed, so as to facilitate the execution of the analysis task of the subsequent analysis module.
Of course, if the reconciliation files corresponding to the target channels of the target object are not successfully acquired, if abnormal downloading occurs, such as interruption in the middle of downloading, incomplete downloading, and the like, the task of acquiring the reconciliation files is executed again after waiting for a second predetermined time, such as 30 minutes. If the account checking files corresponding to the target channels of the target object are successfully acquired, the timer sequentially delays the time set by the follow-up task, and meanwhile, the bill acquisition module updates the task acquisition mark of the account checking files to be complete, and the state of the task acquisition mark is not only used for displaying and inquiring, but also used for indicating the task of the follow-up module to be continuously executed.
And if the account checking files corresponding to the target channels of the target object are not successfully acquired, updating the acquisition task flag of the account checking files to be failure, recording the failure reason, and performing manual processing.
And S20, synchronously analyzing the account checking files corresponding to the target channels to obtain the files to be put in storage corresponding to the account checking files.
Specifically, different modes of reconciliation provided by different banks are different due to different reconciliation modes adopted by different target objects, such as ftp uploading, bank active pushing, http/https downloading interfaces and the like, so that the formats of the obtained reconciliation files are different inevitably. Therefore, the reconciliation files from different sources are eight-door, which results in increased reconciliation difficulty when the reconciliation files are associated and matched with the aggregated order files in the system, greatly increases the manual workload and reduces the efficiency. Therefore, in order to improve the warehousing efficiency and reduce the complexity of association matching, the reconciliation files corresponding to a plurality of target channels are subjected to format conversion and are uniformly converted into formats and structures required by warehousing, so that the warehousing efficiency is improved, and the management is convenient.
Illustratively, the analyzing the reconciliation files corresponding to the target channels synchronously to obtain the files to be put in storage corresponding to the reconciliation files specifically includes:
s21, acquiring the state of the task mark of the account checking file;
s22, if the task mark of acquiring the reconciliation file is complete, analyzing the reconciliation files corresponding to the multiple target channels in parallel according to a preset configuration file;
s23, if the reconciliation files corresponding to all the target channels are analyzed, obtaining the files to be put in storage corresponding to the reconciliation files; wherein, each file to be put in storage has the same file format and structure;
and S24, updating the analysis task of the reconciliation file to be completed.
Specifically, the timer sets the analysis task time of the analysis module, such as running twice or half a day in the morning. In order to improve the accuracy and reduce the error rate, the execution of the task corresponding to the next module is only carried out after the execution of the task of the previous module is finished. Therefore, when the analysis task time is reached, the analysis module acquires the state of the task acquisition mark of the reconciliation file, and starts to perform analysis operation on each reconciliation file if the task acquisition mark of the reconciliation file is finished. Generally speaking, the parsing operation refers to extracting information corresponding to fields included in the configuration files from each pair of account files, and combining the information extracted from each pair of account files according to formats and structures set by the configuration files to obtain files to be put in storage corresponding to each pair of account files.
Further, in the parsing process, if a plurality of reconciliation files, for example 4 reconciliation files, are obtained, a conventional sequential parsing manner may be adopted, that is, a previous reconciliation file is parsed out of a file to be put into a warehouse, and then parsing of a next reconciliation file is continued until all the reconciliation files are parsed. However, the analysis time is too long, and the cost is increased, so that a parallel analysis mode, that is, a plurality of threads are used for synchronously analyzing the reconciliation files is adopted in the embodiment of the application, if 4 threads are created according to the system configuration, at this time, 10 reconciliation files are used for analysis, at this time, the 4 threads receive the analysis task, and 4 reconciliation files are arbitrarily selected from the 10 reconciliation files to start synchronous analysis. In the analysis process, a plurality of threads corresponding to the account checking files are executed first, and the remaining 6 unanalyzed account checking files can be selected continuously. Therefore, the reconciliation files are analyzed in parallel in a multithread mode, the analysis time is shortened, the analysis efficiency is improved, and meanwhile the resource overhead is reasonably utilized.
It should be noted that the configuration file is preset by the system. The configuration file is used for indicating the content and format of each reconciliation file analysis and also used for providing reference basis for the monthly reconciliation table, the quarterly reconciliation table and the annual reconciliation table. The configuration file is configured with field parameters including order number, transaction amount, payment time, payment type, voucher number, batch number, commission fee, etc. Wherein, a certain field parameter or a combination of multiple field parameters can be used as an identification identifier, such as: the character parameter identification ts05 represents a mobile payment, the character parameter ts07 represents a unionpay payment, etc. For another example, the reconciliation file of the mobile payment comprises an order number, and the mobile payment matching and the subsequent association matching of the aggregated order file can be carried out through the order number; the account checking file of the offline card swiping comprises a voucher number, and offline card swiping payment matching and subsequent association matching of the aggregation order file are carried out through the voucher number; the account checking file corresponding to the union pay comprises a combination of the batch number and the order number, and the union pay matching and the subsequent association matching of the aggregated order file can be carried out through the combination of the batch number and the order number.
In addition, the reconciliation files corresponding to the same target channel comprise information corresponding to one or more statements, and the reconciliation files store the information corresponding to the statements in excel, txt, json, compressed package, xtp and other format file streams. Each account checking file corresponds to a file to be put in storage, and the format and the structure of the file to be put in storage meet the storage standard. The file to be stored in the storage comprises one or more analytic information corresponding to the statements, and the format is a standard format of storage in the storage, such as one of file streams of excel, txt, json, compressed packets, xtp and the like.
And S30, determining the aggregate order file to be put in storage matched with the file to be put in storage corresponding to each account file in the system.
Specifically, based on step S20, if the parsing task of a certain reconciliation file is completed, the bill comparison processing module obtains the file to be put into storage corresponding to the reconciliation file. And then checking accounts on the basis of the files to be put in storage, and traversing all the aggregation order files in the system. Specifically, firstly, determining the payment category and the target channel of the file to be put in storage: extracting information corresponding to the payment category and the target channel field related to the file to be put in storage, then searching a payment category and a target channel mapping table, and determining the payment category and the target channel according to the mapping relation between the parameters and the field. For example: and if the payment type parameter of the file to be put in storage is ts05, determining the file to be put in storage as mobile payment, and determining the parameter of the target channel as ts0501 as WeChat.
It should be noted that the aggregate order file refers to information corresponding to all orders in the system, and is stored in one of the unified file stream formats, such as one of excel, txt, json, and compressed packet.
The aggregate order file comprises information corresponding to each configuration parameter in the configuration file, and each configuration parameter field of the aggregate order file can be the same as or different from the configuration parameter corresponding to the file to be put in storage. Therefore, through the payment category and the target channel, aggregate order files which do not meet the requirements can be screened out.
For example, the determining of the aggregate order file to be put into storage, which is correspondingly matched with the file to be put into storage in the system, specifically includes:
s31, acquiring the analysis task state of each account file;
specifically, the status of the parsing is considered to include complete and incomplete, so as to indicate whether the bill comparison processing module is started to perform the corresponding operation.
S32, if the analysis task state of the reconciliation file is completed, acquiring a file to be warehoused corresponding to the reconciliation file, and determining the payment category and the target channel of the file to be warehoused;
specifically, the reconciliation file is consistent with the payment category and the target channel of the analyzed file to be put in storage. Wherein the payment categories include mobile payment, offline card swiping, and Unionpay. Different payment categories may correspond to the same target channel or different target channels. The target channel has been described above and will not be described in detail.
S33, acquiring a plurality of candidate aggregate order files with the same payment type and the same target channel as the file to be put in storage in the system;
specifically, if the payment category of the file to be put into storage is mobile payment and the target channel of the file is WeChat, a plurality of candidate aggregation order files belonging to WeChat mobile payment under the same target object are searched from the system.
Similarly, if the payment type of the file to be put in storage is offline card swiping and the target channel is a China bank (card number), a plurality of candidate aggregated order files and the like belonging to the China bank (card number) payment under the same target object are searched from the system.
And S34, respectively associating and comparing the candidate aggregate order files with files to be put in storage, and determining the aggregate order files to be put in storage, which are correspondingly matched with the files to be put in storage in the system, according to the association comparison result.
Wherein, step S34 specifically includes:
s341, determining a bill identification corresponding to the payment category according to the payment category of the file to be put in storage;
s342, extracting first information corresponding to the bill identification in the file to be put in storage and second information corresponding to the same bill identification in a plurality of candidate aggregated order files;
s343, if the second information of any candidate aggregate order file is different from the first information of the file to be put in storage, prompting through a third-party application, and manually processing;
s344, if the second information of at least one candidate aggregate order file is the same as the first information of the file to be warehoused, whether the payment states of the candidate aggregate order file and the file to be warehoused are consistent or not is continuously determined;
s345, if the candidate aggregate order file is consistent with the payment state in the file to be warehoused, the candidate aggregate order file is the file to be warehoused aggregate order matched with the file to be warehoused;
s346, if the payment state of the candidate aggregate order file is inconsistent with that of the file to be put in storage, storing the candidate aggregate order file and the file to be put in storage in an abnormal storage table, and prompting a user or manually processing the candidate aggregate order file and the file to be put in storage through an automatic reconciliation platform until the candidate aggregate order file is matched with the file to be put in storage.
In particular, the bill identification is used to distinguish between different categories of bills. For example: the bill identification of the mobile payment statement is the order number, the bill identification of the offline card swiping statement is the voucher number, and the bill identification of the Unionpay statement is the batch number and the order number.
For example, the following steps are carried out:
if the payment type of the file to be put in storage is mobile payment, determining whether a candidate aggregation order file with the same order number as that of the file to be put in storage exists;
if no candidate aggregated order file with the same order number as the file to be put in storage exists, prompting through a third-party application, and manually processing;
if the candidate aggregate order file with the same order number as the file to be put in storage exists, continuously determining the payment state of the candidate aggregate order file, such as transaction amount, payment time, commission charge and the like;
if the payment state of the candidate aggregate order file is consistent with that of the file to be put in storage, the candidate aggregate order file is an aggregate order file matched with the file to be put in storage;
and if the payment state of the candidate aggregation order file is inconsistent with the file to be warehoused, storing the candidate aggregation order file and the file to be warehoused into a warehousing exception list, and prompting a user or manually processing the candidate aggregation order file and the file to be warehoused through an automatic reconciliation platform until the candidate aggregation order file is matched with the file to be warehoused. That is, when an exception occurs in the warehousing, not only an exception prompt is presented, but also a solution is provided until the exception is resolved, so as to prepare for a subsequent monthly/quarterly/annual reconciliation table.
Further, when processing an exception, the candidate aggregate order file and the upstream original order information corresponding to the file to be put in storage are obtained, and the exception is updated to obtain accurate account checking information.
And S40, storing the matched aggregate order files to be stored and files to be stored in a storage pair by pair.
In the embodiment, a plurality of aggregated order files to be put in storage, which are correspondingly matched with all files to be put in storage, are obtained; sorting the matched files to be put in storage and the matched aggregated order files to be put in storage according to preset conditions; and warehousing the sorted files to be warehoused and the aggregated order files to be warehoused in a pair by pair. The preset condition may be that the sequence is performed according to a time sequence, or the sequence is performed according to a sequence number from small to large. It can also be custom set according to business requirements.
And further, storing all matched aggregated order files to be stored and files to be stored in a storage mode in a single-thread storage mode in a pair by pair.
And when the storage is abnormal or the matching is abnormal, early warning prompt is carried out, and manual processing is carried out. For example: the method is used for reminding the unilateral account abnormity occurring in daily automatic account checking and informing financial staff to pay attention to the treatment in time in the modes of short messages, WeChat and the like. And a manual intervention and pre-adjustment function is provided, and manual time processing (refund, verification and cancellation and the like) for the unilateral account is performed.
And after warehousing, a monthly reconciliation table, a quarterly reconciliation table and an annual reconciliation table corresponding to different channels of the same target object are constructed according to the month, the quarter and the year so as to provide data and reports for the user.
Therefore, based on the steps S10-S40, the multiple reconciliation files corresponding to the multiple channels are synchronously acquired and analyzed in parallel by utilizing multiple threads, time is saved, the multi-channel processing requirements are met, meanwhile, the multiple threads are associated and matched, abnormal conditions are manually processed until all files to be put in storage are successfully put in storage, the data accuracy is ensured, and the putting-in efficiency is improved.
In the above embodiments, all or part of the implementation may be realized by software, hardware, firmware, or any combination thereof. When implemented using a software program, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, cause the processes or functions described in accordance with the embodiments of the invention to occur, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, the computer instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center via wired (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that incorporates one or more of the available media. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., Solid State Disk (SSD)), among others.
Based on the method, the application also provides a multi-channel bill warehousing system. In one embodiment, as shown in fig. 2, fig. 2 illustrates a block diagram of a multi-channel bill warehousing system. The multi-channel bill warehousing system comprises a timer 1, a bill acquisition module 111, an analysis module 112 and a bill comparison processing module 113, wherein the bill acquisition module 111, the analysis module 112 and the bill comparison processing module 113 are respectively connected with the timer 1;
the timer 1 is used for configuring time for each module and establishing related tasks for each module when the time arrives;
the bill acquiring module 111 is configured to acquire reconciliation files corresponding to a plurality of target channels of a target object;
the analysis module 112 is configured to synchronously perform analysis processing on the reconciliation files corresponding to the multiple target channels to obtain files to be put into a warehouse, which correspond to the reconciliation files;
the bill comparison processing module 113 is configured to determine aggregate order files to be put into storage, which are matched with files to be put into storage corresponding to each ledger file in the system; and warehousing the matched aggregated order files to be warehoused and files to be warehoused in a pair by pair, specifically according to the method.
In other embodiments, the warehousing system of the multi-channel bill comprises an intelligent terminal, as shown in fig. 3, which includes at least one processor (processor) 20; a display screen 21; and a memory (memory)22, and may further include a communication Interface (Communications Interface)23 and a bus 24. The processor 20, the display 21, the memory 22 and the communication interface 23 can communicate with each other through the bus 24. The display screen 21 is configured to display a user guidance interface preset in the initial setting mode. The communication interface 23 may transmit information. The processor 20 may call logic instructions in the memory 22 to perform the methods in the embodiments described above.
Furthermore, the logic instructions in the memory 22 may be implemented in software functional units and stored in a computer readable storage medium when sold or used as a stand-alone product.
The memory 22, which is a computer-readable storage medium, may be configured to store a software program, a computer-executable program, such as program instructions or modules corresponding to the methods in the embodiments of the present invention. The processor 20 executes the functional application and data processing, i.e. implements the method in the above-described embodiments, by executing the software program, instructions or modules stored in the memory 22.
The memory 22 may include a storage program area and a storage data area, wherein the storage program area may store an application program required for operating the voice customer service system, at least one function; the storage data area may store data created according to the use of the terminal device, and the like. Further, the memory 22 may include a high speed random access memory and may also include a non-volatile memory. For example, a variety of media that can store program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk, may also be transient storage media.
The above disclosure is only for the purpose of illustrating the preferred embodiments of the present invention, and it is therefore to be understood that the invention is not limited by the scope of the appended claims.

Claims (10)

1. A multi-channel bill warehousing method comprises the following steps:
acquiring account checking files corresponding to a plurality of target channels of a target object;
synchronously analyzing the account checking files corresponding to the target channels to obtain files to be put in storage corresponding to the account checking files;
determining aggregate order files to be put in storage, which are matched with files to be put in storage corresponding to each account file in the system;
and warehousing the matched aggregated order files to be warehoused and files to be warehoused in a pair by pair.
2. The method for warehousing a multi-channel bill according to claim 1, wherein the acquiring tie-up files corresponding to a plurality of target channels of a target object specifically comprises:
determining a plurality of target channels corresponding to the target object;
acquiring account checking files corresponding to a plurality of target channels of a target object through a network at intervals of first preset time;
if the account checking files corresponding to the target channels of the target object are successfully acquired, updating the acquisition task flag of the account checking files to be complete;
if the account checking files corresponding to the target channels of the target object are not successfully acquired, waiting for second preset time and then executing the task of acquiring the account checking files again;
and if the account checking files corresponding to the target channels of the target object are not successfully acquired, updating the acquisition task flag of the account checking files to be failure, recording the failure reason, and performing manual processing.
3. The method of warehousing a multi-channel bill according to claim 1, wherein the step of analyzing reconciliation files corresponding to the target channels synchronously to obtain the files to be warehoused corresponding to the reconciliation files specifically comprises:
acquiring the state of an acquisition task mark of the account checking file;
if the task mark of acquiring the account checking file is complete, analyzing the account checking files corresponding to the target channels in parallel according to a preset configuration file;
if the account checking files corresponding to all the target channels are analyzed, obtaining files to be put in storage corresponding to the account checking files; wherein, each file to be put in storage has the same file format and structure;
and updating the analysis task of the account checking file to be finished.
4. The method for warehousing a multi-channel bill according to claim 3, wherein the determining of the aggregate order file to be warehoused that is matched with the file to be warehoused corresponding to each ledger file in the system specifically comprises:
acquiring the analysis task state of each account file;
if the analysis task state of the reconciliation file is completed, acquiring a file to be put in storage corresponding to the reconciliation file, and determining the payment category and the target channel of the file to be put in storage;
acquiring a plurality of candidate aggregation order files with the same payment type and the same target channel as the file to be put in storage in a system;
and respectively associating and comparing the candidate aggregate order files with files to be put in storage, and determining the aggregate order files to be put in storage, which are correspondingly matched with the files to be put in storage in the system, according to the association comparison result.
5. The method of warehousing a multi-channel bill as claimed in claim 4, wherein the payment category includes one or more of mobile payment, offline card swiping and Unionpay.
6. The warehousing method of the multi-channel bill according to claim 5, wherein the associating and comparing the candidate aggregate order files with files to be warehoused respectively, and determining the aggregate order file to be warehoused in the system corresponding to the file to be warehoused according to the association comparison result specifically comprises:
determining a bill identification corresponding to the payment category according to the payment category of the file to be put in storage;
extracting first information corresponding to the bill identification in the file to be put in storage and second information corresponding to the same bill identification in a plurality of candidate aggregated order files;
if the second information of any candidate aggregation order file is different from the first information of the file to be put in storage, prompting through a third-party application, and manually processing;
if the second information of at least one candidate aggregate order file is the same as the first information of the file to be warehoused, whether the payment states of the candidate aggregate order file and the file to be warehoused are consistent or not is continuously determined;
if the candidate aggregate order file is consistent with the payment state in the file to be warehoused, the candidate aggregate order file is the file to be warehoused aggregate order matched with the file to be warehoused;
and if the payment state of the candidate aggregate order file is inconsistent with that of the file to be warehoused, storing the candidate aggregate order file and the file to be warehoused in an warehousing exception list, and manually processing the candidate aggregate order file and the file to be warehoused through an automatic reconciliation platform until the candidate aggregate order file is matched with the file to be warehoused.
7. The warehousing method of the multi-channel bill according to claim 1, wherein the warehousing of each matched aggregate order file to be warehoused and file to be warehoused pair by pair specifically comprises:
acquiring a plurality of aggregated order files to be put into a warehouse, which are correspondingly matched with all files to be put into the warehouse;
sorting the matched files to be put in storage and the matched aggregated order files to be put in storage according to preset conditions;
and warehousing the sorted files to be warehoused and the aggregated order files to be warehoused in a pair by pair.
8. The warehousing method of the multi-channel bill according to claim 1, wherein after the step of warehousing the matched aggregate order file to be warehoused and file to be warehoused in pair by pair, the step of warehousing the matched aggregate order file to be warehoused and the matched file to be warehoused comprises the following steps:
and constructing a monthly account table, a quarterly account table and an annual account table corresponding to different channels of the same target object.
9. The multi-channel bill warehousing system is characterized by comprising a timer, a bill acquisition module, an analysis module and a bill comparison processing module, wherein the bill acquisition module, the analysis module and the bill comparison processing module are respectively connected with the timer;
the timer is used for configuring time for each module and establishing related tasks for each module when the time is up;
the bill acquisition module is used for acquiring reconciliation files corresponding to a plurality of target channels of a target object;
the analysis module is used for synchronously analyzing the reconciliation files corresponding to the target channels to obtain files to be put in storage corresponding to the reconciliation files;
the bill comparison processing module is used for determining aggregate order files to be put in storage matched with files to be put in storage corresponding to each account file in the system; and warehousing the matched aggregated order files to be warehoused and files to be warehoused in a pair by pair.
10. A computer temporary storage medium, characterized in that the storage medium stores one or more programs, and the one or more programs are executed by a processor to implement the steps of the method for warehousing a multi-channel bill according to any one of claims 1 to 8.
CN202011180734.4A 2020-10-29 2020-10-29 Multi-channel bill storage method, system and storage medium Active CN112270537B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011180734.4A CN112270537B (en) 2020-10-29 2020-10-29 Multi-channel bill storage method, system and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011180734.4A CN112270537B (en) 2020-10-29 2020-10-29 Multi-channel bill storage method, system and storage medium

Publications (2)

Publication Number Publication Date
CN112270537A true CN112270537A (en) 2021-01-26
CN112270537B CN112270537B (en) 2022-01-25

Family

ID=74345768

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011180734.4A Active CN112270537B (en) 2020-10-29 2020-10-29 Multi-channel bill storage method, system and storage medium

Country Status (1)

Country Link
CN (1) CN112270537B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113469797A (en) * 2021-06-30 2021-10-01 深圳汇商通盈科技有限公司 Account checking method and device, electronic equipment and storage medium
CN114971605A (en) * 2022-04-26 2022-08-30 平安国际融资租赁有限公司 Verification processing method and device for offline payment, computer equipment and medium

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20130290177A1 (en) * 2012-04-26 2013-10-31 Amy Christine Milam Systems and methods for facilitating processing of electronic payments
US20140143101A1 (en) * 2012-11-19 2014-05-22 Portfolio Recovery Associates, Inc. Systems, methods and computer program products that facilitate matching of debtor payments to collection authority accounts
CN109242460A (en) * 2018-07-17 2019-01-18 华润物业工程科技有限公司 A kind of payment system and its account checking method based on multiple channel of disbursement
US20190121865A1 (en) * 2017-10-20 2019-04-25 Bank Of America Corporation System for synchronous document captures into an asynchronous archive and document-level archiving reconciliation
CN109739934A (en) * 2019-01-08 2019-05-10 厦门投融汇网络有限公司 Difference set account checking method, medium, computer equipment and system
CN110188136A (en) * 2019-06-10 2019-08-30 四川长虹电器股份有限公司 A kind of modularization reconciliation system and its account checking method based on bank-corporate express
CN110751550A (en) * 2019-10-12 2020-02-04 上海陆家嘴国际金融资产交易市场股份有限公司 Account checking method and device, computer equipment and storage medium

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20130290177A1 (en) * 2012-04-26 2013-10-31 Amy Christine Milam Systems and methods for facilitating processing of electronic payments
US20140143101A1 (en) * 2012-11-19 2014-05-22 Portfolio Recovery Associates, Inc. Systems, methods and computer program products that facilitate matching of debtor payments to collection authority accounts
US20190121865A1 (en) * 2017-10-20 2019-04-25 Bank Of America Corporation System for synchronous document captures into an asynchronous archive and document-level archiving reconciliation
CN109242460A (en) * 2018-07-17 2019-01-18 华润物业工程科技有限公司 A kind of payment system and its account checking method based on multiple channel of disbursement
CN109739934A (en) * 2019-01-08 2019-05-10 厦门投融汇网络有限公司 Difference set account checking method, medium, computer equipment and system
CN110188136A (en) * 2019-06-10 2019-08-30 四川长虹电器股份有限公司 A kind of modularization reconciliation system and its account checking method based on bank-corporate express
CN110751550A (en) * 2019-10-12 2020-02-04 上海陆家嘴国际金融资产交易市场股份有限公司 Account checking method and device, computer equipment and storage medium

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113469797A (en) * 2021-06-30 2021-10-01 深圳汇商通盈科技有限公司 Account checking method and device, electronic equipment and storage medium
CN114971605A (en) * 2022-04-26 2022-08-30 平安国际融资租赁有限公司 Verification processing method and device for offline payment, computer equipment and medium

Also Published As

Publication number Publication date
CN112270537B (en) 2022-01-25

Similar Documents

Publication Publication Date Title
CN112270537B (en) Multi-channel bill storage method, system and storage medium
CN113205402A (en) Account checking method and device, electronic equipment and computer readable medium
CN115170294A (en) Client classification method and device and server
CN112801792A (en) Information checking method, device, equipment and storage medium based on SaaS platform
CN112308590B (en) Parameter processing method and device, computing equipment and storage medium
CN112506771A (en) Message comparison method and device
CN110781235A (en) Big data based purchase data processing method and device, terminal and storage medium
CN112734352A (en) Document auditing method and device based on data dimensionality
CN110895761B (en) After-sales service application information processing method and device
CN110599133A (en) Data processing method and device based on block chain network and storage medium
CN107316245A (en) Expense adjusts method and system
CN112241866A (en) Service processing method and device, computer readable medium and electronic equipment
CN112330429A (en) Tax data processing method, system, server and storage medium
US11921615B2 (en) Computer-implemented methods, computer-readable media and electronic devices for processing test electronic transactions
CN113721950A (en) Resource loss prevention and control processing method and device
US20190197533A1 (en) Computer-implemented methods, computer-readable media and electronic devices for processing test electronic transactions
CN111179075B (en) Settlement method, device, storage medium and settlement server for medium-and-long-term power transaction
CN110765148B (en) Service data processing method and device
CN114997977B (en) Data processing method, device, electronic equipment and computer readable medium
CN111951016A (en) Merchant protocol subscription storage method and device
CN114511314A (en) Payment account management method and device, computer equipment and storage medium
CN114463100A (en) Order data processing method, device, equipment and storage medium
CN115293755A (en) Bill reconciliation processing method, device, equipment and storage medium
KR20190127318A (en) Server and method for providing intelligent order service
CN113592571A (en) Bill issuing early warning method, device, equipment and computer readable medium

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
EE01 Entry into force of recordation of patent licensing contract

Application publication date: 20210126

Assignee: Guangdong Rongtong Financial Leasing Co.,Ltd.

Assignor: GUANGDONG TONGGUAN TECHNOLOGY CO.,LTD.

Contract record no.: X2022980013964

Denomination of invention: A storage method, system and storage medium for multi-channel billing

Granted publication date: 20220125

License type: Exclusive License

Record date: 20220902

EE01 Entry into force of recordation of patent licensing contract
PE01 Entry into force of the registration of the contract for pledge of patent right
PE01 Entry into force of the registration of the contract for pledge of patent right

Denomination of invention: A storage method, system and storage medium for multi-channel billing

Effective date of registration: 20220906

Granted publication date: 20220125

Pledgee: Guangdong Rongtong Financial Leasing Co.,Ltd.

Pledgor: GUANGDONG TONGGUAN TECHNOLOGY CO.,LTD.

Registration number: Y2022980014599

PC01 Cancellation of the registration of the contract for pledge of patent right
PC01 Cancellation of the registration of the contract for pledge of patent right

Date of cancellation: 20231101

Granted publication date: 20220125

Pledgee: Guangdong Rongtong Financial Leasing Co.,Ltd.

Pledgor: GUANGDONG TONGGUAN TECHNOLOGY CO.,LTD.

Registration number: Y2022980014599

EC01 Cancellation of recordation of patent licensing contract
EC01 Cancellation of recordation of patent licensing contract

Assignee: Guangdong Rongtong Financial Leasing Co.,Ltd.

Assignor: GUANGDONG TONGGUAN TECHNOLOGY CO.,LTD.

Contract record no.: X2022980013964

Date of cancellation: 20231123