CN108182630A - Counteracting method and device in a kind of group financial report - Google Patents
Counteracting method and device in a kind of group financial report Download PDFInfo
- Publication number
- CN108182630A CN108182630A CN201810107825.1A CN201810107825A CN108182630A CN 108182630 A CN108182630 A CN 108182630A CN 201810107825 A CN201810107825 A CN 201810107825A CN 108182630 A CN108182630 A CN 108182630A
- Authority
- CN
- China
- Prior art keywords
- business datum
- target
- business
- consolidation scope
- financial system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Strategic Management (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Databases & Information Systems (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The embodiment of the invention discloses counteracting method and device, the computer installation and readable storage medium storing program for executing in a kind of group financial report, for reducing the difficulty of inquiry financial statement, and can flexibly be offseted by different dimensions difference bore.Present invention method includes:Financial system receives selection instruction of the user to several subsidiaries in group;Financial system receives the report query instruction for target consolidation scope, and target consolidation scope includes several subsidiaries;Financial system chooses corresponding first business datum of subsidiary in target consolidation scope from database;Financial system chooses the second business datum that business object belongs to target consolidation scope from the first business datum;Financial system is according to the generation of the second business datum for the financial statement of target consolidation scope.
Description
Technical field
The present invention relates to financial management information process fields, and in particular to a kind of counteracting method in group financial report and
Device, computer installation and readable storage medium storing program for executing.
Background technology
Indivedual financial statements are to be directed to the financial situation of some subsidiary and the financial statement of management performance in enterprise group,
And consolidated financial statement be used to reflect the whole financial situation of the set of part or all of subsidiary composition in group and operation into
Fruit.The compiling foundation of consolidated financial statement is the indivedual financial statements for the subsidiary for forming group, is to being included in consolidation scope
Subsidiary individual statements data added up on the basis of, with reference to other related datas, pass through on worksheet is merged
The influence that business group internal is merchandised is offseted what is formed later by establishment offset entry.
The existing preparation method of consolidated financial statement generally follows merging work sheet method, is worked out in worksheet is merged
Adjust journal entry and offset entry, by influence artificial judgment of the insider transaction to consolidated financial statement relevant item whether be included in
Pin, and carry out offset processing.In establishment offset entry, progress offset processing are the key that consolidated financial statement establishments and are main
Hold, the factor its object is to be repeated in the totalling amount of money by indivedual financial statement projects is offseted.Setting is needed to offset
Record separately template:The payment attribute for offseting report item is set as " contact class ", selects template type as " individual statements template ",
Table page type is " contact payment table ";It also needs to set internal offset item figure selection formula.
The generation method of existing consolidated financial statement or payment report has the disadvantage that:
1) difficulty is high, error-prone, and the figure selection formula of different software is not quite similar again, without professional training it is difficult to arran into
Work(;
2) conventional software difference consolidation scope is not allow for intersecting, this causes cannot be flexibly by different dimensions difference bore
It is offseted.
Invention content
The present invention provides counteracting method and device, computer installation and readable storage medium in a kind of group financial report
Matter, for solving the problems, such as that the generation method difficulty of existing consolidated financial statement or payment report is high, bore selection is inflexible.
The one side of the embodiment of the present invention provides the counteracting method in a kind of group financial report, including:
Financial system receives selection instruction of the user to several subsidiaries in group;
The financial system receives the report query instruction for target consolidation scope, and the target consolidation scope includes institute
State several subsidiaries;
The financial system chooses the corresponding first business number of subsidiary in the target consolidation scope from database
According to;
The financial system chooses that business object belongs to the target consolidation scope from first business datum
Two business datums;
The financial system is according to second business datum generation for the financial statement of the target consolidation scope.
Optionally, the financial system, which chooses business object from first business datum and belongs to the target, merges model
After the second business datum enclosed, the financial system is according to second business datum generation for the target consolidation scope
Financial statement before, the method further includes:
Second business datum described in the determined property of project of the financial system according to belonging to second business datum
Whether participation is offseted;
If participating in payment, the financial system is performed to be merged according to second business datum generation for the target
The step of financial statement of range.
Optionally, the report query instruction includes target currency and the target table on exchange rates that user specifies;
The financial system chooses the corresponding first business number of subsidiary in the target consolidation scope from database
According to later, the method further includes:
First business datum is converted to target currency by the financial system according to the target table on exchange rates.
Optionally, the financial system is directed to the finance of the target consolidation scope according to second business datum generation
Report includes:
The financial system summarizes second business datum to obtain the payment number in the target consolidation scope
According to;
The financial system is according to the payment data creating in the target consolidation scope in target consolidation scope
Offset report;
Alternatively,
The financial system is summarized to obtain to first business datum summarizes data;
The financial system summarizes second business datum to obtain the payment number in the target consolidation scope
According to;
The financial system summarizes mesh described in payment data creating in data and the target consolidation scope according to
Mark the consolidated financial statement in the group outside consolidation scope.
Optionally, the financial system chooses the subsidiary corresponding first in the target consolidation scope from database
After business datum, the method further includes:
It is described outside the target consolidation scope that the financial system chooses business object from first business datum
Third business datum in group;
The financial system is directed to the financial statement of the target consolidation scope also according to second business datum generation
Including:
The financial system generates supporting in the group outside the target consolidation scope according to the third business datum
Sell report or consolidated financial statement.
Second aspect of the embodiment of the present invention provides the payment device in a kind of group financial report, including:
First receiving module, for receiving selection instruction of the user to several subsidiaries in group;
Second receiving module, the report query for receiving for target consolidation scope instruct, the target consolidation scope
Including several described subsidiaries;
First chooses module, for choosing corresponding first industry of subsidiary in the target consolidation scope from database
Business data;
Second chooses module, belongs to the target consolidation scope for choosing business object from first business datum
The second business datum;
Generation module, for the financial statement according to second business datum generation for the target consolidation scope.
Optionally, business object is chosen from first business datum in the described second selection module and belongs to the target
After second business datum of consolidation scope, in the generation module according to second business datum generation for the target
Before the financial statement of consolidation scope, described device further includes:
Judgment module, for the second business datum described in the determined property of the project according to belonging to second business datum
Whether participation is offseted;
Trigger module, for when the judgment module judges that second business datum participates in payment, triggering the life
The step of financial statement of the target consolidation scope is directed to according to second business datum generation into module.
Optionally, the report query instruction includes target currency and the target table on exchange rates that user specifies;
The subsidiary corresponding first in the target consolidation scope is chosen from database in the described first selection module
After business datum, described device further includes:
Modular converter, for first business datum to be converted to target currency according to the target table on exchange rates.
Optionally, the generation module is specifically used for:
Second business datum is summarized to obtain the payment data in the target consolidation scope;
According to the payment report described in the payment data creating in the target consolidation scope in target consolidation scope;
Alternatively,
First business datum is summarized to obtain and summarizes data;
Second business datum is summarized to obtain the payment data in the target consolidation scope;
According to described in the payment data creating summarized in data and the target consolidation scope outside target consolidation scope
Consolidated financial statement in the group.
Optionally, the subsidiary in the target consolidation scope is chosen from database in the described first selection module to correspond to
The first business datum after, described device further includes:
Third chooses module, for choosing business object from first business datum as outside the target consolidation scope
Third business datum in the group;
The generation module also particularly useful for:
Payment report or the merging outside the target consolidation scope in the group are generated according to the third business datum
Financial statement.
The third aspect of the embodiment of the present invention provides a kind of computer installation, and the computer installation includes processor,
The processor realizes any one of such as first aspect or first aspect when being used to perform the computer program stored in memory
The step of kind possible realization method the method.
The fourth aspect of the embodiment of the present invention provides a kind of computer readable storage medium, is stored thereon with computer journey
Sequence realizes any one possible realization side such as first aspect or first aspect when the computer program is executed by processor
The step of formula the method.
As can be seen from the above technical solutions, the embodiment of the present invention has the following advantages:
The present invention provides the counteracting method in a kind of group financial report, and user needs to inquire for some merging in group
During the financial statement of range, certain subsidiaries in group can be selected in the interface of financial software, and assign to financial system
Report query instructs, wherein, financial system refers to server or server cluster equipped with financial software, and financial system can at this time
It is instructed with the report query received for target consolidation scope.Later, financial system can be from the business datum for being stored with group
Database in choose corresponding first business datum of subsidiary in target consolidation scope, and chosen from the first business datum
Business object belongs to the second business datum of target consolidation scope, according to the generation of the second business datum for target consolidation scope
Financial statement.Compared to the prior art, figure selection formula is configured without user in scheme provided by the invention in query process, may be used also
To specify consolidation scope, difficulty is low, not error-prone, and can flexibly be offseted by different dimensions difference bore.
Description of the drawings
Fig. 1 is a schematic diagram of consolidation scope of the present invention;
Fig. 2 is counteracting method one embodiment schematic diagram in group financial report of the present invention;
Fig. 3 is counteracting method another embodiment schematic diagram in group financial report of the present invention;
Fig. 4 is payment device one embodiment schematic diagram in group's consolidated accounts of the present invention;
Fig. 5 is payment device another embodiment schematic diagram in group's consolidated accounts of the present invention;
Fig. 6 is computer installation one embodiment schematic diagram of the present invention.
Specific embodiment
An embodiment of the present invention provides the counteracting method in a kind of group financial report and device, computer installations and readable
Storage medium for reducing the difficulty of inquiry financial statement, and can be offseted flexibly by different dimensions difference bore.
In order to which those skilled in the art is made to more fully understand the present invention program, below in conjunction in the embodiment of the present invention
The technical solution in the embodiment of the present invention is clearly and completely described in attached drawing, it is clear that described embodiment is only
The embodiment of a part of the invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill people
Member's all other embodiments obtained without making creative work should all belong to the model that the present invention protects
It encloses.
Term " first ", " second ", " third " in description and claims of this specification and above-mentioned attached drawing, "
The (if present)s such as four " are the objects for distinguishing similar, and specific sequence or precedence are described without being used for.It should manage
The data that solution uses in this way can be interchanged in the appropriate case, so that the embodiments described herein can be in addition to illustrating herein
Or the sequence other than the content of description is implemented.In addition, term " comprising " and " having " and their any deformation, it is intended that
Cover it is non-exclusive include, for example, containing the process of series of steps or unit, method, system, product or equipment need not limit
In those steps or unit for clearly listing, but may include not listing clearly or for these processes, method, production
The intrinsic other steps of product or equipment or unit.
In embodiments of the present invention, consolidation scope refers to, selectes subsidiaries certain in company according to the financial core of oneself
The needs (not necessarily pressing tissue division, can arbitrarily divide) of calculation, divide into some range, this range is consolidation scope, no
With consolidation scope in can include identical company.An as shown in Figure 1, schematic diagram for two consolidation scopes in group.
Payment in contract law refers to, when both sides mutually pay debt, the liquidation of debt is respectively served as with its credits, and makes its debt and other side
Debt is mutually eliminated in single-candidate.For a popular example, by taking consolidation scope 1 shown in FIG. 1 as an example, it is assumed that company A is
Milk producer, company B are the retailer of milk, and company B pays A100 ten thousand from 10 tons of milk of company's A bulk purchases.At this moment
It stands to from the point of view of consolidation scope 1, it is payment that at this moment company B, which pays the 100 Wan He companies A of company A to the milk of company B,
, consolidation scope 1 was both paid without income or not.
The embodiment of the present invention wishes to fetch by business, obtains the business object of business datum, automatic identification is with merging model
The relationship enclosed realizes that need not work out offset entry offsets automatically further according to the attribute of project.The embodiment of the present invention is mainly used for
Tool consolidated accounts or independent provide use when offseting report.
Referring to Fig. 2, counteracting method one embodiment in the embodiment of the present invention in group financial report includes:
201st, financial system receives selection instruction of the user to several subsidiaries in group;
In each embodiment of the present invention, financial system refers to server or server cluster equipped with financial software,
In, financial software is relatively common business management software, mainly based on business finance accounts, business capital account, enterprise
The management of balance of payment position etc..When user's needs inquiry is directed to the financial statement of some consolidation scope in group, for convenience
Description, is referred to as target consolidation scope by the consolidation scope, several height in group can be selected in the interface of financial software
Company, at this point, financial system can receive selection instruction of the user to several subsidiaries in group.Need what is illustrated
It is that several subsidiaries at least two of user's selection can also be two or more, herein not to the subsidiary of user's selection
Number be defined.
202nd, financial system receives the report query instruction for target consolidation scope;
After user selects several subsidiaries in the interface of financial software, query option can be selected, at this point, financial
System can receive the report query instruction for target consolidation scope, target consolidation scope subsidiary's group selected by user
Into.
In actual use, step 201 and step 202 can be used as a step, i.e. financial system only receives a finger
It enables, the set which forms several subsidiaries in group user to be indicated to wish is wished as target consolidation scope
Hope the financial statement for consulting target consolidation scope.
203rd, financial system chooses corresponding first business datum of subsidiary in target consolidation scope from database;
The business datum that can be stored in the database of financial system in group, business datum can be to be taken by voucher
What number was got, or business paper records.Before voucher being generally arisen from due to business paper record, it is therefore preferable that
, business datum can be that business paper records.The report query that financial system receives for target consolidation scope instructs it
Afterwards, the corresponding business datum of subsidiary in target consolidation scope can be chosen from database, for the convenience of description, by target
The corresponding all business datums of all subsidiaries are referred to as the first business datum in consolidation scope.It is understood that the first data
The number of business datum is not limited, and refers to a kind of data.
In order to make it easy to understand, assuming that group includes subsidiary A, subsidiary B, subsidiary C, it is public that target consolidation scope includes son
A, subsidiary B are taken charge of, the corresponding business datums of subsidiary A include data A1, data A2, and the business datum that subsidiary B includes includes
Data B1, data B2, the business datum that subsidiary C includes include data C1, data C2, then the first business datum includes data
A1, data A2, data B1 and data B2.
204th, financial system chooses the second business number that business object belongs to target consolidation scope from the first business datum
According to;
Financial system is chosen to after the first business datum, it may be determined that the corresponding business object of the first business datum, industry
Business object refers to other side's object of business generation.Financial system can choose business object from the first business datum and belong to target conjunction
And the second business datum of range.It is understood that the second data do not limit the number of business datum, and refer to a kind of number
According to.
In order to make it easy to understand, the business object for assuming data A1 is subsidiary B, the business object of data A2 is subsidiary C,
The business object of data B1 is subsidiary A, and the business object of data B2 is the company outside group, then, the second business data packet
Include data A1 and data B1.
205th, financial system is directed to the financial statement of target consolidation scope according to the generation of the second business datum.
After financial system chooses the second business datum, it can be calculated in target consolidation scope according to the second business datum
Data are offseted, and according to the generation of payment data for the financial statement of target consolidation scope.
In the embodiment of the present invention, financial system can receive the report query instruction for target consolidation scope, later, wealth
Business system can choose the subsidiary corresponding in target consolidation scope from the database of business datum for being stored with group
One business datum, and the second business datum that business object belongs to target consolidation scope is chosen from the first business datum, according to
The generation of second business datum is for the financial statement of target consolidation scope.Compared to the prior art, scheme provided by the invention without
It needs user that figure selection formula is configured in query process, consolidation scope can also be specified, difficulty is low, not error-prone, and being capable of spirit
Living is offseted by different dimensions difference bore.
Referring to Fig. 3, second embodiment of counteracting method in the embodiment of the present invention in group financial report includes:
301st, financial system receives selection instruction of the user to several subsidiaries in group;
When user's needs inquiry is directed to the financial statement of some consolidation scope in group, for the convenience of description, this is merged
Range is referred to as target consolidation scope, several subsidiaries in group can be selected in the interface of financial software, at this point, financial
System can receive selection instruction of the user to several subsidiaries in group.If it should be noted that user selected
Gan Ge subsidiaries at least two can also be two or more, the number of the subsidiary of user's selection are not defined herein.
302nd, financial system receives the report query instruction for target consolidation scope;
After user selects several subsidiaries in the interface of financial software, query option can be selected, at this point, financial
System can receive the report query instruction for target consolidation scope, target consolidation scope subsidiary's group selected by user
Into.
Preferably, user can specify the currency of data in report, can also specify the table on exchange rates of use, at this point, financial
Target currency and the target table on exchange rates that user specifies are further included in the report query instruction that system receives.
303rd, financial system chooses corresponding first business datum of subsidiary in target consolidation scope from database;
The business datum that can be stored in the database of financial system in group, business datum can be to be taken by voucher
What number was got, or business paper records.Before voucher being generally arisen from due to business paper record, it is therefore preferable that
, business datum can be that business paper records.The report query that financial system receives for target consolidation scope instructs it
Afterwards, the corresponding business datum of subsidiary in target consolidation scope can be chosen from database, for the convenience of description, by target
The corresponding all business datums of all subsidiaries are referred to as the first business datum in consolidation scope.It is understood that the first data
The number of business datum is not limited, and refers to a kind of data.
In order to make it easy to understand, assuming that group includes subsidiary A, subsidiary B, subsidiary C, it is public that target consolidation scope includes son
A, subsidiary B are taken charge of, the corresponding business datums of subsidiary A include data A1, data A2, and the business datum that subsidiary B includes includes
Data B1, data B2, the business datum that subsidiary C includes include data C1, data C2, then the first business datum includes data
A1, data A2, data B1 and data B2.
304th, the first business datum is converted to target currency by financial system according to target table on exchange rates;
If further including target currency and the target table on exchange rates that user specifies in the report query instruction that financial system receives,
So financial system is chosen to after the first business datum, the first business datum can be converted to target according to target table on exchange rates
The business datum of currency.If do not include the target currency and target that user specifies in the report query instruction that financial system receives
Table on exchange rates can not then perform step 304.
305th, financial system chooses the second business number that business object belongs to target consolidation scope from the first business datum
According to;
Financial system is chosen to after the first business datum, it may be determined that the corresponding business object of the first business datum, industry
Business object refers to other side's object of business generation.Financial system can choose business object from the first business datum and belong to target conjunction
And the second business datum of range.It is understood that the second data do not limit the number of business datum, and refer to a kind of number
According to.
In order to make it easy to understand, the business object for assuming data A1 is subsidiary B, the business object of data A2 is subsidiary C,
The business object of data B1 is subsidiary A, and the business object of data B2 is the company outside group, then, the second business data packet
Include data A1 and data B1.
306th, whether the second business datum of determined property of project of the financial system according to belonging to the second business datum participates in
Payment;
The maintenance personnel for inquiring user or financial system can mark the project mark attribute of typing in financial system
Attribute for show the project whether participate in report calculating, if participate in report calculate, if participate in payment, subsequently to go out
It can be by attribute automatic identification processing mode during report.Financial system is chosen to after the second business datum, can be according to each the
Whether the determined property of the project belonging to two business datums second business datum participates in offseting.If participating in payment, step is performed
Rapid 307, if being not involved in offseting, perform step 308.
307th, financial system is directed to the financial statement of target consolidation scope according to the generation of the second business datum.
After financial system chooses the second business datum, if the second business datum can participate in offseting, then financial system
The payment data in target consolidation scope can be calculated according to the second business datum, and are closed according to payment data generation for target
And the financial statement of range.
The financial statement of generation can be the merging wealth in payment report and target consolidation scope in target consolidation scope
At least one of business report, separately below to generating payment report and conjunction in target consolidation scope according to the second business datum
And the method for financial statement is described:
First, the reimbursement report in target consolidation scope is generated according to the second business datum:
Step A1, financial system is summarized to obtain respectively the payment number in target consolidation scope to the second business datum
According to;
Optionally, financial system can summarize the second business datum according to item types.
Step A2, financial system is according to the payment report in payment data creating target consolidation scope.
2nd, the consolidated financial statement in target consolidation scope is generated according to the second business datum:
Step B1, financial system is summarized to obtain to the first business datum summarizes data;
Optionally, financial system can summarize the first business datum respectively according to item types.
Preferably, financial system can be to participate in the business datum that report calculates to converge to attribute in the first business datum
Always.
Step B2, financial system is summarized to obtain the payment data in target consolidation scope to the second business datum;
Optionally, financial system can summarize the second business datum respectively according to item types.
Step B3, financial system is according to the payment data creating target consolidation scope summarized in data and target consolidation scope
Interior consolidated financial statement.
308th, other operations are performed.
If the second business datum can participate in offseting, other operations other than step 307 can be performed.
In the third embodiment of counteracting method in group financial report of the present invention, the finance report of financial system generation
Table can also include the financial statement in target consolidation scope outgroup, based on second embodiment of the invention, step 303 it
Afterwards, following steps can also be performed:
Step 3031, financial system choose business object as in target consolidation scope outgroup from the first business datum
Third business datum;
Assuming that group includes subsidiary A, subsidiary B, subsidiary C, target consolidation scope includes subsidiary A, subsidiary B,
The corresponding business datums of subsidiary A include data A1, data A2, and the business datum that subsidiary B includes includes data B1, data
B2, the business datum that subsidiary C includes include data C1, data C2, then the first business datum include data A1, data A2,
Data B1 and data B2.Assuming that the business object of data A1 is subsidiary B, the business object of data A2 is subsidiary C, data B1
Business object for subsidiary A, the business object of data B2 is the company outside group, then, third business datum includes data
A2。
Based on second embodiment of the invention, step 307 can also include:
Step 3071, financial system according to third business datum generate target consolidation scope outgroup in payment report or
Consolidated financial statement.
Wherein, financial system generates the reimbursement report in target consolidation scope outgroup according to third business datum and can have
Body includes:
Financial system summarizes third business datum to obtain the payment data in target consolidation scope outgroup.It is optional
, financial system can summarize third business datum respectively according to item types.Preferably, financial system is to third industry
The attribute of project is that the business datum for participating in offseting is summarized in business data, obtains the payment in target consolidation scope outgroup
Data.Later according to the reimbursement report in the payment data creating target consolidation scope outgroup in target consolidation scope outgroup
Table.
Financial system generates the consolidated financial statement in target consolidation scope outgroup according to third business datum and specifically wraps
It includes:
Financial system summarizes third business datum to obtain the payment data in target consolidation scope outgroup.It is optional
, financial system can summarize third business datum respectively according to item types.Last basis summarizes data, target is closed
And in the payment data in range and the payment data creating target consolidation scope outgroup in target consolidation scope outgroup
Consolidated financial statement.Preferably, summarize data based on business datum attribute be participate in report calculates, payment data base
In business datum attribute be participate in reimbursement.
Below with practical application scene, third embodiment method in the embodiment of the present invention is further described,
It is as follows:
Assuming that group includes subsidiary A, subsidiary B, subsidiary C and subsidiary D, the business datum of group includes X
The attribute of the business datum of purpose business datum and Y projects, X projects and Y projects is to participate in report to calculate, and participate in supporting
Pin.Subsidiary A X projects the corresponding business amount of money of business datum for 100,000 yuan, wherein, 1) business object is subsidiary B's
The corresponding business amount of money of business datum is 10,000 yuan, and the corresponding business amount of money of business datum that business object is subsidiary C is 20,000
Member, the corresponding business amount of money of business datum that business object is subsidiary D is 30,000, industry of the business object for the company outside group
The corresponding business amount of money of data of being engaged in is 40,000;Subsidiary A is 50,000 yuan in the corresponding business amount of money of business datum of Y projects, wherein,
The corresponding business amount of money of business datum that business object is subsidiary B is 10,000 yuan, and business object is the business datum of subsidiary D
The corresponding business amount of money is 20,000, and business object is that the corresponding business amount of money of business datum of the company outside group is 20,000.2) it is sub
Company B is 200,000 yuan in the corresponding business amount of money of business datum of X projects, wherein, business object is the business datum of subsidiary A
The corresponding business amount of money is 100,000 yuan, and the corresponding business amount of money of business datum that business object is subsidiary D is 40,000 yuan, business
Object is that the corresponding business amount of money of business datum of the company outside group is 60,000;Subsidiary B is corresponded in the business datum of Y projects
The business amount of money for 60,000 yuan, business object is the company outside group.3) subsidiary C is in the corresponding industry of business datum of X projects
The business amount of money is 300,000 yuan, is 70,000 yuan in the corresponding business amount of money of the business datum of Y projects, business object is the public affairs outside group
Department.
Financial system receives selection instruction of the user to subsidiary A~C, can subsidiary A~C be formed target and merged
Range, when receiving the report query instruction for target consolidation scope, financial system can choose target from database
Corresponding first business datum of subsidiary in consolidation scope, i.e. subsidiary A~C is in all business numbers of X projects and Y projects
According to.If target currency and target table on exchange rates have been formulated in the report query instruction of user, financial system can be according to the target exchange rate
First business datum is converted to target currency by table.Later, financial system can choose business object from the first business datum
Belong to the second business datum of target consolidation scope, including:Subsidiary A is in the business datum of X projects, business object is public for son
Take charge of B and subsidiary C business datum (the business amount of money is respectively 10,000 yuan and 20,000 yuan) and subsidiary A Y projects business datum
In, business datum that business object is subsidiary B (the business amount of money is 10,000 yuan);Subsidiary B is in the business datum of X projects, industry
The business datum that business object is subsidiary A (the business amount of money is 100,000 yuan).Financial system can also be selected from the first business datum
Business object is taken as the third business datum in target consolidation scope outgroup, including:Subsidiary A is in the business datum of X projects
In, business datum that business object is D (the business amount of money is 30,000 yuan) and subsidiary A be in the business datum of Y projects, business pair
As the business datum for D (the business amount of money is 40,000 yuan).Financial system is selected from the second business datum and third business datum later
The business datum for participating in payment is selected, is summarized to obtain respectively according to item types such as the following table 1, while embody target consolidation scope
Payment report in interior payment report and target consolidation scope outgroup.
Table 1
Financial system can be summarized to obtain to the first business datum summarizes data, and optionally, financial system can be by
The first business datum is summarized respectively according to item types.Later, financial system can according to summarize data, target merge model
The payment data creating consolidated financial statement in payment data and target consolidation scope outgroup in enclosing is obtained such as the following table 2, together
The consolidated financial statement in consolidated financial statement and target consolidation scope outgroup in Shi Tixian target consolidation scopes.
Table 2
The counteracting method in the group financial report in the embodiment of the present invention is described above, below to the present invention
The payment device of group's consolidated accounts in embodiment is described.
Referring to Fig. 4, one embodiment of the payment device of group's consolidated accounts includes in the embodiment of the present invention:
First receiving module 401, for receiving selection instruction of the user to several subsidiaries in group;
Second receiving module 402, the report query for receiving for target consolidation scope instruct, target consolidation scope packet
Include several subsidiaries;
First chooses module 403, for choosing corresponding first industry of subsidiary in target consolidation scope from database
Business data;
Second chooses module 404, for choose that business object belongs to target consolidation scope from the first business datum the
Two business datums;
Generation module 405, for the financial statement according to the generation of the second business datum for target consolidation scope.
Referring to Fig. 5, second embodiment of the payment device of group's consolidated accounts includes in the embodiment of the present invention:
First receiving module 501, for receiving selection instruction of the user to several subsidiaries in group;
Second receiving module 502, the report query for receiving for target consolidation scope instruct, target consolidation scope packet
Include several subsidiaries;
First chooses module 503, for choosing corresponding first industry of subsidiary in target consolidation scope from database
Business data;
Modular converter 504, for the first business datum to be converted to target currency according to target table on exchange rates.
Second chooses module 505, for choose that business object belongs to target consolidation scope from the first business datum the
Two business datums;
Judgment module 506, for the project according to belonging to the second business datum the second business datum of determined property whether
Participate in payment;
Generation module 507, for the financial statement according to the generation of the second business datum for target consolidation scope.
Generation module 507 is specifically used for:
Summarized to obtain the payment data in target consolidation scope to the second business datum;
According to the payment report in the payment data creating target consolidation scope in target consolidation scope;
Alternatively,
First business datum is summarized to obtain and summarizes data;
Summarized to obtain the payment data in target consolidation scope to the second business datum;
According to the merging in the payment data creating target consolidation scope outgroup summarized in data and target consolidation scope
Financial statement.
In the third embodiment of apparatus of the present invention, based on second embodiment, device further includes:
Third chooses module, for choosing business object from the first business datum as in target consolidation scope outgroup
Third business datum;
Generation module 507 also particularly useful for:
Payment report or the consolidated financial statement in target consolidation scope outgroup are generated according to third business datum.
Above from the angle of modular functionality entity to the payment device of group's consolidated accounts in the embodiment of the present invention into
It has gone description, the computer installation in the embodiment of the present invention has been described from the angle of hardware handles below:
The embodiment of the present invention additionally provides a kind of computer installation 6, as shown in fig. 6, for convenience of description, illustrate only with
The relevant part of the embodiment of the present invention, particular technique details do not disclose, please refer to present invention method part.The calculating
Machine device 6 refers generally to the stronger computer equipment of the processing capacities such as server.
With reference to figure 6, computer installation 6 includes:Power supply 610, memory 620, processor 630, wired or wireless network connect
Mouthfuls 640 and storage in memory and the computer program that can run on a processor.When processor performs computer program
Realize the step in the counteracting method embodiment in above-mentioned each group financial report, such as step 201 shown in FIG. 1 is to 205.
Alternatively, processor realizes each module or the function of unit in above-mentioned each device embodiment when performing computer program.
Illustratively, computer program can be divided into one or more module/units, one or more of moulds
Block/unit is stored in the memory, and is performed by the processor, to complete the present invention.One or more of moulds
Block/unit can be the series of computation machine program instruction section that can complete specific function, the instruction segment by describe it is described based on
Implementation procedure of the calculation machine program in the computer installation.
It will be understood by those skilled in the art that structure shown in Fig. 6 does not form the restriction to computer installation 6, it can
To include either combining certain components or different components arrangement, such as the calculating than illustrating more or fewer components
Machine device can also include input-output equipment, bus etc..
Alleged processor can be central processing unit (Central Processing Unit, CPU), can also be it
His general processor, digital signal processor (Digital Signal Processor, DSP), application-specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable GateArray, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor can also be any conventional processor
Deng the processor is the control centre of the computer installation, utilizes various interfaces and the entire computer installation of connection
Various pieces.
The memory can be used for storing the computer program and/or module, and the processor is by running or performing
The computer program and/or module that are stored in the memory and the data being stored in memory are called, described in realization
The various functions of computer installation.The memory can mainly include storing program area and storage data field, wherein, store program
It area can storage program area, the application program (such as sound-playing function, image player function etc.) needed at least one function
Deng;Storage data field can be stored uses created data (such as audio data, phone directory etc.) etc. according to mobile phone.In addition,
Memory can include high-speed random access memory, can also include nonvolatile memory, such as hard disk, memory, grafting
Formula hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card, flash card
(Flash Card), at least one disk memory, flush memory device or other volatile solid-state parts.
If module/unit that the computer installation integrates is realized and is independent in the form of SFU software functional unit
Product is sold or in use, can be stored in a computer read/write memory medium.Based on such understanding, the present invention is real
All or part of flow in existing above-described embodiment method, can also instruct relevant hardware come complete by computer program
Into the computer program can be stored in a computer readable storage medium, which is being executed by processor
When, it can be achieved that the step of above-mentioned each embodiment of the method.Wherein, the computer program includes computer program code, described
Computer program code can be source code form, object identification code form, executable file or certain intermediate forms etc..The meter
Calculation machine readable medium can include:Can carry the computer program code any entity or device, recording medium, USB flash disk,
Mobile hard disk, magnetic disc, CD, computer storage, read-only memory (ROM, Read-Only Memory), random access memory
Device (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..Need what is illustrated
It is that the content that the computer-readable medium includes can be fitted according to legislation in jurisdiction and the requirement of patent practice
When increase and decrease, such as in certain jurisdictions, according to legislation and patent practice, computer-readable medium, which does not include electric carrier wave, to be believed
Number and telecommunication signal.
It is apparent to those skilled in the art that for convenience and simplicity of description, the system of foregoing description,
The specific work process of device and unit can refer to the corresponding process in preceding method embodiment, and details are not described herein.
In several embodiments, it should be understood that disclosed system, device and method can pass through others
Mode is realized.For example, the apparatus embodiments described above are merely exemplary, for example, the division of unit, only a kind of
Division of logic function, can there is an other dividing mode in actual implementation, such as multiple units or component can combine or can
To be integrated into another system or some features can be ignored or does not perform.Another point, shown or discussed is mutual
Coupling, direct-coupling or communication connection can be by some interfaces, the INDIRECT COUPLING or communication connection of device or unit,
Can be electrical, machinery or other forms.
The unit illustrated as separating component may or may not be physically separate, be shown as unit
Component may or may not be physical unit, you can be located at a place or can also be distributed to multiple networks
On unit.Some or all of unit therein can be selected according to the actual needs to realize the purpose of this embodiment scheme.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
That each unit is individually physically present, can also two or more units integrate in a unit.Above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
More than, the above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations;Although with reference to aforementioned reality
Example is applied the present invention is described in detail, it will be understood by those of ordinary skill in the art that:It still can be to aforementioned each
Technical solution recorded in embodiment modifies or carries out equivalent replacement to which part technical characteristic;And these are changed
Or it replaces, the spirit and scope for various embodiments of the present invention technical solution that it does not separate the essence of the corresponding technical solution.
Claims (10)
1. a kind of counteracting method in group financial report, which is characterized in that including:
Financial system receives selection instruction of the user to several subsidiaries in group;
The financial system receives the report query instruction for target consolidation scope, if the target consolidation scope is including described
Gan Ge subsidiaries;
The financial system chooses corresponding first business datum of subsidiary in the target consolidation scope from database;
The financial system chooses the second industry that business object belongs to the target consolidation scope from first business datum
Business data;
The financial system is according to second business datum generation for the financial statement of the target consolidation scope.
2. counteracting method according to claim 1, which is characterized in that the financial system is from first business datum
It chooses business object to belong to after the second business datum of the target consolidation scope, the financial system is according to second industry
Before data of being engaged in generation is for the financial statement of the target consolidation scope, the method further includes:
Whether the second business datum described in the determined property of project of the financial system according to belonging to second business datum
Participate in payment;
If participating in payment, the financial system is performed according to second business datum generation for the target consolidation scope
Financial statement the step of.
3. counteracting method according to claim 2, which is characterized in that the report query instruction includes the mesh that user specifies
Mark currency and target table on exchange rates;
The financial system chosen from database corresponding first business datum of subsidiary in the target consolidation scope it
Afterwards, the method further includes:
First business datum is converted to target currency by the financial system according to the target table on exchange rates.
4. counteracting method according to any one of claim 1 to 3, which is characterized in that the financial system is according to
The generation of second business datum includes for the financial statement of the target consolidation scope:
The financial system summarizes second business datum to obtain the payment data in the target consolidation scope;
Payment of the financial system according to the payment data creating in the target consolidation scope in target consolidation scope
Report;
Alternatively,
The financial system is summarized to obtain to first business datum summarizes data;
The financial system summarizes second business datum to obtain the payment data in the target consolidation scope;
The financial system summarizes target described in payment data creating in data and the target consolidation scope according to and closes
And the consolidated financial statement outside range in the group.
5. counteracting method according to claim 4, which is characterized in that the financial system chooses the mesh from database
After marking corresponding first business datum of subsidiary in consolidation scope, the method further includes:
The financial system chooses business object as the group outside the target consolidation scope from first business datum
Interior third business datum;
The financial system is further included according to second business datum generation for the financial statement of the target consolidation scope:
The financial system generates the payment report outside the target consolidation scope in the group according to the third business datum
Table or consolidated financial statement.
6. a kind of payment device in group financial report, which is characterized in that including:
First receiving module, for receiving selection instruction of the user to several subsidiaries in group;
Second receiving module, the report query for receiving for target consolidation scope instruct, and the target consolidation scope includes
Several described subsidiaries;
First chooses module, for choosing the corresponding first business number of subsidiary in the target consolidation scope from database
According to;
Second chooses module, for choose that business object belongs to the target consolidation scope from first business datum the
Two business datums;
Generation module, for the financial statement according to second business datum generation for the target consolidation scope.
7. payment device according to claim 6, which is characterized in that choose module from first business described second
It chooses business object in data to belong to after the second business datum of the target consolidation scope, in the generation module according to institute
Before the generation of the second business datum is stated for the financial statement of the target consolidation scope, described device further includes:
Judgment module, for the second business datum described in the determined property of the project according to belonging to second business datum whether
Participate in payment;
Trigger module, for when the judgment module judges that second business datum participates in payment, triggering the generation mould
The step of root tuber is directed to the financial statement of the target consolidation scope according to second business datum generation.
8. payment device according to claim 7, which is characterized in that the report query instruction includes the mesh that user specifies
Mark currency and target table on exchange rates;
Corresponding first business of subsidiary in the target consolidation scope is chosen from database in the described first selection module
After data, described device further includes:
Modular converter, for first business datum to be converted to target currency according to the target table on exchange rates.
9. a kind of computer installation, which is characterized in that the computer installation includes processor, and the processor is deposited for performing
The step of any one the method in such as claim 1-5 is realized during the computer program stored in reservoir.
10. a kind of computer readable storage medium, is stored thereon with computer program, it is characterised in that:The computer program
The step of any one the method in such as claim 1-5 is realized when being executed by processor.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810107825.1A CN108182630A (en) | 2018-02-02 | 2018-02-02 | Counteracting method and device in a kind of group financial report |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810107825.1A CN108182630A (en) | 2018-02-02 | 2018-02-02 | Counteracting method and device in a kind of group financial report |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108182630A true CN108182630A (en) | 2018-06-19 |
Family
ID=62552013
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810107825.1A Pending CN108182630A (en) | 2018-02-02 | 2018-02-02 | Counteracting method and device in a kind of group financial report |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108182630A (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109614607A (en) * | 2018-10-25 | 2019-04-12 | 平安科技(深圳)有限公司 | Method for processing report data, device, computer equipment and storage medium |
CN111723135A (en) * | 2019-03-19 | 2020-09-29 | 上海汽车集团股份有限公司 | Method and device for processing vehicle configuration feature request |
CN111754320A (en) * | 2020-05-15 | 2020-10-09 | 远光软件股份有限公司 | Internal transaction voucher cancellation method, device and medium based on business management dimension |
CN112434018A (en) * | 2020-10-22 | 2021-03-02 | 金蝶云科技有限公司 | Report generation method and device, computer equipment and storage medium |
CN112541027A (en) * | 2020-11-24 | 2021-03-23 | 国网商旅云技术有限公司 | Data processing method and device |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101876970A (en) * | 2009-12-22 | 2010-11-03 | 金蝶软件(中国)有限公司 | Method for combining reports and device thereof |
CN103426070A (en) * | 2013-08-19 | 2013-12-04 | 远光软件股份有限公司 | Compilation method and device of group combined financial statement |
CN104021449A (en) * | 2014-06-19 | 2014-09-03 | 北京工商大学 | Conglomerate report file merging method and device based on open platform system |
CN106326424A (en) * | 2016-08-24 | 2017-01-11 | 明算科技(北京)股份有限公司 | Report processing method, device and system |
-
2018
- 2018-02-02 CN CN201810107825.1A patent/CN108182630A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101876970A (en) * | 2009-12-22 | 2010-11-03 | 金蝶软件(中国)有限公司 | Method for combining reports and device thereof |
CN103426070A (en) * | 2013-08-19 | 2013-12-04 | 远光软件股份有限公司 | Compilation method and device of group combined financial statement |
CN104021449A (en) * | 2014-06-19 | 2014-09-03 | 北京工商大学 | Conglomerate report file merging method and device based on open platform system |
CN106326424A (en) * | 2016-08-24 | 2017-01-11 | 明算科技(北京)股份有限公司 | Report processing method, device and system |
Cited By (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109614607A (en) * | 2018-10-25 | 2019-04-12 | 平安科技(深圳)有限公司 | Method for processing report data, device, computer equipment and storage medium |
CN109614607B (en) * | 2018-10-25 | 2023-09-22 | 平安科技(深圳)有限公司 | Report data processing method, device, computer equipment and storage medium |
CN111723135A (en) * | 2019-03-19 | 2020-09-29 | 上海汽车集团股份有限公司 | Method and device for processing vehicle configuration feature request |
CN111754320A (en) * | 2020-05-15 | 2020-10-09 | 远光软件股份有限公司 | Internal transaction voucher cancellation method, device and medium based on business management dimension |
CN111754320B (en) * | 2020-05-15 | 2023-09-19 | 远光软件股份有限公司 | Method, device and medium for canceling internal transaction certificates based on service management dimension |
CN112434018A (en) * | 2020-10-22 | 2021-03-02 | 金蝶云科技有限公司 | Report generation method and device, computer equipment and storage medium |
CN112434018B (en) * | 2020-10-22 | 2024-06-04 | 金蝶云科技有限公司 | Report generation method, report generation device, computer equipment and storage medium |
CN112541027A (en) * | 2020-11-24 | 2021-03-23 | 国网商旅云技术有限公司 | Data processing method and device |
CN112541027B (en) * | 2020-11-24 | 2024-03-22 | 国网商旅云技术有限公司 | Data processing method and device |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108182630A (en) | Counteracting method and device in a kind of group financial report | |
CN107317672A (en) | A kind of light weight terminating machine block catenary system | |
CN108830686A (en) | A kind of assets information processing method and server based on block chain | |
CN106651097A (en) | Data collection method, data collection device and data collection server based on crowd sourcing | |
CN107358524B (en) | Method for leveling funds among multiple account management lines in same currency | |
CN108665366A (en) | Determine method, terminal device and the computer readable storage medium of consumer's risk grade | |
EP3319030A1 (en) | Method for creating a transaction signal | |
KR102190870B1 (en) | Method for distributing profit of contents using block chain network and computing device performing the same | |
CN110046828B (en) | Intelligent account division protocol system based on block chain | |
CN109447769A (en) | A kind for the treatment of method and apparatus of financial data | |
CN101576990A (en) | Banking service processing system | |
CN106327196A (en) | Payment threshold acquisition method and device | |
CN108171595B (en) | Bank core accounting engine system supporting peripheral business system accounting service | |
CN105913244A (en) | Multi-user business data processing method and system | |
CN108960902A (en) | A kind of the set exchanging method and device of the available resources quota based on block chain | |
CN108921523A (en) | Creation, method of commerce and the system of equity assets value token based on block chain | |
CN107689009A (en) | Annuity data processing method, device, server and storage medium | |
CN109657075A (en) | A kind of digital resource adduction relationship recording method and system | |
CN110060149A (en) | Risk management and control method and system after a kind of loan | |
CN109615506A (en) | Collection information processing method and system | |
CN111797099B (en) | Data processing method and device based on subjects and auxiliary attributes | |
CN107633336A (en) | A kind of fused data source statistics equipment, system and method | |
CN106097093A (en) | Contract data process method and apparatus | |
CN109118359A (en) | A kind of pre- exchanging method and device of the available resources quota based on block chain | |
CN103761573B (en) | Realize that insider transaction business carries out the method and device of reconciliation association |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180619 |
|
RJ01 | Rejection of invention patent application after publication |