CN105786785A - User-defined financial statement collection method - Google Patents
User-defined financial statement collection method Download PDFInfo
- Publication number
- CN105786785A CN105786785A CN201610110330.5A CN201610110330A CN105786785A CN 105786785 A CN105786785 A CN 105786785A CN 201610110330 A CN201610110330 A CN 201610110330A CN 105786785 A CN105786785 A CN 105786785A
- Authority
- CN
- China
- Prior art keywords
- data
- declaration form
- financial statement
- interface
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 16
- 238000012795 verification Methods 0.000 claims description 8
- 238000012423 maintenance Methods 0.000 abstract description 5
- 238000011161 development Methods 0.000 abstract description 4
- 238000013461 design Methods 0.000 description 2
- 230000000717 retained effect Effects 0.000 description 1
- 230000029305 taxis Effects 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/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/123—Tax preparation or submission
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Development Economics (AREA)
- Artificial Intelligence (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a user-defined financial statement collection method, which comprises the following steps: 1) preparing a table sample; 2) releasing a report; 3) filling a statement; 4) automatically calculating and verifying the relation between tables; 5) saving the statement; 6) auditing a statement; 7) submitting a reporting form; 8) and checking the receipt. Compared with the prior art, the user-defined financial statement collection method can be directly submitted to a tax department through the Internet, development is not needed again, maintenance time is saved, and development and maintenance cost is greatly reduced; the method has the advantages of automatic calculation of interface cells, automatic logic judgment, automatic acquisition of data among tables, safety, flexibility, simplicity and easy use.
Description
Technical field
The present invention relates to field of computer technology, specifically a kind of self-defined financial statement acquisition method.
Background technology
Financial statement is the data message that taxpayer provides to bureau of local taxation, is the national significant data foundation judging income level, and Ye Shi enterprise needs the key data retained.All kinds of financial statements, conventional has: small enterprise's accounting standard financial statement, general enterprises financial statement, Institution Accounting System, finance class financial statement (insurance), finance class financial statement (banking), finance class financial statement (securities business) etc., financial statement kind can be increased by self-defined mode；The contents such as the balance sheet that relates in every class form, profit flow table, owner's equity table.
Before, enterprise takes in and information of paying taxes mainly through Excel or LAN-ignorant program record employee, and adopts papery or electronic edition document to be supplied to revenue department；Part declares software with what have a financial statement, runs into form upgrading every time or needs to increase new form, is required for carrying out program upgrading, too development and maintenance workload big, and cost is high.
Summary of the invention
The technical assignment of the present invention is to provide a kind of self-defined financial statement acquisition method.
The technical assignment of the present invention realizes in the following manner, and the method step is as follows:
Step 1) makes table sample: make the required financial statement table sample template added by excel；
Step 2) issue form: by excel Template Information, storage is in database table；
Step 3) fills in declaration form: according to taxpayer's authority of approval limit information, it is determined that needs the declaration form kind filled in, shows and fill in declaration form, it is possible to being imported by template；
Between step 4) Biao Neibiao, relation automatically calculates and verifies: relation information between the Biao Neibiao of reading database storage when interface loads, in table, relation is realized by js, is realized by backstage java program between table；
Step 5) declaration form preserves: the declaration form after filling in is preserved, and the data preserved before are edited after again logging in by user, and declaration form data can not be revised after submitting to；When preserving data, data are stored in the data base of the Internet end by the Internet；
Step 6) declaration form is audited: data are submitted to front user's data to filling in carry out examination & verification and checked, if you have questions, come back for amendment；
Step 7) submits declaration form to: the errorless list of examination & verification is carried out submission and declares；
Step 8) checks receipt: interface acknowledgement information is shown to interface after submitting to by data.
Described step 2) in excel Template Information include: gauge outfit, content, pattern and computing formula.
Described step 7) is submitted to and declares by calling web Service interface or the realization of EJB interface.
The self-defined financial statement acquisition method of one of the present invention is compared to the prior art, it is possible to be submitted to revenue department either directly through the Internet, it is not necessary to exploitation again, saving maintenance time, greatly reduces development and maintenance cost；The method boundary element lattice calculate automatically, logic automatic decision, and between table, data obtain automatically, and instrument safety is flexible, easy to use.
Detailed description of the invention
Embodiment 1:
This self-defined financial statement acquisition method step is as follows:
Step 1) makes table sample: make the required financial statement table sample template added by excel；
Step 2) issue form: by excel Template Information, including: gauge outfit, content, pattern and computing formula；Storage is in database table；
Above-mentioned two step adopt ApachePOI realize excel information reading and write, POI Frame Design implementation:
First have to an object and represent this whole Excel file；Multiple Sheet tab excel for a class financial statement set up object, and object represents a page；In page, there is row, set up an object and represent capable；In being expert at, finally it is sub-divided into lattice cell；In lattice cell, data also have good polymorphic type, have character string, numeral, time etc., realize by setting up object or attribute.
Step 3) fills in declaration form: according to taxpayer's authority of approval limit information, it is determined that needs the declaration form kind filled in, shows and fill in declaration form, it is possible to being imported by template；
Between step 4) Biao Neibiao, relation automatically calculates and verifies: relation information between the Biao Neibiao of reading database storage when interface loads, in table, relation is realized by js, is realized by backstage java program between table；
Step 5) declaration form preserves: the declaration form after filling in is preserved, and the data preserved before are edited after again logging in by user, and declaration form data can not be revised after submitting to；When preserving data, data are stored in the data base of the Internet end by the Internet；
Step 6) declaration form is audited: data are submitted to front user's data to filling in carry out examination & verification and checked, if you have questions, come back for amendment；
Step 7) submits declaration form to: the errorless list of examination & verification is carried out submission and declares, and submits to and declares by calling the realization of EJB interface；
Step 8) checks receipt: interface acknowledgement information is shown to interface after submitting to by data.
Embodiment 2:
This self-defined financial statement acquisition method step is as follows:
Step 1) makes table sample: make the required financial statement table sample template added by excel；
Step 2) issue form: by excel Template Information, including: gauge outfit, content, pattern and computing formula, storage is in database table；
Above-mentioned two step adopt ApachePOI realize excel information reading and write, POI Frame Design implementation:
First have to an object and represent this whole Excel file；Multiple Sheet tab excel for a class financial statement set up object, and object represents a page；In page, there is row, set up an object and represent capable；In being expert at, finally it is sub-divided into lattice cell；In lattice cell, data also have good polymorphic type, have character string, numeral, time etc., realize by setting up object or attribute.
Step 3) fills in declaration form: according to taxpayer's authority of approval limit information, it is determined that needs the declaration form kind filled in, shows and fill in declaration form, it is possible to being imported by template；
Between step 4) Biao Neibiao, relation automatically calculates and verifies: relation information between the Biao Neibiao of reading database storage when interface loads, in table, relation is realized by js, is realized by backstage java program between table；
Step 5) declaration form preserves: the declaration form after filling in is preserved, and the data preserved before are edited after again logging in by user, and declaration form data can not be revised after submitting to；When preserving data, data are stored in the data base of the Internet end by the Internet；
Step 6) declaration form is audited: data are submitted to front user's data to filling in carry out examination & verification and checked, if you have questions, come back for amendment；
Step 7) submits declaration form to: the errorless list of examination & verification is carried out submission and declares, and submits to and declares by calling web Service interface realization；
Step 8) checks receipt: interface acknowledgement information is shown to interface after submitting to by data.
By detailed description of the invention above, described those skilled in the art can be easy to realize the present invention.It is understood that the present invention is not limited to above-mentioned several detailed description of the invention.On the basis of disclosed embodiment, described those skilled in the art can the different technical characteristic of combination in any, thus realizing different technical schemes.
Claims (3)
1. a self-defined financial statement acquisition method, it is characterised in that the method step is as follows:
Step 1) makes table sample: make the required financial statement table sample template added by excel；
Step 2) issue form: by excel Template Information, storage is in database table；
Step 3) fills in declaration form: according to taxpayer's authority of approval limit information, it is determined that needs the declaration form kind filled in, shows and fill in declaration form, it is possible to being imported by template；
Between step 4) Biao Neibiao, relation automatically calculates and verifies: relation information between the Biao Neibiao of reading database storage when interface loads, in table, relation is realized by js, is realized by backstage java program between table；
Step 5) declaration form preserves: the declaration form after filling in is preserved, and the data preserved before are edited after again logging in by user, and declaration form data can not be revised after submitting to；When preserving data, data are stored in the data base of the Internet end by the Internet；
Step 6) declaration form is audited: data are submitted to front user's data to filling in carry out examination & verification and checked, if you have questions, come back for amendment；
Step 7) submits declaration form to: the errorless list of examination & verification is carried out submission and declares；
Step 8) checks receipt: interface acknowledgement information is shown to interface after submitting to by data.
2. the self-defined financial statement acquisition method of one according to claim 1, it is characterised in that described step 2) in excel Template Information include: gauge outfit, content, pattern and computing formula.
3. the self-defined financial statement acquisition method of one according to claim 1, it is characterised in that submit in described step 7) and declare by calling web Service interface or the realization of EJB interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610110330.5A CN105786785B (en) | 2016-02-29 | 2016-02-29 | User-defined financial statement collection method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610110330.5A CN105786785B (en) | 2016-02-29 | 2016-02-29 | User-defined financial statement collection method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105786785A true CN105786785A (en) | 2016-07-20 |
| CN105786785B CN105786785B (en) | 2018-06-19 |
Family
ID=56402992
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610110330.5A Active CN105786785B (en) | 2016-02-29 | 2016-02-29 | User-defined financial statement collection method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105786785B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106651562A (en) * | 2016-12-28 | 2017-05-10 | 深圳市中润四方信息技术有限公司 | Tax-related information acquisition method and system |
| CN106682979A (en) * | 2017-01-03 | 2017-05-17 | 山东浪潮商用系统有限公司 | Universal individual income tax detail acquisition declaration tool |
| CN109711960A (en) * | 2018-12-28 | 2019-05-03 | 北京爱康鼎科技有限公司 | It declares dutiable goods method and system |
| CN112307729A (en) * | 2020-11-04 | 2021-02-02 | 恒瑞通（福建）信息技术有限公司 | Online filling report generation method and terminal |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080228822A1 (en) * | 2007-03-02 | 2008-09-18 | Jarboe Paul | System and method for country of origin compliance |
| US20140052653A1 (en) * | 2012-08-17 | 2014-02-20 | Frederick Douglas SCHWENK | System And Method For Completing, Validating And Submitting Regulatory Forms |
| CN104281901A (en) * | 2013-07-04 | 2015-01-14 | 航天信息股份有限公司 | Tax declaration method based on WEB technology |
| CN105138497A (en) * | 2015-07-13 | 2015-12-09 | 深圳市永兴元科技有限公司 | Report uploadingmethod in report system and report system |
-
2016
- 2016-02-29 CN CN201610110330.5A patent/CN105786785B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080228822A1 (en) * | 2007-03-02 | 2008-09-18 | Jarboe Paul | System and method for country of origin compliance |
| US20140052653A1 (en) * | 2012-08-17 | 2014-02-20 | Frederick Douglas SCHWENK | System And Method For Completing, Validating And Submitting Regulatory Forms |
| CN104281901A (en) * | 2013-07-04 | 2015-01-14 | 航天信息股份有限公司 | Tax declaration method based on WEB technology |
| CN105138497A (en) * | 2015-07-13 | 2015-12-09 | 深圳市永兴元科技有限公司 | Report uploadingmethod in report system and report system |
Non-Patent Citations (2)
| Title |
|---|
| 吴骏: "网上办税服务厅系统的设计与实现", 《2008税务信息化论文集》 * |
| 张学明: "网上办税服务系统的设计与实现", 《每周电脑报》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106651562A (en) * | 2016-12-28 | 2017-05-10 | 深圳市中润四方信息技术有限公司 | Tax-related information acquisition method and system |
| CN106682979A (en) * | 2017-01-03 | 2017-05-17 | 山东浪潮商用系统有限公司 | Universal individual income tax detail acquisition declaration tool |
| CN109711960A (en) * | 2018-12-28 | 2019-05-03 | 北京爱康鼎科技有限公司 | It declares dutiable goods method and system |
| CN112307729A (en) * | 2020-11-04 | 2021-02-02 | 恒瑞通（福建）信息技术有限公司 | Online filling report generation method and terminal |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105786785B (en) | 2018-06-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9779078B2 (en) | Payroll processor system and method | |
| Amin et al. | The effect of the SEC's XBRL mandate on audit report lags | |
| CN105786785A (en) | User-defined financial statement collection method | |
| CN107145480B (en) | Method for compiling XBRL report based on Word | |
| CN103150672A (en) | Bank quick credit granting system and method | |
| US11270381B2 (en) | Environmental, social and corporate governance linked debt instruments | |
| Valentinetti et al. | XBRL for financial reporting: Evidence on Italian GAAP versus IFRS | |
| WO2021227444A1 (en) | Accounting report generation method and apparatus, and electronic device | |
| CN107808334A (en) | A kind of method that accounting voucher is automatically generated from business paper | |
| JP2018077813A (en) | Accounting data processing system and program | |
| Singh | Credit ratings of power distribution utilities in northern region of India | |
| Mirzaei et al. | Do macro‐prudential policies jeopardize banking competition? | |
| Petchenko et al. | Analysis of trends in the implementation of digitalization in accounting (Ukrainian case) | |
| US20140052653A1 (en) | System And Method For Completing, Validating And Submitting Regulatory Forms | |
| AU2016101535A4 (en) | Computer-implemented methods and management systems for managing membership of a group | |
| Bragg | The Interpretation of Financial Statements | |
| CN106682979A (en) | Universal individual income tax detail acquisition declaration tool | |
| Jeong et al. | A case study of Financial Statements Reporting System based on XBRL Taxonomy in accordance with Korean Public Institutions adoption of K-IFRS | |
| WO2021073264A1 (en) | Negotiable instrument information acquisition method and device, computer apparatus, and readable storage medium | |
| Wen | Accounting Practices for Financial Instruments: A Theoretical Framework of IFRS 9 Adoption in China | |
| US20140058925A1 (en) | Apparatus, method and article to automate and manage formula or asset-based lending in a networked environment | |
| Mehta | Basel III implementation a comparative study of Indian public sector banks | |
| IEG Review Team | Nigeria-NG-Lagos State DPO II | |
| Procházka | ICT support of the financial statements conversion: main methods and their advantages/disadvantages | |
| Sampaio et al. | Open source accounting software for SMEs |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20200609 Address after: 250100 Inspur Science Park, No. 1036, Inspur Road, high tech Zone, Jinan City, Shandong Province Patentee after: Inspur Software Technology Co.,Ltd. Address before: 250100, No. 2877, fairway, Sun Town, Ji'nan hi tech Zone, Shandong Patentee before: INSPUR GROUP Co.,Ltd. |