CN109360086A - Method and apparatus based on bank statement data auto-complete accounting data - Google Patents
Method and apparatus based on bank statement data auto-complete accounting data Download PDFInfo
- Publication number
- CN109360086A CN109360086A CN201811142578.5A CN201811142578A CN109360086A CN 109360086 A CN109360086 A CN 109360086A CN 201811142578 A CN201811142578 A CN 201811142578A CN 109360086 A CN109360086 A CN 109360086A
- Authority
- CN
- China
- Prior art keywords
- bill
- reconciliation
- data
- bank statement
- structural data
- 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
- 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/02—Banking, e.g. interest calculation or account maintenance
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V20/00—Scenes; Scene-specific elements
- G06V20/60—Type of objects
- G06V20/62—Text, e.g. of license plates, overlay texts or captions on TV images
- G06V20/63—Scene text, e.g. street names
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
- G06V30/10—Character recognition
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The present invention relates to a kind of methods based on bank statement data auto-complete accounting data, first identification business bill image, extract billing information and generate bill structural data；Bank statement is uploaded again, and the key message extracted on bank statement generates bank statement structural data, carries out automatic reconciliation process with the bill structural data, generates for showing the whether successful reconciliation preview of reconciliation；Whether correct accountant checks the reconciliation preview later；It by this bill recording mark is " reconciliation " if correct, as incorrect, error reason is verified, it does not keep accounts because the amount of money is small and loses the mistake generated with document, by after bank statement auto-complete document by this bill recording mark be " reconciliation ", it does not keep accounts because of bank or the mistake for generation of not entering an item of expenditure in the accounts, is then " not-upto-account " by this bill recording mark；Bill record after finally including label, automatically generates bank balance adjusting table, completes reconciliation.
Description
Technical field
The present invention relates to a kind of method and apparatus based on bank statement data auto-complete accounting data, belong to property tax
Intelligent field.
Background technique
Traditional bank statement reconciliation process is limited to technical reason, and handwork situation is relatively more and verification checking procedure is superfluous
Length is cumbersome.
Specific operation process is as shown in Figure 1, obtain bank statement (papery, PDF document or EXCEL text from bank first
Shelves), it secondly completes accounting processing and arranges " bank account journal " and last bank's not-upto-account record, manual alignment " bank's reconciliation
It is single " it records with " bank account journal ", last not-upto-account, while meeting the record of the following conditions, ticking is identified as " reconciliation ":
(1) check number or serial number are identical；(2) it borrows, credit side is to identical；(3) amount of money is identical；(4) date identical (depending on enterprise, has
Condition does not judge by date a bit).
For the record unmatched, reason is checked:
(1) enterprise has paid or payment received, the record that bank does not keep accounts or enters an item of expenditure in the accounts are identified as " not-upto-account "；(2) amount of debit side is less than
1 record, generally agio bank commission are worked out " expense list " manually and are recorded separately；(3) the case where business paper lacks, supplement system
Business paper and entry.
After the completion of reconciliation, " bank balance adjusting table " is worked out manually, the above process disadvantage:
(1) manual alignment, heavy workload and easy error；(2) reason is checked, business invoice is if desired checked, needs in whole heap
It searches and compares in original invoice, low efficiency；(3) business paper lacks, document amended record heavy workload；(4) " bank balance tune is worked out
Save table " heavy workload, it is easy error.
Summary of the invention
In order to solve above-mentioned problems of the prior art, the present invention provides a kind of automatic based on bank statement data
The method and apparatus of completion accounting data is given technical support in key link and is made from process of the reconciliation business itself
Reconciliation more automates, intelligent.
Technical solution of the present invention one:
A method of based on bank statement data auto-complete accounting data, comprising the following steps:
Identification business bill image extracts billing information and generates bill structural data；
Bank statement is uploaded, the key message on bank statement is extracted and generates bank statement structural data, and it is described
Bill structural data carries out automatic reconciliation process, generates for showing the whether successful reconciliation preview of reconciliation；
Whether accountant checks the reconciliation preview correct, by this bill recording mark is " reconciliation " if correct；If not
Correctly, then it verifies error reason: not keeping accounts because the amount of money is small and lose the mistake generated with document, pass through bank statement auto-complete
By this bill recording mark it is " reconciliation " after document, does not keep accounts or the mistake for generation of not entering an item of expenditure in the accounts, then remember this bill because of bank
Record mark is " not-upto-account "；
Bill record after including label, automatically generates bank balance adjusting table, completes reconciliation.
Further, the business bill image passes through OCR optical character recognition reader scanning recognition；The bill structuring
Data include bill main information structural data and bill detail structural data, and the bill main information structural data is ticket
According to main information；The bill detail structural data is the detail accounting data under bill.
Further, steps are as follows for the automatic reconciliation: by the bank statement structural data and bill structuring
Whether each key message in data is compared one by one, while being kept accounts by logic matching judgment bank statement；Judgement
The reconciliation preview is generated after the completion；
Carry out logic matching when, according to the significance level of each key message by each key message carry out gradient sequence, from up to
Under be divided into the first key message, second the n-th key message of key message ..., when carrying out logic matching, from the first key message
Start to judge, judge again to judge the second key message in next step if you need to carry out, and so on, finally matched according to logic
Arithmetic logic judge whether bank statement keeps accounts.
Further, after the reconciliation preview generates, by the correspondence business bill image of identification and the corresponding reconciliation
It is former to find corresponding business bill image based on the business bill image address information stored in structural data for preview association
Beginning picture further checks whether reconciliation has mistakes and omissions in the process.
Technical solution of the present invention two:
A kind of equipment based on bank statement data auto-complete accounting data, including memory and processor, the storage
Device is stored with instruction, and described instruction is suitable for being loaded by processor and executing following steps:
Identification business bill image extracts billing information and generates bill structural data；
Bank statement is uploaded, the key message on bank statement is extracted and generates bank statement structural data, and it is described
Bill structural data carries out automatic reconciliation process, generates for showing the whether successful reconciliation preview of reconciliation；
Whether accountant checks the reconciliation preview correct；It by this bill recording mark is " reconciliation " if correct, if not
It is correct then verify error reason, it does not keep accounts because the amount of money is small and loses the mistake generated with document, pass through bank statement auto-complete
By this bill recording mark it is " reconciliation " after document, does not keep accounts or the mistake for generation of not entering an item of expenditure in the accounts, then remember this bill because of bank
Record mark is " not-upto-account "；
Bill record after including label, automatically generates bank balance adjusting table, completes reconciliation.
Further, the business bill image passes through OCR optical character recognition reader scanning recognition；The bill structuring
Data include bill main information structural data and bill detail structural data, and the bill main information structural data is ticket
According to main information；The bill detail structural data is the detail accounting data under bill.
Further, steps are as follows for the automatic reconciliation: by the bank statement structural data and bill structuring
Whether each key message in data is compared one by one, while being kept accounts by logic matching judgment bank statement；Judgement
The reconciliation preview is generated after the completion；
Carry out logic matching when, according to the significance level of each key message by each key message carry out gradient sequence, from up to
Under be divided into the first key message, second the n-th key message of key message ..., when carrying out logic matching, from the first key message
Start to judge, judge again to judge the second key message in next step if you need to carry out, and so on, finally matched according to logic
Arithmetic logic judge whether bank statement keeps accounts.
Further, after the reconciliation preview generates, by the correspondence business bill image of identification and the corresponding reconciliation
It is former to find corresponding business bill image based on the business bill image address information stored in structural data for preview association
Beginning picture further checks whether reconciliation has mistakes and omissions in the process.
The invention has the following beneficial effects:
1, the accounting data of nominal value is carried out structure by identifying to bank statement and business bill image by the present invention
Change, automatic comparison is carried out to bill structural data and bank statement structural data, to complete oneself of bank statement
Whether dynamicization reconciliation, can extrapolate whether bank statement " keeps accounts " in accounting data, namely reconciliation, automatically
Reconciliation will be account personnel and free from manual reconciliation, i.e. promotion working efficiency, the accuracy rate of reconciliation be also improved, doing account
Personnel are from manually " being account people " and be changed into this fundamental change of " the examining account people " of automatic reconciliation result this role.Because of service charge
And reconciliation failure problem caused by business paper loss, the plenty of time can be saved with auto-complete document.Silver can be automatically generated
Row balance reconciliation sheet saves artificial compilation process.
2, during automatic reconciliation, by each pass in the bank statement structural data and bill structural data
Key information carries out gradient sequence, when carrying out logic matching, according to gradient being compared from top to bottom, improves the work of automatic reconciliation
Make efficiency and accuracy.
3, the correspondence business bill image of identification is associated with corresponding reconciliation preview, it can be same when auditing reconciliation preview
When check the raw video of business bill, so as to further auxiliary kernel to whether having mistakes and omissions during reconciliation.
Detailed description of the invention
Fig. 1 is existing traditional bank statement reconciliation flow chart；
Fig. 2 is reconciliation flow chart of the invention；
Fig. 3 is the schematic diagram of present invention identification bill；
Fig. 4 is the schematic diagram that bank balance of the present invention adjusts table；
Fig. 5 is the flow chart of the embodiment of the invention.
Specific embodiment
It is next in the following with reference to the drawings and specific embodiments that the present invention will be described in detail.
Embodiment one
Referring to figs. 2 and 3, a method of based on bank statement data auto-complete accounting data, comprising the following steps:
Identification business bill image extracts billing information and generates bill structural data, and structural data includes the main of bill
Information and bill detail.
Bank statement is uploaded, the key message extracted on bank statement generates bank statement structural data, with
The bill structural data carries out automatic reconciliation process, generates for showing the whether successful reconciliation preview of reconciliation.
Whether accountant's verification reconciliation preview is correct, clicks label select button in operation interface if correct,
It is " reconciliation " by this bill recording mark；As incorrect, then verify error reason: not keeping accounts to lose with document because the amount of money is small produces
Raw mistake is recorded this bill by clicking label select button in operation interface after bank statement auto-complete document
Labeled as " reconciliation ", for example: the document of the small amount of money such as parking fee, service charge or the recording rules of enterprise may be led
It causes the unexpected of some small expenses or other fees to lose, leads to not with the Flow Record of the company of banker's record to upper account,
It is not embodied in the bill for the logging system that existing enterprise side is had by oneself, still, these expenses of enterprise side really have
Expenditure, if not doing cost subject, actual expenses and bank statement be not just on, so for convenience and bank pair
Bill can automatically generate the expense document actually having to upper account.The step is really: enterprise side is practical expense
Expenditure, but the logging system that enterprise side is had by oneself is not kept accounts (amount of money is too small), but core account is needed again, pass through above-mentioned automatic benefit
It the step of full document, can be to avoid this problem；It does not keep accounts or the mistake for generation of not entering an item of expenditure in the accounts, is then clicked in operation interface because of bank
Select button is marked, is " not-upto-account " by this bill recording mark.
Bill record after including label, automatically generates bank balance adjusting table, completes reconciliation.Bank account balance is adjusted
Table has respectively been received plus other side, the non-receipt on account item number of our unit on the basis of balance per bank statement and corporate book balance
Volume, the accounts number that subtracts that other side is paid, our unit is unpaid make a kind of its consistent adjusting method to adjust both sides' remaining sum.Bank
Balance of deposits adjusting table can be used as the attached column data of cash in banks section purpose and save.The table main purpose is to be to check enterprise's account
With the difference of bank account, it is also used for checking the mistake of enterprise and bank account.Remaining sum after adjusting is enterprise's reconciliation day silver
The actually available credit of row.
The present embodiment is mainly by carrying out intelligent recognition for bank statement and business paper image, by the account of nominal value
Data carry out structuring processing (referring to Fig. 3, Fig. 3 is the legend that bill image is converted to structural data process), then right
Bill structural data and bank statement structural data carry out automatic comparison, to complete the automation pair of bank statement
Whether account, can extrapolate whether bank statement " keeps accounts " in accounting data, namely reconciliation, and automatic reconciliation will
Account personnel are to free from manual reconciliation, i.e., promotion working efficiency, also improve the accuracy rate of reconciliation, be account personnel from
It manually " is account people " and is changed into this fundamental change of " the examining account people " of automatic reconciliation result this role.Because of service charge and business
Reconciliation failure problem caused by document is lost can save the plenty of time with auto-complete document.Bank balance can be automatically generated
Table is adjusted, artificial compilation process is saved.
Embodiment two
This gives a kind of preferably embodiments of the invention, improve the efficiency of reconciliation.
Referring to fig. 2-5, the business bill image passes through OCR optical character recognition reader scanning recognition；The bill structure
Changing data includes bill main information structural data and bill detail structural data, and the bill main information structural data is
The main information of bill, main information include Business Name, check number, the date of invoice, invoice total；The bill detail knot
Structure data are the detail accounting data under bill, including detail number, amount of money direction, the detail amount of money.
Further, steps are as follows for the automatic reconciliation: by the bank statement structural data and bill structuring
Each key message in data is compared one by one, and in the present embodiment, key message includes amount of money direction, check number, invoice
Date and amount of money detail, while whether being kept accounts by logic matching judgment bank statement；It is described right to generate after the completion of judgement
Account preview；
Carry out logic matching when, according to the significance level of each key message by each key message carry out gradient sequence, from up to
Under be divided into the first key message, second the n-th key message of key message ..., when carrying out logic matching, from the first key message
Start to judge, judges again to judge the second key message in next step if you need to carry out；As shown in figure 5, first determining whether amount of money side
It is not identical directly to mark reconciliation state STATUS=0 to whether unanimously judging whether amount of money direction is identical；Judge check number
Whether Cheque No is identical；If check number Cheque No is identical, the bill detail and account voucher of identical check number are judged
Whether identical record separately the detail amount of money, amount of money same tag reconciliation state STATUS=1, the amount of money not same tag reconciliation state
STATUS=0；Check number Cheque No is if it is not the same, judge whether the date of invoice is identical；The date of invoice is identical, judges identical
Whether the bill detail and the account Accounting entry detail amount of money of check number are identical, amount of money same tag reconciliation state STATUS=1,
The amount of money not same tag reconciliation state STATUS=0；STATUS=1 indicates reconciliation success, and STATUS=0 indicates reconciliation failure.
Further, after the reconciliation preview generates, by the correspondence business bill image of identification and the corresponding reconciliation
Preview association, association are primarily referred to as: the structural data of bill image can be based on depositing in structural data after the completion of reconciliation
The bill image address information of storage finds corresponding bill image original image, so as to further auxiliary kernel to reconciliation process
In whether have mistakes and omissions.
This implementation not only has the beneficial effect of embodiment one, also according to key message significance level by each key message
Gradient sequence is carried out, so that logic matching step is more accurate；Business bill image is associated with the corresponding reconciliation preview,
Keep accounting audit more convenient.
Embodiment three
Referring to Fig. 1, a kind of equipment based on bank statement data auto-complete accounting data, including memory and processor,
The memory is stored with instruction, and described instruction is suitable for being loaded by processor and executing following steps:
Identification business bill image extracts billing information and generates bill structural data, and structural data includes the main of bill
Information and bill detail.
Bank statement is uploaded, the key message extracted on bank statement generates bank statement structural data, with
The bill structural data carries out automatic reconciliation process, generates for showing the whether successful reconciliation preview of reconciliation.
Whether accountant's verification reconciliation preview is correct, clicks label select button in operation interface if correct,
It is " reconciliation " by this bill recording mark；As incorrect, then verify error reason: not keeping accounts to lose with document because the amount of money is small produces
Raw mistake is recorded this bill by clicking label select button in operation interface after bank statement auto-complete document
Labeled as " reconciliation ", for example: the document of the small amount of money such as parking fee, service charge or the recording rules of enterprise may be led
It causes the unexpected of some small expenses or other fees to lose, leads to not with the Flow Record of the company of banker's record to upper account,
It is not embodied in the bill for the logging system that existing enterprise side is had by oneself, still, these expenses of enterprise side really have
Expenditure, if not doing cost subject, actual expenses and bank statement be not just on, so for convenience and bank pair
Bill can automatically generate the expense document actually having to upper account.The step is really: enterprise side is practical expense
Expenditure, but the logging system that enterprise side is had by oneself is not kept accounts (amount of money is too small), but core account is needed again, pass through above-mentioned automatic benefit
It the step of full document, can be to avoid this problem；It does not keep accounts or the mistake for generation of not entering an item of expenditure in the accounts, is then clicked in operation interface because of bank
Select button is marked, is " not-upto-account " by this bill recording mark.
Bill record after including label, automatically generates bank balance adjusting table, completes reconciliation.Bank account balance is adjusted
Table has respectively been received plus other side, the non-receipt on account item number of our unit on the basis of balance per bank statement and corporate book balance
Volume, the accounts number that subtracts that other side is paid, our unit is unpaid make a kind of its consistent adjusting method to adjust both sides' remaining sum.Bank
Balance of deposits adjusting table can be used as the attached column data of cash in banks section purpose and save.The table main purpose is to be to check enterprise's account
With the difference of bank account, it is also used for checking the mistake of enterprise and bank account.Remaining sum after adjusting is enterprise's reconciliation day silver
The actually available credit of row.
The present embodiment is mainly by carrying out intelligent recognition for bank statement and business paper image, by the account of nominal value
Data carry out structuring processing (referring to Fig. 3, Fig. 3 is the legend that bill image is converted to structural data process), then right
Bill structural data and bank statement structural data carry out automatic comparison, to complete the automation pair of bank statement
Whether account, can extrapolate whether bank statement " keeps accounts " in accounting data, namely reconciliation, and automatic reconciliation will
Account personnel are to free from manual reconciliation, i.e., promotion working efficiency, also improve the accuracy rate of reconciliation, be account personnel from
It manually " is account people " and is changed into this fundamental change of " the examining account people " of automatic reconciliation result this role.Because of service charge and business
Reconciliation failure problem caused by document is lost can save the plenty of time with auto-complete document.Bank balance can be automatically generated
Table is adjusted, artificial compilation process is saved.
Example IV
This gives a kind of preferably embodiments of the invention, improve the efficiency of reconciliation.
Referring to fig. 2-5, the business bill image passes through OCR optical character recognition reader scanning recognition；The bill structure
Changing data includes bill main information structural data and bill detail structural data, and the bill main information structural data is
The main information of bill, main information include Business Name, check number, the date of invoice, invoice total；The bill detail knot
Structure data are the detail accounting data under bill, including detail number, amount of money direction, the detail amount of money.
Further, steps are as follows for the automatic reconciliation: by the bank statement structural data and bill structuring
Each key message in data is compared one by one, and in the present embodiment, key message includes amount of money direction, check number, invoice
Date and amount of money detail, while whether being kept accounts by logic matching judgment bank statement；It is described right to generate after the completion of judgement
Account preview；
Carry out logic matching when, according to the significance level of each key message by each key message carry out gradient sequence, from up to
Under be divided into the first key message, second the n-th key message of key message ..., when carrying out logic matching, from the first key message
Start to judge, judges again to judge the second key message in next step if you need to carry out；As shown in figure 5, first determining whether amount of money side
It is not identical directly to mark reconciliation state STATUS=0 to whether unanimously judging whether amount of money direction is identical；Judge check number
Whether Cheque No is identical；If check number Cheque No is identical, the bill detail and account voucher of identical check number are judged
Whether identical record separately the detail amount of money, amount of money same tag reconciliation state STATUS=1, the amount of money not same tag reconciliation state
STATUS=0；Check number Cheque No is if it is not the same, judge whether the date of invoice is identical；The date of invoice is identical, judges identical
Whether the bill detail and the account Accounting entry detail amount of money of check number are identical, amount of money same tag reconciliation state STATUS=1,
The amount of money not same tag reconciliation state STATUS=0；STATUS=1 indicates reconciliation success, and STATUS=0 indicates reconciliation failure.
Further, after the reconciliation preview generates, by the correspondence business bill image of identification and the corresponding reconciliation
Preview association, association are primarily referred to as: the structural data of bill image can be based on depositing in structural data after the completion of reconciliation
The bill image address information of storage finds corresponding bill image original image, so as to further auxiliary kernel to reconciliation process
In whether have mistakes and omissions.
This implementation not only has the beneficial effect of embodiment three, also according to key message significance level by each key message
Gradient sequence is carried out, so that logic matching step is more accurate；Business bill image is associated with the corresponding reconciliation preview,
Keep accounting audit more convenient.
The above description is only an embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skills
Art field, is included within the scope of the present invention.
Claims (8)
1. a kind of method based on bank statement data auto-complete accounting data, which comprises the following steps:
Identification business bill image extracts billing information and generates bill structural data；
Bank statement is uploaded, the key message on bank statement is extracted and generates bank statement structural data, and it is described
Bill structural data carries out automatic reconciliation process, generates for showing the whether successful reconciliation preview of reconciliation；
Whether accountant checks the reconciliation preview correct, by this bill recording mark is " reconciliation " if correct；If not
Correctly, then it verifies error reason: not keeping accounts because the amount of money is small and lose the mistake generated with document, pass through bank statement auto-complete
By this bill recording mark it is " reconciliation " after document, does not keep accounts or the mistake for generation of not entering an item of expenditure in the accounts, then remember this bill because of bank
Record mark is " not-upto-account "；
Bill record after including label, automatically generates bank balance adjusting table, completes reconciliation.
2. a kind of method based on bank statement data auto-complete accounting data according to claim 1, feature
Be: the business bill image passes through OCR optical character recognition reader scanning recognition；The bill structural data includes bill
Main information structural data and bill detail structural data, the bill main information structural data are the main letter of bill
Breath；The bill detail structural data is the detail accounting data under bill.
3. a kind of method based on bank statement data auto-complete accounting data according to claim 1, feature
Be: steps are as follows for the automatic reconciliation: by the bank statement structural data with it is each in bill structural data
Whether key message is compared one by one, while being kept accounts by logic matching judgment bank statement；Institute is generated after the completion of judgement
State reconciliation preview；
Carry out logic matching when, according to the significance level of each key message by each key message carry out gradient sequence, from up to
Under be divided into the first key message, second the n-th key message of key message ..., when carrying out logic matching, from the first key message
Start to judge, judge again to judge the second key message in next step if you need to carry out, and so on, finally matched according to logic
Arithmetic logic judge whether bank statement keeps accounts.
4. a kind of method based on bank statement data auto-complete accounting data according to claim 3, feature
It is: after the reconciliation preview generates, the correspondence business bill image of identification is associated with the corresponding reconciliation preview, is based on
The business bill image address information stored in structural data, finds corresponding business bill image original image, further
Whether there are mistakes and omissions during verification reconciliation.
5. a kind of equipment based on bank statement data auto-complete accounting data, which is characterized in that including memory and place
Device is managed, the memory is stored with instruction, and described instruction is suitable for being loaded by processor and executing following steps:
Identification business bill image extracts billing information and generates bill structural data；
Bank statement is uploaded, the key message on bank statement is extracted and generates bank statement structural data, and it is described
Bill structural data carries out automatic reconciliation process, generates for showing the whether successful reconciliation preview of reconciliation；
Whether accountant checks the reconciliation preview correct, by this bill recording mark is " reconciliation " if correct；If not
Correctly, then it verifies error reason: not keeping accounts because the amount of money is small and lose the mistake generated with document, pass through bank statement auto-complete
By this bill recording mark it is " reconciliation " after document, does not keep accounts or the mistake for generation of not entering an item of expenditure in the accounts, then remember this bill because of bank
Record mark is " not-upto-account "；
Bill record after including label, automatically generates bank balance adjusting table, completes reconciliation.
6. a kind of equipment based on bank statement data auto-complete accounting data according to claim 5, feature
Be: the business bill image passes through OCR optical character recognition reader scanning recognition；The bill structural data includes bill
Main information structural data and bill detail structural data, the bill main information structural data are the main letter of bill
Breath；The bill detail structural data is the detail accounting data under bill.
7. a kind of equipment based on bank statement data auto-complete accounting data according to claim 5, feature
Be: steps are as follows for the automatic reconciliation: by the bank statement structural data with it is each in bill structural data
Whether key message is compared one by one, while being kept accounts by logic matching judgment bank statement；Institute is generated after the completion of judgement
State reconciliation preview；
Carry out logic matching when, according to the significance level of each key message by each key message carry out gradient sequence, from up to
Under be divided into the first key message, second the n-th key message of key message ..., when carrying out logic matching, from the first key message
Start to judge, judge again to judge the second key message in next step if you need to carry out, and so on, finally matched according to logic
Arithmetic logic judge whether bank statement keeps accounts.
8. a kind of equipment based on bank statement data auto-complete accounting data according to claim 7, feature
It is: after the reconciliation preview generates, the correspondence business bill image of identification is associated with the corresponding reconciliation preview, is based on
The business bill image address information stored in structural data, finds corresponding business bill image original image, further
Whether there are mistakes and omissions during verification reconciliation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811142578.5A CN109360086A (en) | 2018-09-28 | 2018-09-28 | Method and apparatus based on bank statement data auto-complete accounting data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811142578.5A CN109360086A (en) | 2018-09-28 | 2018-09-28 | Method and apparatus based on bank statement data auto-complete accounting data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109360086A true CN109360086A (en) | 2019-02-19 |
Family
ID=65348331
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811142578.5A Pending CN109360086A (en) | 2018-09-28 | 2018-09-28 | Method and apparatus based on bank statement data auto-complete accounting data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109360086A (en) |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109919125A (en) * | 2019-03-19 | 2019-06-21 | 厦门商集网络科技有限责任公司 | Travel stroke restoring method and its system based on bank slip recognition |
| CN110109903A (en) * | 2019-04-01 | 2019-08-09 | 广州白云国际机场股份有限公司 | A kind of automatic checkout system and method for calibration of airport charges data |
| CN110348932A (en) * | 2019-05-22 | 2019-10-18 | 口碑(上海)信息技术有限公司 | Proofreading method and device, storage medium, the electronic device of order information |
| CN110866756A (en) * | 2019-11-14 | 2020-03-06 | 中国民航信息网络股份有限公司 | Checking method and system for account statement |
| CN112016893A (en) * | 2020-08-27 | 2020-12-01 | 西安热工研究院有限公司 | Account-arriving claim system and method based on project management system |
| CN112348665A (en) * | 2020-10-28 | 2021-02-09 | 北京快成科技股份公司 | Account checking method, system and device |
| CN112446773A (en) * | 2019-09-02 | 2021-03-05 | 顺丰科技有限公司 | Business non-charge data management method, device, equipment and storage medium |
| CN112465618A (en) * | 2020-12-22 | 2021-03-09 | 航天信息股份有限公司企业服务分公司 | Universal importing method and system for bank statement |
| CN112560843A (en) * | 2020-12-11 | 2021-03-26 | 中信银行股份有限公司 | Bank bill expansion method and system based on image recognition and voice recognition |
| CN112801616A (en) * | 2021-01-28 | 2021-05-14 | 中国工商银行股份有限公司 | Abnormal account book processing method and device |
| CN112950360A (en) * | 2021-03-30 | 2021-06-11 | 杭州职业技术学院 | Financial information arrangement account invoice matching method |
| CN113159859A (en) * | 2021-05-07 | 2021-07-23 | 北京京东振世信息技术有限公司 | Expense adjusting method and device |
| CN113177832A (en) * | 2021-04-29 | 2021-07-27 | 射手科技(珠海)有限公司 | Auxiliary accounting enterprise double entry bank account method and device based on artificial intelligence |
| CN113408446A (en) * | 2021-06-24 | 2021-09-17 | 成都新希望金融信息有限公司 | Bill accounting method and device, electronic equipment and storage medium |
| CN113554009A (en) * | 2021-09-22 | 2021-10-26 | 北京奇虎科技有限公司 | Bill verification method, device, equipment and storage medium |
| CN114238317A (en) * | 2021-12-03 | 2022-03-25 | 武汉联影医疗科技有限公司 | Data storage and synchronization method and device, computer equipment and storage medium |
| CN115063222A (en) * | 2022-05-26 | 2022-09-16 | 重庆银行股份有限公司 | Bank statement information processing method, computer device and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101710410A (en) * | 2009-10-28 | 2010-05-19 | 金蝶软件（中国）有限公司 | Method and system for checking accounting data |
| CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
| CN103903177A (en) * | 2012-12-26 | 2014-07-02 | 远光软件股份有限公司 | Payment account checking method and system |
| CN105630924A (en) * | 2015-12-22 | 2016-06-01 | 北京京东尚科信息技术有限公司 | Asynchronous data processing method and asynchronous data processing system |
-
2018
- 2018-09-28 CN CN201811142578.5A patent/CN109360086A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101710410A (en) * | 2009-10-28 | 2010-05-19 | 金蝶软件（中国）有限公司 | Method and system for checking accounting data |
| CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
| CN103903177A (en) * | 2012-12-26 | 2014-07-02 | 远光软件股份有限公司 | Payment account checking method and system |
| CN105630924A (en) * | 2015-12-22 | 2016-06-01 | 北京京东尚科信息技术有限公司 | Asynchronous data processing method and asynchronous data processing system |
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109919125B (en) * | 2019-03-19 | 2021-03-26 | 厦门商集网络科技有限责任公司 | Travel route restoration method and system based on bill recognition |
| CN109919125A (en) * | 2019-03-19 | 2019-06-21 | 厦门商集网络科技有限责任公司 | Travel stroke restoring method and its system based on bank slip recognition |
| CN110109903A (en) * | 2019-04-01 | 2019-08-09 | 广州白云国际机场股份有限公司 | A kind of automatic checkout system and method for calibration of airport charges data |
| CN110348932A (en) * | 2019-05-22 | 2019-10-18 | 口碑(上海)信息技术有限公司 | Proofreading method and device, storage medium, the electronic device of order information |
| CN112446773A (en) * | 2019-09-02 | 2021-03-05 | 顺丰科技有限公司 | Business non-charge data management method, device, equipment and storage medium |
| CN110866756A (en) * | 2019-11-14 | 2020-03-06 | 中国民航信息网络股份有限公司 | Checking method and system for account statement |
| CN112016893A (en) * | 2020-08-27 | 2020-12-01 | 西安热工研究院有限公司 | Account-arriving claim system and method based on project management system |
| CN112348665B (en) * | 2020-10-28 | 2024-03-15 | 北京快成科技有限公司 | Account checking method, system and device |
| CN112348665A (en) * | 2020-10-28 | 2021-02-09 | 北京快成科技股份公司 | Account checking method, system and device |
| CN112560843A (en) * | 2020-12-11 | 2021-03-26 | 中信银行股份有限公司 | Bank bill expansion method and system based on image recognition and voice recognition |
| CN112560843B (en) * | 2020-12-11 | 2024-05-24 | 中信银行股份有限公司 | Bank bill expansion method and system based on image recognition and voice recognition |
| CN112465618A (en) * | 2020-12-22 | 2021-03-09 | 航天信息股份有限公司企业服务分公司 | Universal importing method and system for bank statement |
| CN112801616A (en) * | 2021-01-28 | 2021-05-14 | 中国工商银行股份有限公司 | Abnormal account book processing method and device |
| CN112801616B (en) * | 2021-01-28 | 2024-03-05 | 中国工商银行股份有限公司 | Abnormal account book processing method and device |
| CN112950360A (en) * | 2021-03-30 | 2021-06-11 | 杭州职业技术学院 | Financial information arrangement account invoice matching method |
| CN113177832A (en) * | 2021-04-29 | 2021-07-27 | 射手科技(珠海)有限公司 | Auxiliary accounting enterprise double entry bank account method and device based on artificial intelligence |
| CN113159859A (en) * | 2021-05-07 | 2021-07-23 | 北京京东振世信息技术有限公司 | Expense adjusting method and device |
| CN113408446A (en) * | 2021-06-24 | 2021-09-17 | 成都新希望金融信息有限公司 | Bill accounting method and device, electronic equipment and storage medium |
| CN113554009A (en) * | 2021-09-22 | 2021-10-26 | 北京奇虎科技有限公司 | Bill verification method, device, equipment and storage medium |
| CN114238317A (en) * | 2021-12-03 | 2022-03-25 | 武汉联影医疗科技有限公司 | Data storage and synchronization method and device, computer equipment and storage medium |
| CN115063222A (en) * | 2022-05-26 | 2022-09-16 | 重庆银行股份有限公司 | Bank statement information processing method, computer device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109360086A (en) | Method and apparatus based on bank statement data auto-complete accounting data | |
| US8521626B1 (en) | System and method for enhanced generation of invoice payment documents | |
| CN102968716B (en) | Reconciliation system and account checking method | |
| US9141991B2 (en) | Enhanced electronic data and metadata interchange system and process for electronic billing and payment system | |
| US7571848B2 (en) | Decentralized system and method for the remote capture, processing and transmission of check 21™ compliant checking document information | |
| EP0632415B1 (en) | Document transaction apparatus | |
| US4974878A (en) | Financial data processing system using payment coupons | |
| US10043201B2 (en) | Enhanced invitation process for electronic billing and payment system | |
| CN109887153A (en) | A kind of property tax processing method and processing system | |
| US20130232043A1 (en) | Systems and Methods of Processing and Classifying a Financial Transaction | |
| US20110196786A1 (en) | Determining trustworthiness and familiarity of users of an electronic billing and payment system | |
| CN107798515A (en) | A kind of method that database automatically generates accounting voucher | |
| US20130204756A1 (en) | Method and System for an Enhanced Business to Business Information and Money Exchange System | |
| JPS63244267A (en) | Window transaction processing system | |
| US20110184843A1 (en) | Enhanced electronic anonymous payment system | |
| CN112419035B (en) | Intelligent accounting and intelligent management accounting information generation method and system | |
| CN108133415B (en) | Electronic credential reimbursement method, device and system | |
| CN108734563A (en) | A method of automatically generating intelligent accounting voucher | |
| CN105825425A (en) | Financial data processing method applied to ameba management depositing and withdrawing style | |
| JP2017010312A (en) | Account processing system | |
| US7991658B2 (en) | Accounting process | |
| US20140198969A1 (en) | Device and Method for Contribution Accounting | |
| CN103440507A (en) | Bill information verifying device and method for verifying bill information | |
| CN109493207A (en) | A kind of finance reimbursement system and method based on artificial intelligence | |
| WO2004008350A1 (en) | Financial document processing method and system |
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: 20190219 |
|
| RJ01 | Rejection of invention patent application after publication |