A report merging method, device and medium

Abstract

The present application discloses a method, device and medium for merging financial statements, and the method includes: obtaining the general ledger data of multiple companies to be merged within a preset period; obtaining the internal transaction data of the companies to be merged for the subjects from the general ledger data, reconciling the internal transaction data, and obtaining reconciliation data; obtaining the equity data of the companies to be merged for the subjects from the general ledger data; determining the offsetting company at the consolidation level where the companies to be merged are located; the offsetting company is a virtual company; in the offsetting company, based on the reconciliation data and the equity data, generating the offsetting voucher of the companies to be merged, generating the account balance of the offsetting company based on the offsetting voucher, adjustment items and single adjustment items, generating the offsetting report of the offsetting company based on the account balance; obtaining the single report of the companies to be merged, merging the offsetting report with the single report, and generating the consolidated report of multiple companies to be merged. By merging accounts, the report can be merged quickly and efficiently.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a report merging method, device and medium. Background Art

[0002] At present, in the field of financial informationization, the consolidation business generally uses computers to improve the simulation of financial business. Usually, the software for consolidating financial statements is basically developed based on the simulation of manual operations and the consolidation method. These systems use the data storage, calculation processing, query and other functions of the database language to solve the problems of irregularities and easy errors in manual operations, reduce the workload of compilers, improve work efficiency, and improve the quality of accounting information.

[0003] However, the consolidated products basically simulate manual operations and do not give full play to the automatic processing capabilities of computers. For example, a lot of data is manually input, and the offsetting data is compiled and adjusted, and there is a lot of duplication every month. In addition, in the consolidated mode, there must be at least three corresponding mapping relationships between financial accounts and report formats, report formats and report items, and report items and report offsetting entry indicators, which has caused great inconvenience to subsequent maintenance work and multi-system docking. In addition, large group companies currently have multiple internal information systems coexisting and report formats are not unified. If the software versions of the group headquarters system and the branch are inconsistent, if the report format items are corresponding, there are different names for the same thing in different industries, which leads to complex consolidated report submission and conversion processes.

[0004] To sum up, there is an urgent need for a fast, concise and efficient technical solution for report consolidation. Summary of the invention

[0005] The embodiments of the present application provide a report merging method, device and medium, which are used to solve the problem of urgently needing a fast, concise and efficient report merging technical solution.

[0006] The present application embodiment adopts the following technical solutions:

[0007] On the one hand, an embodiment of the present application provides a method for merging financial statements, the method comprising: obtaining general ledger data of multiple companies to be merged within a preset period; obtaining internal transaction data of the companies to be merged for subjects from the general ledger data, reconciling the internal transaction data to obtain reconciliation data; obtaining equity data of the companies to be merged for subjects from the general ledger data; the equity data includes long-term equity investment data and shareholding ratio data; determining an offsetting company at the consolidation level where the companies to be merged are located; the offsetting company is a virtual company; in the offsetting company, generating a virtual company report of the companies to be merged based on the reconciliation data and the equity data. The offsetting voucher of the company to be merged; when the company to be merged is a group company, determining the adjustment items of the company to be merged; and when the company to be merged is a branch company, determining the individual adjustment data of the company to be merged; the individual adjustment data includes the beginning adjustment data and the individual adjustment data without adjusting the account; in the offsetting company, according to the offsetting voucher, the adjustment items and the individual adjustment items, the account balance of the offsetting company is generated, and the offsetting report of the offsetting company is generated according to the account balance; the individual report of the company to be merged is obtained, the offset report is merged with the individual report, and the consolidated report of the multiple companies to be merged is generated.

[0008] In one example, the internal transaction data of the company to be merged for the account is obtained from the general ledger data, and the internal transaction data is reconciled to obtain the reconciliation data, which specifically includes: receiving a trigger request for internal transaction reconciliation, and determining the account data with an internal transaction mark in the general ledger data; generating the main project transaction data and the secondary project transaction data of the company to be merged in an automatic reconciliation interface based on the account data; the main project transaction data includes the internal transaction data between other companies to be merged and the company to be merged, and the secondary project transaction data includes the internal transaction data between the company to be merged and the other companies to be merged; the main project transaction data and the secondary project transaction data are matched and confirmed; it is determined whether there is unmatched internal transaction data, and if not, the matching internal transaction data is determined as reconciliation data; if so, the unmatched internal transaction data is processed according to preset rules.

[0009] In one example, the processing of the unmatched internal transaction data according to preset rules specifically includes: supplementing the unmatched internal transaction data; or carrying forward the unmatched internal transaction data; or modifying the data attribute of the unmatched internal transaction data from validity to invalidity, so as to mark the unmatched internal transaction data as invalid data.

[0010] In one example, before obtaining the general ledger data of multiple companies to be merged, the method also includes: determining standard first-level accounts, and adding first-level accounts of minority shareholders' equity, minority shareholders' profit and loss, and other net income attributable to minority shareholders to the standard first-level accounts to obtain updated first-level accounts; and generating the general ledger data of the companies to be merged based on the updated first-level accounts.

[0011] In one example, determining the offsetting company at the consolidation level where the company to be merged is located specifically includes: determining the consolidation level corresponding to the company to be merged; selecting a first company to be merged at the same level as the company to be merged, and a second company to be merged to which the first company to be merged is affiliated; wherein the consolidation level of the first company to be merged is higher than that of the second company to be merged; and generating an offsetting company for the first company to be merged and the second company to be merged.

[0012] In one example, after merging the offsetting report with the single report to generate a consolidated report for the multiple companies to be merged, the method also includes: based on a scheduled task, receiving a report merging request for the next period, and determining the newly added general ledger data for the next period; generating an updated offsetting voucher for the company to be merged based on the newly added general ledger data; when the company to be merged is a group company, determining the updated adjustment matters of the company to be merged; and when the company to be merged is a branch company, determining the updated single adjustment data of the company to be merged; in the offsetting company, generating an updated account balance of the offsetting company based on the updated offsetting voucher, the updated adjustment matters and the updated single adjustment matters, and generating an updated offset report of the offsetting company based on the updated account balance; obtaining an updated single report of the company to be merged, and merging the updated offset report with the updated single report to generate an updated consolidated report for the multiple companies to be merged.

[0013] In one example, the merging of the offsetting report with the individual report to generate the consolidated report of the multiple companies to be merged specifically includes: merging the offsetting report with the individual report to obtain the consolidated data of the group company; performing a draft analysis on the consolidated data to obtain a draft analysis table; the draft analysis table includes the report data of the group company and each branch company; converting the draft analysis table according to the report format of the group company to obtain the consolidated report of the group company; and converting the draft analysis table according to the report format of the branch company to obtain the consolidated report of the branch company.

[0014] In one example, after performing draft analysis on the merged data to obtain a draft analysis table, the method further includes: receiving a trigger request for analysis formula data through a cell of a corresponding company to be merged in the draft analysis table; identifying the corresponding company to be merged based on the position of the cell to call the joint account set data interface of the corresponding company to be merged.

[0015] On the other hand, an embodiment of the present application provides a report consolidation device, comprising: at least one processor; and a memory in communication with the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can: obtain general ledger data of multiple companies to be consolidated within a preset period; obtain internal transaction data of the company to be consolidated for the account from the general ledger data, reconcile the internal transaction data, and obtain reconciliation data; and obtain equity data of the company to be consolidated for the account from the general ledger data; the equity data includes long-term equity investment data and shareholding ratio data; determine the offsetting company at the consolidation level where the company to be consolidated is located; The offsetting company is a virtual company; in the offsetting company, an offsetting voucher of the company to be merged is generated based on the reconciliation data and the equity data; when the company to be merged is a group company, the adjustment items of the company to be merged are determined; and when the company to be merged is a branch company, the individual adjustment data of the company to be merged is determined; the individual adjustment data includes beginning adjustment data and individual adjustment data without adjusting accounts; in the offsetting company, the account balance of the offsetting company is generated based on the offsetting voucher, the adjustment items and the individual adjustment items, and the offsetting report of the offsetting company is generated based on the account balance; the individual report of the company to be merged is obtained, the offset report and the individual report are merged to generate a consolidated report of the multiple companies to be merged.

[0016] On the other hand, an embodiment of the present application provides a report merging non-volatile computer storage medium storing computer executable instructions, wherein the computer executable instructions are configured to: obtain general ledger data of multiple companies to be merged within a preset period; obtain internal transaction data of the companies to be merged for subjects from the general ledger data, reconcile the internal transaction data, and obtain reconciliation data; and obtain equity data of the companies to be merged for subjects from the general ledger data; the equity data includes long-term equity investment data and shareholding ratio data; determine the offsetting company at the merging level where the companies to be merged are located; the offsetting company is a virtual company; in the offsetting company, according to the reconciliation data and the equity data, generating an offsetting voucher for the company to be merged; when the company to be merged is a group company, determining the adjustment items of the company to be merged; and when the company to be merged is a branch company, determining the individual adjustment data of the company to be merged; the individual adjustment data includes the beginning adjustment data and the individual adjustment data without adjusting the account; in the offsetting company, generating the account balance of the offsetting company according to the offsetting voucher, the adjustment items and the individual adjustment items, and generating the offsetting report of the offsetting company according to the account balance; obtaining the individual report of the company to be merged, merging the offset report with the individual report, and generating a consolidated report of the multiple companies to be merged.

[0017] At least one of the above technical solutions adopted in the embodiments of the present application can achieve the following beneficial effects:

[0018] It is capable of merging reports based on the business model of account consolidation, generating corresponding offsetting companies for the companies to be merged, generating offsetting vouchers for the companies to be merged based on the reconciliation data and equity data, and then generating offsetting reports for the offsetting companies, quickly merging offsetting reports and individual reports, and realizing regular calculation of offsetting reports for newly added general ledger data within a preset period, without the need to calculate the offsetting reports of the previous period, thus reducing the workload of developers and enabling fast and efficient report merging. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the technical solution of the present application, some embodiments of the present application will be described in detail below in conjunction with the accompanying drawings, in which:

[0020] Figure 1 A flowchart of a report merging method provided in an embodiment of the present application;

[0021] Figure 2 A schematic diagram of a custom interface for internal transaction reconciliation provided in an embodiment of the present application;

[0022] Figure 3 A schematic diagram of automatic reconciliation of internal transactions provided in an embodiment of the present application;

[0023] Figure 4 A schematic diagram of an internal transaction pair confirmation matching provided in an embodiment of the present application;

[0024] Figure 5 A schematic diagram of an internal transaction pair confirmation mismatch provided in an embodiment of the present application;

[0025] Figure 6 A schematic diagram of an equity investment relationship definition provided in an embodiment of the present application;

[0026] Figure 7 A schematic diagram of internal transaction offset provided in an embodiment of the present application;

[0027] Figure 8 A schematic diagram of an internal transaction offset voucher provided in an embodiment of the present application;

[0028] Fig. 9 A schematic diagram of equity offset provided in an embodiment of the present application;

[0029] Fig.10 A schematic diagram of an equity offset certificate provided for an embodiment of the present application;

[0030] Fig.11 A schematic diagram of generating adjustment items provided in an embodiment of the present application;

[0031] Fig.12 A schematic diagram of a manuscript analysis table provided in an embodiment of the present application;

[0032] Fig.13 A schematic diagram of a joint query account set data interface provided in an embodiment of the present application;

[0033] Fig.14 A framework diagram of a report merging system provided in an embodiment of the present application;

[0034] Fig.15 A structural diagram of a report merging device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0035] In order to make the purpose, technical solution and advantages of the present application clearer, the technical solution of the present application will be clearly and completely described below in conjunction with specific embodiments and corresponding drawings. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without creative work are within the scope of protection of the present application.

[0036] Some embodiments of the present application are described in detail below with reference to the accompanying drawings.

[0037] Figure 1 A flow chart of a report merging method provided in an embodiment of the present application. The method can be applied to different business fields. Certain input parameters or intermediate results in the process allow manual intervention and adjustment to help improve accuracy.

[0038] The analysis method involved in the embodiments of the present application can be implemented by a terminal device or a server, and the present application does not impose any special restrictions on this. For the convenience of understanding and description, the following embodiments are described in detail by taking a server as an example.

[0039] It should be noted that the server may be a single device or a system consisting of multiple devices, that is, a distributed server, and this application does not make any specific limitation on this.

[0040] Figure 1 The process in may include the following steps:

[0041] S101: within a preset period, obtaining general ledger data of multiple companies to be merged.

[0042] The preset period may be set according to actual needs. For example, the preset period may be set on a monthly basis, that is, monthly settlement is performed on the consolidated financial statements of the companies to be merged.

[0043] It should be noted that the companies to be merged include the group company and all its branches. In the general ledger data, the internal transaction data is marked. The group company and the branch company are relative. The group company refers to the company with subordinate branches, and the branch company refers to the company that no longer has a subordinate relationship. For example, A, B, C, D, then B and C are the branches of A, D is the branch of B, then A is the group company of B, C, D, and B is the group company of D. In fact, in the entire company structure tree, A is the group headquarters.

[0044] In some embodiments of the present application, it is first necessary to determine the standard first-level accounts, and then add the first-level accounts of minority shareholders' equity, minority shareholders' profit and loss, and other net income attributable to minority shareholders to the standard first-level accounts to obtain updated first-level accounts, thereby generating the general ledger data of the company to be merged based on the updated first-level accounts.

[0045] That is, minority shareholders' profit and loss, minority shareholders' equity, and other comprehensive income attributable to minority shareholders require the creation of new first-level accounts specifically for consolidation.

[0046] S102: Acquire internal transaction data of the to-be-merged company for the account from the general ledger data, and reconcile the internal transaction data to obtain reconciliation data.

[0047] In some embodiments of the present application, a trigger request for internal transaction reconciliation is received, and account data with an internal transaction tag is determined in the general ledger data.

[0048] Then, based on the account data, the primary project transaction data and secondary project transaction data of the company to be merged are generated in the automatic reconciliation interface.

[0049] The main project transaction data includes the internal transaction data between other companies to be merged and the company to be merged, and the secondary project transaction data includes the internal transaction data between the company to be merged and other companies to be merged.

[0050] It should be noted that the principal party refers to the actual payee of the business, that is, the company to be merged is the actual payee of the business at this time, and the secondary party refers to the actual payee of the business, that is, the company to be merged is the actual payee of the business at this time.

[0051] Then, the transaction data of the primary project and the transaction data of the secondary project are matched and confirmed.

[0052] Then, it is determined whether there is any unmatched internal transaction data.

[0053] If not, the matching internal transaction data is determined as the reconciliation data. If yes, the unmatched internal transaction data is processed according to the preset rules.

[0054] Furthermore, the processing of the unmatched internal transaction data may include three types, namely, supplementing the unmatched internal transaction data, carrying forward the unmatched internal transaction data, and modifying the data attribute of the unmatched internal transaction data from validity to invalidity, so as to mark the unmatched internal transaction data as invalid data.

[0055] Among them, if there is too much internal transaction data or it is added manually incorrectly, and you do not want to cause data redundancy, you should delete the internal transaction data.

[0056] More intuitively, Figure 2 A schematic diagram of a custom interface for internal transaction reconciliation provided in an embodiment of the present application.

[0057] exist Figure 2 , you can customize the consolidation scope, annual period, transaction type, and own entity, etc.

[0058] Among them, the scope of consolidation: subject to user authority control, system default; annual period: select a specific reconciliation period (i.e., the current accounting period); transaction type: divided into three types of cash flow, internal transactions, and internal purchases and sales. Select the reconciliation business according to the first three transaction types in turn every month. Our unit: The relevant unit corresponding to the user selects the secondary party, that is, all the business that occurred in the current accounting period as the secondary transaction party, that is, all the business is confirmed by the secondary transaction party. The rest of the options can be kept by the system default. If the counterparty unit is not filled in, all internal transaction data related to the our unit will be displayed.

[0059] Figure 3 A schematic diagram of automatic reconciliation of internal transactions provided in an embodiment of the present application.

[0060] exist Figure 3 In the automatic reconciliation operation, check all the upper data and all the lower data, and then click the automatic reconciliation control. This method can solve most of the business data matching. If there is still business data, perform manual matching.

[0061] Among them, the upper part is the transaction data of the principal project, and the lower part is the transaction data of the secondary project. It should be noted that manual reconciliation refers to manually checking the reconciliation business data, and automatic reconciliation refers to automatic reconciliation according to the data of the upper unit and the counterparty unit and the amount being equal. Transferring to the previous period means transferring the selected internal transaction data to the previous period. Transferring to the next period means transferring the selected internal transaction data to the next period. Changing validity means setting the internal transaction data to invalid or valid. Exporting means exporting the internal transaction data to Excel.

[0062] Figure 4 A schematic diagram of an internal transaction pair confirmation matching provided in an embodiment of the present application. Figure 5 A schematic diagram of an internal transaction pair confirmation mismatch provided in an embodiment of the present application.

[0063] S103: Acquire equity data for items of the company to be merged from the general ledger data; the equity data includes long-term equity investment data and shareholding ratio data.

[0064] More intuitively, Figure 6 A schematic diagram of an equity investment relationship definition provided in an embodiment of the present application.

[0065] exist Figure 6In the , the equity dimension is the default dimension and does not need to be modified; Newly added means that a new investment company has participated in the merger in the current month. Select the investment unit, the invested unit, and click Add row; Change of shareholding ratio refers to the size of the equity ratio that has changed at one time. Current shareholding ratio refers to the current proportion of shares held. Change of investment amount refers to the amount of money invested at one time. Current investment amount refers to the current investment amount. Current holding amount means that it is equal to the investment amount in general. For whether to generate adjustment vouchers, select Yes in general.

[0066] S104: Determine the offset company at the merger level where the company to be merged is located; the offset company is a virtual company.

[0067] In some embodiments of the present application, the merger level corresponding to the company to be merged is first determined. Then, the first company to be merged whose merger level is at the same level and the second company to be merged to which the first company to be merged belongs are selected. Among them, the merger level of the first company to be merged is higher than that of the second company to be merged. Finally, an offset company is generated for the first company to be merged and the second company to be merged. For example, there are three companies A, B, and C, A is a group company, and B and C are branches of Company A. Therefore, offset companies are generated for A, B, and C.

[0068] In some embodiments of the present application, the company structure is arbitrarily reorganized and then merged according to business management needs or external needs such as listing. For example, Company B has branches D and E, and Company C has branches F and G. The industry of Company B is different from that of Company C. Therefore, due to specific business needs, when merging, Company B, Company D and Company F are merged to generate offsetting companies.

[0069] S105: In the offsetting company, an offsetting voucher of the company to be merged is generated according to the reconciliation data and the equity data.

[0070] In some embodiments of the present application, an internal transaction offset voucher is generated for the reconciliation data, and an equity offset voucher is generated for the equity data, so that an offset voucher is generated according to the internal transaction offset voucher and the equity offset voucher. That is, the offset data and equity offset data that have been matched in the internal transaction reconciliation are offset.

[0071] More intuitively, Figure 7 A schematic diagram of an internal transaction offset provided in an embodiment of the present application, that is, a schematic diagram of a voucher to be generated for internal transaction pair data, Figure 8 A schematic diagram of an internal transaction offset voucher provided in an embodiment of the present application.

[0072] exist Figure 7 In the case where the company to be merged is a group company, an internal transaction offset voucher is generated for the internal transaction offset of the group company. Figure 8 In Figure 7 Internal transaction offset voucher after offset.

[0073] Fig. 9 A schematic diagram of equity offset provided in an embodiment of the present application, Fig.10 A schematic diagram of an equity offset certificate provided for an embodiment of the present application.

[0074] exist Fig. 9 In the merger, the company to be merged is a group company, and the equity offset is carried out for the group company. Fig.10 In Fig. 9 Equity offset certificate after offset.

[0075] S106: When the company to be merged is a group company, determine the adjustment items of the company to be merged; and when the company to be merged is a branch company, determine the individual adjustment data of the company to be merged.

[0076] The entity adjustment data includes the beginning adjustment data and the entity adjustment data without adjusting the account. It should be noted that the balance sheet draft or other beginning data of the company to be merged should be entered into the offset company as the beginning data of the offset company.

[0077] More intuitively, Fig.11 A schematic diagram of generating adjustment items provided in an embodiment of the present application.

[0078] The user enters the offset data in the group adjustment offset interface and obtains Fig.11 .

[0079] S107: In the offsetting company, the account balance of the offsetting company is generated according to the offsetting voucher, the adjustment item and the single adjustment item, and the offsetting report of the offsetting company is generated according to the account balance.

[0080] Among them, when generating an offset report, the user selects the corresponding offset company on the system, calculates the corresponding working papers of the offset company in turn, enters the data at the beginning of the year of the balance sheet, and calculates the remaining data using formulas.

[0081] S108: Obtain the individual statements of the companies to be merged, merge the offset statements with the individual statements, and generate a merged statement of the multiple companies to be merged.

[0082] In some embodiments of the present application, the offset report and the individual report are merged to obtain the consolidated data of the group company. Then, the consolidated data is subjected to draft analysis to obtain a draft analysis table. The draft analysis table includes the report data of the group company and each branch company. According to the report format of the group company, the draft analysis table is converted to obtain the consolidated report of the group company; and according to the report format of the branch company, the draft analysis table is converted to obtain the consolidated report of the branch company.

[0083] Furthermore, a trigger request for analysis formula data is received through the cell of the corresponding company to be merged in the draft analysis table; then, the corresponding company to be merged is identified according to the position of the cell to call the joint inquiry account set data interface of the corresponding company to be merged.

[0084] More intuitively, Fig.12 A schematic diagram of a manuscript analysis table provided in an embodiment of the present application. Fig.13 A schematic diagram of a joint query account data interface provided in an embodiment of the present application.

[0085] exist Fig.12 , click Analyze Formula Data to enter Fig.13 interface.

[0086] In some embodiments of the present application, based on a scheduled task, a report merging request for the next period is received, and newly added general ledger data for the next period is determined.

[0087] Then, based on the newly added general ledger data, generate the updated offsetting voucher of the company to be merged. Then, when the company to be merged is a group company, determine the updated adjustment items of the company to be merged. And when the company to be merged is a branch company, determine the updated single adjustment data of the company to be merged. Then, in the offsetting company, based on the updated offsetting voucher, updated adjustment items and updated single adjustment items, generate the updated account balance of the offsetting company, and generate the updated offset report of the offsetting company based on the updated account balance.

[0088] Obtain updated individual reports of the companies to be merged, merge them with the updated individual reports according to the updated offset reports, generate updated consolidated reports of multiple companies to be merged, and update the consolidated reports according to the updated consolidated reports.

[0089] It should be noted that although the embodiments of the present application are based on Figure 1 Steps S101 to S108 are described in sequence, but this does not mean that steps S101 to S108 must be performed in a strict order. Figure 1The order shown in the figure is to introduce and explain step S101 to step S108 in sequence, in order to facilitate those skilled in the art to understand the technical solution of the embodiment of the present application. In other words, in the embodiment of the present application, the order between step S101 to step S108 can be appropriately adjusted according to actual needs.

[0090] In other words, it gets rid of the traditional ERP office software system's consolidation model's way of calculating business intermediate tables such as equity offsets; it removes the repeated mapping of accounts and items under the dual system of accounts and report items, and the inability to directly correspond to the format content upgrade and maintenance work; it facilitates different industries in listed companies, and different formats of reports to quickly reuse and analyze offset content data, with strong compatibility and expansibility. For example, one set of reports is issued for consolidation of different calibers, and one set of offsets is issued for consolidation of different report formats, and foreign currency reports are allowed to process data according to the situation.

[0091] pass Figure 1 The method can generate corresponding offsetting companies for the companies to be merged based on the business model of report consolidation by account consolidation, generate offsetting vouchers for the companies to be merged according to the reconciliation data and equity data, and then generate offsetting reports for the offsetting companies, quickly merge the offsetting reports and the individual reports, and realize the calculation of offsetting reports for the newly added general ledger data at regular intervals within the preset period, without the need to calculate the offsetting reports of the previous period, thus reducing the workload of developers and enabling fast and efficient report consolidation.

[0092] More intuitively, Fig.14 A framework diagram of a report merging system provided in an embodiment of the present application.

[0093] exist Fig.14 It includes the general ledger system, the reporting system, and basic data processing. Among them, the reporting system selects the general ledger data of each company (to be merged) from the general ledger system, and the basic data processing reads the report data in the general ledger data, and performs the following steps: 01 Reconciliation of internal transactions of each company. 02 Maintenance of equity information of the merged company. At this time, the merged company usually only refers to the company that maintains the equity investment relationship, generally only the group headquarters. 03 Each company generates offsetting vouchers. 04 The group adjustment items of the merged company are entered. 05 The individual adjustment items of each company are entered. 06 Each company generates offsetting company accounts and reports. 07 Each company records the bills normally. 8 Each company issues reports normally. 9 The merged company forms the offsetting company merger draft. 10 The merged company issues the merger draft data. 11 The merged company issues the final reports of each company.

[0094] Based on the same idea, some embodiments of the present application also provide devices and non-volatile computer storage media corresponding to the above methods.

[0095] Fig.15A structural diagram of a report merging device provided in an embodiment of the present application includes:

[0096] at least one processor; and,

[0097] a memory communicatively connected to the at least one processor; wherein,

[0098] The memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to:

[0099] Obtain general ledger data of multiple companies to be merged within a preset period;

[0100] Acquire the internal transaction data of the company to be merged for the account from the general ledger data, and reconcile the internal transaction data to obtain reconciliation data;

[0101] Obtaining equity data for items of the company to be merged from the general ledger data; the equity data includes long-term equity investment data and shareholding ratio data;

[0102] Determine the offset company at the consolidation level where the company to be consolidated is located; the offset company is a virtual company;

[0103] In the offsetting company, generating an offsetting voucher of the company to be merged based on the reconciliation data and the equity data;

[0104] When the company to be merged is a group company, determine the adjustment items of the company to be merged; and when the company to be merged is a branch company, determine the individual adjustment data of the company to be merged; the individual adjustment data includes the beginning adjustment data and the individual adjustment data without adjusting the account;

[0105] In the offsetting company, based on the offsetting voucher, the adjustment item and the single adjustment item, the account balance of the offsetting company is generated, and based on the account balance, an offsetting report of the offsetting company is generated;

[0106] The individual financial statements of the companies to be merged are obtained, and the offsetting financial statements are merged with the individual financial statements to generate the merged financial statements of the multiple companies to be merged.

[0107] Some embodiments of the present application provide a report-merging non-volatile computer storage medium storing computer executable instructions, wherein the computer executable instructions are configured to:

[0108] Obtain general ledger data of multiple companies to be merged within a preset period;

[0109] Acquire the internal transaction data of the company to be merged for the account from the general ledger data, and reconcile the internal transaction data to obtain reconciliation data;

[0110] Obtaining equity data for items of the company to be merged from the general ledger data; the equity data includes long-term equity investment data and shareholding ratio data;

[0111] Determine the offset company at the consolidation level where the company to be consolidated is located; the offset company is a virtual company;

[0112] In the offsetting company, generating an offsetting voucher of the company to be merged based on the reconciliation data and the equity data;

[0113] When the company to be merged is a group company, determine the adjustment items of the company to be merged; and when the company to be merged is a branch company, determine the individual adjustment data of the company to be merged; the individual adjustment data includes the beginning adjustment data and the individual adjustment data without adjusting the account;

[0114] In the offsetting company, based on the offsetting voucher, the adjustment item and the single adjustment item, the account balance of the offsetting company is generated, and based on the account balance, an offsetting report of the offsetting company is generated;

[0115] The individual financial statements of the companies to be merged are obtained, and the offsetting financial statements are merged with the individual financial statements to generate the merged financial statements of the multiple companies to be merged.

[0116] Each embodiment in this application is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device and medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiments.

[0117] The devices and media provided in the embodiments of the present application correspond one-to-one to the methods. Therefore, the devices and media also have similar beneficial technical effects as the corresponding methods. Since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media will not be repeated here.

[0118] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0119] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0120] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0121] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0122] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.

[0123] Memory may include non-permanent storage in a computer-readable medium, random access memory (RAM), and non-volatile memory in the form of read-only memory (ROM) or flash RAM. Memory is an example of a computer-readable medium.

[0124] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.

[0125] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0126] The above is only an embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the technical principle of the present application should all fall within the protection scope of the present application.

Claims

1. A report merging method, characterized in that: The method comprises: Obtain general ledger data of multiple companies to be merged within a preset period; Acquire the internal transaction data of the company to be merged for the account from the general ledger data, and reconcile the internal transaction data to obtain reconciliation data; Obtaining equity data for items of the company to be merged from the general ledger data; the equity data includes long-term equity investment data and shareholding ratio data; Determine the offset company at the consolidation level where the company to be consolidated is located; the offset company is a virtual company; In the offsetting company, generating an offsetting voucher of the company to be merged based on the reconciliation data and the equity data; When the company to be merged is a group company, determine the adjustment items of the company to be merged; and when the company to be merged is a branch company, determine the individual adjustment items of the company to be merged; the individual adjustment items include the beginning adjustment data and the individual adjustment data without adjusting the account; In the offsetting company, based on the offsetting voucher, the adjustment item and the single adjustment item, the account balance of the offsetting company is generated, and based on the account balance, an offsetting report of the offsetting company is generated; Obtaining the individual statements of the companies to be merged, merging the offset statements with the individual statements, and generating a consolidated statement of the multiple companies to be merged; The step of merging the offsetting report with the single report to generate a consolidated report of the multiple companies to be merged specifically includes: Merging the offset report with the individual report to obtain the consolidated data of the group company; Performing draft analysis on the consolidated data to obtain a draft analysis table; the draft analysis table includes report data of the group company and each branch company; According to the report format of the group company, the draft analysis table is converted to obtain the consolidated report of the group company; and according to the report format of the branch company, the draft analysis table is converted to obtain the consolidated report of the branch company.

2. The method according to claim 1, characterized in that The step of obtaining the internal transaction data of the company to be merged for the account from the general ledger data and reconciling the internal transaction data to obtain reconciliation data specifically includes: receiving a trigger request for internal transaction reconciliation, and determining account data with an internal transaction tag in the general ledger data; According to the subject data, the primary project transaction data and the secondary project transaction data of the company to be merged are generated in the automatic reconciliation interface; the primary project transaction data includes the internal transaction data between the company to be merged and other companies to be merged, and the secondary project transaction data includes the internal transaction data between the company to be merged and other companies to be merged; Performing matching confirmation on the primary project transaction data and the secondary project transaction data; Determine whether there is unmatched internal transaction data, and if not, determine the matched internal transaction data as reconciliation data; If so, the unmatched internal transaction data will be processed according to the preset rules.

3. The method according to claim 2, characterized in that The processing of the unmatched internal transaction data according to the preset rules specifically includes: Supplement the mismatched internal transaction data; or The period during which the unmatched internal transaction data is carried forward; or The data attribute of the unmatched internal transaction data is modified from validity to invalidity to mark the unmatched internal transaction data as invalid data.

4. The method according to claim 1, characterized in that: Before obtaining the general ledger data of the plurality of companies to be merged, the method further includes: Determine the standard first-level accounts, and add the first-level accounts of minority shareholders' equity, minority shareholders' profit and loss, and other net income attributable to minority shareholders to the standard first-level accounts to obtain updated first-level accounts; The general ledger data of the company to be merged is generated according to the updated primary accounts.

5. The method according to claim 1, characterized in that The determination of the offsetting company at the consolidation level of the company to be consolidated specifically includes: Determine the consolidation level corresponding to the company to be merged; Select a first company to be merged that is at the same level of merger level, and a second company to be merged to which the first company to be merged is affiliated; wherein the merger level of the first company to be merged is higher than that of the second company to be merged; An offsetting company is generated for the first company to be merged and the second company to be merged.

6. The method according to claim 1, characterized in that After merging the offset report with the single report to generate a combined report of the multiple companies to be merged, the method further includes: Based on the scheduled tasks, receive the report consolidation request for the next period and determine the new general ledger data for the next period; Generate an updated offset voucher for the company to be merged based on the newly added general ledger data; When the company to be merged is a group company, determine the update and adjustment items of the company to be merged; and when the company to be merged is a branch company, determine the update and adjustment items of the company to be merged; In the offsetting company, based on the updated offsetting voucher, the updated adjustment item and the updated single adjustment item, an updated account balance of the offsetting company is generated, and based on the updated account balance, an updated offsetting report of the offsetting company is generated; The updated individual statements of the companies to be merged are obtained, and the updated individual statements are merged with the updated offset statements to generate updated merged statements of the multiple companies to be merged.

7. The method according to claim 1, characterized in that After performing draft analysis on the merged data to obtain a draft analysis table, the method further includes: Receiving a trigger request for analysis formula data through a cell of a corresponding company to be merged in the draft analysis table; According to the position of the cell, the corresponding company to be merged is identified to call the joint inquiry account set data interface of the corresponding company to be merged.

8. A report merging device, characterized in that: include: at least one processor; as well as, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to: Obtain general ledger data of multiple companies to be merged within a preset period; Acquire the internal transaction data of the company to be merged for the account from the general ledger data, reconcile the internal transaction data, and obtain reconciliation data; and Obtaining equity data for items of the company to be merged from the general ledger data; the equity data includes long-term equity investment data and shareholding ratio data; Determine the offset company at the consolidation level where the company to be consolidated is located; the offset company is a virtual company; In the offsetting company, generating an offsetting voucher of the company to be merged based on the reconciliation data and the equity data; When the company to be merged is a group company, determine the adjustment items of the company to be merged; and when the company to be merged is a branch company, determine the individual adjustment items of the company to be merged; the individual adjustment items include the beginning adjustment data and the individual adjustment data without adjusting the account; In the offsetting company, based on the offsetting voucher, the adjustment item and the single adjustment item, the account balance of the offsetting company is generated, and based on the account balance, an offsetting report of the offsetting company is generated; Obtaining the individual statements of the companies to be merged, merging the offset statements with the individual statements, and generating a consolidated statement of the multiple companies to be merged; The step of merging the offsetting report with the single report to generate a consolidated report of the multiple companies to be merged specifically includes: Merging the offset report with the individual report to obtain the consolidated data of the group company; Performing draft analysis on the consolidated data to obtain a draft analysis table; the draft analysis table includes report data of the group company and each branch company; According to the report format of the group company, the draft analysis table is converted to obtain the consolidated report of the group company; and according to the report format of the branch company, the draft analysis table is converted to obtain the consolidated report of the branch company.

9. A report merging non-volatile computer storage medium storing computer executable instructions, characterized in that: The computer executable instructions are configured to: Obtain general ledger data of multiple companies to be merged within a preset period; Acquire the internal transaction data of the company to be merged for the account from the general ledger data, and reconcile the internal transaction data to obtain reconciliation data; as well as Obtaining equity data for items of the company to be merged from the general ledger data; the equity data includes long-term equity investment data and shareholding ratio data; Determine the offset company at the consolidation level where the company to be consolidated is located; the offset company is a virtual company; In the offsetting company, generating an offsetting voucher of the company to be merged based on the reconciliation data and the equity data; When the company to be merged is a group company, determine the adjustment items of the company to be merged; and when the company to be merged is a branch company, determine the individual adjustment items of the company to be merged; the individual adjustment items include the beginning adjustment data and the individual adjustment data without adjusting the account; In the offsetting company, based on the offsetting voucher, the adjustment item and the single adjustment item, the account balance of the offsetting company is generated, and based on the account balance, an offsetting report of the offsetting company is generated; Obtaining the individual statements of the companies to be merged, merging the offset statements with the individual statements, and generating a consolidated statement of the multiple companies to be merged; The step of merging the offsetting report with the single report to generate a consolidated report of the multiple companies to be merged specifically includes: Merging the offset report with the individual report to obtain the consolidated data of the group company; Performing draft analysis on the consolidated data to obtain a draft analysis table; the draft analysis table includes report data of the group company and each branch company; According to the report format of the group company, the draft analysis table is converted to obtain the consolidated report of the group company; and according to the report format of the branch company, the draft analysis table is converted to obtain the consolidated report of the branch company.

Images