CN107798109A - Method, apparatus, computer equipment and the storage medium of reconciliation clearance - Google Patents
Method, apparatus, computer equipment and the storage medium of reconciliation clearance Download PDFInfo
- Publication number
- CN107798109A CN107798109A CN201711058246.4A CN201711058246A CN107798109A CN 107798109 A CN107798109 A CN 107798109A CN 201711058246 A CN201711058246 A CN 201711058246A CN 107798109 A CN107798109 A CN 107798109A
- Authority
- CN
- China
- Prior art keywords
- reconciliation
- billing files
- difference
- bill
- rule
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/148—File search processing
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Library & Information Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of method of reconciliation clearance.The method of reconciliation clearance includes：The billing files in the range of the scheduled time are obtained from data server；With the presence or absence of the billing files having with the reconciliation rule match in default reconciliation rule list in the billing files got according to prefixed time interval inquiry, if so, then carrying out reconciliation clearance to the billing files of matching according to the reconciliation rule；When carrying out reconciliation clearance to the billing files of matching according to corresponding reconciliation rule, if being had differences between the billing files, there will be the billing files of difference to store into difference summary.By way of billing files to first getting carry out reconciliation, all billing files are waited all to obtain to finish and just proceed by reconciliation without expending the time.The first ready method with regard to first reconciliation of this bill, it can first get reconciliation and finish the result being had differences between bill, then can carry out corresponding difference processing according to the difference results of bill in time.
Description
Technical field
The present invention relates to financial data processing fields, method, apparatus, computer more particularly to a kind of reconciliation clearance are set
Standby and storage medium.
Background technology
With the popularization of network technology and mobile communication technology, the internet financial development in China is rapid in recent years, new
Mechanism is continued to bring out, and market scale is also paid on continuous enlargement, line also increasingly to be popularized, therefore the clearance of financial data is needed
Ask also increasingly cumulative.
Conventional art to financial data when clearing, using payment and reconciliation set of system system, the friendship according to reality
Easy flow chart of data processing is handled, and will entirely handle that logic is mixed in together, does not handle the strict difinition of logic.Carry out
Financial data clear when, because financial data is more, when exist in financial data bill it is variant when, difference can not be obtained in time
The result of bill, then corresponding difference processing can not be carried out according to the result of difference bill in time.
The content of the invention
Based on this, it is necessary to for above-mentioned technical problem, there is provided a kind of reconciliation that can obtain difference account unijunction fruit in time
Method, apparatus, computer equipment and the storage medium of clearance.
A kind of method of reconciliation clearance, methods described include：
The billing files in the range of the scheduled time are obtained from data server；
According in the billing files that get of prefixed time interval inquiry with the presence or absence of have with default reconciliation rule list
Reconciliation rule match billing files, if so, then
Reconciliation clearance is carried out to the billing files of matching according to the reconciliation rule；
When carrying out reconciliation clearance to the billing files of matching according to corresponding reconciliation rule, if the billing files
Between have differences, then there will be the billing files of difference to store into difference summary.
In one of the embodiments, the interval to schedule travels through predetermined reconciliation rule list, is deposited when inquiring
Have obtained with the billing files of the reconciliation rule match in the predetermined reconciliation rule list finish when, then according to corresponding right
Account rule carries out reconciliation clearance to the billing files of matching, including：
Uniform format processing is carried out to the billing files got, and obtains the title of the billing files after unified form；
Transaction corresponding to billing files after determining the unified form according to the title of the billing files after unified form
Type；
Advised in the billing files inquired about after the unified form with the presence or absence of type of transaction and the reconciliation in reconciliation rule list
The billing files then matched.
In one of the embodiments, it is described work as predetermined reconciliation rule in there are billing files corresponding to reconciliation rule to match
During success, then the corresponding billing files predetermined reconciliation rule corresponding to is subjected to reconciliation clearance, including：
When carrying out reconciliation clearance according to reconciliation rule reconciliation monofile, if being detected according to the title of the billing files
The type of transaction of the billing files associates with payment platform, then when the Bill Status for meeting default payment platform and business side
When, then difference detail form is generated according to the difference condition between the billing files of the reconciliation.
In one of the embodiments, the difference condition generation difference detail form between the billing files according to reconciliation it
Afterwards, in addition to：
There will be the billing files of difference to store into difference bill table；
If corresponding to described in billing files at least one bill do not find it is regular with the account according to predetermined reconciliation
The reconciliation bill singly matched, then search regular with the bill with the presence or absence of with good grounds predetermined reconciliation in the difference bill table
The reconciliation bill matched somebody with somebody；
If so, the reconciliation bill in the difference bill table and the bill are then subjected to reconciliation according to predetermined reconciliation rule
Clearance；
If it is not, the type of transaction of the bill is associated with payment platform when being detected according to the file name of the bill
When, then the bill is stored into the difference bill table.
In one of the embodiments, the method for the reconciliation clearance also includes：
The difference bill table is read according to prefixed time interval；
When detecting that the difference bill stored in the difference bill table there are more than preset time threshold, then by institute
The corresponding difference account individual palpation stated more than preset time threshold is marked according to difference detail, and will be stored in the difference bill table
The difference bill more than preset time threshold store into difference summary；
The difference account more than preset time threshold stored in the difference bill table is deleted in the difference bill table
It is single.
In one of the embodiments, the method for the reconciliation clearance also includes：
When the billing files for not carrying out reconciliation are not present in the data server, then obtain and carried out reconciliation and finish
Bill reconciliation clearance result；
The type of transaction according to corresponding to the file name of progress reconciliation billing files determines billing files, by billing files
Reconciliation clearance result is stored into reconciliation summary sheet according to the type of transaction；
The reconciliation summary sheet is sent to presumptive address.
In one of the embodiments, it is described that it is cleared to the billing files progress reconciliation of matching according to the reconciliation rule
Afterwards, in addition to：
When detect have the billing files for not carrying out reconciliation in data server when, then obtained again by data server
The billing files of reconciliation are not carried out, then the billing files got are subjected to reconciliation clearance by corresponding predetermined reconciliation rule.
A kind of device of reconciliation clearance, including：
Acquisition module, for obtaining the billing files in the range of the scheduled time from data server；
Enquiry module, for according in the billing files that get of prefixed time interval inquiry with the presence or absence of have with it is default
The billing files of reconciliation rule match in reconciliation rule list；
Module is cleared in reconciliation, for there are and preset when in the billing files got according to prefixed time interval inquiry
Reconciliation rule list in reconciliation rule match billing files when, then the billing files of matching are entered according to the reconciliation rule
Row reconciliation is cleared；
Difference summarizing module, for when the billing files progress reconciliation clearance according to corresponding reconciliation rule to matching
When, if being had differences between the billing files, there will be the billing files of difference to store into difference summary.
A kind of computer equipment, including memory, processor and storage can be run on a memory and on a processor
Computer program, following steps are realized during the computing device described program：
The billing files in the range of the scheduled time are obtained from data server；
According in the billing files that get of prefixed time interval inquiry with the presence or absence of have with default reconciliation rule list
Reconciliation rule match billing files, if so, then
Reconciliation clearance is carried out to the billing files of matching according to the reconciliation rule；
When carrying out reconciliation clearance to the billing files of matching according to corresponding reconciliation rule, if the billing files
Between have differences, then there will be the billing files of difference to store into difference summary.
A kind of computer-readable recording medium, computer program is stored thereon with, it is real when described program is executed by processor
Existing following steps：
The billing files in the range of the scheduled time are obtained from data server；
According in the billing files that get of prefixed time interval inquiry with the presence or absence of have with default reconciliation rule list
Reconciliation rule match billing files, if so, then
Reconciliation clearance is carried out to the billing files of matching according to the reconciliation rule；
When carrying out reconciliation clearance to the billing files of matching according to corresponding reconciliation rule, if the billing files
Between have differences, then there will be the billing files of difference to store into difference summary.
Method, apparatus, computer equipment and the storage medium of above-mentioned reconciliation clearance, by the server for storing billing files
The billing files in the scheduled time are got, interval travels through predetermined reconciliation rule list to schedule, there are when inquiring
Obtained with the billing files of the reconciliation rule match in predetermined reconciliation rule list when finishing, then it is right according to corresponding reconciliation rule
The billing files of matching carry out reconciliation clearance, when the server for detecting storage file does not carry out the billing files of reconciliation
When, then summary sheet is cleared in the result generation cleared according to reconciliation.By way of the billing files to first getting carry out reconciliation,
Need not expend the time waits all billing files all to obtain to finish and just proceed by reconciliation.This bill is first ready with regard to first reconciliation
Method, can first get reconciliation and finish the result being had differences between bill, then can be entered in time according to the difference results of bill
The corresponding difference processing of row.
Brief description of the drawings
Fig. 1 is the applied environment figure of the method that reconciliation is cleared in one embodiment；
Fig. 2 is the schematic flow sheet of the method that reconciliation is cleared in one embodiment；
Fig. 3 is whether the bill inquired about in one embodiment in difference bill table matches and can carry out the flow of reconciliation clearance and show
It is intended to；
Fig. 4 is the schematic flow sheet of the method that reconciliation is cleared in another embodiment；
Fig. 5 is the data flow structure chart of billing files in one embodiment；
Fig. 6 is the reconciliation schematic diagram inside branch company between each platform in one embodiment；
Fig. 7 is the time diagram that process is cleared in reconciliation in one embodiment；
Fig. 8 is the structured flowchart of the device that reconciliation is cleared in one embodiment；
Fig. 9 is the internal structure schematic diagram of one embodiment Computer equipment.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
Fig. 1 shows the applied environment figure of the method that reconciliation is cleared in one embodiment.Reference picture 1, reconciliation clearance
Method can be applied in the system of reconciliation clearance, and the system includes reconciliation clearance server 110 and data server 120, reconciliation
Clearance server 110 is connected by network with data server 120.Reconciliation clearance server 110 and data server can be with
It is the server for realizing simple function or the server for realizing multiple functions, can is specifically independent physical services
Device or physical server cluster.Reconciliation clearance server obtains the account in the range of the scheduled time from data server 120
After monofile, according in the billing files that get of prefixed time interval inquiry with the presence or absence of have with default reconciliation rule list
Reconciliation rule match billing files, if so, then carrying out reconciliation clearance to the billing files of matching according to reconciliation rule；When by
When carrying out reconciliation clearance to the billing files of matching according to corresponding reconciliation rule, if being had differences between billing files, it will deposit
In the billing files of difference store the difference summary to reconciliation clearance server 110.Specifically, in reconciliation clearance server
Before 110 billing files for getting in the range of the scheduled time from data server 120, data server 120 can pass through network
Get the billing files of each branch company or third party's channel and preservation.
As shown in Fig. 2 in one embodiment, there is provided a kind of method of reconciliation clearance, this method is with applied to such as Fig. 1
It is illustrated in shown reconciliation clearance server.Including：
Step 202, the billing files in the range of the scheduled time are obtained from data server.
The billing files of reconciliation are needed to be stored in data server.Before reconciliation clearance starts, reconciliation server meeting
The billing files in the range of the scheduled time are obtained in the billing files stored from data server.Generally, pre- timing
Between scope be arranged to 24 hours, that is, obtain intraday billing files and prepare to carry out the billing files in this period pair
Account is cleared.
Step 204, whether there is in the billing files got according to prefixed time interval inquiry has and default reconciliation
The billing files of reconciliation rule match in rule list, if so, then performing step 206；If it is not, then perform step 212.
Default reconciliation rule list is stored with reconciliation server, there is a plurality of reconciliation rule in reconciliation rule list.
In actual mechanical process, a time can be typically set, the reconciliation rule list in the poll reconciliation server of timing, search reconciliation
In the billing files that server is got from data server, if exist and the reconciliation rule match in reconciliation rule list
Two billing files.Under normal circumstances, corresponding two billing files of reconciliation rule, when two corresponding to a reconciliation rule
Billing files are when all the match is successful, represent with two reconciliation files of the reconciliation rule match be present in reconciliation server from
In the billing files got on data server.
Step 206, reconciliation clearance is carried out to the billing files of matching according to reconciliation rule.
Step 208, when carrying out reconciliation clearance to the billing files of matching according to corresponding reconciliation rule, if billing files
Between when having differences, then there will be the billing files of difference to store into difference summary.
It is according to the corresponding reconciliation of default reconciliation rule when reconciliation monofile carries out reconciliation clearance.Every reconciliation rule
Billing files corresponding to being not only then are different, and corresponding reconciliation clearance mode is also different.Therefore when two bills
After file is according to the success of reconciliation rule match, the two billing files will carry out reconciliation clearance according to corresponding billing files.
When carrying out reconciliation clearance to the billing files of matching according to corresponding reconciliation rule, billing files it is possible that
Difference, when having variant, then the difference that will be stored in there will be the billing files of difference in reconciliation server collects
In table.Specific difference bill and difference condition can also be known by consulting difference summary in the future.
Step 210, do not deal with.
Have and default reconciliation rule list when whether there is in the billing files got according to prefixed time interval inquiry
In reconciliation rule match billing files when, if the not bill with the reconciliation rule match in default reconciliation rule list
File, then illustrate in the billing files that reconciliation server is got from data server, according to reconciliation rule, and in the absence of two
Individual billing files are mutually matched, that is to say, that and two billing files of reconciliation corresponding with reconciliation rule are not all got,
Therefore the work of reconciliation clearance can not be started.
By way of this billing files to first getting carry out reconciliation, all bills are waited without expending the time
File, which all obtains to finish, just proceeds by reconciliation.The first ready method with regard to first reconciliation of this bill, it can first get reconciliation and finish
The result being had differences between bill, then it can carry out corresponding difference processing according to the difference results of bill in time.
In one embodiment, whether there is in the billing files got according to prefixed time interval inquiry has and presets
Reconciliation rule list in reconciliation rule match billing files, including：The billing files got are carried out at uniform format
Reason, and obtain the title of the billing files after unified form；Unified lattice are determined according to the title of the billing files after unified form
Type of transaction corresponding to billing files after formula；It whether there is type of transaction and reconciliation in billing files after the unified form of inquiry
The billing files of reconciliation rule match in rule list.
After reconciliation server gets billing files from data server, reconciliation server can to get bill text
Part carries out uniform format, for example is all named according to modes such as date-company-types of transaction.In this way, according to unified to file name
The processing of form, then type of transaction that can be according to corresponding to the file name of each billing files gets the billing files.Hand over
Easy type is related to reconciliation dimension and branch company, and reconciliation dimension is divided into outside reconciliation and internal reconciliation.Generally, it is outside
Reconciliation refers to the reconciliation of payment platform and third party's channel, and internal reconciliation refers to account platform and transaction platform, transaction
Reconciliation between platform and payment platform.Therefore typically, the corresponding reconciliation rule of a kind of type of transaction.
Whether there is in the billing files got according to prefixed time interval inquiry has and default reconciliation rule list
In reconciliation rule match billing files when, be exactly that the type of transaction according to corresponding to reconciliation rule goes to search this transaction class in fact
Two billing files corresponding to type.If inquiring the billing files with the reconciliation rule match in default reconciliation rule list,
Then it is ready to there are the regular bill of reconciliation for explanation, you can be carried out according to this reconciliation rule to the billing files of matching
Reconciliation is cleared.Simple to operate according to the billing files name-matches reconciliation rule after unified form, it is convenient to search, also can be rapid
It is accurate to match corresponding billing files and start reconciliation clearance.
In one embodiment, when having billing files corresponding to reconciliation rule in predetermined reconciliation rule the match is successful,
Then by corresponding billing files, the predetermined reconciliation rule corresponding to carries out reconciliation clearance, including：According to reconciliation rule reconciliation
When monofile carries out reconciliation clearance, if detecting that the type of transaction of billing files and payment platform close according to the title of billing files
Connection, then when meeting the Bill Status of default payment platform and business side, then according to the difference feelings between the billing files of reconciliation
Condition generates difference detail form.
When by corresponding billing files, predetermined reconciliation rule carries out reconciliation clearance corresponding to, different types of transaction
When reconciliation clearance is carried out, the mode of processing also can be different.When the title according to billing files detects billing files
When type of transaction associates with payment platform, i.e., the text of a billing files in two billing files matched with reconciliation at least be present
When the type of transaction included in part title is payment platform, then when carrying out reconciliation clearance, if the shape between two bills
Condition meets the state between default bill, that is, payment platform and the Bill Status of business side, then will be according to two
Specific difference condition generation schedule of variance between bill.Due to payment platform play be payment effect, with disappearing for user
The expense amount of money links directly, it is therefore desirable to carries out specially treated to the related order of payment platform, the detailed record of problem can be had
Helping problem can be found and be handled early, and classification processing liquid energy is carried out the problem of between platform and improves treatment effect.
In one embodiment, after the difference condition generation difference detail form between the billing files according to reconciliation,
Whether the bill also included in inquiry difference bill table as shown in Figure 3 matches the flow that can carry out reconciliation clearance.Specifically such as
Under：
Step 302, there will be the billing files of difference to store into difference bill table.
, can also there will be difference feelings after difference condition generation difference detail form between the billing files according to reconciliation
Two billing files of condition are stored in difference bill table.Difference detail form is different, difference detail form from difference bill table
The specific difference condition between being bill of storage, and what is stored in difference bill table is that bill is present in itself, that is, mutually
The bill of difference, in simple terms, what difference detail form was deposited is specific reconciliation result, and the storage of difference bill table is reconciliation text
Part.
Step 304, if at least one bill is not found according to predetermined reconciliation rule and account in corresponding billing files
The reconciliation bill singly matched, then search the reconciliation matched in difference bill table with the presence or absence of with good grounds predetermined reconciliation rule with bill
Bill.
Step 306, the reconciliation bill in difference bill table and bill are subjected to reconciliation clearance according to predetermined reconciliation rule.
Whether there is in the billing files got according to prefixed time interval inquiry has and default reconciliation rule list
In reconciliation rule match billing files when, in fact it could happen that situation be two bills with a certain bar reconciliation rule match
File is looked only for one, or is not found both, that is, reconciliation server is obtaining bill text from data server
During part, these billing files are not got.So billing files corresponding to this reconciliation rule are not ready, then can not
Reconciliation is carried out according to this reconciliation rule.As in this case, will enter in difference bill table inquire about whether with good grounds predetermined pair
The reconciliation bill that account rule matches with bill, if any, just the billing files by the two matchings are advised according to predetermined reconciliation
Then carry out reconciliation clearance.
Step 308, when detected according to the file name of bill the type of transaction of bill is associated with payment platform when, then
Bill is stored into difference bill table.
Before reconciliation clearance is carried out, transaction that reconciliation server can be according to belonging to the file name of bill confirms the bill
Type, when detecting that the type of transaction belonging to the bill associates with payment platform, that is, two accounts with reconciliation rule match
When the type of transaction included in the file name of at least one billing files in monofile to be present be payment platform, then work as bill
Between when having differences, the two bills will be stored into difference bill table.
Discrepant bill is first temporarily stored to difference bill table, can be again when reconciliation clearance is started next time
Bill in the secondary bill table to difference carries out reconciliation, reduces the situation that bill is missed that occurs.When bill is discrepant, first
" put on one side ", rather than carry out inquiry again etc. for this discrepant bill always, but with reconciliation next time
Clearance flow is carried out together, further improves treatment effeciency.
In one embodiment, the method for above-mentioned reconciliation clearance also includes：Difference bill is read according to prefixed time interval
Table；When detecting that the difference bill stored in difference bill table there are more than preset time threshold, then when will exceed default
Between the corresponding difference account individual palpation of threshold value be marked according to difference detail, and exceed preset time threshold by what is stored in difference bill table
The difference bill of value is stored into difference summary；Deleted in difference bill table stored in difference bill table when exceeding default
Between threshold value difference bill.
For the difference bill table stored on reconciliation server, because what is stored in difference bill table is to have differences
Billing files, therefore, it is necessary to these bills carry out one timing read, according to default time interval read difference account
Single table, and get the difference bill stored in difference bill table.When difference bill is preserved into difference bill table, this can be recorded
Time in difference bill deposit difference bill table, after difference bill is got, the time that difference bill is stored in can be carried out
Detection.When detecting the presence of variant bill and exceeding preset time threshold, that is, detect the difference stored in difference bill table
When bill be there are more than preset time threshold, then the corresponding difference account individual palpation more than preset time threshold is entered according to difference detail
Line flag, and the difference bill more than preset time threshold stored in difference bill table is stored into difference summary.When
Detect and there are in the difference bill stored in difference bill table more than preset time threshold, i.e., for difference bill table
Speech, this difference bill is " expired ", then the difference detail that will obtain this difference account individual palpation according to reconciliation clearance result is right
It is marked, and by this " expired " difference bill store into difference summary.Meanwhile in difference bill table
In, the difference bill of this " expired " can be also deleted.
Reconciliation server can regularly read the difference billing data stored in reconciliation server on difference bill table, and detect
Whether difference billing data is expired, if expired, the difference bill will be marked.For example, for outside reconciliation,
When the order status for having a bank side is successful recharging, and we supplements with money unsuccessfully, i.e., bank side has settled accounts corresponding order more
The amount of money gives us, then for us, this order is our surplus order.Conversely, when the order shape for having a bank side
State is supplements unsuccessfully with money, and our successful recharging, i.e., bank side has settled accounts the amount of money of corresponding order to us less, then is our shortage of money
Order.Generally, correspondence markings are carried out just for the order related to payment platform, and it is pair incoherent with payment platform
Order, then marks such as " variant " only can be simply used to mark.After having identified, expired difference bill can be stored to difference and converged
In summary table, the expired difference bill stored in difference bill table is then deleted in difference bill table.
Difference bill table can regard a temporary transient cache table as, simply play a part of of short duration storage.Therefore store
Difference bill into difference bill table can all have a storage period, after having served as storage period, will timing to transfiniting
Difference bill is cleared up, and ensures have space to be used to store newest caused difference bill in difference bill table with this.
In one embodiment, the method for above-mentioned reconciliation clearance also includes：Do not carried out pair when being not present in data server
During the billing files of account, then the reconciliation clearance result for having carried out the bill that reconciliation finishes is obtained；It is literary according to reconciliation bill is carried out
The file name of part determines type of transaction corresponding to billing files, and the reconciliation clearance result of billing files is deposited according to type of transaction
Storage is into reconciliation summary sheet；Reconciliation summary sheet is sent to presumptive address.
When the billing files for not carrying out reconciliation are not present in data server, i.e. reconciliation server obtains from data server
When taking billing files, the bill less than new billing files, that is, in the preset time stored on data server is obtained
File is obtained by reconciliation server and finished.In this case, then obtain carried out the bill that reconciliation finishes reconciliation it is clear
Calculate result.Reconciliation clearance result is the result of multiple billing files, can be by carrying out the bill of reconciliation in order to more intuitively inspect
The file name of file determines the type of transaction belonging to the billing files, stores pair of billing files respectively further according to type of transaction
Account clears result, stores in most reconciliation summary sheet, briefly, i.e., the reconciliation of billing files is cleared into result according to transaction class
Type classification storage is into reconciliation summary sheet.The reconciliation summary sheet is sent to presumptive address again, generally, presumptive address is
Predetermined email address.Send to predetermined address, automatically can push away summarized results after Classifying Sum is carried out to reconciliation result
Send, allow related personnel to view reconciliation result in time, Classifying Sum is also allowed for consulting the difference status between each platform, made
Processing that must be to reconciliation result is more convenient.
In one embodiment, after carrying out reconciliation clearance to the billing files of matching according to reconciliation rule, in addition to：When
Detect when there are the billing files for not carrying out reconciliation in data server, then obtained again by data server and do not carry out reconciliation
Billing files, then the billing files got are passed through into corresponding predetermined reconciliation rule and carry out reconciliation clearance.
Reconciliation server from data server obtain billing files when, be not a performance by reconciliation in need text
Part is obtained and finished, and is finished because the billing files that channel or some branch company are there may be on data server do not obtain,
Can so cause the billing files stored on data server be constantly renewal and it is increased.Therefore, reconciliation service each time
All it is probably fetching portion billing files when device obtains billing files from data server.Therefore when detecting data server
In when having the billing files for not carrying out reconciliation, the billing files that do not carry out reconciliation will be obtained again by data server, and
The billing files got are subjected to reconciliation clearance by corresponding predetermined reconciliation rule again.The principle of " being not to wait for ", but obtain
Get the billing files which billing files is just got to this part and carry out reconciliation clearance, save the stand-by period, improve
Operating efficiency.
In one embodiment, as shown in Figure 4, there is provided a kind of method of reconciliation clearance, this method is with applied to such as Fig. 1
Shown in reconciliation server in be illustrated.Including：
Step 402, the billing files in the range of the scheduled time are obtained from data server.
Generally, reconciliation server regularly can obtain the billing files in preset time range from data server,
Preset time range is usually 24 hours, i.e., intraday billing files.As shown in figure 5, the bill stored on data server
Document source in operation system or third party's channel, can be data server active obtaining or operation system or
At least one in the modes such as third party's channel is actively called by HTTP, FTP is pushed, FTP is pulled, is uploaded under mail push and line
Kind.Specifically, the billing files for the operation system that data server is got derive from each point of public affairs included in operation system
Branch company's operation system of department.For example, branch company's operation system of 3 branch companies, respectively A are included in operation system
Company, B companies, C companies, under the operation system of company A respectively again include transaction platform, account platform, product platform with
And payment platform, B companies and C companies are also in this way, can also include multiple platforms under each branch company.Third party's canal
Road, can be fast money, repeatedly, Shanghai Unionpay, middle gold, it is precious pay, the channel such as rich pair and wechat.Obtaining operation system or third party
During the bill of channel, if because the networking problem or system problem of the billing server of third party's channel cause bill to obtain not
Completely, can support to reacquire, the consolidated bill until getting agreement, i.e. retry mechanism.
Data server can use SFTP servers, and the billing files of operation system or third party's channel are being uploaded to number
, can be first with AES encryption mode to file encryption before server, then upload onto the server.And the bill to upload onto the server
File can be parsed first again by uniform format, be TXT forms by billing files uniform format generally, be more convenient pipe
Reason, but the unified form of specific form can be depending on the exploitation demand of developer.
Reconciliation server after data server gets billing files, also can reconciliation monofile form carry out unification.
To add the certain content of unified form in the file content of each billing files, the content of addition is such as concrete mode：
Sequence number _ business numbering _ businessman's order number _ pay invoice number _ dealing money _ transaction deadline _ type of transaction _ stateful transaction
Deng, therefore the content of addition is corresponding addition in each billing files, the interior of addition perhaps has difference.
Step 404, in the billing files that get of prefixed time interval inquiry with the presence or absence of having and default reconciliation rule
The billing files of reconciliation rule match in table, if so, then performing step 406；If it is not, then perform step 402.
Step 406, reconciliation clearance is carried out to the billing files of matching according to reconciliation rule.
When reconciliation server obtains billing files from data server, what may be got only has branch company's A business
The billing files of transaction platform under system.Specifically, polytype is included in the transaction platform under branch company's A operation systems
Billing files, for example supplement with money, withdraw deposit, investing, transferring the possession of, returned money etc..The polytype billing files included in account platform
Also to supplement with money, withdrawing deposit, investing, transferring the possession of, returned money etc..Therefore, when reconciliation server obtains billing files from data server,
Class billing files are supplemented with money in transaction platform under the only branch company's A operation systems that may be got.
The reconciliation rule list being pre-configured with is stored with reconciliation server, has a plurality of reconciliation to advise in reconciliation rule list
Then, every reconciliation rule is corresponding with two billing files.Illustrated with branch company A, have in branch company A transaction platform, account platform,
Product platform and payment platform.Reconciliation mode inside branch company between each platform is as shown in fig. 6, wherein, be not only
Reconciliation be present between transaction platform and account platform, payment platform and transaction platform, product platform and transaction platform, for paying
For platform, it is also necessary to carry out reconciliation, that is, outside reconciliation with third party's channel.It is, therefore, understood that transaction platform with
Reconciliation mode between account platform, payment platform and transaction platform, product platform and transaction platform is internal reconciliation, and is paid
Reconciliation mode between platform and third party's channel is outside reconciliation.For branch company A, internal reconciliation is branch company A
Transaction platform and branch company A account platform, branch company A account platform and branch company A payment platform and branch company A
Product platform and branch company A transaction platform between reconciliation, and branch company A bill and need not be with other branch companies
Bill carries out reconciliation.
Therefore, when in automatic regular polling reconciliation rule list, be in fact reconciliation rule query in reconciliation rule list whether
There are the billing files with reconciliation rule match reconciliation, when two bills all inquire, then illustrate that this reconciliation rule can be entered
Row reconciliation.For example reconciliation rule is, class reconciliation is supplemented with money between branch company A account platform and transaction platform, then when looking into
Ask in the transaction platform for supplementing order and branch company A with money in branch company A account platform supplement order with money all in the presence of, then
Reconciliation clearance can be proceeded by the reconciliation rule for supplementing class reconciliation with money between branch company A account platform and transaction platform
Flow.If two billing files corresponding to reconciliation rule match are fully retrieved, reconciliation server can again from
Billing files are obtained in data server.
Further, a file acquisition record sheet on reconciliation server be present, for recording from data server
Obtain the record of billing files.For example at 3, reconciliation server has got branch company A payment from data server
Platform supplements class bill with money, then this record will be recorded in file acquisition record sheet.Therefore access can directly be passed through
File acquisition record sheet knows the specific acquisition situation of file.
Step 408, when discrepant bill be present during reconciliation clearance, then the billing files that have differences store to
In difference summary.
During reconciliation clearance, if discrepant bill be present, it can be taken according to the concrete condition of difference different
Processing mode.When difference is due to system day to cut phenomenon (day cuts phenomenon：For example using whole 0 point as cut-off, that is asked in the presence of one
Topic, local 23:59 transaction initiated, have arrived channel side, may be 00:01 processing, this transaction become the account of second day
Dan Liao.Just occur that the previous day is few one during reconciliation, one day after more one phenomenons) caused by, then reconciliation server
Difference list information in meeting automatically scanning preset time period, carries out flat account processing automatically.Generally, can be by preset time period
It is arranged to 10 days, can be specifically set according to the exploitation demand of developer.Flat account, such as, each former material in raw material account
The account balance of material, which is added, to collect, and equal with the raw material subject in general ledger, this is just flat account.If unequal, that will enter
Row searches reason, if is that evidence record is wrong, it is equal whether voucher is borrowed or lent money；Whether account book record is accurate；Voucher cover sheet is
No debt-credit misremembers the flat account processing of, is exactly adjusted mutually in the amount of money of each classification account and the amount of money of its summarizing account unequal
In the case of using accounting carry out account balance processing so that it is each classification account the amount of money and its summarizing account the amount of money it is mutual
Mutually adjust equal.
When the bill having differences is to belong to the billing files in payment platform, such as the class account of withdrawing deposit in payment platform
It is single, if there is any one situation in situations below, it will be generated according to the difference condition between the bill for carrying out reconciliation
Difference detail form：1st, payment platform success, in the processing of business side；2nd, payment platform success, the failure of business side；3rd, payment platform loses
Lose, the success of business side；4th, payment platform fails, in the processing of business side；5th, in paymate processes, the success of business side；6th, pay
In platform processes, the failure of business side.For payment platform, its play a part of it is more sensitive, therefore for payment platform
Difference status can carry out more detailed record, and other platforms when variant, can also be recorded, but be probably simple
It is recorded as variant etc..Specific design can be depending on the exploitation demand of developer.
Step 410, verify whether also to there are the billing files for not carrying out reconciliation, if it is not, then performing step 412；If so,
Then perform step 402.
Step 412, the reconciliation clearance result of billing files is stored into reconciliation summary sheet according to type of transaction.
The sequential of reconciliation clearance process is as shown in Figure 7.After the flow for completing reconciliation clearance every time, it can all verify whether
It also there are the billing files for not carrying out reconciliation.It can be inquired about according to file acquisition record sheet and whether also there are file in table
Record is not obtained.If so, then explanation also has file not get and carry out reconciliation clearance, then also needs to from data server
Billing files corresponding to upper acquisition, and carry out reconciliation clearance., can be by account if no, illustrating that billing files all obtain to finish
The reconciliation clearance result of monofile is stored into reconciliation summary sheet according to type of transaction, also can be according to third party's channel classification storage
Into corresponding reconciliation summary sheet.
Part billing files are got, with regard to first carrying out reconciliation clearance to the billing files of this part, without being to wait for owning
Billing files be all disposed.Therefore during reconciliation clearance, when finding variant bill, difference can be also got in time
Metachromatic state, it can be handled in time.
In one embodiment, the billing files stored in data server are from operation system and third party's canalization
It is obtaining or the push of operation system and third party's canalization active, and reconciliation monofile has been carried out at unified form
Reason.The billing files stored in data server have multiple data sources, such as the operation system of each branch company, third party's canal
Road etc..Billing files can be data server active obtaining, for example be obtained by forms such as http, ftp, sftp, email
Bill is actively pushed to data server by the operation system or third party's channel of billing files or each branch company
's.After server gets billing files, billing files can be carried out to unified format analysis processing.
The major way of unified form is the file that the billing files got are carried out with content addition and reconciliation monofile
Title carries out the name of specific format.It is specifically in the file of billing files to carry out content addition to the billing files got
The text of two row specific formats is added in appearance, the text of the two row specific formats added in the file content of billing files is specific
As follows, the text of the first row addition is：Mark (0 represents that file is normal) | information alert (can be sky) | content record number is (no
Include file 1,2 rows) | version number (current version, can subsequently change) according to system upgrade.The content of second row addition is field
Name information, is separated with " | " between each field name.And file content one record of often row increase (using r n as changing
Row symbol), every record includes multiple fields, and each field is separated with " | " and is not allow for newline and " | ", if it does, directly
Connect and " | " is regarded forbidden character and got rid of.
And the file name of reconciliation monofile carries out the name of specific format, form is：File prefix _ business numbering _ industry
Service type [withhold/pay out] _ date .txt.In addition, data server can use SFTP servers, billing files are stored to data, services
During device, first it can be encrypted using AES (Advanced Encryption Standard, Advanced Encryption Standard) encryption method,
And the coding of billing files uses UTF-8 forms.Unification and encryption to form, improve the normalization and peace of file storage
Quan Xing, therefore the management to file is also more convenient.
In one embodiment, as shown in figure 8, additionally providing a kind of device of reconciliation clearance, including：
Acquisition module 802, for obtaining the billing files in the range of the scheduled time from data server；
Enquiry module 804, for according in the billing files that get of prefixed time interval inquiry with the presence or absence of have with advance
If reconciliation rule list in reconciliation rule match billing files；
Module 806 is cleared in reconciliation, for there are according to the billing files that get of prefixed time interval inquiry with
During the billing files of the reconciliation rule match in default reconciliation rule list, then the billing files of matching are entered according to reconciliation rule
Row reconciliation is cleared；
Difference summarizing module 808, for when the billing files progress reconciliation clearance according to corresponding reconciliation rule to matching
When, if being had differences between billing files, there will be the billing files of difference to store into difference summary.
Enquiry module 804 is additionally operable to carry out uniform format processing to the billing files that get, and after obtaining unified form
Billing files title；Corresponding to billing files after determining unified form according to the title of the billing files after unified form
Type of transaction；With the presence or absence of type of transaction and the reconciliation rule in reconciliation rule list in billing files after the unified form of inquiry
The billing files matched somebody with somebody.
In one embodiment, reconciliation clearance module 806 is additionally operable to carrying out reconciliation according to reconciliation rule reconciliation monofile
It is pre- when meeting if the type of transaction for detecting billing files according to the title of billing files associates with payment platform during clearance
If when payment platform and the Bill Status of business side, then it is detailed difference to be generated according to the difference condition between the billing files of reconciliation
It is single.
In one embodiment, difference summarizing module 808 is additionally operable to that there will be the billing files of difference to store to difference account
In single table；If at least one bill does not find pair matched according to predetermined reconciliation rule with bill in corresponding billing files
Account bill, then search in difference bill table and whether there is the regular reconciliation bill matched with the bill of with good grounds predetermined reconciliation；
If so, the reconciliation bill in difference bill table and bill are then subjected to reconciliation clearance according to predetermined reconciliation rule；If it is not, work as basis
The file name for stating bill is detected when the type of transaction of bill is associated with payment platform, then is stored bill to the difference
In bill table.
In one embodiment, the device of above-mentioned reconciliation clearance also includes difference bill table read module, for according to pre-
If time interval reads difference bill table；Difference bill table detection module, the difference stored in difference bill table is detected for working as
, then will be detailed according to difference more than the corresponding difference account individual palpation of preset time threshold when different bill be there are more than preset time threshold
It is marked, and the difference bill more than preset time threshold stored in difference bill table is stored into difference summary；
Removing module, for deleting the difference bill more than preset time threshold stored in difference bill table in difference bill table.
In one embodiment, the device of above-mentioned reconciliation clearance also includes reconciliation clearance result acquisition module, for when number
During according to the billing files for not carrying out reconciliation being not present in server, then the reconciliation clearance for having carried out the bill that reconciliation finishes is obtained
As a result；Sort module, for according to carry out reconciliation billing files file name determine billing files corresponding to type of transaction, will
The reconciliation clearance result of billing files is stored into reconciliation summary sheet according to type of transaction；Reconciliation summary sheet sending module, is used for
Reconciliation summary sheet is sent to presumptive address.
In one embodiment, after carrying out reconciliation clearance to the billing files of matching according to reconciliation rule, in addition to：When
Detect when there are the billing files for not carrying out reconciliation in data server, then obtained again by data server and do not carry out reconciliation
Billing files, then the billing files got are passed through into corresponding predetermined reconciliation rule and carry out reconciliation clearance.
Fig. 9 is the internal structure schematic diagram of one embodiment Computer equipment.The computer equipment can be as in Fig. 1
Reconciliation clearance server, reference picture 9, the computer equipment includes the processor by system bus connection, non-volatile deposits
Storage media, built-in storage and network interface.Wherein, the non-volatile memory medium of the computer equipment can storage program area and
The computer program of reconciliation clearance device is realized, when the computer program is performed, may be such that a kind of reconciliation of computing device is clear
The method of calculation.The processor of the computer equipment is used to provide calculating and control ability, supports the operation of whole computer equipment.
Computer program can be stored in the built-in storage, when the computer program is executed by processor, may be such that computing device pair
The method of account clearance.The network interface of computer equipment is used to carry out network service, such as receives the bill text of data server
Part.
It will be understood by those skilled in the art that the structure shown in Fig. 9, the only part related to the present invention program knot
The block diagram of structure, does not form the restriction for the terminal being applied thereon to the present invention program, and specific terminal can be included than figure
Shown in more or less parts, either combine some parts or arranged with different parts.
In one embodiment, comprise the following steps during above-mentioned computing device above computer program：From data, services
Device obtains the billing files in the range of the scheduled time；It whether there is in the billing files got according to prefixed time interval inquiry
There are the billing files with the reconciliation rule match in default reconciliation rule list, if so, the then account according to reconciliation rule to matching
Monofile carries out reconciliation clearance；When carrying out reconciliation clearance to the billing files of matching according to corresponding reconciliation rule, if bill
Had differences between file, then there will be the billing files of difference to store into difference summary.
In one embodiment, a kind of computer-readable recording medium is additionally provided, is stored thereon with computer program, is counted
Calculation machine program realizes following steps when being executed by processor：The billing files in the range of the scheduled time are obtained from data server；
The reconciliation that whether there is in the billing files got according to prefixed time interval inquiry has and in default reconciliation rule list is advised
The billing files then matched, if so, then carrying out reconciliation clearance to the billing files of matching according to reconciliation rule；When according to corresponding
When reconciliation rule carries out reconciliation clearance to the billing files of matching, if being had differences between billing files, there will be difference
Billing files are stored into difference summary.
In one embodiment, computer program is executed by processor the bill got according to prefixed time interval inquiry
When in file with the presence or absence of there is the step with the billing files of the reconciliation rule match in default reconciliation rule list, including：It is right
The billing files got carry out uniform format processing, and obtain the title of the billing files after unified form；According to unified lattice
Type of transaction corresponding to billing files after the unified form of title determination of billing files after formula；Account after the unified form of inquiry
With the presence or absence of the billing files of type of transaction and the reconciliation rule match in reconciliation rule list in monofile.
In one embodiment, computer program is executed by processor has corresponding to reconciliation rule when in predetermined reconciliation rule
For billing files when the match is successful, then by corresponding billing files, the predetermined reconciliation rule corresponding to carries out the step of reconciliation clearance
When rapid, including：When carrying out reconciliation clearance according to reconciliation rule reconciliation monofile, if detecting account according to the title of billing files
The type of transaction of monofile associates with payment platform, then when meeting the Bill Status of default payment platform and business side, then root
Difference detail form is generated according to the difference condition between the billing files of reconciliation.
In one embodiment, computer program is executed by processor the difference feelings between the billing files according to reconciliation
After condition generates the step of difference detail form, in addition to：There will be the billing files of difference to store into difference bill table；It is if right
At least one bill does not find the reconciliation bill matched according to predetermined reconciliation rule with bill in the billing files answered, then looks into
Look for the reconciliation bill matched in difference bill table with the presence or absence of with good grounds predetermined reconciliation rule with bill；If so, then by difference account
Reconciliation bill in single table carries out reconciliation clearance with bill according to predetermined reconciliation rule；If it is not, when the file name according to bill
Detect when the type of transaction of bill is associated with payment platform, then store bill into the difference bill table.
In one embodiment, following steps are also performed when computer program is executed by processor：According between preset time
Every reading difference bill table；When detecting that the difference bill stored in difference bill table there are more than preset time threshold,
Then the corresponding difference account individual palpation more than preset time threshold is marked according to difference detail, and will be stored in difference bill table
Difference bill more than preset time threshold is stored into difference summary；Delete in difference bill table and deposited in difference bill table
The difference bill more than preset time threshold of storage.
In one embodiment, following steps are also performed when computer program is executed by processor：When in data server
During in the absence of the billing files for not carrying out reconciliation, then the reconciliation clearance result for having carried out the bill that reconciliation finishes is obtained；According to
The file name for carrying out reconciliation billing files determines type of transaction corresponding to billing files, and the reconciliation of billing files is cleared into result
Stored according to type of transaction into reconciliation summary sheet；Reconciliation summary sheet is sent to presumptive address.
In one embodiment, computer program is executed by processor is carried out according to reconciliation rule to the billing files of matching
After the step of reconciliation is cleared, in addition to：When detect have the billing files for not carrying out reconciliation in data server when, then again
The billing files for not carrying out reconciliation are obtained by data server, then the billing files got are passed through into corresponding predetermined reconciliation
Rule carries out reconciliation clearance.
One of ordinary skill in the art will appreciate that realize all or part of flow in above-described embodiment method, being can be with
The hardware of correlation is instructed to complete by computer program, it is non-volatile computer-readable that described program can be stored in one
Take in storage medium, in the embodiment of the present invention, the program can be stored in the non-volatile memory medium of computer system, and
By at least one computing device in the computer system, to realize the flow for including the embodiment such as above-mentioned each method.Its
In, described storage medium can be magnetic disc, CD, read-only memory (Read-Only Memory, ROM) or random storage
Memory body (Random Access Memory, RAM) etc..
Each technical characteristic of embodiment described above can be combined arbitrarily, to make description succinct, not to above-mentioned reality
Apply all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, the scope that this specification is recorded all is considered to be.
Embodiment described above only expresses the several embodiments of the present invention, and its description is more specific and detailed, but simultaneously
Can not therefore it be construed as limiting the scope of the patent.It should be pointed out that come for one of ordinary skill in the art
Say, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to the protection of the present invention
Scope.Therefore, the protection domain of patent of the present invention should be determined by the appended claims.
Claims (10)
1. a kind of method of reconciliation clearance, methods described include：
The billing files in the range of the scheduled time are obtained from data server；
Whether there is in the billing files got according to prefixed time interval inquiry has and pair in default reconciliation rule list
The billing files of account rule match, if so, then
Reconciliation clearance is carried out to the billing files of matching according to the reconciliation rule；
When carrying out reconciliation clearance to the billing files of matching according to corresponding reconciliation rule, if between the billing files
Have differences, then there will be the billing files of difference to store into difference summary.
2. according to the method for claim 1, it is characterised in that the bill got according to prefixed time interval inquiry
With the presence or absence of the billing files having with the reconciliation rule match in default reconciliation rule list in file, including：
Uniform format processing is carried out to the billing files got, and obtains the title of the billing files after unified form；
Type of transaction corresponding to billing files after determining the unified form according to the title of the billing files after unified form；
Inquire about in the billing files after the unified form with the presence or absence of type of transaction and the reconciliation rule in reconciliation rule list
The billing files matched somebody with somebody.
3. according to the method for claim 2, it is characterised in that described to have when in predetermined reconciliation rule corresponding to reconciliation rule
Billing files are when the match is successful, then will it is described corresponding to billing files predetermined reconciliation rule progress reconciliation according to corresponding to it is clear
Calculate, including：
When carrying out reconciliation clearance according to reconciliation rule reconciliation monofile, if according to detecting the title of the billing files
The type of transaction of billing files associates with payment platform, then when meeting the Bill Status of default payment platform and business side, then
Difference detail form is generated according to the difference condition between the billing files of the reconciliation.
4. according to the method for claim 3, it is characterised in that the difference condition life between the billing files according to reconciliation
Into after difference detail form, in addition to：
There will be the billing files of difference to store into difference bill table；
If corresponding to described in billing files at least one bill do not find it is regular with the bill according to predetermined reconciliation
The reconciliation bill matched somebody with somebody, then search in the difference bill table and matched with the presence or absence of with good grounds predetermined reconciliation is regular with the bill
Reconciliation bill；
If so, it is clear that the reconciliation bill in the difference bill table then is carried out into reconciliation according to predetermined reconciliation rule with the bill
Calculate；
If it is not, when detected according to the file name of the bill type of transaction of the bill is associated with payment platform when,
Then the bill is stored into the difference bill table.
5. according to the method for claim 4, it is characterised in that methods described also includes：
The difference bill table is read according to prefixed time interval；
, then will be described super when detecting that the difference bill stored in the difference bill table there are more than preset time threshold
The corresponding difference account individual palpation for crossing preset time threshold is marked according to difference detail, and super by what is stored in the difference bill table
The difference bill for crossing preset time threshold is stored into difference summary；
The difference bill more than preset time threshold stored in the difference bill table is deleted in the difference bill table.
6. according to the method for claim 1, it is characterised in that methods described also includes：
When the billing files for not carrying out reconciliation are not present in the data server, then obtain and carried out the account that reconciliation finishes
Single reconciliation clearance result；
The type of transaction according to corresponding to the file name of progress reconciliation billing files determines billing files, by the reconciliation of billing files
Clearance result is stored into reconciliation summary sheet according to the type of transaction；
The reconciliation summary sheet is sent to presumptive address.
7. according to the method for claim 1, it is characterised in that the billing files according to the reconciliation rule to matching
After carrying out reconciliation clearance, in addition to：
When detect have the billing files for not carrying out reconciliation in data server when, then again by data server obtain do not enter
The billing files of row reconciliation, then the billing files got are subjected to reconciliation clearance by corresponding predetermined reconciliation rule.
8. a kind of device of reconciliation clearance, it is characterised in that described device includes：
Acquisition module, for obtaining the billing files in the range of the scheduled time from data server；
Enquiry module, have and default reconciliation for inquiring about to whether there is in the billing files got according to prefixed time interval
The billing files of reconciliation rule match in rule list；
Module is cleared in reconciliation, for there are according to the billing files that get of prefixed time interval inquiry with it is default right
During the billing files of the reconciliation rule match in account rule list, then the billing files of matching are carried out according to the reconciliation rule pair
Account is cleared；
Difference summarizing module, for when carrying out reconciliation clearance to the billing files of matching according to corresponding reconciliation rule,
If being had differences between the billing files, there will be the billing files of difference to store into difference summary.
9. a kind of computer equipment, including memory, processor and storage are on a memory and the meter that can run on a processor
Calculation machine program, it is characterised in that realize that reconciliation described in claim 1-7 any one is clear during the computing device described program
The step of method of calculation.
10. a kind of computer-readable recording medium, is stored thereon with computer program, it is characterised in that described program is processed
Device realizes the step of method that reconciliation described in claim 1-7 any one is cleared when performing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711058246.4A CN107798109A (en) | 2017-11-01 | 2017-11-01 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711058246.4A CN107798109A (en) | 2017-11-01 | 2017-11-01 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107798109A true CN107798109A (en) | 2018-03-13 |
Family
ID=61548331
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711058246.4A Pending CN107798109A (en) | 2017-11-01 | 2017-11-01 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107798109A (en) |
Cited By (32)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108765152A (en) * | 2018-05-22 | 2018-11-06 | 中国建设银行股份有限公司 | A kind of generation method and device of acceptance instruction |
| CN108805685A (en) * | 2018-04-23 | 2018-11-13 | 顺丰科技有限公司 | Barcode scanning account checking method, barcode scanning reconciliation system, client terminal and server |
| CN109166042A (en) * | 2018-09-03 | 2019-01-08 | 平安科技（深圳）有限公司 | Node device, real-time account checking method and storage medium based on block chain |
| CN109299918A (en) * | 2018-09-26 | 2019-02-01 | 平安科技（深圳）有限公司 | Financial data checking method, device, computer equipment and storage medium |
| CN109670949A (en) * | 2018-09-27 | 2019-04-23 | 深圳壹账通智能科技有限公司 | Exchange settlement method, apparatus, equipment and storage medium |
| CN109684347A (en) * | 2018-11-27 | 2019-04-26 | 平安科技（深圳）有限公司 | Account checking method, device, computer equipment and storage medium |
| CN109739934A (en) * | 2019-01-08 | 2019-05-10 | 厦门投融汇网络有限公司 | Difference set account checking method, medium, computer equipment and system |
| CN109741159A (en) * | 2018-05-14 | 2019-05-10 | 网联清算有限公司 | Clear account checking method, device and computer equipment |
| CN110046877A (en) * | 2018-11-30 | 2019-07-23 | 阿里巴巴集团控股有限公司 | Account checking method and device, server |
| CN110175165A (en) * | 2019-04-16 | 2019-08-27 | 平安普惠企业管理有限公司 | Transaction account checking method, device, computer equipment and storage medium |
| CN110189219A (en) * | 2019-05-05 | 2019-08-30 | 中国银行股份有限公司 | A kind of account checking method and device based on parameter preprocessing |
| CN110287200A (en) * | 2019-07-02 | 2019-09-27 | 江苏满运软件科技有限公司 | Account checking method, system, computer equipment and storage medium |
| CN110428240A (en) * | 2019-07-30 | 2019-11-08 | 中国工商银行股份有限公司 | The suspicious transaction automatic identification of one kind and processing method, terminal and server |
| CN110427424A (en) * | 2019-07-09 | 2019-11-08 | 深圳壹账通智能科技有限公司 | Business datum checking method, device, computer equipment and storage medium |
| CN110443690A (en) * | 2019-08-15 | 2019-11-12 | 深圳乐信软件技术有限公司 | A kind of method, apparatus, server and the storage medium of variance data reconciliation |
| CN110458681A (en) * | 2019-08-15 | 2019-11-15 | 深圳乐信软件技术有限公司 | A kind of method, apparatus, server and the storage medium of data reconciliation decision |
| CN110555698A (en) * | 2019-07-25 | 2019-12-10 | 深圳壹账通智能科技有限公司 | data processing method, data processing device, computer equipment and storage medium |
| CN110598007A (en) * | 2019-09-09 | 2019-12-20 | 腾讯科技（深圳）有限公司 | Bill file processing method, device, medium and electronic equipment |
| CN110659308A (en) * | 2019-09-24 | 2020-01-07 | 华润网络(深圳)有限公司 | Data clearing processing method and device |
| CN110738477A (en) * | 2019-08-22 | 2020-01-31 | 威富通科技有限公司 | reconciliation method, device, computer equipment and storage medium |
| CN111192147A (en) * | 2020-04-10 | 2020-05-22 | 支付宝(杭州)信息技术有限公司 | Block chain-based fund checking method and device, electronic equipment and medium |
| CN111598683A (en) * | 2020-05-18 | 2020-08-28 | 中国邮政储蓄银行股份有限公司 | Data processing method and device |
| CN111784318A (en) * | 2020-06-29 | 2020-10-16 | 京东数字科技控股有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN111833058A (en) * | 2020-07-01 | 2020-10-27 | 中国建设银行股份有限公司 | Payment management method and device |
| CN111833161A (en) * | 2019-03-29 | 2020-10-27 | 阿里巴巴集团控股有限公司 | Inventory reconciliation method, device and storage medium |
| CN111833164A (en) * | 2020-05-27 | 2020-10-27 | 福建亿能达信息技术股份有限公司 | Accounts payable checking system for hospital and supplier |
| CN111861530A (en) * | 2019-11-19 | 2020-10-30 | 北京嘀嘀无限科技发展有限公司 | Order data processing method and device, electronic equipment and readable storage medium |
| CN112037003A (en) * | 2020-09-17 | 2020-12-04 | 中国银行股份有限公司 | File account checking processing method and device |
| CN113254457A (en) * | 2021-07-01 | 2021-08-13 | 中邮消费金融有限公司 | Account checking method, account checking system and computer readable storage medium |
| CN113554440A (en) * | 2021-09-18 | 2021-10-26 | 深圳市深圳通有限公司 | Data reconciliation method, device, equipment and storage medium |
| CN113781190A (en) * | 2021-01-13 | 2021-12-10 | 北京沃东天骏信息技术有限公司 | Bill data processing method, system, computer system and medium |
| CN114140225A (en) * | 2021-12-03 | 2022-03-04 | 北京中亦安图科技股份有限公司 | Expense data processing method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
| US20140372296A1 (en) * | 2013-06-14 | 2014-12-18 | Bank Of America Corporation | Digital image shifting |
| CN105574762A (en) * | 2015-12-14 | 2016-05-11 | 重庆城银科技有限公司 | Account check method and system |
| CN105787109A (en) * | 2016-03-22 | 2016-07-20 | 农信银资金清算中心有限责任公司 | Account checking method and device of payment and clearing system |
| CN106327317A (en) * | 2015-06-16 | 2017-01-11 | 阿里巴巴集团控股有限公司 | Data verification method and device used for computer system |
| CN106408410A (en) * | 2016-11-29 | 2017-02-15 | 用友网络科技股份有限公司 | Automatic account checking method and device |
-
2017
- 2017-11-01 CN CN201711058246.4A patent/CN107798109A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
| US20140372296A1 (en) * | 2013-06-14 | 2014-12-18 | Bank Of America Corporation | Digital image shifting |
| CN106327317A (en) * | 2015-06-16 | 2017-01-11 | 阿里巴巴集团控股有限公司 | Data verification method and device used for computer system |
| CN105574762A (en) * | 2015-12-14 | 2016-05-11 | 重庆城银科技有限公司 | Account check method and system |
| CN105787109A (en) * | 2016-03-22 | 2016-07-20 | 农信银资金清算中心有限责任公司 | Account checking method and device of payment and clearing system |
| CN106408410A (en) * | 2016-11-29 | 2017-02-15 | 用友网络科技股份有限公司 | Automatic account checking method and device |
Cited By (44)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108805685A (en) * | 2018-04-23 | 2018-11-13 | 顺丰科技有限公司 | Barcode scanning account checking method, barcode scanning reconciliation system, client terminal and server |
| CN112215691A (en) * | 2018-05-14 | 2021-01-12 | 网联清算有限公司 | Clearing and reconciliation method and device and computer equipment |
| CN109741159A (en) * | 2018-05-14 | 2019-05-10 | 网联清算有限公司 | Clear account checking method, device and computer equipment |
| CN108765152A (en) * | 2018-05-22 | 2018-11-06 | 中国建设银行股份有限公司 | A kind of generation method and device of acceptance instruction |
| CN108765152B (en) * | 2018-05-22 | 2022-07-12 | 中国建设银行股份有限公司 | Method and device for generating delivery instruction |
| CN109166042A (en) * | 2018-09-03 | 2019-01-08 | 平安科技（深圳）有限公司 | Node device, real-time account checking method and storage medium based on block chain |
| CN109299918A (en) * | 2018-09-26 | 2019-02-01 | 平安科技（深圳）有限公司 | Financial data checking method, device, computer equipment and storage medium |
| CN109670949A (en) * | 2018-09-27 | 2019-04-23 | 深圳壹账通智能科技有限公司 | Exchange settlement method, apparatus, equipment and storage medium |
| CN109684347B (en) * | 2018-11-27 | 2024-04-09 | 平安科技（深圳）有限公司 | Account checking method, account checking device, computer equipment and storage medium |
| CN109684347A (en) * | 2018-11-27 | 2019-04-26 | 平安科技（深圳）有限公司 | Account checking method, device, computer equipment and storage medium |
| CN110046877A (en) * | 2018-11-30 | 2019-07-23 | 阿里巴巴集团控股有限公司 | Account checking method and device, server |
| CN110046877B (en) * | 2018-11-30 | 2023-09-29 | 创新先进技术有限公司 | Account checking method and device and server |
| CN109739934A (en) * | 2019-01-08 | 2019-05-10 | 厦门投融汇网络有限公司 | Difference set account checking method, medium, computer equipment and system |
| CN111833161A (en) * | 2019-03-29 | 2020-10-27 | 阿里巴巴集团控股有限公司 | Inventory reconciliation method, device and storage medium |
| CN110175165A (en) * | 2019-04-16 | 2019-08-27 | 平安普惠企业管理有限公司 | Transaction account checking method, device, computer equipment and storage medium |
| CN110189219A (en) * | 2019-05-05 | 2019-08-30 | 中国银行股份有限公司 | A kind of account checking method and device based on parameter preprocessing |
| CN110189219B (en) * | 2019-05-05 | 2022-02-01 | 中国银行股份有限公司 | Account checking method and device based on parameter preprocessing |
| CN110287200A (en) * | 2019-07-02 | 2019-09-27 | 江苏满运软件科技有限公司 | Account checking method, system, computer equipment and storage medium |
| CN110287200B (en) * | 2019-07-02 | 2022-03-25 | 贵阳货车帮科技有限公司 | Account checking method, account checking system, computer equipment and storage medium |
| CN110427424A (en) * | 2019-07-09 | 2019-11-08 | 深圳壹账通智能科技有限公司 | Business datum checking method, device, computer equipment and storage medium |
| CN110555698A (en) * | 2019-07-25 | 2019-12-10 | 深圳壹账通智能科技有限公司 | data processing method, data processing device, computer equipment and storage medium |
| CN110428240A (en) * | 2019-07-30 | 2019-11-08 | 中国工商银行股份有限公司 | The suspicious transaction automatic identification of one kind and processing method, terminal and server |
| CN110428240B (en) * | 2019-07-30 | 2022-11-04 | 中国工商银行股份有限公司 | Automatic suspicious transaction identification and processing method, terminal and server |
| CN110443690A (en) * | 2019-08-15 | 2019-11-12 | 深圳乐信软件技术有限公司 | A kind of method, apparatus, server and the storage medium of variance data reconciliation |
| CN110458681B (en) * | 2019-08-15 | 2022-06-24 | 深圳乐信软件技术有限公司 | Data reconciliation decision method, device, server and storage medium |
| CN110458681A (en) * | 2019-08-15 | 2019-11-15 | 深圳乐信软件技术有限公司 | A kind of method, apparatus, server and the storage medium of data reconciliation decision |
| CN110738477A (en) * | 2019-08-22 | 2020-01-31 | 威富通科技有限公司 | reconciliation method, device, computer equipment and storage medium |
| CN110598007A (en) * | 2019-09-09 | 2019-12-20 | 腾讯科技（深圳）有限公司 | Bill file processing method, device, medium and electronic equipment |
| CN110598007B (en) * | 2019-09-09 | 2023-10-27 | 腾讯科技（深圳）有限公司 | Bill file processing method, device, medium and electronic equipment |
| CN110659308A (en) * | 2019-09-24 | 2020-01-07 | 华润网络(深圳)有限公司 | Data clearing processing method and device |
| CN111861530A (en) * | 2019-11-19 | 2020-10-30 | 北京嘀嘀无限科技发展有限公司 | Order data processing method and device, electronic equipment and readable storage medium |
| CN111192147A (en) * | 2020-04-10 | 2020-05-22 | 支付宝(杭州)信息技术有限公司 | Block chain-based fund checking method and device, electronic equipment and medium |
| CN111598683B (en) * | 2020-05-18 | 2023-10-27 | 中国邮政储蓄银行股份有限公司 | Data processing method and device |
| CN111598683A (en) * | 2020-05-18 | 2020-08-28 | 中国邮政储蓄银行股份有限公司 | Data processing method and device |
| CN111833164A (en) * | 2020-05-27 | 2020-10-27 | 福建亿能达信息技术股份有限公司 | Accounts payable checking system for hospital and supplier |
| CN111784318A (en) * | 2020-06-29 | 2020-10-16 | 京东数字科技控股有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN111784318B (en) * | 2020-06-29 | 2024-07-19 | 京东科技控股股份有限公司 | Data processing method, device, electronic equipment and storage medium |
| CN111833058A (en) * | 2020-07-01 | 2020-10-27 | 中国建设银行股份有限公司 | Payment management method and device |
| CN112037003A (en) * | 2020-09-17 | 2020-12-04 | 中国银行股份有限公司 | File account checking processing method and device |
| CN113781190A (en) * | 2021-01-13 | 2021-12-10 | 北京沃东天骏信息技术有限公司 | Bill data processing method, system, computer system and medium |
| CN113254457B (en) * | 2021-07-01 | 2021-11-12 | 中邮消费金融有限公司 | Account checking method, account checking system and computer readable storage medium |
| CN113254457A (en) * | 2021-07-01 | 2021-08-13 | 中邮消费金融有限公司 | Account checking method, account checking system and computer readable storage medium |
| CN113554440A (en) * | 2021-09-18 | 2021-10-26 | 深圳市深圳通有限公司 | Data reconciliation method, device, equipment and storage medium |
| CN114140225A (en) * | 2021-12-03 | 2022-03-04 | 北京中亦安图科技股份有限公司 | Expense data processing method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107798109A (en) | Method, apparatus, computer equipment and the storage medium of reconciliation clearance | |
| CA2683600C (en) | A system and method for creating a list of shared information on a peer-to-peer network | |
| CN103744949B (en) | data integrating method and system | |
| CN102254238B (en) | Scalable record keeping with the deduplication in collector | |
| WO1998040804A3 (en) | Distributed relational database | |
| US8112337B2 (en) | Method and system for clearing financial instruments | |
| CN106453061A (en) | Method and system for recognizing internet fraud behavior | |
| US20080167001A1 (en) | Open Virtual Secure Crosscheck-Link Communication Channel | |
| CN102685018A (en) | Method and system for processing network instant messaging message and instant massaging equipment | |
| CN105976195A (en) | Method and device for recommendation of shared accommodation information | |
| CN109144946A (en) | A kind of document handling method and device | |
| CN108989063B (en) | Group account data processing method, device and equipment and readable storage medium | |
| CN100587740C (en) | Tax-control data declaration, checking treatment method of network tax-control system | |
| CN109918471A (en) | Archive method, apparatus, computer equipment and storage medium | |
| US20210073752A1 (en) | Method, device and program for managing proofs of purchase | |
| CN102521713B (en) | Data processing equipment and data processing method | |
| CN106033438A (en) | Public sentiment data storage method and server | |
| US11907391B2 (en) | Method for performing segmenting locking and merging control of encrypted digital assets based on time dimension | |
| CN109710623A (en) | A kind of intelligence order synchronous method | |
| CN116128668B (en) | Method, system and computer storage medium for matching bank certificate subjects | |
| CN107424005A (en) | A kind of intelligent payment method based on different trade companies | |
| CN106255078A (en) | Collecting method based on note and data collecting system | |
| CN109359965A (en) | A kind of transfer charge method of payment and system | |
| CN108711073A (en) | Customer analysis method, apparatus and terminal | |
| CN110197074B (en) | User authority control method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180313 |
|
| RJ01 | Rejection of invention patent application after publication |