CN107679026A - A kind of method of self-defined accounting statement - Google Patents
A kind of method of self-defined accounting statement Download PDFInfo
- Publication number
- CN107679026A CN107679026A CN201710901278.XA CN201710901278A CN107679026A CN 107679026 A CN107679026 A CN 107679026A CN 201710901278 A CN201710901278 A CN 201710901278A CN 107679026 A CN107679026 A CN 107679026A
- Authority
- CN
- China
- Prior art keywords
- template
- subject
- accounting statement
- accounting
- self
- 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
- 238000000034 method Methods 0.000 title claims abstract description 17
- 230000008676 import Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 239000002699 waste material Substances 0.000 description 2
- PEDCQBHIVMGVHV-UHFFFAOYSA-N Glycerine Chemical compound OCC(O)CO PEDCQBHIVMGVHV-UHFFFAOYSA-N 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 239000010931 gold Substances 0.000 description 1
- 229910052737 gold Inorganic materials 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000000149 penetrating effect Effects 0.000 description 1
- 238000004321 preservation Methods 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 238000009738 saturating Methods 0.000 description 1
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/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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Accounting & Taxation (AREA)
- Health & Medical Sciences (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)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of method of self-defined accounting statement, main to include defining report form template, generation 2 steps of accounting statement, specific steps include：101st, report form template is defined；102nd, accounting statement is generated；A template is selected in report form template list, then selection will check the days of form, click " button ", generate accounting statement automatically according to the set content of template and be shown in form.Compared with prior art, the present invention passes through the definition to report form template, the tailor-made form according to user's request can be realized, and user can be with flexibly customizing to report column, language and form, meet many-sided demand of user, improve the application and efficiency of computer generation accounting statement.
Description
Technical field
The present invention relates to accounting voucher in the technical field of daily management, more particularly to a kind of routine work management of enterprise
Generation method.
Background technology
During the financial management of enterprise, at every the end of month, the end of month profit and loss is carried down as current year profit；And to year
End, current year profit is carried down as profit distribution, generates corresponding transfer voucher.However, current transfer voucher substantially needs
Manual manufacture is taken, it is necessary to which the account of the whole moon or season or year are collected, then makes corresponding authority of transferring accounts, is had a large amount of
Statistical work, waste time and energy, efficiency is low, and can consume substantial amounts of paper, causes the waste of resource.
Patent application 201410513392.1 discloses a kind of processing method of accounting statement, is following steps：(1) data
Analytical procedure：By data analysis module, analyze data has inerrancy in terms of computing, in terms of form；(2) data import step
Suddenly：Module is automatically imported by a data, data are automatically imported into the text to be made；(3) data processing step：It is logical
A data processing module is crossed, data are subjected to automatic editing；(4) data sharing step：Start software by shared, data are entered
It is automatic shared in row LAN；(5) data automatically save step：Module is automatically saved by data, form is carried out automatic
Preserve；(6) data start fire wall step：Pass through data security protecting module, automatic start data protection fire wall.
Generated however, this method is the accounting statement for being directed to set form, the template of accounting statement can not be changed,
In actual application, many enterprises need to be adjusted accounting statement for the actual conditions of oneself, change or increase, delete
Corresponding subject, and aforesaid way is only capable of analyzing and importing data, it is impossible to meet individual demand and the accounting of many enterprises
It is required that.
The content of the invention
For weak point present in above-mentioned technology, primary and foremost purpose of the invention is to provide a kind of self-defined accounting statement
Method, this method with flexibly customizing, can meet many-sided demand of user to report column, language and form, carry
The high application and efficiency of computer generation accounting statement.
To achieve the above object, the present invention provides a kind of method of self-defined accounting statement, and this method is soft by computer
Part is realized, is automatically performed the generation of accounting statement, main to include defining report form template, generation accounting statement 2 steps, specifically
Step is as follows：
101st, report form template is defined first.
Specifically, report form template includes balance sheet template and statement of assets losses and gains template, sets asset-liabilities respectively
Table template and statement of assets losses and gains template, report form template are 3 and penetrate the form that mode associates, and are template, subject description respectively, converge
Total subject is detailed.
Further, following field is mainly included in the template table：Template ID, template name.
Further, subject, which describes table, mainly includes following field：Subject describes ID, template ID, subject description, line number, standby
Note.It can represent that null number n, SU below the row represent single underscore with definition cell form, such as digital n in remarks
(Single Underline), DU represent double underline (Double Underline).
Further, collecting subject detail list mainly includes following field：Collect subject detail ID, subject describes ID, accounting
Subject ID, whether add.If choosing " adding " represents that the amount of money of this accounting item uses addition, otherwise using subtraction.
102nd, accounting statement is generated.A template is first selected in report form template list, then selection will check form
Days, click " button ", automatically according to template set content generate accounting statement simultaneously be shown in form.Gold per a line
Volume is drawn by collecting the subject detail amount of money according to whether choosing " adding " (choosing using addition, do not choose using subtraction) and collecting.
For balance sheet template, it is that 3 of a master-slave mode penetrate mode association table, is followed successively by from main to secondary
Template, subject description, collect subject detail.Can manual typing, can also set and import in Excel in advance, then
Preservation.
After selecting template, selection will inquire about the days of form, click " inquiry " button, system is retouched according to the subject in form
That states association collects subject detail, calculates these section's purpose amount of money of cut-off days and then collects and fill in corresponding unit lattice.
The beneficial effects of the invention are as follows：Compared with prior art, the present invention passes through the definition to report form template, it is possible to achieve
According to the tailor-made form of user's request, and user can meet to use to report column, language and form with flexibly customizing
Many-sided demand at family, improve the application and efficiency of computer generation accounting statement.
Brief description of the drawings
Fig. 1 is the control flow chart that the present invention is realized.
Fig. 2 is that the present invention realizes the schematic diagram for setting balance sheet template.
Fig. 3 is the schematic diagram that the present invention realizes generation balance sheet.
Embodiment
In order to more clearly state the present invention, the present invention is further described below in conjunction with the accompanying drawings.
A kind of referring to Fig. 1, method for self-defined accounting statement that the present invention is realized.The benefit of self-defined accounting statement
It is that report column, language and form can be with flexibly customizings.It mainly includes defining 2 report form template, generation accounting statement steps
Suddenly.
(1) report form template is defined first.It is 3 to set balance sheet template and balance sheet template, report form template respectively
The individual form for penetrating mode and associating, it is template, subject description respectively, collects subject detail.
Template table mainly includes following field：Template ID, template name.
Subject, which describes table, mainly includes following field：Subject describes ID, template ID, subject description, line number, remarks.Remarks
In can be with definition cell form, for example digital n represent that null number n, SU below the row represent single underscore (Single
Underline), DU represents double underline (Double Underline).
Collecting subject detail list mainly includes following field：Collect subject detail ID, subject describes ID, accounting item ID,
Whether plus.If choosing " adding " represents that the amount of money of this accounting item uses addition, otherwise using subtraction.
(2) next accounting statement is generated.A template is first selected in report form template list, then selection will be checked
On the days of form, click " button ", system generates accounting statement automatically according to the set content of template and is shown in form.Often
The amount of money of a line is collected by collecting the subject detail amount of money according to whether choosing " adding " (choosing using addition, do not choose using subtraction)
Draw.
The method for introducing self-defined accounting statement by taking balance sheet as an example below.
1. balance sheet template is set
As shown in Fig. 2 this is the user interface of a setting balance sheet template, it is that 3 of a master-slave mode wear
Saturating mode association table, it is followed successively by template, subject description to secondary from main, collects subject detail.Can manual typing, can also be pre-
First set and import in Excel, then preserve.
2. generate balance sheet
As shown in figure 3, this is the user interface of a generation balance sheet.First have to select template, then selection will
The days of form are inquired about, click " inquiry " button, system collects subject detail according to what the subject in form described to associate, calculated
Cut-off days then these section's purpose amount of money collect and filled in corresponding unit lattice.
Compared with prior art, the present invention passes through the definition to report form template, it is possible to achieve according to the tailor-made of user's request
Form, and user with flexibly customizing, can meet many-sided demand of user to report column, language and form, carry
The high application and efficiency of computer generation accounting statement.
Disclosed above is only several specific embodiments of the present invention, but the present invention is not limited to this, any ability
What the technical staff in domain can think change should all fall into protection scope of the present invention.
Claims (6)
1. a kind of method of self-defined accounting statement, main to include defining report form template, generation 2 steps of accounting statement, specifically
Step is as follows：
101st, report form template is defined；
102nd, accounting statement is generated；A template is selected in report form template list, then selection will be checked the days of form, single
" button " is hit, accounting statement is generated automatically according to the set content of template and is shown in form.
2. the method for self-defined accounting statement according to claim 1, it is characterised in that in the step 101, form mould
Plate includes balance sheet template and statement of assets losses and gains template, sets balance sheet template and statement of assets losses and gains template respectively,
Report form template is 3 and penetrates the form that mode associates, and is template, subject description respectively, collects subject detail.
3. the method for self-defined accounting statement according to claim 2, it is characterised in that in the step 101, the mould
Mainly include following field in plate table：Template ID, template name.
4. the method for self-defined accounting statement according to claim 3, it is characterised in that subject, which describes table, mainly to be included such as
Lower field：Subject describes ID, template ID, subject description, line number, remarks；Can be with definition cell form, digital n tables in remarks
Show that null number n, SU below the row represent single underscore (SingleUnderline), DU represents double underline
(DoubleUnderline)。
5. the method for self-defined accounting statement according to claim 4, it is characterised in that collect subject detail list and mainly wrap
Include following field：Collect subject detail ID, subject describes ID, accounting item ID, whether plus；If choosing " adding " represents this accounting
Section's purpose amount of money uses addition, otherwise using subtraction.
6. the method for self-defined accounting statement according to claim 5, it is characterised in that for balance sheet template, it
It is that 3 of a master-slave mode penetrate mode association table, is followed successively by template, subject description to secondary from main, collects subject detail；Choosing
After selecting template, selection will inquire about the days of form, click " inquiry " button, and system describes the remittance of association according to the subject in form
Total subject is detailed, calculates these section's purpose amount of money of cut-off days and then collects and fill in corresponding unit lattice.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710901278.XA CN107679026A (en) | 2017-09-28 | 2017-09-28 | A kind of method of self-defined accounting statement |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710901278.XA CN107679026A (en) | 2017-09-28 | 2017-09-28 | A kind of method of self-defined accounting statement |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107679026A true CN107679026A (en) | 2018-02-09 |
Family
ID=61138513
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710901278.XA Pending CN107679026A (en) | 2017-09-28 | 2017-09-28 | A kind of method of self-defined accounting statement |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107679026A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109272223A (en) * | 2018-09-06 | 2019-01-25 | 广州微印信息科技有限公司 | One kind being based on section's purpose task cooperative system and method |
| CN109711960A (en) * | 2018-12-28 | 2019-05-03 | 北京爱康鼎科技有限公司 | It declares dutiable goods method and system |
| CN109918631A (en) * | 2019-02-24 | 2019-06-21 | 辽宁工程技术大学 | A kind of rapid generation of accounting statement |
| CN111105300A (en) * | 2019-12-23 | 2020-05-05 | 张仁义 | Complete accounting system based on double-straight-method parallelism |
| CN112348652A (en) * | 2020-11-30 | 2021-02-09 | 四川长虹电器股份有限公司 | Enterprise financial statement generation system based on original certificate data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101882266A (en) * | 2010-06-22 | 2010-11-10 | 方志忠 | Account making system for medium-sized and small enterprises |
| CN103440557A (en) * | 2013-08-19 | 2013-12-11 | 远光软件股份有限公司 | Generation method and system for group consolidated accounts and consolidated statements |
| CN103942633A (en) * | 2013-12-26 | 2014-07-23 | 远光软件股份有限公司 | Audit result data presentation and data penetrating system and method |
-
2017
- 2017-09-28 CN CN201710901278.XA patent/CN107679026A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101882266A (en) * | 2010-06-22 | 2010-11-10 | 方志忠 | Account making system for medium-sized and small enterprises |
| CN103440557A (en) * | 2013-08-19 | 2013-12-11 | 远光软件股份有限公司 | Generation method and system for group consolidated accounts and consolidated statements |
| CN103942633A (en) * | 2013-12-26 | 2014-07-23 | 远光软件股份有限公司 | Audit result data presentation and data penetrating system and method |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109272223A (en) * | 2018-09-06 | 2019-01-25 | 广州微印信息科技有限公司 | One kind being based on section's purpose task cooperative system and method |
| CN109711960A (en) * | 2018-12-28 | 2019-05-03 | 北京爱康鼎科技有限公司 | It declares dutiable goods method and system |
| CN109918631A (en) * | 2019-02-24 | 2019-06-21 | 辽宁工程技术大学 | A kind of rapid generation of accounting statement |
| CN111105300A (en) * | 2019-12-23 | 2020-05-05 | 张仁义 | Complete accounting system based on double-straight-method parallelism |
| CN112348652A (en) * | 2020-11-30 | 2021-02-09 | 四川长虹电器股份有限公司 | Enterprise financial statement generation system based on original certificate data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107679026A (en) | A kind of method of self-defined accounting statement | |
| CN110909226A (en) | Financial document information processing method and device, electronic equipment and storage medium | |
| US20080126465A1 (en) | Calendar-based Financial Calculator | |
| CN101976394B (en) | Data acquiring and counting system and method | |
| CN102208064A (en) | Administrative collaborative approval system and approval method | |
| CN101706903A (en) | Method for quickly generating tax account voucher | |
| CN106649232A (en) | Method for automatically converting financial data into data capable of being understood by non-financial staff | |
| CN109408788A (en) | A kind of text marking method towards judgement document | |
| CN107392560A (en) | A kind of Excel list datas issue acquisition method and system based on internet | |
| CN202433952U (en) | General network reporting system | |
| Goriely | Nucleosynthesis by accelerated particles to account for the surface composition of HD 101065 | |
| Marzuki et al. | The Influence of Intelectual Capital and Islamicity Performance Index on Financial Performance in Sharia Banking in Indonesia | |
| CN116611947A (en) | Financial management audit system based on big data analysis | |
| Scott et al. | The adaptive value of energy efficiency programs in a warmer world | |
| CN106682979A (en) | Universal individual income tax detail acquisition declaration tool | |
| Cirujano et al. | Automatic reporting for manpower resources | |
| CN107644373A (en) | It is a kind of to automatically process the method that the accounting end of term carries down | |
| CN111783411A (en) | Report automatic generation system and method based on scheduling synchronization line loss | |
| Kim et al. | Introduction of the STPA mechanism to derivation of risk scenarios for establishment of disaster reduction activity plans | |
| CN206178965U (en) | A information -based management system for power communication | |
| Cho | A study on the improvement of the K-move policy through the current situation of professional education in Australia | |
| CN201974846U (en) | Data collecting and counting system | |
| Salmiah et al. | Accounting System Design for Riau Province Sports Assets: Measuring rent system and Environment | |
| CN116738944A (en) | Comprehensive budget planning system | |
| Kim et al. | An Analysis of Impact of Urbanization on Income Inequality in Korea: Considering Serial Correlations, Spatial Dependence and Common Factor Effect |
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 | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1247367 Country of ref document: HK |
|
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180209 |
|
| RJ01 | Rejection of invention patent application after publication | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: WD Ref document number: 1247367 Country of ref document: HK |