CN111353833A - Method and equipment for generating report - Google Patents
Method and equipment for generating report Download PDFInfo
- Publication number
- CN111353833A CN111353833A CN201811574018.7A CN201811574018A CN111353833A CN 111353833 A CN111353833 A CN 111353833A CN 201811574018 A CN201811574018 A CN 201811574018A CN 111353833 A CN111353833 A CN 111353833A
- Authority
- CN
- China
- Prior art keywords
- invoice
- information
- value
- local
- data table
- 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
Images
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
- G06Q30/00—Commerce
- G06Q30/04—Billing or invoicing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/123—Tax preparation or submission
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Technology Law (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method and equipment for generating a report, which are used for solving the problem of low tax management efficiency of enterprises in the prior art. According to the method, a local invoice data table is generated according to the acquired invoice information corresponding to the invoice associated with the value-added tax declaration; searching invoice data corresponding to the query information in the local invoice data table according to the received query information; and generating a stub association detailed report according to the invoice data corresponding to the query information. In the process, the generated local invoice data table is directly inquired according to the inquiry information, the stub linkage detailed statement is directly generated according to the inquiry result, and compared with manual filling, the statement can be generated more accurately and efficiently, and the enterprise tax management efficiency is improved.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a method and equipment for generating a report.
Background
The invoice refers to the business certificate issued and collected by all units and individuals in purchasing and selling goods, providing or receiving services and doing other business activities, is the original basis for accounting, and is also the important basis for law enforcement inspection of auditing agencies and tax authorities. The stub of the invoice is mainly used for verifying old and new purchases, tax declaration and other scenes.
Scene one: the old is verified and new is purchased.
Value-added taxpayers (called taxpayers for short) need to go to local national tax authorities to purchase invoices every month. When the invoice is purchased, invoice expiration checking is required, namely, the used invoice stub which is originally purchased by the taxpayer is checked by a main tax authority; and providing the new invoice purchase for the enterprise after determining that the invoice stub is correct.
Scene two: and (5) reporting the taxes.
The taxpayer needs to really perform tax declaration every month, and the tax declaration refers to legal behaviors of the taxpayer for submitting written reports related to tax matters to a tax authority according to the time limit and content specified by tax laws. Provision is made in the "temporary regulations on tax collection and collection administration": the taxpayer must make tax declaration according to the regulation, and reports the tax declaration form, the financial accounting form and the relevant tax data to the responsible tax authority; the method is stipulated in 'value-added tax general taxpayer declaration method': general value-added tax payers must report data including value-added tax declaration form, additional data of value-added tax declaration form (table one), (table two), (table three), and (table four); the attached data (table four) is the detailed statement of the anti-counterfeiting tax-control value-added tax special invoice stub.
In the above scenario, when determining the invoice stub detail table, the manual work is mainly to fill and fill the invoice stub together, and for a unit with a large invoicing amount, the unit fills and fills the invoice stub by entry, so that the workload of tax clerks of an enterprise is large, errors are easy to occur, and the tax management efficiency of the enterprise is low.
In summary, in the prior art, the invoice stub detail table is manually filled in, so that the tax administration efficiency of an enterprise is low.
Disclosure of Invention
The invention provides a method and equipment for generating a report, which are used for solving the problem of low tax management efficiency of enterprises in the prior art.
In a first aspect, an embodiment of the present invention provides a method for generating a report, where the method includes:
generating a local invoice data table according to the acquired invoice information corresponding to the invoice associated with the value-added tax declaration;
searching invoice data corresponding to the query information in the local invoice data table according to the received query information;
and generating a stub association detailed report according to the invoice data corresponding to the query information.
According to the method, the local invoice data table is generated according to the acquired invoice information corresponding to the invoice associated with the value-added tax declaration, the inquiry information is searched in the local invoice data table according to the received inquiry information, the invoice information corresponding to the inquiry information is searched, the stub detail report is generated according to the searched invoice information corresponding to the inquiry information, the stub of all invoices issued is not required to be manually filled in one by one according to the format of the stub detail report in the process, the inquiry is directly performed in the generated local invoice data table according to the inquiry information, the report can be generated more accurately and efficiently according to the inquiry result, and the enterprise tax management efficiency is improved.
In one possible implementation, the invoice information associated with the value-added tax declaration is obtained by:
after determining that the historical login time does not exist for the current login user, acquiring invoice information corresponding to all invoices associated with the value-added tax declaration; or
And after determining that the historical login time of the current login user exists, acquiring invoice information corresponding to the increment and alteration invoice associated with the increment tax declaration in the time period of the last login time and the current login time.
According to the method, when the invoice information of the invoice associated with the value-added tax declaration is obtained, if the historical login time does not exist for the user, the invoice information of all the invoices associated with the value-added tax declaration is obtained, the integrity of the obtained invoice information is ensured, if the historical login time exists for the user, the additional and modification invoice issuing information in the time period of the current login time and the last login time is obtained, all the invoice information does not need to be obtained, the invoice obtaining amount is reduced, and the running speed of software is accelerated.
In a possible implementation manner, after a local invoice data table is generated according to the acquired invoice information corresponding to the invoice associated with the value-added tax declaration, before the invoice data corresponding to the query information is searched in the local invoice data table according to the received query information, the invoice information of the invoice corresponding to the invoice identifier which is not included in the local invoice data table is written into the local invoice data table, wherein the invoice identifier of the invoice related to the value-added tax declaration in the invoicing software is included in the invoice identifier.
In a possible implementation manner, after a local invoice data table is generated according to the acquired invoice information corresponding to the invoice associated with the value-added tax declaration, and before invoice data corresponding to the query information is searched in the local invoice data table according to the received query information, the invoice identifier of the invoice related to the value-added tax declaration in the invoicing software is included, and the invoice information of the invoice corresponding to the invoice identifier included in the local invoice data table is compared;
and after determining that the invoice information of the invoice in the local invoice data table is inconsistent with the invoice information of the invoice related to the value-added tax declaration in the invoicing software, modifying the invoice information in the local invoice data table according to the invoice information of the invoice related to the value-added tax declaration in the invoicing software.
The method ensures that the invoice information in the local invoice data table is consistent with the invoice information in the invoice software, and is more accurate when the invoice information corresponding to the query information is searched according to the query information and the stub linked detail table report is generated according to the searched invoice information.
In one possible embodiment, the query information includes part or all of the following: invoice code, invoice number, invoicing date, purchaser tax number and purchaser name;
the invoice associated with the value-added tax declaration includes part or all of the following: value-added tax general invoice, value-added tax special invoice, value-added tax electronic general invoice, motor vehicle invoice and roll invoice.
The method provides specific query information and invoice types associated with the value-added tax declaration, and can accurately query the invoices associated with the value-added tax declaration according to the query information when acquiring the stub detail statement.
In a second aspect, an embodiment of the present invention provides an apparatus for generating a report, where the apparatus includes: at least one processing unit and at least one memory unit, wherein the memory unit stores program code that, when executed by the processing unit, causes the processing unit to perform the following:
generating a local invoice data table according to the acquired invoice information corresponding to the invoice associated with the value-added tax declaration; searching invoice data corresponding to the query information in the local invoice data table according to the received query information; and generating a stub association detailed report according to the invoice data corresponding to the query information.
In a third aspect, an embodiment of the present invention provides another apparatus for generating a report, where the apparatus includes: the device comprises a data acquisition module, a searching module and a generating module;
a data acquisition module: the system comprises a local invoice data table, a local invoice data table and a local invoice data table, wherein the local invoice data table is used for generating local invoice data according to acquired invoice information corresponding to an invoice associated with value-added tax declaration;
a searching module: the local invoice data table is used for searching invoice data corresponding to the query information according to the received query information;
a generation module: and the system is used for generating a stub association detail report according to the invoice data corresponding to the query information.
In a fourth aspect, the present invention also provides a computer-readable storage medium having program code embodied therein, which when run on a computer, causes the computer to perform the method of the above aspects.
In a fifth aspect, the present invention also provides a computer program product comprising instructions which, when run on a computer, cause the computer to perform the method of the above aspects.
In addition, for technical effects brought by any one implementation manner of the second aspect to the fifth aspect, reference may be made to technical effects brought by different implementation manners of the first aspect, and details are not described here.
These and other aspects of the invention are apparent from and will be elucidated with reference to the embodiments described hereinafter.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without inventive exercise.
Fig. 1 is a flowchart of a method for generating a report according to an embodiment of the present invention;
FIG. 2 is a flowchart of a method for obtaining invoice information according to user login time according to an embodiment of the present invention;
fig. 3 is a schematic diagram of a display interface for generating an invoice stub detail report according to an embodiment of the present invention;
FIG. 4 is a flowchart of an overall method for generating a report according to an embodiment of the present invention;
fig. 5 is a structural diagram of an apparatus for generating a report according to an embodiment of the present invention;
fig. 6 is a structural diagram of another device for generating a report according to an embodiment of the present invention.
Detailed Description
The architecture and the service scenario described in the embodiment of the present invention are for more clearly illustrating the technical solution of the embodiment of the present invention, and do not form a limitation on the technical solution provided in the embodiment of the present invention, and it is known by those skilled in the art that with the occurrence of a new service scenario, the technical solution provided in the embodiment of the present invention is also applicable to similar technical problems.
Value-added tax generally taxpayers need to purchase invoices and declare taxes to tax authorities every month;
in the process of buying the invoice, the administrative tax authority needs to verify the used invoice stub which is originally purchased by the general taxpayer of the value-added tax, and provides the taxpayer with new invoice purchase for use after determining that the invoice stub is correct;
in the tax declaration process, the taxpayer needs to report the value-added tax declaration form and the attached data (table one), (table two), (table three) and (table four) of the value-added tax declaration form to the responsible tax authority; the attached data (table four) is the detailed statement of the anti-counterfeiting tax-control value-added tax special invoice stub.
The stub linkage details are needed to be used in the tax payer for generating tax declaration data, invoice expiration checking or other scenes; in the prior art, when the stub detail report is generated, the filling is mainly considered to be performed according to the invoices issued, if the invoicing amount of an enterprise is large, the workload of enterprise tax handling personnel is increased when the main item is filled, and the manual filling is easy to make mistakes, so that the accuracy rate of the generated report is low, and the enterprise tax management efficiency is finally low.
Based on the above content, the embodiment of the invention provides a method for automatically generating a stub association detail report according to query information, in the process, the stub association detail report does not need to be manually filled, the query is performed in a local invoice data table according to the query information, and the stub association detail report is generated according to a query result, so that the stub association detail report can be accurately and efficiently generated, and the enterprise tax management efficiency is improved.
In order to make the objects, technical solutions and advantages of the present invention clearer, the present invention will be described in further detail with reference to the accompanying drawings, and it is apparent that the described embodiments are only a part of the embodiments of the present invention, not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
As shown in fig. 1, a flowchart of a method for generating a report according to the present invention specifically includes the following steps:
and step 120, generating a stub detail report according to the invoice information corresponding to the query information.
In the embodiment of the invention, the local invoice data table is generated according to the acquired invoice information corresponding to the invoice associated with the value-added tax declaration, the invoice information corresponding to the query information is searched in the local invoice data table according to the received query information after the query information is received, and the stub detailed statement is generated according to the searched invoice information corresponding to the query information.
The invoice information of the anti-counterfeiting tax control invoice is stored in a local database and tax control equipment, the invoice information in the local database is synchronous with the information of invoicing software, and when the invoice information is determined to be required to be acquired, the invoice information corresponding to the invoice associated with the value-added tax declaration is acquired from the local database;
wherein the invoices associated with the value-added tax declaration comprise the following categories:
value-added tax general invoice, value-added tax special invoice, value-added tax electronic general invoice, motor vehicle invoice and roll invoice.
It should be noted that the invoices associated with the value-added tax declaration described in the embodiments of the present invention are not limited to the above listed ones, and any invoices of the kind suitable for the present invention are within the scope of the present invention.
When acquiring invoice information associated with value-added tax declaration, determining whether a current login user has historical login time according to a current login user name and login time, namely the current login user is enough for first login;
optionally, the invoice information associated with the value-added tax declaration is acquired by the following method:
after determining that the historical login time does not exist for the current login user, acquiring invoice information corresponding to all invoices associated with the value-added tax declaration; or
And after determining that the historical login time of the current login user exists, acquiring invoice information corresponding to the increment and alteration invoice associated with the increment tax declaration in the time period of the last login time and the current login time.
Specifically, whether the currently logged-in user logs in for the first time is judged according to the login time of the currently logged-in user and the stored historical login time;
if the historical login time exists, the current user is not logged in for the first time, and at the moment, invoice information corresponding to all value-added tax declaration related value-added tax invoices in the time period of the current login and the last login time needs to be acquired;
and if the current logged user does not have historical login time, acquiring all invoice information corresponding to all invoices associated with the value-added tax declaration from the local database.
Specifically, as shown in fig. 2, a flowchart for acquiring invoice information associated with value-added tax declaration provided in the embodiment of the present invention includes the following steps:
and step 230, acquiring invoice information of the incremental invoice associated with the incremental tax declaration.
In the implementation, when acquiring the invoice information of the invoice associated with the value-added tax declaration, if the user does not have the historical login time, acquiring all the invoice information of the invoice associated with the value-added tax declaration to ensure the integrity of the acquired invoice information, and if the user has the historical login time, acquiring the additional and replacement invoice information in the time period of the current login time and the last login time without acquiring all the invoice information, reducing the acquisition amount of the invoice and accelerating the running speed of software.
And acquiring all invoices related to the value-added tax declaration after determining that the user has no historical login time, namely after logging in for the first time, and acquiring invoice information in the invoices.
For example, the information of the acquired invoice is shown in the following table:
TABLE 1 invoice information
Further, the invoice information corresponding to the obtained invoice is sorted, and a local invoice data table is generated.
If the first login requires generation of a stub detail report, after the invoice data report is generated, query information is input, the query information can be searched in a generated local invoice data table according to the input query information, an invoice corresponding to the query information and invoice information on the corresponding invoice are determined, invoice information associated with the stub detail report is automatically acquired, and the stub detail report is generated according to the acquired invoice information associated with the stub detail report.
Wherein the query information includes part or all of the following:
invoice code, invoice number, invoicing date, purchaser tax number and purchaser name.
Taking the invoice code as an example: one of the following invoice codes may be selected:
value-added tax special invoice 1400131560;
value added tax plain invoice 014001800205;
an electronic invoice 111005117101;
a roll ticket 111000010026;
motor vehicle invoice 111001377777;
other types of invoices requiring tax declaration.
Taking the invoice number as an example: the invoice number and the ending invoice number can be input for inquiry;
in the case of the supplier name: and the Boolean option can select whether to display the name field of the buyer in the query list according to the requirement of the user.
As shown in fig. 3, it is an exemplary diagram of an interface for generating a stub associated detail report according to query information. As can be seen from fig. 3, the input query information: the invoice code is value-added tax special invoice 140013560, the invoice number is 00000000 to 99999999, and after the inquiry of the upper right corner of the interface is clicked, the value-added tax special invoice with the invoice number in 00000000 to 99999999 is searched in the generated local invoice data table;
determination in invoice data table: the invoice number is 00000000 to 99999999, the invoice code is two invoices of the value-added tax special invoice 1400131560, at the moment, the corresponding stub detail report can be selected to be generated according to the query result, the information related to the stub detail report in the two invoices is obtained, and the generated stub detail report is displayed in the interface.
After the generated stub association detail report is displayed in the interface, according to the button for exporting Excel by clicking the upper right corner in the interface of fig. 3, the stub association detail report shown in table 2 is exported:
table 2 stub journal report
After the report is exported, the report can be further adjusted according to the strong enterprise personalized requirements, and the report is used for the services of who declares you and the tax authority for invoice and old check and the like.
In the implementation, according to the generated invoice data report and the input query information, the stub detail report can be automatically generated after the query is determined to be needed, manual searching and filling are not needed according to invoice information related to the stub detail report in each invoice, the accuracy is guaranteed, and meanwhile the efficiency of enterprise tax management is improved.
If the registration is not the first time and a stub detailed statement needs to be generated, after a local invoice data table is generated according to the acquired invoice information corresponding to the invoice associated with the value-added tax declaration, before the invoice data corresponding to the query information is searched in the local invoice data table according to the received query information, the invoicing information in the local invoice data table is updated according to the invoicing information in the invoicing software, so that the invoice information in the invoice data packet is synchronous with the invoice information in the invoicing software, and the updating of the invoicing information in the local invoice data table according to the invoice information in the invoicing software is explained specifically according to the following modes:
the first method is as follows: and writing invoice information of the invoices corresponding to the invoice identifications which are contained in the invoicing software and are related to the value-added tax declaration and not contained in the local invoice data table into the local invoice data table.
Comparing invoice identifications of all invoices related to the value-added tax declaration in the invoice software with invoice identifications contained in a local invoice data table, determining that the invoice identifications existing in the invoicing software do not exist in the local invoice data table, and writing invoice information in the invoices corresponding to the invoice identifications existing in the invoicing software but not existing in the local invoice data table into the local invoice data table.
The second method comprises the following steps: the invoice information of the invoices corresponding to the invoice identifications contained in the local invoice data table is compared, wherein the invoice identifications are contained in the invoicing software and are related to the value-added tax declaration;
and after determining that the invoice information of the invoice in the local invoice data table is inconsistent with the invoice information of the invoice related to the value-added tax declaration in the invoicing software, modifying the invoice information in the local invoice data table according to the invoice information of the invoice related to the value-added tax declaration in the invoicing software.
The invoice identification of the invoice related to the value-added tax payment declaration in the invoicing software is contained, and the invoice identification contained in the local invoice data table, namely the invoice identification of the invoice related to the value-added tax payment declaration in the invoicing software and the invoice identification contained in the local invoice data table are correspondingly present, the invoice information of the invoice related to the value-added tax payment declaration in the invoicing software is identified in the invoicing software, and is compared with the invoice information of the invoice corresponding to the invoice identification in the local invoice data table, whether the invoice information in the invoicing software is consistent with the invoice information in the local invoice data table is determined, and if the invoice information in the invoicing software is determined to be inconsistent, the invoice information in the local data table is changed according to the invoice information in the invoicing software.
In the implementation, the invoice information in the local invoice data table is ensured to be consistent with the invoicing information in the invoicing software, and the invoice information corresponding to the query information is searched according to the query information, and the stub associated detailed table report is generated according to the searched invoice information, so that the accuracy is higher.
As shown in fig. 4, a flowchart of an overall method for generating a data report according to an embodiment of the present invention specifically includes the following steps:
specifically, whether the user who logs in at present logs in for the first time is judged according to the current login time and the stored historical login time;
and step 480, after receiving the export instruction, exporting the generated stub linkage detail report.
In some possible embodiments, the aspects of generating reports provided by the embodiments of the present invention can also be implemented in the form of a program product, which includes program code for causing a computer device to execute the steps in the method for generating reports according to various exemplary embodiments of the present invention described in this specification, when the program code runs on the computer device.
The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
A program product for data forwarding control according to an embodiment of the present invention may employ a portable compact disc read only memory (CD-ROM) and include program code, and may be run on a server device. However, the program product of the present invention is not limited thereto, and in this document, the readable storage medium may be any tangible medium containing or storing the program, which can be used by or in connection with an information transmission, apparatus, or device.
A readable signal medium may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A readable signal medium may also be any readable medium other than a readable storage medium that can transmit, propagate, or transport the program for use by or in connection with the periodic network action system, apparatus, or device.
Program code embodied on a readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Program code for carrying out processes of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device.
The embodiment of the invention also provides a storage medium readable by the computing equipment aiming at the report generating method, namely, the content is not lost after power failure. The storage medium stores therein a software program comprising program code which, when read and executed by one or more processors, implements any of the above aspects of embodiments of the invention in generating reports when the program code is run on a computing device.
Based on the same inventive concept, the embodiment of the present invention further provides a device for generating a report, and since the device corresponds to the device corresponding to the method for generating a report in the embodiment of the present invention, and the principle of the device for solving the problem is similar to that of the method, the implementation of the device may refer to the implementation of the method, and repeated details are not repeated.
As shown in fig. 5, an apparatus for generating a report according to an embodiment of the present invention includes: at least one processing unit 500 and at least one memory unit 501, wherein the memory unit 501 stores program code that, when executed by the processing unit 500, causes the processing unit 500 to perform the following:
generating a local invoice data table according to the acquired invoice information corresponding to the invoice associated with the value-added tax declaration;
searching invoice data corresponding to the query information in the local invoice data table according to the received query information;
and generating a stub association detailed report according to the invoice data corresponding to the query information.
Optionally, the invoice information associated with the value-added tax declaration is acquired by the following method:
after determining that the historical login time does not exist for the current login user, acquiring invoice information corresponding to all invoices associated with the value-added tax declaration; or
And after determining that the historical login time of the current login user exists, acquiring invoice information corresponding to the increment and alteration invoice associated with the increment tax declaration in the time period of the last login time and the current login time.
Optionally, the processing unit 500 is further configured to:
and writing invoice information of the invoices corresponding to the invoice identifications which are contained in the invoicing software and are related to the value-added tax declaration and not contained in the local invoice data table into the local invoice data table.
Optionally, the processing unit 500 is further configured to:
the invoice information of the invoices corresponding to the invoice identifications contained in the local invoice data table is compared, wherein the invoice identifications are contained in the invoicing software and are related to the value-added tax declaration;
and after determining that the invoice information of the invoice in the local invoice data table is inconsistent with the invoice information of the invoice related to the value-added tax declaration in the invoicing software, modifying the invoice information in the local invoice data table according to the invoice information of the invoice related to the value-added tax declaration in the invoicing software.
Optionally, the query information includes part or all of the following:
invoice code, invoice number, invoicing date, purchaser tax number and purchaser name.
Optionally, the invoice associated with the value-added tax declaration includes part or all of the following:
value-added tax general invoice, value-added tax special invoice, value-added tax electronic general invoice, motor vehicle invoice and roll invoice.
The embodiment of the invention also provides another device for generating the report, and as the device corresponds to the device corresponding to the method for generating the report in the embodiment of the invention and the principle of solving the problem of the device is similar to the method, the implementation of the device can refer to the implementation of the method, and repeated parts are not described again.
As shown in fig. 6, another device for generating a report according to an embodiment of the present invention includes: the system comprises a data acquisition module 600, a search module 610 and a generation module 620;
the data acquisition module 600: the system comprises a local invoice data table, a local invoice data table and a local invoice data table, wherein the local invoice data table is used for generating local invoice data according to acquired invoice information corresponding to an invoice associated with value-added tax declaration;
the lookup module 610: the local invoice data table is used for searching invoice data corresponding to the query information according to the received query information;
the generation module 620: and the system is used for generating a stub association detail report according to the invoice data corresponding to the query information.
The present invention is described above with reference to block diagrams and/or flowchart illustrations of methods, apparatus (systems) and/or computer program products according to embodiments of the invention. It will be understood that one block of the block diagrams and/or flowchart illustrations, and combinations of blocks in the block diagrams and/or flowchart illustrations, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, and/or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer and/or other programmable data processing apparatus, create means for implementing the functions/acts specified in the block diagrams and/or flowchart block or blocks.
Accordingly, the present invention may also be embodied in hardware and/or in software (including firmware, resident software, micro-code, etc.). Furthermore, the invention can take the form of a computer program product on a computer-usable or computer-readable storage medium having computer-usable or computer-readable program code embodied in the medium for use by or in connection with an instruction execution system. In the context of this document, a computer-usable or computer-readable medium may be any medium that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.
Claims (11)
1. A method for generating a report, the method comprising:
generating a local invoice data table according to the acquired invoice information corresponding to the invoice associated with the value-added tax declaration;
searching invoice information corresponding to the query information in the local invoice data table according to the received query information;
and generating a stub linkage detailed report according to the invoice information corresponding to the query information.
2. The method of claim 1, wherein the invoice information associated with the value-added tax declaration is obtained by:
after determining that the historical login time does not exist for the current login user, acquiring invoice information corresponding to all invoices associated with the value-added tax declaration; or
And after determining that the historical login time of the current login user exists, acquiring invoice information corresponding to the increment and alteration invoice associated with the increment tax declaration in the time period of the last login time and the current login time.
3. The method of claim 1, wherein after generating a local invoice data table based on the obtained invoice information corresponding to the invoice associated with the value-added tax declaration and before searching the invoice data corresponding to the query information in the local invoice data table based on the received query information, further comprising:
and writing invoice information of the invoices corresponding to the invoice identifications which are contained in the invoicing software and are related to the value-added tax declaration and not contained in the local invoice data table into the local invoice data table.
4. The method of claim 1, wherein after generating a local invoice data table based on the obtained invoice information corresponding to the invoice associated with the value-added tax declaration and before searching the invoice data corresponding to the query information in the local invoice data table based on the received query information, further comprising:
the invoice information of the invoices corresponding to the invoice identifications contained in the local invoice data table is compared, wherein the invoice identifications are contained in the invoicing software and are related to the value-added tax declaration;
and after determining that the invoice information of the invoice in the local invoice data table is inconsistent with the invoice information of the invoice related to the value-added tax declaration in the invoicing software, modifying the invoice information in the local invoice data table according to the invoice information of the invoice related to the value-added tax declaration in the invoicing software.
5. The method of claim 1, wherein the query information includes some or all of:
invoice code, invoice number, invoicing date, purchaser tax number and purchaser name;
the invoice category of the invoice associated with the value-added tax declaration comprises part or all of the following:
value-added tax general invoice, value-added tax special invoice, value-added tax electronic general invoice, motor vehicle invoice and roll invoice.
6. An apparatus for generating reports, the apparatus comprising: at least one processing unit and at least one memory unit, wherein the memory unit stores program code that, when executed by the processing unit, causes the processing unit to perform the following:
generating a local invoice data table according to the acquired invoice information corresponding to the invoice associated with the value-added tax declaration;
searching invoice information corresponding to the query information in the local invoice data table according to the received query information;
and generating a stub linkage detailed report according to the invoice information corresponding to the query information.
7. The apparatus of claim 6, wherein the invoice information associated with the value-added tax declaration is obtained by:
after determining that the historical login time does not exist for the current login user, acquiring invoice information corresponding to all invoices associated with the value-added tax declaration; or
And after determining that the historical login time of the current login user exists, acquiring invoice information corresponding to the increment and alteration invoice associated with the increment tax declaration in the time period of the last login time and the current login time.
8. The device of claim 6, wherein the processing unit is further to:
and writing invoice information of the invoices corresponding to the invoice identifications which are contained in the invoicing software and are related to the value-added tax declaration and not contained in the local invoice data table into the local invoice data table.
9. The device of claim 6, wherein the processing unit is further to:
the invoice information of the invoices corresponding to the invoice identifications contained in the local invoice data table is compared, wherein the invoice identifications are contained in the invoicing software and are related to the value-added tax declaration;
and after determining that the invoice information of the invoice in the local invoice data table is inconsistent with the invoice information of the invoice related to the value-added tax declaration in the invoicing software, modifying the invoice information in the local invoice data table according to the invoice information of the invoice related to the value-added tax declaration in the invoicing software.
10. The apparatus of claim 6, wherein the query information comprises some or all of:
invoice code, invoice number, invoicing date, purchaser tax number and purchaser name;
the invoice category of the invoice associated with the value-added tax declaration comprises part or all of the following:
value-added tax general invoice, value-added tax special invoice, value-added tax electronic general invoice, motor vehicle invoice and roll invoice.
11. An apparatus for generating reports, the apparatus comprising:
a data acquisition module: the system comprises a local invoice data table, a local invoice data table and a local invoice data table, wherein the local invoice data table is used for generating local invoice data according to acquired invoice information corresponding to an invoice associated with value-added tax declaration;
a searching module: the local invoice data table is used for searching invoice data corresponding to the query information according to the received query information;
a generation module: and the system is used for generating a stub association detail report according to the invoice data corresponding to the query information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811574018.7A CN111353833A (en) | 2018-12-21 | 2018-12-21 | Method and equipment for generating report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811574018.7A CN111353833A (en) | 2018-12-21 | 2018-12-21 | Method and equipment for generating report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111353833A true CN111353833A (en) | 2020-06-30 |
Family
ID=71195130
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811574018.7A Pending CN111353833A (en) | 2018-12-21 | 2018-12-21 | Method and equipment for generating report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111353833A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116976822A (en) * | 2023-08-03 | 2023-10-31 | 广东企企通科技有限公司 | Report automatic generation method, device, computer equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101169876A (en) * | 2007-11-06 | 2008-04-30 | 浪潮齐鲁软件产业有限公司 | Invoice self-help aging-identification method |
| CN101320444A (en) * | 2007-06-07 | 2008-12-10 | 华为技术有限公司 | Method, system and device for implementing electronic bill |
| CN101923758A (en) * | 2010-08-19 | 2010-12-22 | 浪潮齐鲁软件产业有限公司 | Method for transacting plain invoice expiration checking business by self-help tax service terminal |
| CN102087769A (en) * | 2009-12-03 | 2011-06-08 | 航天信息股份有限公司 | Invoice memory system and management method of tax control equipment |
| CN106709769A (en) * | 2016-12-08 | 2017-05-24 | 用友网络科技股份有限公司 | Automation method and device for exchanging plain invoice into value-added-tax special invoice |
-
2018
- 2018-12-21 CN CN201811574018.7A patent/CN111353833A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101320444A (en) * | 2007-06-07 | 2008-12-10 | 华为技术有限公司 | Method, system and device for implementing electronic bill |
| CN101169876A (en) * | 2007-11-06 | 2008-04-30 | 浪潮齐鲁软件产业有限公司 | Invoice self-help aging-identification method |
| CN102087769A (en) * | 2009-12-03 | 2011-06-08 | 航天信息股份有限公司 | Invoice memory system and management method of tax control equipment |
| CN101923758A (en) * | 2010-08-19 | 2010-12-22 | 浪潮齐鲁软件产业有限公司 | Method for transacting plain invoice expiration checking business by self-help tax service terminal |
| CN106709769A (en) * | 2016-12-08 | 2017-05-24 | 用友网络科技股份有限公司 | Automation method and device for exchanging plain invoice into value-added-tax special invoice |
Non-Patent Citations (2)
| Title |
|---|
| 张彦等: "列车移动补票系统研究与应用" * |
| 曾武斌;: "EJOURNAL电子存根原理和工作流程" * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116976822A (en) * | 2023-08-03 | 2023-10-31 | 广东企企通科技有限公司 | Report automatic generation method, device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10108921B2 (en) | Customs inspection and data processing system and method thereof for web-based processing of customs information | |
| US20090112743A1 (en) | System and method for reporting according to eu vat related legal requirements | |
| US20060200398A1 (en) | Accounting integrity verification method and apparatus | |
| CN111475513A (en) | Form generation method and device, electronic equipment and medium | |
| US10511453B2 (en) | Information processing system and charge calculation apparatus | |
| US7596500B1 (en) | System and method for processing import/export transactions | |
| CN113506166A (en) | Data processing method and device of target service and server | |
| CN106056418A (en) | Invoice submission method, device and system | |
| CN109978542B (en) | Accounts payable data management method, system, storage medium and electronic device | |
| CN113822749A (en) | Merchant settlement and payment processing method, device, equipment and medium based on RPA and AI | |
| CN113362025A (en) | Data accounting system, method, computer readable storage medium, electronic device | |
| CN111353833A (en) | Method and equipment for generating report | |
| CN110008772B (en) | Method and system for rapidly identifying and inputting invoice for tax administration | |
| EP3651106A1 (en) | Systems and methods for generating a digital identity of equipment on an equipment online marketplace platform | |
| CN116739684A (en) | Photovoltaic power cost automatic settlement and bill service method and system | |
| US9208527B2 (en) | General ledger (GL) journal delete/accounting line reversal web service | |
| US20140012830A1 (en) | Data verification system | |
| KR100375967B1 (en) | Taxpaper process system and method by internet | |
| CN115660842A (en) | Accounting checking method, device, equipment and storage medium | |
| CN114358707A (en) | Man-machine cooperative hybrid examination order decision method and system | |
| US11514488B1 (en) | Automatic synchronization of payment data across distributed systems | |
| CN114511318A (en) | Account accounting method and device and electronic equipment | |
| CN113792533A (en) | Data processing method, data processing device, storage medium and electronic equipment | |
| US7882153B1 (en) | Method and system for electronic messaging of trade data | |
| CN112561674A (en) | Passenger transport income settlement method, device, storage medium and electronic equipment |
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 |