CN116630069A - Method and storage medium for automatically generating tax audit report - Google Patents
Method and storage medium for automatically generating tax audit report Download PDFInfo
- Publication number
- CN116630069A CN116630069A CN202310370748.XA CN202310370748A CN116630069A CN 116630069 A CN116630069 A CN 116630069A CN 202310370748 A CN202310370748 A CN 202310370748A CN 116630069 A CN116630069 A CN 116630069A
- Authority
- CN
- China
- Prior art keywords
- tax
- auditing
- inspection
- data
- audit
- 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
- 238000012550 audit Methods 0.000 title claims abstract description 32
- 238000000034 method Methods 0.000 title claims abstract description 26
- 238000004590 computer program Methods 0.000 claims abstract description 10
- 238000007689 inspection Methods 0.000 claims description 46
- 238000012216 screening Methods 0.000 claims description 16
- 230000005856 abnormality Effects 0.000 claims description 2
- FGUUSXIOTUKUDN-IBGZPJMESA-N C1(=CC=CC=C1)N1C2=C(NC([C@H](C1)NC=1OC(=NN=1)C1=CC=CC=C1)=O)C=CC=C2 Chemical compound C1(=CC=CC=C1)N1C2=C(NC([C@H](C1)NC=1OC(=NN=1)C1=CC=CC=C1)=O)C=CC=C2 FGUUSXIOTUKUDN-IBGZPJMESA-N 0.000 claims 1
- 238000012797 qualification Methods 0.000 description 9
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 230000000737 periodic effect Effects 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Technology Law (AREA)
- General Health & Medical Sciences (AREA)
- Economics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method and a storage medium for automatically generating tax audit reports by adopting a computer program. The method comprises the following steps: A. receiving a user to select an auditing scheme from an auditing scheme library; B. receiving the table names of the data tables which are required to be checked and for which the execution period is set by the user; C. generating tax auditing tasks according to the auditing scheme, the execution period and the table names of the data table; D. when the tax auditing task execution time point is reached, determining a target data table according to the table name of the data table, automatically auditing the data table according to an auditing scheme in the task, and outputting an auditing result for a user to confirm; E. and automatically generating tax auditing reports according to the auditing results confirmed by the users and the tax auditing report templates. The method for automatically generating the tax audit report can automatically and regularly execute tax audit tasks, automatically generate the tax audit report according to the audit result and the tax audit report template, does not need a user to manually write the tax audit report, and is convenient and quick.
Description
Technical Field
The invention relates to the technical field of tax auditing, in particular to a method and a storage medium for automatically generating tax auditing reports.
Background
Tax inspection refers to inspection and supervision of tax payment conditions of tax payers by tax authorities on behalf of countries, and is an important link of tax collection management work. The traditional tax auditing mode mainly relies on the auditing personnel to manually review the tax payment data of the relevant tax payers, and the tax payment data is manually analyzed and judged whether suspicious point data exists or not, so that a great amount of time and energy are consumed by the auditing personnel. Therefore, a tax auditing analysis tool based on a computer is proposed in the industry, and an auditing person uses the analysis tool to automatically audit a specified tax data table to obtain an auditing result, but still needs to manually write tax auditing reports according to the auditing result.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a method for automatically generating tax audit report by adopting a computer program and a computer readable storage medium storing the computer program which can realize the method when being executed.
In order to solve the technical problems, the invention provides a method for automatically generating tax audit report by adopting a computer program, which comprises the following steps:
A. receiving a user to select an auditing scheme from an auditing scheme library;
B. receiving the list name of the data list to be checked, wherein the execution period is set for the checking scheme selected by the user;
C. generating tax auditing tasks according to auditing schemes selected by users, execution periods of the auditing schemes and table names of data tables to be audited;
D. when the execution time point of the tax auditing task is reached, determining a target data table according to the table name of the data table to be inspected, automatically auditing the target data table according to an auditing scheme in the task, and outputting an auditing result for a user to confirm;
E. and automatically generating tax auditing reports according to the auditing results confirmed by the users and the tax auditing report templates.
Further:
step D, screening data corresponding to each inspection field meeting the screening conditions from the target data table according to the inspection fields and the screening conditions thereof in the inspection scheme in the tax inspection task;
and E, specifically, searching a problem point matched with the screening condition from a preset problem point database according to the screening condition met by the data in the inspection result, and filling the data of the inspection result and the problem point into a tax inspection report template to generate a tax inspection report.
In step E, a corresponding tax auditing report template is determined according to the matched problem point, specifically, the tax auditing report is generated by filling the data of the auditing result and the problem point into the tax auditing report template corresponding to the problem point.
Further, step F. Output tax audit report.
Further, in step F, if the inspection result is a poor result, an inspection abnormality prompt is sent.
In step D, the checked data in the target data table is marked.
The invention also provides a computer readable storage medium having stored thereon an executable computer program which when executed implements a method of automatically generating tax audit reports as described above.
The method for automatically generating the tax audit report can automatically and regularly execute the tax audit task and output the audit result for the user to confirm, and automatically generate the tax audit report according to the audit result and the tax audit report template after the user confirms, so that the user does not need to manually write the tax audit report, and the method is convenient and quick.
Drawings
FIG. 1 is a flow chart of a method for automatically generating tax audit reports in accordance with the present invention.
FIG. 2 is an example of a result of a tax auditing system auditing a recent year tax data sheet of a small-scale taxpayer.
Detailed Description
The invention is further described in detail below in connection with the detailed description.
The method for automatically generating tax auditing report is shown in figure 1, the method is realized by a computer program, and the client of the tax auditing system comprises the computer program, so that the method can be realized in the tax auditing system. The tax auditing system client is stored in a hard disk of a computer (namely, a computer readable storage medium), a processor of the computer runs the tax auditing system client, a tax auditing report can be automatically generated according to the method shown in fig. 1 when a user automatically inspects a tax data table on the tax auditing system client, and the execution process of the method is described below by taking periodic auditing of qualification registration of small-scale tax payers in area A by the user as an example.
The identification standard of the small-scale taxpayer is 500 ten thousand yuan or less of annual tax sales (hereinafter referred to as annual tax sales). Some enterprises declare to qualify as small-scale tax liabilities in the early stages of development, but as enterprises develop, annual tax sales may be greater than 500 tens of thousands, and small-scale tax liabilities are no longer met. Therefore, tax departments need to check the qualification registers of small-scale tax payers regularly. In this example, the tax manager needs to check the qualification registration of the small-scale tax payer in the area a periodically, log in the client of the tax checking system, and select the checking scheme corresponding to the qualification registration checking of the small-scale tax payer from the checking scheme library of the tax checking system. The checking scheme comprises three checking fields of tax payer identification number, tax payer name and annual tax sales (ten thousand) and screening condition of annual tax sales (ten thousand) > 500. After the tax manager selects the inspection scheme, an execution period is set for the inspection scheme, for example, the execution period is set to be executed 1 per month, and then the table name of the data table to be inspected is selected from the tax database of the tax inspection system, wherein the table name of the data table selected in the embodiment is the tax data table of the small-scale tax payer in the area A in the last year, and the data table is tax data of the small-scale tax payer in the area A in the year before the current month, for example, when the tax data in the data table is in the year 2023 and the tax data of the small-scale tax payer in the area A in the year 2022 month to 2023 in the year 1. The tax auditing system automatically updates the data table along with the time, so that the data of the tax auditing system is always kept as tax data of the small-scale tax payer in the area A in the year closest to the current month, for example, when the time comes to 2023 and 3, the tax auditing system updates the data in the data table into tax data of the small-scale tax payer in the area A in the year 2022 and 3 and 2023 and 2.
The tax auditing system generates tax auditing tasks according to the auditing scheme and the execution period of the tax auditing scheme, namely 'No. 1 per month' and the table name of the data table to be audited, namely 'the tax data table of the small-scale tax payer in the area A for the last year'. The tax auditing system monitors whether the execution time point of the tax auditing task is reached or not in real time, for example, when the tax auditing system is in the 3 month No. 1, the tax auditing system monitors that the execution time point of the tax auditing task is reached (the month No. 1), so that the target data table is determined to be the latest annual tax data table of the small-scale tax payer in the area A according to the table name of the data table of the tax payer in the area A of the latest annual tax data table of the small-scale tax payer in the area A, and then the tax data table is inspected according to the auditing scheme in the tax auditing task. The tax auditing system automatically selects each auditing field information from the tax data table according to the auditing fields of tax payer identification number, tax payer name and annual tax sales (ten thousand) in the auditing scheme, and then screens each selected auditing field information according to the screening condition of annual tax sales (ten thousand) > 500, so as to screen data (recorded as auditing results) corresponding to each auditing field meeting the screening condition from the tax data table. The embodiment screens out 5 tax payers from a plurality of tax payers, wherein the annual tax sales (ten thousand) > 500, as shown in fig. 2, does not satisfy the qualification of small-scale tax payers. After the tax inspection system obtains an inspection result, according to a screening condition 'annual tax sales (ten thousand) > 500' met by data in the inspection result, searching a problem point matched with 'annual tax sales (ten thousand) > 500' from a preset problem point database, obtaining that the problem point is 'not meeting the qualification of a small-scale tax payer', and outputting the inspection result and the corresponding problem point to a tax manager for checking and confirming. After the tax manager confirms that the tax manager is correct, the tax auditing system acquires a tax auditing report template corresponding to the problem point from a tax auditing report template library, then fills the auditing result in the problem data field of the tax auditing report template, fills the matched problem point which does not meet the qualification of the small-scale tax payer into the problem point type field of the tax auditing report template, generates a tax auditing report and outputs the tax auditing report to the tax manager. The embodiment screens out annual tax sales (ten thousand) of 5 tax payers, namely, the current checking result is a bad result, and sends out abnormal checking prompt when tax checking report is output. If the annual tax sales of all small-scale tax payers in the area A is less than 500 ten thousand in the last year, the data obtained by inspection is zero (the data in the inspection result is 0), namely, all the small-scale tax payers in the area A meet the qualification of the small-scale tax payers, the data in the inspection result is 0, and the data does not meet the screening condition, so that the tax inspection system judges that the inspection result is a benign result, and a corresponding benign tax inspection report template is determined according to the screening condition of the inspection scheme of the tax inspection task, and accordingly, a tax inspection report is generated and output to a tax manager.
In this embodiment, the tax data table of the small-scale tax payer in the area a is checked, all data in the tax data table is checked each time the tax checking task is executed, but some tax checking scenes are not suitable for checking all data in the tax data table each time the tax checking task is executed, for example, a tax checking system usually only suggests a tax data table for a single tax of a single tax payer, the tax data table stores all tax data records of the tax payer under the tax, and if the tax payer has new tax data records of the tax, the tax checking system adds the tax data records to the tax data table. If tax manager needs to check special term of tax payer, tax check task is set in tax check system by referring to check qualification of small-scale tax payer in area A. In this embodiment, preferably, an incremental inspection switch is provided for a tax inspection task, and a tax manager opens the incremental inspection switch for the tax inspection task, so that when the tax inspection system detects that the execution time point of the tax inspection task is reached, the incremental data in the target data table of the task is inspected according to the inspection scheme of the tax inspection task, and the inspected data in the target data table is marked, that is: if the tax auditing task is executed for the first time, auditing all data in the target data table and marking the checked data in the target data table; if the tax auditing task is not executed for the first time, auditing the untagged data in the target data table and marking the audited data in the target data table. Thus, incremental auditing of some tax data tables storing all tax data records (total amounts) is realized.
The above-described embodiments are provided for the present invention only and are not intended to limit the scope of patent protection. Insubstantial changes and substitutions can be made by one skilled in the art in light of the teachings of the invention, as yet fall within the scope of the claims.
Claims (7)
1. The method for automatically generating tax auditing report by adopting the computer program is characterized by comprising the following steps:
A. receiving a user to select an auditing scheme from an auditing scheme library;
B. receiving the list name of the data list to be checked, wherein the execution period is set for the checking scheme selected by the user;
C. generating tax auditing tasks according to auditing schemes selected by users, execution periods of the auditing schemes and table names of data tables to be audited;
D. when the execution time point of the tax auditing task is reached, determining a target data table according to the table name of the data table to be inspected, automatically auditing the target data table according to an auditing scheme in the task, and outputting an auditing result for a user to confirm;
E. and automatically generating tax auditing reports according to the auditing results confirmed by the users and the tax auditing report templates.
2. The method for automatically generating tax audit reports according to claim 1 wherein:
step D, screening data corresponding to each inspection field meeting the screening conditions from the target data table according to the inspection fields and the screening conditions thereof in the inspection scheme in the tax inspection task;
and E, specifically, searching a problem point matched with the screening condition from a preset problem point database according to the screening condition met by the data in the inspection result, and filling the data of the inspection result and the problem point into a tax inspection report template to generate a tax inspection report.
3. The method according to claim 2, wherein in step E, a corresponding tax audit report template is determined according to the matched problem point, and specifically, tax audit report is generated by filling the tax audit report template corresponding to the problem point with the data of the audit result and the problem point.
4. The method for automatically generating tax audit reports according to claim 1 including the step f. Outputting tax audit reports.
5. The method according to claim 4, wherein in step F, if the inspection result is a bad result, an inspection abnormality prompt is sent.
6. The method of automatically generating tax audit report according to claim 1 wherein in step D, the current audit data in the target data table is marked.
7. A computer readable storage medium having stored thereon a computer program executable thereon, wherein the computer program when executed performs the method of automatically generating tax audit reports according to any of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310370748.XA CN116630069A (en) | 2023-04-07 | 2023-04-07 | Method and storage medium for automatically generating tax audit report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310370748.XA CN116630069A (en) | 2023-04-07 | 2023-04-07 | Method and storage medium for automatically generating tax audit report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116630069A true CN116630069A (en) | 2023-08-22 |
Family
ID=87620081
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310370748.XA Pending CN116630069A (en) | 2023-04-07 | 2023-04-07 | Method and storage medium for automatically generating tax audit report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116630069A (en) |
-
2023
- 2023-04-07 CN CN202310370748.XA patent/CN116630069A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8234145B2 (en) | Automatic computation of validation metrics for global logistics processes | |
| Bierstaker et al. | The impact of information technology on the audit process: an assessment of the state of the art and implications for the future | |
| US8776007B2 (en) | Assessment of software code development | |
| Casati et al. | A generic solution for warehousing business process data | |
| US20090204517A1 (en) | Intercompany accounting data analytics | |
| US20090070237A1 (en) | Data reconciliation | |
| US20070078701A1 (en) | Systems and methods for managing internal controls with import interface for external test results | |
| US8275739B2 (en) | User interface display for monitoring a database load engine | |
| Kalinowski et al. | Towards a defect prevention based process improvement approach | |
| CN106688001A (en) | Improved system and method for timekeeping entry and work in progress reports | |
| JP2009245380A (en) | Job processing system and job testing method | |
| US8311880B1 (en) | Supplier performance and accountability system | |
| CN110751452B (en) | Workflow management system, method and storage medium | |
| CN116630069A (en) | Method and storage medium for automatically generating tax audit report | |
| US20120209644A1 (en) | Computer-implemented system and method for facilitating creation of business plans and reports | |
| CN112465456A (en) | Engineering evaluation data information management method, system and electronic equipment | |
| JP4183519B2 (en) | Human resource rearrangement simulation method, computer program, and human resource rearrangement simulation device | |
| EP1895455A1 (en) | Systems and methods for testing internal control effectiveness | |
| JP2005128742A (en) | Electronic income tax data generating and confirming method, electronic income tax operation processing apparatus, and program | |
| CN116485330A (en) | Method and storage medium for automatically generating supervision project proposal | |
| CN116485562A (en) | Method and storage medium for automatically data aggregation of inspection results of tax inspection scheme | |
| Shanks et al. | FRMAC Laboratory Analysis RadResponder Gap Analysis and Web Portal Enhancements | |
| Statistics | Northern Ireland Planning Statistics-Quality Assurance of Administrative Data Sources | |
| Cristescu et al. | TRENDS IN AUDITING ERP SYSTEMS | |
| DEFENSE LOGISTICS AGENCY ALEXANDRIA VA | Defense Contract Management Command Data Validation Filter |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |