CN103761599B - Realize that insider transaction business carries out the method and device of generation payment voucher - Google Patents
Realize that insider transaction business carries out the method and device of generation payment voucher Download PDFInfo
- Publication number
- CN103761599B CN103761599B CN201310717222.0A CN201310717222A CN103761599B CN 103761599 B CN103761599 B CN 103761599B CN 201310717222 A CN201310717222 A CN 201310717222A CN 103761599 B CN103761599 B CN 103761599B
- Authority
- CN
- China
- Prior art keywords
- voucher
- business
- reconciliation
- calculation
- calculation business
- 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
Links
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The present invention relates to realize that insider transaction business carries out the method and device of generation payment voucher, wherein, method specifically includes 1）Payment ATL setting steps, 2）Receiving step, 3）Extraction step, 4）Matching step, 5）Generation step.The present invention for the every two groups of calculation business vouchers with insider transaction business reconciliation incidence relation automatically generate payment voucher, reduces the work of artificial establishment payment voucher by setting payment ATL and matching condition, accelerates the progress of work.
Description
【Technical field】
The invention belongs to group financial management field of information system, it is related to the insider transaction industry of business group internal intercompany
Treatment of the business in information system, more particularly to realizes that insider transaction business carries out the method and device of generation payment voucher.
【Background technology】
Insider transaction is generally referred in the range of the enterprise group that is made up of parent company and its all subsidiary, parent company and son
The transaction that company, subsidiary occur each other, for example：Inside purchase and sale, equity in group between parent company and subsidiary company or subsidiary are thrown
Money etc..The insider transaction business occurred in enterprise group, when group provides consolidated financial statement, requires palpus in accounting system
Merge offset processing.
Existing most of conglomerate associates and supports when consolidated financial statement is provided for the reconciliation of insider transaction business
Pin is typically all that hand weaving is carried out when consolidated accounts is gone out, and internally conclude the business frequently conglomerate, checks insider transaction number
It is very big according to, the payment voucher workload of working out these insider transactions, it is also more inaccurate, and easily there is mistake.
【The content of the invention】
The invention solves the problems that first technical problem be to provide one kind realize insider transaction business carry out generation payment with
The method of card, can greatly reduce the artificial operation that insider transaction business is carried out generation payment voucher.
The invention solves the problems that second technical problem be to provide one kind realize insider transaction business carry out generation payment with
The device of card, can greatly reduce the artificial operation that insider transaction business is carried out generation payment voucher.
Above-mentioned first technical problem is solved by the following technical programs：
Realize the method that insider transaction business carries out generation payment voucher, it is characterised in that specifically include：
1）Payment ATL is set, and payment template includes multiple payment templates, and each payment template is each exclusive to that should have
Matching condition；
2）Receive the calculation business voucher that each internal unit is uploaded；
3）In received calculation business voucher, to the every two groups of core with insider transaction business reconciliation incidence relation
Business voucher is calculated, the information described in every two groups of calculation business vouchers is extracted；
4）Matched in ATL is offseted according to the information for being extracted, find out corresponding payment template；
5）With reference to the information for being extracted, according to the payment template found out, generation payment voucher.
Step 1）In, matching condition is the set of multiple subject attributes；Step 4）Specially：According to every two groups of accounting
The set of the subject service attribute described in business voucher, matches in ATL is offseted, and finds out corresponding payment template.
The side of the insider transaction business reconciliation incidence relation is set up in calculation business voucher received by being additionally included in
Method, it is specifically included：
S1）, set and need the subject adjusted and object, it is necessary to the object adjusted includes internal unit and sensing
The non-unity object of internal unit；
S2）, receive each internal unit and be input into respective calculation business voucher；
S3）, according to step S1）The subject and object adjusted the need for middle setting, in received calculation business
Be identified in voucher, the calculation business voucher that will meet screening conditions is extracted, the screening conditions be calculation business with
Card records the subject and object adjusted in need；
S4）, according to default one-to-one reconciliation correlation rule, automatically will be every in the calculation business voucher for being screened
Man-to-man reconciliation incidence relation is set up between two calculation business vouchers for meeting the pair of reconciliation correlation rule；
S5）, in the calculation business voucher for being screened but not being automatically established reconciliation incidence relation, selection adhere to separately in two
The calculation business voucher of portion's unit carries out the input request of reconciliation association, and it is right to be set up between selected calculation business voucher
Account incidence relation, the selected calculation business voucher for adhering to two internal units separately mutually recites and other side or points to other side
The transaction record of non-unity object.
Above-mentioned second technical problem is solved by the following technical programs：
Realize that insider transaction business carries out the device of generation payment voucher, it is characterised in that specifically include：
Payment ATL setup module, for setting payment ATL, payment template includes multiple payment templates, and each is supported
Pin template is to that should have each exclusive matching condition；
Receiver module, for receiving the calculation business voucher that each internal unit is uploaded；
Extraction module, in received calculation business voucher, being closed to being associated with the reconciliation of insider transaction business
Every two groups of calculation business vouchers of system, extract the information described in every two groups of calculation business vouchers；
Matching module, for being matched in ATL is offseted according to the information for being extracted, finds out corresponding payment mould
Plate；
Generation module, for combining extracted information, according to the payment template found out, generation payment voucher.
Matching condition in payment ATL setup module is the set of multiple subject attributes；Matching module is specifically basis
The set of the subject service attribute described in every two groups of calculation business vouchers, matches in ATL is offseted, and finds out corresponding
Payment template.
The pass of the insider transaction business reconciliation incidence relation is set up in calculation business voucher received by being additionally included in
It is device, it is specifically included：
Setup module, for setting the subject and object that need to be adjusted, it is necessary to the object adjusted includes inside
The non-unity object of unit and inwardly directed unit；
Receiver module, respective calculation business voucher is input into for receiving each internal unit；
Screening module, the subject and object adjusted the need for being set in setup module for basis, is being received
To calculation business voucher in be identified, the calculation business voucher that will meet screening conditions is extracted, the screening conditions
For calculation business voucher records the subject and object adjusted in need；
Auto-associating module, for according to default one-to-one reconciliation correlation rule, in the calculation business for being screened
Set up between the automatic two calculation business vouchers that will often meet the pair of reconciliation correlation rule in voucher man-to-man
Reconciliation incidence relation；
Manual association's module, for being screened out but not being automatically established the calculation business voucher of reconciliation incidence relation
In, select the calculation business voucher for adhering to two internal units separately to carry out the input request of reconciliation association, in selected accounting industry
Reconciliation incidence relation is set up between business voucher, the selected calculation business voucher for adhering to two internal units separately mutually recites
With other side or the transaction record of the non-unity object for pointing to other side.
The present invention is by setting payment ATL and matching condition come for insider transaction business reconciliation incidence relation
Every two groups of calculation business vouchers automatically generate payment voucher, reduce the work of artificial establishment payment voucher, accelerate the progress of work.
In addition, by way of increasing artificial reconciliation, further improving the work rendered an account.
Further scheme is that specific restriction is done to automatic account correlation rule in the above method and said apparatus.Specifically
It is that automatic account correlation rule includes the first rule：Two calculation business vouchers are in the state of " non-reconciliation association ", belong to two
Individual internal unit, recites the transaction record with other side respectively, and the business amount of money of the two transaction records is equal, traffic direction phase
Instead.
Automatic account correlation rule also includes Second Rule：In two transaction records of calculation business voucher respectively contain with it is right
The corresponding reconciliation keyword in side.
The automatic account correlation rule also includes three sigma rule：Meet aforementioned rule and belong to two internal units
In two groups of calculation business vouchers, the accounting between two groups of calculation business vouchers is matched by the generation sequencing of calculation business voucher
Business voucher.
【Brief description of the drawings】
Fig. 1 is the flow chart of the inventive method of embodiment one；
Fig. 2 is the structured flowchart of the apparatus of the present invention of embodiment one；
Fig. 3 is the flow chart of the method that embodiment two sets up insider transaction business reconciliation incidence relation；
Fig. 4 is the structured flowchart of the relation device of embodiment two；
Fig. 5 is the schematic diagram that embodiment two sets object；
Fig. 6 is the schematic diagram of the automatic reconciliation of embodiment two association.
【Specific embodiment】
Embodiment one
As shown in figure 1, realizing the method that insider transaction business carries out generation payment voucher, specifically include：
1）, setting steps：Payment ATL is set, and payment template includes multiple payment templates, and each payment template has respectively
From exclusive matching condition.Each payment template have recorded multiple subjects and direction corresponding with each subject, subject business
Attribute, amount of money figure selection formula.
One of which payment template is internal sales stock template, its specific pattern such as table one.
Table one
| Sequence number | Direction | Subject | Amount of money figure selection formula | Subject attribute |
| 1 | Borrow | Accounts receivable | - [Credential data] | Contact |
| 2 | Borrow | Accounts payable | - [Credential data] | Contact |
| 3 | Borrow | Raw material | - [Credential data] * [comprehensive gross profit] | Stock |
| 4 | Borrow | Main business cost | - { [main business income loan]-[raw material are borrowed] } | Cost |
| 5 | Borrow | Main business income | - [Credential data] | Income |
2）Receiving step：Receive the calculation business voucher of each internal unit input.Each calculation business voucher describes this
Financial records of the transaction record and the transaction of unit and other unit transaction to the direct formation of our unit；Transaction record includes section
Mesh, direction, subject service attribute, object, the amount of money；Financial records include subject, direction, subject service attribute, the amount of money.
3）Extraction step：To there is interior business transaction reconciliation incidence relation in the calculation business voucher that is received every two
Group calculation business voucher, extracts the information described in it.One-to-one corresponding is described between every two groups of calculation business vouchers
Transaction record.
For example, it is assumed that two groups of calculation business vouchers with interior business transaction reconciliation incidence relation are defeated for internal unit A
The calculation business voucher 102 that the calculation business voucher 101 for entering is input into internal unit B；As shown in table 2, internal unit A is input into
Calculation business voucher 101 describes the transaction record with internal unit B；As shown in table 3, the calculation business of internal unit B inputs
Voucher 102 describes the transaction record with internal unit A.Therefore, the information of extraction is specific such as table 4.
Table 2
| Direction | Subject | Object | The amount of money | Subject attribute | |
| Transaction record 1 | Borrow | Accounts receivable | B units | 10,000.00 | Contact |
| Financial records | Borrow | Main business income | 10,000.00 | Income |
Table 3
| Direction | Subject | Object | The amount of money | Subject attribute | |
| Financial records | Borrow | Raw material | 10,000.00 | Stock | |
| Transaction record 1 | Borrow | Accounts payable | A units | 10,000.00 | Contact |
Table 4
| Sequence number | Direction | Subject | Object | The amount of money | Subject attribute |
| 1 | Borrow | Accounts receivable | B units | 10,000.00 | Contact |
| 2 | Borrow | Main business income | 10,000.00 | Income | |
| 3 | Borrow | Raw material | 10,000.00 | Stock | |
| 4 | Borrow | Accounts payable | A units | 10,000.00 | Contact |
4）Matching step：Matched in ATL is offseted according to the information for being extracted, find out corresponding payment template.
In the practical application of the applicant, the matching condition of each payment template is the collection of multiple subject service attributes
Close, simply each set is different.
The matching condition for offseting template-internal sales stock template is served as reasons the subject business that " contact, income, stock " constituted
Attribute set, the cost described in internal sales stock template is also subject service attribute, but is used not as matching.
By taking calculation business voucher 101 and calculation business voucher 102 with reconciliation incidence relation as an example, extracted
Information can draw the two calculation business vouchers subject service attribute set, the set include come and go, take in, depositing
Goods.
Therefore, internal sales stock template is have found in ATL is offseted by two matchings of set, its specific sample
Formula such as table one.
5）Generation step:With reference to the information for being extracted, according to the payment template found out, generation payment voucher.
The step is specifically included：
501）In the case of two groups of calculation business vouchers of verification are man-to-man, first compare phase in two calculation business vouchers
Whether the amount of money of corresponding transaction record is consistent, if unanimously, pressed with the value data of two groups of records of calculation business voucher
The payment template Shang Ge sections purpose amount of money is calculated according to payment template Shang Ge section's purpose amount of money figure selection formulas；With reference to what is calculated
The amount of money, according to the payment template found out, generation payment voucher；Therefore, payment voucher describe payment template each subject and
Corresponding traffic direction, subject service attribute, object.
For example, by taking calculation business voucher 101 and calculation business voucher 102 with reconciliation incidence relation as an example, its generation
Payment voucher described information such as table 5.
Table 5
| Direction | Subject | Object | The amount of money |
| Borrow | Accounts receivable | B units | -10,000 |
| Borrow | Accounts payable | A units | -10,000 |
| Borrow | Raw material | -1,000 | |
| Borrow | Main business cost | -9000 | |
| Borrow | Main business income | -10,000 |
502）In the case of two groups of calculation business vouchers of verification are man-to-man, first compare phase in two calculation business vouchers
Whether the amount of money of corresponding transaction record is consistent, if it is inconsistent, using the amount of money minimum in transaction record as two groups of accounting
The amount of money of transaction record and financial records on business voucher, then, with the value data after adjustment according to payment template Shang Ge sections
Purpose amount of money figure selection formula offsets the template Shang Ge sections purpose amount of money to calculate；With reference to the amount of money for being calculated, according to being found out
Payment template, generation payment voucher；Therefore, payment voucher describe payment template each subject and corresponding traffic direction,
The amount of money, object.
For example, with the calculation business voucher 103 with reconciliation incidence relation（It is shown in Table 6）With calculation business voucher 104（It is shown in Table
7）As a example by, the described information such as table 8 of the payment voucher of its generation.
Table 6
| Direction | Subject | Object | The amount of money | Subject attribute | |
| Transaction record 1 | Borrow | Accounts receivable | C units | 10,000.00 | Contact |
| Financial records | Borrow | Main business income | 10,000.00 | Income |
Table 7
| Direction | Subject | Object | The amount of money | Subject attribute | |
| Financial records | Borrow | Raw material | 9,000 | Stock |
| Transaction record 1 | Borrow | Accounts payable | D units | 9,000 | Contact |
Table 8
| Direction | Subject | Object | The amount of money |
| Borrow | Accounts receivable | C units | -9,000 |
| Borrow | Accounts payable | D units | -9,000 |
| Borrow | Raw material | -900 | |
| Borrow | Main business cost | -8,100 | |
| Borrow | Main business income | -9,000 |
503）It is when two groups of calculation business vouchers are checked：First group only includes a calculation business voucher, and second group includes N
Individual calculation business voucher, N is the natural number more than 1；Now, first group of calculation business voucher contains N bars transaction record and one
Bar financial records, second group each calculation business voucher describes a transaction record and a financial records, first
The N bar transaction records of the calculation business voucher of group correspond respectively to the transaction record of second group of N number of calculation business voucher；One by one
Ground will carry out following operation including each calculation business voucher in second group and first group of calculation business voucher：By first group
Calculation business voucher on the amount of money of financial records and the amount of money of corresponding transaction record be adjusted to described second group in it is each
The amount of money of the transaction record described in individual calculation business voucher, then in conjunction with financial records on first group of calculation business voucher,
Corresponding transaction record and it is described second group in financial records and transaction record on each calculation business voucher, according to payment
Template Shang Ge sections purpose amount of money figure selection formula offsets the template Shang Ge sections purpose amount of money to calculate；With reference to the amount of money for being calculated,
According to the payment template found out, generation payment voucher；Therefore, payment voucher describes payment each subject of template and corresponding
Traffic direction, the amount of money, object.As can be seen here, by step 503）N number of payment voucher can be generated.
For example, by taking first group of calculation business voucher and second group of calculation business voucher with reconciliation incidence relation as an example.
The calculation business voucher 105 that first group of calculation business voucher only one of which is uploaded by G units, is specifically shown in Table 9, its；Second group of core
Calculating business voucher has two calculation business vouchers 106,107 for being uploaded by E units, F units respectively, and 10 and table are specifically shown in Table respectively
11.The payment voucher that calculation business voucher 105 is offseted and generated with calculation business voucher 106, the information described in it is such as
Table 12.The payment voucher that calculation business voucher 105 is offseted and generated with calculation business voucher 107, the information described in it
Such as table 13.
Table 9
| Direction | Subject | Object | The amount of money | Subject attribute | |
| Transaction record 1 | Borrow | Accounts receivable | E units | 18,000 | Contact |
| Transaction record 2 | Borrow | Accounts receivable | F units | 10,000 | Contact |
| Financial records | Borrow | Main business income | 18,000 | Income |
Table 10
| Direction | Subject | Object | The amount of money | Subject attribute | |
| Financial records | Borrow | Raw material | 10,000 | Stock | |
| Transaction record 1 | Borrow | Accounts payable | G units | 10,000 | Contact |
Table 11
| Direction | Subject | Object | The amount of money | Subject attribute | |
| Financial records | Borrow | Raw material | 8,000 | Stock | |
| Transaction record 1 | Borrow | Accounts payable | G units | 8,000 | Contact |
Table 12
| Direction | Subject | Object | The amount of money |
| Borrow | Accounts receivable | E units | -10,000 |
| Borrow | Accounts payable | G units | -10,000 |
| Borrow | Raw material | -1,000 | |
| Borrow | Main business cost | -9,000 | |
| Borrow | Main business income | -10,000 |
Table 13
| Direction | Subject | Object | The amount of money |
| Borrow | Accounts receivable | F units | -8,000 |
| Borrow | Accounts payable | G units | -8,000 |
| Borrow | Raw material | -800 | |
| Borrow | Main business cost | -7,200 | |
| Borrow | Main business income | -8,000 |
As shown in Fig. 2 realizing that insider transaction business carries out the device of generation payment voucher, specifically include：
1）, setup module, it is used to set payment ATL, and payment template includes multiple payment templates, each payment mould
Plate has each exclusive matching condition.Specifically, each payment template have recorded multiple subjects and corresponding with each subject
Direction, subject service attribute, amount of money figure selection formula.
One of which payment template is internal sales stock template, its specific pattern such as table 1.
2）Receiver module, the calculation business voucher for receiving each internal unit input.Each calculation business voucher is recorded
The financial records of the transaction record of our unit and other unit transaction and the transaction to our unit direct formation；Transaction record bag
Include subject, direction, subject service attribute, object, the amount of money；Financial records include subject, direction, subject service attribute, the amount of money.
3）Extraction module, for having interior business transaction reconciliation incidence relation in the calculation business voucher to being received
Every two groups of calculation business vouchers, extract the information described in it.Described one by one between every two groups of calculation business vouchers
Corresponding transaction record.
For example, it is assumed that two groups of calculation business vouchers with interior business transaction reconciliation incidence relation are defeated for internal unit A
The calculation business voucher 102 that the calculation business voucher 101 for entering is input into internal unit B；As shown in table 2, internal unit A is input into
Calculation business voucher 101 describes the transaction record with internal unit B；As shown in table 3, the calculation business of internal unit B inputs
Voucher 102 describes the transaction record with internal unit A.Therefore, the information of extraction is specific such as table 4.
4）Matching module, for being matched in ATL is offseted according to the information for being extracted, finds out corresponding payment
Template.
In the practical application of the applicant, the matching condition of each payment template is the collection of multiple subject service attributes
Close, simply each set is different.
The matching condition for offseting template-internal sales stock template is served as reasons the subject business that " contact, income, stock " constituted
Attribute set, the cost described in internal sales stock template is also subject service attribute, but is used not as matching.
By taking calculation business voucher 101 and calculation business voucher 102 with reconciliation incidence relation as an example, extracted
Information can draw the two calculation business vouchers subject service attribute set, the set include come and go, take in, depositing
Goods.
Therefore, internal sales stock template is have found in ATL is offseted by two matchings of set, its specific sample
Formula such as table 1.
5）Generation module, for combining extracted information, according to the payment template found out, generation payment with
Card.
Generation module specifically carries out following operation：
501）In the case of two groups of calculation business vouchers of verification are man-to-man, first compare phase in two calculation business vouchers
Whether the amount of money of corresponding transaction record is consistent, if unanimously, pressed with the value data of two groups of records of calculation business voucher
The payment template Shang Ge sections purpose amount of money is calculated according to payment template Shang Ge section's purpose amount of money figure selection formulas；With reference to what is calculated
The amount of money, according to the payment template found out, generation payment voucher；Therefore, payment voucher describe payment template each subject and
Corresponding traffic direction, subject service attribute, object.
For example, by taking calculation business voucher 101 and calculation business voucher 102 with reconciliation incidence relation as an example, its generation
Payment voucher described information such as table 5.
502）In the case of two groups of calculation business vouchers of verification are man-to-man, first compare phase in two calculation business vouchers
Whether the amount of money of corresponding transaction record is consistent, if it is inconsistent, using the amount of money minimum in transaction record as two groups of accounting
The amount of money of transaction record and financial records on business voucher, then, with the value data after adjustment according to payment template Shang Ge sections
Purpose amount of money figure selection formula offsets the template Shang Ge sections purpose amount of money to calculate；With reference to the amount of money for being calculated, according to being found out
Payment template, generation payment voucher；Therefore, payment voucher describe payment template each subject and corresponding traffic direction,
The amount of money, object.
For example, with the calculation business voucher 103 with reconciliation incidence relation（It is shown in Table 6）With calculation business voucher 104（It is shown in Table
7）As a example by, the described information such as table 8 of the payment voucher of its generation.
503）It is when two groups of calculation business vouchers are checked：First group only includes a calculation business voucher, and second group includes N
Individual calculation business voucher, N is the natural number more than 1；Now, first group of calculation business voucher contains N bars transaction record and one
Bar financial records, second group each calculation business voucher describes a transaction record and a financial records, first
The N bar transaction records of the calculation business voucher of group correspond respectively to the transaction record of second group of N number of calculation business voucher；One by one
Ground will carry out following operation including each calculation business voucher in second group and first group of calculation business voucher：By first group
Calculation business voucher on the amount of money of financial records and the amount of money of corresponding transaction record be adjusted to described second group in it is each
The amount of money of the transaction record described in individual calculation business voucher, then in conjunction with financial records on first group of calculation business voucher,
Corresponding transaction record and it is described second group in financial records and transaction record on each calculation business voucher, according to payment
Template Shang Ge sections purpose amount of money figure selection formula offsets the template Shang Ge sections purpose amount of money to calculate；With reference to the amount of money for being calculated,
According to the payment template found out, generation payment voucher；Therefore, payment voucher describes payment each subject of template and corresponding
Traffic direction, the amount of money, object.As can be seen here, by step 403）N number of payment voucher can be generated.
For example, by taking first group of calculation business voucher and second group of calculation business voucher with reconciliation incidence relation as an example.
The calculation business voucher 105 that first group of calculation business voucher only one of which is uploaded by G units, is specifically shown in Table 9, its；Second group of core
Calculating business voucher has two calculation business vouchers 106,107 for being uploaded by E units, F units respectively, and 10 and table are specifically shown in Table respectively
11.The payment voucher that calculation business voucher 105 is offseted and generated with calculation business voucher 106, the information described in it is such as
Table 12.The payment voucher that calculation business voucher 105 is offseted and generated with calculation business voucher 107, the information described in it
Such as table 13.
Embodiment two
The present embodiment mainly describes how to judge to confirm which is adjusted in the calculation business voucher of each internal unit input
There is insider transaction business reconciliation incidence relation between business voucher and which calculation business voucher.
As shown in figure 3, setting up the insider transaction business reconciliation incidence relation in received calculation business voucher
Method, specifically include：
1）, setting steps：The subject and object for needing to be adjusted are set；The subject also known as dealing section that needs are adjusted
Mesh.
The specific such as table 1 that subject is set, can specifically include subject code, Course in English and indicate whether to need to carry out core
Calculate.
Table one
| Subject code | Course in English | Whether come and go subject |
| 1121 | Bill receivable | It is |
| 1122 | Accounts receivable | It is |
| 1123 | Advance money | It is |
The object that needs are adjusted includes internal unit and sensing（Show corresponding relation）The non-unity pair of internal unit
As（Also known as other objects）, non-unity object can be contract or bill.As shown in figure 5, in being set in existing financial system
Portion's unit 1 and internal unit 2, and inwardly directed unit 1 contract 11 and bill 21, and inwardly directed unit 2 the He of contract 12
Bill 22；For the ease of the work of financial system, internal unit 1 is corresponded to using tissue B, corresponded to using tissue C internal single
Position 2.
2）Screening step：According to step 1）The subject and object adjusted the need for middle setting, in received core
It is identified in calculation business voucher, the calculation business voucher that will meet screening conditions is extracted, the screening conditions are accounting
Business voucher records the subject and object adjusted in need.
For example, calculation business voucher one is specifically recorded：Borrow：Accounts receivable-K units（Non- internal unit）, borrow：Main management industry
Business income.Object-K units in the voucher are not internal units, are not required to extract the voucher.
Calculation business voucher two is specifically recorded：Borrow：Accounts receivable-A units（Internal unit）, borrow：Main business income.
Object-A units in the voucher are internal units, and subject-accounts receivable is dealing subject, so extracting the voucher.
Calculation business voucher three is specifically recorded：Borrow：Intrabranch（Non- contact subject）- A units（Internal unit）, borrow：
Cash in banks.Object-A units in the voucher are internal units, but subject-intrabranch is not belonging to the subject that comes and goes, and is not required to
Extract the voucher.
3）, auto-associating step：According to default one-to-one reconciliation correlation rule, the calculation business for being screened with
It is man-to-man right to be set up between the automatic two calculation business vouchers that will often meet the pair of reconciliation correlation rule in card
Account incidence relation；Then, put on to each two calculation business voucher for having established reconciliation incidence relation identical and exclusive
Reconciliation connective marker ID, in " reconciliation association " state.
The automatic account Correlation Criteria includes the first rule：Two calculation business vouchers are in the shape of " non-reconciliation association "
State, belongs to two internal units（Calculation business voucher belong to input its internal unit）, the friendship with other side is recite respectively
Easily record, the dealing money of the two transaction records is equal, in opposite direction.Wherein, direction is marked with opposite " borrowing " and " loan "
Note.
As shown in fig. 6, the calculation business voucher of the input of internal unit 11 records the transaction record with internal unit 12：Direction
It is by means of subject is accounts receivable, and other side is internal unit 12, the amount of money 10000, the calculation business voucher note of the input of internal unit 12
Carry the transaction record with internal unit 11：To borrow, subject is accounts payable in direction, and other side is internal unit 11, the amount of money 10000；
Therefore, the two calculation business vouchers are automatically established reconciliation incidence relation.
If the transaction record of the calculation business voucher of reconciliation both sides is provided with reconciliation keyword（Set on demand）, it is right to look for
The transaction record that there is identical reconciliation keyword side carries out automatic reconciliation, it is impossible to other record reconciliations；It is described for this kind of situation
Automatic account Correlation Criteria also includes Second Rule：Respectively containing corresponding with other side in two transaction records of calculation business voucher
Reconciliation keyword.
During automatic reconciliation, if it is internal single with another one or more calculation business vouchers of internal unit occur
One or more calculation business vouchers of position occur regular（If the only first rule, aforementioned rule is the first rule；Such as
Fruit has the first rule and Second Rule, and aforementioned rule is the first rule and Second Rule）Meet, but because automatic reconciliation is
It is one-to-one（A calculation business voucher only can form reconciliation and associate with another calculation business voucher i.e. in automatic reconciliation
System）, the automatic account Correlation Criteria is also including three sigma rule：Meeting above-mentioned first rule（If Second Rule, then symbol is needed
In closing aforementioned rule and belonging to two the two of internal unit groups of calculation business vouchers, the generation by calculation business voucher is successively suitable
Sequence matches the calculation business voucher between two groups of calculation business vouchers.
Have been used for setting up the calculation business voucher of reconciliation incidence relation, put on reconciliation connective marker, in " reconciliation is closed
Connection " state.
One-to-one reconciliation correlation rule is not limited to above-mentioned first rule or the first rule and Second Rule, three sigma rule
Combination, can design according to actual needs, and its particular content is not the necessary condition for solving the object of the invention；
4）, manual association's step：In the calculation business voucher for being screened out but not being automatically established reconciliation incidence relation,
Input selection adheres to two the two of internal unit groups of calculation business vouchers separately（I.e. one group calculation business voucher belongs to an internal list
Position, another group of calculation business voucher belongs to another internal unit）The request of reconciliation association is carried out, in selected calculation business
Set up reconciliation incidence relation between voucher, it is selected to adhere to two the two of internal unit groups of calculation business vouchers separately and mutually record
The transaction record with other side or the non-unity object for pointing to other side, to the every two groups of accounting industry for having established reconciliation incidence relation
Business voucher puts on identical and exclusive reconciliation connective marker ID.
This mode for being not belonging to automatic reconciliation association, is specifically provided with " manual reconciliation " and " pressure reconciliation " side in practice
Formula, is all to need artificial reconciliation.
In the mode of " manual reconciliation ", one the one of internal unit group can be selected（One or more）Calculation business with
One group of card and another internal unit（One or more）Calculation business voucher carries out reconciliation, but requires the two internal units
Two groups of calculation business vouchers mutually recite other side or point to other side other objects, and reconciliation total amount will equity.
In the mode of " pressure reconciliation ", one the one of internal unit group can be selected（One or more）Calculation business with
Demonstrate,prove a group with corresponding another internal unit（One or more）Calculation business voucher carries out reconciliation, but requires in the two
The calculation business voucher of portion's unit mutually recites other side or points to other objects of other side, and the total amount of reconciliation however it is reciprocity
's.
As shown in figure 4, the method that the above-mentioned internal correlation transaction business of correspondence carries out reconciliation association, carries in this specific embodiment
The device that internal correlation transaction business carries out reconciliation association is realized for a kind of, including：
1）, setup module, need the subject and object adjusted for setting；The subject that needs are adjusted is also known as coming
Toward subject.
The specific such as table one that subject is set, can specifically include subject code, Course in English and indicate whether that needs are carried out
Adjust.
The object that needs are adjusted includes internal unit and sensing（Show corresponding relation）The non-unity pair of internal unit
As（Also known as other objects）, non-unity object can be contract or bill.As shown in figure 5, in being set in existing financial system
Portion's unit 1 and internal unit 2, and inwardly directed unit 1 contract 11 and bill 21, and inwardly directed unit 2 the He of contract 12
Bill 22；For the ease of the work of financial system, internal unit 1 is corresponded to using tissue B, corresponded to using tissue C internal single
Position 2.
2）, screening module, the subject and object adjusted the need for being set in the setup module for basis connect
It is identified in the calculation business voucher for receiving, the calculation business voucher that will meet screening conditions is extracted, the screening bar
Part is that calculation business voucher records the subject and object adjusted in need.
For example, calculation business voucher one is specifically recorded：Borrow：Accounts receivable-K units（Non- internal unit）, borrow：Main management industry
Business income.Object-K units in the voucher are not internal units, are not required to extract the voucher.
Calculation business voucher two is specifically recorded：Borrow：Accounts receivable-A units（Internal unit）, borrow：Main business income.
Object-A units in the voucher are internal units, and subject-accounts receivable is dealing subject, so extracting the voucher.
Calculation business voucher three is specifically recorded：Borrow：Intrabranch（Non- contact subject）- A units（Internal unit）, borrow：
Cash in banks.Object-A units in the voucher are internal units, but subject-intrabranch is not belonging to the subject that comes and goes, and is not required to
Extract the voucher.
3）, auto-associating module, for according to default one-to-one reconciliation correlation rule, in the accounting industry for being screened
Set up between the automatic two calculation business vouchers that will often meet the pair of reconciliation correlation rule in business voucher one-to-one
Reconciliation incidence relation；Then, put on to each two calculation business voucher for having established reconciliation incidence relation identical and only
Some reconciliation connective marker ID, in " reconciliation association " state.
The automatic account Correlation Criteria includes the first rule：Two calculation business vouchers are in the shape of " non-reconciliation association "
State, belongs to two internal units（Calculation business voucher belong to input its internal unit）, the friendship with other side is recite respectively
Easily record, the dealing money of the two transaction records is equal, in opposite direction.Wherein, direction is marked with opposite " borrowing " and " loan "
Note.
As shown in fig. 6, the calculation business voucher of the input of internal unit 11 records the transaction record with internal unit 12：Direction
It is by means of subject is accounts receivable, and other side is internal unit 12, the amount of money 10000, the calculation business voucher note of the input of internal unit 12
Carry the transaction record with internal unit 11：To borrow, subject is accounts payable in direction, and other side is internal unit 11, the amount of money 10000；
Therefore, the two calculation business vouchers are automatically established reconciliation incidence relation.
If the transaction record of the calculation business voucher of reconciliation both sides is provided with reconciliation keyword（Set on demand）, it is right to look for
The transaction record that there is identical reconciliation keyword side carries out automatic reconciliation, it is impossible to other record reconciliations；It is described for this kind of situation
Automatic account Correlation Criteria also includes Second Rule：Respectively containing corresponding with other side in two transaction records of calculation business voucher
Reconciliation keyword.
During automatic reconciliation, if it is internal single with another one or more calculation business vouchers of internal unit occur
One or more calculation business vouchers of position occur regular（If the only first rule, aforementioned rule is the first rule；Such as
Fruit has the first rule and Second Rule, and aforementioned rule is the first rule and Second Rule）Meet, but because automatic reconciliation is
It is one-to-one（A calculation business voucher only can form reconciliation and associate with another calculation business voucher i.e. in automatic reconciliation
System）, the automatic account Correlation Criteria is also including three sigma rule：Meeting above-mentioned first rule（If Second Rule, then symbol is needed
In closing aforementioned rule and belonging to two the two of internal unit groups of calculation business vouchers, the generation by calculation business voucher is successively suitable
Sequence matches the calculation business voucher between two groups of calculation business vouchers.
Have been used for setting up the calculation business voucher of reconciliation incidence relation, put on reconciliation connective marker, in " reconciliation is closed
Connection " state.
One-to-one reconciliation correlation rule is not limited to above-mentioned first rule or the first rule and Second Rule, three sigma rule
Combination, can design according to actual needs, and its particular content is not the necessary condition for solving the object of the invention；
4）, manual association's module, for be screened out but be not automatically established the calculation business of reconciliation incidence relation with
In card, input selection adheres to two the two of internal unit groups of calculation business vouchers separately carries out the request of reconciliation association, selected
Reconciliation incidence relation is set up between two groups of calculation business vouchers, it is selected to adhere to two the two of internal unit groups of calculation business separately
Voucher mutually recites the transaction record with other side or the non-unity object for pointing to other side, to having established reconciliation incidence relation
Every two groups of calculation business vouchers put on identical and exclusive reconciliation connective marker ID.
This mode for being not belonging to automatic reconciliation association, is specifically provided with " manual reconciliation " and " pressure reconciliation " side in practice
Formula, is all to need artificial reconciliation.
In the mode of " manual reconciliation ", one the one of internal unit group can be selected（One or more）Calculation business with
One group of card and another internal unit（One or more）Calculation business voucher carries out reconciliation, but requires the two internal units
Two groups of calculation business vouchers mutually recite other side or point to other side other objects, and reconciliation total amount will equity.
In the mode of " pressure reconciliation ", one the one of internal unit group can be selected（One or more）Calculation business with
Demonstrate,prove a group with corresponding another internal unit（One or more）Calculation business voucher carries out reconciliation, but requires in the two
Two groups of calculation business vouchers of portion's unit mutually recite other side or point to other side other objects, and reconciliation total amount otherwise
Equity.
The present invention is not limited to above-described embodiment, simple replacement based on above-described embodiment, not making creative work,
Should belong to the invention discloses scope.
Claims (8)
1. the method that insider transaction business carries out generation payment voucher is realized, it is characterised in that specifically included：
1), payment ATL is set, and payment ATL includes multiple payment templates, and each payment template is each exclusive to that should have
Matching condition, matching condition is the set of multiple subject attributes；
2) the calculation business voucher that each internal unit is uploaded is received；
3) in received calculation business voucher, to the every two groups of accounting industry with insider transaction business reconciliation incidence relation
Business voucher, extracts the information described in every two groups of calculation business vouchers；
4) set of the subject service attribute according to described in every two groups of calculation business vouchers, offset ATL in
Match somebody with somebody, find out corresponding payment template；
5) extracted information is combined, according to the payment template found out, generation payment voucher；
The method that the insider transaction business reconciliation incidence relation is set up in calculation business voucher received by being additionally included in, its
Specifically include：
S1), setting needs the subject adjusted and object, it is necessary to the object adjusted includes internal unit and inwardly directed
The non-unity object of unit；
S2), receive each internal unit and be input into respective calculation business voucher；
S3), according to step S1) in set the need for the subject and object adjusted, in received calculation business voucher
In be identified, the calculation business voucher that will meet screening conditions is extracted, the screening conditions be calculation business voucher note
It is loaded with the subject and object for needing to be adjusted；
S4), according to default one-to-one reconciliation correlation rule, will often meet automatically in the calculation business voucher for being screened
Man-to-man reconciliation incidence relation is set up between two calculation business vouchers of the pair of reconciliation correlation rule；
S5), in the calculation business voucher for being screened but not being automatically established reconciliation incidence relation, selection adheres to two internal lists separately
The calculation business voucher of position carries out the input request of reconciliation association, and reconciliation pass is set up between selected calculation business voucher
Connection relation, the selected calculation business voucher for adhering to two internal units separately mutually recites with other side or points to the non-list of other side
The transaction record of position object.
2. it is according to claim 1 to realize the method that insider transaction business carries out generation payment voucher, it is characterised in that institute
Stating one-to-one reconciliation correlation rule includes the first rule：Two calculation business vouchers are in the state of " non-reconciliation association ", adhere to separately
In two internal units, the transaction record with other side is recite respectively, the business amount of money of the two transaction records is equal, direction phase
Instead.
3. it is according to claim 2 to realize the method that insider transaction business carries out generation payment voucher, it is characterised in that institute
Stating one-to-one reconciliation correlation rule also includes Second Rule：Contain respectively and other side in two transaction records of calculation business voucher
Corresponding reconciliation keyword.
4. the method that insider transaction business carries out generation payment voucher is realized according to Claims 2 or 3, its feature exists
In the pair of reconciliation correlation rule also includes three sigma rule：Meet aforementioned rule and belong to two internal units
In two groups of calculation business vouchers, the accounting between two groups of calculation business vouchers is matched by the generation sequencing of calculation business voucher
Business voucher.
5. realize that insider transaction business carries out the device of generation payment voucher, it is characterised in that specifically include：
Payment ATL setup module, for setting payment ATL, payment ATL includes multiple payment templates, each payment
To that should have each exclusive matching, matching condition is the set of multiple subject attributes to template；
Receiver module, for receiving the calculation business voucher that each internal unit is uploaded；
Extraction module, in received calculation business voucher, to insider transaction business reconciliation incidence relation
Every two groups of calculation business vouchers, extract the information described in every two groups of calculation business vouchers；
Matching module, for the set of the subject service attribute according to described in every two groups of calculation business vouchers, in payment
Matched in ATL, find out corresponding payment template；
Generation module, for combining extracted information, according to the payment template found out, generation payment voucher；
The relation dress of the insider transaction business reconciliation incidence relation is set up in calculation business voucher received by being additionally included in
Put, it is specifically included：
Setup module, for setting the subject and object that need to be adjusted, it is necessary to the object adjusted includes internal unit
And the non-unity object of inwardly directed unit；
Receiver module, respective calculation business voucher is input into for receiving each internal unit；
Screening module, the subject and object adjusted the need for being set in setup module for basis, received
It is identified in calculation business voucher, the calculation business voucher that will meet screening conditions is extracted, the screening conditions are core
Calculate business voucher and record the subject and object adjusted in need；
Auto-associating module, for according to default one-to-one reconciliation correlation rule, in the calculation business voucher for being screened
In set up man-to-man reconciliation between the automatic two calculation business vouchers that will often meet the pair of reconciliation correlation rule
Incidence relation；
Manual association's module, in the calculation business voucher for being screened out but not being automatically established reconciliation incidence relation, selecting
Select adhere to separately two internal units calculation business voucher carry out reconciliation association input request, in selected calculation business voucher
Between set up reconciliation incidence relation, the selected calculation business voucher for adhering to two internal units separately mutually recites and other side
Or point to the transaction record of the non-unity object of other side.
6. it is according to claim 5 to realize the device that insider transaction business carries out generation payment voucher, it is characterised in that institute
Stating one-to-one reconciliation correlation rule includes the first rule：Two calculation business vouchers are in the state of " non-reconciliation association ", adhere to separately
In two internal units, the transaction record with other side is recite respectively, the business amount of money of the two transaction records is equal, direction phase
Instead.
7. it is according to claim 6 to realize the device that insider transaction business carries out generation payment voucher, it is characterised in that institute
Stating one-to-one reconciliation correlation rule also includes Second Rule：Contain respectively and other side in two transaction records of calculation business voucher
Corresponding reconciliation keyword.
8. realizing according to claim 6 or 7 insider transaction business carries out the device of generation payment voucher, its feature exists
In the pair of reconciliation correlation rule also includes three sigma rule：Meet aforementioned rule and belong to two internal units
In two groups of calculation business vouchers, the accounting between two groups of calculation business vouchers is matched by the generation sequencing of calculation business voucher
Business voucher, the selected calculation business voucher for adhering to two internal units separately mutually recite with other side or point to other side it is non-
The transaction record of unit object.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310717222.0A CN103761599B (en) | 2013-12-23 | 2013-12-23 | Realize that insider transaction business carries out the method and device of generation payment voucher |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310717222.0A CN103761599B (en) | 2013-12-23 | 2013-12-23 | Realize that insider transaction business carries out the method and device of generation payment voucher |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103761599A CN103761599A (en) | 2014-04-30 |
| CN103761599B true CN103761599B (en) | 2017-06-16 |
Family
ID=50528833
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310717222.0A Active CN103761599B (en) | 2013-12-23 | 2013-12-23 | Realize that insider transaction business carries out the method and device of generation payment voucher |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103761599B (en) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105678520A (en) * | 2016-01-07 | 2016-06-15 | 北京中电普华信息技术有限公司 | Accounting offset processing method and apparatus |
| CN106204252A (en) * | 2016-06-27 | 2016-12-07 | 远光软件股份有限公司 | Internal credit and debt remaining sum identification, the method and system gathering and checking |
| CN108256927A (en) * | 2016-12-28 | 2018-07-06 | 航天信息股份有限公司 | Extract the method and device of sales invoice information |
| CN106681739B (en) * | 2017-01-11 | 2020-06-19 | 杭州云象网络技术有限公司 | Automatic intelligent contract generation method |
| CN108960223B (en) * | 2018-05-18 | 2020-10-30 | 北京大账房网络科技股份有限公司 | Method for automatically generating voucher based on intelligent bill identification |
| CN110969493A (en) * | 2018-09-28 | 2020-04-07 | 北京嘀嘀无限科技发展有限公司 | Bill amount determining method and device, electronic equipment and storage medium |
| CN111754320B (en) * | 2020-05-15 | 2023-09-19 | 远光软件股份有限公司 | Method, device and medium for canceling internal transaction certificates based on service management dimension |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102567345A (en) * | 2010-12-17 | 2012-07-11 | 金蝶软件（中国）有限公司 | Method and device for generating bookkeeping voucher |
| CN103440557A (en) * | 2013-08-19 | 2013-12-11 | 远光软件股份有限公司 | Generation method and system for group consolidated accounts and consolidated statements |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4233537B2 (en) * | 2005-04-01 | 2009-03-04 | 弥生株式会社 | Accounting processing apparatus and program |
-
2013
- 2013-12-23 CN CN201310717222.0A patent/CN103761599B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102567345A (en) * | 2010-12-17 | 2012-07-11 | 金蝶软件（中国）有限公司 | Method and device for generating bookkeeping voucher |
| CN103440557A (en) * | 2013-08-19 | 2013-12-11 | 远光软件股份有限公司 | Generation method and system for group consolidated accounts and consolidated statements |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103761599A (en) | 2014-04-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103761599B (en) | Realize that insider transaction business carries out the method and device of generation payment voucher | |
| CN103440557B (en) | A kind of group merges account and the generation method and system of consolidated accounts | |
| CN106022902A (en) | Accounting method and device | |
| CN105761139A (en) | Account checking system and method | |
| CN104867055A (en) | Financial network doubtable money tracking and identifying method | |
| CN107358524B (en) | Method for leveling funds among multiple account management lines in same currency | |
| CN106408410A (en) | Automatic account checking method and device | |
| CN105243117B (en) | A kind of data processing system and method | |
| CN107862593A (en) | A kind of data settle accounts calculation method, electronic equipment and storage medium | |
| CN104574030A (en) | Voucher generation method for ERP accounting platform | |
| CN103093337A (en) | Data processing system capable of combining and separating payment records | |
| CN107798515A (en) | A kind of method that database automatically generates accounting voucher | |
| CN103559275B (en) | Insider transaction business identifies and counteracting method and system | |
| CA2671627A1 (en) | Intelligent collections models | |
| CN108090759A (en) | A kind of channel of disbursement Intelligent routing algorithm | |
| CN103761573B (en) | Realize that insider transaction business carries out the method and device of reconciliation association | |
| CN109740792A (en) | Data predication method, system, terminal and computer storage medium | |
| CN106355784A (en) | Clearing and reconciliation method and system used for ATM equipment | |
| JP2016181254A (en) | Automatic journalizing processing apparatus, automatic journalizing processing method, and automatic journalizing processing program | |
| DE112021006578T5 (en) | Provenance and tokenization platform for ancient grains | |
| CN104657808A (en) | System and method capable of realizing real-time inquiry and management of fund data of enterprise | |
| CN106485579A (en) | A kind of tax declaration method | |
| CN102521713B (en) | Data processing equipment and data processing method | |
| GB2593991A (en) | Purchase management system and method | |
| CN113781192B (en) | Automatic method for financial management of automobile-distribution linkage sales funds |
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 |