CN105678516A - Electronic form processing method - Google Patents
Electronic form processing method Download PDFInfo
- Publication number
- CN105678516A CN105678516A CN201511033718.1A CN201511033718A CN105678516A CN 105678516 A CN105678516 A CN 105678516A CN 201511033718 A CN201511033718 A CN 201511033718A CN 105678516 A CN105678516 A CN 105678516A
- Authority
- CN
- China
- Prior art keywords
- list
- electronic spreadsheet
- module
- processing method
- electronic
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- 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/125—Finance or payroll
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- Development Economics (AREA)
- General Physics & Mathematics (AREA)
- Technology Law (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Data Mining & Analysis (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
An electronic form processing method provided by the present invention comprises the following steps of S1, using a form manufacturing module to collect the data needed to fill a form, manufacturing an electronic form, and sending the electronic form to a form reception module according to the form need; S2 using the form reception module to receive the electronic form, and verifying the content of the electronic form; S3 using a form returning module to return a processing result of the electronic form passing the content verification to a terminal form filling device. The present invention provides a tax form service system which can realize the paperless office, and enables the tax office efficiency to be improved greatly. By the terminal form filling device provided by the present invention, the manufacturing of the tax electronic form can be realized, thereby effectively substituting for and saving the window labor resources, and improving the safety and the humanization.
Description
Technical field
The present invention relates to electronic information management field, more particularly to a kind of electronic spreadsheet processing method.
Background technology
The making of existing tax form, transmission process are all manual operations, it is necessary to people's self manufacture, confirm and be sent to relevant department's examination & verification, complicated operation and losing time, and are unfavorable for the demand that electronic information is handled official business. Tax staff, when tax bureau etc. handles the tax, will arrive each different department and process, bothersome effort, and the tax form project filled in is various, once fills out mistake and is accomplished by doing over again back and forth, wastes time and energy.
And, the Taxation Work personnel of revenue department are when transacting business, it is also required to paper office, the tax form doing the paper that tax personnel submit to is processed, and return result by the mode of paper, office efficiency is relatively low, and wastes substantial amounts of time and manpower, is unfavorable for the propelling of Intelligent office.
Summary of the invention
The present invention is to solve the operating process of existing tax form mentioned above because being the shortcoming wasted time and energy that causes of manual operation, it is provided that a kind of tax form service system, it is capable of non-support cable, greatly improves the efficiency of tax office.
Specifically, the present invention also provides for a kind of electronic spreadsheet processing method, and it comprises the following steps:
S1, list make module collection list and fill in required metadata, call one or more submeter list, each submeter list is split into one or more Form Element, according to different business demands, one or multiple Form Element are integrated into the electronic spreadsheet needed for this business, described metadata is inserted described electronic spreadsheet, completes the making of described electronic spreadsheet;
S2, list receiver module receive the electronic spreadsheet completed, according to predetermined ordering rule, the described electronic spreadsheet received is ranked up, and the content of the described electronic spreadsheet received is verified, wherein, the checking of the content of described electronic spreadsheet includes: the checking that the one comprise described electronic spreadsheet or multiple Form Element carry out; And to the checking that the relatedness between one or multiple Form Element carries out;And
S3, list return module and pass back through the result of electronic spreadsheet of content verification to terminal device of filling in a form.
Preferably, S1 is further comprising the steps of:
S11, described terminal fill in a form device collect user input magnetic signal, it is thus achieved that user input content, thus obtaining list to fill in required described metadata;
S12, described list make module and obtain magnetic signal and the track that inputs according to described terminal device of filling in a form, and form the dot matrix image of magnetic signal and are loaded into inside electronic spreadsheet, completing the making of described electronic spreadsheet;
The identity of user is verified confirming by S13, identity validation module; And
Described electronic spreadsheet is transmitted to described list receiver module by S14, list sending module in the way of encrypting traffic, and the file format of described electronic spreadsheet includes one or more in XML format, CSV form, txt form, EXCEL form and html format.
Preferably, by the regular expression that each table element is default in S2, the content filled in is verified, completes the checking of each Form Element;
By form set in advance rule, check whether the logical relation between one or more Form Element is set up, complete the correlating validation between one or more Form Element.
Preferably, S12 comprises the following steps:
S121, list contents acquiring unit obtain list and fill in required magnetic signal;
S122, list call unit call one or more submeter list, and one or more submeter list is split into one or more Form Element, according to different business demands, one or multiple Form Element are integrated into the electronic spreadsheet needed for this business; And
S123, list are filled in unit and are obtained the track of magnetic signal input, form the dot matrix image of magnetic signal and be loaded into the inside of described electronic spreadsheet, form the data file of corresponding document form, and list, list item name and list item value are preserved, complete the making of electronic spreadsheet.
Preferably, in S13, it is one or more that authenticating step includes in three below step:
S131, by identity document reader, read the identity information of user;
S132, according to fill in a form from the terminal track of device magnetic signal input and the pressure sensitivity of magnetic pen, obtain the signature to user and carry out the confirmation of former person's handwriting confirmation; And
S133, by fingerprint capturer gather user finger print information.
Preferably, in S11, described terminal device of filling in a form chooses list by receiving touch signal, and inputs list fill in required metadata by receiving magnetic signal.
Preferably, S12 also includes the time sequencing that form number unit completes according to list the list completed is numbered, according to number order, multiple lists are processed for relevant functional department.
Preferably, S13 is also included key production module after user completes identity validation, formed and the list completed electronic key one to one.
Preferably, described list sending module utilizes electronic key as the key of AES, uses AES that submitted electronic spreadsheet is encrypted.
Preferably, also including remote monitoring terminal and obtain the electronic spreadsheet that described list making module making completes, and carry out described electronic spreadsheet checking and feedback result, wherein, described remote monitoring terminal makes module communication with described list and is connected.
Preferably, described electronic spreadsheet includes the one in tax form and finance list or two kinds.
Advantages of the present invention is as described below:
The present invention provides a kind of electronic spreadsheet processing method, and it is capable of non-support cable, greatly improves the efficiency of office. Filled in a form device by terminal provided by the invention, it is possible to realize the making of electronic spreadsheet, effectively substitute and save window human resources, and improving safety and hommization. Setting up the more industry of service window, such as medical institutions, government organs etc., the client of these mechanisms is operated by self-service terminal equipment in this Institution Services hall or hall, can reduce stand queuing and waiting time, is conducive to the satisfaction of efficiency and the client improving transacting business.
And it is provided with and remotely teaches function, can dock with long-range contact staff online, the electronic spreadsheet that user is remotely made by request contact staff is audited, it is ensured that user can be once successful when making electronic spreadsheet, saves and again handles time, material resources and the manpower wasted.
Accompanying drawing explanation
Fig. 1 is the structural schematic block diagram of the electronic watch uniprocesser system of the present invention;
Fig. 2 is the structural schematic block diagram of the list making module of the present invention;
Fig. 3 is the workflow schematic diagram of the present invention;
Fig. 4 is the flow chart that list of the present invention makes; And
Fig. 5 is that the terminal of the present invention is filled in a form the structural representation of device.
Detailed description of the invention
Below in conjunction with accompanying drawing and detailed description of the invention, the present invention is further explained:
The present invention provides a kind of electronic watch uniprocesser system, and it includes user terminal and functional department's terminal. user terminal completes the relative production of electronic spreadsheet for user, user needs the business handled in user terminal selecting, system can call corresponding electronic spreadsheet automatically, user inputs relevant information on electronic spreadsheet and completes the making of electronic spreadsheet, and after the electronic spreadsheet completed is preserved, according to the type of service that user handles, the electronic spreadsheet completed is sent to functional department's terminal of corresponding functional government departments, after the electronic spreadsheet doing tax personnel is processed by staff in function departmental terminals, the result of return electron list.
User is when making list, can dock with long-range contact staff online, the electronic spreadsheet that user is remotely made by request contact staff is audited, it is ensured that user can be once successful when making electronic spreadsheet, saves and again handles time, material resources and the manpower wasted.
Form processing system:
The present invention provides a kind of electronic watch uniprocesser system, as it is shown in figure 1, it terminal including mutual communication connection is filled in a form, device 1, list make module 2, identity validation module 3, list sending module 4 and list receiver module 7 for it.
Terminal fills in a form device 1 for inputting list relevant information, does, to enter, the electronic spreadsheet that tax needs, and completes the input that electronic spreadsheet makes the information of needs, completes the input service of list relevant information, to facilitate the making to electronic spreadsheet, it is achieved teleworking.
Terminal device 1 of filling in a form chooses list by receiving touch signal, and inputs list fill in required metadata by receiving magnetic signal.
List makes module 2 for calling corresponding list according to the fill in a form list relevant information of device 1 input of terminal and complete list and make.
As shown in Figure 2, list makes module 2 and includes list contents acquiring unit 200, list call unit 201 and list fill in unit 202, list contents acquiring unit 200 obtains list and fills in required metadata, list call unit 201 calls one or more submeter list, and one or more submeter lists are split into multiple Form Element, according to different business demand, multiple Form Elements are integrated into the electronic spreadsheet needed for this business, list is filled in unit 202 and is obtained the track of magnetic signal input, and the dot matrix image forming magnetic signal is loaded into inside electronic spreadsheet, complete the making of electronic spreadsheet.
Identity validation module 3, for being verified confirming to the identity of the people that fills in a form, confirms to carry out identity validation on the list completed especially by signature, fingerprint identification and identity document. Process for tax affairs, above-mentioned three kinds of identity validation modes all should carry out, and for some occasions, it is possible to only select one of which or two kinds. Preferably, described identity document can be such as identity card, passport, driving license, social security card etc. according to regulation and the needs of issued transaction occasion, and correspondingly, identity document reader is the reader being suitable for respective identity certificate.
Identity validation module 3 includes identity document confirmation unit, Signature Confirmation unit and fingerprint identification unit.
Identity document confirmation unit passes through identity document reader, reads the identity information of user, and Signature Confirmation unit, according to fill in a form from the terminal track of device magnetic signal input and the pressure sensitivity of magnetic pen, obtains the signature to user and carries out the confirmation of former person's handwriting confirmation; Fingerprint identification unit gathers the finger print information of user by fingerprint capturer.
Identity validation module 3 also includes key production module 6, for being formed and the electronic spreadsheet electronic key one to one that manufactured after user completes identity validation, user is facilitated by electronic key, staff's result to electronic spreadsheet and process progress to be inquired about. In all the other embodiments, do tax personnel and can also directly utilize China second-generation identity card part and serve as electronic key, staff's result to electronic spreadsheet and process progress are inquired about.
List sending module 4 sends the list completed in the way of encrypting traffic to relevant tax department, in order to the tax form doing tax personnel submission is audited by the Taxation Work personnel of relevant tax department.
List sending module 4 utilizes electronic key as the key of AES, uses AES that submitted electronic spreadsheet is encrypted.
The file format of electronic spreadsheet includes one or more in XML format, CSV form, txt form, EXCEL form and html format.
Further, it also includes form number module 5, for the electronic spreadsheet completed is numbered, multiple electronic spreadsheets are processed according to number order for relevant tax department, the multiple electronic spreadsheets that need not do identical revenue department corresponding to tax personnel are numbered by form number module 5 according to time sequencing, namely be equivalent to the queuing mechanism of papery office, facilitate Taxation Work personnel that multiple identical services electronic spreadsheets doing tax personnel are processed sequentially in time. Further, it also includes form number print module, for the numbering of the list that printing and making completes, conveniently does tax personnel and checks the sequence of oneself.
List receiver module 7 receives the electronic spreadsheet completed, according to predetermined ordering rule, the electronic spreadsheet received is ranked up, and the content of the electronic spreadsheet received is verified, wherein, the checking of the content of electronic spreadsheet includes: the checking that the one that electronic spreadsheet is comprised or multiple Form Element carry out; And to the checking that the relatedness between one or more Form Element carries out. Predetermined ordering rule is the number order of electronic spreadsheet.
The content filled in has been verified the checking of single Form Element by list receiver module 7 by the regular expression that each table element is default; By form set in advance rule, check whether the logical relation between multiple Form Element has set up the correlating validation between multiple Form Element.
Further, also include list and return module 8, for returning staff's result to list, by electronic key, the result of list is checked for user, if the electronic spreadsheet of user is undesirable, user can again make electronic spreadsheet and submit to.
Further, also including remote monitoring terminal 6 and obtain the electronic spreadsheet that list making module making completes, and carry out electronic spreadsheet checking and feedback result, wherein, remote monitoring terminal 6 makes module communication with list and is connected.
If user needs to obtain remote guide, namely the making of the electronic spreadsheet of the business completing oneself to handle correct within the fastest time is wished, then can pass through to connect remote monitoring terminal, online communication is carried out with the staff of remote monitoring terminal, and the electronic spreadsheet made is sent to remote monitoring terminal, the correctness of the request staff electronic spreadsheet to making checks, after staff has checked, can to the result doing tax personnel's feedback electronic list, for doing the staff issuing revenue department after electronic spreadsheet is modified by tax personnel again, to guarantee once to handle successfully, avoid repeatedly handling the time brought, the waste of manpower and material resources.
In the present invention, electronic spreadsheet can be one or more of tax form, finance list or other lists, can complete the making of different electronic spreadsheet as required and complete.
Electronic spreadsheet processing method:
S1, list making module 2 is collected list and is filled in required metadata, call one or more submeter list, each submeter list is split into one or more Form Element, according to different business demands, one or multiple Form Element are integrated into the electronic spreadsheet needed for this business, described metadata is inserted described electronic spreadsheet, completes the making of described electronic spreadsheet.
Specifically, terminal fill in a form device 1 collect user input magnetic signal, it is thus achieved that user input content, thus obtaining list to fill in required metadata.
List makes module 2 and obtains magnetic signal and the track that inputs according to terminal device 1 of filling in a form, and forms the dot matrix image of magnetic signal and is loaded into inside electronic spreadsheet, completing the making of electronic spreadsheet.
The step that list making module 2 makes electronic spreadsheet is as follows:
List contents acquiring unit 200 obtains list and fills in required metadata, list call unit 201 calls one or more submeter list, and one or more submeter lists are split into multiple Form Element, according to different business demand, multiple Form Elements are integrated into the electronic spreadsheet needed for this business, list is filled in unit 202 and is obtained the track of magnetic signal input, and the dot matrix image forming magnetic signal is loaded into inside electronic spreadsheet, complete the making of electronic spreadsheet.
The identity of user is verified confirming by identity validation module 3. Identity validation module 3 includes identity document confirmation unit 31, Signature Confirmation unit 32 and fingerprint identification unit 33.
Identity document confirmation unit 31, by identity document reader, reads the identity information of user, the pressure sensitivity of the Signature Confirmation unit 32 track according to device magnetic signal input of filling in a form from terminal and magnetic pen, obtains the signature to user and carries out the confirmation of former person's handwriting confirmation; Fingerprint identification unit 33 gathers the finger print information of user by fingerprint capturer.
Electronic spreadsheet is transmitted to list receiver module 7 by list sending module 4 in the way of encrypting traffic, and the file format of electronic spreadsheet includes one or more in XML format, CSV form, txt form, EXCEL form and html format.
S2, list receiver module 7 receive the electronic spreadsheet completed, according to predetermined ordering rule, the described electronic spreadsheet received is ranked up, and the content of the electronic spreadsheet received is verified, wherein, the checking of the content of electronic spreadsheet includes: the checking that the one that electronic spreadsheet is comprised or multiple Form Element carry out; And to the checking that the relatedness between one or more Form Element carries out.
The content filled in has been verified the checking of single Form Element by list receiver module 7 by the regular expression that each table element is default;By form set in advance rule, check whether the logical relation between multiple Form Element has set up the correlating validation between multiple Form Element.
S3, list return module and pass back through the result of electronic spreadsheet of content verification to terminal device of filling in a form.
Terminal is filled in a form device:
Explain below in conjunction with Fig. 5 terminal filled in a form structure of device 1:
Terminal device 1 of filling in a form includes a casing 10 and is arranged on the bracing frame 11 bottom casing 10, and the upper surface of casing 10 is set to an inclined-plane 12, and an end at casing 10 top is provided with baffle plate 13, is provided with a platform 14 between inclined-plane 12 and baffle plate 13. In the present embodiment, bracing frame 11 can be roller or universal wheel, and convenient device 1 that terminal is filled in a form moves.
Being provided with touch display screen 15 on inclined-plane 12, be used for providing display and touch controllable function, it includes the capacitor layers for sensing touch signal and for sensing the magnetosphere of the magnetic signal of magnetic pen, receives touch signal and magnetic signal respectively.
Touching display screen 15 and be connected to a magnetic pen 16, magnetic pen 16 is arranged on the side touching display screen 15, and the side touching display screen 15 is disposed with scanner 17, fingerprint-collection device 18 and identity document reader 19. Magnetic pen 16 can be signed at display, it is achieved with no paper signature function, and inputs magnetic signal, completes list manufacturing process.
In the present embodiment, on the side touching display screen 15, scanner 17, fingerprint-collection device 18 and identity document reader 19 can be arranged up and down or can be arranged side by side. Offering groove on touch display screen 15 side on inclined-plane 12, scanner 17 is flat bed scanner in the present embodiment, and the flat board of scanner 17 is embedded in a groove.
Scanner 17 is when some business handling needs offer data, it is possible to the data of relevant certificate is submitted in scanning to.
Fingerprint-collection device 18 is fingerprint storehouse in the present embodiment, and for gathering the fingerprint of transactor, the convenient finger print information to transactor confirms.
Identity document reader 19 is China second-generation identity card part reader, and identity document can be scanned by it, for collecting or authenticating identity certificate information.
Being provided with high-definition camera 20 on baffle plate 13, casing 10 is internally provided with printer 21, and the exit slot of printer 21 is arranged on platform 14. To some service needed photo, high-definition camera 20 can shoot, and some service needed shooting video, user all operations can be carried out complete monitoring by high-definition camera 20. Business handling can be provided corresponding voucher by printer 21.
Outer surface on casing 10 is provided with the PORT COM 22 for connecting external device (ED), PORT COM 22USB socket, it is possible to insert USB device, as the external accessories such as U-KEY, tax control tray and tax disc carry out data input.
Outer surface on casing 10 is additionally provided with for sensing the human body sensing device 23 whether someone operates, can detect whether that people is using operation, if there being people using operation, display is transformed into business operation interface, using operation without people, LCDs play operation instructs or ad content. In the present embodiment, human body sensing device 23 is infrared inductor.
Baffle plate 11 is additionally provided with relay indicating light 26, when device 1 is fault-free if terminal is filled in a form, it is possible to normally use, is shown as " normally using "; If terminal is filled in a form, device 1 is to break down, can not normally use, it is shown as " suspend and use ", user can in remote position it is known that terminal is filled in a form the state of device 1, do not have user operate terminal fill in a form device 1 time, just discovery terminal is filled in a form the situation that device 1 breaks down.
Casing 1 is additionally provided with the loudspeaker 24 for improving sound prompt function and for providing the mike 25 of dialogue function.
Casing 10 place inside is disposed with paper storehouse, printer and main control computer by fixing device.
High-definition camera 20, human body sensing device 23, touch display screen 15, scanner 17, fingerprint-collection device 18, identity document reader 19 and relay indicating light 26 are connected with main control computer 27 communication respectively.
It is further explained for the operation principle to the present invention that processes of tax electronic spreadsheet below:
Terminal device 1 of filling in a form inputs list relevant information. Terminal fills in a form device 1 by receiving touch signal to choose certain list and by receiving magnetic signal to input list relevant information.
List makes module 2 and calls corresponding list according to the fill in a form list relevant information of device input of terminal and complete list and make, and the list completed is numbered, according to number order, multiple lists is processed for relevant tax department.
The identity of the people that fills in a form is verified confirming by identity validation module 3, confirms to carry out identity validation on the list completed in particular by signature, fingerprint identification and identity document. Key production module is doing the tax form electronic key one to one being formed after tax personnel complete identity validation and having manufactured.
List sending module 4 sends the list completed to relevant tax department. if user needs to obtain remote guide, then can pass through to connect remote monitoring terminal, online communication is carried out with the staff of remote monitoring terminal, and the electronic spreadsheet made is sent to remote monitoring terminal, the correctness of the request staff electronic spreadsheet to making checks, after staff has checked, can to the result doing tax personnel's feedback electronic list, for doing the staff issuing revenue department after electronic spreadsheet is modified by tax personnel again, to guarantee once to handle successfully, avoid repeatedly handling the time brought, the waste of manpower and material resources.
List receiver module 7 receives the electronic spreadsheet completed, according to predetermined ordering rule, the described electronic spreadsheet received is ranked up, and the content of the electronic spreadsheet received is verified, wherein, the checking of the content of electronic spreadsheet includes: the checking that the one that electronic spreadsheet is comprised or multiple Form Element carry out; And to the checking that the relatedness between one or more Form Element carries out.
List returns module 8 and returns the Taxation Work personnel result to list, the result of list is checked by electronic key for doing tax personnel, if the electronic spreadsheet doing tax personnel is undesirable, does tax personnel and can again make electronic spreadsheet and submit to.
Result print module prints receipt and does the tax personnel result to list. If doing the tax electronic spreadsheet that tax personnel fill in not meet demand, then do tax personnel and can again make tax electronic spreadsheet.
Tax form service system provided by the invention can carry out opening Individual Income Tax dutiable certificate, individual faces the Shang dynasty and draws a bill, individual's stamp tax is declared and is replaced, vehicle and vessel tax (scraps) refund, vehicle and vessel tax (stolen) is refunded, VAT invoice needs the additional expenses of taxation paid, Individual Income Tax 120,000 declares (need to pay arrears), face business make out an invoice collect taxes by mistake money refund, the detailed account of unit social security payment prints, insured people applies for printing record of paying the fees in person, in paying entity application printing note unit, a certain personnel pay the fees record, individual application abandons social security expense arrearage, in unit, individual pays clearly social security expense, vehicle and vessel tax dutiable certificate, individual's new-energy automobile vehicle and vessel tax deduction and exemption, individual's new-energy automobile vehicle and vessel tax tax refund deduction and exemption, Local Tax Bureau of inquiry (replacement) Guangdong Province online password of Individual Income Tax, individual application opens vehicle and vessel tax " tax revenue dutiable certificate ", increment title tax declares (on the other hand the commercial house), individual's second-hand house transfer, individual inherits house property, individual gifts house property, man and wife divorces house property right alteration and man and wife removes Taxation Works such as deduction and exemption contract tax.
Although the present invention is based on the improvement that the demand of Taxation Work is made, but the present invention has general applicability, it is not limited only to be applied in the process of tax form, but can be applied in that bank, hospital, entry-exit management office, customs, building management office, vehicle management office etc. are various to be needed to fill in list and carry out the administration of identity validation or commerce transactions handles occasion. And significantly simplify working flow process by this system, promote efficiency of service.
Last it is noted that above-described each embodiment is merely to illustrate technical scheme, it is not intended to limit; Although the present invention being described in detail with reference to previous embodiment, it will be understood by those within the art that: the technical scheme described in previous embodiment still can be modified by it, or wherein part or all of technical characteristic is carried out equivalent replacement; And these amendments or replacement, do not make the essence of appropriate technical solution depart from the scope of various embodiments of the present invention technical scheme.
Claims (11)
1. an electronic spreadsheet processing method, it is characterised in that: it comprises the following steps:
S1, list make module collection list and fill in required metadata, call one or more submeter list, each submeter list is split into one or more Form Element, according to different business demands, one or multiple Form Element are integrated into the electronic spreadsheet needed for this business, described metadata is inserted described electronic spreadsheet, completes the making of described electronic spreadsheet;
S2, list receiver module receive the electronic spreadsheet completed, according to predetermined ordering rule, the described electronic spreadsheet received is ranked up, and the content of the described electronic spreadsheet received is verified, wherein, the checking of the content of described electronic spreadsheet includes: the checking that the one comprise described electronic spreadsheet or multiple Form Element carry out; And to the checking that the relatedness between one or multiple Form Element carries out; And
S3, list return module and pass back through the result of electronic spreadsheet of content verification to terminal device of filling in a form.
2. electronic spreadsheet processing method according to claim 1, it is characterised in that: S1 is further comprising the steps of:
S11, described terminal fill in a form device collect user input magnetic signal, it is thus achieved that user input content, thus obtaining list to fill in required described metadata;
S12, described list make module and obtain magnetic signal and the track that inputs according to described terminal device of filling in a form, and form the dot matrix image of magnetic signal and are loaded into inside electronic spreadsheet, completing the making of described electronic spreadsheet;
The identity of user is verified confirming by S13, identity validation module; And
Described electronic spreadsheet is transmitted to described list receiver module by S14, list sending module in the way of encrypting traffic, and the file format of described electronic spreadsheet includes one or more in XML format, CSV form, txt form, EXCEL form and html format.
3. electronic spreadsheet processing method according to claim 1, it is characterised in that: by the regular expression that each table element is default in S2, the content filled in is verified, completes the checking of each Form Element;
By form set in advance rule, check whether the logical relation between one or more Form Element is set up, complete the correlating validation between one or more Form Element.
4. electronic spreadsheet processing method according to claim 2, it is characterised in that: S12 comprises the following steps:
S121, list contents acquiring unit obtain list and fill in required magnetic signal;
S122, list call unit call one or more submeter list, and one or more submeter list is split into one or more Form Element, according to different business demands, one or multiple Form Element are integrated into the electronic spreadsheet needed for this business; And
S123, list are filled in unit and are obtained the track of magnetic signal input, form the dot matrix image of magnetic signal and be loaded into the inside of described electronic spreadsheet, form the data file of corresponding document form, and list, list item name and list item value are preserved, complete the making of electronic spreadsheet.
5. electronic spreadsheet processing method according to claim 2, it is characterised in that: in S13, it is one or more that authenticating step includes in three below step:
S131, by identity document reader, read the identity information of user;
S132, according to fill in a form from the terminal track of device magnetic signal input and the pressure sensitivity of magnetic pen, obtain the signature to user and carry out the confirmation of former person's handwriting confirmation; And
S133, by fingerprint capturer gather user finger print information.
6. electronic spreadsheet processing method according to claim 2, it is characterised in that: in S11, described terminal device of filling in a form chooses list by receiving touch signal, and inputs list fill in required metadata by receiving magnetic signal.
7. electronic spreadsheet processing method according to claim 2, it is characterized in that: S12 also includes the time sequencing that form number unit completes according to list the list completed is numbered, according to number order, multiple lists are processed for relevant functional department.
8. electronic spreadsheet processing method according to claim 2, it is characterised in that: S13 is also included key production module after user completes identity validation, formed and the list completed electronic key one to one.
9. electronic spreadsheet processing method according to claim 6, it is characterised in that: described list sending module utilizes electronic key as the key of AES, uses AES that submitted electronic spreadsheet is encrypted.
10. electronic spreadsheet processing method according to any one of claim 1 to 9, it is characterized in that: also include remote monitoring terminal and obtain the electronic spreadsheet that described list making module making completes, and carry out checking and feedback result to described electronic spreadsheet, wherein, described remote monitoring terminal is connected with described list making module communication.
11. electronic spreadsheet processing method according to any one of claim 1 to 9, it is characterised in that described electronic spreadsheet includes the one in tax form and finance list or two kinds.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511033718.1A CN105678516A (en) | 2015-12-31 | 2015-12-31 | Electronic form processing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511033718.1A CN105678516A (en) | 2015-12-31 | 2015-12-31 | Electronic form processing method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105678516A true CN105678516A (en) | 2016-06-15 |
Family
ID=56298650
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201511033718.1A Pending CN105678516A (en) | 2015-12-31 | 2015-12-31 | Electronic form processing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105678516A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107133863A (en) * | 2017-04-27 | 2017-09-05 | 广东金赋科技股份有限公司 | Do tax system and do tax method |
| CN107357913A (en) * | 2017-07-19 | 2017-11-17 | 微鲸科技有限公司 | Multiple terminals collaboration list filling method and for realizing its terminal |
| CN109934692A (en) * | 2017-12-19 | 2019-06-25 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus for automatically generating the voucher that liquidates |
| CN110942567A (en) * | 2019-11-29 | 2020-03-31 | 中国建设银行股份有限公司 | Self-service equipment data processing method, device and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN201922651U (en) * | 2011-01-27 | 2011-08-10 | 昆山天导计算机有限公司 | Intelligent printing equipment for business form |
| CN103106186A (en) * | 2013-01-22 | 2013-05-15 | 百度在线网络技术（北京）有限公司 | Form verification method and form verification system |
| CN103295306A (en) * | 2012-02-27 | 2013-09-11 | 东莞电子科技大学电子信息工程研究院 | Fixed intelligent business quick processing terminal |
| CN103544136A (en) * | 2012-07-09 | 2014-01-29 | 上海博路信息技术有限公司 | Method for automatically inputting form |
| CN103778234A (en) * | 2014-01-26 | 2014-05-07 | 北京恒华伟业科技股份有限公司 | Report form generating method and device |
-
2015
- 2015-12-31 CN CN201511033718.1A patent/CN105678516A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN201922651U (en) * | 2011-01-27 | 2011-08-10 | 昆山天导计算机有限公司 | Intelligent printing equipment for business form |
| CN103295306A (en) * | 2012-02-27 | 2013-09-11 | 东莞电子科技大学电子信息工程研究院 | Fixed intelligent business quick processing terminal |
| CN103544136A (en) * | 2012-07-09 | 2014-01-29 | 上海博路信息技术有限公司 | Method for automatically inputting form |
| CN103106186A (en) * | 2013-01-22 | 2013-05-15 | 百度在线网络技术（北京）有限公司 | Form verification method and form verification system |
| CN103778234A (en) * | 2014-01-26 | 2014-05-07 | 北京恒华伟业科技股份有限公司 | Report form generating method and device |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107133863A (en) * | 2017-04-27 | 2017-09-05 | 广东金赋科技股份有限公司 | Do tax system and do tax method |
| CN107357913A (en) * | 2017-07-19 | 2017-11-17 | 微鲸科技有限公司 | Multiple terminals collaboration list filling method and for realizing its terminal |
| CN109934692A (en) * | 2017-12-19 | 2019-06-25 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus for automatically generating the voucher that liquidates |
| CN109934692B (en) * | 2017-12-19 | 2022-02-01 | 北京京东尚科信息技术有限公司 | Method and device for automatically generating hedge certificates |
| CN110942567A (en) * | 2019-11-29 | 2020-03-31 | 中国建设银行股份有限公司 | Self-service equipment data processing method, device and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20050091325A1 (en) | Information providing system | |
| CN102592373B (en) | Self-service tax system and application method thereof | |
| US20050289059A1 (en) | Apparatus, system, and method for presenting a document image together with a manual signature | |
| US20050273425A1 (en) | Acceptance/reception separating system in financial institution | |
| CN102176267A (en) | Client self-service processing equipment as well as self-service authority authentication system and method | |
| US20110264572A1 (en) | Enabling remote financial transactions | |
| CN105678516A (en) | Electronic form processing method | |
| JP2017091012A (en) | Business support system, business support server, business support method and banking operation processing method | |
| US20070114273A1 (en) | Transaction cooperation method in branch office system | |
| CN108898481B (en) | Method and device for processing counter service | |
| CN110069761A (en) | A kind of bank self-aid apparatus fills out single method and device | |
| CN205334474U (en) | Electronic spreadsheet terminal device of filling in a form | |
| CN205486098U (en) | Electronic spreadsheet processing system | |
| CN201955846U (en) | Customer self-service processing equipment and self-service authorized certification system | |
| CN101996452A (en) | Transaction support method | |
| CN105701079A (en) | Electronic form processing system | |
| WO2013098851A2 (en) | A system for processing visa applications | |
| RU90920U1 (en) | TERMINAL FOR REMOTE IMPLEMENTATION OF SERVICES | |
| CN213092431U (en) | Self-service terminal | |
| RU161477U1 (en) | SELF-SERVICE TERMINAL | |
| JP6911886B2 (en) | Electronics | |
| CN207833636U (en) | Self-help terminal equipment | |
| JP2008083823A (en) | Contract acceptance terminal and contract system | |
| JP7306431B2 (en) | server | |
| JP4821307B2 (en) | Contract reception terminal and contract 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 | ||
| CB02 | Change of applicant information |
Address after: No. 5 on the third floor of the 528200 Guangdong Province Nanhai District of Foshan City, Guicheng deep sea No. 17 Han day science and technology city A District Applicant after: Guangdong Jin Fu Polytron Technologies Inc Address before: No. 5 on the third floor of the 528200 Guangdong Province Nanhai District of Foshan City, Guicheng deep sea No. 17 Han day science and technology city A District Applicant before: Guangdong Kamfu Information Technology Co., Ltd. |
|
| COR | Change of bibliographic data | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160615 |