This article is suitable for enterprises that need to be checked for 4S store industry, VAT invoice details, and mainly use vlookup, data comparison, homemade software, etc.
In our company's finance, after receiving the VAT invoice, we need to go to the National VAT invoice inspection platform of the State Administration of Taxation to check the detailed list of VAT invoices, and then use the list to check with the data exported in the after-sales system to check which invoices are issued and which have not been issued yet. Generally, there are thousands of data in the details of an invoice. In the past, they were manually checked through paper documents. It took two days to check, and it was easy to make mistakes. Now we check through several information-based methods, which are fast and efficient. The software verification can be done in less than three minutes and get off work early.
Excel table checking method
Checking through Excel is the most commonly used method, you can follow the following steps.
1. Query the sales details of electronic invoice on the VAT verification platform. Because the website certificate needs to be installed before the verification code can be released, many friends are stuck in this place. In fact, using the automatic installation tool according to the website introduction is the easiest method. The URL of the verification platform is: https://inv-veri.chinatax.gov.cn/index.html
2. After all input is completed, you can check the authenticity of the invoice, and you can view the sales details of the invoice, but its details are not provided for download. It is a pop-up window. We need to get the content down. There are two methods.
1. Save the sales details into html file , and then you can save them locally.
2. Copy the sales details into the excel table and pay attention to the format.
3. Save this sales details to Excel, first select Excel to set the format as text, and then copy these thousands of records to the table to paste it, which can avoid the occurrence of scientific counting methods for specifications and models.
4. Remove unnecessary data and only keep the name, specifications, models, and amount. These three items need to be checked later. Different specifications and models represent different accessories, so they will not be repeated. This is what is going on after finishing it.
5
5. Because it needs to match the specification model and amount in another table, it is considered an invoice issued. So combine the specification model and amount and amount to become a column. You can use the splitter to connect in the middle. First use the Text function to convert it before connecting.
6. Next is the familiar vlookup function . Use the data table exported by the system to match this invoice sales list, and you can distinguish which accessories have been invoiced at once.
WPS check method
If you use WPS check, you do not need to use the vlookup function, but use its unique function "data comparison". The steps are as follows
1. The previous steps are the same as the method of processing data in Excel. Just sort the data to the fourth step. There is no need to merge columns, just keep the name, specifications, models, and amount.
2. Just organize the data tables exported in the system and keep the three columns of name, specifications, model, and amount.
3. Use the function of extracting unique values in the two regions under the data comparison function.
can choose which area to extract the unique value according to your needs. After simple operations, which goods are quickly compared without invoices.
software verification method
For the frequent verification situation in the company, we have made special verification software.
Step 1: Save the sales goods details web page on the verification platform to the local software directory. Some invoices have multiple details, so just download multiple web pages, and the software will process them into a table together.
Step 2: The software will automatically read all html web pages in this directory, extract the table data in the web page into excel and save it, which is called invoice analysis.
Step 3: Load the parsed sales details table and the data table exported in the system, which is called data loading.
Step 4: Compare the two tables, use each row of the sales list to export each row of the system. If the comparison is successful, add the flag and skip the comparison when the comparison reaches this next time. It is called automatic check.
Step 5: Save the comparison results. Financial personnel can clearly see what has not been checked after opening the table. The data that has not been checked has no color, and the background of the checked data is marked green.
