Method, device and computer equipment for generating tax return form in tax system

Abstract

The present invention provides a method, device and computer equipment for generating a tax return in a tax system. The method for generating a tax return in the tax system comprises: when a tax return generation request is received, obtaining a report template corresponding to the tax return generation request; parsing the report template to obtain all areas with aliases in the report template; based on the aliases of each area in the report template, respectively determining the information blocks corresponding to each area from the call template associated with the report template; traversing the cells of each area to obtain the properties of the cells of each area, and based on the properties of the cells of each area, respectively obtaining the corresponding values ​​of the properties of the cells of each area from the corresponding information blocks to generate the tax return. The present invention can improve the code reuse rate and development efficiency.

Description

Technical Field

[0001] The present invention relates to the technical field of tax data processing, and in particular to a method, device and computer equipment for generating a tax return form in a tax system. Background Art

[0002] The tax system provides a standard tax return form export function. Before exporting, a standard tax return form must be generated. Because tax returns involve multiple types of returns, and the row and column lengths and header styles of each type of return may be different, directly generating XLSX templates and writing data in the background often cannot meet actual business needs. Therefore, the common practice is to use EXCEL to draw the XLSX file of the standard tax return form in advance, and after obtaining the taxpayer's declaration data, read the pre-processed XLSX file and write it according to the data items. However, due to the large number of businesses, writing according to data items requires processing each business separately, which is inconvenient to maintain and time-consuming to develop. Summary of the invention

[0003] The problem solved by the present invention is that due to the large number of businesses, the existing tax return form generation method written by data items needs to process each business separately, which is inconvenient to maintain and time-consuming to develop.

[0004] In order to solve the above problems, the present invention provides a method for generating a tax return in a tax system, comprising:

[0005] When a tax return form generation request is received, obtaining a report template corresponding to the tax return form generation request;

[0006] Parsing the report template to obtain all areas with aliases set in the report template;

[0007] Based on the aliases of the respective areas in the report template, respectively determining the information blocks corresponding to the respective areas from the calling template associated with the report template;

[0008] The cells of each area are traversed to obtain the attributes of the cells of each area. Based on the attributes of the cells of each area, corresponding values ​​of the attributes of the cells of each area are obtained from corresponding information blocks respectively to generate the tax return.

[0009] Optionally, the area type in the report template includes at least one of the following: a fixed irregular area, a fixed regular area, and a non-fixed regular area. In the calling template, areas of different area types are defined as corresponding structured forms.

[0010] Optionally, the calling template is expressed in JSON format, and the information blocks corresponding to the respective areas are JSON nodes corresponding to the respective areas.

[0011] Optionally, in the calling template, all cell properties in the fixed irregular area are defined as properties in JSONOBJECT.

[0012] Optionally, in the calling template, the row data or column data in the fixed rule area is defined as JSONOBJECT, and the fixed rule area as a whole is defined as JSONARRAY.

[0013] Optionally, in the calling template, the row data in the non-fixed rule area is defined as JSONOBJECT, and the non-fixed rule area as a whole is defined as JSONARRAY.

[0014] Optionally, the alias name of each area is consistent with the JSON node name corresponding to each area.

[0015] The present invention also provides a tax return form generating device in a tax system, comprising:

[0016] A template acquisition unit, which is used to acquire a report template corresponding to the tax return form generation request when receiving the tax return form generation request;

[0017] A parsing unit, used for parsing the report template and obtaining all areas with aliases in the report template;

[0018] A query unit, configured to determine, based on the aliases of the respective regions in the report template, information blocks corresponding to the respective regions from a calling template associated with the report template;

[0019] A declaration information writing unit is used to traverse the cells of each area, obtain the attributes of the cells of each area, and based on the attributes of the cells of each area, obtain the corresponding values ​​of the attributes of the cells of each area from the corresponding information blocks to generate the tax return form.

[0020] The present invention also proposes a computer device, comprising a computer-readable storage medium storing a computer program and a processor, wherein when the computer program is read and executed by the processor, the method for generating a tax return in a tax system as described in any one of the above items is implemented.

[0021] The present invention also proposes a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is read and executed by a processor, the method for generating a tax return in a tax system as described in any one of the above items is implemented.

[0022] Compared with the prior art, the present invention divides the report template into multiple areas, and uses a calling template to perform structured definition of the information of each area of ​​the report template, thereby realizing the structuring of the taxpayer's declaration information corresponding to the report template. When a tax return form generation request is received, the report template corresponding to the tax return form generation request is obtained, and based on the aliases of each area in the report template, the information blocks corresponding to each area are respectively determined from the calling template associated with the report template, and the corresponding attribute values ​​of the cells in each area are respectively obtained from the corresponding information blocks, and written into the report template to generate a tax return form, and the function of exporting and printing standard tax returns is provided to taxpayers, which changes the original tax return form export and printing method. The corresponding relationship between the defined template and the declaration information is adopted for the assignment of the report template, and the background template parsing and assignment process is used as a public method to improve development efficiency and avoid repeated coding. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 A schematic diagram of an embodiment of a method for generating a tax return form in a tax system of the present invention;

[0024] Figure 2 An example of fixing irregular areas in the tax return generation method in the tax system of the present invention Figure 1 ;

[0025] Figure 3 An example of fixing irregular areas in the tax return generation method in the tax system of the present invention Figure 2 ;

[0026] Figure 4 An example diagram of a fixed rule area in a method for generating a tax return in a tax system of the present invention;

[0027] Figure 5 An example diagram of an unfixed rule area in a method for generating a tax return in a tax system of the present invention;

[0028] Figure 6 FIG. 1 is a schematic diagram of an embodiment of a computer device of the present invention. DETAILED DESCRIPTION

[0029] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, specific embodiments of the present invention are described in detail below with reference to the accompanying drawings.

[0030] The invention provides a method for generating a tax return form in a tax system.

[0031] Figure 1 This is a flow chart of an embodiment of a method for generating a tax return form in a tax system of the present invention. Figure 1 , the tax return generation method in the tax system includes:

[0032] Step S100: when a tax return form generation request is received, a report template corresponding to the tax return form generation request is obtained.

[0033] In the tax system, taxpayers can request to generate, export, and print standard tax returns for the tax system. When a request to export or print a standard tax return for the tax system is detected, a request to generate a tax return can be triggered.

[0034] After receiving the tax return generation request, the tax return generation request is parsed to obtain the type of tax return requested to be generated. In the tax system, report templates for different types of tax returns are pre-stored. Based on the type of tax return requested to be generated, the report template for this type of tax return is obtained, that is, the report template corresponding to the tax return generation request.

[0035] Optionally, the report template is an XLSX format template.

[0036] Step S200, parsing the report template, and obtaining all areas with aliases set in the report template.

[0037] When establishing a report template, the report template can be divided into different areas, and cells belonging to the same area are cells with high similarity in cell position characteristics and cell attribute characteristics.

[0038] Optionally, the area in the report template includes but is not limited to at least one of the following: (1) Fixed irregular area. This area is a fixed area on the tax return form, and no cell attributes in this area are regularly the same. (2) Fixed regular area. This area is a fixed area on the tax return form, and the cell attributes in this area are regularly the same, generally regular rows or columns, and the displayed data is generally in a detailed format. (3) Non-fixed regular area. This area is a non-fixed area on the tax return form, and it generally has an unfixed number of rows. The number of rows is determined by the amount of data reported by the taxpayer. Only one row can be set in the report template. The cell attributes in this area are regularly the same, and the attributes of each column can be the same. The data displayed is generally in a detailed format.

[0039] Figure 2 and Figure 3 is an example of a fixed irregular region. Figure 2 The attributes contained in the report area shown belong to the basic information of taxpayers. The basic information of taxpayers is usually information with fixed attributes and attribute values, so its position is fixed in the report template, and the cell attributes: taxpayer identification number (nsrsbh), taxpayer name (nsrmc) and report period (skssqq) are independent and different from each other. This area can be defined as a fixed irregular area when establishing a report template, where: Figure 2 The cell where nsrsbh / nsrmc / skssqq is located is the area for filling in the corresponding value of the taxpayer identification number / taxpayer name / corresponding value of the reporting period. Figure 3 The attributes contained in the report area shown also belong to taxpayer information. Taxpayer information is information related to taxpayers, and its content is fixed, so its position is fixed in the report template. The cell attributes: taxpayer identification number (nsrsbh), taxpayer full name (nsrmc), tax collection agency (swjgmc), opening bank (khyh), bank account number (yhzh) are independent and different from each other. Figure 3 The report area shown is defined as a fixed irregular area, where Figure 3 The cells where the Chinese and English strings are located are the areas where the corresponding values ​​of the attributes are filled in. For example, the cell where swjgmc is located is the area where the corresponding values ​​of the tax collection authorities are filled in.

[0040] Figure 4 is a fixed regular area. The attributes of the third column are all assets at the beginning of the year (ncyeZc), the attributes of the fourth column are all assets at the end of the period (qmyeZc), the attributes of the seventh column are all equity at the beginning of the year (ncyeQy), and the attributes of the eighth column are all equity at the end of the period (qmyeQy). That is, the attributes of cells in this area are regularly the same. For example, Figure 4 The third column of the row where the monetary funds are located refers to the beginning balance of assets in the monetary funds category, the fourth column of the row where the monetary funds are located refers to the ending balance of assets in the monetary funds category, the third column of the row where the short-term loans are located refers to the beginning balance of equity in the short-term loans category, and the fourth column of the row where the short-term loans are located refers to the ending balance of equity in the short-term loans category. In addition, the cell position of this area is fixed. For the same report template, the cell position or number of rows will not change due to different taxpayers. This area can be defined as a fixed rule area when creating a report template.

[0041] Figure 5 The area enclosed by the black box is a non-fixed regular area. Figure 5 In the example, only one row of data is shown in this area, but different taxpayers may have different numbers of data rows. Taxpayer A may have 1 row of data, while taxpayer B may have 3 rows of data. Therefore, the cells in this area are not fixed. In addition, if the number of data rows increases, the attributes of the same column remain unchanged, that is, the attributes of the data in the same column are the same, that is, the cell attributes in this area are regularly the same, that is, this area can be defined as a non-fixed regular area when creating a report template, such as Figure 5In the non-fixed rule area shown, the column attributes are: system invoice number, tax (fee) type, tax (product) item, start of period, end of period, actual payment amount, payment date, and remarks. When a new row of data is added to this area, the column attributes remain unchanged. For example, the data attributes of the system invoice number column are all system invoice number, and the data attributes of the actual payment amount column are all actual payment amount. Among them, the cell where DZSPHM is located is the area where the corresponding value of the system invoice number in this row of data is filled in, and the cell where ZSXMMC is located is the area where the corresponding value of the tax (fee) type in this row of data is filled in. Similarly, the cells where other English strings are located are the areas where the corresponding values ​​of the corresponding attributes in this row of data are filled in, which are not repeated here.

[0042] Based on the above content, since the cells belonging to the same area have high similarity in cell location characteristics and cell attribute characteristics, the taxpayer's declaration information can be structured based on the cell characteristics of different areas in the report template, and multiple data structures can be defined to adapt to the cell characteristics of different areas, speed up the data import speed in the tax return form generation process, and facilitate development and maintenance. The structured definition here means that the data of each area is structured based on the area type of each area in the report template through the call template in the subsequent steps.

[0043] Set aliases for each area. There may be one or more areas with aliases in the report template. Different areas have different aliases. On the one hand, they are used to distinguish different areas to ensure that the final taxpayer return form has high readability. On the other hand, they are used as parameters for subsequent queries to call the corresponding information blocks in the template to associate each area with different information blocks. For example, Figure 2 The locale alias "nsrxxForm" is shown. Figure 4 The locale alias shown is "sbxxGrid".

[0044] After the report template is established, its various areas are basically divided, the positions of various areas in the report template are basically fixed, and the areas with aliases set in the report template are also basically fixed. The areas with aliases set in the report template and their aliases can be stored in association with the report template. After determining the report template corresponding to the tax return generation request, the report template is parsed to directly obtain the areas with aliases set and their aliases stored in association with the report template. The cells in the report template can also be directly traversed to obtain the areas with aliases set in the report template and their aliases.

[0045] Step S300: Based on the aliases of the respective areas in the report template, information blocks corresponding to the respective areas are determined from the calling template associated with the report template.

[0046] The calling template is used to call the taxpayer's declaration information, write the report template, and then generate a tax return. Optionally, the calling template is represented in JSON format. JSON (JavaScript Object Notation) is a lightweight data exchange format that contains objects (JSONOBJECT) and arrays (JSONARRAY). By representing the calling template in JSON format, the taxpayer's declaration information can be structured.

[0047] After determining the report template, you can perform corresponding JSON programming on the report template, define the data format of each area in the report template, and generate a call template for the report template. Figure 3 The area shown contains attributes: taxpayer identification number, taxpayer full name, tax collection agency, bank account, and bank account number. Use JSON to assemble the attributes of this area into JSONOBJECT, that is, Figure 3 In the area shown, JSONOBJECT contains attributes such as nsrsbh, nsrmc, swjgmc, khyh, and yhzh.

[0048] In the calling template, areas of different area types are defined as corresponding structured forms. Specifically, all cell properties in the fixed irregular area are defined as attributes in JSONOBJECT, the row data or column data in the fixed regular area is defined as JSONOBJECT, and the fixed regular area as a whole is defined as JSONARRAY, the row data in the non-fixed regular area is defined as JSONOBJECT, and the non-fixed regular area as a whole is defined as JSONARRAY.

[0049] Optionally, in the calling template, all cell properties in the fixed irregular area are defined as properties in JSONOBJECT.

[0050] Fixed irregular area is a fixed area on the tax return form. All the information in it is defined as a JSONOBJECT. The related information can be defined as different attributes in JSONOBJECT. The obtained information is converted into a JSONOBJECT object, and the corresponding attribute values ​​are written in the corresponding positions in the template cells. For example, Figure 2 The area shown defines a JSONOBJECT named nsrxxForm, which contains three attributes: taxpayer identification number, taxpayer name, and report period.

[0051] Optionally, in the calling template, the row data or column data in the fixed rule area is defined as JSONOBJECT, and the fixed rule area as a whole is defined as JSONARRAY.

[0052] The fixed regular area has cell attributes that are regularly the same, generally regular rows or columns. If the row attributes are the same or the column attributes are the same, each row of data or each column of data is defined as a JSONOBJECT, and each JSONOBJECT in a JSONARRAY is distinguished by the row number or column number. According to the number of rows or columns where the JSONOBJECT is located in the report template, the JSONOBJECT is distinguishably named, and then the specific JSONOBJECT object can be determined based on the specific row number to achieve accurate data writing.

[0053] Optionally, in the calling template, the row data in the non-fixed rule area is defined as JSONOBJECT, and the non-fixed rule area as a whole is defined as JSONARRAY.

[0054] That is, each row of data in the non-fixed regular area is defined as JSONOBJECT, and the entire area is defined as JSONARRAY. The row attributes of the non-fixed regular area are usually the same, so each row of data is defined as JSONOBJECT.

[0055] To achieve accurate data writing, different names are used to distinguish data in fixed rule areas and non-fixed rule areas in the calling template. For example, jsonObject_n (n is a positive integer, indicating the number of rows) is used to represent row data or column data in fixed rule areas, and jsonObject_list is used to represent row data in non-fixed rule areas.

[0056] Different regions correspond to respective information blocks, and the information blocks corresponding to the respective regions are JSON nodes corresponding to the respective regions. The JSON nodes include JSONOBJECT nodes and JSONARRAY nodes.

[0057] Optionally, the alias name of each area is consistent with the JSON node name corresponding to each area.

[0058] Set the JSON node name corresponding to each region to be consistent with the alias name of each region, so as to associate the JSON node corresponding to each region with the alias of each region, and then associate the region with the taxpayer declaration information node in the report template, so as to quickly locate the corresponding JSON node based on the alias of each region. For example, Figure 2 For the area shown, its alias can be set to nsrxxForm, and the corresponding JSON node name is also set to nsrxxForm.

[0059] Furthermore, for areas and JSON nodes that have a corresponding relationship, the attributes in the JSONOBJECT node / JSONARRAY node are consistent with the cell name of the area, which can quickly match the cells in the area with the attributes in the JSONOBJECT node / JSONARRAY node, and then quickly write the cell data in the area.

[0060] Step S400, traverse the cells of each area, obtain the attributes of the cells of each area, and based on the attributes of the cells of each area, obtain the corresponding values ​​of the attributes of the cells of each area from the corresponding information blocks respectively to generate the tax return form.

[0061] You can set the order of traversal of each area in the report template, starting from the first area, traversing to obtain the properties of all cells in the first area, then starting from the second area, traversing to obtain the properties of all cells in the second area, and so on. The traversal of each area is performed in sequence.

[0062] After obtaining the properties of a cell, you can obtain the corresponding value of the cell property from the information block corresponding to the area to which the cell belongs. You can also obtain the corresponding value of each cell property from the information block corresponding to the area after obtaining the properties of all cells in an area. After obtaining the corresponding value of each cell property, write the corresponding value of the property into the report template to generate a tax return.

[0063] By dividing the report template into multiple areas and using the calling template to define the information of each area of ​​the report template, the structuring of the taxpayer's declaration information corresponding to the report template is realized. When a tax return generation request is received, the report template corresponding to the tax return generation request is obtained. Based on the aliases of each area in the report template, the information blocks corresponding to each area are determined from the calling template associated with the report template. The corresponding attribute values ​​of the cells in each area are obtained from the corresponding information blocks, written into the report template, and the tax return is generated, providing the taxpayer with the function of exporting and printing standard tax returns. The traditional export and printing method generally generates an XLSX file in the background and provides export after assigning values. This method cannot meet the generation of complex tax returns. The present invention solves the cumbersome problem of background generation of export files and the problem of non-compliance of the file style exported by taxpayers after declaration through the use of pre-defined report templates. In addition, by defining the correspondence between data and XLSX files, using JAVA to parse the template, and writing structured data into the template according to the defined rules, it is possible to easily write stored data into the standard tax return form, thus changing the original tax return export and printing method. The report template is assigned a corresponding relationship between the defined template and the declaration information, and the background template is parsed and the assignment process is used as a public method to improve development efficiency and avoid repeated coding.

[0064] Another embodiment of the present invention provides a tax return form generating device in a tax system, wherein the tax return form generating device in the tax system comprises:

[0065] A template acquisition unit, which is used to acquire a report template corresponding to the tax return form generation request when receiving the tax return form generation request;

[0066] A parsing unit, used for parsing the report template and obtaining all areas with aliases in the report template;

[0067] A query unit, configured to determine, based on the aliases of the respective regions in the report template, information blocks corresponding to the respective regions from a calling template associated with the report template;

[0068] A declaration information writing unit is used to traverse the cells of each area, obtain the attributes of the cells of each area, and based on the attributes of the cells of each area, obtain the corresponding values ​​of the attributes of the cells of each area from the corresponding information blocks to generate the tax return form.

[0069] Optionally, the area type in the report template includes at least one of the following: a fixed irregular area, a fixed regular area, and a non-fixed regular area. In the calling template, areas of different area types are defined as corresponding structured forms.

[0070] Optionally, the calling template is expressed in JSON format, and the information blocks corresponding to the respective areas are JSON nodes corresponding to the respective areas.

[0071] Optionally, in the calling template, all cell properties in the fixed irregular area are defined as properties in JSONOBJECT.

[0072] Optionally, in the calling template, the row data or column data in the fixed rule area is defined as JSONOBJECT, and the fixed rule area as a whole is defined as JSONARRAY.

[0073] Optionally, in the calling template, the row data in the non-fixed rule area is defined as JSONOBJECT, and the non-fixed rule area as a whole is defined as JSONARRAY.

[0074] Optionally, the alias name of each area is consistent with the JSON node name corresponding to each area.

[0075] The beneficial effects of the tax return form generating device in the tax system of the present invention relative to the prior art are consistent with the tax return form generating method in the above-mentioned tax system, which will not be described in detail here.

[0076] Another embodiment of the present invention provides a computer device. Figure 6 As shown, the computer device includes a computer-readable storage medium storing a computer program and a processor. When the computer program is read and executed by the processor, the tax return generation method in the tax system as described in any one of the above items is implemented.

[0077] The beneficial effects of the computer device of the present invention relative to the prior art are consistent with the tax return form generation method in the above-mentioned tax system, and will not be described in detail here.

[0078] Another embodiment of the present invention provides a computer-readable storage medium, the computer-readable storage medium comprising: the computer-readable storage medium stores a computer program, and when the computer program is read and executed by a processor, it implements the tax return generation method in a tax system as described in any of the above items.

[0079] The beneficial effects of the computer-readable storage medium of the present invention relative to the prior art are consistent with the tax return form generation method in the above-mentioned tax system, and will not be described in detail here.

[0080] Although the disclosure is disclosed as above, the protection scope of the disclosure is not limited thereto. Those skilled in the art may make various changes and modifications without departing from the spirit and scope of the disclosure, and these changes and modifications will fall within the protection scope of the present invention.

Claims

1. A method for generating a tax return in a tax system, characterized in that: include: When a tax return form generation request is received, obtaining a report template corresponding to the tax return form generation request; Parsing the report template to obtain all areas with aliases set in the report template; Based on the aliases of the respective regions in the report template, information blocks corresponding to the respective regions are determined from the calling template associated with the report template; wherein the region types in the report template include at least one of the following: a fixed irregular region, a fixed regular region, and a non-fixed regular region; in the calling template, regions of different region types are defined as corresponding structured forms; Traversing the cells of each region, obtaining the attributes of the cells of each region, and based on the attributes of the cells of each region, respectively obtaining the corresponding values ​​of the attributes of the cells of each region from the corresponding information blocks, and generating the tax return form; The calling template is expressed in JSON format, and the information blocks corresponding to the respective regions are JSON nodes corresponding to the respective regions.

2. The method for generating a tax return in a tax system according to claim 1, characterized in that: In the calling template, all cell properties in the fixed irregular area are defined as properties in JSONOBJECT.

3. The method for generating a tax return in a tax system according to claim 1 or 2, characterized in that: In the calling template, the row data or column data in the fixed rule area is defined as JSONOBJECT, and the fixed rule area as a whole is defined as JSONARRAY.

4. The method for generating a tax return in a tax system according to claim 1 or 2, characterized in that: In the calling template, the row data in the non-fixed rule area is defined as JSONOBJECT, and the entire non-fixed rule area is defined as JSONARRAY.

5. The method for generating a tax return in a tax system according to claim 1 or 2, characterized in that: The alias name of each region is consistent with the JSON node name corresponding to each region.

6. A tax return form generating device in a tax system, characterized in that: include: A template acquisition unit, which is used to acquire a report template corresponding to the tax return form generation request when receiving the tax return form generation request; A parsing unit, used for parsing the report template and obtaining all areas with aliases in the report template; A query unit, which is used to determine the information blocks corresponding to each area from the calling template associated with the report template based on the alias of each area in the report template; wherein the area type in the report template includes at least one of the following: a fixed irregular area, a fixed regular area, and a non-fixed regular area; in the calling template, areas of different area types are defined as corresponding structured forms; A declaration information writing unit, which is used to traverse the cells of each area, obtain the attributes of the cells of each area, and based on the attributes of the cells of each area, respectively obtain the corresponding values ​​of the attributes of the cells of each area from the corresponding information blocks to generate the tax declaration form; The calling template is expressed in JSON format, and the information blocks corresponding to the respective regions are JSON nodes corresponding to the respective regions.

7. A computer device, characterized in that: It comprises a computer-readable storage medium storing a computer program and a processor. When the computer program is read and executed by the processor, the method for generating a tax return form in a tax system as described in any one of claims 1 to 5 is implemented.

8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is read and executed by a processor, the method for generating a tax return in a tax system according to any one of claims 1 to 5 is implemented.

Images