> For the complete documentation index, see [llms.txt](https://help.supplyd.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.supplyd.co/supplyd-erp/expenses/understanding-supplier-invoices-for-expense-reconciliation.md).

# Understanding Supplier Invoices for Expense Reconciliation

Understanding how to read supplier invoices helps ensure Expense Reconciliation is accurate by allowing you to correctly identify pricing, quantities, taxes, discounts, and purchasing units.

Understanding how a supplier invoice is structured is important when completing **Expense Reconciliation** in Supply’d. Supplier invoices can present quantities, unit prices, line amounts, discounts, taxes such as GST, and purchasing units in different ways. Knowing how these values relate to each other helps you select the correct reconciliation settings and ensures Supply’d Intelligence interprets the invoice accurately.

This document provides examples of common invoice formats and explains how to identify the relevant values, choose the appropriate **Price Calculation Method**, account for taxes and discounts, and confirm that units and cartons match how products have been invoiced.

* [#how-supplyd-intelligence-reads-an-invoice](#how-supplyd-intelligence-reads-an-invoice "mention")
* [#choosing-your-invoice-settings](#choosing-your-invoice-settings "mention")
* [#when-units-or-cartons-do-not-match](#when-units-or-cartons-do-not-match "mention")
* [#final-check](#final-check "mention")
* [#if-supplyd-intelligence-reads-the-wrong-value](#if-supplyd-intelligence-reads-the-wrong-value "mention")
* [#invoice-examples](#invoice-examples "mention")

***

### How Supply’d Intelligence Reads an Invoice

**Supply’d Intelligence** scans the invoice and identifies key values, including:

* **Quantity**
* **Unit Price**
* **Line Amount**

On a simple invoice:

&#x20;       **Quantity × Unit Price = Line Amount**

However, supplier invoices can use different layouts and calculation methods. More complex invoices may include multiple quantity or price columns, carton and unit quantities, discounts, rebates, taxes or other charges. In these cases, review the values identified by Supply’d Intelligence and choose the **Price Calculation Method** that best matches how the supplier has calculated the final amount charged.

***

### Choosing Your Invoice Settings

Review how the supplier displays its prices and determine which values represent the amount charged.

{% hint style="warning" %}
**Important:** **Edit Invoice** settings do not change which information Supply’d Intelligence scans. They tell Supply’d how to **use the scanned values** when calculating the price.
{% endhint %}

{% stepper %}
{% step %}

#### Select the Invoice

1. Select **Expenses** from the main menu.
2. Select the invoice you are reconciling.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FEABSroqtdjaxfIWsCWfp%2FExpenses%20-%20Reconcile%20Page.png?alt=media&amp;token=8199c1f6-da70-43ff-a9fa-cd034d3bc551" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

***

{% endstep %}

{% step %}

#### Select Edit Invoice

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FO58PW7kCF1tYQYcBbQFU%2FReconcile%20-%203%20Dots%20Edit%20Invoice.png?alt=media&amp;token=79426545-9dda-4f39-911b-a33dc54ec8fe" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

With the invoice open, select the 3 dots in the top-right corner, then select **Edit Invoice**.

The **Edit Invoice** form will open, allowing you to choose how line items are sorted and how prices are calculated during reconciliation.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

***

{% endstep %}

{% step %}

#### Complete the Form

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FOGt0Ejd0qRoHxfTm0smQ%2FEdit%20Invoice%20Form.png?alt=media&amp;token=7fa947c6-e1bd-4d2b-8eb8-6c04893153da" alt="" width="563"><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Sort Line Items By**

Choose how the invoice line items are arranged during reconciliation.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FGoocAVuyQqXqDw4NdjuR%2FSort%20Line%20Items%20By.png?alt=media&amp;token=a1580378-3981-4ada-9c69-341b5a19e2a3" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

* **Purchase Order** – Sorts items according to their associated purchase order.
* **SKU** – Sorts items by SKU.
* **Brand Name** – Sorts items alphabetically by brand name.
* **Unmatched, Discrepancy** – Displays unmatched items and items with discrepancies at the top, while matched items appear below for easier reconciliation.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

***

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Update Data By**

Choose whether product buy prices and batch **Cost of Goods Sold (CoGS)** are updated for the entire order or controlled individually for each line item.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FUrUHuO4rzfp53Z9qZ73T%2FUpdate%20Data%20By%20Drop%20Down.png?alt=media&amp;token=8a64f384-406c-4a59-ba81-6b3c2f31e489" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

***

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Price Calculation Method**

Choose how Supply’d calculates prices when reconciling the invoice.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FMInIPXNyMQ8gKugdKf0A%2FPrice%20Calculation%20Method%20Drop%20Down.png?alt=media&amp;token=9d8d5efc-3c1a-497d-80d2-cdd25d86e653" alt="" width="375"><figcaption></figcaption></figure>

* **Unit Price** – Select when the invoice provides a clear final unit price. Supply’d uses the entered unit price and quantity to calculate the line total.
* **Line Amount & Quantity** – Select when the final line amount best represents the amount charged. Supply’d divides the entered line amount by the quantity to calculate the unit price.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

{% hint style="success" %}
Supply’d calculates:\ <br>

&#x20;       **Line Amount ÷ Quantity = Unit Price**\ <br>

For example: **$30 ÷ 3 = $10 per unit**<br>
{% endhint %}

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

***

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Prices Are Tax-Inclusive?**

Check whether the price being used includes taxes such as GST:

* **Yes** - Tax is included in the price.
* **No** - Tax is added separately.

Look for headings such as **incl. GST**, **excl. GST**, **GST**, **Tax**, or the applicable tax name used in your country.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

***

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Discount**

Enter any discount applied to the invoice. Supply’d distributes the discount evenly across all line items to calculate the final amounts accurately.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FDSdVy0QAxrlw4GFtH1ol%2FDiscount%20Drop%20Down.png?alt=media&amp;token=4ba07925-d28b-42ee-be5b-bd5054e39b09" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

Choose from **No Discount**, **Fixed Amount**, or **Percentage**, depending on how the invoice handles the discount.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Discount Amount ($)**

When **Fixed Amount** is selected in the **Discount** field, a **Discount Amount** **($)** field appears for you to enter the dollar amount of the discount.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FtBw9sDLJDsjoe1mq7UZb%2FDiscount%20Amount%20(%24).png?alt=media&amp;token=c37b0b95-ccc3-41aa-bc41-082c9f7df8f6" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Discount Percentage (%)**

When **Percentage** is selected in the **Discount** field, a **Discount Percentage (%)** field appears for you to enter the discount percentage.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FrQCMcSxw7S9lI1vb9VQW%2FDiscount%20Percentage%20(%25).png?alt=media&amp;token=1cf4dfd7-6911-4636-83e1-325b83561f99" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
**Important:** If the discount is already included in the **Unit Price** or **Line Amount**, select **No Discount**. Otherwise, the discount will be applied twice.
{% endhint %}

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

***

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Save Settings To Supplier**

If the supplier consistently uses the same invoice format, select **Save Settings to Supplier** once you have confirmed the settings are correct. Supply’d will use the same settings for future invoices from that supplier.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

***

{% endstep %}

{% step %}

#### Click Save

Click <img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2Fw7vNdWre4ViL4czC3qLv%2FSAVE.png?alt=media&amp;token=96a25e18-5d77-4c97-82c6-d9d9d6362740" alt="" data-size="line"> to apply your settings.

{% endstep %}
{% endstepper %}

***

#### Quick Guide

| What you see                                 | Setting                            |
| -------------------------------------------- | ---------------------------------- |
| Clear final unit price                       | **Unit Price**                     |
| Final line amount best represents the charge | **Line Amount & Quantity**         |
| Price includes taxes                         | **Tax-Inclusive: Yes**             |
| Tax is added separately                      | **Tax-Inclusive: No**              |
| Discount already included                    | **No Discount**                    |
| Discount still needs to be applied           | **Fixed Amount** or **Percentage** |

***

### When Units or Cartons Do Not Match

Once the invoice settings are correct, check that the invoice quantity uses the same purchasing unit configured in Supply’d.

For example, Supply’d may have a product configured as **individual units**, while the supplier invoices it by **carton**, with **10 units per carton**.

If they do not match:

{% stepper %}
{% step %}

#### Select Change Units/Cartons

Select the **3 dots** beside the product, then **Change Units/Cartons**.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2Fz0J61PvTubXS4KK8NLa6%2FChange%20Units%3ACartons.png?alt=media&amp;token=22fe74ba-5a31-4fa4-a54a-e42340bd652e" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

The **Change Units/Cartons** form will open, allowing you to update the purchasing unit.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

***

{% endstep %}

{% step %}

#### Complete the Form

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FtxTqtgMvU0EwAQ61R5jm%2FChange%20Units%3ACartons%20Form.png?alt=media&amp;token=31c9355d-165a-4a51-a32c-7178f3a5969c" alt="" width="563"><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Ordered By**

Select whether the product is ordered by **Unit** or **Carton**.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FapcMDRsJLSLSZJwmlsUE%2FOrdered%20By%20Drop%20Down.png?alt=media&amp;token=e75dc667-4943-4fcf-b774-4a6d77a5ff7c" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Carton Qty**

Enter the number of individual units in each carton. This field only appears when **Carton** is selected in the **Ordered By** field.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Recalculate The Price**

Choose whether to recalculate the price for this line item.

* **Yes** – Recalculates the price when changing from Units to Cartons to reflect the updated quantity.
* **No** – Keeps the existing price unchanged when only updating the carton size.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Update Product**

Choose whether to save the unit or carton changes to the product’s purchasing setup:

* **Yes** – Permanently updates the product for this supplier and applies the new setup to future orders and invoices.
* **No** – Applies the change to the current reconciliation only. The product’s purchasing setup remains unchanged. You may need to repeat the adjustment on future invoices.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

{% endstep %}

{% step %}

#### Click Save

Click <img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2Fw7vNdWre4ViL4czC3qLv%2FSAVE.png?alt=media&amp;token=96a25e18-5d77-4c97-82c6-d9d9d6362740" alt="" data-size="line"> to apply the change.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

{% endstep %}
{% endstepper %}

***

### Final Check

Before completing reconciliation, confirm the **quantity and purchasing unit**, **unit price**, **tax**, **discounts**, **line amounts**, and **invoice total** are correct.

If Supply’d shows a difference, first check the **Edit Invoice** settings and **Units/Cartons** to determine whether it is a genuine price difference or a configuration issue.

***

### If Supply’d Intelligence Reads the Wrong Value

If Supply’d Intelligence reads an incorrect value on an individual invoice, correct the scanned value before completing reconciliation.

If invoices from the same supplier **consistently** identify the wrong quantity, unit price, or line amount, contact Supply’d so the invoice format can be reviewed for possible additional AI training.

{% hint style="warning" icon="bookmark" %}
**Remember:** **Edit Invoice** controls how Supply’d uses the scanned values. It does not change which invoice columns Supply’d Intelligence identifies.
{% endhint %}

***

## Invoice Examples

The following examples show common supplier invoice formats and the appropriate Supply’d settings.

For each invoice, check:

1. Which quantity represents what was **supplied**?
2. Which price or line amount represents what was **charged**?
3. Does the price **include or exclude taxes**?
4. Is any **discount or rebate already included**?
5. Do the invoice **units match the purchasing setup** in Supply’d?

These answers will help you choose the correct **Edit Invoice** settings and verify the result.

{% hint style="warning" %}
The examples in this document use **Goods and Services Tax (GST)**, as shown on Australian supplier invoices. If you operate in another country, apply the same guidance using the relevant tax type and rate for your location.
{% endhint %}

* [#example-1-simple-unit-price-quantity-invoice](#example-1-simple-unit-price-quantity-invoice "mention")
* [#example-2-separate-discount-at-the-bottom-of-the-invoice](#example-2-separate-discount-at-the-bottom-of-the-invoice "mention")
* [#example-3-discount-deducted-from-the-line-amount](#example-3-discount-deducted-from-the-line-amount "mention")
* [#example-4-discount-already-included-in-the-unit-price](#example-4-discount-already-included-in-the-unit-price "mention")
* [#example-5-different-line-discounts-with-tax-included-in-the-final-total](#example-5-different-line-discounts-with-tax-included-in-the-final-total "mention")
* [#example-6-quantities-and-prices-shown-by-both-carton-and-unit](#example-6-quantities-and-prices-shown-by-both-carton-and-unit "mention")
* [#invoice-example-7-case-pricing-with-discounts-and-wet](#invoice-example-7-case-pricing-with-discounts-and-wet "mention")

***

### Example 1 - Simple Unit Price × Quantity Invoice

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FKvTXs5EZk2djZs0858kk%2F1%20-%20Invoice%20Example%201.png?alt=media&amp;token=478cb388-b9f9-4ad1-842c-bb54ecfc81a3" alt="" width="563"><figcaption></figcaption></figure>

This invoice is a straightforward example where the three key values are clearly shown:

* **Quantity**
* **Unit Price**
* **Amount** - The total charged for each line.

Each product follows:

&#x20;      **Quantity × Unit Price = Amount**

For example:

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2Fsw1mAotiHcghvJfQ9e0a%2F2%20-%20Example%201%20-%20Example.png?alt=media&amp;token=cd82da90-2f29-418c-961f-ffb21ec48194" alt=""><figcaption></figcaption></figure>

&#x20;      &#x20;

&#x20;       **3 × $4.36 = $13.08**

Because there are no additional pricing columns or line discounts, the values needed for reconciliation are easy to identify.

#### 1. Choose the Quantity and Price

In this example, Supply’d Intelligence is trained to identify **Quantity** as the quantity supplied and **Unit Price** as the price. The **Amount** may also be used because it is calculated directly from these two values.

Select **Unit Price** as the **Price Calculation Method**. Alternatively, you can select **Line Amount & Quantity** if Supply’d Intelligence identifies the **Amount** more reliably. Both methods produce the same result for this invoice.

#### 2. Check Tax and Discounts

Select **No** for **Prices Are Tax-Inclusive?** because GST is added separately.

The **Amount** column totals $128.31, with $1.50 GST added to produce the final invoice total:

&#x20;       **$128.31 + $1.50 GST = $129.81**

Most products are GST-free, while the **Delivery** line includes 10% GST. This confirms that the displayed prices exclude GST.

As there are no line discounts, select **No Discount**.

Once you have confirmed that the settings and calculated prices are correct, select **Save Settings to Supplier** if the supplier generally uses the same invoice format.

**Recommended Settings**

| Setting                       | Selection       |
| ----------------------------- | --------------- |
| **Price Calculation Method**  | **Unit Price**  |
| **Prices Are Tax-Inclusive?** | **No**          |
| **Discount**                  | **No Discount** |

#### 3. Check Units and Cartons

Confirm that the invoice **Quantity** represents the same purchasing unit configured for the product in Supply’d.

For example, a description such as **6 pack** or **4 pack** does not necessarily mean the product is purchased by carton. Check whether the invoiced quantity represents an individual unit, pack or carton.

If the invoice and Supply’d use different purchasing units, select **Change Units/Cartons**. You can either update the supplier product for future purchases or apply the change to the current reconciliation only.

***

### Example 2 - Separate Discount at the Bottom of the Invoice

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FRO4c1DbkjzvnGw85EMuV%2FExample%202%20-%20%20A%20separate%20discount%20at%20the%20bottom%20of%20the%20invoice.png?alt=media&amp;token=befee378-08f9-4401-994a-b9de37006522" alt="" width="563"><figcaption></figcaption></figure>

This invoice is another simple example, but it also shows where a supplier may apply a **separate discount to the overall invoice**.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FCXZmZFY55U04IOz4YJrf%2FExample%202%20-%20Example.png?alt=media&amp;token=f61bc094-fb2f-4ece-95f4-65ed84e9e2d5" alt=""><figcaption></figcaption></figure>

Each product follows:

&#x20;      **Price × Qty Del = Total**

The three product lines total:

&#x20;      **$250 + $180 + $42 = $472**

This matches the **Grand Total** of **$472**. The invoice also shows **GST Tax** and **Discount** as **$0.00**, so neither affects the amount charged.

#### 1. Choose the Quantity and Price

In this example, Supply’d Intelligence is trained to identify:

* **Qty Del** as the quantity supplied.
* **Price** as the unit price.
* **Total** as the line amount.

Either **Price Calculation Method** can be used:

* **Unit Price** – Uses the displayed **Price** and **Qty Del**.
* **Line Amount & Quantity** – Uses the **Total** and **Qty Del** to calculate the unit price.

Both methods produce the same result for this invoice.

#### 2. Check Tax and Discount

For this invoice, select:

* **Prices Are Tax-Inclusive?** – **No**
* **Discount** – **No Discount**

**GST Tax** is $0.00, so this invoice does not demonstrate how the supplier handles GST on taxable products.

Once you have confirmed that the settings and calculated prices are correct, select **Save Settings to Supplier** if the supplier generally uses the same invoice format.

**Recommended Settings**

| Setting                       | Selection                                    |
| ----------------------------- | -------------------------------------------- |
| **Price Calculation Method**  | **Unit Price** or **Line Amount & Quantity** |
| **Prices Are Tax-Inclusive?** | **No**                                       |
| **Discount**                  | **No Discount**                              |

#### What If a Separate Discount Was Applied?

The **Discount** field at the bottom of the invoice is important because an invoice-level discount may need to be applied separately during reconciliation.

For example, **if the supplier had applied a $20 discount** to the $472 total:

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FtEjEKAHp7sg2FEvFRvGb%2FScreenshot%202026-09-30%20at%2011.01.14%E2%80%AFam.png?alt=media&amp;token=5a5d3f55-cb41-4cc8-a655-a304411b97c1" alt=""><figcaption></figcaption></figure>

| Step                              | Calculation                         | Result                |
| --------------------------------- | ----------------------------------- | --------------------- |
| Deduct the invoice-level discount | **Invoice Total − Discount Amount** | **$472 − $20 = $452** |

Select:

* **Discount** – **Fixed Amount**
* **Discount Amount ($)** – **20.00**

This discount must be applied whether you use **Unit Price** or **Line Amount & Quantity**, as the separate $20 discount is not included in the individual product prices or line totals.

{% hint style="warning" %}
**Important:** A discount shown separately below the product lines may still need to be applied when using **Line Amount & Quantity**. Always check whether the line amounts already include the discount before selecting the **Discount** setting.
{% endhint %}

***

### Example 3 - Discount Deducted from the Line Amount

This invoice shows a discount that is not included in the **Unit Price** but has already been deducted from the final line amount.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FHopwm4YtBUnoTNBoFw9q%2FExample%203%20-%20Discount%20Deducted%20from%20the%20Line%20Amount.png?alt=media&amp;token=2e15d673-ea77-4e3d-a352-2accbbc19ea0" alt=""><figcaption></figcaption></figure>

The invoice shows:

* **Quantity:** 4 cases
* **Unit Price:** $605.43
* **Discount Amount:** $484.34
* **Amount Excl. GST:** $1,937.38

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FGRToKTdbbdA9Njwd8Zyz%2FExample%203%20-%20Example.png?alt=media&amp;token=1ced9f91-1b0b-42d1-ab65-7bf5b295fe4b" alt=""><figcaption></figcaption></figure>

The calculation is:

| Step                                 | Calculation                                  | Result                                        |
| ------------------------------------ | -------------------------------------------- | --------------------------------------------- |
| Calculate the amount before discount | **Quantity × Unit Price**                    | **4 × $605.43 = $2,421.72**                   |
| Deduct the discount                  | **Amount Before Discount − Discount Amount** | **$2,421.72 − $484.34 = $1,937.38 excl. GST** |

#### 1. Use the Final Line Amount

For this invoice, use **Line Amount & Quantity** because **Amount Excl. GST** already includes the discount.

Supply’d calculates:

&#x20;      **$1,937.38 ÷ 4 = $484.345 per case**

Because the discount has already been deducted from the line amount, select **No Discount**. Applying another discount would discount the product twice.

**Recommended Settings**

| Setting                       | Selection                  |
| ----------------------------- | -------------------------- |
| **Price Calculation Method**  | **Line Amount & Quantity** |
| **Prices Are Tax-Inclusive?** | **No**                     |
| **Discount**                  | **No Discount**            |

Supply’d Intelligence should use **Quantity** for the quantity and **Amount Excl. GST** for the line amount.

#### 2. What If You Use Unit Price?

If you use **Unit Price** instead, the **$605.43** price is before the discount. This means the discount still needs to be applied.

For this invoice, either of these produces the final amount:&#x20;

| Discount Setting |       Value |
| ---------------- | ----------: |
| **Fixed Amount** | **$484.34** |
| **Percentage**   |     **20%** |

The **$484.34** discount is 20% of the original **$2,421.72**, rounded to cents. However, the invoice does not state that the discount is 20% or confirm that the same discount applies to future invoices.

These options work because this invoice contains only one product line. Do not assume an invoice-level discount will work for invoices containing multiple products with different line discounts.

Only save a discount as a supplier default once you have confirmed that the supplier consistently applies it in the same way.

{% hint style="warning" %}
**Important:** Whether you need to apply a discount depends on the **Price Calculation Method**. With **Unit Price**, the discount still needs to be deducted. With **Line Amount & Quantity**, it is already included in the line amount
{% endhint %}

***

### Example 4 - Discount Already Included in the Unit Price

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FUQMY2Fb3BSNJe9gYHgRJ%2FExample%204%20-%20Discount%20already%20included%20in%20the%20unit%20price.png?alt=media&amp;token=0d1595b2-dd80-4051-95d0-30e17891d3e6" alt=""><figcaption></figcaption></figure>

This invoice contains several quantity and pricing columns:

* **Quantity Supplied**
* **Quantity (B)order/(C)ancel**
* **Unit Price excl. GST**
* **Extended Reb. $**
* **Disc %**
* **Extended excl. GST**
* **GST**
* **TOTAL**

The key is to identify the **quantity supplied** and the **final price charged**.

#### 1. Choose the Supplied Quantity

In this example, Supply’d Intelligence is trained to identify **Quantity Supplied** as the invoiced quantity.

The **Quantity (B)order/(C)ancel** column should not be used because it records products that were backordered or cancelled. For example, a cancelled product may display a quantity and **C**, but no price or total.

#### 2. Check How the Discount Is Applied

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FwC3nTQyvHEOdTi7eIF0c%2FExample%204%20-%20Example.jpg?alt=media&amp;token=e4c4f916-a8f1-494a-89be-db1f3debb764" alt=""><figcaption></figcaption></figure>

For **NUTRA ORG PROTEIN WATER BERRY BLISS 450G**, the invoice shows:

* **Normal Wholesale Price:** $36.33
* **Discount:** 10%
* **Unit Price excl. GST:** $32.697
* **Quantity Supplied:** 1
* **Extended excl. GST:** $32.70
* **GST:** $3.27
* **TOTAL:** $35.97

The calculation is:

| Step                                | Calculation                  | Result                      |
| ----------------------------------- | ---------------------------- | --------------------------- |
| Calculate the discounted unit price | **Wholesale Price − 10%**    | **$36.33 − 10% = $32.697**  |
| Add GST                             | **Extended excl. GST + GST** | **$32.70 + $3.27 = $35.97** |

This confirms that **Unit Price excl. GST** already includes the 10% discount. Select **No Discount** in Supply’d, as applying another discount would discount the product twice.

#### 3. Choose the Price

Supply’d Intelligence is trained to identify **Unit Price excl. GST** as the price for this invoice. This price already includes the discount but excludes GST, so no further discount needs to be applied.

**Recommended Settings**

| Setting                       | Selection       |
| ----------------------------- | --------------- |
| **Price Calculation Method**  | **Unit Price**  |
| **Prices Are Tax-Inclusive?** | **No**          |
| **Discount**                  | **No Discount** |

**What If You Use a Different Price?**

If Supply’d Intelligence identifies a different price field, you can still reconcile the invoice correctly by adjusting the settings.

* **Extended excl. GST**

This is the line amount after the discount but before GST. Use the following settings:

| Setting                       | Selection                  |
| ----------------------------- | -------------------------- |
| **Price Calculation Method**  | **Line Amount & Quantity** |
| **Prices Are Tax-Inclusive?** | **No**                     |
| **Discount**                  | **No Discount**            |

* **TOTAL**

This is the final line amount including GST. Use the following settings:

| Setting                       | Selection                  |
| ----------------------------- | -------------------------- |
| **Price Calculation Method**  | **Line Amount & Quantity** |
| **Prices Are Tax-Inclusive?** | **Yes**                    |
| **Discount**                  | **No Discount**            |

All three options can produce the correct result, provided the **Price Calculation Method** and **Tax** settings match the price being used.

{% hint style="warning" %}
**Important:** Do not apply an additional discount when using a price that already includes the discount, as this would reduce the calculated price twice.
{% endhint %}

#### 4. Check for Rebates

The **Extended Reb. $** value is $0.00 in this example, so it does not affect the calculation.

If a rebate appears on another invoice, check where it has been applied:

* If it is included in the unit price, use **Unit Price**.
* If it is only included in the final line amount, use **Line Amount & Quantity**.

Once you have confirmed that Supply’d Intelligence consistently identifies the correct values and the calculated prices are accurate, select **Save Settings to Supplier**.

{% hint style="warning" %}
**Important:** Do not apply a discount or rebate again if it is already included in the price being used for reconciliation. The value used by Supply’d should represent the final amount charged after any applicable line-level discounts or rebates.
{% endhint %}

***

### Example 5 - Different Line Discounts with Tax Included in the Final Total

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2Ff7S6rBB4KfJx9t8DhiGM%2FExample%205%20-%20.png?alt=media&amp;token=b8747998-72e4-4ade-91b1-84a6e3c69dd7" alt="" width="563"><figcaption></figcaption></figure>

This invoice contains several quantity and pricing columns:

* **Order**
* **Ship**
* **RRP**
* **W/Sale**
* **Gross**
* **Disc %**
* **GST**
* **Total**

The key is to identify **what was actually supplied** and the **final amount charged**.

#### 1. Choose the Supplied Quantity

The invoice shows two quantities:

* **Order** - The quantity originally ordered.
* **Ship** - The quantity actually supplied and invoiced.

Supply’d Intelligence is trained to identify **Ship** as the supplied quantity. Some products may have an **Order** quantity but a **Ship** quantity of zero. These lines also show a **Gross** and **Total** of $0.00, confirming that the products were not supplied or charged.

#### 2. Choose the Final Amount Charged

The invoice displays several price values:

* **RRP** – The recommended retail price.
* **W/Sale** – The wholesale unit price before discount.
* **Gross** – The wholesale price multiplied by the quantity shipped, before discount and GST.
* **Total** – The final line amount after the discount and GST.

The invoice calculates each line as follows:

| Step                       | Calculation                        |
| -------------------------- | ---------------------------------- |
| Calculate the gross amount | **W/Sale × Ship = Gross**          |
| Calculate the final amount | **Gross − Discount + GST = Total** |

**Example**

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FUQIfCmLfVrRWWbKE7Q7C%2FExample%205%20-%20Example.jpg?alt=media&amp;token=069c5fd8-c33a-43b5-a8c6-47013a96d53b" alt=""><figcaption></figcaption></figure>

For **Complete Health Products Vitamin C Powder 200g**:

* **Ship:** 2
* **W/Sale:** $16.00
* **Gross:** $32.00
* **Discount:** 70%
* **GST:** $0.96
* **Total:** $10.56

The calculation is:

| Step                       | Calculation       | Result     |
| -------------------------- | ----------------- | ---------- |
| Calculate the gross amount | **$16.00 × 2**    | **$32.00** |
| Apply the 70% discount     | **$32.00 − 70%**  | **$9.60**  |
| Add GST                    | **$9.60 + $0.96** | **$10.56** |

Supply’d Intelligence is trained to identify **Total** as the line amount because it represents the final amount charged after the discount and taxes such as GST.

#### 3. Configure the Invoice Settings

Select:

* **Price Calculation Method** – **Line Amount & Quantity**
* **Prices Are Tax-Inclusive?** – **Yes**
* **Discount** – **No Discount**

Select **No Discount** because each line’s discount is already included in its **Total**. Applying another discount would discount the products twice.

This is particularly important because the invoice contains different discounts for individual products, such as 8%, 10%, 15% and 70%. The invoice-level **Discount** setting applies the same discount across all line items and cannot represent different line discounts.

**Recommended Settings**

| Setting                       | Selection                  |
| ----------------------------- | -------------------------- |
| **Price Calculation Method**  | **Line Amount & Quantity** |
| **Line Amount**               | **Total**                  |
| **Prices Are Tax-Inclusive?** | **Yes**                    |
| **Discount**                  | **No Discount**            |

For this invoice, Supply’d Intelligence is trained to identify:

* **Quantity** – **Ship**
* **Line Amount** – **Total**

The **Order**, **RRP**, **W/Sale** and **Gross** columns do not represent both the quantity supplied and the final amount charged.

Once you have confirmed that the identified values and calculated prices are correct, select **Save Settings to Supplier**.

#### If the Wrong Amount Is Identified

If Supply’d Intelligence identifies **Gross** instead of **Total** on an individual invoice, manually correct the scanned value before completing reconciliation.

{% hint style="warning" %}
If this happens consistently on invoices from the same supplier, contact Supply’d so the invoice format can be reviewed for possible additional AI training. Do not use an invoice-level discount to correct the difference, as the discount varies between individual product lines.
{% endhint %}

***

### Example 6 - Quantities & Prices Shown by Both Carton & Unit

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FFbkGzJPi22YrgJ4ViKgB%2FExample%206%20-%20Quantities%20and%20prices%20shown%20by%20both%20carton%20and%20unit.png?alt=media&amp;token=ba8d5c46-8c93-484b-a1ee-b445b659d315" alt="" width="563"><figcaption></figcaption></figure>

This invoice shows supplied quantities and prices in two ways:

* **Supplied Qty Case(s)** and **Supplied Qty Each(s)**
* **Price Excl Gst** and **Unit Price Ex Gst**

The important thing is to make sure the **quantity and price use the same purchasing unit**.

#### 1. Check the Purchasing Unit

Review the **Unit of Measure** to determine whether each product is purchased by **Case** or **Each**.

For this invoice, Supply’d Intelligence is trained to identify **Supplied Qty Case(s)** as the supplied quantity. Despite the column name, it displays the correct quantity based on each product’s purchasing unit.

For example:

* **Orecchiette** - 1 case containing 12 units
* **Noosa Basics deodorant** - 2 individual units

{% hint style="warning" %}
The **Qty Ordered** and **Not Supplied QTY** columns do not represent the quantity actually supplied and invoiced.
{% endhint %}

#### 2. Use the Final Line Amount

Select **Line Amount & Quantity** as the **Price Calculation Method**.

Supply’d Intelligence is trained to identify **Ext Price Excl GST** as the line amount. This provides the most accurate price and avoids differences caused by rounded individual-unit prices.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FF4LoZE0RHOu48X84l6G9%2FExample%206%20-%20Example.png?alt=media&amp;token=a10d5c82-fc5f-4b6e-8cb5-d91222eea968" alt=""><figcaption></figcaption></figure>

For example, **Orecchiette** shows:

* **Case quantity:** 1
* **Individual quantity:** 12
* **Individual price:** $4.16
* **Final line amount:** $49.86

| Method                | Calculation         | Result              |
| --------------------- | ------------------- | ------------------- |
| Individual unit price | **12 × $4.16**      | **$49.92**          |
| Final case amount     | **$49.86 ÷ 1 case** | **$49.86 per case** |

The individual unit calculation differs slightly from the amount actually charged, so the final line amount should be used.

{% hint style="info" %}
Small differences between the displayed prices may occur due to rounding.
{% endhint %}

#### 3. Check Taxes and Discounts

Select **No** for **Prices Are Tax-Inclusive?** because **Ext Price Excl GST** excludes GST.

Select **No Discount** because any line discount is already included in the final pricing. Always check how the values are calculated rather than relying on the position of the discount column.

**Recommended Settings**

| Setting                       | Selection                  |
| ----------------------------- | -------------------------- |
| **Price Calculation Method**  | **Line Amount & Quantity** |
| **Prices Are Tax-Inclusive?** | **No**                     |
| **Discount**                  | **No Discount**            |

For this invoice, Supply’d Intelligence is trained to identify:

* **Quantity** – **Supplied Qty Case(s)**
* **Line Amount** – **Ext Price Excl GST**

#### 4. Check the Product Setup and Scanned Values

If the purchasing setup in Supply’d does not match the supplier’s **Case/Each** setup, select **Change Units/Cartons**. You can update the supplier product for future purchases or apply the change to the current reconciliation only.

Confirm that the identified quantity and line amount use the same purchasing-unit basis. If Supply’d Intelligence identifies **Supplied Qty Each(s)** instead of **Supplied Qty Case(s)**, the calculated price will be based on individual units.

Once you have confirmed that the settings and calculated prices are correct, select **Save Settings to Supplier**.

***

### Invoice Example 7 - Case Pricing with Discounts and WET

This invoice includes several prices, discounts, and **WET (Wine Equalisation Tax)**. The key is to use the final cost per case that already includes WET.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbwojqOeM0CHuwtdOhgR2%2FExample%207%20-%20Case%20Pricing%20with%20Discounts%20and%20WET.png?alt=media&amp;token=f60ba2aa-6cb9-4b4d-879b-0df7ef2097ee" alt=""><figcaption></figcaption></figure>

#### 1. Understand the Pricing

The relevant columns are:

* **W/Sale/Case** - Price per case before discount.
* **Discount/Case** - Discount applied to each case.
* **Nett/Case** - Case price after discount.
* **Total Value** - Line amount after discount, before WET and GST.
* **Invoice Value** - Final line amount including WET but excluding GST.
* **L.U.C. Ex. GST** - Individual bottle cost including WET but excluding GST.

For **Tormaresca Chardonnay**, the invoice calculates the line as follows:

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2Fr5ZIvOJrQwOksUYb3i4j%2FExample%207%20-%20Example.jpg?alt=media&amp;token=13b5065f-c0fa-43b0-9639-d701f33743d1" alt=""><figcaption></figcaption></figure>

| Step                           | Calculation                     | Result                                       |
| ------------------------------ | ------------------------------- | -------------------------------------------- |
| Apply the case discount        | **W/Sale/Case − Discount/Case** | **$85.00 − $8.50 = $76.50 per case**         |
| Calculate the total before WET | **Nett/Case × Cases**           | **$76.50 × 2 = $153.00**                     |
| Add WET                        | **Total Value + WET**           | **$153.00 + $44.37 = $197.37 Invoice Value** |

{% hint style="info" %}
The **Container Deposit** is zero for this example, so it does not affect the calculation.
{% endhint %}

#### 2. Use the Final Invoice Value

Select **Line Amount & Quantity**, using **Invoice Value** as the line amount and **Supply Qty** as the quantity.

| Calculation                    | Result                                   |
| ------------------------------ | ---------------------------------------- |
| **Invoice Value ÷ Supply Qty** | **$197.37 ÷ 2 cases = $98.685 per case** |

This gives the case price **including WET and excluding GST**.

Do not base the reconciliation on **W/Sale/Case** or **Nett/Case**, as neither includes WET. **L.U.C. Ex. GST** includes WET but represents a rounded bottle price, so it should not be used with a case quantity.

The **Supply Qty** values are displayed in a cases/loose-units format, such as **1/0** or **2/0**. In this example, the invoice confirms a total of 6 cases and 0 loose units.

#### 3. Check GST and Discounts

Select **No** for **Prices Are Tax-Inclusive?** because **Invoice Value** excludes GST. GST is added separately in the invoice summary. Ensure the product’s tax setup in Supply’d is also correct.

Select **No Discount** because each product’s discount is already included in **Invoice Value**. Applying another discount would deduct it twice. The discounts also vary between products, so a single invoice-level discount would not represent them accurately.

**Recommended Settings**

| Setting                       | Selection                  |
| ----------------------------- | -------------------------- |
| **Price Calculation Method**  | **Line Amount & Quantity** |
| **Prices Are Tax-Inclusive?** | **No**                     |
| **Discount**                  | **No Discount**            |

Supply’d Intelligence should identify **Supply Qty** as the quantity and **Invoice Value** as the line amount.

**4. Check the Purchasing Unit and Scanned Values**

These products are invoiced by case. If they are configured in Supply’d as individual bottles, select **Change Units/Cartons** to align the purchasing units. You can update the supplier product for future purchases or apply the adjustment to the current reconciliation only.

Confirm that the identified values are based on the case quantity and **Invoice Value**, rather than **Total Value** or a bottle-level price.

Once you have confirmed that the settings and calculated prices are correct, select **Save Settings to Supplier**.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://help.supplyd.co/supplyd-erp/expenses/understanding-supplier-invoices-for-expense-reconciliation.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
