The Invoice CN skill extracts data from VAT invoices posted by manufacturers from China. A VAT invoice is a document issued by a seller to a buyer that lists the goods or services supplied. A VAT invoice typically contains the following information:
- The list of goods or services supplied and their quantity and price
- The total amount payable for the goods or services
- The currency to be used for payment
- A description of the goods or services
- Details about the seller and the buyer
- The number and date of the invoice
- Applicable taxes
The Invoice CN skill is a production skill. It has been fully trained on a large document set and provides high accuracy of data identification and extraction. The skill is ready to be used in production and does not require further training on your specific documents. Accuracy and straight-through processing (STP) rates can be further optimized in production through continuous learning from human-in-the-loop feedback.
This skill is designed for processing VAT invoices from China, which have a specific structure that does not change from document to document. Other types of invoices from China may not be processed correctly using this skill.
The Invoice CN skill does not use the Vendors, BusinessUnits, PurchaseOrders and PurchaseOrderItems data catalogs.
Countries and Languages
| Countries | Languages |
|---|
| China | Chinese (Simplified) |
| English |
Asterisk (*) indicates a required field or field group. Values cannot be empty.
Business Unit (BU)
| Field | Description |
|---|
| Name | The invoice recipient’s name. |
| Tax ID | The invoice recipient’s taxpayer identifier. |
| Address | The address of the invoice recipient. |
| Country | The address of the invoice recipient. |
| Phone | The invoice recipient’s phone number. |
| Bank Name | The invoice recipient’s bank name and branch (if specified). |
| Bank Account | The invoice recipient’s bank account number. |
Vendor
| Field | Description |
|---|
| Name | The vendor’s name. |
| Tax ID | The vendor’s taxpayer identifier. |
| Address | The vendor’s address. |
| Country | The vendor’s address. |
| Phone | The vendor’s phone number. |
| Bank Name | The vendor’s bank name. |
| Bank Account | The vendor’s bank account number. |
| Field | Description |
|---|
| Invoice Number | The number of the invoice. |
| Invoice Date* | The date when the invoice was issued. |
| Invoice ID | The invoice identifier. |
| Total* | The total cost of goods or services. |
| Currency | The currency of the invoice. |
Purchase Order
| Field | Description |
|---|
| Order Number | The purchase order number. |
Line Items (repeating group)
| Field | Description |
|---|
| Description | A description of the line item. |
| Article | The article number or code of the line item. |
| UoM | The unit of measurement used for the goods. |
| Quantity | The number of line item units purchased. |
| Unit Price | The price of one unit of the line item goods. |
| Net Price | The price of the line item before tax. |
| Tax Rate | The tax rate applicable to the line item. |
| Tax Amount | The amount of tax payable on the line item. |
Taxes
| Field | Description |
|---|
| Total Net Amount | The total cost of goods and services without tax. |
| Total Taxes | The total amount of tax charged. |
| Tax Rate | The tax rate. |
Key Fields
- Vendor/Name
- Invoice Date
- Invoice Number
- Total
- Currency
Validation Rules
| Rule | Description |
|---|
| Invoice Date is required | Checks that the Invoice Date field is filled in. If the field is empty, displays a message that it is a required field. |
| Total is required | Checks that the Total field is filled in. If the field is empty, displays a message that it is a required field. |
| Set Default Country | If the values for the Business Unit (BU)/Country and Vendor/Country fields are either missing from the document or have not been extracted, fills them in using the following value: “中国”. |
| Process money fields and currency | Checks that the value Currency field is a supported currency. If not, sets the value to “CNY”. Currency descriptions are replaced with ISO codes. |
| Check Total Net Amount | Checks if the value of the Total Net Amount field equals the sum of the Line Items/Net Price fields. If not, displays a warning message and suggests filling in the fields with their calculated values. |
| Check Total Taxes | Checks if the value of the Total Taxes field equals the sum of the Line Items/Tax Amount fields. If not, displays an appropriate message and suggests filling in the fields with their calculated values. |
| Check Sum | Checks if the value of the Total field equals the sum of all line items (Total Net Amount) after taxes (Total Taxes). If not, displays an appropriate message and suggests filling in the fields with their calculated values. |
| Check item amount | Checks the following:
1. That the number of units for each line item (Quantity) multiplied by the price of a unit (Unit Price) equals the price of the goods or service before taxes (Net Price).
2. That the price of the goods or service before taxes (Net Price) multiplied by the tax rate (Tax Rate) equals the value in the Tax Amount field.
Removes the percent sign (%) from the value in the Tax Rate field.
For each invoice line item, suggests values for the following fields (wherever calculating them is possible): Quantity, Unit Price, Net Price, Tax Rate, and Tax Amount. |
| Complete Tax Rate | Checks that the value of the Tax Rate field equals the following: Total Taxes*100/Total Net. If the values are different or Tax Rate is empty, suggests filling it with its calculated value. |
