CN101887553A - Automatic data settlement processing method and system - Google Patents
Automatic data settlement processing method and system Download PDFInfo
- Publication number
- CN101887553A CN101887553A CN2010102556428A CN201010255642A CN101887553A CN 101887553 A CN101887553 A CN 101887553A CN 2010102556428 A CN2010102556428 A CN 2010102556428A CN 201010255642 A CN201010255642 A CN 201010255642A CN 101887553 A CN101887553 A CN 101887553A
- Authority
- CN
- China
- Prior art keywords
- clearing
- data
- settlement
- allocation plan
- database
- 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
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses an automatic data settlement processing method and an automatic data settlement processing system. The method comprises the following steps of: inputting data to be settled; acquiring a corresponding settlement configuration plan from a database; generating settled data according to the input data to be settled and the acquired settlement configuration plan; generating reports according to the generated settled data and a prestored report template; and displaying the generated reports to a user. In the method and the system, a partner and a corresponding settlement configuration plan of the partner are prestored in the database according to a contract or an agreement; when the user performs the settlement, only by inputting the data to be settled, the corresponding settlement configuration plan can be found out in the database; and then according to the found settlement configuration plan and in combination with real-time data in the data to be settled, the reports are automatically generated so as to save much operation and facilitate the operation of the user.
Description
Technical field
The present invention relates to data settlement process technology, relate in particular to the method and system that a kind of automatic data settlement is handled.
Background technology
In company's practical business clearing, the unit that cooperates with the company is generally many, and the clearing of each cooperation unit are all complicated, and different clearing form (comprising different expenses of taxation rates, clearing ratio, clearing coefficient etc.) is all arranged.In this case, the clearing personnel need note the clearing form of each tame cooperation unit with document, when each monthly billing, all will manually generate the clearing form.
Along with cooperation unit increases, the thing followed is exactly that Mission Day is heavy increasingly, but also the inaccurate problem of certain report data can occur, and in the middle of this, very most reason is owing to the hand labour that repeats causes.Though office software commonly used such as Excel etc. provide certain computing function, but still can not satisfy the needs of various complicated settlement process.
Summary of the invention
The purpose of this invention is to provide the method and system that a kind of automatic data settlement is handled, it can satisfy the needs of various complicated settlement process.
For achieving the above object, the present invention adopts following technical scheme:
The method that a kind of automatic data settlement is handled comprises:
Import data to be settled accounts, data described to be settled accounts comprise partner's information and real time data;
According to described partner's information, from database, obtain corresponding clearing allocation plan, wherein said clearing allocation plan is used to instruct the generation of settlement data, stores all partners' clearing allocation plan in the described database in advance;
Carry out computing according to described real time data and the clearing allocation plan that is obtained, generate settlement data;
Report form template coupling according to settlement data that is generated and storage in advance generates form;
Give the user with the report display that is generated.
Further, the clearing allocation plan in the described database is corresponding one by one with described partner's information.
Further, described clearing allocation plan comprises clearing formula and clearing parameter, and described clearing allocation plan and described clearing formula be one-one relationship, perhaps is many-one relationship.
Further, the content of the form that is generated comprises the data of being imported to be settled accounts, described clearing parameter and the settlement data that is generated.
Further, described report form template is provided with according to the clearing allocation plan of storing in the described database.
The system that a kind of automatic data settlement is handled comprises:
Load module is used to import data to be settled accounts, and data described to be settled accounts comprise partner's information and real time data;
Acquisition module is used for obtaining corresponding clearing allocation plan according to described partner's information from database, and wherein said clearing allocation plan is used to instruct the generation of settlement data, stores all partners' clearing allocation plan in the described database in advance;
The settlement data generation module is used for carrying out computing according to described real time data and the clearing allocation plan that is obtained, and generates settlement data;
The report generation module is used for generating form according to the report form template coupling of settlement data that is generated and storage in advance;
The report display module, the report display that is used for being generated is given the user.
Further, the clearing allocation plan in the described database is corresponding one by one with described partner's information.
Further, described clearing allocation plan comprises clearing formula and clearing parameter, and described clearing allocation plan and described clearing formula be one-one relationship, perhaps is many-one relationship.
Further, the content of the form that is generated comprises the data of being imported to be settled accounts, described clearing parameter and the settlement data that is generated.
Further, described report form template is provided with according to the clearing allocation plan of storing in the described database.
The method and system that automatic data settlement provided by the invention is handled, based on contract or agreement in advance partner and corresponding clearing allocation plan thereof are stored in the database, the user is when settling accounts, only need input data to be settled accounts, the present invention just can seek corresponding clearing allocation plan according to partner's information wherein in database, then according to the clearing allocation plan of finding out, in conjunction with the real time data for the treatment of in the settlement data, automatic report generation, for the user has saved a lot of operation stepss, be convenient to user's operation.
Description of drawings
Fig. 1 is the schematic flow sheet of an embodiment of the method handled of automatic data settlement of the present invention;
Fig. 2 is the schematic flow sheet of another embodiment of the method handled of automatic data settlement of the present invention;
Fig. 3 is the structural representation of the system of automatic data settlement processing of the present invention.
Embodiment
In order to make purpose of the present invention, technical scheme and advantage clearer,, the present invention is further elaborated below in conjunction with drawings and Examples.Should be appreciated that specific embodiment described herein only in order to explanation the present invention, and be not used in qualification the present invention.
As shown in Figure 1, the invention provides the method that a kind of automatic data settlement is handled, comprising:
Step 11: import data to be settled accounts, data described to be settled accounts comprise partner's information and real time data; In this step, each partner can be with unique ID number sign, and this moment, partner information was ID number; Real time data is meant the cost data that needs clearing, is generally the cost data of generation in every month.
Step 12: according to described partner's information, obtain corresponding clearing allocation plan from database, wherein said clearing allocation plan is used to instruct the generation of settlement data, stores all partners' clearing allocation plan in the described database in advance;
Step 13: carry out computing according to described real time data and the clearing allocation plan that is obtained, generate settlement data;
Step 14: the report form template coupling according to settlement data that is generated and storage in advance generates form;
Step 15: give the user with the report display that is generated.
The method that automatic data settlement of the present invention is handled, based on contract or agreement in advance partner and corresponding clearing allocation plan thereof are stored in the database, the user is when settling accounts, only need input data to be settled accounts, the present invention just can seek corresponding clearing allocation plan according to partner's information wherein in database, then according to the clearing allocation plan of finding out, in conjunction with the real time data for the treatment of in the settlement data, automatic report generation, for the user has saved a lot of operation stepss, be convenient to user's operation.
Among the present invention, all partners' clearing formula in advance according in certain form input database, is formed a condom and independently settles accounts allocation plan, preferably, this clearing allocation plan is corresponding one by one with partner's information, and promptly a partner only has a cover clearing allocation plan.Can carry out corresponding one by one with the clearing allocation plan by unique ID number of partner.
The clearing allocation plan preferably is made of clearing formula and clearing parameter two parts, and by managerial personnel based on contract or arrange prior typing and be kept in the database these two parts all are.And the clearing allocation plan is an one-one relationship with the clearing formula, perhaps is many-one relationship, and promptly a clearing allocation plan both can only comprise a clearing formula, also can comprise a plurality of clearing formula.
For the integrality of form content, the settlement data that the content of the form that the present invention generated preferably includes the data of being imported to be settled accounts, described clearing parameter and generated.In addition, generate the report form template that form utilized and preferably be provided with, better to list the parameter with the clearing detail of cooperation unit according to the clearing allocation plan of storing in the database.
The technical scheme of method of the present invention is described with a concrete clearing example below.
With reference to Fig. 2, the method that the automatic data settlement of present embodiment is handled comprises:
Step 21: the data that user's input is to be settled accounts, data wherein to be settled accounts comprise partner's information and channel information expense;
Present embodiment is that the method that automatic data settlement of the present invention is handled is applied to communication class company,, treats that real time data in the settlement data is is that example describes with the channel information expense herein.
Step 22: the partner according to input in the step 21 seeks corresponding ID number and the clearing allocation plan of this ID correspondence in database;
Step 23: treating that settlement data combines with clearing formula in the predefined clearing allocation plan and calculate the generation settlement data with input in the step 21;
Wherein, the clearing formula is specially: settlement amounts=channel information expense * (1-bad credit rate) * (1-button operator withholds service charge) * (1-expenses of taxation rate)-(unbalanced passage expense-examine and make cuts-user moves back expense) * sharing proportion * reconciliation ratio, and wherein bad credit rate, button operator withhold that service charge, expenses of taxation rate, unbalanced passage are taken, examined and made cuts, the user moves back expense, sharing proportion, the isoparametric clearing coefficient of reconciliation ratio all preset when settling accounts allocation plan being provided with;
Step 24: with the settlement data that draws of clearing and the parameter matching of report form template in the step 23, generation form;
The content of report display mainly comprises the clearing parameter, user input treat settlement data, and last checkout result is wherein settled accounts parameter and can directly be read from database, checkout result obtains from step 23.
Step 25: carry out report display, the various supplemental characteristics that obtain in the step 24 page format according to is shown.
Below just illustrate one of them data (channel information expense) and how to draw, a general partner ID is to more than one of parameter in requisition for clearing, and the clearing formula of its correspondence is generally also with regard to more than one so.If any a plurality of parameters that need clearing, the parameter according to the user selects the needs clearing according to said process execution settlement process, obtains final checkout result, and shows.
In addition, increase partner and corresponding clearing allocation plan newly, also only need the keeper that its ID and corresponding clearing allocation plan is default and be stored in the database and get final product, make things convenient for the user to increase or delete partner's corresponding informance.
Corresponding with the method that above-mentioned automatic data settlement is handled, the system that the present invention also provides a kind of automatic data settlement to handle as shown in Figure 3, comprising:
Settlement data generation module 303 is used for carrying out computing according to described real time data and the clearing allocation plan that is obtained, and generates settlement data;
The system that automatic data settlement of the present invention is handled by based on contract or agreement in advance with the partner with and corresponding clearing allocation plan be stored in the database, the user is when settling accounts, only need input partner and some real time datas, the present invention just can seek corresponding clearing allocation plan according to the partner of input in database, then according to clearing formula in the clearing allocation plan and clearing parameter, real time data in conjunction with input calculates last checkout result, and automatic report generation, for the user has saved a lot of operation stepss, be convenient to user's operation.
Preferably, the clearing allocation plan in the described database is corresponding one by one with described partner's information.
Preferably, described clearing allocation plan comprises clearing formula and clearing parameter, and described clearing allocation plan and described clearing formula be one-one relationship, perhaps is many-one relationship.
Preferably, the content of the form that is generated comprises the data of being imported to be settled accounts, described clearing parameter and the settlement data that is generated.
Preferably, described report form template is provided with according to the clearing allocation plan of storing in the described database.
Automatic data settlement disposal system of the present invention both can be implemented on single electronic equipment with calculation function such as computing machine, also can on a sets of computer, implement, for example on a sets of computer, implement with the form of client-server, at this moment, database among the present invention need be arranged on server end, above-mentioned load module 301 and report display module 305 need be arranged on client, above-mentioned acquisition module 302, settlement data generation module 303 and report generation module 304 both can be arranged on client, also can be arranged on server end.Communicating by letter between server end and the client can be adopted communication mode commonly known in the art, as wired, bluetooth, Wi-Fi and infrared etc., repeats no more herein.
The above is preferred embodiment of the present invention only, is not to be used for limiting practical range of the present invention; If do not break away from the spirit and scope of the present invention, the present invention is made amendment or is equal to replacement, all should be encompassed in the middle of the protection domain of claim of the present invention.
Claims (10)
1. the method that automatic data settlement is handled is characterized in that, comprising:
Import data to be settled accounts, data described to be settled accounts comprise partner's information and real time data;
According to described partner's information, from database, obtain corresponding clearing allocation plan, wherein said clearing allocation plan is used to instruct the generation of settlement data, stores all partners' clearing allocation plan in the described database in advance;
Carry out computing according to described real time data and the clearing allocation plan that is obtained, generate settlement data;
Report form template coupling according to settlement data that is generated and storage in advance generates form;
Give the user with the report display that is generated.
2. method according to claim 1 is characterized in that, the clearing allocation plan in the described database is corresponding one by one with described partner's information.
3. method according to claim 1 and 2 is characterized in that, described clearing allocation plan comprises clearing formula and clearing parameter, and described clearing allocation plan and described clearing formula be one-one relationship, perhaps is many-one relationship.
4. method according to claim 3 is characterized in that, the content of the form that is generated comprises the data of being imported to be settled accounts, described clearing parameter and the settlement data that is generated.
5. method according to claim 1 is characterized in that, described report form template is provided with according to the clearing allocation plan of storing in the described database.
6. the system that automatic data settlement is handled is characterized in that, comprising:
Load module is used to import data to be settled accounts, and data described to be settled accounts comprise partner's information and real time data;
Acquisition module is used for obtaining corresponding clearing allocation plan according to described partner's information from database, and wherein said clearing allocation plan is used to instruct the generation of settlement data, stores all partners' clearing allocation plan in the described database in advance;
The settlement data generation module is used for carrying out computing according to described real time data and the clearing allocation plan that is obtained, and generates settlement data;
The report generation module is used for generating form according to the report form template coupling of settlement data that is generated and storage in advance;
The report display module, the report display that is used for being generated is given the user.
7. the system that automatic data settlement according to claim 6 is handled is characterized in that the clearing allocation plan in the described database is corresponding one by one with described partner's information.
8. the system that handles according to claim 6 or 7 described automatic data settlements, it is characterized in that, described clearing allocation plan comprises clearing formula and clearing parameter, and described clearing allocation plan and described clearing formula be one-one relationship, perhaps is many-one relationship.
9. the system that automatic data settlement according to claim 8 is handled is characterized in that the content of the form that is generated comprises the data of being imported to be settled accounts, described clearing parameter and the settlement data that is generated.
10. the system that automatic data settlement according to claim 6 is handled is characterized in that described report form template is provided with according to the clearing allocation plan of storing in the described database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102556428A CN101887553A (en) | 2010-08-12 | 2010-08-12 | Automatic data settlement processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102556428A CN101887553A (en) | 2010-08-12 | 2010-08-12 | Automatic data settlement processing method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101887553A true CN101887553A (en) | 2010-11-17 |
Family
ID=43073465
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010102556428A Pending CN101887553A (en) | 2010-08-12 | 2010-08-12 | Automatic data settlement processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101887553A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103106754A (en) * | 2012-12-27 | 2013-05-15 | 北京税恒科技有限公司 | Tax accounting control platform and method |
| CN104573946A (en) * | 2014-12-26 | 2015-04-29 | 北京奇虎科技有限公司 | Processing method and system of business object data |
| CN104750714A (en) * | 2013-12-30 | 2015-07-01 | 中国银联股份有限公司 | File generation system and method |
| CN105787243A (en) * | 2014-12-24 | 2016-07-20 | 北京奇虎科技有限公司 | Data processing method and system for business object and electronic device |
| CN108389119A (en) * | 2018-03-18 | 2018-08-10 | 中科富创（北京）科技有限公司 | A kind of financial settlement system and method |
| CN108805632A (en) * | 2018-05-07 | 2018-11-13 | 北京京东尚科信息技术有限公司 | A kind of charging method and device |
| CN109345364A (en) * | 2018-09-07 | 2019-02-15 | 阿里巴巴集团控股有限公司 | Method and device for realizing accounting day settlement |
| CN109409933A (en) * | 2018-09-26 | 2019-03-01 | 深圳壹账通智能科技有限公司 | Intelligent fee counting method, computer readable storage medium and terminal device |
| CN111062762A (en) * | 2019-12-27 | 2020-04-24 | 宁波三星医疗电气股份有限公司 | Smart meter settlement method and device |
-
2010
- 2010-08-12 CN CN2010102556428A patent/CN101887553A/en active Pending
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103106754A (en) * | 2012-12-27 | 2013-05-15 | 北京税恒科技有限公司 | Tax accounting control platform and method |
| CN104750714A (en) * | 2013-12-30 | 2015-07-01 | 中国银联股份有限公司 | File generation system and method |
| CN105787243A (en) * | 2014-12-24 | 2016-07-20 | 北京奇虎科技有限公司 | Data processing method and system for business object and electronic device |
| CN104573946A (en) * | 2014-12-26 | 2015-04-29 | 北京奇虎科技有限公司 | Processing method and system of business object data |
| CN108389119A (en) * | 2018-03-18 | 2018-08-10 | 中科富创（北京）科技有限公司 | A kind of financial settlement system and method |
| CN108805632A (en) * | 2018-05-07 | 2018-11-13 | 北京京东尚科信息技术有限公司 | A kind of charging method and device |
| CN109345364A (en) * | 2018-09-07 | 2019-02-15 | 阿里巴巴集团控股有限公司 | Method and device for realizing accounting day settlement |
| CN109409933A (en) * | 2018-09-26 | 2019-03-01 | 深圳壹账通智能科技有限公司 | Intelligent fee counting method, computer readable storage medium and terminal device |
| CN111062762A (en) * | 2019-12-27 | 2020-04-24 | 宁波三星医疗电气股份有限公司 | Smart meter settlement method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101887553A (en) | Automatic data settlement processing method and system | |
| CN110704519B (en) | Service bill conversion method and device, storage medium and computer equipment | |
| CN101719119A (en) | Report management system and method | |
| CN106548322A (en) | Project examination system | |
| CN102902740B (en) | Recommendation method and device for Web service combination | |
| KR101636560B1 (en) | Cloud-based public affairs information management system | |
| CN105139190A (en) | Enterprise financial statement automatic generation system and method | |
| CN111274774A (en) | Industrial building engineering full-process automatic management system | |
| CN104636855A (en) | Project data management server and project data management program | |
| KR20140110777A (en) | Information processing system, information processing apparatus, method of controlling an information processing apparatus, and program | |
| CN112184419A (en) | Method and device for providing service for customer | |
| CN102376023A (en) | Integration method for evaluation material for credit evaluation | |
| CN103559586B (en) | A kind of report document management, system and method | |
| CN110347992A (en) | Data analysing method and system based on electronic report forms | |
| CN102354317A (en) | Data generation device and method | |
| CN113253951A (en) | Paper contract information printing method, system, device and readable storage medium | |
| US20120233175A1 (en) | Database, slip data management server, and index data management program | |
| CN105843785B (en) | A kind of data self accounting report generation method of embedded organization and administration level | |
| JP4560171B2 (en) | Computer-readable recording medium recording consolidated settlement method and program | |
| US20110320225A1 (en) | Method and apparatus for automatic healthplan data retrieval and reconciliation using a processing device | |
| CN1534523A (en) | Integrated sales system and method thereof | |
| JP2002073606A (en) | Information retrieval device, idea operation device and those methods | |
| CN103390217A (en) | Power transformation transaction management operating system | |
| CN113191580A (en) | Method and system for comprehensively evaluating acre area based on enterprise label | |
| CN105868960A (en) | Method for realizing rapid work reporting based on coding algorithm |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20101117 |