CN110287200A - Account checking method, system, computer equipment and storage medium - Google Patents
Account checking method, system, computer equipment and storage medium Download PDFInfo
- Publication number
- CN110287200A CN110287200A CN201910591328.8A CN201910591328A CN110287200A CN 110287200 A CN110287200 A CN 110287200A CN 201910591328 A CN201910591328 A CN 201910591328A CN 110287200 A CN110287200 A CN 110287200A
- Authority
- CN
- China
- Prior art keywords
- data
- reconciliation
- tables
- billing
- source
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
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/2282—Tablespace storage structures; 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
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- 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
Abstract
The present invention relates to data reconciliation technical field, a kind of account checking method, system, computer equipment and storage medium are provided.The account checking method periodically carries out reconciliation task according to the reconciliation period of configuration, comprising: respectively from each billing data obtained in the current reconciliation period in the first data source and the second data source, generates the first tables of data and the second tables of data；Data cached table is traversed, the billing data for belonging to the first data source and the second data source is moved into the first tables of data and the second tables of data respectively；Each billing data is compared, correspondence is filtered out and is present in the first tables of data and the second tables of data but unmatched first kind billing data, as abnormal data；And the second class billing data for existing only in the first tables of data or the second tables of data is filtered out, data cached table is stored at least to supply the comparison in next reconciliation period.The present invention can be realized the flexible configuration of reconciliation information and the rolling reconciliation of the second class billing data, improve reconciliation efficiency and precision.
Description
Technical field
The present invention relates to data reconciliation technical fields, specifically, being related to a kind of account checking method, system, computer equipment
And storage medium.
Background technique
In enterprise management process, the transaction data generated for online trading process is needed to be compared, i.e. billing data
It compares, to ensure the clear and accurate of funds on account in process of exchange.
There are mainly two types of existing financial counting modes:
First is that the manual reconciliation of financial staff, financial staff from the data platforms such as each payment mechanism, bank, our company pull to
The data file of reconciliation is needed, progress compares line by line manually.This kind of mode is time-consuming and laborious, and artificial error-prone；
Second is that, for every payment mechanism, bank and the related data of our company, every kind all hard using Corporate Finance platform
Then the acquisition and process flow of coded data are compared line by line using system.This kind of mode is compiled firmly for every kind of data source
Code process flow, wastes development resources and entreprise cost；And reconciliation has the inconsistent data of fringe time generation every time, every time
It will check one by one, it is time-consuming and laborious.
It should be noted that the information in above-mentioned background technology part application is only used for reinforcing the reason to background of the invention
Solution, therefore may include the information not constituted to the prior art known to persons of ordinary skill in the art.
Summary of the invention
In view of this, the present invention provides a kind of account checking method, system, computer equipment and storage medium, may be implemented pair
The flexible configuration of account information, and rolling reconciliation is carried out for the data that leave a question open, improve reconciliation efficiency and precision.
According to an aspect of the present invention, a kind of account checking method is provided, the account checking method according to reconciliation period of configuration,
Periodically carry out reconciliation task, comprising: obtain to the first data source of reconciliation, the second data source and current reconciliation period；Point
Not from each billing data obtained in first data source and second data source in the current reconciliation period, generate
First tables of data and the second tables of data；Traverse data cached table, will belong in the data cached table first data source and
The billing data of second data source moves to first tables of data and second tables of data respectively；Compare first number
According to each billing data in table and second tables of data, filters out correspondence and be present in first tables of data and described second
Tables of data but unmatched first kind billing data, as abnormal data；And filter out exist only in first tables of data or
Second class billing data of second tables of data is stored in the data cached table at least to supply the comparison in next reconciliation period.
Preferably, above-mentioned account checking method further include: periodically the billing data in the data cached table is carried out
Screening；The billing data that number is more than preset value is compared when existing in the data cached table, then using the billing data as different
Regular data removes the data cached table.
Preferably, in above-mentioned account checking method, every billing data includes transaction journal number and transaction amount, described
First kind billing data is that transaction journal number is existed simultaneously in first tables of data and second tables of data but transaction amount
Different billing datas, the second class billing data are that transaction journal number exists only in first tables of data or described second
The billing data of tables of data.
Preferably, each in the comparison first tables of data and second tables of data in above-mentioned account checking method
Billing data, comprising: parse each billing data in first tables of data and second tables of data；With the transaction
Serial number is that mark traversal compares each billing data in first tables of data and second tables of data, searches described the
A kind of billing data and the second class billing data.
Preferably, in above-mentioned account checking method, the traversal ratio of billing data is carried out using SQL-join or Redis-sdiff
It is right.
Preferably, in above-mentioned account checking method, the reconciliation period according to configuration, periodically carry out reconciliation task it
Before, further includes: the reconciliation information for obtaining configuration periodically generates reconciliation task, and the reconciliation information is included at least to reconciliation
Data source and the reconciliation period.
Preferably, above-mentioned account checking method further include: generate the reconciliation notified extremely for including at least the abnormal data
Result form.
According to another aspect of the present invention, a kind of reconciliation system is provided, including for the reconciliation period according to configuration, week
The task execution module of reconciliation task is executed to phase property, the task execution module includes: reconciliation data obtaining module, for obtaining
Take the first data source to reconciliation, the second data source and current reconciliation period；Comparison data obtains module, for respectively from described
Each billing data in the current reconciliation period is obtained in first data source and second data source, generates the first data
Table and the second tables of data；Rolling data obtains module, for traversing data cached table, will belong in the data cached table described
The billing data of first data source and second data source moves to first tables of data and second tables of data respectively；With
And it compares screening module and is filtered out for comparing each billing data in first tables of data and second tables of data
Correspondence is present in first tables of data and second tables of data but unmatched first kind billing data, as abnormal number
According to；And the second class billing data for existing only in first tables of data or second tables of data is filtered out, it is stored in described slow
Deposit data table is at least for the comparison in next reconciliation period.
Preferably, above-mentioned reconciliation system further include: configuration module is used to provide the described the configuration of reconciliation information visuallization
The page, the configuration of the reconciliation information include at least the configuration and the configuration in reconciliation period of the data source to reconciliation.
According to another aspect of the present invention, a kind of computer equipment is provided, comprising: processor；Memory, wherein storing
There is the executable instruction of the processor；Wherein, the processor is configured to execute via the executable instruction is executed
The step of account checking method stated.
According to another aspect of the present invention, a kind of computer readable storage medium is provided, for storing program, the journey
Sequence is performed the step of realizing above-mentioned account checking method.
Beneficial effects of the present invention include at least:
The present invention there will be only the data that leave a question open in the first tables of data or the second tables of data as can roll the of reconciliation
Two class billing datas allow the second class billing data to continue to participate in the ratio in the period of reconciliation below after current reconciliation end cycle
It is right, to realize because the data that leave a question open that the time difference generates automatically carry out rolling reconciliation, handled without artificial participation, improves reconciliation
Efficiency and precision；
Meanwhile the present invention is able to achieve the flexible configuration of reconciliation information, user, which can according to need, carries out data source and reconciliation
The configuration of the reconciliations such as period information improves reconciliation flexibility.
It should be understood that above general description and following detailed description be only it is exemplary and explanatory, not
It can the limitation present invention.
Detailed description of the invention
The drawings herein are incorporated into the specification and forms part of this specification, and shows and meets implementation of the invention
Example, and be used to explain the principle of the present invention together with specification.It should be evident that the accompanying drawings in the following description is only the present invention
Some embodiments for those of ordinary skill in the art without creative efforts, can also basis
These attached drawings obtain other attached drawings.
Fig. 1 shows the step schematic diagram of the account checking method of the embodiment of the present invention；
Fig. 2 shows the execution step schematic diagrams of a reconciliation task in the embodiment of the present invention；
Fig. 3 shows the module diagram of the reconciliation system of the embodiment of the present invention；
Fig. 4 shows a kind of structural schematic diagram of computer equipment of the embodiment of the present invention；
Fig. 5 shows a kind of structural schematic diagram of computer readable storage medium of the embodiment of the present invention.
Specific embodiment
Example embodiment is described more fully with reference to the drawings.However, example embodiment can be with a variety of shapes
Formula is implemented, and is not understood as limited to embodiment set forth herein.On the contrary, thesing embodiments are provided so that the present invention will
Fully and completely, and by the design of example embodiment comprehensively it is communicated to those skilled in the art.It is identical attached in figure
Icon note indicates same or similar structure, thus will omit repetition thereof.
Account checking method of the invention is suitable for the data reconciliation of payment platform, and the mainly reconciliation of transaction data can solve
Financial reconciliation line by line manually is put, based on configurable rule, compares the data in the period, and generate related statements and need finance
The exception handled under Manual line is single.Also research staff's overprogram, each data source of flexible configuration and alignments can be liberated, are not necessarily to
In a kind of every relevant data processing code of hard coded after increasing data source.
Fig. 1 shows the step schematic diagram of account checking method in one embodiment, shown referring to Fig.1, before carrying out reconciliation, reconciliation
Personnel, such as the visual page that financial staff can provide in system configure reconciliation information, i.e. execution step S10.Reconciliation letter
The configuration of breath includes: the configuration of data source, acquisition modes, analysis mode, field format including configuring each data source, and number
According to comparison field, the comparison rules etc. between source.One configured data source, including title, acquisition modes (such as HTTP/FTP or
Person other agreements), file type (such as csv, xls, txt), (including field name, field type, field most greatly enhance field format
Degree).By providing the visual page configured for every kind of data source, system can be used configured rule automatically into
Row data processing, without manpower intervention or research and development hard coded.The configuration of reconciliation information further includes the configuration of reconciliation account, can be with
Configure which account participates in reconciliation, carries out comparing；And the configuration of reconciliation task, the reconciliation week of reconciliation task can be configured
Phase, reconciliation time, comparison rules, rolling planning etc..After the completion of reconciliation information configuration, S20 is executed, reconciliation is periodically executed
Task carries out reconciliation every the reconciliation period of configuration.S30 is executed after the completion of each reconciliation task execution, generates reconciliation result
Report, the reconciliation result including every kind of configuration task, configuration account summarizes and every kind of configuration task, the exception for configuring account
Single and processing mode etc..
The reconciliation period, which can according to need, to be configured, such as reconciliation period assignment is 1 day, then as unit of day, daily
Reconciliation is carried out to the billing data that the previous day generates.Fig. 2 shows the execution schematic diagrames of a reconciliation task in embodiment, referring to figure
Shown in 2, according to the reconciliation period of configuration, periodically carrying out reconciliation task includes:
S220, it obtains to the first data source of reconciliation, the second data source and current reconciliation period.
To the first data source of reconciliation and the second data source depending on configuration, such as when needing to our company's ordering system
Billing data reconciliation is carried out between Third-party payment platform, then can configure the first data source to our company's ordering system data
Library, the second data source are configured to Third-party payment platform database.In one embodiment, according to the reconciliation period of configuration, week
Before executing to phase property reconciliation task further include: the reconciliation information for obtaining configuration periodically generates reconciliation task, reconciliation information
Including at least to reconciliation data source and the reconciliation period.
S230, respectively from each billing data obtained in the first data source and the second data source in the current reconciliation period,
Generate the first tables of data and the second tables of data.
In one embodiment, such as the current reconciliation period is 2019-06-20 (i.e. on June 20th, 2019), then from first
Each billing data that 2019-06-20 is generated is obtained in data source, generates the first tables of data；And it is obtained from the second data source
Each billing data that 2019-06-20 is generated generates the second tables of data.The acquisition of billing data can use above-mentioned HTTP/
FTP or other agreements.
S240, the data cached table of traversal, will belong to the bill number of the first data source and the second data source in data cached table
According to moving to the first tables of data and the second tables of data respectively.
Leave a question open as the result is shown in data cached table for reconciliation before storing, but there is no the billing data for needing artificial treatment.
Data type suitable for being stored in data cached table, which can according to need, to be configured, for example, can in the secondary reconciliation period,
Two compared to pair tables of data in, exist and the billing data being not present in the second tables of data or second in the first tables of data
The billing data for existing in tables of data and being not present in the first tables of data is configured to that data cached table can be stored in, and makes those bills
Data can participate in subsequent reconciliation, until comparing successfully, or compare failure because violating rolling planning.By rolling reconciliation
Scheme, each reconciliation period generate because of inconsistent data caused by the fringe time, the ratio in the period of reconciliation below can be participated in
It is right, it is handled without artificial participation, improves reconciliation efficiency and precision.
Each billing data in S250, the first tables of data of comparison and the second tables of data filters out correspondence and is present in first
Tables of data and the second tables of data but unmatched first kind billing data, as abnormal data；And it filters out and exists only in first
Second class billing data of tables of data or the second tables of data is stored in data cached table at least to supply the comparison in next reconciliation period.
In the present embodiment, first kind billing data be exist simultaneously in the first tables of data and the second tables of data, but can not
The billing data matched；Second class billing data be exist in the first tables of data but be not present in the second tables of data or second number
According to the billing data for existing in table but being not present in the first tables of data.In one embodiment, every billing data includes transaction
Serial number and transaction amount, then first kind billing data is that transaction journal number is existed simultaneously in the first tables of data and the second tables of data
But the different billing data of transaction amount.For example, transaction journal number is the billing data of " 123456789 " in the first tables of data
The transaction amount of record is 1000 yuan, and the transaction amount recorded in the second tables of data is 800 yuan, then it is usually because first
There is mistake in system where data source or the second data source, and artificial treatment is needed to check.Therefore those first kind billing datas
It is screened out, as abnormal data.Second class billing data is that transaction journal number exists only in the first tables of data or the second number
According to the billing data of table.For example, the billing data that transaction journal number is " 987654321 " exist in the first tables of data and the
Be not present in two tables of data, then it is usually because system delay or order place an order and pay between there are time differences and right
Data record difference caused by the reasons such as the fringe time in account period.Those the second class billing datas are screened out, deposit caching
Tables of data is at least for the comparison in next reconciliation period.
In one embodiment, the first data source is our company's ordering system database, and the second data source is third party's branch
Platform database is paid, the current reconciliation period is 2019-06-20.One order is generated in 2019-06-20 23:59:00, and
2019-06-21 00:01:00 payment, then the corresponding billing data of the order is recorded in 2019-06-20 in the first data source
Period in, and in the period for being then recorded in 2019-06-21 in the second data source.Within the current reconciliation period, the order
Billing data exists only in the first tables of data, therefore is screened out as the second class billing data, is stored in data cached table.When
When the reconciliation task execution in next reconciliation period, the billing data of the order then be may be implemented and be recorded in the second data source
Billing data matches, to compare success, eliminates difference.
The data type of first kind billing data and the second class billing data also can according to need configuration, to filter out symbol
Close the billing data of checking requirement.
In one embodiment, the step of comparing each billing data in the first tables of data and the second tables of data include:
Each billing data in the first tables of data and the second tables of data is parsed, such as by the bill in the first tables of data and the second tables of data
Data conversion is for convenience of the data format compared；It is that mark traversal compares the first tables of data and the second tables of data with transaction journal number
In each billing data, search first kind billing data and the second class billing data.Specifically, it can be selected according to data volume
It is compared using the traversal that SQL-join or Redis-sdiff carries out billing data.
In one embodiment, when data volume to be compared be no more than 1,000,000, then be compared using SQL.Assuming that needing
Compare transaction journal number, the transaction amount of the billing data of the first data source (data source A) and the second data source (data source B) with
And the amount of money enters and leaves direction.Two kinds of interim table ds_A and ds_B are created for data source A and data source B is each, by data source A and data source
The billing data that B respectively needs to compare is stored in respectively in interim table ds_A and ds_B.It can be easily using SQL-join
It obtains, exist in ds_A but is not present in ds_B, the second class billing data for existing in ds_B but being not present in ds_A, and
The first kind billing data that ds_A and ds_B exists but transaction amount is inconsistent.In one embodiment, when number to be compared
According to amount more than 1,000,000, then compared using Redis.It also assumes that and needs comparison data source A and data source B, compare field transaction flow
Water O, the amount of money enter and leave direction D, transaction amount M.Two Redis Set are created for data source A and data source B is each, it is respective for being worth
Data configuration character string (O_D_M) list can easily filter out first kind bill number using the sdiff method of Redis
According to the second class billing data.
In a preferred embodiment, above-mentioned account checking method further include: periodically to the bill number in data cached table
According to progress screening；When in data cached table exist compare number be more than preset value billing data, then using the billing data as
Abnormal data removes data cached table.For example, being configured to rolling reconciliation in 3 days for the billing data in data cached table, work as caching
A billing data in tables of data is compared by 3 days (then passing through 3 times when the reconciliation period is 1 day) and can not still be matched, then is said
It is possible to there is very big error in the bright billing data, therefore then removes data cached table using the billing data as abnormal data,
It is no longer participate in rolling reconciliation, and artificial treatment is needed to check, or carries out the processing operation of next step by system.
Further, it is further comprised the steps of: after the completion of reconciliation task execution and generates the abnormal notice for including at least abnormal data
Reconciliation result form, show reconciliation result in detail, comprising: reconciliation serial number, reconciliation date, the total stroke count of reconciliation success, reconciliation
Success total amount, the total stroke count of reconciliation failure, reconciliation failure total amount, reconciliation success detail and file, reconciliation failure detail and text
Part etc..
The flexible configuration of reconciliation information may be implemented in above-mentioned account checking method, carries out data source and right by visual page
The configuration of the reconciliations such as account period information allows system to carry out data reconciliation automatically according to configured reconciliation information, is not necessarily to people
Work intervention or research and development hard coded, also improve reconciliation flexibility；And the rolling reconciliation of the second class billing data may be implemented, make
Second class billing data continues to participate in the comparison in the period of reconciliation below after current reconciliation end cycle, realizes because the time difference generates
The data that leave a question open automatically carry out rolling reconciliation, handled without artificial participation, improve reconciliation efficiency and precision.
The embodiment of the present invention also provides a kind of reconciliation system.Referring to shown in Fig. 3, reconciliation system of the invention includes configuration mould
Block 10, task execution module 20, result display module 30 etc..Wherein configuration module 10 is matched for providing reconciliation information visuallization
Set window, the configuration of reconciliation information includes at least described in above-mentioned account checking method embodiment to the configuration of the data source of reconciliation and right
The configuration in account period.Task execution module 20 is used for the reconciliation period according to configuration, periodically carries out reconciliation task, specific to wrap
It includes:
Reconciliation data obtaining module 220, for obtaining the first data source, the second data source and current the reconciliation week to reconciliation
Phase.For example, reconciliation data obtaining module 220 can be used for executing step S220 described in above-mentioned any account checking method embodiment.
Comparison data obtains module 230, for obtaining current reconciliation week from the first data source and the second data source respectively
Each billing data in phase generates the first tables of data and the second tables of data.It can be used for for example, comparison data obtains module 230
Execute step S230 described in above-mentioned any account checking method embodiment.
Rolling data obtain module 240, for traversing data cached table, will belong in data cached table the first data source and
The billing data of second data source moves to the first tables of data and the second tables of data respectively.For example, rolling data acquisition module 240 can
For executing step S240 described in above-mentioned any account checking method embodiment.
Screening module 250 is compared to filter out for comparing each billing data in the first tables of data and the second tables of data
Correspondence is present in the first tables of data and the second tables of data but unmatched first kind billing data, as abnormal data；And it screens
The the second class billing data for existing only in the first tables of data or the second tables of data out is stored in data cached table at least to supply lower a pair
The comparison in account period.For example, comparing screening module 250 can be used for executing step described in above-mentioned any account checking method embodiment
S250。
As a result 30 main presentation reconciliation result form of display module.Reconciliation system can also include dealing of abnormal data module
Deng specifically can be by user configuration.
Above-mentioned reconciliation system realizes the flexible configuration of reconciliation information by configuration module 10, is carried out by visual page
The configuration of the reconciliations information such as data source and reconciliation period allows system to carry out data pair automatically according to configured reconciliation information
Account also improves reconciliation flexibility without manpower intervention or research and development hard coded.Bill number is realized by task execution module 20
According to automatic comparison, and realize the second class billing data rolling reconciliation, tie the second class billing data in the current reconciliation period
The comparison in the period of reconciliation below is continued to participate in after beam, is realized because the data that leave a question open that the time difference generates automatically carry out rolling reconciliation,
It is handled without manually participation, improves reconciliation efficiency and precision.And the detailed exhibition of reconciliation result is realized by result display module 30
Show.
The embodiment of the present invention also provides a kind of computer equipment, including processor and memory, and being stored in memory can
It executes instruction, processor is configured as via execution executable instruction come the step of executing the account checking method in above-described embodiment.
As described above, computer equipment of the invention can be realized the flexible configuration of reconciliation information, pass through visual page
The configuration for carrying out the reconciliations information such as data source and reconciliation period, counts system automatically according to configured reconciliation information
Reconciliation flexibility is also improved without manpower intervention or research and development hard coded according to reconciliation；And the second class billing data may be implemented
Rolling reconciliation, so that the second class billing data is continued to participate in the comparison in the period of reconciliation below after current reconciliation end cycle, it is real
It now because the data that leave a question open that the time difference generates automatically carry out rolling reconciliation, is handled without artificial participation, improves reconciliation efficiency and essence
Degree.
Fig. 4 is the structural schematic diagram of computer equipment in the embodiment of the present invention, it should be appreciated that Fig. 4 is only to illustrate
Modules are shown to property, these modules can be virtual software module or actual hardware module, the merging of these modules,
Fractionation and its increase of complementary modul block are all within protection scope of the present invention.
Person of ordinary skill in the field it is understood that various aspects of the invention can be implemented as system, method or
Program product.Therefore, various aspects of the invention can be embodied in the following forms, it may be assumed that complete hardware embodiment, complete
The embodiment combined in terms of full Software Implementation (including firmware, microcode etc.) or hardware and software, can unite here
Referred to as " circuit ", " module " or " platform ".
Computer equipment 400 of the invention is described referring to Fig. 4.The computer equipment 400 that Fig. 4 is shown is only one
A example, should not function to the embodiment of the present invention and use scope bring any restrictions.
As shown in figure 4, computer equipment 400 is showed in the form of universal computing device.The component of computer equipment 400 can
With include but is not limited to: at least one processing unit 410, at least one storage unit 420, connection different platform component (including
Storage unit 420 and processing unit 410) bus 430, display unit 440 etc..
Wherein, storage unit is stored with program code, and program code can be executed with unit 410 processed, so that processing is single
Member 410 executes the step of account checking method described in above-described embodiment.For example, processing unit 410 can be executed such as Fig. 1 and Fig. 2
Shown step.
Storage unit 420 may include the readable medium of volatile memory cell form, such as Random Access Storage Unit
(RAM) 4201 and/or cache memory unit 4202, it can further include read-only memory unit (ROM) 4203.
Storage unit 420 can also include program/utility with one group of (at least one) program module 4205
4204, such program module 4205 includes but is not limited to: operating system, one or more application program, other program moulds
It may include the realization of network environment in block and program data, each of these examples or certain combination.
Bus 430 can be to indicate one of a few class bus structures or a variety of, including storage unit bus or storage
Cell controller, peripheral bus, graphics acceleration port, processing unit use any bus structures in a variety of bus structures
Local bus.
Computer equipment 400 can also be with one or more external equipments 500 (such as keyboard, sensing equipment, bluetooth equipment
Deng) communication, can also be enabled a user to one or more equipment interact with the computer equipment 400 communicate, and/or with make
The computer equipment 400 can with it is one or more of the other calculating equipment be communicated any equipment (such as router, modulation
Demodulator etc.) communication.This communication can be carried out by input/output (I/O) interface 450.Also, computer equipment 400
Network adapter 460 and one or more network (such as local area network (LAN), wide area network (WAN) and/or public affairs can also be passed through
Common network network, such as internet) communication.Network adapter 460 can pass through other modules of bus 430 and computer equipment 400
Communication.It should be understood that although not shown in the drawings, can in conjunction with computer equipment 400 use other hardware and/or software module,
Including but not limited to: microcode, device driver, redundant processing unit, external disk drive array, RAID system, tape drive
Dynamic device and data backup storage platform etc..
The embodiment of the present invention also provides a kind of computer readable storage medium, and for storing program, program is performed reality
The step of account checking method of existing above-described embodiment description.In some possible embodiments, various aspects of the invention may be used also
In the form of being embodied as a kind of program product comprising program code, when program product is run on the terminal device, program generation
The step of code is for making terminal device execute the account checking method of above-described embodiment description.
As described above, computer readable storage medium of the invention can be realized the flexible configuration of reconciliation information, by can
Depending on change the page carry out the reconciliations information such as data source and reconciliation period configuration, allow system according to configured reconciliation information from
It is dynamic to carry out data reconciliation, without manpower intervention or research and development hard coded, also improve reconciliation flexibility；And the second class may be implemented
The rolling reconciliation of billing data makes the second class billing data continue to participate in the period of reconciliation below after current reconciliation end cycle
It compares, realizes because the data that leave a question open that the time difference generates automatically carry out rolling reconciliation, handled without artificial participation, improve reconciliation effect
Rate and precision.
Fig. 5 is the structural schematic diagram of computer readable storage medium of the invention.Refering to what is shown in Fig. 5, describing according to this
The program product 600 for realizing the above method of the embodiment of invention can use the read-only storage of portable compact disc
Device (CD-ROM) and including program code, and can be run on terminal device, such as PC.However, journey of the invention
Sequence product is without being limited thereto, and in this document, readable storage medium storing program for executing can be any tangible medium for including or store program, the journey
Sequence can be commanded execution system, device or device use or in connection.
Program product can be using any combination of one or more readable mediums.Readable medium can be readable signal Jie
Matter or readable storage medium storing program for executing.Readable storage medium storing program for executing for example can be but be not limited to electricity, magnetic, optical, electromagnetic, infrared ray or partly lead
System, device or the device of body, or any above combination.More specific example (the non exhaustive column of readable storage medium storing program for executing
Table) it include: the electrical connection with one or more conducting wires, portable disc, hard disk, random access memory (RAM), read-only storage
Device (ROM), erasable programmable read only memory (EPROM or flash memory), optical fiber, portable compact disc read only memory (CD-
ROM), light storage device, magnetic memory device or above-mentioned any appropriate combination.
Computer readable storage medium may include in a base band or as carrier wave a part propagate data-signal,
In carry readable program code.The data-signal of this propagation can take various forms, including but not limited to electromagnetic signal,
Optical signal or above-mentioned any appropriate combination.Readable storage medium storing program for executing can also be any readable Jie other than readable storage medium storing program for executing
Matter, the readable medium can send, propagate or transmit for by instruction execution system, device or device use or and its
The program of combined use.The program code for including on readable storage medium storing program for executing can transmit with any suitable medium, including but not
It is limited to wireless, wired, optical cable, RF etc. or above-mentioned any appropriate combination.
The program for executing operation of the present invention can be write with any combination of one or more programming languages
Code, programming language include object oriented program language-Java, C++ etc., further include conventional process
Formula programming language-such as " C " language or similar programming language.Program code can be calculated fully in user
It executes in equipment, partly execute on a user device, executing, as an independent software package partially in user calculating equipment
Upper part executes on a remote computing or executes in remote computing device or server completely.It is being related to remotely counting
In the situation for calculating equipment, remote computing device can pass through the network of any kind, including local area network (LAN) or wide area network
(WAN), it is connected to user calculating equipment, or, it may be connected to external computing device (such as utilize ISP
To be connected by internet).
The above content is a further detailed description of the present invention in conjunction with specific preferred embodiments, and it cannot be said that
Specific implementation of the invention is only limited to these instructions.For those of ordinary skill in the art to which the present invention belongs, exist
Under the premise of not departing from present inventive concept, a number of simple deductions or replacements can also be made, all shall be regarded as belonging to of the invention
Protection scope.
Claims (11)
1. a kind of account checking method, which is characterized in that according to the reconciliation period of configuration, periodically carry out reconciliation task, comprising:
It obtains to the first data source of reconciliation, the second data source and current reconciliation period；
Respectively from each bill number obtained in first data source and second data source in the current reconciliation period
According to the first tables of data of generation and the second tables of data；
Data cached table is traversed, the bill of first data source and second data source will be belonged in the data cached table
Data move to first tables of data and second tables of data respectively；
Each billing data in first tables of data and second tables of data is compared, filters out and corresponding is present in described the
One tables of data and second tables of data but unmatched first kind billing data, as abnormal data；And filter out there is only
In the second class billing data of first tables of data or second tables of data, the data cached table is stored at least to supply down
The comparison in one reconciliation period.
2. account checking method as described in claim 1, which is characterized in that further include:
Screening periodically is carried out to the billing data in the data cached table；
The billing data that number is more than preset value is compared when existing in the data cached table, then using the billing data as abnormal
Data remove the data cached table.
3. account checking method as described in claim 1, which is characterized in that every billing data includes transaction journal number and hands over
The easy amount of money, the first kind billing data are that transaction journal number is existed simultaneously in first tables of data and second tables of data
But the different billing data of transaction amount, the second class billing data are that transaction journal number exists only in first tables of data
Or the billing data of second tables of data.
4. account checking method as claimed in claim 3, which is characterized in that described to compare first tables of data and second number
According to each billing data in table, comprising:
Parse each billing data in first tables of data and second tables of data；
With each bill that the transaction journal number is in mark traversal comparison first tables of data and second tables of data
Data search the first kind billing data and the second class billing data.
5. account checking method as claimed in claim 4, which is characterized in that carry out bill using SQL-join or Redis-sdiff
The traversal of data compares.
6. account checking method as described in claim 1, which is characterized in that the reconciliation period according to configuration, periodically hold
Before row reconciliation task, further includes:
The reconciliation information for obtaining configuration, periodically generates reconciliation task, and the reconciliation information includes at least the data to reconciliation
Source and reconciliation period.
7. account checking method as described in claim 1, which is characterized in that further include:
Generate the reconciliation result form notified extremely for including at least the abnormal data.
8. a kind of reconciliation system, which is characterized in that including periodically carrying out reconciliation task for the reconciliation period according to configuration
Task execution module, the task execution module includes:
Reconciliation data obtaining module, for obtaining the first data source to reconciliation, the second data source and current reconciliation period；
Comparison data obtains module, described current right for obtaining from first data source and second data source respectively
Each billing data in the account period generates the first tables of data and the second tables of data；
Rolling data, which obtains module, will belong to first data source for traversing data cached table in the data cached table
First tables of data and second tables of data are moved to respectively with the billing data of second data source；And
Screening module is compared, for comparing each billing data in first tables of data and second tables of data, is screened
Correspondence is present in first tables of data and second tables of data but unmatched first kind billing data out, as abnormal number
According to；And the second class billing data for existing only in first tables of data or second tables of data is filtered out, it is stored in described slow
Deposit data table is at least for the comparison in next reconciliation period.
9. reconciliation system as claimed in claim 8, which is characterized in that further include:
Configuration module, is used to provide the described the reconciliation information visuallization configuration page, and the configuration of the reconciliation information includes at least
The configuration and the configuration in reconciliation period of data source to reconciliation.
10. a kind of computer equipment characterized by comprising
Processor；
Memory, wherein being stored with the executable instruction of the processor；
Wherein, the processor be configured to via execute the executable instruction come perform claim require it is 1 to 7 described in any item
The step of account checking method.
11. a kind of computer readable storage medium, for storing program, which is characterized in that described program is performed realization power
Benefit requires the step of 1 to 7 described in any item account checking methods.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910591328.8A CN110287200B (en) | 2019-07-02 | 2019-07-02 | Account checking method, account checking system, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910591328.8A CN110287200B (en) | 2019-07-02 | 2019-07-02 | Account checking method, account checking system, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110287200A true CN110287200A (en) | 2019-09-27 |
| CN110287200B CN110287200B (en) | 2022-03-25 |
Family
ID=68021761
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910591328.8A Active CN110287200B (en) | 2019-07-02 | 2019-07-02 | Account checking method, account checking system, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110287200B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111325617A (en) * | 2020-01-22 | 2020-06-23 | 北京开科唯识技术有限公司 | File-based account checking method and device, computer equipment and readable storage medium |
| CN112037003A (en) * | 2020-09-17 | 2020-12-04 | 中国银行股份有限公司 | File account checking processing method and device |
| CN112162976A (en) * | 2020-09-29 | 2021-01-01 | 北京锐安科技有限公司 | Data reconciliation method, device, equipment and storage medium |
| CN112597246A (en) * | 2020-12-25 | 2021-04-02 | 中国农业银行股份有限公司 | Method, device and system for maintaining data consistency |
| CN112732733A (en) * | 2020-12-31 | 2021-04-30 | 中国工商银行股份有限公司 | Data checking processing method and device |
| CN113342857A (en) * | 2021-06-28 | 2021-09-03 | 北京三快在线科技有限公司 | Transaction record checking method and device, electronic equipment and storage medium |
| CN113591446A (en) * | 2021-06-29 | 2021-11-02 | 四川新网银行股份有限公司 | Configuration reconciliation file generation device |
| WO2024055779A1 (en) * | 2022-09-15 | 2024-03-21 | 支付宝(杭州)信息技术有限公司 | Bill processing method and apparatus |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020026416A1 (en) * | 2000-08-25 | 2002-02-28 | Provinse Shirely J. | System and method for account reconciliation |
| US20120102015A1 (en) * | 2010-10-21 | 2012-04-26 | Rillip Inc | Method and System for Performing a Comparison |
| CN104156832A (en) * | 2014-08-28 | 2014-11-19 | 国家电网公司 | Intersystem data verification method and device |
| CN104462568A (en) * | 2014-12-26 | 2015-03-25 | 山东中创软件商用中间件股份有限公司 | Data reconciliation method, device and system |
| CN104750703A (en) * | 2013-12-26 | 2015-07-01 | 中国移动通信集团天津有限公司 | Method and device for improving data accuracy |
| CN105786911A (en) * | 2014-12-25 | 2016-07-20 | 阿里巴巴集团控股有限公司 | Application data checking method and device |
| CN107798109A (en) * | 2017-11-01 | 2018-03-13 | 深圳市牛鼎丰科技有限公司 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
-
2019
- 2019-07-02 CN CN201910591328.8A patent/CN110287200B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020026416A1 (en) * | 2000-08-25 | 2002-02-28 | Provinse Shirely J. | System and method for account reconciliation |
| US20120102015A1 (en) * | 2010-10-21 | 2012-04-26 | Rillip Inc | Method and System for Performing a Comparison |
| CN104750703A (en) * | 2013-12-26 | 2015-07-01 | 中国移动通信集团天津有限公司 | Method and device for improving data accuracy |
| CN104156832A (en) * | 2014-08-28 | 2014-11-19 | 国家电网公司 | Intersystem data verification method and device |
| CN105786911A (en) * | 2014-12-25 | 2016-07-20 | 阿里巴巴集团控股有限公司 | Application data checking method and device |
| CN104462568A (en) * | 2014-12-26 | 2015-03-25 | 山东中创软件商用中间件股份有限公司 | Data reconciliation method, device and system |
| CN107798109A (en) * | 2017-11-01 | 2018-03-13 | 深圳市牛鼎丰科技有限公司 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111325617B (en) * | 2020-01-22 | 2021-05-28 | 北京开科唯识技术股份有限公司 | File-based account checking method and device, computer equipment and readable storage medium |
| CN111325617A (en) * | 2020-01-22 | 2020-06-23 | 北京开科唯识技术有限公司 | File-based account checking method and device, computer equipment and readable storage medium |
| CN112037003A (en) * | 2020-09-17 | 2020-12-04 | 中国银行股份有限公司 | File account checking processing method and device |
| CN112162976A (en) * | 2020-09-29 | 2021-01-01 | 北京锐安科技有限公司 | Data reconciliation method, device, equipment and storage medium |
| WO2022068316A1 (en) * | 2020-09-29 | 2022-04-07 | 北京锐安科技有限公司 | Data reconciliation method and apparatus, device, and storage medium |
| CN112597246A (en) * | 2020-12-25 | 2021-04-02 | 中国农业银行股份有限公司 | Method, device and system for maintaining data consistency |
| CN112597246B (en) * | 2020-12-25 | 2024-04-12 | 中国农业银行股份有限公司 | Method, device and system for maintaining data consistency |
| CN112732733B (en) * | 2020-12-31 | 2024-02-09 | 中国工商银行股份有限公司 | Data checking processing method and device |
| CN112732733A (en) * | 2020-12-31 | 2021-04-30 | 中国工商银行股份有限公司 | Data checking processing method and device |
| CN113342857A (en) * | 2021-06-28 | 2021-09-03 | 北京三快在线科技有限公司 | Transaction record checking method and device, electronic equipment and storage medium |
| CN113342857B (en) * | 2021-06-28 | 2022-09-16 | 北京三快在线科技有限公司 | Transaction record checking method and device, electronic equipment and storage medium |
| CN113591446B (en) * | 2021-06-29 | 2023-11-03 | 四川新网银行股份有限公司 | Configurational account checking file generating device |
| CN113591446A (en) * | 2021-06-29 | 2021-11-02 | 四川新网银行股份有限公司 | Configuration reconciliation file generation device |
| WO2024055779A1 (en) * | 2022-09-15 | 2024-03-21 | 支付宝(杭州)信息技术有限公司 | Bill processing method and apparatus |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110287200B (en) | 2022-03-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110287200A (en) | Account checking method, system, computer equipment and storage medium | |
| CN105335412B (en) | For data conversion, the method and apparatus of Data Migration | |
| CN103426070B (en) | Compilation method and device of group combined financial statement | |
| CN103391311B (en) | A kind of multi-platform between the method and system of consistency verification of data | |
| CN107273556A (en) | Block chain data index method and equipment | |
| CN109584031A (en) | Account checking method, device, electronic equipment and computer-readable medium | |
| US20130066775A1 (en) | Apparatus, method, and computer program product for data cleansing and/or biller scrubbing | |
| CN103310311A (en) | Electric charge finance management system and account checking method | |
| CN102663650A (en) | System for analyzing enterprise credit risk and application method thereof | |
| CN105335207A (en) | Method and apparatus for managing virtual machine instance | |
| CN108520008A (en) | The construction method and construction device of data warehouse model | |
| CN104636130B (en) | For generating the method and system of event tree | |
| US20160154840A1 (en) | Avoid double counting of mapped database data | |
| CN110084682A (en) | Order audits settlement method, system, equipment and storage medium | |
| Grimsey et al. | PFI in the NHS | |
| Xu et al. | Evaluating and prioritizing the carbon credit financing risks and strategies for sustainable carbon markets in China | |
| CN104200324A (en) | Business knowledge management based configuration management method | |
| CN104766240A (en) | Electronic banking data processing system and method | |
| CN112417060A (en) | Method, device, equipment and computer readable medium for identifying enterprise relationship | |
| CN105988911A (en) | Establishing a chain of trust in a system log | |
| Hallinan et al. | Review and demonstration of the potential of bitcoin mining as a productive use of energy (PUE) to aid equitable investment in solar micro-and mini-grids worldwide | |
| CN108876577A (en) | The system that multilingual mobile visualization collects processing information | |
| CN116194908A (en) | Optimizing automatic selection of machine learning pipelines using meta-learning | |
| CN107807992A (en) | Barcode scanning multiplies public transport payment system | |
| CN109102319A (en) | Plate index preparation method, device and the server of block chain cryptographic assets |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20220303 Address after: No.123, Kaifa Avenue, Guiyang Economic and Technological Development Zone, 550000, Guizhou Province Applicant after: GUIYANG HUOCHEBANG TECHNOLOGY CO.,LTD. Address before: 210012 3-5 / F, building 4, 170-1 software Avenue, Yuhuatai District, Nanjing City, Jiangsu Province Applicant before: JIANGSU MANYUN SOFTWARE TECHNOLOGY Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| EE01 | Entry into force of recordation of patent licensing contract |
Application publication date: 20190927 Assignee: Nanjing Manyun Cold Chain Technology Co.,Ltd. Assignor: GUIYANG HUOCHEBANG TECHNOLOGY CO.,LTD. Contract record no.: X2023310000141 Denomination of invention: Reconciliation methods, systems, computer equipment, and storage media Granted publication date: 20220325 License type: Common License Record date: 20230802 |
|
| EE01 | Entry into force of recordation of patent licensing contract |