Tax control Invoicing Software Invoice Import Tool

0. Title

A gadget was created to import the product sales list from Excel into the invoicing software for everyone to use.

Demo Video: Video will show how to download and use tools

Bilibili video link:http://www.bilibili.com/video/av6201085/

Baidu Cloud Video link:https://pan.baidu.com/s/1hrF4S8c

1. Holistic approach

The manual import function of the tax-controlled invoicing software requires an XML file, and the XML file should contain the invoice information, so all we need to do is make an XML file that contains the invoice information.

My approach is to associate a well-known format XML file with an Excel document, where the user simply enters the invoice information in Excel and then exports an XML file.

2. Frequently Asked Questions

if the drawer after the import of information is missing, it is the invoicing software itself, please download the latest version of the invoicing software, for example, gold tax disk, please log into the Space gold Tax Download Center download .

:http://www.ejinsui.com.cn/download.php?id=1570  

3. How to Operate

A. Open tools, paste the invoice information into the corresponding column, and enter other necessary information

B. Export the XML file, save it where you can find it, and modify the XML file

C. Enter the invoice to fill out the interface, click on manual Import, and select the XML file to

4. Operation DetailsA.

The product code is a 19-digit combined code, which can be queried in the tax classification code in the invoicing software.

Optional: Enterprise product Code, deduction, preferential policy statement, can be used in English single quotation marks "Do not fill"

Suggested buyer information is empty, import and then select the buyer information in the invoicing software

In Excel, single quotation marks mean "empty", that is, no data, but not really empty

Zero tax mark (null: Non-zero tax rate 0: Export Tax Rebate 1: Duty Free 2: No 3: normal zero tax rate)

Preferential Policy logo (0: Not used 1: use)

tax-included flag (0: tax-free taxrate 1: tax-Included rate 2: Difference tax)

B.

EXCEL2007: Development Tools-xml-Export

EXCEL2003: Data-xml-Export

Copy the following two lines to replace the first two lines of the XML file

<?xml version= "1.0" encoding= "GBK"?>

<Kp>

Click "Save As", file name +. XML, save type: All files, code: ANSI

Tax control Invoicing Software Invoice Import Tool