CN107609968A - A kind of method and device based on EXCEL value-added tax data analyses - Google Patents

A kind of method and device based on EXCEL value-added tax data analyses Download PDF

Info

Publication number
CN107609968A
CN107609968A CN201710832624.3A CN201710832624A CN107609968A CN 107609968 A CN107609968 A CN 107609968A CN 201710832624 A CN201710832624 A CN 201710832624A CN 107609968 A CN107609968 A CN 107609968A
Authority
CN
China
Prior art keywords
value
added tax
data
item
representing
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
Application number
CN201710832624.3A
Other languages
Chinese (zh)
Inventor
吴祥荣
吴钢
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Individual
Original Assignee
Individual
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Priority to CN201710832624.3A priority Critical patent/CN107609968A/en
Publication of CN107609968A publication Critical patent/CN107609968A/en
Pending legal-status Critical Current

Links

Landscapes

  • Epoxy Compounds (AREA)

Abstract

The invention provides a kind of method and device based on EXCEL value-added tax data analyses, this method includes：Create former table, differentiation table and at least one analytical table；Developing table includes figure selection formula corresponding at least one VAT invoice project and each VAT invoice project；At least one analytical table includes at least one value-added tax analysis item, and different analytical tables correspond to different value-added tax data analysis requirements；Corresponding original value-added tax data on each VAT invoice are imported using former table；Original value-added tax data are extracted from former table using table is developed；The original value-added tax data extracted are imported into differentiation table；Selection analysis table；The each value-added tax analysis item included for selected analytical table, the data value corresponding to extraction in table is developed, and imported into analytical table；EXCEL value-added tax data analyses are carried out using analytical table.Therefore, scheme provided by the invention can improve the efficiency of value-added tax data analysis.

Description

EXCEL value-added tax data analysis-based method and device
Technical Field
The invention relates to the technical field of computers, in particular to a method and a device for analyzing value-added tax data based on EXCEL.
Background
With the continuous and deep promotion of national gold tax engineering, more and more enterprises are forcing the use of value-added tax. Therefore, the profit capacity, the operation capacity and the repayment capacity of the enterprise can be evaluated by reasonably analyzing the value-added tax data, and a basis is provided for the decision making of the enterprise.
At present, the method adopted for analyzing the value-added tax data of the enterprise is generally as follows: the value-added tax data to be analyzed is manually sorted from the original value-added tax data such as accounting, report data and the like. And then the sorted data are manually analyzed. However, manual processing is adopted in the data sorting and analyzing processes, so that the workload is large and errors are easy to occur. Therefore, the existing method is low in efficiency in analyzing the value-added tax data.
Disclosure of Invention
The embodiment of the invention provides a method and a device for analyzing value-added tax data based on EXCEL, which can improve the efficiency of value-added tax data analysis.
In a first aspect, an embodiment of the present invention provides a method for analyzing value-added tax data based on EXCEL, where the method includes:
creating an original table, an evolution table and at least one analysis table; wherein,
the evolution table comprises at least one value-added tax invoice item and a data acquisition formula corresponding to each value-added tax invoice item;
the at least one analysis table comprises at least one value-added tax analysis item, and different analysis tables correspond to different value-added tax data analysis requirements;
importing corresponding original value-added tax data on at least one value-added tax invoice by using the original table;
extracting original value-added tax data from the original table by using the at least one value-added tax invoice item in the evolution table and a corresponding access formula thereof;
importing the extracted original value-added tax data into the evolution table;
selecting an analysis table;
extracting a corresponding data value from the evolution table aiming at each value-added tax analysis item included in the selected analysis table, and importing the data value into the analysis table;
and performing EXCEL value-added tax data analysis by using the analysis table.
Preferably, in the evolution table,
when the value-added tax data corresponding to any one first value-added tax invoice item is digital data, the access formula corresponding to the first value-added tax invoice item includes: formula (1) or formula (2);
TA＝IFERROR(VALUE(MID(α！Q，k1，FIND(″Pn″，α！Q，k2)-k3))，″″) (1)
wherein, T isArepresenting the value-added tax data imported on the A-th unit grid, wherein the A-th unit grid corresponds to a first value-added tax invoice item, the alpha represents the original table, the Q represents the unit grid corresponding to the first value-added tax invoice item in the original table, and the k represents the unit grid corresponding to the first value-added tax invoice item1Representing a first preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is2Representing a second preset value; k is3Representing a third preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "VALUE" characterizes a function of text strings converted to numbers; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function;
TB＝IFERROR(MID(α！W，FIND(″Pn：″，α！W，k4)+k5，k6)，″″) (2)
wherein, T isBCharacterizing the value-added tax data imported on the B-th cell, wherein the B-th cell pairthe method comprises the steps of acquiring a first value-added tax invoice item, representing the original table by α, representing a unit grid corresponding to the first value-added tax invoice item in the original table by W, and representing the unit grid corresponding to the first value-added tax invoice item in the original table by k4Representing a fourth preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is5Representing a fifth preset numerical value; k is6Representing a sixth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; the "MID" characterizes a function that intercepts a specified number of characters from a string.
Preferably, in the evolution table,
when the value-added tax data corresponding to any second value-added tax invoice item is the character data, the access formula corresponding to the second value-added tax invoice item comprises a formula (3);
TC＝IFERROR(VLOOKUP(Z，α！R，k7，k8)，) (3)
wherein, T isCcharacterizing the value added tax data imported on the C unit grid, wherein the C unit grid corresponds to the second value added tax issue item, the alpha characterizing the original table, the k characterizing the original table7Representing a seventh preset numerical value; k is8Representing an eighth preset numerical value; the R represents a cell range corresponding to the second value-added tax invoice item in the original table; the Z represents a cell in the evolution table related to the second value-added tax invoice item; "IFERROR" characterizes a function that checks whether there is an error parameter; "VLOOLUP" characterizes the vertical lookup function.
Preferably, in the evolution table,
when any third value-added tax invoice item corresponds to the value-added tax data representing unit time, the access formula corresponding to the third value-added tax invoice item comprises the following steps: formula (4);
TD＝
IFERROR(CONCATENATE(MID(α！E，FIND(Pm，α！E，k9)+k10，k11)，″F″)，″″) (4)
wherein, T isDcharacterizing value-added tax data imported on a Dth cell, wherein the Dth cell corresponds to a third value-added tax invoice item, the alpha represents the original table, the E represents a cell corresponding to the third value-added tax invoice item in the original table, the Pm represents a corresponding item name of the third value-added tax invoice item in the original table, and the k represents9Representing a ninth preset numerical value; k is10Representing a tenth preset value; k is11Representing an eleventh preset numerical value; the F represents a unit time corresponding to the Pm; "IFERROR" characterizes a function that checks whether there is an error parameter; "CONCATENATE" characterizes a function that performs an operation on one or more values and returns one or more values; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function.
Preferably, in the evolution table,
when the value-added tax data corresponding to any fourth value-added tax invoice item represents the date, the access formula corresponding to the fourth value-added tax invoice item includes: formula (5);
TE＝IFERROR(DATE(MID(α！G，FIND(Pk，α！G，k12)+k13，k14)，
MID(α！G，FIND(Pk，α！G，k12)+k15，k16)，
MID(α！G，FIND(″Pk″，α！G，k12)+k17，k18) (5)
wherein, T isEcharacterizing the value-added tax data imported on the E-th cell corresponding to the fourth value-added tax invoice item, said alpha characterizing the original table, said G characterizing the cell corresponding to the fourth value-added tax invoice item in the original table, said PkCharacterizing the corresponding item name of the fourth value-added tax invoice item in the original table; k is12Representing a twelfth preset numerical value; k is13Representing a thirteenth preset numerical value; k is14Representing a fourteenth preset numerical value; k is15Representing a fifteenth preset numerical value; k is16Representing a sixteenth preset numerical value; k is17Representing a seventeenth preset value; k is18Representing an eighteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "DATE" characterizes a function of the DATE of acquisition; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function.
Preferably, in the evolution table,
when the value-added tax data corresponding to any fifth value-added tax invoice item is data with a specified digit length, the access formula corresponding to the fifth value-added tax invoice item includes: formula (6);
TF＝IFERROR(ROUND(H/L，k19)，″″) (6)
wherein, T isFRepresenting value-added tax data imported on the F-th unit grid, wherein the F-th unit grid corresponds to a fifth value-added tax invoice item; the H represents a first cell related to the Fth cell in the evolution table; the L represents a second cell related to the Fth cell in the evolution table; k is19Representing a nineteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "ROUND" characterizes a function that ROUNDs a value by a specified number of digits.
Preferably, the first and second electrodes are formed of a metal,
the extracting, for each value-added tax analysis item included in the selected analysis table, a corresponding data value in the evolution table includes:
executing each value-added tax analysis item in the selected analysis table, determining whether value-added tax data corresponding to the current value-added tax analysis item exists in the evolution table, if so, determining the existing value-added tax data as a data value corresponding to the current value-added tax analysis item, and extracting the data value corresponding to the current value-added tax analysis item from the evolution table; otherwise, determining a preset null value as a data value corresponding to the current value-added tax.
Preferably, the first and second electrodes are formed of a metal,
the at least one value-added tax invoice item comprises: at least one or more of invoice number, purchaser tax number, purchaser name, seller tax number, seller name, transaction amount, tax rate, date of authentication, date of invoicing.
Preferably, the first and second electrodes are formed of a metal,
after importing the extracted original value-added tax data into the evolution table, the method further includes:
monitoring the integrity of original value-added tax data in the evolution table, and generating a monitoring report comprising incomplete value-added tax data when the original value-added tax data is monitored to be incomplete;
receiving externally input supplementary data aiming at the monitoring report, and supplementing the supplementary data into the evolution table.
In a second aspect, an embodiment of the present invention provides an apparatus for analyzing based on EXCEL value-added tax data, where the apparatus includes:
the system comprises a creating unit, a calculating unit and a processing unit, wherein the creating unit is used for creating an original table, an evolution table and at least one analysis table; the evolution table comprises at least one value-added tax invoice item and a data acquisition formula corresponding to each value-added tax invoice item; the at least one analysis table comprises at least one value-added tax analysis item, and different analysis tables correspond to different value-added tax data analysis requirements;
the original table importing unit is used for importing corresponding original value-added tax data on at least one value-added tax invoice by using the original table created by the creating unit;
the extraction unit is used for extracting original value-added tax data from the original table by using the at least one value-added tax invoice item in the evolution table and the corresponding access formula;
an evolution table importing unit, which imports the original value-added tax data extracted by the extracting unit into the evolution table;
an analysis table importing unit for selecting an analysis table; extracting a corresponding data value from the evolution table aiming at each value-added tax analysis item included in the selected analysis table, and importing the data value into the analysis table;
and the analysis unit is used for carrying out EXCEL value-added tax data analysis by utilizing the analysis table.
Preferably, in the evolution table,
when the value-added tax data corresponding to any one first value-added tax invoice item is digital data, the access formula corresponding to the first value-added tax invoice item includes: formula (1) or formula (2);
TA＝IFERROR(VALUE(MID(α！Q，k1，FIND(″Pn″，α！Q，k2)-k3))，″″) (1)
wherein, T isArepresenting the value-added tax data imported on the A-th unit grid, wherein the A-th unit grid corresponds to a first value-added tax invoice item, the alpha represents the original table, the Q represents the unit grid corresponding to the first value-added tax invoice item in the original table, and the k represents the unit grid corresponding to the first value-added tax invoice item1Representing a first preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is2Representing a second preset value; k is3Representing a third preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "VALUE" characterizes a function of text strings converted to numbers; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterisation of locationA function;
TB＝IFERROR(MID(α！W，FIND(″Pn：″，α！W，k4)+k5，k6)，″″) (2)
wherein, T isBrepresenting the value-added tax data imported on the B-th unit grid, wherein the B-th unit grid corresponds to a first value-added tax invoice item, the alpha represents the original table, the W represents the unit grid corresponding to the first value-added tax invoice item in the original table, and the k represents the unit grid corresponding to the first value-added tax invoice item4Representing a fourth preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is5Representing a fifth preset numerical value; k is6Representing a sixth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; the "MID" characterizes a function that intercepts a specified number of characters from a string.
Preferably, in the evolution table,
when the value-added tax data corresponding to any second value-added tax invoice item is the character data, the access formula corresponding to the second value-added tax invoice item comprises a formula (3);
TC＝IFERROR(VLOOKUP(Z，α！R，k7，k8)，) (3)
wherein, T isCcharacterizing the value added tax data imported on the C unit grid, wherein the C unit grid corresponds to the second value added tax issue item, the alpha characterizing the original table, the k characterizing the original table7Representing a seventh preset numerical value; k is8Representing an eighth preset numerical value; the R represents a cell range corresponding to the second value-added tax invoice item in the original table; the Z represents a cell in the evolution table related to the second value-added tax invoice item; "IFERROR" characterizes a function that checks whether there is an error parameter; "VLOOLUP" characterizes the vertical lookup function.
Preferably, in the evolution table,
when any third value-added tax invoice item corresponds to the value-added tax data representing unit time, the access formula corresponding to the third value-added tax invoice item comprises the following steps: formula (4);
TD＝
IFERROR(CONCATENATE(MID(α！E，FIND(Pm，α！E，k9)+k10，k11)，″F″)，″″) (4)
wherein, T isDcharacterizing value-added tax data imported on a Dth cell, wherein the Dth cell corresponds to a third value-added tax invoice item, the alpha represents the original table, the E represents a cell corresponding to the third value-added tax invoice item in the original table, the Pm represents a corresponding item name of the third value-added tax invoice item in the original table, and the k represents9Representing a ninth preset numerical value; k is10Representing a tenth preset value; k is11Representing an eleventh preset numerical value; the F represents a unit time corresponding to the Pm; "IFERROR" characterizes a function that checks whether there is an error parameter; "CONCATENATE" characterizes a function that performs an operation on one or more values and returns one or more values; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function.
Preferably, in the evolution table,
when the value-added tax data corresponding to any fourth value-added tax invoice item represents the date, the access formula corresponding to the fourth value-added tax invoice item includes: formula (5);
TE＝IFERROR(DATE(MID(α！G，FIND(Pk，α！G，k12)+k13，k14)，
MID(α！G，FIND(Pk，α！G，k12)+k15，k16)，
MID(α！G，FIND(″Pk″，α！G，k12)+k17，k18) (5)
wherein, T isEcharacterizing the value-added tax data imported on the E-th cell corresponding to the fourth value-added tax invoice item, said alpha characterizing the original table, said G characterizing the cell corresponding to the fourth value-added tax invoice item in the original table, said PkCharacterizing the corresponding item name of the fourth value-added tax invoice item in the original table; k is12Representing a twelfth preset numerical value; k is13Representing a thirteenth preset numerical value; k is14Representing a fourteenth preset numerical value; k is15Representing a fifteenth preset numerical value; k is16Representing a sixteenth preset numerical value; k is17Representing a seventeenth preset value; k is18Representing an eighteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "DATE" characterizes a function of the DATE of acquisition; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function.
Preferably, in the evolution table,
when the value-added tax data corresponding to any fifth value-added tax invoice item is data with a specified digit length, the access formula corresponding to the fifth value-added tax invoice item includes: formula (6);
TF＝IFERROR(ROUND(H/L，k19)，″″) (6)
wherein, T isFRepresenting value-added tax data imported on the F-th unit grid, wherein the F-th unit grid corresponds to a fifth value-added tax invoice item; the H represents a first cell related to the Fth cell in the evolution table; the L represents a second cell related to the Fth cell in the evolution table; k is19Representing a nineteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "ROUND" characterizes a function that ROUNDs a value by a specified number of digits.
Preferably, the first and second electrodes are formed of a metal,
the judging subunit is configured to execute each value-added tax analysis item included in the selected analysis table, determine whether value-added tax data corresponding to the current value-added tax analysis item exists in the evolution table, determine, if yes, the existing value-added tax data as a data value corresponding to the current value-added tax analysis item, and extract, in the evolution table, the data value corresponding to the current value-added tax analysis item; otherwise, determining a preset null value as a data value corresponding to the current value-added tax.
Preferably, the first and second electrodes are formed of a metal,
further comprising: a monitoring unit and a supplementing unit;
the monitoring unit is used for monitoring the integrity of the original value-added tax data in the evolution table, and when the original value-added tax data is monitored to be incomplete, a monitoring report comprising the incomplete value-added tax data is generated;
the supplementary unit is used for receiving supplementary data which are input from the outside and are aimed at the monitoring report generated by the monitoring unit, and supplementing the supplementary data into the evolution table.
The embodiment of the invention provides a method and a device for analyzing value-added tax data based on EXCEL. And then, importing the corresponding original value-added tax data on each value-added tax invoice by using the original table. And extracting original value-added tax data from the original table by using each value-added tax invoice item and a corresponding access formula in the evolution table, and importing the extracted original value-added tax data into the evolution table. And then selecting an analysis table meeting the current service requirement from the created analysis tables, extracting corresponding data values from the evolution table aiming at each value-added tax analysis item included in the selected analysis table, and importing the extracted data values into the selected analysis table. And after the data value is imported, the EXCEL value-added tax data analysis is carried out by utilizing the analysis table. According to the process, the original value-added tax data on each value-added tax invoice are sorted and analyzed through the original table, the evolution table and the analysis table, and the original value-added tax data on the value-added tax invoice do not need to be sorted and analyzed manually. Therefore, the scheme provided by the embodiment of the invention can improve the efficiency of value-added tax data analysis.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
FIG. 1 is a flow chart of a method for analyzing based on EXCEL value-added tax data according to an embodiment of the present invention;
FIG. 2 is a flow chart of a method for analyzing based on EXCEL value-added tax data according to another embodiment of the present invention;
FIG. 3 is a hardware configuration diagram of an apparatus for analyzing value-added tax data based on EXCEL according to an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of an EXCEL-based value-added tax data analysis apparatus according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of an EXCEL-based value-added tax data analysis apparatus according to another embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer and more complete, the technical solutions in the embodiments of the present invention will be described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention, and based on the embodiments of the present invention, all other embodiments obtained by a person of ordinary skill in the art without creative efforts belong to the scope of the present invention.
As shown in fig. 1, an embodiment of the present invention provides a method based on EXCEL value-added tax data analysis, which may include the following steps:
step 101: creating an original table, an evolution table and at least one analysis table; the evolution table comprises at least one value-added tax invoice item and a data acquisition formula corresponding to each value-added tax invoice item; the at least one analysis table comprises at least one value-added tax analysis item, and different analysis tables correspond to different value-added tax data analysis requirements;
step 102: importing corresponding original value-added tax data on at least one value-added tax invoice by using the original table;
step 103: extracting original value-added tax data from the original table by using the at least one value-added tax invoice item in the evolution table and a corresponding access formula thereof;
step 104: importing the extracted original value-added tax data into the evolution table;
step 105: selecting an analysis table;
step 106: extracting a corresponding data value from the evolution table aiming at each value-added tax analysis item included in the selected analysis table, and importing the data value into the analysis table;
step 107: and performing EXCEL value-added tax data analysis by using the analysis table.
According to the embodiment shown in fig. 1, the original table, the evolution table, and the analysis table are first created. And then, importing the corresponding original value-added tax data on each value-added tax invoice by using the original table. And extracting original value-added tax data from the original table by using each value-added tax invoice item and a corresponding access formula in the evolution table, and importing the extracted original value-added tax data into the evolution table. And then selecting an analysis table meeting the current service requirement from the created analysis tables, extracting corresponding data values from the evolution table aiming at each value-added tax analysis item included in the selected analysis table, and importing the extracted data values into the selected analysis table. And after the data value is imported, the EXCEL value-added tax data analysis is carried out by utilizing the analysis table. According to the process, the original value-added tax data on each value-added tax invoice are sorted and analyzed through the original table, the evolution table and the analysis table, and the original value-added tax data on the value-added tax invoice do not need to be sorted and analyzed manually. Therefore, the scheme provided by the embodiment of the invention can improve the efficiency of value-added tax data analysis.
In an embodiment of the present invention, the at least one value-added tax invoice item referred to in step 101 of the flowchart shown in fig. 1 may include at least one or more of an invoice number, a purchaser tax name, a seller tax number, a seller tax name, a transaction amount, a tax rate, an authentication date, and an invoicing date.
In this embodiment, the specific content in at least one value-added tax invoice item may be determined according to the service requirement. At least one or more of invoice number, purchasing party tax number, purchasing party name, selling party tax number, selling party name, transaction amount, tax rate, authentication date and invoicing date is selected, which is a preferred mode, and other value-added tax invoice items can be selected according to service requirements. In addition, in the present embodiment, the authentication date may include the authentication year and the authentication month. The transaction amount may include a non-tax amount and a tax amount.
According to the above embodiment, the at least one value-added tax invoice item included in the evolution table may select at least one or more of an invoice number, a purchaser tax number, a purchaser name, a seller tax number, a seller name, a transaction amount, a tax rate, an authentication date, and an invoicing date according to the service requirement. Therefore, the service applicability of the evolution table is strong.
In one embodiment of the present invention, each value-added tax analysis item included in each analysis table may be determined according to service requirements. The value-added tax analysis item can be selected from the value-added tax invoice item. For example, when the value-added tax invoice item includes an invoice number, a purchasing party tax number, a purchasing party name, a selling party tax number, a selling party name, a transaction amount, a tax rate, an authentication date, and an invoicing date, the value-added tax analysis item in the analysis table a may be the invoice number, the purchasing party tax number, the purchasing party name, the selling party tax number, the selling party name, and the tax rate.
In an embodiment of the present invention, the access formula corresponding to each value-added tax invoice item included in the evolution table may be determined according to the service requirement. And at least the following conditions exist:
the first condition is as follows: in one embodiment of the invention, in the evolution table referred to in step 101 of the flow chart shown in fig. 1,
when the value-added tax data corresponding to any one first value-added tax invoice item is digital data, the access formula corresponding to the first value-added tax invoice item includes: formula (1) or formula (2);
TA＝IFERROR(VALUE(MID(α！Q，k1，FIND(″Pn″，α！Q，k2)-k3))，″″) (1)
wherein, T isArepresenting the value-added tax data imported on the A-th unit grid, wherein the A-th unit grid corresponds to a first value-added tax invoice item, the alpha represents the original table, the Q represents the unit grid corresponding to the first value-added tax invoice item in the original table, and the k represents the unit grid corresponding to the first value-added tax invoice item1Representing a first preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is2Representing a second preset value; k is3Representing a third preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "VALUE" representation text string conversionA function that is numerical; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function;
TB＝IFERROR(MID(α！W，FIND(″Pn：″，α！W，k4)+k5，k6)，″″) (2)
wherein, T isBrepresenting the value-added tax data imported on the B-th unit grid, wherein the B-th unit grid corresponds to a first value-added tax invoice item, the alpha represents the original table, the W represents the unit grid corresponding to the first value-added tax invoice item in the original table, and the k represents the unit grid corresponding to the first value-added tax invoice item4Representing a fourth preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is5Representing a fifth preset numerical value; k is6Representing a sixth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; the "MID" characterizes a function that intercepts a specified number of characters from a string.
In the present embodiment, a method of using formula (1) will be described: and finding the cell corresponding to the first value-added tax invoice item in the original table through a 'FIND' function according to the item name Pn corresponding to the first value-added tax invoice item in the original table. And then determining a character string corresponding to the item name Pn according to the set specified number of characters through an MID function. And converting the determined character string into numbers through a 'VALUE' function. And finally, detecting whether the converted number is a null value or not through an IFERROR function, and determining the converted number as the imported value-added tax data when the converted number is detected to be a non-null value. And when the converted number is detected to be a null value, determining the null value as the imported value-added tax data.
In the present embodiment, a method of using formula (2) will be described: firstly, determining a cell corresponding to the first value-added tax invoice item in an original table according to the item name Pn corresponding to the first value-added tax invoice item in the original table through a 'FIND' function. Then, the character string corresponding to the item name Pn is determined by the specified number of characters set by the "MID" function. And finally, detecting whether the determined character string is a null value or not through an IFERROR function, and determining the character string as the imported value-added tax data when the character string is detected to be a non-null value. And when the character string is detected to be null, determining that the null is the imported value-added tax data.
Case two: in one embodiment of the invention, in the evolution table referred to in step 101 of the flow chart shown in fig. 1,
when the value-added tax data corresponding to any second value-added tax invoice item is the character data, the access formula corresponding to the second value-added tax invoice item comprises a formula (3);
TC＝IFERROR(VLOOKUP(Z，α！R，k7，k8)，) (3)
wherein, T isCcharacterizing the value added tax data imported on the C unit grid, wherein the C unit grid corresponds to the second value added tax issue item, the alpha characterizing the original table, the k characterizing the original table7Representing a seventh preset numerical value; k is8Representing an eighth preset numerical value; the R represents a cell range corresponding to the second value-added tax invoice item in the original table; the Z represents a cell in the evolution table related to the second value-added tax invoice item; "IFERROR" characterizes a function that checks whether there is an error parameter; "VLOOLUP" characterizes the vertical lookup function.
In this embodiment, a method of using formula (3) will be described: firstly, determining a cell range R corresponding to a second value-added tax invoice item in an original table through a VLOOLUP function, and then determining data corresponding to the second value-added tax invoice item in the cell range R according to a cell related to the second value-added tax invoice item in an evolution table. And then detecting whether the determined data is a null value or not through an IFERROR function, and determining the data to be imported value-added tax data when the determined data is a non-null value. And when the character string is detected to be null, determining that the null is the imported value-added tax data.
Case three: in one embodiment of the invention, in the evolution table referred to in step 101 of the flow chart shown in fig. 1,
when any third value-added tax invoice item corresponds to the value-added tax data representing unit time, the access formula corresponding to the third value-added tax invoice item comprises the following steps: formula (4);
TD＝
IFERROR(CONCATENATE(MID(α！E，FIND(Pm，α！E，k9)+k10，k11)，″F″)，″″) (4)
wherein, T isDcharacterizing value-added tax data imported on a Dth cell, wherein the Dth cell corresponds to a third value-added tax invoice item, the alpha represents the original table, the E represents a cell corresponding to the third value-added tax invoice item in the original table, the Pm represents a corresponding item name of the third value-added tax invoice item in the original table, and the k represents9Representing a ninth preset numerical value; k is10Representing a tenth preset value; k is11Representing an eleventh preset numerical value; the F represents a function for checking whether an error parameter exists or not in a unit time IFERROR corresponding to the Pm; "CONCATENATE" characterizes a function that performs an operation on one or more values and returns one or more values; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function.
In this embodiment, a method of using equation (4) will be described: and finding out the cell corresponding to the third value-added tax invoice item in the original table through a 'FIND' function by using the item name Pm corresponding to the third value-added tax invoice item in the original table. And determining a character string corresponding to the project name Pm according to the specified number of characters through an MID function. And then, the character string determined by the "MID" function is operated to the data of the set type through the "CONCATENATE" function. And finally, detecting whether the determined data is a null value or not through an 'IFERROR' function, for example, when the data is detected to be a normal value, determining the data to be imported value-added tax data. And when the data is detected to be null, determining that the null is the imported value-added tax data.
Case four: in one embodiment of the invention, in the evolution table referred to in step 101 of the flow chart shown in fig. 1,
when the value-added tax data corresponding to any fourth value-added tax invoice item represents the date, the access formula corresponding to the fourth value-added tax invoice item includes: formula (5);
TE＝IFERROR(DATE(MID(α！G，FIND(Pk，α！G，k12)+k13，k14)，
MID(α！G，FIND(Pk，α！G，k12)+k15，k16)，
MID(α！G，FIND(″Pk″，α！G，k12)+k17，k18) (5)
wherein, T isEcharacterizing the value-added tax data imported on the E-th cell corresponding to the fourth value-added tax invoice item, said alpha characterizing the original table, said G characterizing the cell corresponding to the fourth value-added tax invoice item in the original table, said PkCharacterizing the corresponding item name of the fourth value-added tax invoice item in the original table; k is12Representing a twelfth preset numerical value; k is13Representing a thirteenth preset numerical value; k is14Representing a fourteenth preset numerical value; k is15Representing a fifteenth preset numerical value; k is16Representing a sixteenth preset numerical value; k is17Representing a seventeenth preset value; k is18Representing an eighteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "DATE" characterizes a function of the DATE of acquisition; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function.
In this embodiment, for equation (5)) The method of use of (a): and respectively finding out the cell corresponding to the fourth value-added tax invoice item in the original table through three 'FIND' functions according to the item name corresponding to the fourth value-added tax invoice item in the original table. Then determining the project name P according to the designated number of the set characters by three MID functionskA corresponding character string. The determined individual character strings are then converted into DATE type data by the "DATE" function. And finally, detecting whether the converted date type data is a null value or not through a function 'IFERROR', and determining the date type data as imported value-added tax data when the date type data is detected to be a non-null value. And when the date type data is detected to be null, determining that the null is the imported value-added tax data.
Case five: in one embodiment of the invention, in the evolution table referred to in step 101 of the flow chart shown in fig. 1,
when the value-added tax data corresponding to any fifth value-added tax invoice item is data with a specified digit length, the access formula corresponding to the fifth value-added tax invoice item includes: formula (6);
TF＝IFERROR(ROUND(H/L，k19)，″″) (6)
wherein, T isFRepresenting value-added tax data imported on the F-th unit grid, wherein the F-th unit grid corresponds to a fifth value-added tax invoice item; the H represents a first cell related to the Fth cell in the evolution table; the L represents a second cell related to the Fth cell in the evolution table; k is19Representing a nineteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "ROUND" characterizes a function that ROUNDs a value by a specified number of digits.
In this embodiment, H is a first cell related to the F-th cell in the evolution table, and L is a second cell related to the F-th cell in the evolution table. And carrying out quotient finding by using the data in the first cell and the second cell. After obtaining the quotient, utilizeThe "ROUND" function is based on a specified number of bits k19The resulting quotient is rounded off. And then detecting whether the obtained value is a null value or not by using an IFERROR function, and determining the obtained value to be imported value-added tax data when the obtained value is detected to be a non-null value. And when the obtained numerical value is detected to be a null value, determining the null value as the imported value-added tax data. Nineteenth preset value k19Is a set decimal place.
According to the embodiment, the original value-added tax data corresponding to each value-added tax invoice item is extracted through the access formula corresponding to the value-added tax invoice item, so that the matching degree of the extracted original value-added tax data and the value-added tax invoice item is high.
In an embodiment of the present invention, step 106 in the flowchart shown in fig. 1 above extracts, for each value-added tax analysis item included in the selected analysis table, a corresponding data value in the evolution table, including:
executing each value-added tax analysis item in the selected analysis table, determining whether value-added tax data corresponding to the current value-added tax analysis item exists in the evolution table, if so, determining the existing value-added tax data as a data value corresponding to the current value-added tax analysis item, and extracting the data value corresponding to the current value-added tax analysis item from the evolution table; otherwise, determining a preset null value as a data value corresponding to the current value-added tax.
In this embodiment, for each value-added tax analysis item included in the selected analysis table, a data mapping method or a data perspective method may be adopted to extract a corresponding data value in the evolution table. When the data perspective method is adopted, the data perspective method can be realized in a data perspective table mode.
In an embodiment of the present invention, after the step 106 in the flowchart shown in fig. 1 imports the extracted original value-added tax data into the evolution table, the method further includes:
monitoring the integrity of original value-added tax data in the evolution table, and generating a monitoring report comprising incomplete value-added tax data when the original value-added tax data is monitored to be incomplete;
receiving externally input supplementary data aiming at the monitoring report, and supplementing the supplementary data into the evolution table.
In this embodiment, the method for monitoring the integrity of the original value-added tax data in the evolution table includes at least the following two ways:
the first method is as follows: and monitoring whether the data corresponding to each value-added tax invoice item in the evolution table is a null value or not, and when the data corresponding to at least one value-added tax invoice item in the evolution table is monitored to be the null value, determining that the original value-added tax data in the evolution table is incomplete, and generating a monitoring report.
The second method comprises the following steps: setting a character string length threshold value for each value-added tax invoice item, and monitoring whether the character string length of data corresponding to each value-added tax invoice item in the evolution table is consistent with the length threshold value. And when the condition that the data corresponding to at least one value-added tax invoice item in the evolution table is inconsistent with the corresponding character string length threshold is monitored, determining that the original value-added tax data in the evolution table is incomplete, and generating a monitoring report.
In this embodiment, the monitoring report includes value-added tax invoices corresponding to incomplete value-added tax invoice items. The service personnel can determine supplementary data for the monitoring report according to the monitoring report so as to supplement the supplementary data into the evolution table.
According to the above embodiment, after the extracted original value-added tax data is imported into the evolution table, the integrity of the original value-added tax data in the evolution table needs to be monitored. When the original value-added tax data is incomplete, the incomplete data can be supplemented, so that the integrity of the original value-added tax data in the evolution table can be improved.
In the following, the value added tax invoice 1, the value added tax invoice 2, and the value added tax invoice 3 are analyzed by EXCEL value added tax data as an example. The method based on EXCEL value-added tax data analysis is expanded and explained, as shown in FIG. 2, the method based on EXCEL value-added tax data analysis may include the following steps:
step 201: creating an original table, an evolution table and at least one analysis table; the evolution table comprises at least one value-added tax invoice item and a data acquisition formula corresponding to each value-added tax invoice item; at least one analysis table comprises at least one value-added tax analysis item, and different analysis tables correspond to different value-added tax data analysis requirements.
In this step, the value-added tax invoice items included in the created evolution table are respectively: invoice number, purchaser name, seller tax number, seller name, amount, tax rate, year of authentication, month of authentication, and date of invoicing. The system comprises a formula (1) for taking out money and tax amount correspondingly, a formula (2) for taking out invoice numbers and tax numbers of sales parties correspondingly, a formula (3) for taking out money and name of purchase parties correspondingly, a formula (4) for taking out money and name of sales parties correspondingly, a formula (5) for taking out invoices and dates correspondingly, and a formula (6) for taking out tax rate correspondingly. Two analysis tables are created. The value added tax analysis items in the analysis table 1 are the name of the buyer, the name of the seller, the month of authentication and the amount of tax. The value added tax analysis items included in the analysis table 2 are invoice number, name of seller, tax number of seller, billing date, tax rate, non-tax amount, tax amount and name of purchaser.
Step 202: and importing corresponding original value-added tax data on at least one value-added tax invoice by using the original table.
In the step, the original table is used for importing the corresponding original value-added tax data on the value-added tax invoice 1, the value-added tax invoice 2 and the value-added tax invoice 3 to form the original table shown in the table-1.
TABLE-1
Step 203: and extracting the original value-added tax data from the original table by using at least one value-added tax invoice item in the evolution table and a corresponding access formula.
In this step, the original value-added tax data corresponding to the value-added tax invoice 1 is extracted as an example for explanation:
because the amount and the tax amount corresponding to the access formula are both access formula (1), the original value-added tax data corresponding to the amount is extracted from the original table for explanation: the cell B2 corresponding to "amount" is found in "Table-1" by the "FIND" function according to the item name "amount" corresponding to "amount" in the original table "Table-1". Then determining the amount of the character string corresponding to the amount according to the set specified number of the characters through an MID function: 51158.97". And then the determined character string is used for determining the amount by a 'VALUE' function: 51158.97 "to a number 51158.97. Finally, the function "IFERROR" is used to check 51158.97 whether the value is null, obviously, when 51158.97 number is non-null, 51158.97 is determined as the imported value-added tax data, and the imported value-added tax data is extracted.
Because the invoice number and the corresponding access formula of the sales side tax number are both access formulas (2), the original value-added tax data corresponding to the invoice number is extracted from the original table for explanation: first, the cell B2 corresponding to the "invoice number" is determined in the "table-1" by the "FIND" function according to the item name "number" corresponding to the "invoice number" in the original table "table-1". The designated number of characters set by the "MID" function then determines the character string "00677393" corresponding to the "number". And finally, detecting whether the determined character string '00677393' is a null value through the function 'IFERROR', finally detecting whether the character string '00677393' is a null value through the function 'IFERROR', and obviously, when the number '00677393' is a non-null value, determining '00677393' as the imported value-added tax data and extracting the imported value-added tax data.
Because the access formulas corresponding to the buyer name and the seller name are both access formula (3), the original value-added tax data corresponding to the buyer name is extracted from the original table for explanation: firstly, determining a cell range corresponding to a "buyer name" in an original table through a "VLOOLUP" function, and then determining data "Nanjing XX composite plastics Limited company" corresponding to the "buyer name" according to the fact that a cell "buyer tax number" related to the "buyer name" in an evolution table is in the cell range. And finally, detecting whether the Nanjing XX composite plastic company Limited is empty or not through a function IFERROR, and determining the Nanjing XX composite plastic company Limited as imported value-added tax data and extracting when the Nanjing XX composite plastic company Limited is non-empty obviously.
Because the access formulas corresponding to the authentication years and the authentication months are both access formulas (4), the original value-added tax data corresponding to the authentication years extracted from the original table is taken as an example for explanation: the cell B2 corresponding to the "year of authentication" is found in "table-1" by the "FIND" function using the item name "date of authentication" corresponding to the "year of authentication" in the original table "table-1". And determining a character string '2017-04-27' corresponding to the item name 'authentication date' according to the specified number of characters through an 'MID' function. The string "2017-04-27" determined by the function "MID" is then passed through the "CONCATENATE" function. The calculation is performed to set type data "2017". And finally, detecting whether the value of the '2017' is a null value or not through a function 'IFERROR', and if the value of the '2017' is a non-null value, determining the '2017' as the imported value-added tax data and extracting.
The numerical formulas corresponding to the invoicing dates are all numerical formulas (5), and the original value-added tax data corresponding to the invoicing dates are extracted from the original table for explanation by taking as an example: according to the item name 'billing date' corresponding to the 'billing date' in the original table 'table-1', the cell B2 corresponding to the 'billing date' is found in the 'table-1' through three 'FIND' functions respectively. Then, the three "MID" functions determine the character strings "2017", "04", and "08" corresponding to the item name "invoicing date" respectively according to the set specified number of characters. The determined respective character strings "2017", "04", and "08" are then converted into DATE type data 2017/04/08 by the "DATE" function. And finally, detecting whether the converted date type data 2017/04/08 is a null value or not through a function 'IFERROR', obviously, if the '2017/04/08' is a non-null value, determining that the '2017/04/08' is imported value-added tax data, and extracting.
The access formulas corresponding to the tax rates are all access formulas (6), and the original value-added tax data corresponding to the tax rates are extracted from the original table for explanation by taking as an example: h is the first cell related to the tax rate in the evolution table, and L is the second cell related to the tax rate in the evolution table. The quotient is determined using the data 8697.03 in the first cell and the data 51158.97 in the second cell. After the quotient is obtained, the quotient is calculated according to the specified digit k by using a 'ROUND' function19The resulting quotient was rounded to give 0.17. And finally, detecting whether the value of 0.17 is a null value or not through the function IFERROR, and if the value of 0.17 is a non-null value, determining that the value of 0.17 is imported value-added tax data and extracting.
Step 204: and importing the extracted original value-added tax data into an evolution table.
In this embodiment, the extracted original value-added tax data is imported into an evolution table to form an evolution table shown in table-2.
TABLE-2
Step 205: monitoring whether the original value-added tax data in the evolution table is complete, if so, executing step 208; otherwise, step 206 is performed.
In this step, if the original value-added tax data in the evolution table is detected to be complete, step 208 is executed.
Step 206: and when the original value-added tax data is monitored to be incomplete, generating a monitoring report comprising the incomplete value-added tax data.
Step 207: and receiving externally input supplementary data aiming at the monitoring report, and supplementing the supplementary data into the evolution table.
Step 208: an analysis table is selected.
In this step, analysis table 1 is selected according to the service requirements.
Step 209: and sequentially selecting one value-added tax analysis item from the value-added tax analysis items included in the selected analysis table as the current value-added tax analysis item.
Step 210: determining whether value-added tax data corresponding to the current value-added tax analysis item exists in the evolution table, if so, executing step 211; otherwise, step 212 is performed.
Step 211: and determining the existing value-added tax data as the data value corresponding to the current value-added tax analysis item, extracting the data value corresponding to the current value-added tax analysis item from the evolution table, and executing the step 213.
Step 212: and determining the preset null value as a data value corresponding to the current value-added tax.
Step 213: judging whether the current value-added tax analysis item is the last value-added tax analysis item or not, if so, executing step 214; otherwise, step 209 is performed.
Step 214: and importing the extracted data value into an analysis table.
In this step, the extracted data values are imported into an analysis table to form an analysis table as shown in table-3.
TABLE-3
Step 215: and performing EXCEL value-added tax data analysis by using the analysis table.
As shown in fig. 3 and 4, the embodiment of the invention provides an apparatus based on EXCEL value-added tax data analysis. The device embodiments may be implemented by software, or by hardware, or by a combination of hardware and software. From a hardware level, as shown in fig. 3, for a hardware structure diagram of a device where the apparatus based on EXCEL value-added tax data analysis provided in the embodiment of the present invention is located, in addition to the processor, the memory, the network interface, and the nonvolatile memory shown in fig. 3, the device where the apparatus is located in the embodiment may also include other hardware, such as a forwarding chip responsible for processing a packet, and the like. Taking a software implementation as an example, as shown in fig. 4, as a logical apparatus, the apparatus is formed by reading a corresponding computer program instruction in a non-volatile memory into a memory by a CPU of a device in which the apparatus is located and running the computer program instruction. The apparatus based on EXCEL value-added tax data analysis provided by this embodiment includes:
a creating unit 401, configured to create an original table, an evolution table, and at least one analysis table; the evolution table comprises at least one value-added tax invoice item and a data acquisition formula corresponding to each value-added tax invoice item; the at least one analysis table comprises at least one value-added tax analysis item, and different analysis tables correspond to different value-added tax data analysis requirements;
an original table importing unit 402, configured to import, by using the original table created by the creating unit 401, original value-added tax data corresponding to at least one value-added tax invoice;
an extracting unit 403, configured to extract original value-added tax data from the original table by using the at least one value-added tax invoice item in the evolution table and a corresponding access formula thereof;
an evolution table importing unit 404, which imports the original value-added tax data extracted by the extracting unit 403 into the evolution table;
an analysis table importing unit 405 for selecting an analysis table; extracting a corresponding data value from the evolution table aiming at each value-added tax analysis item included in the selected analysis table, and importing the data value into the analysis table;
and the analysis unit 406 is used for performing EXCEL value-added tax data analysis by using the analysis table.
According to the embodiment shown in fig. 4, the original value-added tax data on each value-added tax invoice is sorted and analyzed through the original table, the evolution table and the analysis table, and the original value-added tax data on the value-added tax invoice does not need to be sorted and analyzed manually. Therefore, the scheme provided by the embodiment of the invention can improve the efficiency of value-added tax data analysis.
In an embodiment of the present invention, in the evolution table, when the value-added tax data corresponding to any one first value-added tax invoice item is digital data, the access formula corresponding to the first value-added tax invoice item includes: formula (1) or formula (2);
TA＝IFERROR(VALUE(MID(α！Q，k1，FIND(″Pn″，α！Q，k2)-k3))，″″) (1)
wherein, T isArepresenting the value-added tax data imported on the A-th unit grid, wherein the A-th unit grid corresponds to a first value-added tax invoice item, the alpha represents the original table, the Q represents the unit grid corresponding to the first value-added tax invoice item in the original table, and the k represents the unit grid corresponding to the first value-added tax invoice item1Representing a first preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is2Representing a second preset value; k is3Representing a third preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "VALUE" characterizes a function of text strings converted to numbers; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function;
TB＝IFERROR(MID(α！W，FIND(″Pn：″，α！W，k4)+k5，k6)，″″) (2)
wherein, T isBrepresenting the value-added tax data imported on the B-th unit grid, wherein the B-th unit grid corresponds to a first value-added tax invoice item, the alpha represents the original table, the W represents the unit grid corresponding to the first value-added tax invoice item in the original table, and the k represents the unit grid corresponding to the first value-added tax invoice item4Representing a fourth preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is5Representing a fifth preset numerical value; k is6Representing a sixth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; the "MID" characterizes a function that intercepts a specified number of characters from a string.
In one embodiment of the invention, in the evolution table,
when the value-added tax data corresponding to any second value-added tax invoice item is the character data, the access formula corresponding to the second value-added tax invoice item comprises a formula (3);
TC＝IFERROR(VLOOKUP(Z，α！R，k7，k8)，) (3)
wherein, T isCcharacterizing the value added tax data imported on the C unit grid, wherein the C unit grid corresponds to the second value added tax issue item, the alpha characterizing the original table, the k characterizing the original table7Representing a seventh preset numerical value; k is8Representing an eighth preset numerical value; the R represents a cell range corresponding to the second value-added tax invoice item in the original table; the Z represents a cell in the evolution table related to the second value-added tax invoice item; "IFERROR" characterizes a function that checks whether there is an error parameter; "VLOOLUP" characterizes the vertical lookup function.
In one embodiment of the invention, in the evolution table,
when any third value-added tax invoice item corresponds to the value-added tax data representing unit time, the access formula corresponding to the third value-added tax invoice item comprises the following steps: formula (4);
TD＝
IFERROR(CONCATENATE(MID(α！E，FIND(Pm，α！E，k9)+k10，k11)，″F″)，″″) (4)
wherein, T isDcharacterizing value-added tax data imported on a Dth cell, wherein the Dth cell corresponds to a third value-added tax invoice item, the alpha represents the original table, the E represents a cell corresponding to the third value-added tax invoice item in the original table, the Pm represents a corresponding item name of the third value-added tax invoice item in the original table, and the k represents9Representing a ninth preset numerical value; k is10Representing a tenth preset value; k is11Representing an eleventh preset numerical value; the F represents a unit time corresponding to the Pm; "IFERROR" characterizes a function that checks whether there is an error parameter; "CONCATENATE" characterizes a function that performs an operation on one or more values and returns one or more values; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function.
In one embodiment of the invention, in the evolution table,
when the value-added tax data corresponding to any fourth value-added tax invoice item represents the date, the access formula corresponding to the fourth value-added tax invoice item includes: formula (5);
TE＝IFERROR(DATE(MID(α！G，FIND(Pk，α！G，k12)+k13，k14)，
MID(α！G，FIND(Pk，α！G，k12)+k15，k16)，
MID(α！G，FIND(″Pk″，α！G，k12)+k17，k18) (5)
wherein, T isEcharacterizing the value-added tax data imported on the E-th cell corresponding to the fourth value-added tax invoice item, said alpha characterizing the original table, said G characterizing the cell corresponding to the fourth value-added tax invoice item in the original table, said PkCharacterizing the corresponding item name of the fourth value-added tax invoice item in the original table; k is12Representing a twelfth preset numerical value; k is13Representing a thirteenth preset numerical value; k is14Representing a fourteenth preset numerical value; k is15Representing a fifteenth preset numerical value; k is16Representing a sixteenth preset numerical value; k is17Representing a seventeenth preset value; k is18Representing an eighteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "DATE" characterizes a function of the DATE of acquisition; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function.
In one embodiment of the invention, in the evolution table,
when the value-added tax data corresponding to any fifth value-added tax invoice item is data with a specified digit length, the access formula corresponding to the fifth value-added tax invoice item includes: formula (6);
TF＝IFERROR(ROUND(H/L，k19)，″″) (6)
wherein, T isFRepresenting value-added tax data imported on the F-th unit grid, wherein the F-th unit grid corresponds to a fifth value-added tax invoice item; the H represents a first cell related to the Fth cell in the evolution table; the L represents a second cell related to the Fth cell in the evolution table; k is19Representing a nineteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "ROUND" characterizes a function that ROUNDs a value by a specified number of digits.
In an embodiment of the present invention, the analysis table importing unit 405 is configured to perform, for each value-added tax analysis item included in the selected analysis table, determining whether value-added tax data corresponding to the current value-added tax analysis item exists in the evolution table, if yes, determining the existing value-added tax data as a data value corresponding to the current value-added tax analysis item, and extracting the data value corresponding to the current value-added tax analysis item from the evolution table; otherwise, determining a preset null value as a data value corresponding to the current value-added tax.
In an embodiment of the present invention, as shown in fig. 5, the apparatus for analyzing based on EXCEL value-added tax data may further include: a monitoring unit 501 and a supplementing unit 502;
the monitoring unit 501 is configured to monitor integrity of original value-added tax data in the evolution table, and when it is monitored that the original value-added tax data is incomplete, generate a monitoring report including incomplete value-added tax data;
the supplementing unit 502 is configured to receive externally input supplemental data for the monitoring report generated by the monitoring unit, and supplement the supplemental data into the evolution table.
Because the information interaction, execution process, and other contents between the units in the device are based on the same concept as the method embodiment of the present invention, specific contents may refer to the description in the method embodiment of the present invention, and are not described herein again.
In summary, the embodiments of the present invention can at least achieve the following beneficial effects:
1. in the embodiment of the invention, the original table, the evolution table and the analysis table are firstly created. And then, importing the corresponding original value-added tax data on each value-added tax invoice by using the original table. And extracting original value-added tax data from the original table by using each value-added tax invoice item and a corresponding access formula in the evolution table, and importing the extracted original value-added tax data into the evolution table. And then selecting an analysis table meeting the current service requirement from the created analysis tables, extracting corresponding data values from the evolution table aiming at each value-added tax analysis item included in the selected analysis table, and importing the extracted data values into the selected analysis table. And after the data value is imported, the EXCEL value-added tax data analysis is carried out by utilizing the analysis table. According to the process, the original value-added tax data on each value-added tax invoice are sorted and analyzed through the original table, the evolution table and the analysis table, and the original value-added tax data on the value-added tax invoice do not need to be sorted and analyzed manually. Therefore, the scheme provided by the embodiment of the invention can improve the efficiency of value-added tax data analysis.
2. In the embodiment of the present invention, the at least one value-added tax invoice item included in the evolution table may select at least one or more of an invoice number, a purchasing party tax number, a purchasing party name, a selling party tax number, a selling party name, a transaction amount, a tax rate, an authentication date, and an invoicing date according to a service requirement. Therefore, the service applicability of the evolution table is strong.
3. In the embodiment of the invention, the original value-added tax data corresponding to each value-added tax invoice item is extracted through the access formula corresponding to the value-added tax invoice item, so that the matching degree of the extracted original value-added tax data and the value-added tax invoice item is higher.
4. In the embodiment of the present invention, after the extracted original value-added tax data is imported into the evolution table, the integrity of the original value-added tax data in the evolution table needs to be monitored. When the original value-added tax data is incomplete, the incomplete data can be supplemented, so that the integrity of the original value-added tax data in the evolution table can be improved.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising a" does not exclude the presence of other similar elements in a process, method, article, or apparatus that comprises the element.
Those of ordinary skill in the art will understand that: all or part of the steps for realizing the method embodiments can be completed by hardware related to program instructions, the program can be stored in a computer readable storage medium, and the program executes the steps comprising the method embodiments when executed; and the aforementioned storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic or optical disks.
Finally, it is to be noted that: the above description is only a preferred embodiment of the present invention, and is only used to illustrate the technical solutions of the present invention, and not to limit the protection scope of the present invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention shall fall within the protection scope of the present invention.

Claims (10)

1. A method based on EXCEL value-added tax data analysis is characterized in that an original table, an evolution table and at least one analysis table are created; wherein,
the evolution table comprises at least one value-added tax invoice item and a data acquisition formula corresponding to each value-added tax invoice item;
the at least one analysis table comprises at least one value-added tax analysis item, and different analysis tables correspond to different value-added tax data analysis requirements;
further comprising:
importing corresponding original value-added tax data on at least one value-added tax invoice by using the original table;
extracting original value-added tax data from the original table by using the at least one value-added tax invoice item in the evolution table and a corresponding access formula thereof;
importing the extracted original value-added tax data into the evolution table;
selecting an analysis table;
extracting a corresponding data value from the evolution table aiming at each value-added tax analysis item included in the selected analysis table, and importing the data value into the analysis table;
and performing EXCEL value-added tax data analysis by using the analysis table.
2. The method of claim 1, wherein, in the evolutionary table,
when the value-added tax data corresponding to any one first value-added tax invoice item is digital data, the access formula corresponding to the first value-added tax invoice item includes: a first formula or a second formula;
the first formula includes:
TA＝IFERROR(VALUE(MID(α！Q，k1，FIND(″Pn″，α！Q，k2)-k3))，″″)
wherein, T isArepresenting the value-added tax data imported on the A-th unit grid, wherein the A-th unit grid corresponds to a first value-added tax invoice item, the alpha represents the original table, the Q represents the unit grid corresponding to the first value-added tax invoice item in the original table, and the k represents the unit grid corresponding to the first value-added tax invoice item1Representing a first preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is2Representing a second preset value; k is3Representing a third preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "VALUE" characterizes a function of text strings converted to numbers; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function;
the second formula includes:
TB＝IFERROR(MID(α！W，FIND(″Pn：″，α！W，k4)+k5，k6)，″″)
wherein, T isBrepresenting the value-added tax data imported on the B-th unit grid, wherein the B-th unit grid corresponds to a first value-added tax invoice item, the alpha represents the original table, the W represents the unit grid corresponding to the first value-added tax invoice item in the original table, and the k represents the unit grid corresponding to the first value-added tax invoice item4Representing a fourth preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is5Representing a fifth preset numerical value; k is6Representing a sixth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "MID" characterizes a function that intercepts a specified number of characters from a string;
and/or, in the evolutionary table,
when the value-added tax data corresponding to any one second value-added tax invoice item is character data, the access formula corresponding to the second value-added tax invoice item comprises a third formula;
the third formula includes:
TC＝IFERROR(VLOOKUP(Z，α！R，k7，k8)，)
wherein, T isCcharacterizing the value added tax data imported on the C unit grid, wherein the C unit grid corresponds to the second value added tax issue item, the alpha characterizing the original table, the k characterizing the original table7Representing a seventh preset numerical value; k is8Representing an eighth preset numerical value; the R represents a cell range corresponding to the second value-added tax invoice item in the original table; the Z represents a cell in the evolution table related to the second value-added tax invoice item; "IFERROR" characterizes a function that checks whether there is an error parameter; "VLOOLUP" characterizes the vertical lookup function.
3. The method of claim 1, wherein, in the evolutionary table,
when any third value-added tax invoice item corresponds to the value-added tax data representing unit time, the access formula corresponding to the third value-added tax invoice item comprises the following steps: a fourth formula;
the fourth formula includes:
TD＝IFERROR(CONCATENATE(MID(α！E，FIND(Pm，α！E，k9)+k10，k11)，″F″)，″″)
wherein, T isDcharacterizing value-added tax data imported on a Dth cell, wherein the Dth cell corresponds to a third value-added tax invoice item, the alpha represents the original table, the E represents a cell corresponding to the third value-added tax invoice item in the original table, the Pm represents a corresponding item name of the third value-added tax invoice item in the original table, and the k represents9Representing a ninth preset numerical value; k is10Representing a tenth preset value; k is11Representing an eleventh preset numerical value; the F represents a unit time corresponding to the Pm; "IFERROR" characterizes a function that checks whether there is an error parameter; "CONCATENATE" characterizes a function that performs an operation on one or more values and returns one or more values; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function;
and/or, in the evolutionary table,
when the value-added tax data corresponding to any fourth value-added tax invoice item represents the date, the access formula corresponding to the fourth value-added tax invoice item includes: a fifth formula;
the fifth formula includes:
TE＝IFERROR(DATE(MID(α！G，FIND(Pk，α！G，k12)+k13，k14)，
MID(α！G，FIND(Pk，α！G，k12)+k15，k16)，
MID(α！G，FIND(″Pk″，α！G，k12)+k17，k18)
wherein, T isECharacterization ofthe value-added tax data is imported into the E-th cell, wherein the E-th cell corresponds to a fourth value-added tax invoice item, the α represents the original table, the G represents the cell corresponding to the fourth value-added tax invoice item in the original table, and the P represents the price of the unit corresponding to the fourth value-added tax invoice itemkCharacterizing the corresponding item name of the fourth value-added tax invoice item in the original table; k is12Representing a twelfth preset numerical value; k is13Representing a thirteenth preset numerical value; k is14Representing a fourteenth preset numerical value; k is15Representing a fifteenth preset numerical value; k is16Representing a sixteenth preset numerical value; k is17Representing a seventeenth preset value; k is18Representing an eighteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "DATE" characterizes a function of the DATE of acquisition; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function;
and/or, in the evolutionary table,
when the value-added tax data corresponding to any fifth value-added tax invoice item is data with a specified digit length, the access formula corresponding to the fifth value-added tax invoice item includes: a sixth formula;
the sixth formula includes:
TF＝IFERROR(ROUND(H/L，k19)，″″)
wherein, T isFRepresenting value-added tax data imported on the F-th unit grid, wherein the F-th unit grid corresponds to a fifth value-added tax invoice item; the H represents a first cell related to the Fth cell in the evolution table; the L represents a second cell related to the Fth cell in the evolution table; k is19Representing a nineteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "ROUND" characterizes a function that ROUNDs a value by a specified number of digits.
4. The method of claim 1,
the extracting, for each value-added tax analysis item included in the selected analysis table, a corresponding data value in the evolution table includes:
executing each value-added tax analysis item in the selected analysis table, determining whether value-added tax data corresponding to the current value-added tax analysis item exists in the evolution table, if so, determining the existing value-added tax data as a data value corresponding to the current value-added tax analysis item, and extracting the data value corresponding to the current value-added tax analysis item from the evolution table; otherwise, determining a preset null value as a data value corresponding to the current value-added tax.
5. The method according to any one of claims 1 to 4,
the at least one value-added tax invoice item comprises: at least one or more of invoice number, purchaser tax number, purchaser name, seller tax number, seller name, transaction amount, tax rate, authentication date, and invoicing date;
and/or the presence of a gas in the gas,
after importing the extracted original value-added tax data into the evolution table, the method further includes:
monitoring the integrity of original value-added tax data in the evolution table, and generating a monitoring report comprising incomplete value-added tax data when the original value-added tax data is monitored to be incomplete;
receiving externally input supplementary data aiming at the monitoring report, and supplementing the supplementary data into the evolution table.
6. An apparatus based on EXCEL value-added tax data analysis, comprising:
the system comprises a creating unit, a calculating unit and a processing unit, wherein the creating unit is used for creating an original table, an evolution table and at least one analysis table; the evolution table comprises at least one value-added tax invoice item and a data acquisition formula corresponding to each value-added tax invoice item; the at least one analysis table comprises at least one value-added tax analysis item, and different analysis tables correspond to different value-added tax data analysis requirements;
the original table importing unit is used for importing corresponding original value-added tax data on at least one value-added tax invoice by using the original table created by the creating unit;
the extraction unit is used for extracting original value-added tax data from the original table by using the at least one value-added tax invoice item in the evolution table and the corresponding access formula;
an evolution table importing unit, which imports the original value-added tax data extracted by the extracting unit into the evolution table;
an analysis table importing unit for selecting an analysis table; extracting a corresponding data value from the evolution table aiming at each value-added tax analysis item included in the selected analysis table, and importing the data value into the analysis table;
and the analysis unit is used for carrying out EXCEL value-added tax data analysis by utilizing the analysis table.
7. The apparatus of claim 6, wherein, in the evolutionary table,
when the value-added tax data corresponding to any one first value-added tax invoice item is digital data, the access formula corresponding to the first value-added tax invoice item includes: a first formula or a second formula;
the first formula includes:
TA＝IFERROR(VALUE(MID(α！Q，k1，FIND(″Pn″，α！Q，k2)-k3))，″″)
wherein, T isArepresenting the value-added tax data imported on the A-th unit grid, wherein the A-th unit grid corresponds to a first value-added tax invoice item, the alpha represents the original table, the Q represents the unit grid corresponding to the first value-added tax invoice item in the original table, and the k represents the unit grid corresponding to the first value-added tax invoice item1Representing a first preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is2Representing a second preset value; k is3Representing a third preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "VALUE "represents a function for converting text strings into numbers; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function;
the second formula includes:
TB＝IFERROR(MID(α！W，FIND(″Pn：″，α！W，k4)+k5，k6)，″″)
wherein, T isBrepresenting the value-added tax data imported on the B-th unit grid, wherein the B-th unit grid corresponds to a first value-added tax invoice item, the alpha represents the original table, the W represents the unit grid corresponding to the first value-added tax invoice item in the original table, and the k represents the unit grid corresponding to the first value-added tax invoice item4Representing a fourth preset numerical value; the Pn represents a corresponding item name of the first value-added tax invoice item in the original table; k is5Representing a fifth preset numerical value; k is6Representing a sixth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "MID" characterizes a function that intercepts a specified number of characters from a string;
and/or, in the evolutionary table,
when the value-added tax data corresponding to any one second value-added tax invoice item is character data, the access formula corresponding to the second value-added tax invoice item comprises a third formula;
the third formula includes:
TC＝IFERROR(VLOOKUP(Z，α！R，k7，k8)，)
wherein, T isCcharacterizing the value added tax data imported on the C unit grid, wherein the C unit grid corresponds to the second value added tax issue item, the alpha characterizing the original table, the k characterizing the original table7Representing a seventh preset numerical value; k is8Representing an eighth preset numerical value; the R represents a cell range corresponding to the second value-added tax invoice item in the original table; the Z represents a cell in the evolution table related to the second value-added tax invoice item; "IFERROR" characterizes a function that checks whether there is an error parameter; "VLOOLUP" characterizes the vertical lookup function.
8. The apparatus of claim 6, wherein, in the evolutionary table,
when any third value-added tax invoice item corresponds to the value-added tax data representing unit time, the access formula corresponding to the third value-added tax invoice item comprises the following steps: a fourth formula;
the fourth formula includes:
TD＝IFERROR(CONCATENATE(MID(α！E，FIND(Pm，α！E，k9)+k10，k11)，″F″)，″″)
wherein, T isDcharacterizing value-added tax data imported on a Dth cell, wherein the Dth cell corresponds to a third value-added tax invoice item, the alpha represents the original table, the E represents a cell corresponding to the third value-added tax invoice item in the original table, the Pm represents a corresponding item name of the third value-added tax invoice item in the original table, and the k represents9Representing a ninth preset numerical value; k is10Representing a tenth preset value; k is11Representing an eleventh preset numerical value; the F represents a unit time corresponding to the Pm; "IFERROR" characterizes a function that checks whether there is an error parameter; "CONCATENATE" characterizes a function that performs an operation on one or more values and returns one or more values; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function;
and/or, in the evolutionary table,
when the value-added tax data corresponding to any fourth value-added tax invoice item represents the date, the access formula corresponding to the fourth value-added tax invoice item includes: a fifth formula;
the fifth formula includes:
TE＝IFERROR(DATE(MID(α！G，FIND(Pk，α！G，k12)+k13，k14)，
MID(α！G，FIND(Pk，α！G，k12)+k15，k16)，
MID(α！G，FIND(″Pk″，α！G，k12)+k17，k18)
wherein, T isEcharacterizing the value-added tax data imported on the E-th cell corresponding to the fourth value-added tax invoice item, said alpha characterizing the original table, said G characterizing the cell corresponding to the fourth value-added tax invoice item in the original table, said PkCharacterizing the corresponding item name of the fourth value-added tax invoice item in the original table; k is12Representing a twelfth preset numerical value; k is13Representing a thirteenth preset numerical value; k is14Representing a fourteenth preset numerical value; k is15Representing a fifteenth preset numerical value; k is16Representing a sixteenth preset numerical value; k is17Representing a seventeenth preset value; k is18Representing an eighteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "DATE" characterizes a function of the DATE of acquisition; "MID" characterizes a function that intercepts a specified number of characters from a string; "FIND" characterizes the localization function;
and/or, in the evolutionary table,
when the value-added tax data corresponding to any fifth value-added tax invoice item is data with a specified digit length, the access formula corresponding to the fifth value-added tax invoice item includes: a sixth formula;
the sixth formula includes:
TF＝IFERROR(ROUND(H/L，k19)，″″)
wherein, T isFRepresenting value-added tax data imported on the F-th unit grid, wherein the F-th unit grid corresponds to a fifth value-added tax invoice item; the H represents a first cell related to the Fth cell in the evolution table; the L represents a second cell related to the Fth cell in the evolution table; k is19Representing a nineteenth preset numerical value; "IFERROR" characterizes a function that checks whether there is an error parameter; "ROUND" characterizes a function that ROUNDs a value by a specified number of digits.
9. The apparatus of claim 6,
the analysis table importing unit is used for executing each value-added tax analysis item in the selected analysis table, determining whether value-added tax data corresponding to the current value-added tax analysis item exists in the evolution table, if so, determining the existing value-added tax data as a data value corresponding to the current value-added tax analysis item, and extracting the data value corresponding to the current value-added tax analysis item from the evolution table; otherwise, determining a preset null value as a data value corresponding to the current value-added tax.
10. The apparatus according to any one of claims 6 to 9,
further comprising: a monitoring unit and a supplementing unit;
the monitoring unit is used for monitoring the integrity of the original value-added tax data in the evolution table, and when the original value-added tax data is monitored to be incomplete, a monitoring report comprising the incomplete value-added tax data is generated;
the supplementary unit is used for receiving supplementary data which are input from the outside and are aimed at the monitoring report generated by the monitoring unit, and supplementing the supplementary data into the evolution table.
CN201710832624.3A 2017-09-15 2017-09-15 A kind of method and device based on EXCEL value-added tax data analyses Pending CN107609968A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710832624.3A CN107609968A (en) 2017-09-15 2017-09-15 A kind of method and device based on EXCEL value-added tax data analyses

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710832624.3A CN107609968A (en) 2017-09-15 2017-09-15 A kind of method and device based on EXCEL value-added tax data analyses

Publications (1)

Publication Number Publication Date
CN107609968A true CN107609968A (en) 2018-01-19

Family

ID=61060117

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710832624.3A Pending CN107609968A (en) 2017-09-15 2017-09-15 A kind of method and device based on EXCEL value-added tax data analyses

Country Status (1)

Country Link
CN (1) CN107609968A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108335087A (en) * 2018-03-09 2018-07-27 吴祥荣 Value-added tax invoice for sales data statistical approach based on EXCEL and device

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120065914A1 (en) * 2010-09-13 2012-03-15 Seiko Epson Corporation Optical detection system, electronic device and program
CN103034652A (en) * 2011-09-28 2013-04-10 海洋王照明科技股份有限公司 Method and system for analyzing and processing data
CN106709675A (en) * 2015-11-13 2017-05-24 航天信息股份有限公司 Method and system for tracking article circulation
CN107122961A (en) * 2017-05-16 2017-09-01 上海斐晟企业管理有限公司 Excel nested report data processing methods based on SAP system

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120065914A1 (en) * 2010-09-13 2012-03-15 Seiko Epson Corporation Optical detection system, electronic device and program
CN103034652A (en) * 2011-09-28 2013-04-10 海洋王照明科技股份有限公司 Method and system for analyzing and processing data
CN106709675A (en) * 2015-11-13 2017-05-24 航天信息股份有限公司 Method and system for tracking article circulation
CN107122961A (en) * 2017-05-16 2017-09-01 上海斐晟企业管理有限公司 Excel nested report data processing methods based on SAP system

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108335087A (en) * 2018-03-09 2018-07-27 吴祥荣 Value-added tax invoice for sales data statistical approach based on EXCEL and device

Similar Documents

Publication Publication Date Title
US11797503B2 (en) Systems and methods for enhanced mapping and classification of data
WO2008045738A2 (en) Fraud detection, risk analysis and compliance assessment
CN108595621A (en) A kind of early warning analysis method and system write false value added tax invoice
US20180260910A1 (en) Systems and methods for extracting information from a transaction description
CN111695979A (en) Method, device and equipment for analyzing relation between raw material and finished product
US10282353B2 (en) Proactive duplicate identification
CN111562965A (en) Page data verification method and device based on decision tree
CN106296385A (en) A kind of book keeping operation section purpose arranges and recommends method
CN110633331A (en) Method, system and related equipment for extracting data in relational database
CN106056418A (en) Invoice submission method, device and system
CN113159118A (en) Logistics data index processing method, device, equipment and storage medium
US11182436B2 (en) Predicting locations based on transaction records
CN108335087A (en) Value-added tax invoice for sales data statistical approach based on EXCEL and device
CN110363457A (en) Method and system based on express delivery odd numbers matching express company's title
CN106294834B (en) Connected transaction based on taxpayer's interests related network is evaded the tax Activity recognition method
CN105138656A (en) Method and device for processing data
US20120078610A1 (en) Determining offer terms from text
CN110276609B (en) Business data processing method and device, electronic equipment and computer readable medium
TWI517072B (en) System and method for comparing account receivables data or other transaction data among sellers and buyers
CN107609968A (en) A kind of method and device based on EXCEL value-added tax data analyses
CN111401959B (en) Risk group prediction method, apparatus, computer device and storage medium
CN116757790A (en) Cross-border E-commerce logistics management system based on user portrait
CN107203506A (en) A kind of report form generation method and device
CN113344674A (en) Product recommendation method, device, equipment and storage medium based on user purchasing power
CN109584029B (en) Method, device, medium and electronic equipment for auditing electronic invoices

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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20180119