CN110276672A - A kind of account checking method, device, equipment and computer readable storage medium - Google Patents
A kind of account checking method, device, equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN110276672A CN110276672A CN201910435483.0A CN201910435483A CN110276672A CN 110276672 A CN110276672 A CN 110276672A CN 201910435483 A CN201910435483 A CN 201910435483A CN 110276672 A CN110276672 A CN 110276672A
- Authority
- CN
- China
- Prior art keywords
- record sheet
- account
- account record
- money
- amount
- 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a kind of account checking method, device, equipment and computer readable storage mediums, wherein account checking method includes: to obtain the first account record sheet, the second account record sheet and third account record sheet and pre-processed, first account record sheet is matched with the field value of the first preset field in the second account record sheet, and the corresponding data sample of the field value of successful match is removed；A plurality of data sample is filtered out in remaining first account record sheet, the amount of money of a plurality of data sample is added, the amount of money after being recombinated；The amount of money amount of money corresponding with the data sample filtered out in third account record sheet after recombination is matched.Technical solution of the present invention, can complete the reconciliation operation of the first account record sheet and the second account record sheet and two account record sheets of third account record sheet during a reconciliation, and easy to operate and successful match rate is high.
Description
Technical field
The present invention relates to electric power data processing technology fields, and in particular to a kind of account checking method, device, equipment and computer
Readable storage medium storing program for executing.
Background technique
Utilities Electric Co. reconciliation person needs to take over company the information of the electricity charge and bank capital file carries out reconciliation work, currently
Reconciliation mode have following two: when 1. electric power mechanism business personnels carry out charge and pay in operation in sales service system,
Sales service system generates reconciliation mark, i.e. fund pay in record sheet.Fund is stored in company's electricity charge by electric power mechanism business personnel
When account, reconciliation mark is supplied to banking personnel, reconciliation is identified typing banking system by banking personnel.Next day,
The fund reconciliation file identified comprising reconciliation is supplied to sales service system by banking system, and sales service system is by fund pay in
Record sheet is not sold fund check list with the reconciliation of fund reconciliation file mark and is matched, and realizes automatic reconciliation.2. passing through generation
It receives, withhold, the electricity charge fund i.e. Internetbank flowing water that third party's charge, the modes such as automatic fee terminal recycle, by banking system, marketing
Operation system automatically generates reconciliation mark according to treaty rule, is matched in fund reconciliation, realizes automatic reconciliation.
In existing reconciliation mode, need by the fund pay in record sheet of power marketing operation system respectively with bank side
Do not sell fund check list and Internetbank flowing water is matched, cumbersome and matching efficiency is low.
Summary of the invention
In view of this, the embodiment of the invention provides a kind of account checking method, device, equipment and computer-readable storage mediums
Matter, to solve the problems, such as that existing account checking method is cumbersome and matching efficiency is low.
According in a first aspect, the embodiment of the invention provides a kind of account checking methods, comprising the following steps:
It obtains the first account record sheet, the second account record sheet and third account record sheet and is pre-processed, so that institute
State the field project at least portion stored in the first account record sheet, the second account record sheet and the third account record sheet
Split-phase is same；
The field value of first preset field in the first account record sheet and the second account record sheet is carried out
Matching, and the corresponding data sample of the field value of successful match is removed；
A plurality of data sample is filtered out in remaining first account record sheet, by the amount of money phase of a plurality of data sample
Add, the amount of money after being recombinated；
The amount of money amount of money corresponding with the data sample filtered out in third account record sheet after the recombination is carried out
Matching.
The account checking method that first aspect of the embodiment of the present invention provides can complete the first account note during a reconciliation
The reconciliation operation of two account record sheets of table and the second account record sheet and third account record sheet is recorded, it is easy to operate；Exist simultaneously
Before first account record sheet is matched with third account record sheet, the number of successful match is eliminated in the first account record sheet
According to sample, and by data sample a plurality of in the first account record sheet recombination after the amount of money and third account record sheet in the amount of money
It is matched, so that the successful match rate of the first account record sheet and third account record sheet is higher.
With reference to first aspect, in first aspect first embodiment, first preset field includes one in lower
Or two: reconciliation number and the amount of money；And/or first preset field includes one or several in following: pay in personnel, silver
Row account, Bank Account Number and the amount of money.
With reference to first aspect, it in first aspect second embodiment, is filtered out in remaining first account record sheet
A plurality of data sample includes:
Filtered out in remaining first account record sheet the second preset field field value include POS machine separate type and
The Embedded data sample of POS machine；Wherein the second preset field is clearing form；
Postsearch screening is carried out in the data sample filtered out, the field value for obtaining third preset field is identical a plurality of
Data sample；Third preset field includes one or several in following: power supply bureau's unit number, time, Bank Account Number.
Second embodiment with reference to first aspect, in first aspect third embodiment, by the gold after the recombination
Before the volume amount of money corresponding with the data sample filtered out in third account record sheet is matched further include:
The field value that the 4th preset field is filtered out in third account record sheet includes the data sample of POS machine consumption
This；Wherein, the 4th preset field is reciprocal account name.
With reference to first aspect, in the 4th embodiment of first aspect, by the amount of money after the recombination and in third account
After the corresponding amount of money of the data sample filtered out in program recording table is matched, further includes:
The amount of money amount of money corresponding with the data sample filtered out in the third account record sheet the after recombination
When identical, the corresponding a plurality of data sample of the amount of money after determining the recombination with filtered out in the third account record sheet
Data sample successful match, and the data sample of successful match is removed；
The identical a plurality of data sample of field value of the 5th preset field in remaining first account record sheet is filtered out, it will
The amount of money of a plurality of data sample is added, the data sample after obtaining the first recombination, wherein the 5th preset field includes reconciliation
Number, and it is following in one or several: pay in personnel, time；
The field of data sample after first recombination and the 6th preset field in the second account record sheet is taken
Value is matched, wherein the 6th preset field includes reconciliation number and the amount of money.
With reference to first aspect and first aspect first embodiment is into the 4th embodiment, implements in first aspect the 5th
In mode, account checking method is further comprising the steps of:
According to the identical principle of the corresponding field value of the 7th preset field, by the field in the third account record sheet
Value is associated with the field value in the second account record sheet, bank's side data after being associated with, wherein the 7th
Preset field includes one or several in following: time, the amount of money and remarks.
5th embodiment with reference to first aspect, in first aspect sixth embodiment, by the gold after the recombination
After the volume amount of money corresponding with the data sample filtered out in third account record sheet is matched, further includes:
The amount of money amount of money corresponding with the data sample filtered out in the third account record sheet the after recombination
When identical, the corresponding a plurality of data sample of the amount of money after determining the recombination with filtered out in the third account record sheet
Data sample successful match, and the data sample of successful match is removed；
According to the identical principle of the corresponding field value of the 8th preset field, sieved in bank's side data after association
Choosing, and the amount of money of the pieces of data sample after screening is added, the data sample after obtaining the second recombination；Wherein the described 8th is pre-
If field includes reconciliation number, and it is following in one or several: reciprocal account name, other side's account, bank account, bank's account
Family, time；
The field of data sample after second recombination and the 9th preset field in the first account record sheet is taken
Value is matched, wherein the 9th preset field includes reconciliation number and the amount of money.
With reference to first aspect and first aspect first embodiment is into sixth embodiment, implements in first aspect the 7th
In mode, carrying out pretreatment to the first account record sheet, the second account record sheet and third account record sheet includes:
Respectively in the structure of the first account record sheet, the second account record sheet and the third account record sheet
Change in field and extracts effective field；
It is identical to having in the first account record sheet, the second account record sheet and the third account record sheet
The title and format of the effective field of meaning carry out unification, so that the first account record sheet, the second account record sheet
It is at least partly identical with the field project in third account record sheet.
7th embodiment with reference to first aspect is remembered in the 8th embodiment of first aspect to first account
Record the title and lattice of the effective field in table, the second account record sheet and the third account record sheet with identical meanings
Formula carries out after unification, further includes:
Pay in personnel are extracted using name entity recognition techniques in the unstructured field of the second account record sheet
Information, and the pay in personal information of extraction is added in the second account record sheet；
Or/and reconciliation number letter is extracted by pattern match in the unstructured field of the second account record sheet
Breath, and the reconciliation number information of extraction is added in the second account record sheet, or the reconciliation in the second account record sheet is compiled
Number information is replaced.
According to second aspect, the embodiment of the invention provides a kind of account checking apparatus, comprising:
Preprocessing module is gone forward side by side for obtaining the first account record sheet, the second account record sheet and third account record sheet
Row pretreatment, so as to be stored in the first account record sheet, the second account record sheet and the third account record sheet
Field project it is at least partly identical；
Reconciliation module, for by the first preset field in the first account record sheet and the second account record sheet
Field value is matched, and the corresponding data sample of the field value of successful match is removed；
Recombination module, for filtering out a plurality of data sample in remaining first account record sheet, by a plurality of number
It is added according to the amount of money of sample, the amount of money after being recombinated；
The reconciliation module is also used to the amount of money after the recombination and the data filtered out in third account record sheet
The corresponding amount of money of sample is matched.
According to the third aspect, the embodiment of the invention provides a kind of reconciliation equipment, including account record sheet collector, storage
Device and processor communicate with each other connection between the account record sheet collector, the memory and the processor, described to deposit
Be stored with computer instruction in reservoir, the processor by executing the computer instruction, thereby executing first aspect or
Account checking method described in any one embodiment of first aspect.
It is described computer-readable the embodiment of the invention provides a kind of computer readable storage medium according to fourth aspect
Storage medium stores computer instruction, and the computer instruction is for making the computer execute first aspect or first aspect
Any one embodiment described in account checking method.
Detailed description of the invention
The features and advantages of the present invention will be more clearly understood by referring to the accompanying drawings, and attached drawing is schematically without that should manage
Solution is carries out any restrictions to the present invention, in the accompanying drawings:
Fig. 1 is the flow diagram of account checking method in the embodiment of the present invention 1；
Fig. 2 is the flow diagram of account checking method in the embodiment of the present invention 2；
Fig. 3 is the flow diagram of account checking method in the embodiment of the present invention 3；
Fig. 4 is the flow diagram of account checking method in the embodiment of the present invention 4；
Fig. 5 is the structural schematic diagram of account checking apparatus in the embodiment of the present invention 5；
Fig. 6 is the structural schematic diagram of reconciliation equipment in the embodiment of the present invention 6.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is
A part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, those skilled in the art are not having
Every other embodiment obtained under the premise of creative work is made, shall fall within the protection scope of the present invention.
Embodiment 1
The embodiment of the present invention 1 provides a kind of account checking method, and Fig. 1 is that the process of account checking method in the embodiment of the present invention 1 is shown
Be intended to, as shown in Figure 1, the account checking method of the embodiment of the present invention 1 the following steps are included:
S101: obtaining the first account record sheet, the second account record sheet and third account record sheet and pre-processed, with
Make the field project stored in the first account record sheet, the second account record sheet and the third account record sheet extremely
Small part is identical.
As a specific embodiment, specific to the account checking method of electric system, the first account record sheet is fund
Pay in record sheet, the second account record sheet are not sell fund check list.
S102: by the field value of the first preset field in the first account record sheet and the second account record sheet
It is matched, and the corresponding data sample of the field value of successful match is removed.
As a specific embodiment, specific to the account checking method of electric system, first preset field includes
One or two in lower: reconciliation number and the amount of money；Or first preset field includes one or several in following: pay in
Personnel, bank account, Bank Account Number and the amount of money.
S103: filtering out a plurality of data sample in remaining first account record sheet, by a plurality of data sample
The amount of money is added, the amount of money after being recombinated.
S104: by the amount of money amount of money corresponding with the data sample filtered out in third account record sheet after the recombination
It is matched.
As a specific embodiment, specific to the account checking method of electric system, third account record sheet is Internetbank
Flowing water.
The account checking method that the embodiment of the present invention 1 provides, first by the first account record sheet and the second account record sheet the
The field value of one preset field is matched, and the corresponding data sample of the field value of successful match is removed, and is then existed
A plurality of data sample is filtered out in remaining first account record sheet, the amount of money of a plurality of data sample is added after obtaining recombination
The amount of money, then the amount of money corresponding with the data sample filtered out in third account record sheet is matched, in a reconciliation
Pair of the first account record sheet and the second account record sheet and third account two account record sheets of record sheet can be completed in journey
Account operation, it is easy to operate；Simultaneously before matching the first account record sheet with third account record sheet, recorded in the first account
Eliminate the data sample of successful match in table, and by after data sample a plurality of in the first account record sheet recombination the amount of money with
The amount of money in third account record sheet is matched, so that the successful match rate of the first account record sheet and third account record sheet
It is higher.
Embodiment 2
The embodiment of the present invention 2 provides a kind of account checking method, and Fig. 2 is that the process of account checking method in the embodiment of the present invention 2 is shown
Be intended to, as shown in Fig. 2, the account checking method of the embodiment of the present invention 2 the following steps are included:
S201: obtaining the first account record sheet, the second account record sheet and third account record sheet and pre-processed, with
Make the field project stored in the first account record sheet, the second account record sheet and the third account record sheet extremely
Small part is identical.
Since the account current that certain banks generate is lack of standardization, reconciliation identifies format error or missing, leads to mass data
It can not match, need to carry out artificial reconciliation, as a specific embodiment, the first account record sheet, the second account are remembered
Record table and third account record sheet carry out pretreatment
Respectively in the structure of the first account record sheet, the second account record sheet and the third account record sheet
Change in field and extracts effective field；
It is identical to having in the first account record sheet, the second account record sheet and the third account record sheet
The title and format of the effective field of meaning carry out unification, so that the first account record sheet, the second account record sheet
It is at least partly identical with the field project in third account record sheet.
It is exemplary in the embodiment of the present invention 2, effective field in the first account record sheet extracted in structured field
Title include: " pay in personnel ", " pay in time ", " the pay in amount of money ", " clearing form ", " power supply bureau's unit number ", " pay in
Bank account ", " pay in Bank Account Number ", " reconciliation number "；In the second account record sheet extracted in structured field effectively
The title of field includes: " keeping accounts the time ", " amount of money ", " bank account ", " Bank Account Number ", " remarks ", " reconciliation number "；It is tying
The title of effective field includes: " trade date ", " transaction amount ", " right in the third account record sheet extracted in structure field
Square account name ", " other side's account ", " abstract ".
It is exemplary, to the first account record sheet, the second account record sheet and the third account record sheet
In the effective field with identical meanings title and format carry out it is unified after, further includes: in the second account record sheet
Unstructured field in using name entity recognition techniques extract pay in personal information, and the pay in personal information of extraction is added
Enter into the second account record sheet；Or/and it is mentioned in the unstructured field of the second account record sheet by pattern match
Reconciliation number information is taken, and the reconciliation number information of extraction is added in the second account record sheet, or the second account is recorded
Reconciliation number information in table is replaced.The embodiment of the present invention 2 is identified from unstructured information for the effective of reconciliation
Field greatly improves the matching rate of account checking method.
S202: by the first account record sheet field value corresponding with reconciliation number in the second account record sheet and the amount of money into
Row matching, and the corresponding data sample of the field value of successful match is removed.
S203: by pay in personnel, bank account, bank in the first account record sheet and the second account record sheet
Account and the corresponding field value of the amount of money are matched, and the corresponding data sample of the field value of successful match is removed.
S204: the field value that clearing form is filtered out in remaining first account record sheet includes POS machine separate type
With the Embedded data sample of POS machine；Postsearch screening is carried out in the data sample filtered out, obtain power supply bureau's unit number,
Time, the identical a plurality of data sample of the corresponding field value of Bank Account Number.
S205: the amount of money of the identical a plurality of data sample of the field value of third preset field is added, after obtaining recombination
The amount of money.
S206: the field value that reciprocal account name is filtered out in third account record sheet includes the data of POS machine consumption
Sample.
S207: by the amount of money amount of money corresponding with the data sample filtered out in third account record sheet after the recombination
It is matched.
S208: the amount of money after recombination is corresponding with the data sample filtered out in the third account record sheet
When the amount of money is identical, the corresponding a plurality of data sample of the amount of money after determining the recombination is screened in the third account record sheet
Data sample successful match out, and the data sample of successful match is removed.
S209: reconciliation number, pay in personnel and time corresponding field value in remaining first account record sheet are filtered out
Identical a plurality of data sample, the amount of money of a plurality of data sample is added, the data sample after obtaining the first recombination.
It include reconciliation number, pay in personnel, time and amount field in the data sample after the first recombination；Wherein reconciliation
Number, pay in personnel and the field value of time are the reconciliation number of any one data sample, pay in a plurality of data sample
Personnel and time corresponding field value, the field value of the amount of money are the amount of money for being added the amount of money of a plurality of data sample.
S210: by reconciliation number and the amount of money pair in the data sample and the second account record sheet after first recombination
The field value answered is matched.
The embodiment of the present invention 2 can be completed during a reconciliation the first account record sheet and the second account record sheet and
The reconciliation of two account record sheets of third account record sheet operates, easy to operate, while setting matching process to according to preferential
Grade sequence is matched, that is to say, that firstly, by reconciliation number and the amount of money in the first account record sheet and the second account record sheet
Corresponding field value is matched；Second, by pay in personnel, bank's account in the first account record sheet and the second account record sheet
Family, Bank Account Number and the corresponding field value of the amount of money are matched；Third filters out a plurality of data in the first account record sheet
The amount of money of a plurality of data sample is added the amount of money after being recombinated by sample, and the amount of money after recombination is recorded in third account
The corresponding amount of money of the data sample filtered out in table is matched；4th, filter out reconciliation number, solution in the first account record sheet
The amount of money of a plurality of data sample is added, obtains by money personnel and the identical a plurality of data sample of time corresponding field value
Data sample to after the first recombination, by reconciliation number and the amount of money in the data sample and the second account record sheet after the first recombination
Corresponding field value is matched.When being matched in the order described above, successful match rate is high, and matching speed is fast.
Embodiment 3
The embodiment of the present invention 3 provides a kind of account checking method, and Fig. 3 is that the process of account checking method in the embodiment of the present invention 3 is shown
It is intended to, as shown in Figure 3.Step S301~S307 of the embodiment of the present invention 3 is identical as step S201~S207, the embodiment of the present invention
3 repeat no more, and after step S307, further comprising the steps of:
S308: according to time, the amount of money and the identical principle of the corresponding field value of remarks, by the third account record sheet
In field value be associated with the field value in the second account record sheet, bank's side data after being associated with.
S309: the amount of money after recombination is corresponding with the data sample filtered out in the third account record sheet
When the amount of money is identical, the corresponding a plurality of data sample of the amount of money after determining the recombination is screened in the third account record sheet
Data sample successful match out, and the data sample of successful match is removed；
S310: according to reciprocal account name, other side's account, bank account, bank account and time corresponding field value phase
With principle, screened in bank's side data after association, and the amount of money of the pieces of data sample after screening is added, obtained
Data sample to after the second recombination.
Second recombination after data sample in include reciprocal account name, other side's account, bank account, bank account, when
Between and amount field；Wherein reciprocal account name, other side's account, bank account, bank account and the field value of time are a plurality of
The reciprocal account name, other side's account, bank account, bank account of any one data sample and time are corresponding in data sample
Field value, the field value of the amount of money are the amount of money for being added the amount of money of a plurality of data sample.
S312: by reconciliation number and the amount of money in the data sample and the first account record sheet after second recombination
Field value is matched.
The embodiment of the present invention 3 can be completed during a reconciliation the first account record sheet and the second account record sheet and
The reconciliation of two account record sheets of third account record sheet operates, easy to operate, while setting matching process to according to preferential
Grade sequence is matched, that is to say, that firstly, by reconciliation number and the amount of money in the first account record sheet and the second account record sheet
Corresponding field value is matched；Second, by pay in personnel, bank's account in the first account record sheet and the second account record sheet
Family, Bank Account Number and the corresponding field value of the amount of money are matched；Third filters out a plurality of data in the first account record sheet
The amount of money of a plurality of data sample is added the amount of money after being recombinated by sample, and the amount of money after recombination is recorded in third account
The corresponding amount of money of the data sample filtered out in table is matched；4th, the data of bank side are associated, according to other side's account
Name in an account book, other side's account, bank account, bank account and the identical principle of time corresponding field value, bank after association
It is screened in side data, and the amount of money of the pieces of data sample after screening is added, the data sample after obtaining the second recombination；
Data sample after second recombination is matched with reconciliation number in the first account record sheet and the field value of the amount of money.
When being matched in the order described above, successful match rate is high, and matching speed is fast.
Embodiment 4
Illustrate account checking method of the invention in order to more detailed, the embodiment of the present invention 4 provides a kind of power marketing industry
The account checking method for not selling fund check list and Internetbank flowing water that the fund pay in record sheet and banking system that business system generates generate,
It does not sell fund check list wherein and power marketing operation system is supplied to by banking system, Internetbank flowing water is published in silver by banking system
On capable website, power marketing operation system can obtain on website.As shown in figure 4, the account checking method of the embodiment of the present invention 4
The following steps are included:
1. data prediction
1.1: obtaining fund pay in record sheet respectively, do not sell fund check list and Internetbank flowing water.
1.2: in fund pay in record sheet, not selling in fund check list and Internetbank flowing water and extract effective field.
Wherein, the effective field that fund pay in record sheet extracts includes: " pay in personnel ", " pay in time ", " pay in gold
Volume ", " clearing form ", " power supply bureau's unit number ", " pay in bank account ", " pay in Bank Account Number ", " reconciliation number ".
Not selling the effective field extracted in fund check list includes: " keeping accounts the time ", " amount of money ", " bank account ", " bank
Account ", " remarks ", " reconciliation number ".
The effective field extracted in Internetbank flowing water includes: " trade date ", " transaction amount ", " reciprocal account name ", " other side
Account ", " abstract ".
1.3: to fund pay in record sheet, not selling the effective field in fund check list and Internetbank flowing water with identical meanings
Title and format carry out unification, so as to fund pay in record sheet, not sell field project in fund check list and Internetbank flowing water
It is at least partly identical.
Specifically, in fund pay in record sheet, " pay in time " renamed as " time ", " the pay in amount of money " renamed as
" amount of money ", " pay in bank account " renamed as " bank account ", " pay in Bank Account Number " renamed as " Bank Account Number ", remaining
Field keeps original title constant.
" keep accounts time " renamed as " time " is not sold in fund check list, remaining field keeps original title constant.
In Internetbank flowing water, " trade date " renamed as " time ", " transaction amount " renamed as " amount of money ", " abstract " weight
" remarks " are named as, remaining field keeps original title constant.
1.4: the second account record sheet and third account record sheet that banking system generates are associated.
Specifically, will not sell fund according to the identical principle of " time ", " amount of money " and " remarks " corresponding field value and examine
Field value in core table is associated with the field value in Internetbank flowing water, generates bank side account record sheet.
Wherein, so-called association can do following understanding: because in not selling fund check list and Internetbank flowing water " time ",
" amount of money " field value corresponding with " remarks " is identical, therefore takes in a data sample and do not sell fund check list or Internetbank flowing water
In " time ", " amount of money " and " remarks " corresponding field value, and fund check list will not sold except " time ", " amount of money " and " standby
Remaining field value and Internetbank the flowing water remaining field value in addition to " time ", " amount of money " and " remarks " increase except note "
Into the data sample.
1.5: reconciliation number being extracted by pattern match in the unstructured field of bank's side account record sheet that 1.4 generate
Information.And it is extracted in the unstructured field of the bank's side account record sheet generated 1.4 using name entity recognition techniques
Pay in personal information.
Specifically, numbered in " remarks " column according to the correct reconciliation of Rule Extraction format, i.e. 10 integers directly as
As a result, 9 integers then need to mend " 0 " in first place, arrange the result of extraction as " reconciliation number " candidate.If original fund of not selling is examined
There are format correct reconciliation number in " reconciliation number " column of core table, then retain original reconciliation number as a result, otherwise, with " right
Result in account number " candidate column replaces reconciliation number result.
Increase " pay in personnel " column in not selling fund check list." remarks " column in, using name entity recognition techniques,
Extract " pay in personnel " result of name as receipt.For guarantee algorithm high recall rate, by different name entity recognition methods
The result of acquisition is all retained.
By to fund pay in record sheet, do not sell the data after fund check list and Internetbank stream treatment and store into reconciliation
Pond.At this point, including " pay in personnel ", " time ", " amount of money ", " clearing side for the field of reconciliation in fund pay in record sheet
Formula ", " power supply bureau's unit number ", " bank account ", " Bank Account Number ", " reconciliation number "；Fund check list is not sold for reconciliation
Field include " time ", " amount of money ", " bank account ", " Bank Account Number ", " pay in personnel ", " reconciliation number "；Internetbank flowing water
In for reconciliation field include " time ", " amount of money ", " reciprocal account name ", " other side's account ".
2. matching process
2.1 carry out one-to-one matching according to " reconciliation number " and " amount of money "
Using fund pay in record sheet as " system side " data for being used for reconciliation, fund check list is not sold and is used as reconciliation
" bank side " data." reconciliation number " and " amount of money " two consistent entries of information in " system side " and " bank side " data
Carry out one-to-one matching.Matched data are completed if fitted through, in initial data enters reconciliation completion pond.
2.2 carry out one-to-one matching according to " pay in personnel ", " bank account ", " Bank Account Number " and " amount of money "
Using fund pay in record sheet as " system side " data for being used for reconciliation, fund check list is not sold and is used as reconciliation
" bank side " data.In " system side " and " bank side " data " pay in personnel ", " bank account ", " Bank Account Number " and
The consistent entry of " amount of money " 4 information carries out one-to-one matching.Completed if fitted through, in initial data matched data into
Enter reconciliation and completes pond.
2.3 carry out many-one matching to the bill that POS machine is consumed according to " amount of money "
The entry that " clearing form " is " POS machine separate type " and " POS machine is embedded " is screened in fund pay in record sheet,
According to the identical rule of " power supply bureau's unit number ", " time " and " bank account " 3 information to " amount of money " in the selection result
It is added up, as new " amount of money " field, so that a plurality of information be compressed, obtains " system side " number for reconciliation
According to.The entry that " reciprocal account name " contains " POS machine consumption " printed words is screened in Internetbank flowing water, obtains " the bank for reconciliation
Side " data." amount of money " consistent entry in " system side " and " bank side " data is matched.It is original if fitted through
Matched data are completed in data enters reconciliation completion pond.
2.4 carry out one-to-many matching according to " reconciliation number " and " amount of money "
Using fund pay in record sheet as be used for reconciliation " system side " data, Internetbank flowing water be associated with receipt after data
According to " reciprocal account name ", " other side's account ", " reconciliation number ", " bank account ", " Bank Account Number ", " time " 6 information
Identical rule adds up " amount of money ", is used for as new " amount of money " field so that a plurality of information be compressed
" bank side " data of reconciliation." amount of money " and " reconciliation number " two information are consistent in " system side " and " bank side " data
Entry is matched.If fitted through, initial data completes matched result and enters pond to be checked.
2.5 carry out many-one matching according to " reconciliation number " and " amount of money "
Not sell fund check list as " bank side " data for being used for reconciliation, according to " pay in fund pay in record sheet
Personnel ", " time ", the identical rule of " reconciliation number " 3 information add up " amount of money ", as new " amount of money " field,
To compress a plurality of information, " system side " data for reconciliation are obtained.To in " system side " and " bank side " data
" amount of money " and " reconciliation number " two consistent entries of information are matched.If fitted through, initial data is completed matched
As a result enter pond to be checked.
Matched result is not yet passed in initial data enters non-match-pool.
Embodiment 5
Corresponding with present invention implementation 1, the embodiment of the present invention 5 additionally provides a kind of account checking apparatus, and Fig. 5 is that the present invention is implemented
The structural schematic diagram of account checking apparatus in example 5, as shown in figure 5, the account checking apparatus of the embodiment of the present invention 5 include preprocessing module 50,
Reconciliation module 52, recombination module 54.
Wherein, preprocessing module 50, for obtaining the first account record sheet, the second account record sheet and third account record
Table is simultaneously pre-processed, so that the first account record sheet, the second account record sheet and the third account record sheet
The field project of middle storage is at least partly identical.
Reconciliation module 52 is used for the first preset field in the first account record sheet and the second account record sheet
Field value matched, and the corresponding data sample of the field value of successful match is removed.
Recombination module 54 will be described a plurality of for filtering out a plurality of data sample in remaining first account record sheet
The amount of money of data sample is added, the amount of money after being recombinated.
The reconciliation module 52 is also used to the amount of money after the recombination and the number filtered out in third account record sheet
It is matched according to the corresponding amount of money of sample.
The account checking apparatus that the embodiment of the present invention 5 provides, first by the first account record sheet and the second account record sheet the
The field value of one preset field is matched, and the corresponding data sample of the field value of successful match is removed, and is then existed
A plurality of data sample is filtered out in remaining first account record sheet, the amount of money of a plurality of data sample is added after obtaining recombination
The amount of money, then the amount of money corresponding with the data sample filtered out in third account record sheet is matched, so that system side
First account record sheet can be matched successively with the second account record sheet of bank side feedback and third account record sheet, one
Pair of the first account record sheet of system side and two account record sheets of bank side feedback can be completed during secondary reconciliation
Account operation, it is easy to operate；Simultaneously by the first account record sheet of system side and bank side feedback third account record sheet it
Before, the data sample of successful match is eliminated in the first account record sheet of system side, and will be in the first account record sheet
The amount of money after the recombination of a plurality of data sample is matched with the amount of money in third account record sheet so that the first account record sheet and
The successful match rate of third account record sheet is higher.
The account checking apparatus that the embodiment of the present invention 5 provides, equally may be implemented the reconciliation of 2~embodiment of the embodiment of the present invention 4
Method, and there is same technical effect, details are not described herein.
Embodiment 6
The embodiment of the invention also provides a kind of reconciliation equipment, as shown in fig. 6, the reconciliation equipment may include account record
Table collector 60, processor 61 and memory 62, wherein account record sheet collector 60, processor 61 and memory 62 can lead to
It crosses bus or other modes connects, in Fig. 6 for being connected by bus.
Processor 61 can be central processing unit (Central Processing Unit, CPU).Processor 61 can be with
For other general processors, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), field programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
The combination of the chips such as discrete hardware components or above-mentioned all kinds of chips.
Memory 62 is used as a kind of non-transient computer readable storage medium, can be used for storing non-transient software program, non-
Transient computer executable program and module, such as the corresponding program instruction of the account checking method in the embodiment of the present invention/module (example
Such as, preprocessing module 50 shown in fig. 5, reconciliation module 52, recombination module 54).Processor 61 is stored in memory by operation
Non-transient software program, instruction and module in 62, thereby executing the various function application and data processing of processor, i.e.,
Realize the account checking method in above method embodiment.
Memory 62 may include storing program area and storage data area, wherein storing program area can storage program area,
Application program required at least one function；It storage data area can the data etc. that are created of storage processor 61.In addition, storage
Device 62 may include high-speed random access memory, can also include non-transient memory, for example, at least a magnetic disk storage
Part, flush memory device or other non-transient solid-state memories.In some embodiments, it includes relative to place that memory 62 is optional
The remotely located memory of device 61 is managed, these remote memories can pass through network connection to processor 61.The reality of above-mentioned network
Example includes but is not limited to internet, intranet, local area network, mobile radio communication and combinations thereof.
One or more of modules are stored in the memory 62, when being executed by the processor 61, are executed
Account checking method in embodiment as shown in Figs 1-4.
Above-mentioned vehicle termination detail can correspond to corresponding associated description in embodiment referring to FIG. 1 to 4
Understood with effect, details are not described herein again.
It is that can lead to it will be understood by those skilled in the art that realizing all or part of the process in above-described embodiment method
Computer program is crossed to instruct relevant hardware and complete, the program can be stored in a computer-readable storage medium
In, the program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, the storage medium can for magnetic disk,
CD, read-only memory (Read-OnlyMemory, ROM), random access memory (Random Access Memory,
RAM), flash memory (Flash Memory), hard disk (Hard Disk Drive, abbreviation: HDD) or solid state hard disk (Solid-
State Drive, SSD) etc.；The storage medium can also include the combination of the memory of mentioned kind.
Although being described in conjunction with the accompanying the embodiment of the present invention, those skilled in the art can not depart from the present invention
Spirit and scope in the case where various modifications and variations can be made, such modifications and variations are each fallen within by appended claims institute
Within the scope of restriction.
Claims (12)
1. a kind of account checking method, which comprises the steps of:
It obtains the first account record sheet, the second account record sheet and third account record sheet and is pre-processed, so that described
The field project at least partly phase stored in one account record sheet, the second account record sheet and the third account record sheet
Together；
The first account record sheet is matched with the field value of the first preset field in the second account record sheet,
And the corresponding data sample of the field value of successful match is removed；
A plurality of data sample is filtered out in remaining first account record sheet, the amount of money of a plurality of data sample is added,
The amount of money after being recombinated；
The amount of money amount of money corresponding with the data sample filtered out in third account record sheet after the recombination is matched.
2. account checking method according to claim 1, which is characterized in that
First preset field includes one or two in lower: reconciliation number and the amount of money；
And/or first preset field includes one or several in following: pay in personnel, bank account, Bank Account Number and
The amount of money.
3. account checking method according to claim 1, which is characterized in that filtered out in remaining first account record sheet more
Data sample includes:
The field value that the second preset field is filtered out in remaining first account record sheet includes POS machine separate type and POS
The Embedded data sample of machine；Wherein the second preset field is clearing form；
Postsearch screening is carried out in the data sample filtered out, obtains the identical a plurality of data of field value of third preset field
Sample；Third preset field includes one or several in following: power supply bureau's unit number, time, Bank Account Number.
4. account checking method according to claim 3, which is characterized in that by the amount of money after the recombination and in third account
Before the corresponding amount of money of the data sample filtered out in record sheet is matched further include:
The field value that the 4th preset field is filtered out in third account record sheet includes the data sample of POS machine consumption；Its
In, the 4th preset field is reciprocal account name.
5. account checking method according to claim 1, which is characterized in that by the amount of money after the recombination and in third account
After the corresponding amount of money of the data sample filtered out in record sheet is matched, further includes:
The amount of money after recombination is identical as the corresponding amount of money of data sample filtered out in the third account record sheet
When, after determining the recombination the amount of money corresponding a plurality of data sample and the data that filter out in the third account record sheet
Sample matches success, and the data sample of successful match is removed；
The identical a plurality of data sample of field value of the 5th preset field in remaining first account record sheet is filtered out, it will be described
The amount of money of a plurality of data sample is added, the data sample after obtaining the first recombination, wherein the 5th preset field includes reconciliation number,
And it is following in one or several: pay in personnel, time；
By it is described first recombination after data sample and the second account record sheet in the 6th preset field field value into
Row matching, wherein the 6th preset field includes reconciliation number and the amount of money.
6. described in any item account checking methods according to claim 1~5, which is characterized in that further comprising the steps of:
According to the identical principle of the corresponding field value of the 7th preset field, by the field value in the third account record sheet
It is associated with the field value in the second account record sheet, bank's side data after being associated with, wherein the 7th is default
Field includes one or several in following: time, the amount of money and remarks.
7. account checking method according to claim 6, which is characterized in that by the amount of money after the recombination and in third account
After the corresponding amount of money of the data sample filtered out in record sheet is matched, further includes:
The amount of money after recombination is identical as the corresponding amount of money of data sample filtered out in the third account record sheet
When, after determining the recombination the amount of money corresponding a plurality of data sample and the data that filter out in the third account record sheet
Sample matches success, and the data sample of successful match is removed；
According to the identical principle of the corresponding field value of the 8th preset field, screened in bank's side data after association,
And the amount of money of the pieces of data sample after screening is added, the data sample after obtaining the second recombination；Wherein the described 8th is default
Field includes reconciliation number, and it is following in one or several: reciprocal account name, other side's account, bank account, bank account,
Time；
By it is described second recombination after data sample and the first account record sheet in the 9th preset field field value into
Row matching, wherein the 9th preset field includes reconciliation number and the amount of money.
8. described in any item account checking methods according to claim 1~7, which is characterized in that the first account record sheet, the second account
Program recording table and third account record sheet carry out pretreatment
Respectively in the first account record sheet, the structuring word of the second account record sheet and the third account record sheet
Effective field is extracted in section；
To in the first account record sheet, the second account record sheet and the third account record sheet have identical meanings
Effective field title and format carry out unification so that the first account record sheet, the second account record sheet and the
Field project in three account record sheets is at least partly identical.
9. account checking method according to claim 8, which is characterized in that the first account record sheet, described second
The title and format of effective field in account record sheet and the third account record sheet with identical meanings carry out unification
Afterwards, further includes:
Pay in personal information is extracted using name entity recognition techniques in the unstructured field of the second account record sheet,
And the pay in personal information of extraction is added in the second account record sheet；
Or/and reconciliation number information is extracted by pattern match in the unstructured field of the second account record sheet, and
The reconciliation number information of extraction is added in the second account record sheet, or to the reconciliation number information in the second account record sheet
It is replaced.
10. a kind of account checking apparatus characterized by comprising
Preprocessing module, for obtaining the first account record sheet, the second account record sheet and third account record sheet and carrying out pre-
Processing, so that the word stored in the first account record sheet, the second account record sheet and the third account record sheet
Section project is at least partly identical；
Reconciliation module, for by the field of the first preset field in the first account record sheet and the second account record sheet
Value is matched, and the corresponding data sample of the field value of successful match is removed；
Recombination module, for filtering out a plurality of data sample in remaining first account record sheet, by a plurality of data sample
This amount of money is added, the amount of money after being recombinated；
The reconciliation module is also used to the amount of money after the recombination and the data sample filtered out in third account record sheet
The corresponding amount of money is matched.
11. a kind of reconciliation equipment characterized by comprising
Account record sheet collector, memory and processor, the account record sheet collector, the memory and the processing
Connection is communicated with each other between device, computer instruction is stored in the memory, the processor is by executing the computer
Instruction, thereby executing account checking method of any of claims 1-9.
12. a kind of computer readable storage medium, which is characterized in that the computer-readable recording medium storage has computer to refer to
It enables, the computer instruction is used to that the computer perform claim to be made to require account checking method described in any one of 1-9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910435483.0A CN110276672A (en) | 2019-05-23 | 2019-05-23 | A kind of account checking method, device, equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910435483.0A CN110276672A (en) | 2019-05-23 | 2019-05-23 | A kind of account checking method, device, equipment and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110276672A true CN110276672A (en) | 2019-09-24 |
Family
ID=67959427
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910435483.0A Pending CN110276672A (en) | 2019-05-23 | 2019-05-23 | A kind of account checking method, device, equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110276672A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111626872A (en) * | 2020-05-25 | 2020-09-04 | 泰康保险集团股份有限公司 | Data verification and cancellation method, device, equipment and storage medium |
| CN111951091A (en) * | 2020-08-13 | 2020-11-17 | 金蝶软件（中国）有限公司 | Transaction flow reconciliation method, system and related equipment |
| CN112286936A (en) * | 2020-11-03 | 2021-01-29 | 金蝶软件（中国）有限公司 | Account checking method, system and related equipment |
| CN114218914A (en) * | 2021-12-16 | 2022-03-22 | 金蝶软件（中国）有限公司 | Service matching method and related device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP5005008B2 (en) * | 2009-08-26 | 2012-08-22 | 中国電力株式会社 | Resource or service supply control system and resource or service supply control method |
| CN103310311A (en) * | 2013-06-29 | 2013-09-18 | 国家电网公司 | Electric charge finance management system and account checking method |
| CN104156832A (en) * | 2014-08-28 | 2014-11-19 | 国家电网公司 | Intersystem data verification method and device |
| CN107292493A (en) * | 2017-05-26 | 2017-10-24 | 国网山东省电力公司德州供电公司 | A kind of reconciliation system and method between electric power enterprise and bank |
| CN108288223A (en) * | 2018-03-13 | 2018-07-17 | 同方鼎欣科技股份有限公司 | A kind of power marketing manages system and method with financial counting |
| CN109461066A (en) * | 2018-11-01 | 2019-03-12 | 广东电网有限责任公司 | Electric power enterprise account checking system and method thereof |
-
2019
- 2019-05-23 CN CN201910435483.0A patent/CN110276672A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP5005008B2 (en) * | 2009-08-26 | 2012-08-22 | 中国電力株式会社 | Resource or service supply control system and resource or service supply control method |
| CN103310311A (en) * | 2013-06-29 | 2013-09-18 | 国家电网公司 | Electric charge finance management system and account checking method |
| CN104156832A (en) * | 2014-08-28 | 2014-11-19 | 国家电网公司 | Intersystem data verification method and device |
| CN107292493A (en) * | 2017-05-26 | 2017-10-24 | 国网山东省电力公司德州供电公司 | A kind of reconciliation system and method between electric power enterprise and bank |
| CN108288223A (en) * | 2018-03-13 | 2018-07-17 | 同方鼎欣科技股份有限公司 | A kind of power marketing manages system and method with financial counting |
| CN109461066A (en) * | 2018-11-01 | 2019-03-12 | 广东电网有限责任公司 | Electric power enterprise account checking system and method thereof |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111626872A (en) * | 2020-05-25 | 2020-09-04 | 泰康保险集团股份有限公司 | Data verification and cancellation method, device, equipment and storage medium |
| CN111626872B (en) * | 2020-05-25 | 2023-09-26 | 泰康保险集团股份有限公司 | Data verification method, device, equipment and storage medium |
| CN111951091A (en) * | 2020-08-13 | 2020-11-17 | 金蝶软件（中国）有限公司 | Transaction flow reconciliation method, system and related equipment |
| CN111951091B (en) * | 2020-08-13 | 2023-12-29 | 金蝶软件（中国）有限公司 | Transaction flow reconciliation method, system and related equipment |
| CN112286936A (en) * | 2020-11-03 | 2021-01-29 | 金蝶软件（中国）有限公司 | Account checking method, system and related equipment |
| CN114218914A (en) * | 2021-12-16 | 2022-03-22 | 金蝶软件（中国）有限公司 | Service matching method and related device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110276672A (en) | A kind of account checking method, device, equipment and computer readable storage medium | |
| CN107103462B (en) | Method and device for processing snapshot data of cross-border remittance of bank | |
| CN102880956B (en) | Paying server and payment channel integration method | |
| CN108268593A (en) | Credit card is insured processing method, device, server and the storage medium of information | |
| CN105741088A (en) | Routing matching payment method and device | |
| CN106557971A (en) | Based on the financial data processing method of speech recognition technology, system and terminal | |
| CN109636567A (en) | Business handling method, server, storage medium and device based on big data | |
| CN101145264A (en) | Business affairs bank card processing system and method | |
| CN107103575A (en) | A kind of rail traffic ticket automatic selling and checking system credit payment method based on mobile phone IMEI acquisition techniques | |
| CN107689009A (en) | Annuity data processing method, device, server and storage medium | |
| CN113205402A (en) | Account checking method and device, electronic equipment and computer readable medium | |
| CN103903082A (en) | Method for generating accounting documents by means of receipt data in ERP system | |
| CN105630839B (en) | The acquisition methods and device of webpage information | |
| CN107808206A (en) | It is a kind of to pay out processing method, server and passenger terminal with car order | |
| CN104200355A (en) | Integrated circuit (IC) card loading method based on O2O mode | |
| CN110827132A (en) | Automatic reconciliation method for marketing account of power enterprise | |
| CN109272400A (en) | Method for processing resource and device | |
| CN109345371A (en) | Personal reference report backtracking method and system | |
| CN105741094A (en) | Payment system for immediately transferring to account and electronic business system | |
| CN102968858B (en) | Transaction data backup method in AFC system and transaction terminal | |
| CN107563741A (en) | A kind of data save related service charging method and system from damage | |
| CN112989763B (en) | Data acquisition method, device, computer equipment and storage medium | |
| CN111951016B (en) | Merchant agreement subscription storage method and device | |
| CN107403301A (en) | Declaration form move back expense is transferred accounts treating method and apparatus | |
| US11875374B2 (en) | Automated auditing and recommendation systems and methods |
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: 20190924 |
|
| RJ01 | Rejection of invention patent application after publication |