CN106169153A - The automatic accounting method of a kind of stamp tax and system - Google Patents

The automatic accounting method of a kind of stamp tax and system Download PDF

Info

Publication number
CN106169153A
CN106169153A CN201610810447.4A CN201610810447A CN106169153A CN 106169153 A CN106169153 A CN 106169153A CN 201610810447 A CN201610810447 A CN 201610810447A CN 106169153 A CN106169153 A CN 106169153A
Authority
CN
China
Prior art keywords
tax
contract
data source
stamp
storehouse
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
Application number
CN201610810447.4A
Other languages
Chinese (zh)
Inventor
程君
凌世传
邱礼豪
黄高登
沈奇彬
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
GUANGDONG YUANHENG SOFTWARE TECHNOLOGY Co Ltd
Original Assignee
GUANGDONG YUANHENG SOFTWARE TECHNOLOGY Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by GUANGDONG YUANHENG SOFTWARE TECHNOLOGY Co Ltd filed Critical GUANGDONG YUANHENG SOFTWARE TECHNOLOGY Co Ltd
Priority to CN201610810447.4A priority Critical patent/CN106169153A/en
Publication of CN106169153A publication Critical patent/CN106169153A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/10Tax strategies

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Development Economics (AREA)
  • Finance (AREA)
  • Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Marketing (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 invention discloses automatic accounting method and the system of a kind of stamp tax, the method includes: different taxation projects is set up the taxing model of stamp tax, configuration computing formula, taxation evidence and the corresponding tax rate;Configure the data source storehouse towards financial system, according to contracts card and the contract detail sublist of association in data source storehouse, set up local corresponding object library, the corresponding object library in this this locality sets up contracts card and the contract detail sublist having storehouse, corresponding data source;Configure the extraction condition in the data source storehouse to financial system;Configuration data scheduling duties, according to scheduler task, the contract dataset in storehouse, extracted data source is to local correspondence database;For contract dataset, according to taxing model, determine taxation evidence and the corresponding tax rate, calculate tax liability according to corresponding computing formula, pass through the present invention, it is achieved that the automatization that stamp tax is adjusted.

Description

The automatic accounting method of a kind of stamp tax and system
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 stamp tax.
Background technology
Stamp tax is to add setting up in economic activity and economic association, accept and have the behavior of valid voucher and levied A kind of tax received.Because using affix revenue stamps on taxable voucher to gain the name as the mark of tax payment.The taxpayer of stamp tax It is included in and sets up, accept the enterprise of economic voucher of regulation, administrative unit, public institution, military unit, group of society within Chinese territory Body, other unit, self-employed entrepreneur and other people.
Stamp tax is bought and affix revenue stamps with quota in the ratio that regulation is taxable the most voluntarily by taxpayer, i.e. completes to pay taxes Obligation.Securities trading stamp tax, is a part for stamp tax, collects the seller according to the amount of money of book end securities trading contract, tax Rate is 1 ‰.Through State Council approved, the Ministry of Finance determines, from JIUYUE in 2008 19 days, to adjust security trading stamps tax policy Whole, existing bilateral collection change monolateral collection into, i.e. only the side of selling (or succession, A-share of gifting, transferor of B stock equity) is levied Receive security (stock) trading stamps tax, the side of buying in (assignee) is no longer levied taxes.The tax rate still keeps 1 ‰.
At present, enterprise typically uses the artificial mode calculating stamp tax, and which has the following disadvantages:
1, more and the tax rate differs due to stamp tax taxation project, when causing calculating stamp tax, needs are levied according to different Tax item mesh is by using the tax rate to calculate one by one, and workload is relatively big, and error rate is higher, makes troubles to tax calculation work;
2, have different modes can calculate stamp tax, such as by the taxation of the taxable voucher taxing amount of money and by taxable with certificate Number taxation, when skimble-scamble mode causes calculating, time cost increases;
3, the collection of stamp tax contract information such as region span and level span bigger in the case of, artificially collect arrangement Workload big and the data out that arranges is inconvenient to inquire about and screen.
4, the papery data of text contract is difficult to preserve, scattered, along with the variation of staff causes contract easily to abandon Or damage, cause contract dataset entanglement;Reliable detail can not be quickly provided to depend on the tax bureau looks into taxation evidence detail when According to.
5, the tax rate of various contracts differs, and brings relatively burden to the calculating amount of tax to be paid, and workload increases.
Summary of the invention
For the deficiency overcoming above-mentioned prior art to exist, the purpose of the present invention is oneself of offer a kind of stamp tax of the present invention Kinetonucleus calculates method and system, by setting up organizational structure tree, it is achieved that trans-regional inter-organization stamp tax contract dataset is collected, logical Cross and automatically read contract information correspondence contract value, count and answer the amount of tax to be paid, further calculate the tax liability of stamp tax, then The stamp tax specified by the default tax bureau declare template, automatically calculated key index and contract detail are inserted Declare template, form declaration form, and the detailed data foundation that declaration form calculates process forms taxing draft, is truly realized meter Tax automatization.
For reaching above and other purpose, the present invention proposes the automatic accounting method of a kind of stamp tax, comprises the steps:
Step one, sets up the taxing model of stamp tax to different taxation projects, configuration computing formula, taxation evidence and The corresponding tax rate;
Step 2, configures the data source storehouse towards financial system, bright according to the contracts card in data source storehouse and the contract of association Thin sublist, sets up local corresponding object library, sets up, in the corresponding object library in this this locality, contracts card and the contract having storehouse, corresponding data source Detailed sublist;
Step 3, configures the extraction condition in the data source storehouse to financial system;
Step 4, configures data scheduling duties, and according to scheduler task, the contract dataset in storehouse, extracted data source is to local corresponding Data base;
Step 5, for contract dataset, according to taxing model, determines taxation evidence and the corresponding tax rate, according to correspondence Computing formula calculate tax liability.
Further, in step one, according to the different calculations of stamp tax, each taxation project is set up taxing model, Configure the corresponding tax rate.
Further, the calculation of this stamp tax includes calculating by the taxable voucher taxing amount of money with by candidate voucher number of packages Mode.
Further, step 2 farther includes:
Step S1, configures the data source storehouse towards financial system, and configuration database links;
Step S2, selects contracts card and the contract detail sublist of association in data source storehouse;
Step S3, inputs the contracts card field in requisition for docking;
Step S4, according to the field of the contracts card in data source storehouse, set up in local corresponding object library corresponding contracts card and Contract detail sublist.
Further, the method also includes:
Setting up organizational structure tree, this organizational structure tree includes at least region, organizes two kinds of data, and provides user To freely configuring of these two types data.
Further, before step 5, also include:
Read user configured organizational structure tree, according to Taxpayer Identification Number, the conjunction that automatic arranging scheduling engine is drawn into Same data.
Further, after step 5, also include:
According to each tissue under organizational structure tree, add up the data of every sub-level by tissue, and according to the default tax Office's declaration form template, the mark that traversal template is preset, reads the guideline code that mark is corresponding, the key of the stamp tax calculated Index inserts the cell of corresponding mark, forms the tax return of stamp tax.
For reaching above-mentioned purpose, the present invention also provides for the automatic accounting system of a kind of stamp tax, including:
Unit set up by taxing model, and for different taxation projects is set up the taxing model of stamp tax, configuration calculates public affairs Formula, taxation evidence and the corresponding tax rate;
Local corresponding object library sets up unit, for configuring the data source storehouse towards financial system, according to data source storehouse The contract detail sublist of contracts card and association, sets up local corresponding object library, and setting up in the corresponding object library in this this locality has corresponding number Contracts card and contract detail sublist according to storehouse, source;
Extraction condition dispensing unit, for the configuration extraction condition to data source storehouse;
Scheduling extracting unit, is used for configuring data scheduling duties, according to scheduler task, the contract dataset in storehouse, extracted data source To local correspondence database;
Stamp tax computing unit, for contract dataset, according to taxing model, determines taxation evidence and the corresponding tax rate, Tax liability is calculated according to corresponding computing formula.
Further, this system also includes:
Organizational structure sets up unit, is used for setting up organizational structure tree, and this organizational structure tree is including at least region, two kinds of tissue The data of type;
Arranging unit, be used for reading user configured organizational structure tree, according to Taxpayer Identification Number, automatic arranging scheduling is drawn Hold up the contract dataset being drawn into;
Tax return signal generating unit, according to each tissue under organizational structure tree, is added up the number of every sub-level by tissue According to, and according to default tax bureau's declaration form template, the mark that traversal template is preset, read the guideline code that mark is corresponding, The key index of the stamp tax calculated inserts the cell of corresponding mark, forms the tax return of stamp tax.
Further, this taxing model is set up unit, according to the different calculations of stamp tax, each taxation project is set up meter Tax model, configures the corresponding tax rate.
Compared with prior art, the automatic accounting method of a kind of stamp tax of the present invention and system, by setting up organizational structure Tree, it is achieved that trans-regional inter-organization stamp tax contract dataset is collected, and the non-taxable data of automatic fitration, by automatically reading conjunction With information correspondence contract value, count and answer the amount of tax to be paid, further calculate the tax liability of stamp tax, then by the tax preset The stamp tax that business office specifies declare template, automatically calculated key index and contract detail are inserted and declare template, shape Become declaration form, and the detailed data foundation that declaration form calculates process forms 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 stamp tax of the present invention;
Fig. 2 is the thin portion flow chart of step 102 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 stamp tax of the present invention;
Fig. 4 is the flow chart of steps of the automatic accounting method of the stamp 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 stamp 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 stamp 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 stamp tax of the present invention.Such as Fig. 1 Shown in, the automatic accounting method of a kind of stamp tax of the present invention, comprise the steps:
Step 101, sets up the taxing model of stamp tax to different taxation projects, configuration computing formula, taxation evidence with And the corresponding tax rate.
Owing to the calculating of stamp tax has two ways: by the taxable voucher taxing amount of money with by candidate voucher number of packages calculating side Formula, each taxation project is set up taxing model according to the different calculations of stamp tax, is configured the corresponding tax rate, specifically by the present invention As follows:
1) levy taxes by the taxable voucher taxing amount of money.Computing formula is: the tax liability=taxable voucher taxing amount of money × tax Rate.
(a) loan contract.Taxation evidence: borrowing balance;The tax rate: 0.05 ‰;
(b) purchase order.Taxation evidence: the purchase and sale amount of money;The tax rate: 0.3 ‰;
(c) building installation engineering contract.Taxation evidence: contract the amount of money;The tax rate: 0.3 ‰;
(d) technology contract.Taxation evidence: cost, remuneration or the usage charges that contract is contained;The tax rate: 0.3 ‰;
(e) assuming contract.Taxation evidence: the processing charges+auxiliary material of consignee's income;The tax rate: 0.5 ‰;
(f) construction project contract for prospecting and designing.Taxation evidence: fee charged;The tax rate: 0.5 ‰;
(g) freight transport contract.Taxation evidence: the traffic expense amount of money (but do not include the amount of money of goods carried, terminal charges and Insurance premium etc.);The tax rate: 0.5 ‰;
(h) property right transfer book evidence.Taxation evidence: the contained amount of money;The tax rate: 0.5 ‰;
The account book of fund described in (i) operating book.Taxation evidence: two total gold of " paid-up capital " and " capital surplus " Volume;The tax rate: 0.5 ‰;
(j) contract for the lease of property.Taxation evidence: lease the amount of money (if be computed, the amount of tax to be paid more than 1 jiao less than 1 yuan, by 1 Unit's applique);The tax rate: 1 ‰;
(k) contract for storage and safekeeping.Taxation evidence: the storage expense collected;The tax rate: 1 ‰;
(l) contract of property insurance.Taxation evidence: amount cover charge (does not include the amount of money of protected property;The tax rate: 1 ‰;
(2) levy taxes by taxable voucher number of packages.Computing formula is: tax liability=taxable voucher number of packages × be suitable for the tax rate.
Other account books in (a) operating book.Tax by part, 5 yuan every;
B () right, licence shine.Tax by part, 5 yuan every.
Step 102, configures the data source storehouse towards financial system, bright according to the contracts card in data source storehouse and the contract of association Thin sublist, sets up local corresponding object library, sets up, in the corresponding object library in this this locality, contracts card and the contract having storehouse, corresponding data source Detailed sublist.
Fig. 2 is the thin portion flow chart of step 102 in present pre-ferred embodiments.Specifically, step 102 is wrapped further Include:
Step S1, configures the data source storehouse towards financial system, and (database link here is main in configuration database link Comprise database address, manager's account, administrator's password, connected mode etc.);
Step S2, selects contracts card and the contract detail sublist of association in data source storehouse, and contracts card here refers to close With content master meter, the inside generally comprises contract type, treaty particulars, contract value, Party A's unit, and Party B's unit etc., contract is bright Thin sublist is usually the commodity detail list etc. that contract is corresponding.
Step S3, inputs the contracts card field in requisition for docking, such as contract type, treaty particulars, contract value, Party A Unit, Party B's unit;
Step S4, according to the field of the contracts card in data source storehouse, set up in local corresponding object library corresponding contracts card and Contract detail sublist.
Step 103, configures the extraction condition in the data source storehouse to financial system (such as: the time point etc. of data occurs Deng).
Step 104, configures data scheduling duties, according to scheduler task, utilizes the conjunction in storehouse, ETL scheduling engine extracted data source With data to local correspondence database.Specifically, first financial system is adjusted by configuration pin to the data of local corresponding object library Degree task is (between the data in the data source storehouse i.e. set up for Third party system (financial system) to object library data of the present invention Extraction and convert task), fill in task essential information (such as task names, task remarks, affiliated tissue etc.), the tune of configuration task Degree frequency (such as every day, monthly, annual etc.), performs task after configuration, system is at backstage Automatic dispatching;System calls ETL (Extraction-Transformation-Loading) analytics engine resolves above-mentioned configuration rule, storehouse, extracted data source Contract dataset is to local correspondence database.
Step 105, for contract dataset, according to taxing model, determines taxation evidence and the corresponding tax rate, according to correspondence Computing formula calculate tax liability.
Fig. 3 is the flow chart of steps of the second preferred embodiment of the automatic accounting method of a kind of stamp tax of the present invention.Such as Fig. 3 Shown in, the automatic accounting method of a kind of stamp tax of the present invention, comprise the steps:
Step 301, sets up the taxing model of stamp tax to different taxation projects, configuration computing formula, taxation evidence with And the corresponding tax rate.This step is identical with the step in the present invention the first preferred embodiment, does not repeats them here.
Step 302, sets up organizational structure tree, this main inclusion region of organizational structure tree (such as East China, South China Etc.), tissue (subject of tax payment is subject of tax payment as group company typically sets up multiple subsidiary, such as Guangzhou XX company limited) Two kinds of data, according to the data type that both is different, provide corresponding maintenance interface respectively, and user can freely join Put, including, but not limited to increasing, delete, revise, inquiring about.
Step 303, configures the data source storehouse towards financial system, bright according to the contracts card in data source storehouse and the contract of association Thin sublist, sets up local corresponding object library, sets up, in the corresponding object library in this this locality, contracts card and the contract having storehouse, corresponding data source Detailed sublist.Owing to this step is identical with the first preferred embodiment, do not repeat them here.
Step 304, configures the extraction condition (time point occurred such as data) in the data source storehouse to financial system.
Step 305, configures data scheduling duties, according to scheduler task, utilizes the contract in storehouse, scheduling engine extracted data source Data are to local correspondence database.Owing to this step is identical with the step in the present invention the first preferred embodiment, the most superfluous at this State
Step 306, reads user configured organizational structure tree, and according to the unique key of Taxpayer Identification Number, automatic arranging is adjusted The contract dataset that degree engine is drawn into.
Step 307, for contract dataset, according to taxing model, determines taxation evidence and the corresponding tax rate, according to correspondence Computing formula calculate tax liability.
Step 308, according to each tissue under organizational structure tree, is added up the data of every sub-level by tissue, and according in advance If tax bureau's declaration form template, the mark (the most such as example mark COLID) that traversal template is preset, read mark (row mark COLID) corresponding guideline code, inserts the key index of the stamp tax calculated the list of corresponding mark (row mark COLID) Unit's lattice, form the tax return of stamp tax.
It is preferred that after step 308, present invention additionally comprises following steps:
Reading the contract dataset concluded under organizational structure, the field of ergodic data, traversal presets the data of draft template Source indicates and cell polymeric rule (such as ask and collect, average), the corresponding field initial value of corresponding contract dataset is inserted or Value after calculating is inserted formation and is collected taxing draft, when user clicks on the value of polymerized unit lattice, automatically reads current cell Corresponding detailed data, it is achieved penetrate detail.
Fig. 4 is the flow chart of steps of the automatic accounting method of the stamp 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 group company typically sets up multiple subsidiary, such as Guangzhou XX company limited) Two kinds of data, in the specific embodiment of the invention, according to the data type that both is different, provide corresponding maintenance respectively Interface, user can freely configure, including, but not limited to increasing, delete, revise, inquiring about.
Configure the data source storehouse towards financial system, set up local corresponding object library, configure ETL extraction condition (table name, word Section correspondence and field conversion etc.), utilize ETL scheduling engine extraction contract dataset to local correspondence object library.
Set up the taxing model of stamp tax according to different treaty contents, configure computing formula, taxation evidence and set up phase The tax rate model answered.
Reading user configured organizational structure tree, according to the unique key of Taxpayer Identification Number, automatic arranging scheduling engine is taken out The contract dataset got;For contract dataset, according to taxing model, determine taxation evidence and the corresponding tax rate, according to correspondence Computing formula calculate tax liability, and add up the data of every sub-level by tissue, programming count is to tax return.
Fig. 5 is the system architecture diagram of the first preferred embodiment of the automatic accounting system of a kind of stamp tax of the present invention.Such as Fig. 5 Shown in, the automatic accounting system of a kind of stamp tax of the present invention, including: unit 50 set up by taxing model, local corresponding object library is built Vertical unit 51, extraction condition dispensing unit 52, scheduling extracting unit 53, stamp tax computing unit 54.
Wherein, unit 50 set up by taxing model, for different taxation projects being set up the taxing model of stamp tax, and configuration Computing formula, taxation evidence and the corresponding tax rate.
In the present invention, owing to the calculating of stamp tax has two ways: by the taxable voucher taxing amount of money with by being recruited with certificate Number calculation, each taxation project is set up taxing model according to the different calculations of stamp tax by the present invention, and configuration is corresponding The tax rate, specific as follows:
1) levy taxes by the taxable voucher taxing amount of money.Computing formula is: the tax liability=taxable voucher taxing amount of money × tax Rate.
(a) loan contract.Taxation evidence: borrowing balance;The tax rate: 0.05 ‰;
(b) purchase order.Taxation evidence: the purchase and sale amount of money;The tax rate: 0.3 ‰;
(c) building installation engineering contract.Taxation evidence: contract the amount of money;The tax rate: 0.3 ‰;
(d) technology contract.Taxation evidence: cost, remuneration or the usage charges that contract is contained;The tax rate: 0.3 ‰;
(e) assuming contract.Taxation evidence: the processing charges+auxiliary material of consignee's income;The tax rate: 0.5 ‰;
(f) construction project contract for prospecting and designing.Taxation evidence: fee charged;The tax rate: 0.5 ‰;
(g) freight transport contract.Taxation evidence: the traffic expense amount of money (but do not include the amount of money of goods carried, terminal charges and Insurance premium etc.);The tax rate: 0.5 ‰;
(h) property right transfer book evidence.Taxation evidence: the contained amount of money;The tax rate: 0.5 ‰;
The account book of fund described in (i) operating book.Taxation evidence: two total gold of " paid-up capital " and " capital surplus " Volume;The tax rate: 0.5 ‰;
(j) contract for the lease of property.Taxation evidence: lease the amount of money (if be computed, the amount of tax to be paid more than 1 jiao less than 1 yuan, by 1 Unit's applique);The tax rate: 1 ‰;
(k) contract for storage and safekeeping.Taxation evidence: the storage expense collected;The tax rate: 1 ‰;
(l) contract of property insurance.Taxation evidence: amount cover charge (does not include the amount of money of protected property;The tax rate: 1 ‰;
(2) levy taxes by taxable voucher number of packages.Computing formula is: tax liability=taxable voucher number of packages × be suitable for the tax rate.
Other account books in (a) operating book.Tax by part, 5 yuan every;
B () right, licence shine.Tax by part, 5 yuan every.
Local corresponding object library sets up unit 51, for configuring the data source storehouse towards financial system (such as Kingdee), root According to contracts card and the contract detail sublist of association in data source storehouse, set up local corresponding object library, in the corresponding object library in this this locality Set up contracts card and the contract detail sublist having storehouse, corresponding data source.
Fig. 6 is the detail structure chart that in present pre-ferred embodiments, local corresponding object library sets up unit 51.Such as Fig. 6 institute Showing, local corresponding object library is set up unit 51 and is farther included:
Data source storehouse dispensing unit 510, for configuring the data source towards financial system (the most such as Kingdee) Storehouse, (database link here mainly comprises database address, manager's account, administrator's password, connects in configuration database link Connect mode etc.);
Select unit 511, for selecting the contracts card in data source storehouse and the contract detail sublist of association, contracts card here Referring to treaty content master meter, the inside generally comprises contract type, treaty particulars, contract value, Party A's unit, Party B's unit Deng, contract detail sublist is usually the commodity detail list etc. that contract is corresponding.
Field input block 512, for input to the contracts card field in requisition for docking, such as contract type, treaty particulars, Contract value, Party A's unit, Party B's unit;
Object library sets up unit 513, for the field of the contracts card according to data source storehouse, sets up in local corresponding object library Corresponding contracts card and contract detail sublist.
Extraction condition dispensing unit, configures the extraction condition in the data source storehouse to financial system.
Scheduling extracting unit 53, is used for configuring data scheduling duties, according to scheduler task, utilizes ETL scheduling engine to extract The contract dataset in data source storehouse is to local correspondence database.Specifically, first configuration pin to financial system to local corresponding mesh (data in the data source storehouse i.e. set up for Third party system (financial system) are to target of the present invention for the data scheduling duties in mark storehouse Extraction between database data and convert task), fill in task essential information (such as task names, task remarks, affiliated tissue etc.), The scheduling frequency of configuration task (such as every day, monthly, annual etc.), performs task after configuration, system is at backstage Automatic dispatching;System Call ETL (Extraction-Transformation-Loading) analytics engine and resolve above-mentioned configuration rule, extracted data The contract dataset in storehouse, source is to local correspondence database.
Stamp tax computing unit 54, for contract dataset, according to taxing model, determines taxation evidence and corresponding tax Rate, calculates tax liability according to corresponding computing formula.
Fig. 7 is the system architecture diagram of the second preferred embodiment of the automatic accounting system of a kind of stamp tax of the present invention.At this Inventing in the second preferred embodiment, unit 702 set up by taxing model, object library sets up unit 703 to local correspondence, extraction condition is joined Put unit 704, scheduling extracting unit 705 identical with the first preferred embodiment, do not repeat them here, this automatic accounting system also wraps Include:
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, it is subject of tax payment that group company typically sets up multiple subsidiary, as Guangzhou XX company limited) two kinds of data, according to the data type that both is different, provide corresponding maintenance circle respectively Face, user can freely configure, including, but not limited to increasing, delete, revise, inquiring about.
Arrange unit 706, be used for reading user configured organizational structure tree, according to the unique key of Taxpayer Identification Number, from The contract dataset that dynamic arrangement scheduling engine is drawn into.
Stamp tax computing unit 707, for contract dataset, according to taxing model, determines taxation evidence and corresponding tax Rate, and calculate tax liability according to corresponding computing formula.
Tax return signal generating unit 708, according to each tissue under organizational structure tree, adds up every sub-level by tissue Data, and according to default tax bureau's declaration form template, the mark (the most such as example mark COLID) that traversal template is preset, read Label taking knows the guideline code that (row mark COLID) is corresponding, and the key index of the stamp tax calculated is inserted corresponding mark (row mark Know COLID) cell, formed stamp tax tax return.
Invention further preferably includes taxing draft signal generating unit, for reading the contract number concluded under organizational structure According to, the field of ergodic data, traversal is preset the data source sign of draft template and (is such as asked collect with cell polymeric rule, ask flat Average), the value after the corresponding field initial value of corresponding contract dataset is inserted or calculated is inserted formation and is collected taxing draft, works as user When clicking on the value of polymerized unit lattice, 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 stamp tax of the present invention and system, by setting up organizational structure tree, it is achieved Trans-regional inter-organization stamp tax contract dataset is collected, and by automatically reading contract information correspondence contract value, counting should The amount of tax to be paid, further calculates the tax liability of stamp tax, then the stamp tax specified by the tax bureau preset declare template, Automatically calculated key index and contract detail are inserted and declare template, form declaration form, and declaration form is calculated process Detailed data according to formed taxing draft, be truly realized taxing automatization.
Compared with prior art, present invention have the advantage that
(1) by the present invention, can realize automatically extracting stamp tax tax trans-regional, inter-organization and be correlated with finance corresponding to contract Subject data, and according to organization unit, contract dataset automatic sorting can be arranged, greatly alleviate business taxation personnel to stamp The statistics of tax contract dataset and collection work, improve work efficiency.
(2) can realize, to stamp tax contract dataset automatic arranging, saving the evaluation work of tax staff, and improve meter The correctness of tax.
(3) template is declared by the tax bureau by presetting, and automatically the stamp tax the customhouse key data calculated and key is referred to Mark inserts declaration form, it is achieved the key declaring front taxing work generates, convenient and swift.
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 stamp tax, comprises the steps:
Step one, sets up the taxing model of stamp tax to different taxation projects, configuration computing formula, taxation evidence and corresponding The tax rate;
Step 2, configures the data source storehouse towards financial system, according to contracts card and contract detail of association in data source storehouse Table, sets up local corresponding object library, and setting up in the corresponding object library in this this locality has the contracts card in storehouse, corresponding data source and contract detailed Sublist;
Step 3, configures the extraction condition in the data source storehouse to financial system;
Step 4, configures data scheduling duties, and according to scheduler task, the contract dataset in storehouse, extracted data source is to local corresponding data Storehouse;
Step 5, for contract dataset, according to taxing model, determines taxation evidence and the corresponding tax rate, according to corresponding meter Calculate formula and calculate tax liability.
The automatic accounting method of a kind of stamp tax the most as claimed in claim 1, it is characterised in that: in step one, according to print Each taxation project is set up taxing model by the different calculations of flower tax, configures the corresponding tax rate.
The automatic accounting method of a kind of stamp tax the most as claimed in claim 2, it is characterised in that: the calculation of this stamp tax Including by the taxable voucher taxing amount of money with by candidate voucher number of packages calculation.
The automatic accounting method of a kind of stamp tax the most as claimed in claim 3, it is characterised in that step 2 farther includes:
Step S1, configures the data source storehouse towards financial system, and configuration database links;
Step S2, selects contracts card and the contract detail sublist of association in data source storehouse;
Step S3, inputs the contracts card field in requisition for docking;
Step S4, according to the field of the contracts card in data source storehouse, sets up corresponding contracts card and contract in local corresponding object library Detailed sublist.
The automatic accounting method of a kind of stamp tax the most as claimed in claim 4, it is characterised in that the method also includes:
Setting up organizational structure tree, this organizational structure tree includes at least region, organizes two kinds of data, and provides user to this Freely configuring of two types data.
The automatic accounting method of a kind of stamp tax the most as claimed in claim 5, it is characterised in that before step 5, also wrap Include:
Read user configured organizational structure tree, according to Taxpayer Identification Number, the contract number that automatic arranging scheduling engine is drawn into According to.
The automatic accounting method of a kind of stamp tax the most as claimed in claim 6, it is characterised in that after step 5, also wrap Include:
According to each tissue under organizational structure tree, add up the data of every sub-level by tissue, and according to default tax bureau Shen Report form template, the mark that traversal template is preset, reads the guideline code that mark is corresponding, the key index of the stamp tax calculated Insert the cell of corresponding mark, form the tax return of stamp tax.
8. an automatic accounting system for stamp tax, including:
Unit set up by taxing model, for different taxation projects is set up the taxing model of stamp tax, configures computing formula, meter Tax foundation and the corresponding tax rate;
Local corresponding object library sets up unit, for configuring the data source storehouse towards financial system, according to the contract in data source storehouse The contract detail sublist of table and association, sets up local corresponding object library, and setting up in the corresponding object library in this this locality has corresponding data source The contracts card in storehouse and contract detail sublist;
Extraction condition dispensing unit, for the configuration extraction condition to data source storehouse;
Scheduling extracting unit, is used for configuring data scheduling duties, and according to scheduler task, the contract dataset in storehouse, extracted data source is to this Ground correspondence database;
Stamp tax computing unit, for contract dataset, according to taxing model, determines taxation evidence and the corresponding tax rate, according to Corresponding computing formula calculates tax liability.
The automatic accounting system of a kind of stamp 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 is including at least region, tissue two types Data;
Arranging unit, be used for reading user configured organizational structure tree, according to Taxpayer Identification Number, automatic arranging scheduling engine is taken out The contract dataset got;
Tax return signal generating unit, according to each tissue under organizational structure tree, is added up the data of every sub-level by tissue, and According to default tax bureau's declaration form template, the mark that traversal template is preset, read the guideline code that mark is corresponding, calculating The key index of stamp tax insert the cell of corresponding mark, form the tax return of stamp tax.
The automatic accounting system of a kind of stamp tax the most as claimed in claim 8, it is characterised in that: this taxing model is set up single Each taxation project is set up taxing model according to the different calculations of stamp tax by unit, configures the corresponding tax rate.
CN201610810447.4A 2016-09-08 2016-09-08 The automatic accounting method of a kind of stamp tax and system Pending CN106169153A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610810447.4A CN106169153A (en) 2016-09-08 2016-09-08 The automatic accounting method of a kind of stamp tax and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610810447.4A CN106169153A (en) 2016-09-08 2016-09-08 The automatic accounting method of a kind of stamp tax and system

Publications (1)

Publication Number Publication Date
CN106169153A true CN106169153A (en) 2016-11-30

Family

ID=57376958

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610810447.4A Pending CN106169153A (en) 2016-09-08 2016-09-08 The automatic accounting method of a kind of stamp tax and system

Country Status (1)

Country Link
CN (1) CN106169153A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108960789A (en) * 2018-09-25 2018-12-07 金蝶软件(中国)有限公司 A kind of method, apparatus and terminal of financial accounting
CN109801149A (en) * 2018-12-20 2019-05-24 航天信息股份有限公司 The method for creating tax return, device, storage medium and electronic equipment

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108960789A (en) * 2018-09-25 2018-12-07 金蝶软件(中国)有限公司 A kind of method, apparatus and terminal of financial accounting
CN109801149A (en) * 2018-12-20 2019-05-24 航天信息股份有限公司 The method for creating tax return, device, storage medium and electronic equipment

Similar Documents

Publication Publication Date Title
US20210049706A1 (en) Systems and methods of organizing databases
US10068294B1 (en) Method and system for allocating funds over a plurality of time deposit instruments in depository institutions
US9213993B2 (en) Investment, trading and accounting management system
Segal et al. The expected impact of the implementation of International Financial Reporting Standard (IFRS) 16–Leases
CN106169152A (en) The automatic accounting method of a kind of value-added tax and system
Brailsford et al. Re‐examination of the historical equity risk premium in Australia
CN106447476A (en) Automatic check computation method and system of consumer tax
CN106384275A (en) Land increment tax automatic accounting method and system
CN108596527A (en) A kind of financial revenue and expenditure data dynamic supervision system
US20060036524A1 (en) Method and apparatus for capture and application of legal personal net worth information
CN109615492B (en) Accounting voucher generation method and system
Borga et al. US International Services
CN106169156A (en) The automatic accounting method of a kind of vehicle-purchase tax and system
Scudder et al. Timber royalty reform to improve the livelihoods of forest resource owners in Papua New Guinea
CN106169153A (en) The automatic accounting method of a kind of stamp tax and system
Altuntas et al. Takaful-Charity or Business? Field Study Evidence from Microinsurance Providers.
CN106169154A (en) The automatic accounting method of a kind of tariff and system
CN106384276A (en) Deed tax automatic checking method and system
US20220301073A1 (en) System and method for general ledger processing
Park Comparison of BEA Estimates of Personal Income and IRS Estimates of Adjusted Gross Income
KR20200006338A (en) System for accounting process based on blockchain
US20150149334A1 (en) Transfer Pricing Systems and Methods
KR20120035016A (en) Method for financial assets management
US20130290155A1 (en) System and method for processing data related to fixed annuities having price index based interest crediting
Otavová Proposals of changes in the financial statements of non-profit organizations

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

Application publication date: 20161130

RJ01 Rejection of invention patent application after publication