CN106447476A - Automatic check computation method and system of consumer tax - Google Patents
Automatic check computation method and system of consumer tax Download PDFInfo
- Publication number
- CN106447476A CN106447476A CN201610810481.1A CN201610810481A CN106447476A CN 106447476 A CN106447476 A CN 106447476A CN 201610810481 A CN201610810481 A CN 201610810481A CN 106447476 A CN106447476 A CN 106447476A
- Authority
- CN
- China
- Prior art keywords
- tax
- data
- unit
- consumption
- consumption tax
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/123—Tax preparation or submission
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses an automatic check computation method and system of a consumer tax. The method comprises the following steps of: establishing a tax subject related to the consumer tax; configuring a data source library oriented to sales data, establishing a local corresponding target library, a corresponding commodity type and a commodity income combination detail according to the data source library and system business logic; configuring the correspondence of a field in the data source library and a field in the target library; configuring a data scheduling task, and extracting finance subject data corresponding to sales incomes, and carrying out automatic corresponding on the finance subject data to a tax subject system; aiming at the tax subject to obtain the computation unit, the computational formula and the tax rate configuration of a consumer tax item, and calculating a key tax index under each subject; and according to a preset tax bureau declaration form template, traversing the preset identification of the template, reading an index code corresponding to the identification, and filling the key tax index into the cell of the corresponding identification to form the tax return of the consumer tax. Through the method, the automation of the check computation of the consumer tax is realized.
Description
Technical field
The present invention relates to the tax adjusts field, the automatic accounting method of more particularly to a kind of consumption tax and system.
Background technology
The consumption tax (Consumer tax/Excise Duty) (special cargo and service tax) is the circulation volume with consumer goodss
General designation as the various tax revenues of the object of taxation.It is the tax item that government imposes to consumer goodss, can impose from whole seller or retailer.
The consumption tax is typical indirect tax.The consumption tax is the taxation reform in 1994 newly-installed tax category in turnover tax.The consumption tax
Carry out taxes included in the calculated prices, only pay in the production of dutiable consumer goods, consigned processing and import link, the ring such as wholesale, retail afterwards
Section, because having comprised the consumption tax in cost, therefore without paying the consumption tax again, tax is finally undertaken by consumer.The consumption tax
Taxpayer be China produce within the border, consigned processing, retail and import《People's Republic of China's consumption tax interim regulations》Regulation
The entity and individual of dutiable consumer goods.
The consumption tax is on the basis of levy value-added tax universal to goods, selects an Individual Income Tax of minority consumer goodss reimpose
Kind, primarily to adjusting product structure, guiding consumption direction is it is ensured that state revenue.The range of collection of the existing consumption tax
Main inclusion：Cigarette, wine, firecrackers, fireworks, cosmetics, product oil, valuable jewelry and jewels and jade, golf and ball, high-grade
Wrist-watch, yacht, wooden throwaway chopsticks, solid wooden floor board, motorcycle, car, battery, the tax items such as coating, some tax items also enter
One step divides some specific items.
Therefore, the consumption tax is the tax category imposed for specific consumer goodss, has tax items clearly at different levels, in the consumption tax
Calculation process is broadly divided into three steps：First, the collection of taxation evidence, mainly gathers finance income account voucher, and to finance income
Account is distinguished, corresponds to the consumption tax tax items that tax law specifies；2nd, the difference according to consumption tax tax items, according to each tax items
Computing formula, determine each tax items answers the amount of tax to be paid, determines final tax base；3rd, the filling out of the calculating of tax liability and tax return
Write.
At present, for the collection of taxation evidence (specific consumer goodss finance income from sales voucher), medium-and-large-sized enterprise often relates to
And arrive the trans-regional information across organizational hierarchy, often trans-regional as (Central China, south China etc.), the different tissues under zones of different
Unit is divided into different subject of tax payments again, and the collection of original finance income from sales voucher adopts artificial enquiry, then it is carefully and neatly done to carry out people
Reason and conclusion；It is still necessary to artificial screen contract one by one after collection is aggregated into initial data, reject non-consumption tax manually taxable
Voucher, and conclusion corresponds to the tax subject (consumption tax tax items) that the consumption tax specifies manually, so that it is determined that unit of assessment, calculating public affairs
Formula and tax base, and correspond to subject of tax payment (organization unit) manually, thus calculating the taxable of each organization unit's consumption tax
Volume.
In sum, there is following drawback in prior art：
1st, the collection such as region span of income from sales credential information and level span ratio in the case of larger in financial account, people
The workload that work is compiled is big and arrangement data out is inconvenient to inquire about and is screened.
2nd, it is directed to the conclusion of income from sales voucher, need manually to screen each Credential data one by one, reject non-consumption tax
The income from sales voucher of taxable products, and conclude manually and correspond to the tax subject (consumption tax tax items) that the consumption tax specify with determination
Computing formula, unit of assessment and tax base, correspond to subject of tax payment (organization unit) simultaneously, thus calculate each organization unit corresponding to
Consumption tax tax tax liability, manually, time cost is high and easily malfunctions.
3rd, after the consumption tax is adjusted and finished, need the manual declaration form template completion corresponding data providing according to the tax bureau,
Waste time and energy and can not accomplish that detail penetrates, can not quickly provide reliable detail when the tax bureau looks into taxation evidence detail
Foundation.
Content of the invention
For overcoming the shortcomings of above-mentioned prior art presence, the purpose of the present invention is to provide a kind of automatic accounting of consumption tax
Method and system, set up enterprise organization structure tree, set up with the consumption tax relevant tax subject (collection project) system, call
ETL (data dispatch engine) technology extracts the account of finance data of corresponding income from sales in business finance (as financial data) automatically
Automatically correspond to consumption tax tax subject, and automatic sorting, under corresponding subject of tax payment (organization unit), configures according to tax items
Computing formula and unit of assessment, the tax rate, collect unit of assessment sum, read the corresponding tax rate of tax items, thus a key calculates
Specific to the consumption tax tax liability of each subject of tax payment (organization unit), and automatically generate the consumption tax that the tax bureau specifies and declare
The declaration form of form.
Another object of the present invention is to provide a kind of automatic accounting method of consumption tax and system, and it is automatically calculating tax
When golden, the good income from sales account voucher basic data of summarizing presses consumption tax key factor (consumption tax tax items, unit of assessment, tax
Rate, answers amount of tax to be paid etc.) generate taxing draft, provide data to penetrate function, all total amounts arranging and summarizing of taxing draft are all
Detail can be penetrated into by a key, real realization has good grounds.
For reaching above and other purpose, the present invention proposes a kind of automatic accounting method of consumption tax, comprises the steps：
Step one, sets up the tax subject related to the consumption tax；
Step 2, the data source storehouse of configuration marketing orientation data, set up local according to data source storehouse and system business logic
Corresponding object library, corresponding goods type, commodity income merge detailed；
Step 3, disposition data source storehouse field is corresponding with the field in object library；
Step 4, configuration data scheduler task, according to scheduler task, extracts income from sales corresponding account of finance data certainly
Move and correspond to tax popular tourism；
Step 5, for tax subject, the unit of account of acquisition consumption tax tax items, computing formula, tax rate configuration, calculates every
Individual section unit of account now and tax liability and finally collect all sections of organization unit unit of account now and Ying Na
The amount of tax to be paid, the key tax index such as tax bearing rate；
Step 6, according to default tax bureau declaration form template, travels through the default mark of template, reads and identify corresponding finger
Mark code, inserts the crucial tax index cell of corresponding mark, forms the tax return of the consumption tax.
Further, in step one, using system provide formula designer, configuration the corresponding unit of account of tax items and
Computing formula.
Further, step 2 further includes：
Step S1, the data source storehouse of configuration marketing orientation data system, configuration database links；
Step S2, account table when the corresponding type of merchandise of income from sales, commodity detail, income sequence in disposition data source storehouse, and
Respective field is filled according to data source storehouse；
Step S3, according to data source storehouse and system business logic, sets up local object library, corresponding goods type, commodity are received
Enter to merge detailed.
Further, before step one, also comprise the steps：
Set up organizational structure tree, this organizational structure tree includes at least region, organizes two kinds of data, and is supplied to use
Family freely configures to this three types data.
Further, before step 5, also include：
Read user configured organizational structure tree, according to Taxpayer Identification Number, what automatic arranging scheduling engine was drawn into disappears
Income from sales account data after the adjustment now of Fei Shui tax section；
Select the organization unit of the currently consumption tax to be adjusted, receive tax computation requests, under traversal current organization rank
All sub- ranks, and collect the sales revenue data of all sub- rank including current level.
Further, after step 6, also include：
Read the sales revenue data concluded under organizational structure, the field of ergodic data, traversal according to consumption tax tax items
The data source of default draft template indicates and cell polymeric rule, and the corresponding field initial value of corresponding sales revenue data is inserted
Or the value after calculating inserts formation and collects taxing draft.
Further, the method also includes：
Query facility and adjustment in batches instrument are provided, to inquire issuable wrong data in extraction process, and
The sales revenue data that there is mistake is quickly adjusted by adjustment in batches instrument.
For reaching above-mentioned purpose, the present invention also provides a kind of automatic accounting system of consumption tax, including：
Tax subject sets up unit, for setting up the tax subject related to the consumption tax；
Locally correspond to object library and set up unit, for configuring the data source storehouse of marketing orientation data, according to data source storehouse and
System business logic is set up and is locally corresponded to object library, and corresponding goods type, commodity income merge detailed；
Docking unit is corresponding with the field in object library for disposition data source storehouse field；
Scheduling extracting unit, for configuration data scheduler task, according to scheduler task, extracts the corresponding finance of income from sales
Subject data corresponds to tax popular tourism automatically；
Consumption tax computing unit, for tax subject, the unit of account of acquisition consumption tax tax items, computing formula, the tax rate are joined
Put, calculate each section unit of account now and tax liability and finally collect all sections of organization unit calculating list now
Position and tax liability, the key tax index such as tax bearing rate；
Tax return signal generating unit, according to default tax bureau declaration form template, travels through the default mark of template, reads
Identify corresponding guideline code, crucial tax index is inserted the cell of corresponding mark, form the tax return of the consumption 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, two kinds of tissue
The data of type；
Arrange unit, for reading user configured organizational structure tree, according to Taxpayer Identification Number, automatic arranging scheduling is drawn
Hold up the income from sales account data after the consumption tax tax section being drawn into adjustment now；
Select collection unit, select the organization unit of the currently consumption tax to be adjusted, receive tax computation requests, and collect bag
Include the sales revenue data of current organization.
Further, this system also includes inquiring about adjustment unit, for providing query facility and adjustment in batches instrument, so that
Inquire issuable wrong data in extraction process, and quickly adjust the sale receipts that there is mistake by adjustment in batches instrument
Enter data.
Compared with prior art, a kind of automatic accounting method of consumption tax of the present invention and system, it is by foundation group stretching frame
Broussonetia papyrifera, sets up consumption tax tax subject it is achieved that trans-regional inter-organization income from sales financial data is collected, and automatically corresponds to
Consumption tax tax items, the non-taxable data (being distinguished according to product type) of automatic fitration, and quick search instrument and adjustment in batches are provided
Instrument, makes user conveniently find in the sales revenue data being drawn into and there may be wrong data, quickly make
Adjustment, by reading unit of assessment, computing formula and the tax rate of configuration in tax items, count income from sales under corresponding tax items should
Tax, further calculates total tax liability under current organization, then declaring by default tax bureau's regulation consumption tax
Calculated key index and income from sales detail are inserted and are declared template by template automatically, form declaration form, and to declaration form
The income from sales detailed data of calculating process, according to forming taxing draft, is truly realized taxing automatization.
Brief description
Fig. 1 is a kind of flow chart of steps of first preferred embodiment of automatic accounting method of consumption tax of the present invention；
Fig. 2 is the thin portion flow chart of step 102 in present pre-ferred embodiments；
Fig. 3 is a kind of flow chart of steps of second preferred embodiment of automatic accounting method of consumption tax of the present invention；
Fig. 4 is the flow chart of steps of the automatic accounting method of the consumption tax of the present invention one specific embodiment；
Fig. 5 is a kind of system architecture diagram of first preferred embodiment of automatic accounting system of consumption tax of the present invention；
Fig. 6 is locally to correspond to the detail structure chart that object library sets up unit 52 in present pre-ferred embodiments；
Fig. 7 is a kind of system architecture diagram of second preferred embodiment of automatic accounting system of consumption tax of the present invention.
Specific embodiment
Below by way of specific instantiation and embodiments of the present invention are described with reference to the drawings, those skilled in the art can
Understand further advantage and effect of the present invention by content disclosed in the present specification easily.The present invention also can be by other different
Instantiation implemented or applied, the every details in this specification also can be based on different viewpoints and application, without departing substantially from
Carry out various modification and change under the spirit of the present invention.
Fig. 1 is a kind of flow chart of steps of first preferred embodiment of automatic accounting method of consumption tax of the present invention.As Fig. 1
Shown, a kind of automatic accounting method of consumption tax of the present invention, comprise the steps：
Step 101, sets up the tax subject related to the consumption tax, i.e. consumption tax tax items, such as includes Medicated cigarette, ethanol, cosmetic
Product, valuable jewelry and jewels and jade etc., provide maintenance interface, user can be in the clear and definite one-level of tax law, two grades of subjects, lower freedom
(for example, one-level subject such as Medicated cigarette, medicated beer etc., two grades of subjects are then directed to and subject division detail configuration subordinate subject, such as Class A
Medicated cigarette, Class B Medicated cigarette etc.), and the formula designer being provided using system, configure the corresponding unit of account of tax items and calculate public
Formula.
Step 102, the data source storehouse of configuration marketing orientation (as sales data), according to data source storehouse and system business logic
Set up and locally correspond to object library, corresponding goods type, commodity income merge detailed.
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, the data source storehouse of configuration marketing orientation (such as sales data in the present invention), configuration database links
(database link here mainly comprises database address, manager's account, administrator's password, connected mode etc.)；
Step S2, account table when the corresponding type of merchandise of income from sales, commodity detail, income sequence in disposition data source storehouse, and
Respective field is filled according to data source storehouse.In the present invention, data source storehouse is mainly sales data, adjusts the main write off of the consumption tax and sells
The income Credential data of data, income voucher corresponds to sales invoice, comprises commodity detail in invoice, so need docking is to send out
The commodity of ticket are detailed and take in voucher, and commodity are detailed to be used for determining which consumption tax tax items this commodity corresponds to, and income voucher is used for
Determine consumption tax tax base (i.e. the taxation evidence of the consumption tax)).
Step S3, according to data source storehouse and system business logic, (service logic here refers to what the above-mentioned consumption tax was adjusted
Service logic), set up local object library, corresponding goods type, commodity income merge detailed that is to say, that local object library bag
Table containing the type of merchandise, for determining which consumption tax tax items commodity belong to, commodity and income merge table, for recording commodity detail
And the income from sales (income from sales is mainly to determine consumption tax tax base) of commodity).
Step 103, disposition data source storehouse field is corresponding with the field in object library.
Step 104, configuration data scheduler task, according to scheduler task, extracts income from sales corresponding account of finance data
Automatically correspond to tax popular tourism, and the consumption tax taxable products specifying automatically according to tax law filter non-taxable data.Specifically
Ground say, first against extracted data configuration schedules task, fill in task essential information (such as task names, task remarks, affiliated group
Knit), the scheduling frequency (as daily, monthly, annual etc.) of configuration task, execute task after configuration, system is adjusted automatically on backstage
Degree；System calls the above-mentioned configuration rule of ETL (Extraction-Transformation-Loading) analytics engine parsing,
Extract income from sales corresponding account of finance data and automatically correspond to tax popular tourism, and the consumption specifying automatically according to tax law
Tax taxable products filter non-taxable data.
Step 105, for tax subject, the unit of account of acquisition consumption tax tax items, computing formula, tax rate configuration (calculate
Unit, computing formula, tax rate configuration are all to be directed to tax items when setting up consumption tax tax items to set up), calculate each subject
Under unit of account and tax liability and finally collect all sections of organization unit unit of account now and tax liability, tax
The key tax index such as negative rate.
Step 106, according to default tax bureau declaration form template, travels through the default mark of template (specifically such as example mark
COLID), read mark (row mark COLID) corresponding guideline code, crucial tax index is inserted corresponding mark (row mark
COLID cell), forms the tax return of the consumption tax.
Fig. 3 is a kind of flow chart of steps of second preferred embodiment of automatic accounting method of consumption tax of the present invention.As Fig. 3
Shown, a kind of automatic accounting method of consumption 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), (it is subject of tax payment that subject of tax payment, such as Real Estate Corporations typically set up multiple subsidiaries to tissue, and such as Guangzhou XX real estate has
Limit company), two kinds of data, according to the different data type of both, provide corresponding maintenance interface, Yong Huke respectively
Freely configure, including but not limited to increase, delete, change, inquire about.
Step 302, sets up the tax subject related to the consumption tax, i.e. consumption tax tax items, such as includes Medicated cigarette, ethanol, cosmetic
Product, valuable jewelry and jewels and jade etc..This step is identical with the first preferred embodiment, will not be described here.
Step 303, the data source storehouse of configuration marketing orientation (as sales data), according to data source storehouse and system business logic
Set up and locally correspond to object library, corresponding goods type, commodity income merge detailed.
Step 304, disposition data source storehouse field is corresponding with the field in object library.
Step 305, configuration data scheduler task, according to scheduler task, extracts income from sales corresponding account of finance data
Automatically correspond to tax popular tourism, and the consumption tax taxable products specifying automatically according to tax law filter non-taxable data, this step
Rapid and identical in the first preferred embodiment, will not be described here
Step 306, reads user configured organizational structure tree, and according to the unique key of Taxpayer Identification Number, automatic arranging is adjusted
Income from sales account data after the consumption tax tax section that degree engine is drawn into adjustment now.
Step 307, selects the organization unit (such as Guangzhou XX company limited etc.) of the currently consumption tax to be adjusted, and receives tax
Computation requests, and collect the sales revenue data including current organization；
Step 308, for tax subject, the unit of account of acquisition consumption tax tax items, computing formula, tax rate configuration, calculates
Each section unit of account now and tax liability and finally collect all sections of organization unit unit of account now and should
Tax, the key tax index such as tax bearing rate.
Step 309, according to default tax bureau declaration form template, travels through the default mark of template (specifically such as example mark
COLID), read mark (row mark COLID) corresponding guideline code, crucial tax index is inserted corresponding mark (row mark
COLID cell), forms the tax return of the consumption tax.
It is preferred that after step 309, present invention additionally comprises following steps：
Read the sales revenue data concluded under organizational structure, the field of ergodic data, traversal according to consumption tax tax items
The data source of default draft template indicates and cell polymeric rule (such as ask and collect, average), by the pin under corresponding tax items
Sell income data corresponding field initial value insert or calculate after value insert formation and collect taxing draft, as user, to click on polymerization single
During the value of first lattice, automatically read the corresponding detailed data of current cell, realize penetrating detail.
It is preferred that before step 306, the automatic accounting method of the consumption tax of the present invention also comprises the steps：
There is provided query facility and adjustment in batches instrument, to inquire in extraction process issuable wrong data (such as
Non- taxable income from sales, the consumption tax tax items of the corresponding mistake of income from sales), and it is wrong quickly to adjust presence by adjustment in batches instrument
Sales revenue data by mistake.
Fig. 4 is the flow chart of steps of the automatic accounting method of the consumption tax of the present invention one specific embodiment.
Configuration group stretching frame Broussonetia papyrifera, configuring area, tissue, that is, this main inclusion region of organizational structure tree (East China, south China etc.),
Tissue (subject of tax payment, such as Guangzhou XX trade Co., Ltd etc.) two kinds of data, in the specific embodiment of the invention, according to this
Two kinds of different data types, provide corresponding maintenance interface respectively, and user can freely configure, including but not limited to increase,
Delete, change, inquire about.
Configure the tax subject related to the consumption tax, i.e. consumption tax tax items, for example, include Medicated cigarette, ethanol, cosmetics are valuable
Jewelry and jewels and jade etc., in the specific embodiment of the invention, provide maintenance interface, user can the clear and definite one-level of tax law,
Two grades of sections freely configure subordinate's subject, and the formula designer providing using system now, configure the corresponding unit of account of tax items
And computing formula.
The configuration consumption tax declares template, configuration ETL decimation rule (table name, field correspond to and field is changed etc.), configuration pin
Sell (as sales data) data source storehouse information (link, account), select table (type of merchandise, the business needing in data source storehouse to extract
Product are detailed, income sequence when account), set up object library (type of merchandise table, commodity and income merge table), and configure number in sales data
Field according to source storehouse to object library corresponds to.
Configuration data scheduler task, according to scheduler task, extracts income from sales corresponding account of finance data and automatically corresponds to
To tax popular tourism, and the consumption tax taxable products specifying automatically according to tax law filter non-taxable data.Specifically, call
The parsing of ETL engine is isolated rule extraction sales revenue data correspond to tax subject, in configuration object library type of merchandise table and
The correspondence of tax popular tourism, type of merchandise table is corresponded to tax popular tourism, and the consumption tax specifying automatically according to tax law
Taxable products filter non-taxable data.
Adjustment sales revenue data, inquiry error data, and adjust wrong data that is to say, that system provides inquiry work
Tool and adjustment in batches instrument, user easily inquires in extraction process issuable wrong data (such as using query facility
Non- taxable income from sales, the consumption tax tax items of the corresponding mistake of income from sales), then it is wrong quickly to adjust presence by adjustment in batches instrument
Sales revenue data by mistake.
Tax subject under the currently selected tissue of traversal, and travel through current tax section sales revenue data now, read
Now whether present sales amount received and the unit of assessment of current subject configuration, count into total amount, judge current tax section
Also having contract dataset, if also having, continuing traversal, otherwise, according to computing formula, the tax rate of the configuration of current tax items, and current tax
Now the unit of assessment sum counting, calculates tax liability, and counts into total unit of assessment and total tax liability, judges current
Whether also having tax subject under tissue, if having, continuing traversal, otherwise according to the tax subject total amount under current organization, meter
Calculate the tax index relevant with the consumption tax and tax liability.
Traversal consumption tax declaration form modular unit lattice, insert the data source of current calculating according to cell data source identification ID
Generate declaration form, traversal tax subject and tax section income from sales detailed data now and key index generate taxing draft.
Fig. 5 is a kind of system architecture diagram of first preferred embodiment of automatic accounting system of consumption tax of the present invention.As Fig. 5
Shown, a kind of automatic accounting system of consumption tax of the present invention, including：Tax subject set up unit 51, locally correspond to object library build
Vertical unit 52, docking unit 53, scheduling extracting unit 54, consumption tax computing unit 55, tax return signal generating unit 56.
Wherein, tax subject sets up unit 51, for setting up the tax subject related to the consumption tax, i.e. consumption tax tax items,
As included Medicated cigarette, ethanol, cosmetics, valuable jewelry and jewels and jade etc., provide maintenance interface, user can be clear and definite in tax law
One-level, two grades of sections freely configure subordinate's subject, and the formula designer providing using system now, configure the corresponding calculating of tax items
Unit and computing formula.
Locally correspond to object library and set up unit 52, for configuring the data source storehouse of marketing orientation data (Ru Mingyuan), according to
Data source storehouse and system business logic are set up and are locally corresponded to object library, and corresponding goods type, commodity income merge detailed.
Fig. 6 is locally to correspond to the detail structure chart that object library sets up unit 52 in present pre-ferred embodiments.Specifically,
Locally corresponding object library is set up unit 52 and is further included：Data source storehouse dispensing unit 520, field input block 521, object library
Set up unit 522.
Data source storehouse dispensing unit 520, the data source storehouse of configuration marketing orientation (such as sales data in the present invention), join
(database link here mainly comprises database address, manager's account, administrator's password, connection side to put database link
Formula etc.)；
Field input block 521, the corresponding type of merchandise of income from sales, commodity detail, income sequence in disposition data source storehouse
When account table, and respective field is filled according to data source storehouse；
Object library sets up unit 522, according to data source storehouse and system business logic, sets up local object library, corresponding goods
Type, commodity income merge detailed.
Docking unit 53 is corresponding with the field in object library for disposition data source storehouse field.
Scheduling extracting unit 54, for configuration data scheduler task, according to scheduler task, extracts the corresponding wealth of income from sales
Business subject data corresponds to tax popular tourism automatically, and consumption tax taxable products filtration specify automatically according to tax law is non-taxable
Data.Specifically, first against extracted data configuration schedules task, (such as task names, task is standby to fill in task essential information
Note, affiliated tissue etc.), the scheduling frequency (as daily, monthly, annual etc.) of configuration task, execute task after configuration, system is rear
Platform Automatic dispatching；System calls ETL (Extraction-Transformation-Loading) analytics engine to parse above-mentioned joining
Put rule, extract income from sales corresponding account of finance data and automatically correspond to tax popular tourism, and automatically according to tax law rule
Fixed consumption tax taxable products filter non-taxable data.
Consumption tax computing unit 55, for tax subject, the unit of account of acquisition consumption tax tax items, computing formula, the tax rate
Configuration, calculates each section unit of account now and tax liability and finally collects the calculating now of all sections of organization unit
Unit and tax liability, the key tax index such as tax bearing rate.
Tax return signal generating unit 56, according to default tax bureau declaration form template, travels through the default mark of template (tool
Body such as example mark COLID), read mark (row mark COLID) corresponding guideline code, crucial tax index is inserted correspondence
The cell of mark (row mark COLID), forms the tax return of the consumption tax
Fig. 7 is a kind of system architecture diagram of second preferred embodiment of automatic accounting system of consumption tax of the present invention.At this
Invent in the second preferred embodiment, tax subject set up unit 702, locally correspond to object library set up unit 703, docking unit
704th, scheduling extracting unit 705 is identical with the first preferred embodiment, will not be described 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 (for example
East China, South China etc.), tissue (subject of tax payment, such as Guangzhou XX trade Co., Ltd) two kinds of data, according to this
Two kinds of different data types, provide corresponding maintenance interface respectively, and user can freely configure, including but not limited to increase,
Delete, change, inquire about.
Arrange unit 706, for reading user configured organizational structure tree, according to the unique key of Taxpayer Identification Number, from
Income from sales account data after the consumption tax tax section that dynamic arrangement scheduling engine is drawn into adjustment now.
Select collection unit 707, for selecting organization unit's (such as limited public affairs of Guangzhou XX of the currently consumption tax to be adjusted
Department), receive tax computation requests, and collect the sales revenue data including current organization.
Consumption tax computing unit 708, for tax subject, the unit of account of acquisition consumption tax tax items, computing formula, the tax rate
Configuration, calculates each section unit of account now and tax liability and finally collects the calculating now of all sections of organization unit
Unit and tax liability, the key tax index such as tax bearing rate.
Tax return signal generating unit 709, according to default tax bureau declaration form template, travels through the default mark of template
(specifically such as example mark COLID), reads mark (row mark COLID) corresponding guideline code, crucial tax index is inserted
The cell of corresponding mark (row mark COLID), forms the tax return of the consumption tax.
Present invention additionally comprises taxing draft signal generating unit, conclude according to consumption tax tax items under organizational structure for reading
Sales revenue data, the field of ergodic data, the data source of the default draft template of traversal indicates and cell polymeric rule (is such as asked
Collect, average), the value after the corresponding field initial value of the sales revenue data under corresponding tax items is inserted or calculated inserts shape
Become to collect taxing draft, when user clicks on the value of polymerized unit lattice, automatically read the corresponding detailed data of current cell, real
Now penetrate detail.
Invention further preferably includes inquiry adjustment unit, for providing query facility and adjustment in batches instrument, to look into
Ask issuable wrong data (such as non-taxable income from sales, the consumption tax tax of the corresponding mistake of income from sales in extraction process
Mesh), and the sales revenue data that there is mistake is quickly adjusted by adjustment in batches instrument.
In sum, a kind of automatic accounting method of consumption tax of the present invention and system, it, by setting up organizational structure tree, is built
Vertical consumption tax tax subject is it is achieved that trans-regional inter-organization income from sales financial data is collected, and automatically corresponds to the consumption tax
Tax items, the non-taxable data (being distinguished according to product type) of automatic fitration, and quick search instrument and adjustment in batches instrument are provided, make
User conveniently finds the data that there may be mistake in the sales revenue data being drawn into, and quickly adjusts, and leads to
Cross unit of assessment, computing formula and the tax rate reading configuration in tax items, count the tax liability of income from sales under corresponding tax items,
Further calculate total tax liability under current organization, then template declared by the default tax bureau regulation consumption tax, from
Dynamic insert calculated key index and income from sales detail declares template, forms declaration form, and declaration form was calculated
The income from sales detailed data of journey, according to forming taxing draft, is truly realized taxing automatization.
Compared with prior art, the invention has the advantages that：
(1) pass through the present invention, can achieve that the income from sales automatically extracting trans-regional, inter-organization consumption tax correlation is corresponding
Account of finance data automatic sorting, and can be according to tissue to the tax popular tourism (consumption tax collection project) relevant with the consumption tax
Unit arranges to the sales revenue data automatic sorting under consumption tax tax items, greatly alleviates business taxation personnel to the consumption tax
The statistics of taxable sales revenue data and collection work, improve work efficiency.
(2) pass through quick search instrument and adjustment in batches instrument, be quickly found out in the income from sales being drawn into and there may be
Wrong data, and quickly adjust, save the evaluation work of tax staff, and improve the correctness of taxing.
(3) unit of assessment being configured by tax subject, computing formula, the tax rate, automatically calculate each tax section now
Total unit of assessment of sales revenue data and tax liability are it is achieved that automatization taxes, convenient accurate.
(4) template is declared by the default tax bureau, automatically by the consumption tax calculating critical data and key index
Insert declaration form, the key realizing declaring front taxing work generates, convenient and swift.
(5) automatically by arranging tax subject out and tax section, corresponding sales revenue data generates current taxing now
Draft, and provide and penetrate detailed functions, realize the foundation of paying taxes of tax account, really have something to base on, reduce tax risk.
Above-described embodiment only principle of the illustrative present invention and its effect, not for the restriction present invention.Any
Skilled person all can be modified to above-described embodiment and changed without prejudice under the spirit and the scope of the present invention.Therefore,
The scope of the present invention, should be as listed by claims.
Claims (10)
1. a kind of automatic accounting method of consumption tax, comprises the steps：
Step one, sets up the tax subject related to the consumption tax；
Step 2, the data source storehouse of configuration marketing orientation data, set up according to data source storehouse and system business logic and locally correspond to
Object library, corresponding goods type, commodity income merge detailed；
Step 3, disposition data source storehouse field is corresponding with the field in object library；
Step 4, configuration data scheduler task, according to scheduler task, extracts income from sales corresponding account of finance data automatically right
Tax popular tourism should be arrived；
Step 5, for tax subject, the unit of account of acquisition consumption tax tax items, computing formula, tax rate configuration, calculates each section
Now unit of account and tax liability and finally collect all sections of organization unit unit of account now and tax liability,
The key tax index such as tax bearing rate；
Step 6, according to default tax bureau declaration form template, travels through the default mark of template, reads and identify corresponding index generation
Code, inserts the crucial tax index cell of corresponding mark, forms the tax return of the consumption tax.
2. as claimed in claim 1 a kind of consumption tax automatic accounting method it is characterised in that：In step one, using system
The formula designer that system provides, the configuration corresponding unit of account of tax items and computing formula.
3. as claimed in claim 2 a kind of automatic accounting method of consumption tax it is characterised in that step 2 further includes：
Step S1, the data source storehouse of configuration marketing orientation data, configuration database links；
Step S2, account table when the corresponding type of merchandise of income from sales, commodity detail, income sequence in disposition data source storehouse, and according to
Respective field is filled in data source storehouse；
Step S3, according to data source storehouse and system business logic, sets up local object library, corresponding goods type, commodity income are closed
And it is detailed.
4. as claimed in claim 3 a kind of automatic accounting method of consumption tax it is characterised in that before step one, also wrapping
Include following steps：
Set up organizational structure tree, this organizational structure tree includes at least region, organizes two kinds of data, and is supplied to user couple
Freely the configuring of this three types data.
5. as claimed in claim 4 a kind of automatic accounting method of consumption tax it is characterised in that before step 5, also wrapping
Include：
Read user configured organizational structure tree, the consumption tax being drawn into according to Taxpayer Identification Number, automatic arranging scheduling engine
Income from sales account data after the adjustment now of tax section；
Select the organization unit of the currently consumption tax to be adjusted, receive tax computation requests, all under traversal current organization rank
Sub- rank, and collect the sales revenue data including current organization.
6. as claimed in claim 5 a kind of consumption tax automatic accounting method it is characterised in that：After step 6, also wrap
Include：
Read the sales revenue data concluded under organizational structure, the field of ergodic data according to consumption tax tax items, traversal is default
The data source of draft template indicates and cell polymeric rule, the corresponding field initial value of corresponding sales revenue data is inserted or counts
Value after calculation is inserted formation and is collected taxing draft.
7. as claimed in claim 5 a kind of automatic accounting method of consumption tax it is characterised in that the method also includes：
Query facility and adjustment in batches instrument being provided, to inquire issuable wrong data in extraction process, and passing through
Adjustment in batches instrument quickly adjusts the sales revenue data that there is mistake.
8. the automatic accounting system of a kind of consumption tax, including：
Tax subject sets up unit, for setting up the tax subject related to the consumption tax；
Locally correspond to object library and set up unit, for configuring the data source storehouse of marketing orientation data, according to data source storehouse and system
Service logic is set up and is locally corresponded to object library, and corresponding goods type, commodity income merge detailed；
Docking unit is corresponding with the field in object library for disposition data source storehouse field；
Scheduling extracting unit, for configuration data scheduler task, according to scheduler task, extracts the corresponding account of finance of income from sales
Data corresponds to tax popular tourism automatically；
Consumption tax computing unit, for tax subject, the unit of account of acquisition consumption tax tax items, computing formula, tax rate configuration, meter
Calculate each section unit of account now and tax liability and finally collect all sections of organization unit unit of account now and
Tax liability, the key tax index such as tax bearing rate；
Tax return signal generating unit, according to default tax bureau declaration form template, travels through the default mark of template, reads mark
Corresponding guideline code, inserts the crucial tax index cell of corresponding mark, forms the tax return of the consumption tax.
9. as claimed in claim 8 a kind of consumption tax automatic accounting system 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 two types
Data；
Arrange unit, for reading user configured organizational structure tree, according to Taxpayer Identification Number, automatic arranging scheduling engine is taken out
Income from sales account data after the consumption tax tax section getting adjustment now；
Select collection unit, select the organization unit of the current consumption tax to be adjusted, receive tax computation requests, and collect including working as
The sales revenue data of front tissue.
10. as claimed in claim 9 a kind of consumption tax automatic accounting system it is characterised in that：This system also includes inquiring about
Adjustment unit, for providing query facility and adjustment in batches instrument, to inquire issuable error number in extraction process
According to, and the sales revenue data that there is mistake is quickly adjusted by adjustment in batches instrument.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610810481.1A CN106447476A (en) | 2016-09-08 | 2016-09-08 | Automatic check computation method and system of consumer tax |
| CN202111188656.7A CN113902535A (en) | 2016-09-08 | 2016-09-08 | Automatic accounting method and system for consumption tax |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610810481.1A CN106447476A (en) | 2016-09-08 | 2016-09-08 | Automatic check computation method and system of consumer tax |
Related Child Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111188656.7A Division CN113902535A (en) | 2016-09-08 | 2016-09-08 | Automatic accounting method and system for consumption tax |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106447476A true CN106447476A (en) | 2017-02-22 |
Family
ID=58165391
Family Applications (2)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610810481.1A Pending CN106447476A (en) | 2016-09-08 | 2016-09-08 | Automatic check computation method and system of consumer tax |
| CN202111188656.7A Pending CN113902535A (en) | 2016-09-08 | 2016-09-08 | Automatic accounting method and system for consumption tax |
Family Applications After (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111188656.7A Pending CN113902535A (en) | 2016-09-08 | 2016-09-08 | Automatic accounting method and system for consumption tax |
Country Status (1)
| Country | Link |
|---|---|
| CN (2) | CN106447476A (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109299243A (en) * | 2018-10-31 | 2019-02-01 | 河南职业技术学院 | Financial data processing method and financial data system |
| CN109544311A (en) * | 2018-11-28 | 2019-03-29 | 优信拍（北京）信息科技有限公司 | A kind of method and apparatus of financial accounting |
| CN109801149A (en) * | 2018-12-20 | 2019-05-24 | 航天信息股份有限公司 | The method for creating tax return, device, storage medium and electronic equipment |
| CN109934545A (en) * | 2017-12-15 | 2019-06-25 | 江苏醉开心酒业有限公司 | A kind of alcohol product Product Data Management system |
| CN110119978A (en) * | 2019-05-10 | 2019-08-13 | 海闻科技有限公司 | A kind of extracting method of taxation declaration module |
| CN110929488A (en) * | 2019-11-06 | 2020-03-27 | 深圳市云智融科技有限公司 | Data processing method and related device |
| CN111199464A (en) * | 2019-12-02 | 2020-05-26 | 泰康保险集团股份有限公司 | Receipt data processing system, receipt data processing method, device, and medium |
| CN111861691A (en) * | 2020-07-24 | 2020-10-30 | 远光软件股份有限公司 | Enterprise income tax declaration method and device, storage medium and electronic equipment |
| CN112017022A (en) * | 2020-09-17 | 2020-12-01 | 中国银行股份有限公司 | Tree-shaped organization expense accounting and collecting method and device based on financial transaction |
| CN112184022A (en) * | 2020-09-29 | 2021-01-05 | 神州数码信息系统有限公司 | White spirit consumption tax risk assessment method |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116664066B (en) * | 2023-05-09 | 2023-11-14 | 三峡高科信息技术有限责任公司 | Method and system for managing enterprise planning income and actual income |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103049874A (en) * | 2012-12-18 | 2013-04-17 | 北京税恒科技有限公司 | Enterprise taxation control platform and enterprise taxation control method |
| CN103106614A (en) * | 2013-02-07 | 2013-05-15 | 广东源恒软件科技有限公司 | Final settlement platform for enterprise |
| CN103106754A (en) * | 2012-12-27 | 2013-05-15 | 北京税恒科技有限公司 | Tax accounting control platform and method |
| CN104978685A (en) * | 2015-07-03 | 2015-10-14 | 广东源恒软件科技有限公司 | Tax account book automatic generating method and system |
-
2016
- 2016-09-08 CN CN201610810481.1A patent/CN106447476A/en active Pending
- 2016-09-08 CN CN202111188656.7A patent/CN113902535A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103049874A (en) * | 2012-12-18 | 2013-04-17 | 北京税恒科技有限公司 | Enterprise taxation control platform and enterprise taxation control method |
| CN103106754A (en) * | 2012-12-27 | 2013-05-15 | 北京税恒科技有限公司 | Tax accounting control platform and method |
| CN103106614A (en) * | 2013-02-07 | 2013-05-15 | 广东源恒软件科技有限公司 | Final settlement platform for enterprise |
| CN104978685A (en) * | 2015-07-03 | 2015-10-14 | 广东源恒软件科技有限公司 | Tax account book automatic generating method and system |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109934545A (en) * | 2017-12-15 | 2019-06-25 | 江苏醉开心酒业有限公司 | A kind of alcohol product Product Data Management system |
| CN109299243A (en) * | 2018-10-31 | 2019-02-01 | 河南职业技术学院 | Financial data processing method and financial data system |
| CN109544311A (en) * | 2018-11-28 | 2019-03-29 | 优信拍（北京）信息科技有限公司 | A kind of method and apparatus of financial accounting |
| CN109801149A (en) * | 2018-12-20 | 2019-05-24 | 航天信息股份有限公司 | The method for creating tax return, device, storage medium and electronic equipment |
| CN110119978A (en) * | 2019-05-10 | 2019-08-13 | 海闻科技有限公司 | A kind of extracting method of taxation declaration module |
| CN110929488B (en) * | 2019-11-06 | 2023-12-26 | 深圳市云智融科技有限公司 | Data processing method and related device |
| CN110929488A (en) * | 2019-11-06 | 2020-03-27 | 深圳市云智融科技有限公司 | Data processing method and related device |
| CN111199464A (en) * | 2019-12-02 | 2020-05-26 | 泰康保险集团股份有限公司 | Receipt data processing system, receipt data processing method, device, and medium |
| CN111199464B (en) * | 2019-12-02 | 2023-06-30 | 泰康保险集团股份有限公司 | Processing system of collection data, processing method, device and medium of collection data |
| CN111861691A (en) * | 2020-07-24 | 2020-10-30 | 远光软件股份有限公司 | Enterprise income tax declaration method and device, storage medium and electronic equipment |
| CN112017022A (en) * | 2020-09-17 | 2020-12-01 | 中国银行股份有限公司 | Tree-shaped organization expense accounting and collecting method and device based on financial transaction |
| CN112017022B (en) * | 2020-09-17 | 2023-11-21 | 中国银行股份有限公司 | Tree organization expense accounting and collecting method and device based on financial transaction |
| CN112184022A (en) * | 2020-09-29 | 2021-01-05 | 神州数码信息系统有限公司 | White spirit consumption tax risk assessment method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113902535A (en) | 2022-01-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106447476A (en) | Automatic check computation method and system of consumer tax | |
| Ebrill et al. | The modern VAT | |
| US7966231B2 (en) | System and method for calculating taxes and multi-currency pricing | |
| Robinson | The USDA/ERS computable general equilibrium (CGE) model of the United States | |
| US20160104252A1 (en) | System and method for intelligent classification of data | |
| CN106169152A (en) | The automatic accounting method of a kind of value-added tax and system | |
| US20180108000A1 (en) | Systems and methods for generating aggregated merchant analytics for a geographic sector using tip data | |
| CN109447769A (en) | A kind for the treatment of method and apparatus of financial data | |
| CN106384275A (en) | Land increment tax automatic accounting method and system | |
| CN111026801A (en) | Method and system for assisting operation quick decision-making work of insurance type e-commerce | |
| Giles | Low income measurement in Canada | |
| CN109598631B (en) | Method and system for generating human resource outsourcing client bill based on social security policy | |
| CN106447478A (en) | Automatic check computation method and system of corporate income tax | |
| CN106169156A (en) | The automatic accounting method of a kind of vehicle-purchase tax and system | |
| Murdihardjo et al. | Implementing INTACS Dynamics Enterprise Resources Planning System for Financial Statements | |
| US10564990B1 (en) | Interactive budget display including dynamically adjustable budget elements | |
| CN106384276A (en) | Deed tax automatic checking method and system | |
| CN106169154A (en) | The automatic accounting method of a kind of tariff and system | |
| CN106339936A (en) | Automatic accounting method of resource tax and system thereof | |
| CN106169153A (en) | The automatic accounting method of a kind of stamp tax and system | |
| US20030018548A1 (en) | System for economic-financial planning | |
| CN106447479A (en) | Method and system for automatically accounting housing property tax | |
| CN106384278A (en) | Vehicle and vessel tax automatic accounting method and system | |
| US20150149334A1 (en) | Transfer Pricing Systems and Methods | |
| US7418415B1 (en) | Object-oriented representation of a generic profitability rule for financial processing in a relational database management system |
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: 20170222 |