CN115618825A - Financial statement merging method and device, computer readable medium and terminal equipment - Google Patents
Financial statement merging method and device, computer readable medium and terminal equipment Download PDFInfo
- Publication number
- CN115618825A CN115618825A CN202211216153.0A CN202211216153A CN115618825A CN 115618825 A CN115618825 A CN 115618825A CN 202211216153 A CN202211216153 A CN 202211216153A CN 115618825 A CN115618825 A CN 115618825A
- Authority
- CN
- China
- Prior art keywords
- target
- merging
- financial
- merged
- index data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application provides a financial statement merging method, a financial statement merging device, a computer readable medium and terminal equipment, and relates to the technical field of data processing, wherein the method comprises the following steps: receiving a financial statement merging instruction of a user, and acquiring merging parameters corresponding to the financial statement merging instruction, wherein the merging parameters comprise a target merging group and a target financial statement type; determining target main bodies corresponding to the target sub-combination groups and target financial index data of the target financial statement types; and acquiring target financial index data corresponding to each target main body, merging the target financial index data of each target main body to generate a target financial merged sub-report, merging the corresponding target financial index data in each target financial merged sub-report according to a preset hierarchical relation corresponding to the target merged group to generate a target financial merged report. According to the method and the device, the accuracy and the merging efficiency of data merging can be effectively improved, the labor cost is reduced, and the reporting period of the financial merged report is shortened.
Description
Technical Field
The application relates to the technical field of data processing, in particular to a financial statement merging method, a financial statement merging device, a computer readable medium and a terminal device.
Background
However, for enterprises with numerous subsidiaries, complex businesses and great differences in the aspects of performance, accounting and the like, data needing to be checked, adjusted and offset are too complicated, and layer-by-layer combination needs to be performed according to various organizations.
Content of application
An object of the embodiments of the present application is to provide a method and an apparatus for merging financial statements, a computer-readable medium, and a terminal device, so as to solve the problem that it is difficult to perform the merging of the financial statements in a timely and accurate manner in the prior art.
In order to achieve the above object, a first aspect of the present application provides a financial statement merging method, including:
receiving a financial statement merging instruction of a user, and acquiring a merging parameter corresponding to the financial statement merging instruction, wherein the merging parameter comprises a target merging group and a target financial statement category;
judging whether the target merging group comprises a plurality of target sub-merging groups with hierarchical relationship, and determining a target main body corresponding to each target sub-merging group and target financial index data of the target financial statement type under the condition that the target merging group comprises the plurality of target sub-merging groups with hierarchical relationship;
and acquiring target financial index data corresponding to each target main body, merging the target financial index data of each target main body to generate a target financial merged sub-report, and merging the corresponding target financial index data in each target financial merged sub-report according to a preset hierarchical relation corresponding to the target merged group to generate a target financial merged report.
Optionally, the financial statement merging instruction includes a merging target time preset by a user, and the determining whether the target merged group includes a plurality of target sub-merged groups having a hierarchical relationship includes:
and acquiring the current time in real time, and judging whether the target merging group comprises a plurality of target sub-merging groups with hierarchical relationship or not under the condition that the current time is matched with the financial merging target time.
Optionally, the method further comprises:
determining a target main body corresponding to each target merging group and target financial index data of the target financial statement type under the condition that the target merging group does not comprise the target sub-merging group;
and acquiring target financial index data corresponding to each target main body, merging the target financial index data of each target main body, and generating a target financial merged report.
Optionally, the target sub-merge-group comprises:
a first class target sub-merge-group and a second class target sub-merge-group;
the first category target sub-merge group comprises at least one first category target subject, and the second category target sub-merge group comprises at least one second category target subject.
Optionally, the obtaining of the target financial index data corresponding to each target subject includes:
and acquiring target financial index data corresponding to the first category target main body through a preset data model, and acquiring target financial index data corresponding to the second category target main body through a preset financial statement.
Optionally, obtaining target financial index data corresponding to each target subject, merging the target financial index data of each target subject to generate a target financial merged sub-report, merging the corresponding target financial index data in each target financial merged sub-report according to a preset hierarchical relationship corresponding to the target merged group to generate a target financial merged report, including:
acquiring target financial index data corresponding to each first-class target main body, merging the target financial index data of all the first-class target main bodies to generate a first target financial merged sub-report, merging the corresponding target financial index data in each first target financial merged sub-report according to a preset hierarchical relation corresponding to the target merged group to generate a first initial target financial merged report;
acquiring target financial index data corresponding to each second type of target main body, merging the target financial index data of all the second type of target main bodies to generate a second target financial merged sub-report, merging the corresponding target financial index data in each second target financial merged sub-report according to a preset hierarchical relation corresponding to the target merged group to generate a second initial target financial merged report;
and combining the corresponding target financial index data in the first initial target financial combination report and the second initial target financial combination report to generate a target financial combination report.
Optionally, the method further comprises:
determining the number of target subjects, and dividing the target subjects into at least one target subject set, wherein each target subject set at least comprises one target subject;
determining corresponding computing nodes according to the number of the target subject sets, wherein the computing nodes comprise first computing nodes and second computing nodes, and the number of the first computing nodes corresponds to the number of the target subject sets one to one;
merging the target financial index data of each target main body in the corresponding target main body set through the first computing node to generate a target financial merged sub-report, and merging the corresponding target financial index data in each target financial merged sub-report through the second computing node according to a preset hierarchical relation corresponding to the target merged group to generate a target financial merged report; or
And acquiring target financial index data of each target main body in the corresponding target main body set through the first computing node, and combining the target financial index data of each target main body through the second computing node to generate a target financial combination report.
This application second aspect provides a financial statement merger device, includes:
the instruction receiving module is configured to receive a financial statement merging instruction of a user and acquire merging parameters corresponding to the financial statement merging instruction, wherein the merging parameters comprise a target merging group and a target financial statement type;
the data acquisition module is configured to judge whether the target merging group comprises a plurality of target sub-merging groups with hierarchical relationships, and determine a target main body corresponding to each target sub-merging group and target financial index data of the target financial statement type under the condition that the target merging group comprises the plurality of target sub-merging groups with hierarchical relationships;
and the data merging module is configured to acquire target financial index data corresponding to each target main body, merge the target financial index data of each target main body to generate a target financial merging sub-report, and merge the corresponding target financial index data in each target financial merging sub-report according to a preset hierarchical relationship corresponding to the target merging group to generate a target financial merging report.
A third aspect of the present application provides a computer-readable medium, which stores a computer program, and when the computer program is executed by a processor, the computer program implements the above-mentioned financial statement merging method.
The fourth aspect of the present application provides a terminal device, which includes a memory, a processor, and a computer program stored in the memory and operable on the processor, where the processor implements the financial statement merging method when executing the computer program.
The implementation mode provided by the application has the following beneficial effects:
according to the method and the device, the merging framework of each target main body is established in advance, so that the hierarchical relation of each target main body can be determined according to the predetermined merging framework when a merging instruction is received, the merging of the financial reports among different target main bodies is automatically executed, the accuracy and merging efficiency of data merging can be effectively improved, the labor cost is reduced, and the reporting period of the financial merged reports is shortened.
Additional features and advantages of embodiments or examples of the present application are described in detail in the detailed description which follows.
Drawings
The accompanying drawings, which are included to provide a further understanding of the embodiments of the disclosure and are incorporated in and constitute a part of this specification, illustrate embodiments of the disclosure and together with the description serve to explain the embodiments of the disclosure, but are not intended to limit the embodiments of the disclosure. In the drawings:
FIG. 1 is a flow chart of a method for merging financial statements according to an embodiment of the present disclosure;
FIG. 2 is a schematic block diagram of a financial statement merging device according to an embodiment of the present application;
fig. 3 schematically shows a structural diagram of a terminal device according to an embodiment of the present application.
Description of the reference numerals
10-terminal device, 100-processor, 101-memory, 102-computer program.
Detailed Description
The following describes in detail specific embodiments of the present application with reference to the drawings. It should be understood that the detailed description and specific examples, while indicating the embodiments of the application, are given by way of illustration and explanation only, not limitation.
As shown in fig. 1, a first aspect of the present embodiment provides a financial statement merging method, including:
receiving a financial statement merging instruction of a user, and acquiring merging parameters corresponding to the financial statement merging instruction, wherein the merging parameters comprise a target merging group and a target financial statement type;
judging whether the target merging set comprises a plurality of target sub-merging sets with hierarchical relationship, and determining target main bodies corresponding to the target sub-merging sets and target financial index data of the target financial statement types under the condition that the target merging set comprises the plurality of target sub-merging sets with hierarchical relationship;
and combining the corresponding target financial index data in the target financial combination sub-reports according to the preset hierarchical relationship corresponding to the target combination group to generate the target financial combination report.
Therefore, the merging framework of each target main body is established in advance, so that the hierarchical relation of each target main body can be determined according to the predetermined merging framework when a merging instruction is received, the merging of financial reports among different target main bodies is automatically executed, the accuracy and merging efficiency of data merging can be effectively improved, the labor cost is reduced, and the reporting period of the financial merged reports is shortened.
Specifically, a plurality of sets of financial merging frameworks are constructed in advance according to management needs, and the financial merging frameworks may include a property framework or a management framework and the like. The merging framework consists of a single company, a merging group and a cancellation user, wherein the single company corresponds to a base unit; the merging group comprises group large merging and each level unit such as each level two unit, level three unit and the like, or a virtual unit node arranged according to the business management requirement; the offset account is used as a virtual unit node for offsetting the financial affairs of each merging group and corresponds to the merging group one by one. It is understood that in the present application, a target merge may include a single company, a merge, or a cancellation household. For example, the target merge group may include only monomer company y001; alternatively, the target merge may comprise merge a001, wherein a001 comprises monomer companies y001, y002. In the present application, the target financial statement category may include financial statements such as an asset liability statement, a profit statement, and a cash flow statement. For example, the merge instruction includes a001, the balance sheet, indicating that data merging is required for the balance sheets of all the individual companies subordinate to the merge group a001. The financial index data comprises monetary funds, accounts receivable, major business income, total business cost and the like, the financial indexes of different types of financial consolidated reports are coded in advance, and meanwhile, the time dimension of the financial index data of the financial consolidated reports is coded, for example, different dimensional value codes are respectively given to end-of-term balance, last-year same-term number, early-year balance and the like, so that corresponding data can be searched quickly when data consolidation is carried out. In the application, the property architecture can be automatically synchronized from an ERP system, and the unit attributes, the hierarchical relationship and the like of the single company are consistent with the property architecture of the ERP system; in order to conveniently check offset data of each merging group, offset user nodes are automatically set under each merging group. The management architecture is constructed according to management needs, a single company can be selected from the property right architecture as a unit node of the management architecture, and a virtual unit node can be set according to business management needs, for example, a merge group named according to a certain business plate of a group.
In the present application, the target sub-merge-group includes: a first category target sub-merge-group and a second category target sub-merge-group; the first category target sub-merge group comprises at least one first category target subject, and the second category target sub-merge group comprises at least one second category target subject. The first-class target body represents an ERP unit, and the second-class target body represents a non-ERP unit. It can be understood that in the merged architecture, usually, most of the accounting data of the single company is in the ERP system, the single company entered in the ERP system is an ERP unit, and the single company whose accounting data is not in the ERP system is a non-ERP unit. For ERP units and non-ERP units, identification differentiation can be performed on the merged architecture in advance. For example, the merge instruction includes a001 and an asset liability table, and the attributes (y 001, 1) and (y 002, 0) of the individual company under the a001 can be obtained through a pre-constructed merge framework, where y001 and y002 are identifiers of the individual companies, 1 identifies the company as an ERP unit, and 0 indicates that the company is a non-ERP unit.
After receiving the merge instruction, the hierarchical relationship of the target merge group is first determined by the pre-constructed merge framework. For example, if the merging instruction is a001 and a balance sheet, querying the hierarchical relationship of the a001 from a pre-constructed merging framework, for example, by querying, the a001 subordinate has two sub-merging groups B001 and B002, and the sub-merging group B001 includes subordinate sub-merging groups C001 and C002, acquiring balance sheet data of each individual company in the C001, and performing data merging on the balance sheet data of all individual companies of the C001 to generate a target financial merged sub-report C001; acquiring the data of the balance sheet of each monomer company in the C002, merging the data of the balance sheet of all the monomer companies of the C002 to generate a target financial merged sub-report C002, merging the data of the C001 and the C002 to generate a target financial merged sub-report B001; and in the same way, generating a target financial combination sub-report B002 of the combination group B002, and finally performing data combination on the target financial combination sub-report B001 and the target financial combination sub-report B002 to generate a final target financial combination report A001.
Alternatively, the method of the present application further comprises: determining target main bodies corresponding to the target merging groups and target financial index data of the target financial statement types under the condition that the target merging groups do not comprise the target sub-merging groups; and acquiring target financial index data corresponding to each target main body, merging the target financial index data of each target main body, and generating a target financial merged report. If the single companies with the hierarchical relationship are not included in the merged group a001, that is, the single companies y001, y002, y003 and the like are included in a001, the balance sheet data of y001, y002 and y003 are respectively obtained, and the balance sheet data of y001, y002 and y003 are merged to generate the target financial merged statement.
In this application, obtain the target financial index data that each target subject corresponds, include: and acquiring target financial index data corresponding to the first category target main body through a preset data model, and acquiring target financial index data corresponding to the second category target main body through a preset financial statement. For ERP units, when financial statement combination is executed, the financial data and the offset data of the corresponding single company are obtained through an ERP system. The ERP system is pre-established with various data models, such as a general record inventory model, an income cost model, an inventory model, a current reconciliation analysis model, a two-fund occupation model and the like. In the present application, the consolidation of the accounting data is realized by calling a pre-constructed financial statement consolidation model, for example, an inter-table access formula based on a non-ERP unit level relationship in a consolidation framework and an accounting access formula constructed based on an ERP unit level relationship in a consolidation framework, where the access formula may be set according to business requirements, which is the prior art, and is not described herein again. When the merging model is established, the acquired data model field is coded in advance to keep consistent with the data model field code of the ERP system, and meanwhile, the dimensions of accounting subjects, plates and the like are coded to keep consistent with the dimension and dimension value code of the ERP system. For example, M _ C11 represents the total record inventory model, M _ VG001 represents the receivables; and (4) coding the dimensions of the accounting subjects, the plates and the like, and keeping the dimensions and dimensional value codes consistent with the ERP system, wherein W _ ITEM represents the accounting subjects, and W _ BK represents the plates. For another example, if the accounting data whose accounting subject is cash in stock-rmb and block is coal production is obtained from the master record list data model, the number obtaining condition is if M _ C11$ W _ ITEM = = '1001990100' & & M _ C11$ BK = '01', and the number obtaining formula is M _ C11$ N _ TRN _ JT, where M _ C11$ ITEM represents accounting subject, M _ C11$ W _ BK represents block, M _ C11$ W _ JT represents block, M _ C11$ N _ TRN _ JT represents time period value in group currency, "1001990100" represents cash in stock of accounting subject-rmb, "01" represents block is coal production, and "& &" represents a relationship with two conditions before and after.
For the non-ERP units, the related data is obtained through the preset financial statement, it can be understood that the related account data of the non-ERP units is recorded in the corresponding financial statement, when the related account data of the non-ERP units is obtained, the related data can be obtained through the preset financial statement, and when data merging is carried out, the non-ERP units obtain the report data from the merged statement according to subordinate units of the non-ERP units and carry out merging calculation. For non-ERP units, the inter-table access formula of the financial combination report is compiled according to the financial index code and the time dimension value. For example, if the monetary funds end balance is obtained from the balance sheet, the numerical formula is formulated as = a $ Z _ Z01$ W _ T01, where a represents the balance sheet, $ Z _ Z01$ W _ T01 represents the monetary funds end balance, and "=" is the assignment expression. It is understood that, in the present application, the merged model may include a corresponding access formula according to the category of the target subject, i.e. the target monomer company, being an ERP unit and/or a non-ERP unit. By encoding the model field, financial index data and the like, the source data can be accurately and quickly acquired when a merging model is constructed and data merging is performed.
Because the data acquisition ways of the ERP unit and the non-ERP unit are different, and the data merging process of the ERP unit and the non-ERP unit is also different, in the application, the target financial index data corresponding to each target main body is acquired, the target financial index data of each target main body are merged to generate a target financial merging sub-report, and the corresponding target financial index data in each target financial merging sub-report are merged according to the preset hierarchical relation corresponding to the target merging group to generate a target financial merging report, which comprises the following steps:
acquiring target financial index data corresponding to each first-class target main body, merging the target financial index data of all the first-class target main bodies to generate a first target financial merged sub-report, merging the corresponding target financial index data in each first target financial merged sub-report according to a preset hierarchical relation corresponding to a target merged group to generate a first initial target financial merged report. Specifically, for the ERP unit account combination of the financial combined report, the account combination is carried out according to the ERP unit level relation and the account access formula in the combined architecture; for example, 2 single companies under a certain combined group are ERP units, when the balance sheet of the combined group is issued, the accounting data and the offset data of the 2 ERP single companies are obtained from the total record list data model, and the financial statement combining calculation is executed according to an accounting data calculation formula edited in advance by the balance sheet.
And acquiring target financial index data corresponding to each second type of target main body, merging the target financial index data of all the second type of target main bodies to generate a second target financial merged sub-report, merging the corresponding target financial index data in each second target financial merged sub-report according to the preset hierarchical relation corresponding to the target merged group to generate a second initial target financial merged report. Specifically, combining non-ERP unit financial reports of the financial combined report, and combining the reports according to a non-ERP unit level relation and an inter-table access formula in a combined framework; for example, 2 individual companies under a certain combined group are all non-ERP units, when the balance sheet of the combined group is issued, report data is obtained from the balance sheet of the 2 non-ERP individual companies, balance sheet data of the combined group is obtained, and financial statement combining calculation is executed according to a pre-programmed inter-table access calculation formula of the balance sheet.
And for a combined group under the financial combined report merging framework, when both an ERP unit and a non-ERP unit exist, dividing the combined calculation into two parts, namely, combining and calculating the account data of the ERP unit and combining and calculating the financial report data of the non-ERP unit, respectively obtaining a first initial target financial combined report of the ERP unit and a second initial target financial combined report of the non-ERP unit according to the steps, then combining and calculating the calculation results of the two parts, namely, the first initial target financial combined report and the second initial target financial combined report, and generating final financial report data of the combined group, namely, a target financial combined report.
The pre-constructed merging model can be constructed based on a complex logic formula of the financial merging report, is compiled according to report coding, financial index coding and time dimension, is compiled according to accounting data model coding and dimension coding, and supports AND, OR logic and nested combination of a plurality of complex conditions. For example, the accounting data of which the accounting subjects are prepared for loan and loan loss, the plates are coal production, the contract number is loan, and the account age is less than-12 is obtained from the total record list data model, and when the merged model is constructed, the compiling and fetching conditions may be as follows:
if $ (M _ C11$ W _ ITEM, '1303 &, 1304 @') & & M _ C11$ BK = '01' & $. Inlist (M _ C11$ YEHTH, '040203,040204,040205') & $. Aage < -12, the numerical formula is formulated as M _ C11N _ TRN _ JT, where M _ C11 represents the total record inventory model, M _ C11$ W _ ITEM represents the accounting title, M _ C11W _ BK represents the slab, M _ C11$ YEHTH represents the contract number, M _ C11N _ TRN _ JT represents the period value in the group currency, "1303" represents the loan, "1304" represents the preparation loss, "01" represents the slab for coal production, "040203" represents the loan in one to three years (including three years), "represents the loan in three years" (including three years), "represents the loan in five years" (204 years) and "represents the loan in five years" 040 $ function, "040205 represents the loan between the five years" (i $ and "represents the five loan condition, and" is represented by two loan in $ functions 040 $ 205.
Compiling the multilevel complex dependency relationship of the financial merged report according to the report code; in the case where a plurality of report data are referred to, for example, an economic added value (EVA) calculation table, and data of an asset liability table, a profit table, and a debt situation table are referred to, the hierarchical relationships before YZB0102, before YZB0002, and before YZB0020 are specified in advance when the economic added value (EVA) calculation table definition is constructed. Where YZB0102 denotes a balance sheet, YZB0002 denotes a profit sheet, YZB0020 denotes a debt situation sheet, and before denotes the merging calculation of these reports.
And for the case of multi-level reference of report data, for example, the new energy subsidy statistical table refers to the two-fund pressure-controlled work statistical table data, and the two-fund pressure-controlled work statistical table refers to the data of the asset liability table, when the new energy subsidy statistical table is defined, a hierarchical relationship before is specified, namely YGL0023, wherein YGL0023 represents the two-fund pressure-controlled work statistical table, and before represents that the merging calculation of the two-fund pressure-controlled work statistical table is carried out in advance. When the definition of the two-fund pressure control work statistical table is constructed, a hierarchical relationship before is specified to YZB0102, wherein YZB0102 represents a balance sheet, and before represents that the combination calculation of the balance sheet is carried out in advance.
If the same control enterprise merging organization structure is subjected to the report retroactive adjustment, calculating according to the starting time and the ending time of the single company and the merging group in the merging architecture; for example, when a single company D1 transfers from the merge group a to the merge group B at time T0 and issues a balance sheet after time T0 of the merge group B, the accounting data and the statement data of the single company D1 participate in the merge calculation, and the beginning of year and the current year cumulative number of the balance sheet of the merge group B are adjusted. It can be understood that the access formula and the hierarchical relationship related to the merging model can be set according to actual requirements, for example, by combining the financial statement merging service, the logical access calculation rules scattered in each statement are comprehensively formulated, summarized, refined and integrated to construct the financial statement merging model; by pre-establishing the merging models of the financial statements of different categories, when the merging instruction of the financial statements of corresponding categories is received, calling the pre-established corresponding merging models to perform data acquisition and merging calculation, and the concrete formula of the merging mode is not limited in the application.
In order to further improve the efficiency of financial data merging, in the present application, the financial statement merging instruction includes a merging target time preset by a user, and determines whether the target merging group includes a plurality of target sub-merging groups having a hierarchical relationship, including: and acquiring the current time in real time, and judging whether the target merging group comprises a plurality of target sub-merging groups with hierarchical relationship or not under the condition that the current time is matched with the financial merging target time. The user can appoint the appointment time, the system judges whether the current time reaches the appointment time appointed by the user in real time, and when the current time reaches the appointment time appointed by the user, the issuing of the financial combination report and the checking of the report data are executed. When the system makes an appointment, the users make an appointment according to the report codes and the time points, each unit user can make an appointment for issuing the time of the financial merged report, the system automatically schedules the collection from the financial accounting system, merges and offsets in the BCS to generate the financial merged report according to the time reserved by the users, and the data of the financial merged report are verified. For example, the user command includes a001, balance sheet, 2022/01/15, which means that the user designates that the consolidation of accounting data of the balance sheet of the consolidated group a001 is performed on 1 month and 15 days 2022. In the application, the account period of the financial combination report is closed and opened, and the account period can be linked with a financial accounting system, an ERP system and a BCS system.
In order to further improve the efficiency of data merging and save the computing resources, the method of the present application further includes: determining the number of target subjects, and dividing the target subjects into at least one target subject set, wherein each target subject set at least comprises one target subject; determining corresponding computing nodes according to the number of the target subject sets, wherein the computing nodes comprise first computing nodes and second computing nodes, and the number of the first computing nodes corresponds to the number of the target subject sets one to one; merging the target financial index data of each target main body in the corresponding target main body set through a first computing node to generate a target financial merged sub-report, and merging the corresponding target financial index data in each target financial merged sub-report through a second computing node according to a preset hierarchical relation corresponding to the target merged group to generate a target financial merged report; or acquiring the target financial index data of each target main body in the corresponding target main body set through the first computing node, and combining the target financial index data of each target main body through the second computing node to generate a target financial combination report.
In order to further improve the data merging efficiency of the financial statements and save computing resources, the computing nodes of the application execute the merging task of the financial statements by adopting a distributed architecture. Through a distributed technology, for a financial statement to be subjected to data combination, different tasks are distributed to different computing nodes to execute corresponding computation according to split tasks such as units, time, data volume and the like, so that financial combination computing power can be expanded according to different elasticity of the task volume, and pressure on system performance caused by centralized financial monthly settlement time, centralized table refreshing of a large number of users and large financial combination computing amount is responded. For example, a plurality of units generate three previous month principal tables, namely an asset liability table, a profit table and a cash flow table, within a certain time period, some of the units have a superior-inferior relationship, for example, if the unit company y001, the unit company y002 and the unit company y003 are inferior units of the combined group a01, the combined report tasks of the units a01 and y001 all need to obtain the account data of the unit y001 from the ERP system, the combined report tasks of the units a01 and y002 all need to obtain the account data of the unit y002 from the ERP system, the combined report tasks of the units a01 and y003 all need to obtain the account data of the unit y003 from the ERP system, the system automatically divides the account data calculation of the units y001, y002 and y into 3 tasks according to allocate to different account calculation nodes, the calculation nodes one, the calculation node two and the calculation node three are respectively responsible for obtaining the previous month account data of the unit company y001, y002 and y003, and the configured account data, and then respectively obtain the combined result of the combined month balance table, the cash flow table, the combined result of the three previous month account tables, the profit table, the combined result of the unit company y001, the profit table and the combined account table. If the single company has a lot of accounting data exceeding a preset data volume threshold of the computing node, splitting the counting calculation into a plurality of tasks according to the total amount of the accounting data volume of the single company, so that the calculation amount of each task is approximately average, respectively counting from an ERP system on the plurality of computing nodes, calculating according to the counting calculation logic of the report forms, and then combining and calculating the calculation results of the computing nodes to obtain a combined result of the single company. The time for issuing the financial combination report forms at the end of the month of each unit of the financial affairs is concentrated in several days, the system performance pressure is large during the end of the month of the financial affairs, the calculation demand of other times is small, on the basis of distributed operation, the calculation server nodes are automatically added before the end of the month, the calculation capacity of the system is expanded, the financial combination stable operation of each unit during the end of the month is ensured, the calculation server nodes are automatically released after the end of the month, the server resources are recovered, and therefore the elastic expansion of the financial combination calculation capacity is achieved.
As shown in fig. 2, a second aspect of the present application provides a financial statement merging device, including:
the instruction receiving module is configured to receive a financial statement merging instruction of a user and acquire merging parameters corresponding to the financial statement merging instruction, wherein the merging parameters comprise a target merging group and a target financial statement category;
the data acquisition module is configured to judge whether the target merging group comprises a plurality of target sub-merging groups with hierarchical relationships, and determine target main bodies corresponding to the target sub-merging groups and target financial index data of the target financial statement types under the condition that the target merging group comprises the plurality of target sub-merging groups with hierarchical relationships;
and the data merging module is configured to acquire target financial index data corresponding to each target main body, merge the target financial index data of each target main body to generate a target financial merged sub-report, and merge the corresponding target financial index data in each target financial merged sub-report according to a preset hierarchical relationship corresponding to the target merged group to generate a target financial merged report.
In a third aspect, the present application provides a computer readable medium, in which a computer program is stored, and the computer program, when executed by a processor, implements the above-mentioned financial statement merging method.
As shown in fig. 3, a fourth aspect of the present application provides a terminal device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the financial statement merging method when executing the computer program.
Fig. 3 is a schematic diagram of a terminal device according to an embodiment of the present application. As shown in fig. 3, the terminal device 10 of this embodiment includes: a processor 100, a memory 101, and a computer program 102 stored in the memory 101 and executable on the processor 100. The steps in the above-described method embodiments are implemented when the processor 100 executes the computer program 102. Alternatively, the processor 100, when executing the computer program 102, implements the functions of the modules/units in the above-described device embodiments.
Illustratively, the computer program 102 may be partitioned into one or more modules/units, which are stored in the memory 101 and executed by the processor 100 to accomplish the present application. One or more of the modules/units may be a series of computer program instruction segments capable of performing specific functions, which are used to describe the execution of the computer program 102 in the terminal device 10. For example, the computer program 102 may be partitioned into an instruction receiving module, a data acquisition module, and a data merging module.
The terminal device 10 may be a computing device such as a desktop computer, a notebook, a palm computer, and a cloud server. Terminal device 10 may include, but is not limited to, a processor 100, a memory 101. Those skilled in the art will appreciate that fig. 3 is merely an example of the terminal device 10 and does not constitute a limitation of the terminal device 10 and may include more or less components than those shown, or combine certain components, or different components, e.g., the terminal device may also include input output devices, network access devices, buses, etc.
The Processor 100 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The storage 101 may be an internal storage unit of the terminal device 10, such as a hard disk or a memory of the terminal device 10. The memory 101 may also be an external storage device of the terminal device 10, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), or the like provided on the terminal device 10. Further, the memory 101 may also include both an internal storage unit of the terminal device 10 and an external storage device. The memory 101 is used to store computer programs and other programs and data required by the terminal device 10. The memory 101 may also be used to temporarily store data that has been output or is to be output.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-mentioned division of the functional units and modules is illustrated, and in practical applications, the above-mentioned function distribution may be performed by different functional units and modules according to needs, that is, the internal structure of the apparatus is divided into different functional units or modules, so as to perform all or part of the functions described above. Each functional unit and module in the embodiments may be integrated in one processing unit, or each unit may exist alone physically, or two or more units are integrated in one unit, and the integrated unit may be implemented in a form of hardware, or in a form of software functional unit. In addition, specific names of the functional units and modules are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present application. The specific working processes of the units and modules in the system may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In conclusion, the method and the device can improve efficiency and timeliness of financial statement merging, support combination calculation based on ERP account data, combination calculation based on financial statement data and combination of the two combination modes, support full-level financial statement merging of multiple sets of financial combination frameworks such as a property framework and a management framework, support automatic merging and automatic verification of reserved financial statements and elastic expansion of financial combination calculation capacity, effectively reduce labor cost of financial statement merging and shorten reporting period of financial statement merging.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising a … …" does not exclude the presence of another identical element in a process, method, article, or apparatus that comprises the element.
The above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A financial statement merging method is characterized by comprising the following steps:
receiving a financial statement merging instruction of a user, and acquiring a merging parameter corresponding to the financial statement merging instruction, wherein the merging parameter comprises a target merging group and a target financial statement category;
judging whether the target merging group comprises a plurality of target sub-merging groups with hierarchical relationship, and determining a target main body corresponding to each target sub-merging group and target financial index data of the target financial statement type under the condition that the target merging group comprises the plurality of target sub-merging groups with hierarchical relationship;
and acquiring target financial index data corresponding to each target main body, merging the target financial index data of each target main body to generate a target financial merged sub-report, and merging the corresponding target financial index data in each target financial merged sub-report according to a preset hierarchical relation corresponding to the target merged group to generate a target financial merged report.
2. The financial statement merging method according to claim 1, wherein the financial statement merging order includes a merging target time preset by a user, and the determining whether the target merged group includes a plurality of target child merged groups having a hierarchical relationship comprises:
and acquiring the current time in real time, and judging whether the target merging group comprises a plurality of target sub-merging groups with hierarchical relation or not under the condition that the current time is matched with the financial merging target time.
3. The financial statement merging method according to claim 1, further comprising:
determining a target main body corresponding to each target merging group and target financial index data of the target financial statement type under the condition that the target merging group does not comprise the target sub-merging group;
and acquiring target financial index data corresponding to each target main body, merging the target financial index data of each target main body, and generating a target financial merged statement.
4. The financial statement merger method according to claim 1, wherein said target child merger group comprises:
a first class target sub-merge-group and a second class target sub-merge-group;
the first category target sub-merge group comprises at least one first category target subject, and the second category target sub-merge group comprises at least one second category target subject.
5. The financial statement merging method according to claim 4, wherein obtaining target financial index data corresponding to each target subject includes:
and acquiring target financial index data corresponding to the first category target main body through a preset data model, and acquiring target financial index data corresponding to the second category target main body through a preset financial statement.
6. The financial statement merging method according to claim 4, wherein the step of obtaining target financial index data corresponding to each target subject, merging the target financial index data of each target subject to generate a target financial merged sub-statement, and merging the corresponding target financial index data in each target financial merged sub-statement according to a preset hierarchical relationship corresponding to the target merged group to generate a target financial merged statement comprises:
acquiring target financial index data corresponding to each first-class target main body, merging the target financial index data of all the first-class target main bodies to generate a first target financial merged sub-report, merging the corresponding target financial index data in each first target financial merged sub-report according to a preset hierarchical relation corresponding to the target merged group to generate a first initial target financial merged report;
acquiring target financial index data corresponding to each second type of target main body, merging the target financial index data of all the second type of target main bodies to generate a second target financial merged sub-report, merging the corresponding target financial index data in each second target financial merged sub-report according to a preset hierarchical relation corresponding to the target merged group to generate a second initial target financial merged report;
and combining the corresponding target financial index data in the first initial target financial merged report and the second initial target financial merged report to generate a target financial merged report.
7. A financial statement merging method according to any one of claims 1-6, characterized in that said method further includes:
determining the number of target subjects, and dividing the target subjects into at least one target subject set, wherein each target subject set at least comprises one target subject;
determining corresponding computing nodes according to the number of the target subject sets, wherein the computing nodes comprise first computing nodes and second computing nodes, and the number of the first computing nodes corresponds to the number of the target subject sets one to one;
merging the target financial index data of each target main body in the corresponding target main body set through the first computing node to generate a target financial merged sub-report, and merging the corresponding target financial index data in each target financial merged sub-report through the second computing node according to a preset hierarchical relation corresponding to the target merged group to generate a target financial merged report; or alternatively
And acquiring the target financial index data of each target main body in the corresponding target main body set through the first computing node, and combining the target financial index data of each target main body through the second computing node to generate a target financial combination report.
8. A financial statement merging device, comprising:
the instruction receiving module is configured to receive a financial statement merging instruction of a user and acquire merging parameters corresponding to the financial statement merging instruction, wherein the merging parameters comprise a target merging group and a target financial statement type;
the data acquisition module is configured to judge whether the target merging group comprises a plurality of target sub-merging groups with hierarchical relationships, and determine a target main body corresponding to each target sub-merging group and target financial index data of the target financial statement type under the condition that the target merging group comprises the plurality of target sub-merging groups with hierarchical relationships;
and the data merging module is configured to acquire target financial index data corresponding to each target main body, merge the target financial index data of each target main body to generate a target financial merging sub-report, and merge the corresponding target financial index data in each target financial merging sub-report according to a preset hierarchical relationship corresponding to the target merging group to generate a target financial merging report.
9. A computer-readable medium, in which a computer program is stored, which, when being executed by a processor, implements the financial statement merging method according to any one of claims 1 to 7.
10. A terminal device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the financial statement merging method according to any one of claims 1 to 7 when executing the computer program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211216153.0A CN115618825A (en) | 2022-09-30 | 2022-09-30 | Financial statement merging method and device, computer readable medium and terminal equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211216153.0A CN115618825A (en) | 2022-09-30 | 2022-09-30 | Financial statement merging method and device, computer readable medium and terminal equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115618825A true CN115618825A (en) | 2023-01-17 |
Family
ID=84861058
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211216153.0A Pending CN115618825A (en) | 2022-09-30 | 2022-09-30 | Financial statement merging method and device, computer readable medium and terminal equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115618825A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117371411A (en) * | 2023-10-25 | 2024-01-09 | 中亿丰控股集团有限公司 | Financial statement merging method, system, equipment and storage medium |
-
2022
- 2022-09-30 CN CN202211216153.0A patent/CN115618825A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117371411A (en) * | 2023-10-25 | 2024-01-09 | 中亿丰控股集团有限公司 | Financial statement merging method, system, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2022179008A1 (en) | Supply chain finance ai daas algorithm warehouse platform based on blockchain | |
| CN103426070B (en) | Compilation method and device of group combined financial statement | |
| CN110457294B (en) | Data processing method and device | |
| CN111104394A (en) | Energy data warehouse system construction method and device | |
| CN110046337B (en) | Financial data acquisition method and system | |
| CN102158373A (en) | Performance evaluation system of high-end server for intermediary business of bank | |
| CN110390607B (en) | Target cost measuring and calculating method and system based on subject index system and computer readable storage medium | |
| CN111400288A (en) | Data quality inspection method and system | |
| CN102929899A (en) | Distributed reporting system based on intermediate table | |
| CN105243582A (en) | Financial cloud based XBRL accounting software standard data interface system and method | |
| CN112651218A (en) | Automatic generation method and management method of bidding document, medium and computer | |
| CN111367939A (en) | System and method for compiling and managing highway engineering project account and computer | |
| CN111833018A (en) | Patent analysis method and system for science and technology project | |
| CN113361980A (en) | Big data asset value evaluation system and method | |
| CN115618825A (en) | Financial statement merging method and device, computer readable medium and terminal equipment | |
| CN110032594B (en) | Customizable data extraction method and device for multi-source database and storage medium | |
| CN110737673B (en) | Data processing method and system | |
| CN114511235A (en) | Process evaluation method and system | |
| RU105491U1 (en) | AUTOMATED SYSTEM OF ACCESS TO INFORMATION RESOURCES BASED ON THE UNIVERSAL BUDGET DATA CLASSIFIER | |
| CN111984677B (en) | Resource data checking method, device, computer equipment and storage medium | |
| CN111723004B (en) | Measurement method for agile software development, measurement data output method and device | |
| CN117273511A (en) | Data analysis method and device | |
| CN116820767A (en) | Cloud resource management method and device, electronic equipment and storage medium | |
| CN116611788A (en) | Science and technology project management method and system | |
| CN117036062A (en) | Accounting resource calculation method and device |
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 |