[go: up one dir, main page]

CN103903177B - A kind of method and system for paying reconciliation - Google Patents

A kind of method and system for paying reconciliation Download PDF

Info

Publication number
CN103903177B
CN103903177B CN201210575901.4A CN201210575901A CN103903177B CN 103903177 B CN103903177 B CN 103903177B CN 201210575901 A CN201210575901 A CN 201210575901A CN 103903177 B CN103903177 B CN 103903177B
Authority
CN
China
Prior art keywords
reconciliation
transaction
data
bank
information
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.)
Active
Application number
CN201210575901.4A
Other languages
Chinese (zh)
Other versions
CN103903177A (en
Inventor
樊宇
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yuanguang Software Co Ltd
Original Assignee
Yuanguang Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Yuanguang Software Co Ltd filed Critical Yuanguang Software Co Ltd
Priority to CN201210575901.4A priority Critical patent/CN103903177B/en
Publication of CN103903177A publication Critical patent/CN103903177A/en
Application granted granted Critical
Publication of CN103903177B publication Critical patent/CN103903177B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The invention discloses a kind of method and system for paying reconciliation.The inventive method its comprise the following steps:Step(1), obtain bank transaction detailed data and e-payment record data;Step(2), collect transaction and the auto deduction of filtering bank transaction detailed data are merchandised;Step(3), the reconciliation keyword of bank transaction detailed data and e-payment record data is checked, it is as both sides' reconciliation keyword message is consistent, then such as inconsistent labeled as reconciliation data, then do not make reconciliation mark;Step(4), export no reconciliation flag data and carry out abnormal trade confirmation and manual reconciliation;Step(5), generate reconciliation form and abnormal transaction handled.Technical solutions according to the invention, can collect transaction to enterprise and auto deduction information filters, and improve reconciliation efficiency.

Description

A kind of method and system for paying reconciliation
Technical field
The present invention relates to financial and financial class software engineering, and in particular to a kind of method and system of corporate payments reconciliation.
Background technology
In existing enterprise's financial software, enterprise is obtaining silver by bank-enterprise interconnection interface to bank transaction system is got , it is necessary to which the detailed e-payment record with business finance software payment system of bank transaction is carried out reconciliation after row transaction details, It is accurate with the payment information ensured in payment system, the abnormal transaction such as investigation repeats payment, mistake is paid.
All kinds of financial at present and financial class software is when carrying out reconciliation, not to collecting the information such as transaction, auto deduction Filtered, checked simply by the information of reconciliation both data, cause the efficiency of reconciliation not high.
The content of the invention
It is an object of the invention to weak point regarding to the issue above, there is provided a kind of side of the payment reconciliation of reconciliation efficiency high Method and system, it collects transaction to enterprise and auto deduction information filters, and improves reconciliation efficiency.
In order to achieve the above object, the present invention uses following technical scheme:
A kind of method for paying reconciliation, it comprises the following steps:
Step(1), obtain bank transaction detailed data and e-payment record data;
Step(2), collect transaction and the auto deduction of filtering bank transaction detailed data are merchandised;
Step(3), the reconciliation keyword of bank transaction detailed data and e-payment record data is checked, it is such as double Square reconciliation keyword message is consistent, then such as inconsistent labeled as reconciliation data, then does not make reconciliation mark;
Step(4), export no reconciliation flag data and carry out abnormal trade confirmation and manual reconciliation;
Step(5), generate reconciliation form and abnormal transaction handled.
Further, the step(1)Specially:Bank transaction is obtained respectively from bank-enterprise interconnection interface and corporate payments system Detailed data and e-payment record data.
Further, the step(2)Specially:Checked by the account to bank transaction detailed data and summary, Find out collect account correspondingly merchandise direction collect Transaction Information, summary for collect transaction collect Transaction Information, summary be from The dynamic auto deduction Transaction Information withholdd, labeled as without reconciliation information, is filtered.
Further, the step(3)Specially:To bank transaction detailed data and e-payment record data both sides' reconciliation Keyword is checked, and reconciliation keyword includes unit, account, the amount of money, reconciliation unit, other side's account, trade date, opened an account Row, other side open an account row information, as both sides' reconciliation keyword message is consistent, then labeled as reconciliation data;Such as exist one-to-many, more To one situation, then reconciliation mark is not made.
Further, the step(4)Specially:The data without reconciliation mark are exported, reconciliation mark is not made by confirmation by hand Whether both sides' record of note is abnormal transaction, if it is, record preservation carries out step processing, if it is not, then carrying out by hand Reconciliation simultaneously records preservation.
Further, the step(5)Specially:Reconciliation form is issued, and abnormal Transaction Information is fed back into bank transaction System is further checked, while abnormal information is fed back into corporate payments system handling for business personnel of generation and waits to handle affairs .
A kind of system for paying reconciliation, it includes following functions unit:
Data capture unit, for obtaining bank transaction detailed data and e-payment record data;
Reconciliation filter element, collect transaction and auto deduction for filtering bank transaction detailed data are merchandised;
Automatic reconciliation unit, for the reconciliation keyword progress to bank transaction detailed data and e-payment record data Verification, it is as both sides' reconciliation keyword message is consistent, then such as inconsistent labeled as reconciliation data, then do not make reconciliation mark;
Manual setting unit, abnormal trade confirmation and manual reconciliation are carried out without reconciliation flag data for exporting;
Reconciliation information process unit, generate reconciliation form and abnormal transaction is handled.
Further, the data capture unit is specially:Silver is obtained respectively from bank-enterprise interconnection interface and corporate payments system Row transaction details data and e-payment record data.
Further, checked by the account to bank transaction detailed data and summary, find out and collect the corresponding friendship of account Easy direction collect Transaction Information, summary for collect transaction collect Transaction Information, the auto deduction that summary is auto deduction is handed over Easy information, labeled as without reconciliation information, filtered.
Further, the automatic reconciliation unit is specially:It is double to bank transaction detailed data and e-payment record data Square reconciliation keyword is checked, reconciliation keyword include unit, account, the amount of money, reconciliation unit, other side's account, trade date, Bank of deposit, other side open an account row information, as both sides' reconciliation keyword message is consistent, then labeled as reconciliation data;Such as exist a pair More, many-to-one situation, then do not make reconciliation mark.
Further, the manual setting unit is specially:The data without reconciliation mark are exported, are not opposed by confirmation by hand Whether both sides' record of account mark is abnormal transaction, if it is, record preservation carries out step processing, if it is not, then carrying out Manual reconciliation simultaneously records preservation.
Further, the reconciliation information process unit is specially:Reconciliation form is issued, and abnormal Transaction Information is fed back to Bank transaction system is further checked, while abnormal information is fed back to the processing of corporate payments system generation business personnel Backlog.
Technical solutions according to the invention, can collect transaction to enterprise and auto deduction information filters, and improve pair Account efficiency, at the same solve prior art can not be distinguished in reconciliation is paid phase same date, same amount and same account transaction Problem.
Brief description of the drawings
Fig. 1 is the basic flow sheet of payment account checking method of the present invention.
Fig. 2 is payment reconciliation system general principle structured flowchart of the present invention.
Below by way of the drawings and specific embodiments, the invention will be further described:
Embodiment
A kind of method for paying reconciliation of the present invention, it is necessary to depend on business finance software and banking system is implemented, Its using filter out collect transaction, auto deduction transaction after carry out reconciliation keyword verification reconciliation mode.
As shown in figure 1, the inventive method specifically includes following steps:
Step 1 A1, obtain bank transaction detailed data and e-payment record data
Specially:Bank transaction detailed data and e-payment are obtained respectively from bank-enterprise interconnection interface and corporate payments system Record data.
Following data is such as obtained respectively:
Bank transaction detailed data(Table one):
Table one:
E-payment record data(Table two):
Table two:
Step 2 A2, filtering bank transaction detailed data collect transaction and auto deduction transaction.
Specially:Checked by the account to bank transaction detailed data and summary, find out and collect the corresponding friendship of account Easy direction collect Transaction Information, summary for collect transaction collect Transaction Information, the auto deduction that summary is auto deduction is handed over Easy information, labeled as without reconciliation information, filtered.
Collect account direction of correspondingly merchandising and refer to that label collects account in corporate payments systems, externally income and right Other collect this corresponding transaction direction that account paid to business group internal, or foreign payment and in enterprise group Portion other collect this corresponding transaction direction that account obtains income.And collect account with what above two correspondingly merchandised direction Transaction belong to and collect transaction, therefore such Transaction Information of bank transaction detailed data belongs to and collects Transaction Information, and it is marked It is designated as, without reconciliation information, being filtered.
Such as above-mentioned bank transaction detailed data(Table one)The summary of transaction details sequence number 4 to collect transaction, then it is marked For without reconciliation sequence number 1, referring to following without reconciliation data(Table three):
Table three:
Step 3 A3, the reconciliation keyword of bank transaction detailed data and e-payment record data is checked, such as Both sides' reconciliation keyword message is consistent, then such as inconsistent labeled as reconciliation data, then does not make reconciliation mark.
Specially:Bank transaction detailed data and e-payment record data both sides' reconciliation keyword are checked, it is right Row information that account keyword includes unit, account, the amount of money, reconciliation unit, other side's account, trade date, bank of deposit, other side open an account, As both sides' reconciliation keyword message is consistent, then labeled as reconciliation data;One-to-many, many-to-one situation such as be present, then do not make Reconciliation marks.
From above-mentioned table one and table two, first record pair of bank transaction detailed data and e-payment record data Account keyword is completely the same, therefore can mark as reconciliation data(Table four), generate a reconciliation data, and one reconciliation of mark Number 1, and e-payment record data(Table two)Sequence number 2 and bank transaction detailed data(Table one)Sequence number 2 and 3 belong to a pair , that is, be present the problem of multiple transaction of phase same date, same amount and same account in more or many-to-one situation, then do not make temporarily Reconciliation marks.
Table four:
Step 4 A4, export no reconciliation flag data and carry out abnormal trade confirmation and manual reconciliation.
Specially:Export without reconciliation mark data, by by hand confirmation do not make reconciliation mark both sides record whether be Abnormal transaction, if it is, record preservation carries out step processing, if it is not, then carrying out manual reconciliation and recording preservation.
Such as above-mentioned e-payment record data(Table two)Sequence number 2 and bank transaction detailed data(Table one)Sequence number 2 and 3 Data marked without reconciliation, handled at manual markings, through artificial judgment, such as find e-payment record data(Table two) Sequence number 2 and bank transaction detailed data(Table one)Sequence number 2 and 3 be substantially a payment record data when, bank transaction Detailed data sequence number 2,3 is merchandised labeled as abnormal, is shown in Table five.
Table five
Step 5 A5, generate reconciliation form and abnormal transaction is handled.
Specially:The information accumulated according to above-mentioned steps, issue reconciliation form(It is shown in Table six), and by abnormal transaction(It is such as different Often transaction sequence number 1)Feedback of the information is further checked to bank transaction system, while abnormal information is fed back into corporate payments System generates the processing backlog of business personnel.
Table six
As shown in Fig. 2 the present embodiment 1 also discloses a kind of payment reconciliation system completely corresponding with the above method, it is wrapped Include following functions unit:
Data capture unit B1, for obtaining bank transaction detailed data and e-payment record data.Specially:From silver Enterprise's interconnecting interface and corporate payments system obtain bank transaction detailed data and e-payment record data respectively.
Reconciliation filter element B2, collect transaction and auto deduction for filtering bank transaction detailed data are merchandised.Specifically For:Checked by the summary to bank transaction detailed data and account, find out summary and believe to collect the transaction that collects of transaction Breath and summary are the auto deduction Transaction Information of auto deduction, labeled as without reconciliation information, are filtered.
Automatic reconciliation unit B3, for entering to the reconciliation keyword of bank transaction detailed data and e-payment record data Row verification, reconciliation keyword include unit, account, the amount of money, reconciliation unit, other side's account, trade date, bank of deposit, Dui Fangkai Family row information, as both sides' reconciliation keyword message is consistent, then labeled as reconciliation data, one-to-many, many-one such as be present, then not Make reconciliation mark;
Manual setting unit B 4, abnormal trade confirmation and manual reconciliation are carried out without reconciliation flag data for exporting.Specifically For:The data without reconciliation mark are exported, whether the both sides' record for not making reconciliation mark by confirmation by hand is abnormal transaction, if It is then to record preservation to carry out step processing, if it is not, then carrying out manual reconciliation and recording preservation.
Reconciliation information process unit B5, generate reconciliation form and abnormal transaction is handled.Specially:Issue reconciliation report Table, and abnormal Transaction Information is fed back into bank transaction system and further checked, while abnormal information is fed back into enterprise Payment system generates the processing backlog of business personnel.
Technical solutions according to the invention, can collect transaction to enterprise and auto deduction information filters, and improve pair Account efficiency, at the same solve prior art can not be distinguished in reconciliation is paid phase same date, same amount and same account transaction Problem.

Claims (10)

  1. A kind of 1. method for paying reconciliation, it is characterised in that comprise the following steps:
    Step (1), obtain bank transaction detailed data and e-payment record data;
    Step (2), filtering bank transaction detailed data collect transaction and auto deduction transaction;
    Step (3), the reconciliation keyword of bank transaction detailed data and e-payment record data is checked, such as both sides couple Account keyword message is consistent, then such as inconsistent labeled as reconciliation data, then does not make reconciliation mark;The step (3) is specific For:Bank transaction detailed data and e-payment record data both sides' reconciliation keyword are checked, reconciliation keyword includes Unit, account, the amount of money, reconciliation unit, other side's account, trade date, bank of deposit, other side are opened an account row information, as both sides' reconciliation is closed Key word information is consistent, then labeled as reconciliation data;One-to-many, many-to-one situation such as be present, then do not make reconciliation mark;
    Step (4), export no reconciliation flag data and carry out abnormal trade confirmation and manual reconciliation;
    Step (5), generate reconciliation form and abnormal transaction is handled.
  2. 2. a kind of method for paying reconciliation according to claim 1, it is characterised in that the step (1) is specially:From bank Interconnecting interface and corporate payments system obtain bank transaction detailed data and e-payment record data respectively.
  3. 3. a kind of method for paying reconciliation according to claim 1, it is characterised in that the step (2) is specially:By right The account and summary of bank transaction detailed data checked, find out collect account correspondingly merchandise direction collect Transaction Information, Make a summary for collect transaction collect Transaction Information, summary be auto deduction auto deduction Transaction Information, labeled as without reconciliation Information, filtered.
  4. 4. a kind of method for paying reconciliation according to claim 1, it is characterised in that the step (4) is specially:Export nothing The data of reconciliation mark, whether the both sides' record for not making reconciliation mark by confirmation by hand is abnormal transaction, if it is, record Preservation carries out step processing, if it is not, then carrying out manual reconciliation and recording preservation.
  5. 5. a kind of method for paying reconciliation according to claim 1, it is characterised in that the step (5) is specially:Issue pair Account form, and abnormal Transaction Information is fed back into bank transaction system and further checked, while abnormal information is fed back to Corporate payments system generates the processing backlog of business personnel.
  6. 6. a kind of system for paying reconciliation, it is characterised in that including following functions unit:
    Data capture unit, for obtaining bank transaction detailed data and e-payment record data;
    Reconciliation filter element, collect transaction and auto deduction for filtering bank transaction detailed data are merchandised;
    Automatic reconciliation unit, for carrying out core to the reconciliation keyword of bank transaction detailed data and e-payment record data It is right, it is as both sides' reconciliation keyword message is consistent, then such as inconsistent labeled as reconciliation data, then do not make reconciliation mark;It is described from Moving reconciliation unit is specially:Bank transaction detailed data and e-payment record data both sides' reconciliation keyword are checked, Reconciliation keyword includes unit, account, the amount of money, reconciliation unit, other side's account, trade date, bank of deposit, other side bank of deposit letter Breath, as both sides' reconciliation keyword message is consistent, then labeled as reconciliation data;One-to-many, many-to-one situation such as be present, then not Make reconciliation mark;
    Manual setting unit, abnormal trade confirmation and manual reconciliation are carried out without reconciliation flag data for exporting;
    Reconciliation information process unit, generate reconciliation form and abnormal transaction is handled.
  7. 7. a kind of system for paying reconciliation according to claim 6, it is characterised in that the data capture unit is specially: Bank transaction detailed data and e-payment record data are obtained respectively from bank-enterprise interconnection interface and corporate payments system.
  8. 8. a kind of system for paying reconciliation according to claim 6, it is characterised in that the reconciliation filter element is specially: Checked by the account to bank transaction detailed data and summary, find out collect that account correspondingly merchandises direction collect transaction Information, summary for collect transaction collect Transaction Information, the auto deduction Transaction Information that summary is auto deduction, labeled as need not Reconciliation information, is filtered.
  9. 9. a kind of system for paying reconciliation according to claim 6, it is characterised in that the manual setting unit is specially: The data without reconciliation mark are exported, whether the both sides' record for not making reconciliation mark by confirmation by hand is abnormal transaction, if it is, Then record preservation carries out step processing, if it is not, then carrying out manual reconciliation and recording preservation.
  10. A kind of 10. system for paying reconciliation according to claim 6, it is characterised in that the reconciliation information process unit tool Body is:Reconciliation form is issued, and abnormal Transaction Information is fed back into bank transaction system and further checked, while will be abnormal Processing backlog of the feedback of the information to corporate payments system generation business personnel.
CN201210575901.4A 2012-12-26 2012-12-26 A kind of method and system for paying reconciliation Active CN103903177B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201210575901.4A CN103903177B (en) 2012-12-26 2012-12-26 A kind of method and system for paying reconciliation

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201210575901.4A CN103903177B (en) 2012-12-26 2012-12-26 A kind of method and system for paying reconciliation

Publications (2)

Publication Number Publication Date
CN103903177A CN103903177A (en) 2014-07-02
CN103903177B true CN103903177B (en) 2017-12-15

Family

ID=50994485

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201210575901.4A Active CN103903177B (en) 2012-12-26 2012-12-26 A kind of method and system for paying reconciliation

Country Status (1)

Country Link
CN (1) CN103903177B (en)

Families Citing this family (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104574182A (en) * 2015-01-28 2015-04-29 中国农业银行股份有限公司 Bank reconciliation account configuration method and device
CN107665460A (en) * 2016-07-24 2018-02-06 平安科技(深圳)有限公司 Accounting method and device based on real-time deal
CN106600247B (en) * 2016-12-14 2020-11-10 中国航空结算有限责任公司 Payment processing method and device
CN106897925A (en) * 2017-02-21 2017-06-27 世纪禾光科技发展(北京)有限公司 Bill processing method and device
CN107944996A (en) * 2017-10-17 2018-04-20 九派天下支付有限公司 A kind of fund account checking method and system
CN107993137A (en) * 2017-11-15 2018-05-04 浪潮金融信息技术有限公司 Account checking method and device, computer-readable storage medium and terminal
CN108182632A (en) * 2017-12-29 2018-06-19 山大地纬软件股份有限公司 The device of the automatic reconciliation of support business
CN109360086A (en) * 2018-09-28 2019-02-19 厦门商集网络科技有限责任公司 Method and apparatus based on bank statement data auto-complete accounting data
CN109544151A (en) * 2018-10-11 2019-03-29 平安科技(深圳)有限公司 Method, apparatus, computer equipment and the storage medium of gathering confirmation
CN109949430A (en) * 2019-03-28 2019-06-28 西安艾润物联网技术服务有限责任公司 Parking payment management method, cloud platform and storage medium
CN110310188B (en) * 2019-05-30 2024-05-07 平安科技(深圳)有限公司 Information verification method, device, computer equipment and storage medium thereof
CN110766404A (en) * 2019-09-27 2020-02-07 山东高速信联科技有限公司 Automatic reconciliation method and system for ETC multi-service multi-payment scene
CN112396412B (en) * 2020-11-19 2023-10-20 深圳供电局有限公司 Abnormality monitoring method and system in checking process of electric power system and bank
CN112862609A (en) * 2021-01-22 2021-05-28 中国建设银行股份有限公司 Transaction data checking method and device, electronic equipment and storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101482945A (en) * 2009-02-11 2009-07-15 浪潮集团山东通用软件有限公司 Method for implementing balance account receiving, distributing and storing query statistics in accounting management process
CN101908253A (en) * 2010-08-12 2010-12-08 深圳市雁联计算系统有限公司 System and method for realizing tax control function
CN102411756A (en) * 2010-09-26 2012-04-11 金蝶软件(中国)有限公司 Bank account data management system and method

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7577599B2 (en) * 2004-03-12 2009-08-18 First Data Corporation Method and system for processing electronic payment transactions
US20100121746A1 (en) * 2008-11-13 2010-05-13 Ez Decisions Llc Financial statement risk assessment and management system and method
CN101710410A (en) * 2009-10-28 2010-05-19 金蝶软件(中国)有限公司 Method and system for checking accounting data

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101482945A (en) * 2009-02-11 2009-07-15 浪潮集团山东通用软件有限公司 Method for implementing balance account receiving, distributing and storing query statistics in accounting management process
CN101908253A (en) * 2010-08-12 2010-12-08 深圳市雁联计算系统有限公司 System and method for realizing tax control function
CN102411756A (en) * 2010-09-26 2012-04-11 金蝶软件(中国)有限公司 Bank account data management system and method

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
会计信息化环境下现金流量表的编制;吕志明;《中国管理信息化》;20060228;第9卷(第2期);全文 *

Also Published As

Publication number Publication date
CN103903177A (en) 2014-07-02

Similar Documents

Publication Publication Date Title
CN103903177B (en) A kind of method and system for paying reconciliation
CN103903137B (en) It is a kind of automatically to pay account checking method and system
JP4701510B2 (en) Apparatus and method for aggregating transaction information relating to financial transactions
CN106408410A (en) Automatic account checking method and device
CN110390596A (en) A Financial Futures Trading System
CN105321046A (en) Corporate financial management system
CN106022902A (en) Accounting method and device
CN111967985B (en) Block chain-based acceptance draft management method
CN103440557A (en) Generation method and system for group consolidated accounts and consolidated statements
CN107862567B (en) Order checking method
CN105787109A (en) Account checking method and device of payment and clearing system
US20150142648A1 (en) Corporate Bill Self-service System with Blank Bill Vending and Temporary Bill Storage Functions
CN102982421A (en) Preparation method and system for merging cash flow statements of group based on bank reconciliations
CN102982483A (en) Processing method and system for bank account receipt notice data
CN104021457A (en) Method and system for monitoring group enterprise cost expenditure data
CN106022736A (en) Card issuer and acquirer settlement method in traffic field multi-city intercommunication
CN107203914A (en) A kind of data managing method of raw material order
CN113807942A (en) Method and system for real-time recovery of bank bad loan
CN102117454A (en) Bank card safe payment method and system
CN113129021A (en) Block chain-based method and device for preventing malicious overdraft of credit card
US20070255651A1 (en) Batch processing of financial transactions
CN106204252A (en) Internal credit and debt remaining sum identification, the method and system gathering and checking
CN115358739A (en) Information processing method and device
CN114742634A (en) Method and device for processing data of same-industry deposit receipt and electronic equipment
CN115953259B (en) Multidimensional automatic account checking method based on collaboration platform loan business

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant