Invoice CA - Document Skill

Extract data from Canadian invoices — vendor, customer, GST/HST/PST, line items, and totals in English and French — for Canadian AP automation.

The Invoice CA skill extracts data from Canadian invoices — vendor, customer, GST/HST/PST details, line items, and totals in English and French — for AP automation across Canada.

The Invoice CA 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.

Countries and Languages

Countries	Languages
Canada	English
	French

Extracted Fields

Asterisk (*) indicates a required field or field group. Values cannot be empty.

Basic Information

Field	Description
Invoice Number	The number of the invoice.
Invoice Date*	The date when the invoice was issued.
Total*	The total cost of goods or services.
Currency	The currency of the invoice.

Business Unit (BU)

Field	Description
Name	The name of the business unit (invoice recipient).
Address	The address of the business unit (invoice recipient). The address will be extracted into this field, if no BusinessUnits data catalog is used or if the business unit has not been found in a data catalog.
Country	The country of the business unit (invoice recipient).
State or Province	The address of the business unit (invoice recipient). This address format will be used if the BusinessUnits data catalog is used and the business unit has been found in the data catalog.
City	The address of the business unit (invoice recipient). This address format will be used if the BusinessUnits data catalog is used and the business unit has been found in the data catalog.
Street	The address of the business unit (invoice recipient). This address format will be used if the BusinessUnits data catalog is used and the business unit has been found in the data catalog.
Postal Code	The address of the business unit (invoice recipient). This address format will be used if the BusinessUnits data catalog is used and the business unit has been found in the data catalog.
ID	The unique identifier of the business unit in an external system. Note: This field can only be obtained from the BusinessUnits data catalog.

Vendor

Field	Description
Name	The vendor’s name.
Address	The vendor’s address. The address will be extracted into this field, if no Vendors data catalog is used or if the vendor has not been found in a data catalog.
Country	The vendor’s country.
State or Province	The vendor’s address. This address format will be used if the Vendors data catalog is used and if the vendor has been found in the data catalog.
City	The vendor’s address. This address format will be used if the Vendors data catalog is used and if the vendor has been found in the data catalog.
Street	The vendor’s address. This address format will be used if the Vendors data catalog is used and if the vendor has been found in the data catalog.
Postal Code	The vendor’s address. This address format will be used if the Vendors data catalog is used and if the vendor has been found in the data catalog.
Bank Account	The vendor’s bank account.
Bank Code	The vendor’s bank code.
ID	The vendor’s unique identifier in an external system. Note: This field can only be obtained from the Vendors data catalog.

Invoice Details

Field	Description
Delivery Date	The date the goods were delivered or services performed.
Due Date	The date by which the invoice should be paid.

Taxes

Field	Description
Total Net Amount	The total cost of goods and services without tax.
Total Taxes	The total tax amount.
Tax Rates (repeating group)	For each tax group: Net Amount. Cost of goods or services without tax. Tax Amount. Tax charged. Tax Rate. Tax rate.
Non Taxable Amount	The amount on which no tax is payable.

Invoice Type

Field	Description
Invoice	Specifies the Invoice type of the invoice.
Credit Note	Specifies the Credit Note type of the invoice.

Purchase Order

Field	Description
Order Number	The number of the purchase order.
Total	The cost of the goods or services listed in the purchase order. Note: This field can only be obtained from the PurchaseOrders data catalog.
Order Checked	Indicates whether the order number is verified. The value of the field can be True or False.

Line Items (repeating group)

Field	Description
Order Number	The number of the purchase order.
Order Date	The date when the purchase order was created.
Position	The number of the line item in the list.
Article Number Vendor	The article number or code in the vendors’s database.
Article Number BU	The article number or code in the business unit’s database.
Description	A description of the line item.
Quantity	The number of units purchased.
Unit of Measurement	The unit of measurement used for the goods.
Unit Price	The price of one item of goods.
Discount Percentage	The discount percentage on the initial line item price.
Discount	Discount applicable to the line item.
Net Price	The price of the line item without tax.
Tax Rate	The tax rate for the line item.
Tax Amount	The amount of tax payable on the line item.
Tax Code	The code of the tax.
Total Price	The price of the line item including tax.
Currency	The currency of the line item.
Is Valid	Indicates whether the order number in the Line Item group matches any checked order number in the Purchase Order group. The value of the field can be True or False.
Order Item ID	The unique line item identifier. Note: This field can only be obtained from the PurchaseOrderItems data catalog.

Ship To

Field	Description
Name	The name of the recipient receiving the goods.
Address	The address of the recipient receiving the goods.

Older versions of this skill extracted the tax information into fields named Tax Rate X, Tax Amount X, and Net Amount X. In Vantage 2.4 and later, these fields are grouped into a repeating group called Tax Rates. If you are updating a copy of a built-in skill, check that the new Tax Rates group works for you. If you are satisfied with the results, remove the individual fields used in the older version. If not, create new fields to suit your processing scenario.

Key Fields

• Vendor/Name
• Invoice Date
• Invoice Number
• Total
• Currency

Validation Rules

Rule	Description
Total is required field	Checks whether the Total field is filled in. If it is not, displays a message saying that it is a required field.
Separate currency from amount in money fields	Splits the amount and the currency in fields containing currency amounts and copies the currency into the Currency field if it is empty.
Invoice date is required	Checks whether the Invoice Date field is filled in. If it is not, displays a message saying that it is a required field.
Currency is required	Checks whether the Currency field has been detected on the document. If not, displays a message saying that it is a required field.
Vendor Tax ID is required	Checks whether the vendor Tax ID field is filled in. If it is not, displays a message saying that it is a required field.
Check item amount	Checks that: 1. The number of units of each type (Quantity) multiplied by the unit price (Unit Price) is equal to the total amount charged before tax (Net Price) minus the applicable discount (Discount). 2. The total amount charged before tax (Net Price) multiplied by the tax rate (Tax Rate) is equal to the value of the Tax Amount field. 3. The sum of the values of the Net Price and Tax Amount fields is equal to the value of the Total Price field. 4. For each invoice line item, suggests values for the following fields (wherever calculating them is possible): Quantity, Unit Price, Discount, Net Price, Tax Rate, Tax Amount, and Total Price.
Separate currency from amount in LI money fields	Splits the amount and the currency in the corresponding field and copies the currency into the Line Items/Currency field if it is not filled in. 1. Line Items/Unit Price 2. Line Items/Net Price 3. Line Items/Total Price
Check invoice and line items currency	Checks that the value of the Currency and Line Items/Currency fields is a supported currency. If the currency is not supported or has not been extracted, suggests currency values from the appropriate invoice region. Currency descriptions are replaced with ISO codes.
Check LI Total Prices against Total Amount	Checks the value of the Total Amount field. If it is not equal to the sum of the Line Items/Total Price fields, suggests filling in the fields with their calculated values.
Check LI Net Prices against Total Net Amount	Checks the value of the Total Net Amount field. If it is not equal to the sum of the Line Items/Net Price fields, suggests filling in the fields with their calculated values.
Check Total Tax	Checks that the sum of the Tax Amount fields across the Tax Rates repeating group is equal to the value of the Total Taxes field. If the values are not equal, suggests filling in the fields with the calculated values. If the Total Taxes field is not filled in, fills it in with its calculated value. For each instance of the Tax Rates group: Checks that (Tax Rate / 100 ) * Net Amount is equal to Tax Amount. If Tax Rate, Net Amount, or Tax Amount is not filled in, suggests filling in these fields with their calculated values. Removes the percent sign (%) from the value in the Tax Rate field.
Check Total field	Checks that the sum of the Total Net Amount and Tax Amount fields is equal to the total invoiced amount (Total). If the values are not equal or if the Total field is not filled in, suggests filling in the fields with their calculated values.
Check Net Total	Checks that the sum of the Net Amount fields across the Tax Rates repeating group is equal to the total amount charged for the goods or services before tax (Total Net Amount). If the values are not equal, suggests filling in the fields with their calculated values. If the Total Net Amount is not filled in, fills it in with its calculated value.
Set default country	If a country has not been detected on the image, specifies the default country for the invoice based on the supported country for the skill. For example, Invoice CA = CA; Invoice = Default Country Not Set )
Check vendor details against database	Checks whether the appropriate entry in the Vendors data catalog has been found for the vendor bank details detected on the image. If the values in the data catalog are different, replaces the field values with entries from the data catalog. If the vendor was not detected correctly, the operator may select a different vendor from the data catalog manually during manual review. The Vendor Id, Name, Street, Country, and Business Unit ID fields must be filled in the Vendors data catalog.
Business unit must be found in database	Checks that the business unit details detected on the document image are the same as those in the BusinessUnits data catalog. If some entries are different, replaces the field values with values from the data catalog. If the business unit was not detected correctly, the operator may select a different business unit from the data catalog manually during manual review. The Business Unit Id, Name, Street, and Country fields should be filled in the BusinessUnits data catalog.
Check purchase order number and amount	Checks that the order number and amount detected on the document image are the same as those in the PurchaseOrders data catalog. If several order numbers are detected, checks all of them and their amounts against the values in the data catalog. The Order Number field should be filled in the PurchaseOrders data catalog.
Match invoice line item with order item	Checks invoice line item information against records in the PurchaseOrderItems data catalog. If the catalog contains an entry for a particular line item, fills in the corresponding Order Item ID field using the value from the data catalog. The Order Item ID and Order Number fields should be filled in the PurchaseOrderItems data catalog.
Check purchase order total amount	Checks if the value in the Total field equals the value of the Total field in the Purchase Order group when one purchase order is found. Checks if the value in the Total field equals the sum of values in Total fields in the Purchase Order group when several purchase orders are found.
Check matching of line items to unique order items	For all line items whose purchase order number is equal to the one extracted in the Purchase Order group, checks that the value in the Order item ID field in the Line Items group is unique for every purchase order number if the value of the Order Checked field is True.
If order is checked make line items valid	For each item in Purchase Order group that has the Order Checked field set to True, compares the order number to the order number in all line items of the Line Items group. If they match in the Line Items group row, the value of the Is Valid field in the Line Items group value in that row is set to True.
Copy order number	If there is only one value in the Order Number field in the Purchase Order group and the values in the Order Number field in the Line Items group are empty, copies the value of the Order Number field in the Purchase Order group to the values of the Order Number field in the Line Items group.
Detect invoice type	Sets the type in the Invoice Type checkmark group. If the document is marked as credit note or if the value of the Total field is negative, sets the type to Credit Note. Otherwise, sets the type to Invoice.
Reversed Charge field is empty or completed	If the document contains references to reversed charges, checks the values of the taxes fields. If they are empty, marks the Reversed Charge checkmark. Note: Does not apply to AU-NZ, CA, US, and JP regions.

To fill in a field with its calculated value, click the suggested value button in the value region of the field and select one of the suggestions from the drop-down list.

When you update a copy of this skill to a derived skill, the rules will also be updated:

• Some of the rules will get new versions. The outdated versions will receive numbered postfixes (for example, Check item amount 1). Review these rules and remove any unnecessary versions from the derived skill.
• If you remove outdated Tax Rate X, Tax Amount X, and Net Amount X fields, the rules that checked them will become unnecessary. Remove those rules from the derived skill.

Parameters

The Invoice skills have default skill parameters that refer to data catalogs used for Vendor, Business Unit, and Purchase Order lookup. You can change the values of these parameters in Vantage or Advanced Designer to modify the field extraction process.

Parameter	Description
Vendors	The predefined data catalog used for Vendor lookup. The default value of this parameter is Vendors. You can change this value by choosing another available data catalog of the same type (Document Issuer Companies).
BusinessUnits	The predefined data catalog used for Business Unit lookup. The default value of the parameter is BusinessUnits. You can change this value by choosing another available data catalog of the same type (Document Receiver Companies). Note: This parameter is not available for the Invoice JP skill.
PurchaseOrders	The predefined data catalog used for Purchase Order lookup. The default value of this parameter is PurchaseOrders. You can change this value by choosing another available data catalog having the same structure.
PurchaseOrderItems	The predefined data catalog used to check if the Purchase Order details match. The default value of this parameter is PurchaseOrderItems. You can change this value by choosing another available data catalog having the same structure.