CN105786785B - User-defined financial statement collection method - Google Patents
User-defined financial statement collection method Download PDFInfo
- Publication number
- CN105786785B CN105786785B CN201610110330.5A CN201610110330A CN105786785B CN 105786785 B CN105786785 B CN 105786785B CN 201610110330 A CN201610110330 A CN 201610110330A CN 105786785 B CN105786785 B CN 105786785B
- Authority
- CN
- China
- Prior art keywords
- declaration form
- data
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 14
- 238000012550 audit Methods 0.000 claims description 8
- 230000004048 modification Effects 0.000 claims 1
- 238000012986 modification Methods 0.000 claims 1
- 238000012423 maintenance Methods 0.000 abstract description 5
- 230000006855 networking Effects 0.000 description 3
- BQCADISMDOOEFD-UHFFFAOYSA-N Silver Chemical compound [Ag] BQCADISMDOOEFD-UHFFFAOYSA-N 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
- 229910052709 silver Inorganic materials 0.000 description 1
- 239000004332 silver Substances 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 information that taxpayer provides to bureau of local taxation, is the important number that country judges income level
The key data retained is needed according to foundation and enterprise.All kinds of financial statements, it is common to have：Small enterprise's accounting standard finance report
Table, general enterprises financial statement, Institution Accounting System, financial class financial statement（Insurance）, financial class financial statement（Silver
Industry）, financial class financial statement（Securities business）Deng financial statement type can be increased by self-defined mode；Per class report
The contents such as balance sheet, profit flow table, owner's equity table involved in table.
Before, corporate boss will record employee's income and information of paying taxes, and using papery by Excel or LAN-ignorant program
Or electronic edition document is supplied to revenue department；The part software of declaring for having financial statement encounters report upgrading or needs every time
Increase new report, be required for upgrading into line program, too development and maintenance workload are big, of high cost.
Invention content
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 that this method step is as follows in the following manner：
Step 1）Make table sample：By excel make needed for financial statement table sample template to be added；
Step 2）Issue report：Excel Template Informations are stored in database table；
Step 3）Fill in declaration form：Authority information is appraised and decided according to taxpayer, determines the declaration form type for needing to fill in, displaying
And declaration form is filled in, it can also be imported by template；
Step 4）Relationship is calculated and is verified automatically between Biao Neibiao：It is closed between the Biao Neibiao of reading database storage when interface loads
It is information, relationship is realized by js in table, is passed through backstage java programs between table and is realized；
Step 5）Declaration form preserves：Declaration form after filling in is preserved, user log in again after to preserving before
Data into edlin, after declaration form data are submitted, can not change；When preserving data, data are stored by internet to mutual
In the database at networking end；
Step 6）Declaration form is audited：User to the data filled in audit and check before data are submitted, and if you have questions, returns
It modifies；
Step 7）Submit declaration form：The list errorless to audit submit and is declared；
Step 8）Check receipt：Interface acknowledgement information is shown to interface after data submission.
The step 2）Middle excel Template Informations include：Gauge outfit, content, pattern and calculation formula.
The step 7）Middle submission is declared by the way that web Service interface or EJB interfaces is called to realize.
Compared to the prior art a kind of self-defined financial statement acquisition method of the present invention, can be carried directly by internet
Revenue department is sent to, do not need to develop again, save maintenance time, greatly reduce exploitation maintenance cost；This method boundary element
Lattice calculate automatically, logic automatic decision, and data obtain automatically between table, and tool is flexible safely, easy to use.
Specific embodiment
Embodiment 1：
The self-defined financial statement acquisition method step is as follows：
Step 1）Make table sample：By excel make needed for financial statement table sample template to be added；
Step 2）Issue report：By excel Template Informations, including：Gauge outfit, content, pattern and calculation formula；It stores
In database table；
Above-mentioned two step realizes the reading and write-in of excel information using Apache POI, and POI Frame Designs are realized
Mode：
It first has to represent this entire Excel file there are one object；For multiple Sheet bookmarks of a kind of financial statement
Excel establishes object, and object represents a page；In page, there is row, establish an object and represent row；In being expert at, finally it is sub-divided into
Lattice cell；Data also have a lot of types in lattice cell, there is character string, number, time etc., real by establishing object or attribute
It is existing.
Step 3）Fill in declaration form：Authority information is appraised and decided according to taxpayer, determines the declaration form type for needing to fill in, displaying
And declaration form is filled in, it can also be imported by template；
Step 4）Relationship is calculated and is verified automatically between Biao Neibiao：It is closed between the Biao Neibiao of reading database storage when interface loads
It is information, relationship is realized by js in table, is passed through backstage java programs between table and is realized；
Step 5）Declaration form preserves：Declaration form after filling in is preserved, user log in again after to preserving before
Data into edlin, after declaration form data are submitted, can not change；When preserving data, data are stored by internet to mutual
In the database at networking end；
Step 6）Declaration form is audited：User to the data filled in audit and check before data are submitted, and if you have questions, returns
It modifies；
Step 7）Submit declaration form：The list errorless to audit submit and is declared, and submission is declared by calling EJB interfaces
It realizes；
Step 8）Check receipt：Interface acknowledgement information is shown to interface after data submission.
Embodiment 2：
The self-defined financial statement acquisition method step is as follows：
Step 1）Make table sample：By excel make needed for financial statement table sample template to be added；
Step 2）Issue report：By excel Template Informations, including：Gauge outfit, content, pattern and calculation formula, storage are arrived
In database table；
Above-mentioned two step realizes the reading and write-in of excel information using Apache POI, and POI Frame Designs are realized
Mode：
It first has to represent this entire Excel file there are one object；For multiple Sheet bookmarks of a kind of financial statement
Excel establishes object, and object represents a page；In page, there is row, establish an object and represent row；In being expert at, finally it is sub-divided into
Lattice cell；Data also have a lot of types in lattice cell, there is character string, number, time etc., real by establishing object or attribute
It is existing.
Step 3）Fill in declaration form：Authority information is appraised and decided according to taxpayer, determines the declaration form type for needing to fill in, displaying
And declaration form is filled in, it can also be imported by template；
Step 4）Relationship is calculated and is verified automatically between Biao Neibiao：It is closed between the Biao Neibiao of reading database storage when interface loads
It is information, relationship is realized by js in table, is passed through backstage java programs between table and is realized；
Step 5）Declaration form preserves：Declaration form after filling in is preserved, user log in again after to preserving before
Data into edlin, after declaration form data are submitted, can not change；When preserving data, data are stored by internet to mutual
In the database at networking end；
Step 6）Declaration form is audited：User to the data filled in audit and check before data are submitted, and if you have questions, returns
It modifies；
Step 7）Submit declaration form：The list errorless to audit submit and is declared, and submission, which is declared, passes through calling
Web Service interface is realized；
Step 8）Check receipt：Interface acknowledgement information is shown to interface after data submission.
The those skilled in the art can readily realize the present invention with the above specific embodiments,.It but should
Work as understanding, the present invention is not limited to above-mentioned several specific embodiments.On the basis of the disclosed embodiments, the technology
The technical staff in field can arbitrarily combine different technical characteristics, so as to fulfill different technical solutions.
Claims (1)
1. a kind of self-defined financial statement acquisition method, which is characterized in that this method step is as follows：
Step 1）Make table sample：By excel make needed for financial statement table sample template to be added；
Step 2）Issue report：Excel Template Informations are included：Gauge outfit, content, pattern and calculation formula, storage to data
In the table of library；
Step 3）Fill in declaration form：Authority information is appraised and decided according to taxpayer, the declaration form type for needing to fill in is determined, shows and fill out
Declaration form is write, can also be imported by template；
Step 4）Relationship is calculated and is verified automatically between Biao Neibiao：Relationship is believed between the Biao Neibiao of reading database storage when interface loads
It ceases, relationship is realized by js in table, is passed through backstage java programs between table and is realized；
Step 5）Declaration form preserves：Declaration form after filling in is preserved, user log in again after to the number that preserved before
According into edlin, after declaration form data are submitted, can not change；When preserving data, data are stored by internet to internet
In the database at end；
Step 6）Declaration form is audited：User to the data filled in audit and check before data are submitted, and if you have questions, comes back for
Modification；
Step 7）Submit declaration form：The list errorless to audit submit and is declared, and submission is declared by calling WebService
Interface or EJB interfaces are realized；
Step 8）Check receipt：Interface acknowledgement information is shown to interface after data submission.
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 CN105786785A (en) | 2016-07-20 |
| CN105786785B true 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) |
Families Citing this family (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 (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (2)
| 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 |
-
2016
- 2016-02-29 CN CN201610110330.5A patent/CN105786785B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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税务信息化论文集》;20081231;第399-407页 * |
| 网上办税服务系统的设计与实现;张学明;《每周电脑报》;20081027;第33-34页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105786785A (en) | 2016-07-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Silva et al. | Enterprise risk management and firm value: Evidence from Brazil | |
| Bushman et al. | Accounting discretion, loan loss provisioning, and discipline of banks’ risk-taking | |
| Oliveira et al. | Intangible assets and value relevance: Evidence from the Portuguese stock exchange | |
| Kajüter et al. | The impact of IFRS 8 adoption on the usefulness of segment reports | |
| CN105786785B (en) | User-defined financial statement collection method | |
| Penman | Financial forecasting, risk and valuation: Accounting for the future | |
| Mamilla | A study on sustainable growth rate for firm survival | |
| CN103295091A (en) | Enterprise resource planning system with enterprise tax administration control function | |
| Kim et al. | Product market competition on the effectiveness of internal control | |
| Dewi et al. | The effect of CSR disclosure on firm value with profitability and leverage as moderators | |
| Wier et al. | The dominant role of large firms in profit shifting | |
| US20130110687A1 (en) | Automated reconciliation of payroll and tax reports | |
| Nikiforos | Crisis, austerity, and fiscal expenditure in Greece: Recent experience and future prospects in the post-COVID-19 era | |
| Petchenko et al. | Analysis of trends in the implementation of digitalization in accounting (Ukrainian case) | |
| Asem et al. | CASH HOARDS AND CHANGES IN INVESTORS'OUTLOOK | |
| Eulaiwi et al. | Investment committee, corporate cash holdings and corporate life cycle | |
| Septiari et al. | Analysis of the influence of financial leverage on financial performance at mining, oil and gas companies listed on Indonesia stock exchange | |
| Baihaqqi et al. | How Financial Ratio, Good Corporate Governance, and Firm Size Affect Firm Value in Infraestructure Companies | |
| Li et al. | [Retracted] Empirical Research on the Relationship between Industry Working Capital Shortfall and Company Cash Holding in the Same Industry | |
| Brown et al. | Fraud at the Global Fund? A viewpoint | |
| CN106682979A (en) | Universal individual income tax detail acquisition declaration tool | |
| Zou et al. | The Impact of Dividend Policies and Financing Strategies on the Speed of Firms’ Capital Structure Adjustment | |
| Martić et al. | XBRL implementation in the banking sector in Montenegro | |
| Lee | The relationship between green innovation and sustainable growth in Korean companies: Moderated mediation effect of ESG score by industry | |
| Onji et al. | Tax law asymmetries and income shifting: Evidence from Japanese capital keiretsu |
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. |