CN106169155A - The automatic accounting method of a kind of cultivated land use tax and system - Google Patents
The automatic accounting method of a kind of cultivated land use tax and system Download PDFInfo
- Publication number
- CN106169155A CN106169155A CN201610810540.5A CN201610810540A CN106169155A CN 106169155 A CN106169155 A CN 106169155A CN 201610810540 A CN201610810540 A CN 201610810540A CN 106169155 A CN106169155 A CN 106169155A
- Authority
- CN
- China
- Prior art keywords
- tax
- land
- transfers
- cultivated land
- data source
- 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/10—Tax strategies
Abstract
The invention discloses automatic accounting method and the system of a kind of cultivated land use tax, the method includes: configure the data source storehouse towards financial data, according to the land transfers contracts card in data source storehouse, sets up local corresponding object library；Configure docking of the contracts card in this data source storehouse and the land transfers contracts card in this object library；The configuration extraction condition to data source storehouse；Automatically extraction land transfer contract dataset；The land transfers contract dataset being drawn into is adjusted, adjusts taxable area；To the land transfers contract dataset after adjusting, according to cultivated land use tax computation rule, calculate the taxable area of cultivated land use tax, be suitable for the crucial tax index such as the tax rate, tax base and tax liability；According to default tax bureau's declaration form template, the mark that traversal template is preset, this key tax index is inserted the cell of corresponding mark, form the tax return of cultivated land use tax, pass through the present invention, it is achieved that the automatization that cultivated land use tax is adjusted.
Description
Technical field
The present invention relates to the tax and adjust field, particularly relate to automatic accounting method and the system of a kind of cultivated land use tax.
Background technology
Cultivated land use tax is the entity and individual that country built a house or be engaged in other non-agricultural constructions to occupying cultivated land, foundation
A kind of tax that the actual area that occupies cultivated land, the according to the rules amount of tax to be paid are disposably imposed, cultivated land use tax belongs to act tax category.Taxation model
Enclose and include Planting Crops arable land (once for the arable land of Planting Crops), fish pond, field, vegetable plot and other agricultural lands, as
Artificial growth grassland and developed Planting Crops or be engaged in the beach etc. of aquaculture.Cultivated land use tax builds a house to occupy cultivated land
It is taxpayer with being engaged in the entity and individual of non-agricultural construction, takes the regional disparity tax rate.The whole nation is how many by per capita arable land
It is divided into 4 class areas, and determines the different amount of tax to be paid by the different purposes occupied cultivated land.To special economic zone, economic and technological development zone and
The area that arable land economically developed, per capita is the fewest, can be properly increased by the amount of tax to be paid of regulation, but the highest must not be higher than 50%.
The concrete applicable amount of tax to be paid, is determined in the allowance of regulation voluntarily by various places.To being approved the arable land that takies, do not used more than 2 years
Entity and individual, add the tax of below twice.Cultivated land use tax is machine-operated by local tax or financial collection organ is responsible for levying
Closed tube is managed.
Therefore, adjusting cultivated land use tax when, it is necessary first to the farmland information taken is as taxation evidence, pin
To the arable land taken, it is necessary first to the area that record is ploughed, as tax base, secondly according to location, arable land, determines cultivated land occupancy
The tax rate of tax, thus the tax liability of cultivated land use tax is calculated further according to cultivated area * locality fixed taxation rate.
For the accounting of cultivated land use tax, in the existing way of enterprise, for the receipts of taxation evidence (occupy cultivated land information)
Collection, medium-and-large-sized enterprise often relates to the trans-regional information across organizational hierarchy, and as a example by program of real estate enterprise, exploration project is past
Such as (Central China, south China etc.) different subject of tax payments it is divided into again for the project developed toward trans-regional, original cultivated land occupancy information
Collect and use artificial enquiry, then carry out manual sorting and conclusion,；After collection is aggregated into original cultivated land occupancy data, then lead to
Cross artificial enquiry to conclude every piece of seating position occupied cultivated land and judge the fixed taxation rate of current cultivated land use tax, thus calculate and work as
Before the cultivated land use tax tax liability that occupies cultivated land.
In sum, the existing way that cultivated land use tax is adjusted suffers from the drawback that
1, the collection of cultivated land occupancy information such as region span and level span bigger in the case of, artificially collect arrangement
Workload is big and the data out that arranges is inconvenient to inquire about and screen.
2, for the conclusion of the data that occupy cultivated land, needing manually to screen each piece of arable land data seating position one by one could really
Determining fixed taxation rate, thus calculate cultivated land use tax tax liability, manually, time cost is high and easily makes mistakes.
3, after cultivated land use tax accounting is complete, the manual declaration form template completion correspondence number provided according to the tax bureau is needed
According to, waste time and energy and can not accomplish that detail penetrates, can not quickly provide reliable the tax bureau looks into taxation evidence detail when
Detailed foundation.
Summary of the invention
For the deficiency overcoming above-mentioned prior art to exist, the purpose of the present invention is to provide the automatic of a kind of cultivated land use tax
Accounting method and system, by setting up enterprise organization structure tree, call ETL technology and automatically extract in the existing financial data of enterprise
Land transfers contract dataset, and automatically screen the contract dataset that land type screening soil is arable land of land transfers contract, right
The land transfers contract dataset being drawn into manually adjusts, and specifies preferential policy according to tax law, filters out tax-free preferential policy
In cultivated land occupancy data (land transfers contract) and according to arable land royalities tax law regulation be allowed to reduce policy, adjust taxable
Long-pending, read land area and automatically according to the administrative region at place in land transfers contract, determine the quota tax of cultivated land use tax
Rate, thus a key calculates specific to the cultivated land use tax tax liability of cultivated land occupancy data in wall scroll land transfer contract, and
Automatically generate the house property tax that the tax bureau specifies and declare the declaration form of form.
Another object of the present invention is to provide the automatic accounting method of a kind of cultivated land use tax and system, and it is automatically meter
The land transfers Contract basis data that when calculating tax, summarizing is good are by cultivated land use tax tax key factor (land area, place
Administrative region, and the tax rate etc. corresponding to administrative region) generate taxing draft, it is provided that and data penetrate function, and taxing draft owns
The total amount arranged and summarize can be penetrated into detail by a key, and real realization has good grounds.
For reaching above and other purpose, the present invention proposes the automatic accounting method of a kind of cultivated land use tax, including walking as follows
Rapid:
Step one, configures the data source storehouse towards financial data, according to land transfers contracts card and the phase thereof in data source storehouse
The merchandise news table answered, sets up local corresponding object library, at least includes the soil in storehouse, corresponding data source in local corresponding object library
Selling contract table；
Step 2, configures the docking of this data source storehouse object library corresponding with this this locality；
Step 3, the configuration extraction condition to data source storehouse；
Step 4, automatically extraction land transfer contract dataset, and based on contract the land type automatic fitration in information is non-
Arable land contract dataset；
Step 5, is adjusted the land transfers contract dataset being drawn into, and specifies preferential policy according to tax law, filters out
Cultivated land occupancy data in tax-free preferential policy and be allowed to reduce policy according to arable land royalities tax law regulation, adjust taxable
Long-pending；
Step 6, to the land transfers contract dataset after adjusting, according to cultivated land use tax computation rule, calculates arable land and accounts for
With the taxable area of tax, it is suitable for the crucial tax index such as the tax rate, tax base and tax liability；
Step 7, according to default tax bureau's declaration form template, the mark that traversal template is preset, this key tax index
Insert the cell of corresponding mark, form the tax return of cultivated land use tax.
Further, step one farther includes:
Step S1, configures the data source storehouse towards financial data, and configuration database links；
Step S2, selects the land transfers contracts card in data source storehouse and corresponding merchandise news table；
Step S3, inputs the contracts card field in requisition for docking；
Step S4, according to field and the business demand of the land transfers contracts card in data source storehouse, sets up local corresponding mesh
Mark storehouse, at least includes land transfers contracts card and Land Information table in local corresponding object library.
Further, before step one, also include:
Setting up organizational structure tree, this organizational structure tree includes at least region, tissue and the data of project three types, and
It is supplied to user's freely configuring these three types data.
Further, before step 5, also include:
Read user configured organizational structure tree, according to unique key therein, the soil that automatic arranging scheduling engine is drawn into
Ground selling contract data；
The land transfers contract dataset concluded under traversal organizational structure tree, reads the place of land transfers contract dataset
Administrative region, secondary concludes the land transfers contract dataset under each tissue rank.
Further, also included before step 6:
Select the organization unit of cultivated land use tax to be adjusted, receive tax computation requests, travel through current organization rank
Under all sub-rank, and collect the land transfers contract dataset of all sub-rank including current level.
Further, in step 5, it is provided that express query instrument and adjustment in batches instrument, to the land transfers being drawn into
Contract dataset manually adjusts, and specifies preferential policy according to tax law, filters out the cultivated land occupancy data in tax-free preferential policy
And it is allowed to reduce policy according to what arable land royalities tax law specified, adjust taxable area.
Further, after step 7, also include:
Reading the land transfers contract dataset concluded under organizational structure, the field of ergodic data, traversal presets draft mould
The data source of plate indicates and cell polymeric rule, and the corresponding field initial value of corresponding land transfers contract dataset is inserted or calculated
After value insert formation and collect taxing draft.
For reaching above-mentioned purpose, the present invention also provides for the automatic accounting system of a kind of cultivated land use tax, including:
Local corresponding object library sets up unit, for configuring the data source storehouse towards financial data, according to data source storehouse
Land transfers contracts card and corresponding merchandise news table thereof, set up local corresponding object library, at least wrap in local corresponding object library
Include land transfers contracts card and the Land Information table in storehouse, corresponding data source；
Docking unit, for configuring the docking of this data source storehouse object library corresponding with this this locality；
Extraction condition dispensing unit, for the configuration extraction condition to data source storehouse；
Scheduling extracting unit, is used for according to data scheduling duties, automatically extraction land transfer contract dataset, and based on contract
Land type automatic fitration bare place contract dataset in information；
Adjustment unit, for being adjusted the land transfers contract dataset being drawn into, specifies preferential policy according to tax law,
Filtering out the cultivated land occupancy data in tax-free preferential policy and the policy of being allowed to reduce according to arable land royalities tax law regulation, adjusting should
Tax area；
Cultivated land use tax computing unit, for the land transfers contract dataset after adjusting, calculating according to cultivated land use tax
Rule, calculates the taxable area of cultivated land use tax, is suitable for the crucial tax index such as the tax rate, tax base and tax liability；
Tax return signal generating unit, for according to default tax bureau's declaration form template, traveling through the mark that template is preset,
This key tax index is inserted the cell of corresponding mark, form the tax return of cultivated land use tax.
Further, this system also includes:
Organizational structure sets up unit, is used for setting up organizational structure tree, and this organizational structure tree includes at least region, tissue, item
The data of mesh three types；
Arrange unit, be used for reading user configured organizational structure tree, according to the unique key of Taxpayer Identification Number, the most whole
The land transfers contract dataset that reason scheduling engine is drawn into；
Secondary concludes unit, for traveling through the land transfers contract dataset concluded under organizational structure tree, reads soil
The administrative region, place of selling contract data, secondary concludes the land transfers contract dataset under each tissue rank
Selecting unit, select the organization unit of cultivated land use tax to be adjusted, receive tax computation requests, traversal is current
All sub-rank under tissue rank, and collect the land transfers contract dataset of all sub-rank including current level.
Further, this system also includes taxing draft signal generating unit, and this taxing draft signal generating unit reads organizational structure
The land transfers contract dataset that lower conclusion is good, the field of ergodic data, traversal is preset the data source of draft template and is indicated and unit
Lattice polymeric rule, the value after the corresponding field initial value of corresponding land transfers contract dataset is inserted or calculated is inserted formation and is collected meter
Tax draft.
Compared with prior art, the automatic accounting method of a kind of cultivated land use tax of the present invention and system, set up organizational structure
Tree, it is achieved that trans-regional inter-organization land transfers data collection, by automatically reading the type of contract information and filtering out non-
Farmland information, the more applicable tax rate of cultivated land use tax is determined by administrative region, contract place, and offer is conveniently inquired about
Instrument and batch modification instrument, enterprise can be according to accounting for that the cultivated land use tax deduction and exemption policy adjustment system that tax law specifies is collected automatically
With the land transfers contract ploughed, determine final tax base, the most automatically calculate the land transfers conjunction that correspondence occupies cultivated land
With cultivated land use tax tax liability, then declare template by tax bureau's regulation cultivated land use tax of presetting, automatically will calculate
The key index and the land transfers contract detail that obtain are inserted and are declared template, form declaration form, and declaration form is calculated process
Detailed data, according to forming taxing draft, is truly realized taxing automatization.
Accompanying drawing explanation
Fig. 1 is the flow chart of steps of the first preferred embodiment of the automatic accounting method of a kind of cultivated land use tax of the present invention；
Fig. 2 is the thin portion flow chart of step 101 in present pre-ferred embodiments；
Fig. 3 is the flow chart of steps of the second preferred embodiment of the automatic accounting method of a kind of cultivated land use tax of the present invention；
Fig. 4 is the flow chart of steps of the automatic accounting method of the cultivated land use tax of the present invention one specific embodiment；
Fig. 5 is the system architecture diagram of the first preferred embodiment of the automatic accounting system of a kind of cultivated land use tax of the present invention；
Fig. 6 is the detail structure chart that in present pre-ferred embodiments, local corresponding object library sets up unit 51；
Fig. 7 is the system architecture diagram of the second preferred embodiment of the automatic accounting system of a kind of cultivated land use tax of the present invention.
Detailed description of the invention
Below by way of specific instantiation accompanying drawings embodiments of the present invention, those skilled in the art can
Further advantage and effect of the present invention is understood easily by content disclosed in the present specification.The present invention also can be different by other
Instantiation implemented or applied, the every details in this specification also can based on different viewpoints and application, without departing substantially from
Various modification and change is carried out under the spirit of the present invention.
Fig. 1 is the flow chart of steps of the first preferred embodiment of the automatic accounting method of a kind of cultivated land use tax of the present invention.
As it is shown in figure 1, the automatic accounting method of a kind of cultivated land use tax of the present invention, comprise the steps:
Step 101, configures towards the data source storehouse of financial data, according to the land transfers contracts card in data source storehouse and corresponding
Merchandise news table, set up local corresponding object library, local corresponding object library at least include that the soil in storehouse, corresponding data source goes out
Allow contracts card and sublist (i.e. Land Information table).
Fig. 2 is the thin portion flow chart of step 101 in present pre-ferred embodiments.Specifically, step 101 is wrapped further
Include:
Step S1, configures the data source storehouse towards financial data (the most such as financial data), configuration database
Link (database link here mainly comprises database address, manager's account, administrator's password, connected mode etc.)；
Step S2, selects land transfers contracts card and the sublist (i.e. merchandise news table) of correspondence thereof in data source storehouse.Here
Land transfers contracts card at least include treaty particulars, pin side's unit, the side's of purchasing unit, contract value, the soil such as Key of Goods goes out
Information, merchandise news table is allowed to include the relevant information in commodity (soil).
Step S3, inputs the contracts card field in requisition for docking, such as treaty particulars, pin side's unit, the side's of purchasing unit, closes
The same amount of money, Key of Goods etc., the land transfers information in storehouse, associated data source；
Step S4, according to field and the business demand of the land transfers contracts card in data source storehouse, sets up local corresponding mesh
Mark storehouse, at least includes land transfers contracts card and sublist (i.e. Land Information table) in local corresponding object library, including soil title,
Pin side's unit, the side's of purchasing unit, land registration system, land area etc..
Step 102, the contracts card in disposition data source storehouse docks (including sublist) with the contracts card in object library, configures number
According to storehouse, source and the correspondence of object library field, and it is corresponding to carry out field.
Step 103, the configuration extraction condition to data source storehouse, (i.e. land transfers contract sublist is also such as to extract sublist
Merchandise news table, the Land Information table of its corresponding object library) in the type of merchandise be the data in soil.
Step 104, according to data scheduling duties, extraction land transfer contract dataset (it should be noted that, extracts soil automatically
Transfer contract data also include intercepting merchandise news table and the managing detailed catalogue of merchandise news table being corresponded to the soil of local object library
The Land Information table of ground selling contract table), and the based on contract land type automatic fitration bare place contract dataset in information.Tool
Saying, financial data (is i.e. set up for financial data by first configuration pin to the data scheduling duties of local corresponding object library body
The data in data source storehouse to the extraction between object library data of the present invention and convert task), fill in task essential information (as appointed
Business title, task remarks, affiliated tissue etc.), the scheduling frequency of configuration task (such as every day, monthly, annual etc.), perform after configuration
Task, system is at backstage Automatic dispatching；System is called ETL (Extraction-Transformation-Loading) parsing and is drawn
Hold up and resolve above-mentioned configuration rule, the account of finance data that extraction land transfer contract dataset is corresponding, and based on contract in information
Land type automatic fitration bare place contract dataset.
Step 105, is adjusted the land transfers contract dataset being drawn into, and specifies preferential policy according to tax law, filters
Fall the cultivated land occupancy data in tax-free preferential policy (land transfers contract) and being allowed to reduce according to arable land royalities tax law regulation
Policy, adjusts taxable area.
Step 106, to the land transfers contract dataset after adjusting, according to cultivated land use tax computation rule, calculates arable land
The taxable area of occupancy tax, it is suitable for the tax rate (can based on contract administrative region, place determine the applicable tax rate of cultivated land use tax), meter
Tax base number (i.e. the taxable area in soil), and the crucial tax index such as tax liability.
Step 107, according to default tax bureau's declaration form template, the mark (such as row mark COLID) that traversal template is default,
Read the guideline code that mark (COLID) is corresponding, key index is inserted the cell of corresponding mark (COLID), formed and plough
The tax return of occupancy tax.
Fig. 3 is the flow chart of steps of the second preferred embodiment of the automatic accounting method of a kind of cultivated land use tax of the present invention.
As it is shown on figure 3, the automatic accounting method of a kind of cultivated land use tax of the present invention, comprise the steps:
Step 301, sets up organizational structure tree, this main inclusion region of organizational structure tree (such as East China, South China
Deng), tissue (subject of tax payment, typically setting up multiple subsidiary such as Real Estate Corporations is subject of tax payment, as Guangzhou XX real estate has
Limit company), the data of project (concrete real estates projects, such as XX holiday village) three types, different according to these three
Data type, provides corresponding maintenance interface respectively, and user can freely configure, including, but not limited to increasing, delete, revising,
Inquiry.
Step 302, configures the data source storehouse towards financial data, according to the land transfers contracts card in data source storehouse, sets up
Local corresponding object library, at least includes the land transfers contracts card in storehouse, corresponding data source in local corresponding object library.
Step 303, the contracts card in disposition data source storehouse docks with the contracts card in object library.This step is preferable with first
Embodiment identical, does not repeats them here.
Step 304, the configuration extraction condition to data source storehouse.This step is identical, at this not with the first preferred embodiment
Give and repeating.
Step 305, according to data scheduling duties, automatically extraction land transfer contract dataset, and based on contract in information
Land type automatic fitration bare place contract dataset.This step is identical with the first preferred embodiment, does not repeats them here.
Step 306, reads user configured organizational structure tree, and according to the unique key of Taxpayer Identification Number, automatic arranging is adjusted
The land transfers contract dataset that degree engine is drawn into.
Step 307, the land transfers contract dataset concluded under traversal organizational structure tree, reads land transfers contract number
According to administrative region, place, secondary concludes the land transfers contract dataset under each tissue rank.
Step 308, is adjusted the land transfers contract dataset being drawn into, and specifies preferential policy according to tax law, filters
Fall the cultivated land occupancy data in tax-free preferential policy (land transfers contract) and being allowed to reduce according to arable land royalities tax law regulation
Policy, adjusts taxable area.In the specific embodiment of the invention, it is provided that express query instrument and adjustment in batches instrument, can be to taking out
The land transfers contract dataset got manually adjusts, and specifies preferential policy according to tax law, filters out in tax-free preferential policy
Cultivated land occupancy data (land transfers contract) and according to arable land royalities tax law regulation be allowed to reduce policy, adjust taxable
Long-pending.
Step 309, selects the organization unit (such as Guangzhou XX company limited) of cultivated land use tax to be adjusted, and receives tax
Gold computation requests, all sub-rank (subsidiary under such as Guangzhou XX company limited, or extensively under traversal current organization rank
Concrete exploration project etc. under the XX company limited of state), and collect the land transfers of all sub-rank including current level
Contract dataset.
Step 310, according to cultivated land use tax computation rule, calculates the taxable area of cultivated land use tax, is suitable for the tax rate, meter
Tax base number, and the crucial tax index such as tax liability.
Step 311, according to default tax bureau's declaration form template, the mark (such as COLID) that traversal template is preset, reads mark
Know the guideline code that (such as COLID) is corresponding, crucial tax index is inserted the cell of corresponding mark (such as COLID), formed and plough
The tax return of ground occupancy tax.
It is preferred that after step 311, present invention additionally comprises following steps:
Reading the land transfers contract dataset concluded under organizational structure, the field of ergodic data, traversal presets draft mould
The data source of plate indicates and cell polymeric rule (such as ask and collect, average), right by corresponding land transfers contract dataset
Value after answering field initial value to insert or calculate is inserted formation and is collected taxing draft, when user clicks on the value of polymerized unit lattice, from
The detailed data that dynamic reading current cell is corresponding, it is achieved penetrate detail.
Fig. 4 is the flow chart of steps of the automatic accounting method of the cultivated land use tax of the present invention one specific embodiment.
Configuration organizational structure tree, configuring area, tissue, project, the i.e. main inclusion region of this organizational structure tree (East China, China
South etc.), tissue (subject of tax payment, it is subject of tax payment that Real Estate Corporations typically sets up multiple subsidiary, as Guangzhou XX real estate has
Limit company), the data of project (concrete real estates projects, such as XX holiday village) three types, the specific embodiment of the invention
In, according to the data type that these three is different, provide corresponding maintenance interface respectively, user can freely configure, including but not office
It is limited to increase, deletes, revises, inquires about.
Configuration cultivated land use tax declaration form template, configuration ETL decimation rule (table name, field are corresponding with field), configuration
Towards the data source storehouse of financial data, fill in database information (link, account etc.), select contracts card and the soil in data source storehouse
Sell information sublist, fill in in requisition for docking contracts card and land transfers information sublist field (contracts card such as contract is plucked
Want, Key of Goods, the side's of purchasing unit, pin side's unit, contract value).
Contracts card according to data source storehouse and the field of land transfers information sublist, set up the soil of local corresponding object library
Selling contract table.
Setting up local object library corresponding with the field of the contracts card in data source storehouse and contract detail list, configuration pin is to finance number
According to the data scheduling duties (for extraction and the convert task of finance such as financial data) to local target contract database, fill in
Task essential information (such as task names, task remarks, affiliated tissue etc.), the scheduling frequency of configuration task is (such as every day, monthly,
Annual etc.), perform task after configuration, system is at backstage Automatic dispatching, and system is called ETL analytics engine and resolved configuration above rule
Then, extraction account of finance data corresponding to land transfers contract dataset, and based on contract land type automatic fitration is non-in information
Arable land contract dataset.
Reading user configured organizational structure tree, according to the unique key of Taxpayer Identification Number, automatic arranging scheduling engine is taken out
The land transfers contract dataset got, is selected organization unit's (limited public affairs of Guangzhou XX of cultivated land use tax to be adjusted by user
Department), click on tax calculate, traversal current organization rank under all sub-rank (the Sun company under the XX company limited of Guangzhou, or
Concrete exploration project etc. under the XX company limited of Guangzhou), and the soil collecting all sub-rank including current level goes out
Allow contract dataset, according to cultivated land use tax computation rule, calculate the taxable area of cultivated land use tax, be suitable for the tax rate, taxing base
Number, and the crucial tax index such as tax liability, and according to default tax bureau's declaration form template, traversal template is preset
COLID, reads guideline code corresponding to COLID, key index is inserted the cell of corresponding COLID, forms cultivated land use tax
Tax return, i.e. travel through the land transfers contract dataset under currently selected tissue, it is judged that current soil is the most cultivated for taking
Ground, if it is not, then continue traversal, the most then reads the current conclusion of contract amount of money or appraises and decides the amount of money, adding up into always answering the amount of tax to be paid；Judge
Whether also have contract dataset, if having, continuing traversal, otherwise calculating the tax index relevant with cultivated land use tax and tax liability；
Traversal cultivated land use tax declaration form modular unit lattice, the data source inserting current calculating according to cell data source identification ID generates
Declaration form.
Reading the land transfers contract dataset concluded under organizational structure, the field of ergodic data, traversal presets draft mould
The data source of plate indicates and cell polymeric rule (such as ask and collect, average), right by corresponding land transfers contract dataset
Value after answering field initial value to insert or calculate is inserted formation and is collected taxing draft, when user clicks on the value of polymerized unit lattice, from
The detailed data that dynamic reading current cell is corresponding, it is achieved penetrate detail.
Fig. 5 is the system architecture diagram of the first preferred embodiment of the automatic accounting system of a kind of cultivated land use tax of the present invention.
As it is shown in figure 5, the automatic accounting system of a kind of cultivated land use tax of the present invention, set up unit 51, right including: local corresponding object library
Order unit 52, extraction condition dispensing unit 53, scheduling unit 54, adjustment unit 55, cultivated land use tax computing unit 56 and receive
Tax declaration form signal generating unit 57.
Wherein, local corresponding object library sets up unit 51, for configuring the data source storehouse towards financial data, according to data
The land transfers contracts card in storehouse, source and corresponding merchandise news table, set up local corresponding object library, in local corresponding object library extremely
Include land transfers contracts card and the sublist (i.e. Land Information table) in storehouse, corresponding data source less.
Fig. 6 is the detail structure chart that in present pre-ferred embodiments, local corresponding object library sets up unit 51.Specifically,
Local corresponding object library is set up unit 51 and is farther included: data source storehouse dispensing unit 510, selection unit 511, field input list
Unit 512, object library set up unit 513.
Data source storehouse dispensing unit 510 is for configuring the data towards financial data (the most such as financial data)
Storehouse, source, configuration database link (database link here mainly comprises database address, manager's account, administrator's password,
Connected mode etc.)；
Select unit 511, for selecting the land transfers contracts card in data source storehouse and sublist (the i.e. merchandise news of correspondence thereof
Table).Here land transfers contracts card at least includes treaty particulars, pin side's unit, the side's of purchasing unit, contract value, Key of Goods
Deng land transfers information, merchandise news table includes the relevant information in commodity (soil)；
Field input block 512, for input to the contracts card field in requisition for docking, such as treaty particulars, sells Fang Dan
Position, the side's of purchasing unit, contract value, Key of Goods etc., the land transfers information in storehouse, associated data source；
Object library sets up unit 513, for field and the business demand of the land transfers contracts card according to data source storehouse,
Set up local corresponding object library, local corresponding object library at least includes land transfers contracts card and sublist (i.e. Land Information
Table), including soil title, pin side's unit, the side's of purchasing unit, land registration system, land area etc..
Docking unit 52, the contracts card for disposition data source storehouse docks with the contracts card in object library, configures data
Storehouse, source and the correspondence of object library field, and carry out field corresponding (main intercepting merchandise news table in object library), and commodity are believed
The managing detailed catalogue of breath table corresponds to the land transfers contracts card of local object library.
Extraction condition dispensing unit 53, for the configuration extraction condition to data source storehouse, (i.e. soil goes out such as to extract sublist
Allow contract sublist, be also merchandise news table, the Land Information table of its corresponding object library) in the type of merchandise be the contract of land transfers
Data.
Scheduling extracting unit 54, according to data scheduling duties, automatic extraction land transfer contract dataset (it should be noted that,
Extraction land transfer contract dataset also includes intercepting merchandise news table and the managing detailed catalogue of merchandise news table being corresponded to local mesh
The Land Information table of land transfers contracts card in mark storehouse), and based on contract the land type automatic fitration bare place in information closes
Same data.Specifically, first configuration pin to the data scheduling duties of financial data to local corresponding object library (i.e. for finance
The data in the data source storehouse that data are set up are to the extraction between object library data of the present invention and convert task), fill in task basic
Information (such as task names, task remarks, affiliated tissue etc.), the scheduling frequency of configuration task (such as every day, monthly, annual etc.),
Performing task after configuration, system is at backstage Automatic dispatching；System calls ETL (Extraction-Transformation-
Loading) analytics engine resolves above-mentioned configuration rule, extracts the account of finance data that land transfer contract dataset is corresponding, and
Based on contract the land type automatic fitration bare place contract dataset in information.
Adjustment unit 55, for being adjusted the land transfers contract dataset being drawn into, specifies preferential political affairs according to tax law
Plan, filters out the cultivated land occupancy data (land transfers contract) in tax-free preferential policy and specifies according to arable land royalities tax law
Be allowed to reduce policy, adjust taxable area.
Cultivated land use tax computing unit 56, for according to cultivated land use tax computation rule, calculating answering of cultivated land use tax
The crucial tax indexs such as tax area, the applicable tax rate, tax base, and tax liability.
Tax return signal generating unit 57, for according to default tax bureau's declaration form template, traversal template is preset
COLID, reads guideline code corresponding to COLID, key index is inserted the cell of corresponding COLID, forms cultivated land use tax
Tax return.
Fig. 7 is the system architecture diagram of the second preferred embodiment of the automatic accounting system of a kind of cultivated land use tax of the present invention.
In the present invention the second preferred embodiment, local corresponding object library sets up unit 702, docking unit 703, extraction condition configuration list
Unit 704, scheduling extracting unit 705 identical with the first preferred embodiment, do not repeat them here, this automatic accounting system also includes:
Organizational structure sets up unit 701, is used for setting up organizational structure tree, and this main inclusion region of organizational structure tree is (such as
East China, South China etc.), tissue (subject of tax payment, as Real Estate Corporations typically sets up multiple subsidiary for the master that pays taxes
Body, such as Guangzhou XX real estate company limited), the number of project (concrete real estates projects, such as XX holiday village etc.) three types
According to, according to the data type that these three is different, provide corresponding maintenance interface respectively, user can freely configure, including but not office
It is limited to increase, deletes, revises, inquires about.
Arrange unit 706, be used for reading user configured organizational structure tree, according to the unique key of Taxpayer Identification Number, from
The land transfers contract dataset that dynamic arrangement scheduling engine ETL is drawn into.
Secondary concludes unit 707, the land transfers contract dataset concluded under traversal organizational structure tree, reads soil and goes out
The administrative region, place of contract dataset, secondary is allowed to conclude the land transfers contract dataset under each tissue rank.
Adjustment unit 708, for being adjusted the land transfers contract dataset being drawn into, specifies preferential political affairs according to tax law
Plan, filters out the cultivated land occupancy data (land transfers contract) in tax-free preferential policy and specifies according to arable land royalities tax law
Be allowed to reduce policy, adjust taxable area.In the present invention, it is provided that express query instrument and adjustment in batches instrument, can be to being drawn into
Land transfers contract dataset manually adjust, according to tax law specify preferential policy, filter out in tax-free preferential policy plough
Take data (land transfers contract) and according to arable land royalities tax law regulation be allowed to reduce policy, adjust taxable area.
Choose to go through unit 709, select (the such as Guangzhou XX company limited of organization unit of cultivated land use tax to be adjusted
Deng), receive tax computation requests, all sub-rank (son under such as Guangzhou XX company limited under traversal current organization rank
Concrete exploration project etc. under company, or Guangzhou XX company limited), and collect all sub-rank including current level
Land transfers contract dataset；
Cultivated land use tax computing unit 710, for according to cultivated land use tax computation rule, calculating answering of cultivated land use tax
The crucial tax indexs such as tax area, the applicable tax rate, tax base, and tax liability.
Tax return signal generating unit 711, for according to default tax bureau's declaration form template, traversal template is preset
COLID, reads guideline code corresponding to COLID, key index is inserted the cell of corresponding COLID, forms cultivated land use tax
Tax return
It is preferred that the automatic accounting system of the cultivated land use tax of the present invention also includes taxing draft signal generating unit, this taxing
Draft signal generating unit, reads the land transfers contract dataset concluded under organizational structure, the field of ergodic data, and traversal presets the end
The data source of original text template indicates and cell polymeric rule (such as ask and collect, average), by correspondence land transfers contract number
According to corresponding field initial value insert or calculate after value insert formation and collect taxing draft, when user clicks on the value of polymerized unit lattice
Time, automatically read the detailed data that current cell is corresponding, it is achieved penetrate detail.
In sum, the automatic accounting method of a kind of cultivated land use tax of the present invention and system, set up organizational structure tree, it is achieved
Trans-regional inter-organization land transfers data collection, by automatically reading the type of contract information and filtering out bare place and believe
Breath, then determine the applicable tax rate of cultivated land use tax by administrative region, contract place, and provide conveniently query facility with
Batch modification instrument, enterprise can be according to occupying cultivated land that the cultivated land use tax deduction and exemption policy adjustment system that tax law specifies is collected automatically
Land transfers contract, determine final tax base, the most automatically calculate ploughing of the land transfers contract that correspondence occupies cultivated land
Ground occupancy tax tax liability, then by preset tax bureau's regulation cultivated land use tax declare template, automatically by calculated
Key index and land transfers contract detail are inserted and are declared template, form declaration form, and declaration form calculates the detailed number of process
According to according to forming taxing draft, it is truly realized taxing automatization.
Compared with prior art, present invention have the advantage that
(1) by the present invention, can realize automatically extracting land transfers contract dataset trans-regional, inter-organization, and according to conjunction
With the data of information automatic fitration bare place type, whole to land transfers contract dataset automatic sorting further according to organization unit
Reason, greatly alleviates business taxation personnel to the statistics of house property data and collection work, improves work efficiency.
(2) combine computer technology by Professional knowledge, it is achieved in land transfers contract dataset with cultivated land use tax meter
Tax, according to automatic examination for information about, automatic arranging, saves the evaluation work of tax staff, and improves the correct of taxing
Property.
(3) offer query facility and batch modification instrument were used, the cultivated land use tax deduction and exemption that enterprise can specify according to tax law
The land transfers contract that what policy adjustment system was collected automatically occupy cultivated land, determines final tax base, convenient and swift, improves
The accuracy of taxation evidence.
(4) template is declared, automatically by the cultivated land use tax critical data calculated and key by the tax bureau by presetting
Index inserts declaration form, it is achieved the key declaring front taxing work generates, convenient and swift.
(5) automatically the land transfers contract dataset arranged out is generated draft of currently taxing, and offer penetrates detailed merit
Can, it is achieved the foundation of paying taxes of tax account, real have something to base on, reduce tax risk.
The principle of above-described embodiment only illustrative present invention and effect thereof, not for limiting the present invention.Any
Above-described embodiment all can be modified under the spirit and the scope of the present invention and change by skilled person.Therefore,
The scope of the present invention, should be as listed by claims.
Claims (10)
1. an automatic accounting method for cultivated land use tax, comprises the steps:
Step one, configures the data source storehouse towards financial data, according to land transfers contracts card and the corresponding business in data source storehouse
Product information table, sets up local corresponding object library, at least includes that the land transfers in storehouse, corresponding data source are closed in local corresponding object library
With table and Land Information table thereof；
Step 2, configures the docking of this data source storehouse object library corresponding with this this locality；
Step 3, the configuration extraction condition to data source storehouse；
Step 4, automatically extraction land transfer contract dataset, and the based on contract land type automatic fitration bare place in information
Contract dataset；
Step 5, is adjusted the land transfers contract dataset being drawn into, and specifies preferential policy according to tax law, filters out tax-free
Cultivated land occupancy data in preferential policy and be allowed to reduce policy according to arable land royalities tax law regulation, adjust taxable area；
Step 6, to the land transfers contract dataset after adjusting, according to cultivated land use tax computation rule, calculates cultivated land use tax
Taxable area, be suitable for the crucial tax index such as the tax rate, tax base and tax liability；
Step 7, according to default tax bureau's declaration form template, the mark that traversal template is preset, inserts this key tax index
The cell of corresponding mark, forms the tax return of cultivated land use tax.
The automatic accounting method of a kind of cultivated land use tax the most as claimed in claim 1, it is characterised in that step one is wrapped further
Include:
Step S1, configures the data source storehouse towards financial data, and configuration database links；
Step S2, selects the land transfers contracts card in data source storehouse and corresponding merchandise news table thereof；
Step S3, inputs the contracts card field in requisition for docking；
Step S4, according to field and the business demand of the land transfers contracts card in data source storehouse, sets up local corresponding object library,
Local corresponding object library at least includes land transfers contracts card and Land Information table.
The automatic accounting method of a kind of cultivated land use tax the most as claimed in claim 1, it is characterised in that before step one,
Also include:
Setting up organizational structure tree, this organizational structure tree is including at least region, tissue and the data of project three types, and provides
To user's freely configuring these three types data.
The automatic accounting method of a kind of cultivated land use tax the most as claimed in claim 3, it is characterised in that before step 5,
Also include:
Reading user configured organizational structure tree, according to unique key therein, the soil that automatic arranging scheduling engine is drawn into goes out
Allow contract dataset；
The land transfers contract dataset concluded under traversal organizational structure tree, the place reading land transfers contract dataset is administrative
Region, secondary concludes the land transfers contract dataset under each tissue rank.
The automatic accounting method of a kind of cultivated land use tax the most as claimed in claim 4, it is characterised in that before step 6 also
Including:
Select the organization unit of cultivated land use tax to be adjusted, receive tax computation requests, under traversal current organization rank
All sub-ranks, and collect the land transfers contract dataset of all sub-rank including current level.
The automatic accounting method of a kind of cultivated land use tax the most as claimed in claim 5, it is characterised in that: in step 5, carry
For express query instrument and adjustment in batches instrument, the land transfers contract dataset being drawn into is manually adjusted, according to tax law
Regulation preferential policy, filters out the cultivated land occupancy data in tax-free preferential policy and subtracting according to arable land royalities tax law regulation
Levy policy, adjust taxable area.
The automatic accounting method of a kind of cultivated land use tax the most as claimed in claim 6, it is characterised in that after step 7, also
Including:
Reading the land transfers contract dataset concluded under organizational structure, the field of ergodic data, traversal presets draft template
Data source indicates and cell polymeric rule, after the corresponding field initial value of corresponding land transfers contract dataset is inserted or calculated
Value is inserted formation and is collected taxing draft.
8. an automatic accounting system for cultivated land use tax, including:
Local corresponding object library sets up unit, for configuring the data source storehouse towards financial data, according to the soil in data source storehouse
Selling contract table and corresponding merchandise news table thereof, set up local corresponding object library, and it is right at least to include in local corresponding object library
Answer land transfers contracts card and the Land Information table thereof in data source storehouse；
Docking unit, for configuring the docking of this data source storehouse object library corresponding with this this locality；
Extraction condition dispensing unit, for the configuration extraction condition to data source storehouse；
Scheduling extracting unit, for according to data scheduling duties, extracts land transfer contract dataset, and based on contract information automatically
In land type automatic fitration bare place contract dataset；
Adjustment unit, for being adjusted the land transfers contract dataset being drawn into, specifies preferential policy according to tax law, filters
Fall the cultivated land occupancy data in tax-free preferential policy and be allowed to reduce policy according to what arable land royalities tax law specified, adjusting taxable
Long-pending；
Cultivated land use tax computing unit, for the land transfers contract dataset after adjusting, according to cultivated land use tax computation rule,
Calculate the taxable area of cultivated land use tax, be suitable for the crucial tax index such as the tax rate, tax base and tax liability；
Tax return signal generating unit, for according to default tax bureau's declaration form template, the mark that traversal template is preset, this
Crucial tax index inserts the cell of corresponding mark, forms the tax return of cultivated land use tax.
The automatic accounting system of a kind of cultivated land use tax the most as claimed in claim 8, it is characterised in that: this system also includes:
Organizational structure sets up unit, is used for setting up organizational structure tree, and this organizational structure tree includes at least region, tissue, project three
The data of type；
Arranging unit, be used for reading user configured organizational structure tree, according to the unique key of Taxpayer Identification Number, automatic arranging is adjusted
The land transfers contract dataset that degree engine is drawn into；
Secondary concludes unit, for traveling through the land transfers contract dataset concluded under organizational structure tree, reads land transfers
The administrative region, place of contract dataset, secondary concludes the land transfers contract dataset under each tissue rank
Select unit, select the organization unit of cultivated land use tax to be adjusted, receive tax computation requests, travel through current organization
All sub-rank under rank, and collect the land transfers contract dataset of all sub-rank including current level.
The automatic accounting system of a kind of cultivated land use tax the most as claimed in claim 9, it is characterised in that: this system also includes
Taxing draft signal generating unit, this taxing draft signal generating unit reads the land transfers contract dataset concluded under organizational structure, time
Counting the field of evidence one by one, traversal is preset the data source of draft template and is indicated and cell polymeric rule, by correspondence land transfers contract
Value after the corresponding field initial value of data is inserted or calculated is inserted formation and is collected taxing draft.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610810540.5A CN106169155A (en) | 2016-09-08 | 2016-09-08 | The automatic accounting method of a kind of cultivated land use tax and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610810540.5A CN106169155A (en) | 2016-09-08 | 2016-09-08 | The automatic accounting method of a kind of cultivated land use tax and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106169155A true CN106169155A (en) | 2016-11-30 |
Family
ID=57376169
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610810540.5A Pending CN106169155A (en) | 2016-09-08 | 2016-09-08 | The automatic accounting method of a kind of cultivated land use tax and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106169155A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112633839A (en) * | 2020-12-25 | 2021-04-09 | 山东浪潮通软信息科技有限公司 | Automatic tax declaration method and device based on NoSql and storage medium |
| CN114969130A (en) * | 2022-08-01 | 2022-08-30 | 创智和宇信息技术股份有限公司 | Social insurance collection service data processing method, system and storage medium |
-
2016
- 2016-09-08 CN CN201610810540.5A patent/CN106169155A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112633839A (en) * | 2020-12-25 | 2021-04-09 | 山东浪潮通软信息科技有限公司 | Automatic tax declaration method and device based on NoSql and storage medium |
| CN114969130A (en) * | 2022-08-01 | 2022-08-30 | 创智和宇信息技术股份有限公司 | Social insurance collection service data processing method, system and storage medium |
| CN114969130B (en) * | 2022-08-01 | 2022-11-18 | 创智和宇信息技术股份有限公司 | Social insurance collection service data processing method, system and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Alston et al. | Making science pay: The economics of agricultural R&D policy | |
| CN106169152A (en) | The automatic accounting method of a kind of value-added tax and system | |
| Kleemann et al. | Rural welfare implications of large-scale land acquisitions in Africa: A theoretical framework | |
| CN105243514A (en) | Salary management system | |
| CN106447478A (en) | Automatic check computation method and system of corporate income tax | |
| Hanson et al. | Data, linkages and models: US national income and product accounts in the framework of a social accounting matrix | |
| Bascom | The peasant economy of refugee resettlement in eastern Sudan | |
| CN106169155A (en) | The automatic accounting method of a kind of cultivated land use tax and system | |
| Küzmič et al. | European Weed Vegetation Database-a gap-focused vegetation-plot database. | |
| CN106169156A (en) | The automatic accounting method of a kind of vehicle-purchase tax and system | |
| CN106384276A (en) | Deed tax automatic checking method and system | |
| Emigh | The spread of sharecropping in Tuscany: the political economy of transaction costs | |
| Burniaux et al. | Trade policies in a global context: technical specifications of the Rural/Urban-North/South (RUNS) applied general equilibrium model | |
| Pascual et al. | On price liberalization, poverty, and shifting cultivation: an example from Mexico | |
| CN106339936A (en) | Automatic accounting method of resource tax and system thereof | |
| Shivakumar | Aspects of Agrarian Economy in Tamil Nadu: A Study of Two Villages: I: Class Structure | |
| Rocca | The gendered implications of the expansion in commercial sugarcane production: A case study of contract farming in Magobbo, Zambia | |
| Chulu et al. | A 1998 social accounting matrix for malawi | |
| CN106447479A (en) | Method and system for automatically accounting housing property tax | |
| Diogo et al. | MagnetGrid: Model description and user guide | |
| CN106169153A (en) | The automatic accounting method of a kind of stamp tax and system | |
| Nyangito | Delivery of services to smallholder coffee farmers and impacts on production under liberalization in Kenya | |
| Kaarhus et al. | Development of national producer organizations and specialized business units in Mozambique: a study for the Royal Norwegian Society for Development to prepare a new phase of programme collaboration | |
| Pontara | A critical examination of theoretical and methodological approaches to low-income country labour markets: A case study of Mauritania | |
| Munoz | Rural credit markets and informal contracts in the Cochabamba valleys, Bolivia |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161130 |