CN106844320A - A kind of financial statement integration method and equipment - Google Patents
A kind of financial statement integration method and equipment Download PDFInfo
- Publication number
- CN106844320A CN106844320A CN201611229979.5A CN201611229979A CN106844320A CN 106844320 A CN106844320 A CN 106844320A CN 201611229979 A CN201611229979 A CN 201611229979A CN 106844320 A CN106844320 A CN 106844320A
- Authority
- CN
- China
- Prior art keywords
- financial statement
- row title
- line number
- row
- specified type
- 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.)
- Granted
Links
Classifications
-
- 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
-
- 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/123—Tax preparation or submission
-
- 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
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Development Economics (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The present embodiments relate to a kind of financial statement integration method and equipment, the method includes：Obtain the financial statement of the specified type of each enterprise；For the financial statement of each specified type, according to default standard line number and the corresponding relation of row title collection, determine the corresponding standard line number of each row title in the financial statement of the specified type, wherein, the row title of same attribute is belonged to a line title centrally stored at least one；The corresponding original line number of each row title in the financial statement of the specified type is changed to the corresponding standard line number of each row title；The financial statement of each specified type that will be changed to after standard line number is saved in same form, the financial statement after being integrated.The present invention can to a certain extent reduce the workload of exploitation complexity and inquiry, and user is also improve to a certain extent carries out the convenience and efficiency of financial data inquiry.
Description
Technical field
The present invention relates to data processing field, more particularly to a kind of financial statement integration method and equipment.
Background technology
In Analysis of Tariff Data application system, it is related to the financial statement of different enterprises, a set of wealth of each enterprise correspondence
Business form, often covering financial statement includes the financial statement of four types, and the financial statement of these four types is：Balance sheet,
Profit flow table, cash flow statement, owner's equity change table.
At present, each financial statement of each enterprise is individually storage, number of the user in different financial statements are inquired about
According to when, it is necessary to being directed to different financial statements formulates different query functions, and the financial statement data amount in Tax is huge
Greatly, involved financial statement quantity is more, if formulating different query functions for each financial statement, exploitation can be caused multiple
The miscellaneous, problem that inquiry workload is big.
The content of the invention
The embodiment of the present invention provides a kind of financial statement integration method and equipment, to solve existing financial statement inquiry mode
The problem that exploitation is complicated, inquiry workload is big brought.
A kind of financial statement integration method provided in an embodiment of the present invention, including：
Obtain the financial statement of the specified type of each enterprise；
For the financial statement of each specified type, according to default standard line number and the corresponding relation of row title collection, really
The corresponding standard line number of each row title in the financial statement of the fixed specified type, wherein, it is centrally stored at least with a line title
One row title for belonging to same attribute；
The corresponding original line number of each row title in the financial statement of the specified type is changed to each row title correspondence
Standard line number；
The financial statement of each specified type that will be changed to after standard line number is saved in same form, after being integrated
Financial statement.
Alternatively, in methods described, according to default standard line number and the corresponding relation of row title collection, the specified class is determined
The corresponding standard line number of each row title, specifically includes in the financial statement of type：
For each the row title in the financial statement of the specified type, the row title collection belonging to the row title is determined；
According to default standard line number and the corresponding relation of row title collection, the row title collection correspondence belonging to the row title is determined
Standard line number；
The corresponding standard line number of row title collection belonging to the row title that will be determined is used as the corresponding standard row of the row title
Number.
The embodiment of the present invention, according to default row title collection and the corresponding relation of standard line number, determines each specified type
Financial statement in the corresponding standard line number of each row title, so as to the line number of the financial statement of each specified type be united
One.
Alternatively, in methods described, the financial statement of the specified type is：Balance sheet, profit flow table, cash flow
Table, owner's equity change table.
Alternatively, methods described, also includes：
The corresponding financial data storage of row title with same standard line number in financial statement after the integration is arrived
The same row of preset table, financial statement after being changed, wherein, after the conversion in financial statement per a line store it is same
Each corresponding financial data of row title in the financial statement of specified type.
The embodiment of the present invention, it is same by the way that the corresponding financial data of the corresponding row title of same standard line number is saved in
Row, same a line is saved in by the corresponding financial data of title of not gone together in the same financial statement of same enterprise, and resulting turns
The space shared by financial statement changed after the corresponding integration in the space shared by rear financial statement greatly reduces.
Alternatively, in methods described, every a line of financial statement also stores the same specified type after the conversion
The corresponding enterprise's mark of enterprise belonging to financial statement.
The embodiment of the present invention, can be easy to user to distinguish the financial data of different enterprises.
The present invention also provides a kind of financial statement integration equipment, including：
Acquisition module, the financial statement of the specified type for obtaining each enterprise；
Determining module, for the financial statement for each specified type, according to default standard line number and row title collection
Corresponding relation, determine the corresponding standard line number of each row title in the financial statement of the specified type, wherein, with a line title
The centrally stored at least one row title for belonging to same attribute；
Change module, is changed to respectively for the corresponding original line number of each row title in the financial statement by the specified type
The corresponding standard line number of individual row title；
Module is integrated, the financial statement of each specified type for will be changed to after standard line number is saved in same table
Lattice, the financial statement after being integrated.
Alternatively, the determining module specifically for：
For each the row title in the financial statement of the specified type, the row title collection belonging to the row title is determined；
According to default standard line number and the corresponding relation of row title collection, the row title collection correspondence belonging to the row title is determined
Standard line number；
The corresponding standard line number of row title collection belonging to the row title that will be determined is used as the corresponding standard row of the row title
Number.
Alternatively, the financial statement of the specified type is：Balance sheet, profit flow table, cash flow statement, owner's power
Benefit changes table.
Alternatively, the equipment, also includes：
Modular converter, for the corresponding wealth of row title that will there is same standard line number in the financial statement after the integration
The same row of data Cun Chudao preset tables of being engaged in, financial statement after being changed, wherein, it is each in financial statement after the conversion
Each corresponding financial data of row title in the capable financial statement for storing same specified type.
Alternatively, every a line of financial statement is also stored belonging to the financial statement of the same specified type after the conversion
Corresponding enterprise of enterprise mark.
Using financial statement integration method provided in an embodiment of the present invention and equipment, have the advantages that：
The same type of financial statement of different enterprises uniform format and the finance stored to after same integration have been carried out into
In form, now only need to formulate same query function for the financial statement of the type, reduce to a certain extent
Exploitation complexity and inquiry workload, also improve to a certain extent user carry out financial data inquiry convenience and
Efficiency.
Brief description of the drawings
Fig. 1 financial statement integration method flow chart schematic diagrames provided in an embodiment of the present invention；
Fig. 2 flow chart schematic diagrames for determining the corresponding standard line number of row title provided in an embodiment of the present invention；
Fig. 3 embodiment of the present invention provides the structural representation of financial statement integration equipment.
Specific embodiment
The financial statement integration method that the present invention is provided is illustrated in greater detail with reference to the accompanying drawings and examples.
The embodiment of the present invention provides a kind of financial statement integration method, as shown in figure 1, including：
Step 101, obtains the financial statement of the specified type of each enterprise.
Specifically, in Analysis of Tariff Data system, being related to the financial statement of multiple enterprises, each enterprise is related at least one
Set financial statement, often covering financial statement includes the financial statement of four types, i.e. balance sheet, profit flow table, cash flow
Table, owner's equity change table, it is also possible to also including other types of financial statement, do not limit here.Wherein, specified type
Financial statement can be any one in balance sheet, profit flow table, cash flow statement, owner's equity variation table.
In this step, for each enterprise for carrying out financial statement integration in advance, in obtaining the financial statement of each enterprise
The financial statement of specified type, that is, obtain the financial statement of the specified type in each enterprise, for example, carrying out financial statement in advance
The enterprise of integration includes enterprise A and enterprise B, obtains the profit flow table in enterprise A and the profit in enterprise B in this step respectively
Table, wherein, profit flow table is the financial statement of specified type.
Step 102, it is corresponding with row title collection according to default standard line number for the financial statement of each specified type
Relation, determines the corresponding standard line number of each row title in the financial statement of the specified type, wherein, concentrated with a line title and deposited
Storage at least one belongs to the row title of same attribute.
Specifically, the storage mode of financial data is to be stored by row in existing financial statement, i.e., often row stores report successively
Sequence number is sent, audit field, original line number, row title, the corresponding financial data of row title.But the specified type of different enterprises
Financial data storage mode in financial statement may be different, such as same a line in the financial statement of the specified type of different enterprises
Title may correspond to different original line numbers.During specific implementation, for same in the financial statement of the specified type of different enterprises
The row title of attribute may be differed also, therefore, in order to the line number in the financial statement by each specified type is unified into standard
Line number, the embodiment of the present invention has pre-build the corresponding relation of standard line number and row title collection, centrally stored extremely with a line title
A few row title for belonging to same attribute.Row title in the such as profit flow table of enterprise A is taken in the profit flow table with enterprise B
Operating income, then will income same standard line number corresponding with operating income to belong to same attribute, i.e. operating income.Do not go together name
Claim the corresponding standard line number of collection different.
Step 103, each row is changed to by the corresponding original line number of each row title in the financial statement of the specified type
The corresponding standard line number of title.
During specific implementation, the corresponding original line number of row title is replaced with into the corresponding standard line number of row title, so that will not
Line number standardization is carried out with the financial statement of the specified type of enterprise.Specifically, for the finance report of one of specified type
Exist and non-existent row title in the financial statement of other specified types in table, the corresponding original line number of the row title can be replaced
The line numbers different from other corresponding standard No.s of row title are changed to, so as to avoid the occurrence of the problem that line number is repeated.
Step 104, the financial statement of each specified type that will be changed to after standard line number is saved in same form, obtains
Financial statement after integration.
Specifically, the financial statement of the specified type of each enterprise that will be changed to after standard line number is saved in same form
In, the financial statement after being integrated, the financial statement after the integration is wealth after the corresponding integration of financial statement of specified type
Business form.
Illustrate, it is assumed that the enterprise that preadmission row financial statement is integrated includes enterprise A and enterprise B, the finance of specified type
Form be enterprise A in and enterprise B in profit flow table, the profit flow table of enterprise A as shown in Table 1, the profit flow table such as institute of table two of enterprise B
Show, wherein, the storage mode of financial data is different in table one and table two, and the corresponding relation of standard line number and row title collection is such as
Shown in table three, using financial statement integration method provided in an embodiment of the present invention, according to the corresponding relation that table three is provided, by table one
Financial statement after the integration obtained after being integrated with table two is as shown in Table 4.
Table one
| Data report and submit sequence number | Line number | Row title | This month amount of money | This year adds up | Date of entry |
| 01 | 1 | Operating income | 0 | 0 | 2013.3.4 |
| 01 | 2 | Sales volume | 0 | 0 | 2013.3.4 |
| 01 | 3 | Administration fee | 0 | 0 | 2013.3.4 |
Table two
| Data report and submit sequence number | Line number | Row title | This month amount of money | This year adds up | Date of entry |
| 02 | 1 | Consumption sum | 0 | 0 | 2013.3.4 |
| 02 | 2 | Income | 0 | 0 | 2013.3.4 |
| 02 | 3 | Administration fee | 0 | 0 | 2013.3.4 |
Table three
Table four
It should be noted that the income in operating income and table two in table one belongs to operating income this attribute, table
The consumption sum in sales volume and table two in one belongs to consumption sum this attribute.
As shown in Table 4, in the financial statement after integration, same form has been arrived in two profit flow table storages, and belongs to same
The corresponding line number of row title of attribute has been unified into standard line number, it is preferable that also marked including enterprise in the financial statement after integration
Know, the financial data for distinguishing different enterprises.Wherein, during the data in table four report and submit sequence number for distinguishing each financial statement
Financial data reports and submits order, it is necessary to explanation, the same financial statement of same enterprise may report and submit repeatedly, report and submit every time
Financial data may have renewal, therefore, the corresponding packet of financial data that homogeneous is not reported and submitted send sequence number also different.
Using the embodiment of the present invention, respectively by the balance sheet of the different enterprises, profit flow table, cash flow statement and institute
The person's of having rights and interests variation table is integrated, the financial statement after being integrated accordingly, that is, balance sheet after being integrated, whole
The cash flow statement after profit flow table, integration after conjunction and the owner's equity after integration change table.
In the prior art, the storage mode of financial data can not in the same type of financial statement of different enterprises
Together, therefore in the prior art because the financial statement of different enterprises is individually storage, it is therefore desirable to for different finance
Form formulates different query functions, such as, the profit flow table for different enterprises formulates different query functions respectively, and the tax
Financial statement data amount in industry is huge, and involved financial statement quantity is more, if being formulated not for each financial statement
Same query function, can cause the problem that exploitation is complicated, inquiry workload is big.Financial statement provided in an embodiment of the present invention is integrated
Method, uniform format and the financial statement stored to after same integration have been carried out by the same type of financial statement of different enterprises
In, now only need to formulate same query function for the financial statement of the type, exploitation is reduced to a certain extent
Complexity and the workload of inquiry, user is also improve to a certain extent carries out the convenience and effect of financial data inquiry
Rate.
Preferably, the content for being provided according to Fig. 2, according to default standard line number and the corresponding relation of row title collection, it is determined that
The corresponding standard line number of each row title in the financial statement of the specified type：
Step 201, for each the row title in the financial statement of the specified type, determines the row name belonging to the row title
Claim collection.
Specifically, for each the row title in the financial statement of each specified type, according to default standard line number with
Row title collection in the corresponding relation of row title collection, determines the row title collection belonging to each row title.
Step 202, according to default standard line number and the corresponding relation of row title collection, determines the row name belonging to the row title
Claim collection corresponding standard line number.
Step 203, the corresponding standard line number of row title collection belonging to the row title that will be determined is corresponding as the row title
Standard line number.
The embodiment of the present invention, according to default row title collection and the corresponding relation of standard line number, determines each specified type
Financial statement in the corresponding standard line number of each row title, so as to the line number of the financial statement of each specified type be united
One.
Financial statement after integration obtained above has carries out the financial statement after inquiry operation, but the integration using user
In have many financial datas for repeating, such as the Plays line number of table four and identical report and submit sequence number to occupy multiple cells,
Date of entry (can regard as one audit field) also occupies multiple cells, if data volume is very big, can take compared with
Large space, therefore, for save space, it is preferable that the financial statement after the integration that will be obtained carries out further compression treatment,
Specific compress mode is as follows：
The corresponding financial data storage of row title with same standard line number in financial statement after the integration is arrived
The same row of preset table, financial statement after being changed, wherein, after the conversion in financial statement per a line store it is same
Each corresponding financial data of row title in the financial statement of specified type.
Specifically, by the row title correspondence with same standard line number in the financial statement after integration in the embodiment of the present invention
Financial data storage to same row, by the corresponding financial data storage of title of not gone together in the financial statement of same specified type
To same a line.Preferably, same data in the financial statement of same specified type are reported and submitted into the corresponding title pair of not going together of needs
Same a line is arrived in the financial data storage answered.
It is further preferred that the financial data in order to distinguish different enterprises, after the conversion, every a line of financial statement is also
The corresponding enterprise's mark of enterprise belonging to the financial statement of the same specified type is stored, so as to distinguish the finance of different enterprises
Data.
Continue to use the example above, financial statement such as table after the conversion obtained after table four is compressed according to the embodiment of the present invention
Shown in five.
Table five
Table four and table five are carried out into contrast as can be seen that table five is due to the corresponding row name of the same standard line number of different enterprises
The corresponding financial data storage of title of not going together of corresponding financial data storage to same row, same enterprise is claimed to arrive same a line,
So that enterprise's mark, line number and this repeated financial data occurred in table four of date of entry greatly reduce, the phase of table five
Also greatly reduce for the memory space shared by table four.
As the above analysis, the side being compressed using the financial statement by after integration provided in an embodiment of the present invention
Formula, is saved in same row, by the same of same enterprise by by the corresponding financial data of the corresponding row title of same standard line number
The corresponding financial data of title of not gone together in financial statement is saved in same a line, after resulting conversion shared by financial statement
The space shared by financial statement after the corresponding integration in space greatly reduces.
The embodiment of the present invention also provides a kind of financial statement integration equipment, as shown in figure 3, including：
Acquisition module 301, the financial statement of the specified type for obtaining each enterprise；
Determining module 302, for the financial statement for each specified type, according to default standard line number and row title
The corresponding relation of collection, determines the corresponding standard line number of each row title in the financial statement of the specified type, wherein, with a line name
Claim the centrally stored at least one row title for belonging to same attribute；
Change module 303, for the corresponding original line number change of each row title in the financial statement by the specified type
It is the corresponding standard line number of each row title；
Module 304 is integrated, the financial statement of each specified type for will be changed to after standard line number is saved in same
Form, the financial statement after being integrated.
Alternatively, the determining module 302 specifically for：
For each the row title in the financial statement of the specified type, the row title collection belonging to the row title is determined；
According to default standard line number and the corresponding relation of row title collection, the row title collection correspondence belonging to the row title is determined
Standard line number；
The corresponding standard line number of row title collection belonging to the row title that will be determined is used as the corresponding standard row of the row title
Number.
Alternatively, the financial statement of the specified type is：Balance sheet, profit flow table, cash flow statement, owner's power
Benefit changes table.
Alternatively, the equipment, also includes：
Modular converter 305, for the row title with same standard line number in the financial statement after the integration is corresponding
Financial data storage to preset table same row, financial statement after being changed, wherein, after the conversion in financial statement
Each corresponding financial data of row title in the financial statement of same specified type is stored per a line.
Alternatively, every a line of financial statement is also stored belonging to the financial statement of the same specified type after the conversion
Corresponding enterprise of enterprise mark.
Using financial statement integration method provided in an embodiment of the present invention and equipment, have the advantages that：
The same type of financial statement of different enterprises uniform format and the finance stored to after same integration have been carried out into
In form, now only need to formulate same query function for the financial statement of the type, reduce to a certain extent
Exploitation complexity and inquiry workload, also improve to a certain extent user carry out financial data inquiry convenience and
Efficiency.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method, system or computer program
Product.Therefore, the present invention can use complete hardware embodiment, complete application software embodiment or connected applications software and hardware
The form of the embodiment of aspect.And, the present invention can be used and wherein include computer usable program code at one or more
Computer-usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) on implement calculating
The form of machine program product.
The present invention is the flow with reference to method according to embodiments of the present invention, equipment (system) and computer program product
Figure and/or block diagram are described.It should be understood that every first-class during flow chart and/or block diagram can be realized by computer program instructions
The combination of flow and/or square frame in journey and/or square frame and flow chart and/or block diagram.These computer programs can be provided
The processor of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce
A raw machine so that produced for reality by the instruction of computer or the computing device of other programmable data processing devices
The device of the function of being specified in present one flow of flow chart or multiple one square frame of flow and/or block diagram or multiple square frames.
These computer program instructions may be alternatively stored in can guide computer or other programmable data processing devices with spy
In determining the computer-readable memory that mode works so that instruction of the storage in the computer-readable memory is produced and include finger
Make the manufacture of device, the command device realize in one flow of flow chart or multiple one square frame of flow and/or block diagram or
The function of being specified in multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that in meter
Series of operation steps is performed on calculation machine or other programmable devices to produce computer implemented treatment, so as in computer or
The instruction performed on other programmable devices is provided for realizing in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in individual square frame or multiple square frames.
, but those skilled in the art once know basic creation although preferred embodiments of the present invention have been described
Property concept, then can make other change and modification to these embodiments.So, appended claims are intended to be construed to include excellent
Select embodiment and fall into having altered and changing for the scope of the invention.
Obviously, those skilled in the art can carry out the essence of various changes and modification without deviating from the application to the application
God and scope.So, if these modifications of the application and modification belong to the scope of the application claim and its equivalent technologies
Within, then the application is also intended to comprising these changes and modification.
Claims (10)
1. a kind of financial statement integration method, it is characterised in that including：
Obtain the financial statement of the specified type of each enterprise；
For the financial statement of each specified type, according to default standard line number and the corresponding relation of row title collection, it is determined that should
The corresponding standard line number of each row title in the financial statement of specified type, wherein, with a line title centrally stored at least one
Belong to the row title of same attribute；
The corresponding original line number of each row title in the financial statement of the specified type is changed to each corresponding mark of row title
There won't be any problem number；
The financial statement of each specified type that will be changed to after standard line number is saved in same form, the finance after being integrated
Form.
2. method according to claim 1, it is characterised in that close according to default standard line number is corresponding with row title collection
System, determines the corresponding standard line number of each row title in the financial statement of the specified type, specifically includes：
For each the row title in the financial statement of the specified type, the row title collection belonging to the row title is determined；
According to default standard line number and the corresponding relation of row title collection, the corresponding mark of row title collection belonging to the row title is determined
There won't be any problem number；
The corresponding standard line number of row title collection belonging to the row title that will be determined is used as the corresponding standard line number of the row title.
3. method according to claim 1, it is characterised in that the financial statement of the specified type is：Balance sheet,
Profit flow table, cash flow statement, owner's equity change table.
4. method according to claim 1, it is characterised in that also include：
The corresponding financial data storage of row title in financial statement after the integration with same standard line number is arrived default
The same row of form, financial statement after being changed, wherein, store same specifying after the conversion in financial statement per a line
Each corresponding financial data of row title in the financial statement of type.
5. method according to claim 4, it is characterised in that every a line of financial statement also stores described after the conversion
The corresponding enterprise's mark of enterprise belonging to the financial statement of same specified type.
6. a kind of financial statement integration equipment, it is characterised in that including：
Acquisition module, the financial statement of the specified type for obtaining each enterprise；
Determining module is right with row title collection according to default standard line number for the financial statement for each specified type
Should be related to, determine the corresponding standard line number of each row title in the financial statement of the specified type, wherein, concentrated with a line title
Storage at least one belongs to the row title of same attribute；
Change module, each row is changed to for the corresponding original line number of each row title in the financial statement by the specified type
The corresponding standard line number of title；
Module is integrated, the financial statement of each specified type for will be changed to after standard line number is saved in same form, obtains
Financial statement after to integration.
7. equipment according to claim 6, it is characterised in that the determining module specifically for：
For each the row title in the financial statement of the specified type, the row title collection belonging to the row title is determined；
According to default standard line number and the corresponding relation of row title collection, the corresponding mark of row title collection belonging to the row title is determined
There won't be any problem number；
The corresponding standard line number of row title collection belonging to the row title that will be determined is used as the corresponding standard line number of the row title.
8. equipment according to claim 6, it is characterised in that the financial statement of the specified type is：Balance sheet,
Profit flow table, cash flow statement, owner's equity change table.
9. equipment according to claim 6, it is characterised in that also include：
Modular converter, for the corresponding financial number of row title that will there is same standard line number in the financial statement after the integration
According to storage to preset table same row, financial statement after change, wherein, after the conversion in financial statement often a line deposit
Each corresponding financial data of row title in the financial statement of same specified type is stored up.
10. equipment according to claim 9, it is characterised in that every a line of financial statement also stores institute after the conversion
State the corresponding enterprise's mark of enterprise belonging to the financial statement of same specified type.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611229979.5A CN106844320B (en) | 2016-12-27 | 2016-12-27 | Financial statement integration method and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611229979.5A CN106844320B (en) | 2016-12-27 | 2016-12-27 | Financial statement integration method and equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106844320A true CN106844320A (en) | 2017-06-13 |
| CN106844320B CN106844320B (en) | 2020-09-15 |
Family
ID=59113316
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611229979.5A Active CN106844320B (en) | 2016-12-27 | 2016-12-27 | Financial statement integration method and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106844320B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109299926A (en) * | 2018-12-03 | 2019-02-01 | 武汉快税通财税服务股份有限公司 | A kind of external finance software data integration method |
| CN109376191A (en) * | 2018-09-18 | 2019-02-22 | 深圳壹账通智能科技有限公司 | Financial report data processing method, device, computer equipment and storage medium |
| CN109816503A (en) * | 2019-01-04 | 2019-05-28 | 深圳壹账通智能科技有限公司 | Financial details data creation method, device, computer equipment and storage medium |
| WO2019153471A1 (en) * | 2018-02-07 | 2019-08-15 | 平安科技（深圳）有限公司 | Data table query method and apparatus, terminal device and storage medium |
| CN111178028A (en) * | 2019-12-11 | 2020-05-19 | 深圳金赋科技有限公司 | Method and equipment for cleaning financial data and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101876970A (en) * | 2009-12-22 | 2010-11-03 | 金蝶软件（中国）有限公司 | Method for combining reports and device thereof |
| CN101908040A (en) * | 2010-07-01 | 2010-12-08 | 千乡万才科技(中国)有限公司 | Data report system |
| CN102567828A (en) * | 2010-12-21 | 2012-07-11 | 金蝶软件（中国）有限公司 | Preparation method and device for consolidated report |
| CN103631969A (en) * | 2013-12-20 | 2014-03-12 | 北京中电普华信息技术有限公司 | Generation method and device of report data |
| CN104021449A (en) * | 2014-06-19 | 2014-09-03 | 北京工商大学 | Conglomerate report file merging method and device based on open platform system |
| CN105335459A (en) * | 2015-09-24 | 2016-02-17 | 四川长虹电器股份有限公司 | XBRL intelligent report platform based statement consolidation data extraction method |
| CN105354213A (en) * | 2015-09-24 | 2016-02-24 | 四川长虹电器股份有限公司 | Method for establishing XBRL financial report business model based on data point modeling |
-
2016
- 2016-12-27 CN CN201611229979.5A patent/CN106844320B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101876970A (en) * | 2009-12-22 | 2010-11-03 | 金蝶软件（中国）有限公司 | Method for combining reports and device thereof |
| CN101908040A (en) * | 2010-07-01 | 2010-12-08 | 千乡万才科技(中国)有限公司 | Data report system |
| CN102567828A (en) * | 2010-12-21 | 2012-07-11 | 金蝶软件（中国）有限公司 | Preparation method and device for consolidated report |
| CN103631969A (en) * | 2013-12-20 | 2014-03-12 | 北京中电普华信息技术有限公司 | Generation method and device of report data |
| CN104021449A (en) * | 2014-06-19 | 2014-09-03 | 北京工商大学 | Conglomerate report file merging method and device based on open platform system |
| CN105335459A (en) * | 2015-09-24 | 2016-02-17 | 四川长虹电器股份有限公司 | XBRL intelligent report platform based statement consolidation data extraction method |
| CN105354213A (en) * | 2015-09-24 | 2016-02-24 | 四川长虹电器股份有限公司 | Method for establishing XBRL financial report business model based on data point modeling |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2019153471A1 (en) * | 2018-02-07 | 2019-08-15 | 平安科技（深圳）有限公司 | Data table query method and apparatus, terminal device and storage medium |
| CN109376191A (en) * | 2018-09-18 | 2019-02-22 | 深圳壹账通智能科技有限公司 | Financial report data processing method, device, computer equipment and storage medium |
| CN109299926A (en) * | 2018-12-03 | 2019-02-01 | 武汉快税通财税服务股份有限公司 | A kind of external finance software data integration method |
| CN109816503A (en) * | 2019-01-04 | 2019-05-28 | 深圳壹账通智能科技有限公司 | Financial details data creation method, device, computer equipment and storage medium |
| CN111178028A (en) * | 2019-12-11 | 2020-05-19 | 深圳金赋科技有限公司 | Method and equipment for cleaning financial data and storage medium |
| CN111178028B (en) * | 2019-12-11 | 2024-06-04 | 深圳金赋科技有限公司 | Financial data cleaning method, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106844320B (en) | 2020-09-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106844320A (en) | A kind of financial statement integration method and equipment | |
| Kao | Efficiency decomposition and aggregation in network data envelopment analysis | |
| US20180137180A1 (en) | Systems and methods for interest-driven data visualization systems utilized in interest-driven business intelligence systems | |
| JP5008662B2 (en) | Data aggregation by compound operation | |
| US20180210934A1 (en) | Systems and methods for interest-driven business intelligence systems including event-oriented data | |
| CN107622103A (en) | Manage data query | |
| CN107908672A (en) | Application report implementation method, equipment and storage medium based on Hadoop platform | |
| CN104750727B (en) | A kind of column memory storage inquiry unit and column memory storage querying method | |
| CN106875110A (en) | Operational indicator layered calculation method and device, distributed computing method and system | |
| CN102024062A (en) | Device and method for realizing data dynamic cache | |
| CN105989129A (en) | Real-time data statistic method and device | |
| US20150081353A1 (en) | Systems and Methods for Interest-Driven Business Intelligence Systems Including Segment Data | |
| CN107967347A (en) | Batch data processing method, server, system and storage medium | |
| CN105843842A (en) | Multi-dimensional gathering querying and displaying system and method in big data environment | |
| US20180373777A1 (en) | Systems and methods for memory optimization interest-driven business intelligence systems | |
| CN107273339A (en) | A kind of task processing method and device | |
| CN108062378B (en) | The Connection inquiring method and system of more time serieses under a kind of storage of column | |
| Cremona | The elliptic curve database for conductors to 130000 | |
| CN106250565A (en) | Querying method based on burst relevant database and system | |
| CN111913962A (en) | Multi-dimensional annual detailed fund planning system and method | |
| CN111754340A (en) | Guarantee network risk investigation system based on graph database | |
| CN103455556B (en) | Memory cell data method of cutting out | |
| CN105740328B (en) | method for generating bank protection report | |
| CN113505172B (en) | Data processing method, device, electronic equipment and readable storage medium | |
| US20180365872A1 (en) | Systems and methods for rendering visualizations in an interest-driven business intelligence system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |