CN110119978A - A kind of extracting method of taxation declaration module - Google Patents
A kind of extracting method of taxation declaration module Download PDFInfo
- Publication number
- CN110119978A CN110119978A CN201910390827.0A CN201910390827A CN110119978A CN 110119978 A CN110119978 A CN 110119978A CN 201910390827 A CN201910390827 A CN 201910390827A CN 110119978 A CN110119978 A CN 110119978A
- Authority
- CN
- China
- Prior art keywords
- tax
- amount
- income
- price
- category
- 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
Classifications
-
- 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
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to the parsing of electronics account and show processing technology field, more particularly to a kind of extracting method of taxation declaration module, the following steps are included: configuring declaration form at O&M end by operation maintenance personnel configuration, if the good different tax category, difference declare category phase corresponding declaration form template, calculation formula is set in declaration form cell, stamps write-in label to need to be written the cell of business datum result；The selection of business end declares the tax category, after the category phase, extracts business datum and returns to view interface, confirm for user or manually adjust, each business datum extracts result and is attached to uniquely tagged；After user's confirmation, according to the tax category and belong to the phase from declaration form template library extraction template resolution file, according to the corresponding filling data of label.The invention meets the parsing of a variety of declaration form templates, and calculating logic is not influenced, operating process is simple, and convenient for safeguarding, being not necessarily to training can be used without carrying out additional development by each Tax declaration Policy Updates upgrading between table.
Description
Technical field
The present invention relates to the parsing of electronics account with show processing technology field more particularly to a kind of taxation declaration module
Extracting method.
Background technique
Service application declares module extraction system data function, need to extract the data from disparate modules, is put into different taxes
In the declaration form of kind, these are declared, and tableau format is different, and data structure difference is huge, and existing is the Shen according to the different tax category
Calculating logic between statement form designing form and list exports target data, however needs according to the different tax category, do not belong to the phase
The exploitation of declaration form customization, meanwhile, declaration form includes effective extensive work table and cell and calculating logic, development amount
Greatly, program is too fat to move and is not easy to safeguard.
Summary of the invention
(1) the technical issues of (one) solves
In view of the deficiencies of the prior art, the present invention provides a kind of extracting methods of taxation declaration module, have operating process letter
Easily, advantage convenient for safeguarding, solving existing declaration form includes effective extensive work table and cell and calculating logic, exploitation
Heavy workload, program are too fat to move and are not easy to maintenance issues.
(2) technical solution
To realize above-mentioned technical problem, the present invention provides the extracting methods of such a taxation declaration module, including following step
It is rapid:
S1, declaration form is configured at O&M end by operation maintenance personnel configuration, if the good different tax category, difference declare category phase corresponding declaration form
Calculation formula is arranged in declaration form cell in template, stamps write-in label to need to be written the cell of business datum result；
S2, business end selection declare the tax category, after the category phase, extract business datum return view interface, confirm for user or
It manually adjusts, each business datum extracts result and is attached to uniquely tagged；
After S3, user's confirmation, according to the tax category and belongs to the phase from declaration form template library extraction template resolution file, filled out according to label correspondence
Enter data；
S4, business end show declaration form and data write-in as a result, and according to formula, calculated result between the data and table of write-in；
S5, export include the declaration form Excel of data.
Further, the tax category are Individual Income Tax, value-added tax, sale tax, Sales Tax and enterprise income tax.
Further, the calculation formula of Individual Income Tax:
This month, which answers amount withheld ,=(this month to date should detain advance payment incomes from taxes volume * withholding tax rate-calculates quickly and deducts number)-accumulative deduction and exemption
The accumulative advance payment amount of tax to be paid of having withheld of the amount of tax to be paid-；
This month to date should detain advance payment incomes from taxes volume=accumulative special project of the accumulative deductible expenses-of the accumulative exempt income-of accumulative income-and buckle
Except-accumulative special additional deduction-accumulative other deductions determined in accordance with the law；
Wherein: accumulative deductible expenses=5000* month number.
Further, the calculation formula of value-added tax:
17%=tax included price of tax included price */(1+17%) * 17% of value-added tax=not
Not tax included price=tax included price/(1+17%)；
Value added tax payable=tax amount of offset item-income tax amount；
Tax amount of offset item=be free of tax sale price × 17%=÷ of sale price containing tax (1+17%) × 17%；
Income tax amount=be free of tax purchasing price × 17%=÷ of purchasing price containing tax (1+17%) × 17%.
Further, the calculation formula of sale tax:
Tax liability=sales volume × tax rate；
Without tax sales volume=÷ of sales volume containing tax (1+ VAT rate or tax rate)；
Form taxing price=(cost+profit) ÷ (1-consumption tax rate)；
Form taxing price=cost × (the 1+ profit ratio of cost) ÷ (1-consumption tax tax rate)；
Form taxing price=(material cost+processing charges) ÷ (1-consumption tax tax rate)；
Form taxing price=(dutiable price+tariff) ÷ (1-consumption tax tax rate).
Further, the calculation formula of Sales Tax:
Tax liability=the turnover * tax rate；
Taxing price=running cost or engineering cost * [(the 1+ profit ratio of cost)/(the 1- Sales Tax tax rate)].
Further, the calculation formula of the enterprise income tax:
The amount of taxable income=gross income-permission deduction the amount of money；
The amount of taxable income=total profit+tax-payment adjustment increases volume-tax-payment adjustment and reduces volume；
Tax liability=the amount of taxable income * tax rate；
Moon advance payment volume=moon amount of taxable income * 25%；
The moon amount of taxable income=last year amount of taxable income * 1/12.
(3) beneficial effect
The present invention provides a kind of extracting method of taxation declaration module, have it is following the utility model has the advantages that
1, the extracting method of the taxation declaration module meets the parsing of a variety of declaration form templates, and calculating logic is without carrying out between table
Additional development is not influenced by each Tax declaration Policy Updates upgrading, and operating process is simple, convenient for safeguarding, without training
It can be used.
2, the extracting method of the taxation declaration module, solves different tax category types and needs to handle different declaration form calculating to patrol
Volume, one Individual Income Tax seed type of the caused every increase of demand will do corresponding code revision and increase processing calculating logic, using this
Technology can satisfy a variety of tax category, develop without increasing to each being customized property of declaration form formula calculating logic.
Detailed description of the invention
Fig. 1 is structure of the invention flow chart.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
Referring to Fig. 1, that the present invention provides specific embodiments is as follows:
A kind of extracting method of taxation declaration module, comprising the following steps:
S1, declaration form is configured at O&M end by operation maintenance personnel configuration, if the good different tax category, difference declare category phase corresponding declaration form
Calculation formula is arranged in declaration form cell in template, stamps write-in label to need to be written the cell of business datum result；
S2, business end selection declare the tax category, after the category phase, extract business datum return view interface, confirm for user or
It manually adjusts, each business datum extracts result and is attached to uniquely tagged；
After S3, user's confirmation, according to the tax category and belongs to the phase from declaration form template library extraction template resolution file, filled out according to label correspondence
Enter data；
S4, business end show declaration form and data write-in as a result, and according to formula, calculated result between the data and table of write-in；
S5, export include the declaration form Excel of data.
The tax category are Individual Income Tax, value-added tax, sale tax, Sales Tax and enterprise income tax.
The calculation formula of Individual Income Tax:
This month, which answers amount withheld ,=(this month to date should detain advance payment incomes from taxes volume * withholding tax rate-calculates quickly and deducts number)-accumulative deduction and exemption
The accumulative advance payment amount of tax to be paid of having withheld of the amount of tax to be paid-；
This month to date should detain advance payment incomes from taxes volume=accumulative special project of the accumulative deductible expenses-of the accumulative exempt income-of accumulative income-and buckle
Except-accumulative special additional deduction-accumulative other deductions determined in accordance with the law；
Wherein: accumulative deductible expenses=5000* month number；
Withholding tax rate table
The calculation formula of value-added tax:
17%=tax included price of tax included price */(1+17%) * 17% of value-added tax=not；
Not tax included price=tax included price/(1+17%)；
Value added tax payable=tax amount of offset item-income tax amount；
Tax amount of offset item=be free of tax sale price × 17%=÷ of sale price containing tax (1+17%) × 17%；
Income tax amount=be free of tax purchasing price × 17%=÷ of purchasing price containing tax (1+17%) × 17%.
The calculation formula of sale tax:
Tax liability=sales volume × tax rate；
Without tax sales volume=÷ of sales volume containing tax (1+ VAT rate or tax rate)；
Form taxing price=(cost+profit) ÷ (1-consumption tax rate)；
Form taxing price=cost × (the 1+ profit ratio of cost) ÷ (1-consumption tax tax rate)；
Form taxing price=(material cost+processing charges) ÷ (1-consumption tax tax rate)；
Form taxing price=(dutiable price+tariff) ÷ (1-consumption tax tax rate).
The calculation formula of Sales Tax:
Tax liability=the turnover * tax rate；
Taxing price=running cost or engineering cost * [(the 1+ profit ratio of cost)/(the 1- Sales Tax tax rate)]
The calculation formula of enterprise income tax:
The amount of taxable income=gross income-permission deduction the amount of money；
The amount of taxable income=total profit+tax-payment adjustment increases volume-tax-payment adjustment and reduces volume；
Tax liability=the amount of taxable income * tax rate；
Moon advance payment volume=moon amount of taxable income * 25%；
The moon amount of taxable income=last year amount of taxable income * 1/12.
It although an embodiment of the present invention has been shown and described, for the ordinary skill in the art, can be with
A variety of variations, modification, replacement can be carried out to these embodiments without departing from the principles and spirit of the present invention by understanding
And modification, the scope of the present invention is defined by the appended.
Claims (7)
1. a kind of extracting method of taxation declaration module, which comprises the following steps:
S1, declaration form is configured at O&M end by operation maintenance personnel configuration, if the good different tax category, difference declare category phase corresponding declaration form
Calculation formula is arranged in declaration form cell in template, stamps write-in label to need to be written the cell of business datum result；
S2, business end selection declare the tax category, after the category phase, extract business datum return view interface, confirm for user or
It manually adjusts, each business datum extracts result and is attached to uniquely tagged；
After S3, user's confirmation, according to the tax category and belongs to the phase from declaration form template library extraction template resolution file, filled out according to label correspondence
Enter data；
S4, business end show declaration form and data write-in as a result, and according to formula, calculated result between the data and table of write-in；
S5, export include the declaration form Excel of data.
2. a kind of extracting method of taxation declaration module according to claim 1, it is characterised in that: the tax category are individual
Income tax, value-added tax, sale tax, Sales Tax and enterprise income tax.
3. a kind of extracting method of taxation declaration module according to claim 1, it is characterised in that: the Individual Income Tax
Calculation formula:
This month, which answers amount withheld ,=(this month to date should detain advance payment incomes from taxes volume * withholding tax rate-calculates quickly and deducts number)-accumulative deduction and exemption
The accumulative advance payment amount of tax to be paid of having withheld of the amount of tax to be paid-；
This month to date should detain advance payment incomes from taxes volume=accumulative special project of the accumulative deductible expenses-of the accumulative exempt income-of accumulative income-and buckle
Except-accumulative special additional deduction-accumulative other deductions determined in accordance with the law；
Wherein: accumulative deductible expenses=5000* month number.
4. a kind of extracting method of taxation declaration module according to claim 1, it is characterised in that: the meter of the value-added tax
Calculate formula:
17%=tax included price of tax included price */(1+17%) * 17% of value-added tax=not；
Not tax included price=tax included price/(1+17%)；
Value added tax payable=tax amount of offset item-income tax amount；
Tax amount of offset item=be free of tax sale price × 17%=÷ of sale price containing tax (1+17%) × 17%；
Income tax amount=be free of tax purchasing price × 17%=÷ of purchasing price containing tax (1+17%) × 17%.
5. a kind of extracting method of taxation declaration module according to claim 1, it is characterised in that: the meter of the sale tax
Calculate formula:
Tax liability=sales volume × tax rate；
Without tax sales volume=÷ of sales volume containing tax (1+ VAT rate or tax rate)；
Form taxing price=(cost+profit) ÷ (1-consumption tax rate)；
Form taxing price=cost × (the 1+ profit ratio of cost) ÷ (1-consumption tax tax rate)；
Form taxing price=(material cost+processing charges) ÷ (1-consumption tax tax rate)；
Form taxing price=(dutiable price+tariff) ÷ (1-consumption tax tax rate).
6. a kind of extracting method of taxation declaration module according to claim 1, it is characterised in that: the meter of the Sales Tax
Calculate formula:
Tax liability=the turnover * tax rate；
Taxing price=running cost or engineering cost * [(the 1+ profit ratio of cost)/(the 1- Sales Tax tax rate)].
7. a kind of extracting method of taxation declaration module according to claim 1, it is characterised in that: the enterprise income tax
Calculation formula:
The amount of taxable income=gross income-permission deduction the amount of money；
The amount of taxable income=total profit+tax-payment adjustment increases volume-tax-payment adjustment and reduces volume；
Tax liability=the amount of taxable income * tax rate；
Moon advance payment volume=moon amount of taxable income * 25%；
The moon amount of taxable income=last year amount of taxable income * 1/12.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910390827.0A CN110119978A (en) | 2019-05-10 | 2019-05-10 | A kind of extracting method of taxation declaration module |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910390827.0A CN110119978A (en) | 2019-05-10 | 2019-05-10 | A kind of extracting method of taxation declaration module |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110119978A true CN110119978A (en) | 2019-08-13 |
Family
ID=67522155
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910390827.0A Pending CN110119978A (en) | 2019-05-10 | 2019-05-10 | A kind of extracting method of taxation declaration module |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110119978A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111192125A (en) * | 2019-12-26 | 2020-05-22 | 大象慧云信息技术有限公司 | System and method for tax declaration |
| CN111222967A (en) * | 2019-12-26 | 2020-06-02 | 大象慧云信息技术有限公司 | Group enterprise full-tax-variety taxpayer payment and declaration method and system |
| CN111915417A (en) * | 2020-07-31 | 2020-11-10 | 中国工商银行股份有限公司 | Tax payment amount determining method and device and electronic equipment |
| CN112818655A (en) * | 2021-04-19 | 2021-05-18 | 中建电子商务有限责任公司 | Excel data processing method and tool based on template and file additional writing |
| CN112883319A (en) * | 2021-01-12 | 2021-06-01 | 四川天行健穗金科技有限公司 | Intelligent calculation method and system for calculating full-tax taxes and taxes amount |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106447476A (en) * | 2016-09-08 | 2017-02-22 | 广东源恒软件科技有限公司 | Automatic check computation method and system of consumer tax |
| CN109711960A (en) * | 2018-12-28 | 2019-05-03 | 北京爱康鼎科技有限公司 | It declares dutiable goods method and system |
-
2019
- 2019-05-10 CN CN201910390827.0A patent/CN110119978A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106447476A (en) * | 2016-09-08 | 2017-02-22 | 广东源恒软件科技有限公司 | Automatic check computation method and system of consumer tax |
| CN109711960A (en) * | 2018-12-28 | 2019-05-03 | 北京爱康鼎科技有限公司 | It declares dutiable goods method and system |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111192125A (en) * | 2019-12-26 | 2020-05-22 | 大象慧云信息技术有限公司 | System and method for tax declaration |
| CN111222967A (en) * | 2019-12-26 | 2020-06-02 | 大象慧云信息技术有限公司 | Group enterprise full-tax-variety taxpayer payment and declaration method and system |
| CN111915417A (en) * | 2020-07-31 | 2020-11-10 | 中国工商银行股份有限公司 | Tax payment amount determining method and device and electronic equipment |
| CN111915417B (en) * | 2020-07-31 | 2024-04-23 | 中国工商银行股份有限公司 | Tax amount determining method and device and electronic equipment |
| CN112883319A (en) * | 2021-01-12 | 2021-06-01 | 四川天行健穗金科技有限公司 | Intelligent calculation method and system for calculating full-tax taxes and taxes amount |
| CN112818655A (en) * | 2021-04-19 | 2021-05-18 | 中建电子商务有限责任公司 | Excel data processing method and tool based on template and file additional writing |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110119978A (en) | A kind of extracting method of taxation declaration module | |
| US7668768B2 (en) | Computer-implemented method for evaluating an investment | |
| CN104599176A (en) | Artificial intelligent accounting bookkeeping system and method | |
| CN105608620A (en) | Final settlement platform for enterprise | |
| CN103903081A (en) | Method and system for generating taxi receipt with the use of tax document data in ERP system | |
| JP2009151675A (en) | Budget management accounting computer system and computer program | |
| CN110852861A (en) | Accounting real-time checkout method and system | |
| CN101847219A (en) | Informatization management mode and system for specialized farmers' cooperatives | |
| CN112348650A (en) | Accounting account management system and device based on unitary account keeping | |
| CN107644300A (en) | A kind of concerning taxes risk analysis system | |
| JP3415117B2 (en) | Accounting processing system and medium recording accounting processing program | |
| CN105321114A (en) | Enterprise annuity revenue and payment algorithm | |
| CN101122991A (en) | The fourth generation finance core business system systematic structure and intelligent financial accounting method | |
| Bordeianu et al. | Digital Challenges Brought by Financial Reporting in 2022–SAF-T (Standard Audit File for Taxation) | |
| KR102652883B1 (en) | Computer-readable medium in which an enterprise resource planning program using computer-implemented calendar for financial managing | |
| CN114663256A (en) | Intelligent generation method and system for property account receivable full life cycle accounting document | |
| Zhuravleva et al. | Ways To Improve The Russian Model Of Vat Refunds On Goods Export | |
| Johnson | " More" on" Income-Tax-Allocation" Accounting | |
| JP4206438B2 (en) | Electronic cash register creation apparatus, recording medium on which electronic cash register creation program is recorded, cash accounting management system and management method thereof | |
| Apriyanto et al. | Navigating Financial Reporting: Exploring the Impact of PSAK Number 1 on Liability Preparation | |
| Deaconu et al. | Cases Of Limited Deductibility Value-Added Tax | |
| Ovsyuk et al. | Features of cash accounting at the enterprise | |
| Löfgren | Exercises in General Equilibrium Modeling Using GAMS | |
| Freed et al. | Innovation for VAT: Tax Technology Is Changing How VAT Applies to New and More Complex Business Models, How Tax Authorities Administer These Taxes, and How Businesses Comply | |
| Liu | Research on the significance of value-added tax amendment in 2019 |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190813 |
|
| RJ01 | Rejection of invention patent application after publication |