Movatterモバイル変換


[0]ホーム

URL:


CN102567828A - Preparation method and device for consolidated report - Google Patents

Preparation method and device for consolidated report
Download PDF

Info

Publication number
CN102567828A
CN102567828ACN201010598871XACN201010598871ACN102567828ACN 102567828 ACN102567828 ACN 102567828ACN 201010598871X ACN201010598871X ACN 201010598871XACN 201010598871 ACN201010598871 ACN 201010598871ACN 102567828 ACN102567828 ACN 102567828A
Authority
CN
China
Prior art keywords
accounting
subject
data
group
consolidated accounts
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
Application number
CN201010598871XA
Other languages
Chinese (zh)
Inventor
万立
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Kingdee Software China Co Ltd
Original Assignee
Kingdee Software China Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Kingdee Software China Co LtdfiledCriticalKingdee Software China Co Ltd
Priority to CN201010598871XApriorityCriticalpatent/CN102567828A/en
Publication of CN102567828ApublicationCriticalpatent/CN102567828A/en
Pendinglegal-statusCriticalCurrent

Links

Images

Landscapes

Abstract

The embodiment of the invention provides a preparation method and a preparation device for a consolidated report, and aims to reduce the preparation difficulty of the consolidated report and improve the timeliness for issuing the consolidated report. The method comprises the following steps of: taking a group as an accounting main body, and generating an accounting certificate of the accounting main body; generating a subject balance sheet data table according to the accounting certificate of the group serving as the accounting main body, and storing the subject balance sheet data table; and generating the consolidated report of the group serving as the accounting main body according to the subject balance sheet data table. The accounting certificate of the group serving as the accounting main body is generated timely through an accounting affair, so that the consolidated report can be prepared more accurately; and the counteraction problem in the conventional consolidated report preparation method is solved, so that the report preparation difficulty is reduced. Furthermore, the consolidated report can be issued at any time, and is not limited by the submission time of a sub company, so that the timeliness for issuing and submitting the consolidated report is improved; and therefore, the working amount of financial staff is reduced, and the work efficiency is improved.

Description

A kind of preparation method of consolidated accounts and device
Technical field
The present invention relates to the financial software field, relate in particular to a kind of preparation method and device of consolidated accounts.
Background technology
Consolidated accounts is also referred to as consolidated financial statement or consolidated financial statements, and it is to stand on the whole group angle, after the accounting statement of subsidiary company under the group is gathered, offsets the connected transaction part and the report data that draws.In other words; Consolidated accounts is to form accounting subject with parent company and subsidiary company thereof; Be the basis with parent corporation with indivedual financial statements that its subsidiary company works out separately, merge the financial statement of financial position and management performance by the group behind the reflection counteracting group internal contact accounts of parent corporation's establishment.Consolidated accounts comprises consolidated balance sheet, consolidated income statement, the consolidated statement of cash flows or merges statement of change in financial position etc.
Existing a kind of consolidated accounts preparation method comprises the steps: 1) establishment individual statements, 2) fill and present worksheet, 3) adjust journal entry and elimination entry, 4) calculate merge the amount of money, 5) the list consolidated accounts.Above-mentioned existing consolidated accounts preparation method below is described by way of example.
Suppose to have under the A group B company and two tame subsidiary companies of C company, as capital assets, then the accounting processing of C company is following from 5000 yuan of C company commodities purchaseds in B company:
Borrow: accounts receivable-B company 5000
Borrow: main business income 5000;
Meanwhile:
Borrow: main business cost: 4000
Borrow: stock: 4000;
And the accounting processing of B company is following:
Borrow: capital assets 5000
Borrow: accounts payable-C company 5000;
Meanwhile, depreciation next month:
Borrow: managerial cost 50
Borrow: accumulated depreciation 50;
Based on the account record of above-mentioned B company and C company, existing consolidated accounts establishment comprises following 4 steps:
1, receives the individual statements of B company and C company;
2, the consolidated statement of establishment B company and C company;
3, establishment group merges elimination entry, and is as follows:
Borrow: accounts payable-B company 5000
Borrow: accounts receivable-C company 5000;
Borrow: main business income 5000
Borrow: main business cost 4000 is borrowed: capital assets 1000;
Borrow: accumulated depreciation 10
Borrow: managerial cost 10;
It should be noted that in above-mentioned establishment group to merge in the elimination entry process that owing to also will continue to propose depreciation next month, the entry that accumulated depreciation is offset needs to repeat every month establishment,, therefore, possibly need to continue several years even decades until discarding of fixed assets.
4,, calculate the consolidated accounts data according to elimination entry with adjust journal entry.
Can know from said process; Under existing consolidated accounts preparation method; The counteracting in consolidated accounts later stage and adjustment work are huge, because the form of each phase all can deferredly be increased in the counteracting and adjustment work with next issues of even tens phases, not only operation easier is high, workload is big; And need the financial staff to have higher professional level and unusual elaboration attitude, otherwise be easy to cause the inaccurate of report data; On the other hand, according to existing consolidated accounts preparation method, form ageing relatively poor often makes the time of providing of consolidated accounts delay tens days even the longer time.
Summary of the invention
The embodiment of the invention provides a kind of preparation method and device of consolidated accounts, to reduce the establishment difficulty of consolidated accounts, improves the promptness that consolidated accounts is provided.
The embodiment of the invention provides a kind of preparation method of consolidated accounts, comprising: be accounting subject with the group, generate the accounting voucher of said accounting subject;
According to said be the accounting voucher of accounting subject with the group, generate subject balance table tables of data and also preserve said subject balance table tables of data;
Generating with said group according to said subject balance table tables of data is the consolidated accounts of accounting subject.
The embodiment of the invention provides the scheduling apparatus of consolidated accounts, and said device comprises accounting voucher generation module, tables of data generation module and consolidated accounts generation module;
Said accounting voucher generation module, being used for the group is accounting subject, generates the accounting voucher of said accounting subject;
Said tables of data generation module, what be used for generating according to said accounting voucher generation module is the accounting voucher of accounting subject with the group, generates subject balance table tables of data and also preserves said subject balance table tables of data;
Said consolidated accounts generation module, it is the consolidated accounts of accounting subject that the subject balance table tables of data that is used for generating according to said tables of data generation module generates with said group.
Can know from the invention described above embodiment; Owing to be to be that accounting subject generates accounting voucher with the group; And according to being the accounting voucher of accounting subject with the group; The subject balance table tables of data that generates is preserved, and last, generating with said group according to these subject balance table tables of data is the consolidated accounts of accounting subject.Therefore; Compare with the preparation method of existing consolidated accounts, the present invention is the accounting voucher of accounting subject through in time generating with the group in the thing, can work out consolidated accounts more accurately; Solved the cancellation problem in the existing consolidated accounts preparation method, the establishment difficulty of form is reduced.In addition; Because the subject balance table tables of data that generates has in time preserved, and therefore, can provide consolidated accounts at any time; Needn't be subject to reporting and submitting the time of subsidiary company's form; Improved the promptness that consolidated accounts is provided and reported and submitted, the workload that these have all alleviated the financial staff has improved work efficiency.
Description of drawings
In order to be illustrated more clearly in the technical scheme of the embodiment of the invention; To do to introduce simply to the accompanying drawing of required use in prior art or the embodiment description below; Obviously, the accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills; Under the prerequisite of not paying creative work property, can also obtain other accompanying drawing like these accompanying drawings.
Fig. 1 is the preparation method schematic flow sheet of the consolidated accounts that provides of the embodiment of the invention;
Fig. 2 is the scheduling apparatus logical organization synoptic diagram of the consolidated accounts that provides of the embodiment of the invention;
Fig. 3 is the scheduling apparatus logical organization synoptic diagram of the consolidated accounts that provides of another embodiment of the present invention;
Fig. 4 is the scheduling apparatus logical organization synoptic diagram of the consolidated accounts that provides of another embodiment of the present invention;
Fig. 5 is the scheduling apparatus logical organization synoptic diagram of the consolidated accounts that provides of another embodiment of the present invention.
Embodiment
To combine the accompanying drawing in the embodiment of the invention below, the technical scheme in the embodiment of the invention is carried out clear, intactly description, obviously, described embodiment only is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills are not making the every other embodiment that is obtained under the creative work prerequisite, all belong to the scope of the present invention's protection.
Seeing also accompanying drawing 1, is the preparation method schematic flow sheet of the consolidated accounts that provides of the embodiment of the invention, mainly comprises step:
S101 is an accounting subject with the group, generates the accounting voucher of this accounting subject.
So-called accounting subject; Be meant specific unit or tissue that accounting information reflects, its standard the spatial dimension of accountancy, promptly; Accounting should be an object with each item transaction or the item that enterprise takes place, each item production and operating activities of record and reflection enterprise itself.Be that accounting subject is different with the subsidiary company under the group in the preparation method of existing consolidated accounts, in embodiments of the present invention, be to be accounting subject with the group, all accounting activities all are to be that accounting subject is carried out with this group.For example, it is the account book of accounting subject with this group that the accountant is provided with one, and what system received setting is the account book of accounting subject with said group.
Because group is that the accounting voucher of accounting subject is not to be the simple addition of the accounting voucher of accounting subject with subsidiary company under the group; And in modern times in the accounting activity; It is more frequent that the occasion or the scene of accounting voucher provided in requirement; In order to improve the formation efficiency of accounting voucher, in embodiments of the present invention, can be that the account book of accounting subject generates with said group with the group be the accounting voucher template of accounting subject according to what be provided with.So-called accounting voucher template is by the accounting subject account book template that each business paper generates voucher to be set, that is, document and business processing generate the foundation and the starting point of voucher.The voucher template is accomplished the description that voucher divides directory structures through specifying the corresponding relation between document item and the voucher field; Generate the process of voucher masterplate; It is exactly the Data Source of wanting clear and definite each key element of voucher; And essential of voucher is meant the key element that constitutes every entry, for example, and subject, summary, the amount of money and auxiliary Perform Project Financial Aanalysis etc.Be that can generate with said group according to this accounting voucher template be the accounting voucher of accounting subject after the accounting voucher template of accounting subject generated with the group.So, no matter be operation system or general ledger system, can come to provide automatically group's voucher according to the tissue identification that generates accounting voucher, and system provides the subject balance table that group is an accounting subject, write down subject balance month by month.
S102 according to being the accounting voucher of accounting subject with the group, generating subject balance table tables of data and preserves this subject balance table tables of data.
Beginning balance, current period debit amount, current period credit amount and ending balance or the like are the master datas that constitutes subject balance table tables of data, and subject balance table tables of data can generate according to the accounting voucher that with the group is accounting subject.Because need come to generate fast consolidated accounts according to group's balance sheet, therefore, system must keep and calculate the function of balance sheet.In embodiments of the present invention, can said subject balance table tables of data be stored in the database of local data base or other operation systems.
Need to prove; With respect to being the accounting voucher template of accounting subject generation with the subsidiary company group under in the preparation method of existing consolidated accounts; In embodiments of the present invention; With the group is that the accounting voucher template difference that accounting subject generates is: both accounting subjecies are different, ring fence is different and accounting method might be different, for example, and inventory costing methods etc.; With the group is that the accounting voucher template generation that accounting subject generates is the accounting voucher of accounting subject with said group; Reduced the process of offsetting and adjusting when making the later stage generate consolidated accounts, solved the cancellation problem in the existing consolidated accounts preparation method, the establishment difficulty of form is reduced.
S103, generating with said group according to said subject balance table tables of data is the consolidated accounts of accounting subject.
In embodiments of the present invention, can generate the consolidated accounts template according to subject balance table tables of data earlier, concrete grammar is; From before be stored in local data base or other operation system databases and obtain the subject balance in the subject balance table tables of data; For example, beginning balance, current period debit amount, current period credit amount and ending balance etc., then; According to formula acquisition parameters and the subject balance that obtains, generate said consolidated accounts template.So-called formula acquisition parameters, be the affirmation report form figure selection that in reporting system, is provided with the concrete time, during (comprise initial during and between tailend etc.), subject, currency, peek type and set of books configuration name or the like.And obtain the subject balance in the subject balance table tables of data; Can be to obtain through the formula of from the tables of data of other operation systems, peeking that in reporting system, is provided with; For example, in embodiments of the present invention, can be to obtain the subject balance in the subject balance table tables of data through the form function.At last, according to the consolidated accounts template that generates, generating with the group is the consolidated accounts of accounting subject.
Can know from the invention described above embodiment; Owing to be to be that accounting subject generates accounting voucher with the group; And according to being the accounting voucher of accounting subject with the group; The subject balance table tables of data that generates is preserved, and last, generating with said group according to these subject balance table tables of data is the consolidated accounts of accounting subject.Therefore; Compare with the preparation method of existing consolidated accounts, the present invention is the accounting voucher of accounting subject through in time generating with the group in the thing, can work out consolidated accounts more accurately; Solved the cancellation problem in the existing consolidated accounts preparation method, the establishment difficulty of form is reduced.In addition; Because the subject balance table tables of data that generates has in time preserved, and therefore, can provide consolidated accounts at any time; Needn't be subject to reporting and submitting the time of subsidiary company's form; Improved the promptness that consolidated accounts is provided and reported and submitted, the workload that these have all alleviated the financial staff has improved work efficiency.
Seeing also accompanying drawing 2, is the scheduling apparatus logical organization synoptic diagram of a kind of consolidated accounts of providing of the embodiment of the invention.For the ease of explanation, only show the part relevant with the embodiment of the invention.The practice test device of Fig. 2 example comprises accountingvoucher generation module 201, tables ofdata generation module 202 and consolidatedaccounts generation module 203, wherein:
Accountingvoucher generation module 201, being used for the group is accounting subject, generates the accounting voucher of said accounting subject;
Tables ofdata generation module 202, what be used for generating according to said accountingvoucher generation module 201 is the accounting voucher of accounting subject with the group, generates subject balance table tables of data and also preserves said subject balance table tables of data;
Consolidatedaccounts generation module 203, being used for generating with said group according to the subject balance table tables of data that said tables ofdata generation module 202 generates is the consolidated accounts of accounting subject.
The accountingvoucher generation module 201 of Fig. 2 example can comprise receiving element 301, accounting voucher template generation unit 302 and accounting voucher generation unit 303; The scheduling apparatus logical organization synoptic diagram of the consolidated accounts that another embodiment of the present invention provides shown in accompanying drawing 3, wherein:
Receiving element 301, what be used to receive setting is the account book of accounting subject with said group;
Accounting voucher template generation unit 302, being used for generating with said group according to the account book that said receiving element 301 receives is the accounting voucher template of accounting subject;
Accounting voucher generation unit 303 is used for the accounting voucher template according to said accounting voucher template generation unit 302 generations, and generating with said group is the accounting voucher of accounting subject.
Particularly, the tables ofdata generation module 202 of accompanying drawing 2 or accompanying drawing 3 examples is used for said subject balance table tables of data is stored in the database of local data base or other operation systems.
The consolidated accountsgeneration module 203 of accompanying drawing 2 or accompanying drawing 3 examples can comprise consolidated accountstemplate generation unit 401 and consolidated accountstemplate generation unit 402; The scheduling apparatus logical organization synoptic diagram of the consolidated accounts that another embodiment of the present invention provides shown in accompanying drawing 4, wherein:
Consolidated accountstemplate generation unit 401 is used for generating the consolidated accounts template according to said subject balance table tables of data;
Consolidatedaccounts generation unit 402 is used for the consolidated accounts template according to said consolidated accountstemplate generation unit 401 generations, and generating with said group is the consolidated accounts of accounting subject.
The consolidated accountstemplate generation unit 401 of accompanying drawing 4 examples may further include acquiringunit 501 andgeneration unit 502, the scheduling apparatus logical organization synoptic diagram of the consolidated accounts that another embodiment of the present invention provides shown in accompanying drawing 5, wherein:
Acquiringunit 501 is used for being stored in the subject balance that local data base or other operation system databases obtain said subject balance table tables of data from said;
Generation unit 502 is used for the subject balance that obtains according to formula acquisition parameters and said acquiringunit 501, generates said consolidated accounts template.
Need to prove; Contents such as the information interaction between each module/unit of said apparatus, implementation; Since with the inventive method embodiment based on same design; Its technique effect that brings is identical with the inventive method embodiment, and particular content can repeat no more referring to the narration among the inventive method embodiment here.
One of ordinary skill in the art will appreciate that all or part of step in the whole bag of tricks of the foregoing description is to instruct relevant hardware to accomplish through program; This program can be stored in the computer-readable recording medium; Storage medium can comprise: ROM (read-only memory) (ROM; Read Only Memory), RAS (RAM, Random Access Memory), disk or CD etc.
More than the preparation method and the device of a kind of consolidated accounts that the embodiment of the invention is provided carried out detailed introduction; Used concrete example among this paper principle of the present invention and embodiment are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that on embodiment and range of application, all can change, in sum, this description should not be construed as limitation of the present invention.

Claims (10)

CN201010598871XA2010-12-212010-12-21Preparation method and device for consolidated reportPendingCN102567828A (en)

Priority Applications (1)

Application NumberPriority DateFiling DateTitle
CN201010598871XACN102567828A (en)2010-12-212010-12-21Preparation method and device for consolidated report

Applications Claiming Priority (1)

Application NumberPriority DateFiling DateTitle
CN201010598871XACN102567828A (en)2010-12-212010-12-21Preparation method and device for consolidated report

Publications (1)

Publication NumberPublication Date
CN102567828Atrue CN102567828A (en)2012-07-11

Family

ID=46413195

Family Applications (1)

Application NumberTitlePriority DateFiling Date
CN201010598871XAPendingCN102567828A (en)2010-12-212010-12-21Preparation method and device for consolidated report

Country Status (1)

CountryLink
CN (1)CN102567828A (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN103426070A (en)*2013-08-192013-12-04远光软件股份有限公司Compilation method and device of group combined financial statement
CN103942634A (en)*2013-12-302014-07-23远光软件股份有限公司Group consolidated statement offset number data processing method and system
CN104021449A (en)*2014-06-192014-09-03北京工商大学Conglomerate report file merging method and device based on open platform system
CN105302785A (en)*2015-09-242016-02-03金蝶软件(中国)有限公司Data collection method and system
CN106844320A (en)*2016-12-272017-06-13税友软件集团股份有限公司A kind of financial statement integration method and equipment
CN112508671A (en)*2020-12-292021-03-16广州广电运通信息科技有限公司Enterprise financial data processing method, system, device and medium
WO2023056810A1 (en)*2021-10-092023-04-13周晓东Report merging method, intelligent terminal and storage medium
CN116361298A (en)*2023-05-302023-06-30物产中大数字科技有限公司Method and device for automatically acquiring SAP data to generate report form for EAS

Citations (2)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US20030043141A1 (en)*2001-09-062003-03-06Samsung Electronics Co., Ltd.System and method for digital video signal transmission
CN101561898A (en)*2009-03-022009-10-21浪潮集团山东通用软件有限公司Method for designing group financial combination system based on real-time account incorporation

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US20030043141A1 (en)*2001-09-062003-03-06Samsung Electronics Co., Ltd.System and method for digital video signal transmission
CN101561898A (en)*2009-03-022009-10-21浪潮集团山东通用软件有限公司Method for designing group financial combination system based on real-time account incorporation

Cited By (10)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN103426070A (en)*2013-08-192013-12-04远光软件股份有限公司Compilation method and device of group combined financial statement
CN103426070B (en)*2013-08-192017-01-11远光软件股份有限公司Compilation method and device of group combined financial statement
CN103942634A (en)*2013-12-302014-07-23远光软件股份有限公司Group consolidated statement offset number data processing method and system
CN104021449A (en)*2014-06-192014-09-03北京工商大学Conglomerate report file merging method and device based on open platform system
CN105302785A (en)*2015-09-242016-02-03金蝶软件(中国)有限公司Data collection method and system
CN106844320A (en)*2016-12-272017-06-13税友软件集团股份有限公司A kind of financial statement integration method and equipment
CN112508671A (en)*2020-12-292021-03-16广州广电运通信息科技有限公司Enterprise financial data processing method, system, device and medium
WO2023056810A1 (en)*2021-10-092023-04-13周晓东Report merging method, intelligent terminal and storage medium
CN116361298A (en)*2023-05-302023-06-30物产中大数字科技有限公司Method and device for automatically acquiring SAP data to generate report form for EAS
CN116361298B (en)*2023-05-302023-08-04物产中大数字科技有限公司Method and device for automatically acquiring SAP data to generate report form for EAS

Similar Documents

PublicationPublication DateTitle
CN102567828A (en)Preparation method and device for consolidated report
EdenMultinationals and foreign investment policies in a digital world
CN103426070B (en)Compilation method and device of group combined financial statement
CN106022902A (en)Accounting method and device
CN110147365A (en)The checking method of business datum and financial data, device, equipment and medium
CN101882266A (en)Account making system for medium and small enterprises
CN109829001A (en)For generating the method and device of invoice data
CN103903081A (en)Method and system for generating taxi receipt with the use of tax document data in ERP system
Kim et al.Dividend policy and corporate social responsibility: a comparative analysis of multinational enterprise subsidiaries and domestic firms in Korea
Shin et al.Impact of financialization and financial development on inequality: Panel cointegration results using OECD data
CN103903082A (en)Method for generating accounting documents by means of receipt data in ERP system
CN101706936A (en)Domestic and foreign ledger-combining processing method and processing system
CN111523298A (en)Generation method and device of accounting voucher
KR20150110463A (en)Systems and methods for providing computer-automated adjusting entries
SørensenTaxation and the optimal constraint on corporate debt finance: Why a comprehensive business income tax is suboptimal
Lavee et al.The effect of investment in transportation infrastructure on the debt-to-GDP ratio
Damayanthi et al.Loan restructuring as a banking solution in the COVID-19 pandemic: Based on contingency theory
Hobijn et al.Taking the pulse of the tech sector: A coincident index of high-tech activity
US20130332325A1 (en)Systems and methods for cash based accounting in a general ledger
EichengreenCoping with global volatility: editor’s introduction
CN105320774B (en)Data table creating and data query method
Trott et al.Adjusting the Australian Labour Share for Depreciation, Housing and Other Factors, 1960–2016
JP7409984B2 (en) Business support devices, business support methods, and business support programs
CN101650803A (en)Method and device for adding budget completed information and budget control system
CN104102948A (en)Six-dimensional metering method for account balance

Legal Events

DateCodeTitleDescription
C06Publication
PB01Publication
C10Entry into substantive examination
SE01Entry into force of request for substantive examination
C12Rejection of a patent application after its publication
RJ01Rejection of invention patent application after publication

Application publication date:20120711


[8]ページ先頭

©2009-2025 Movatter.jp