# Receiving and Balancing Connect Logistics Invoices

**RECEIVING AND BALANCING CONNECT LOGISTICS INVOICES**

To accurately receive and reconcile Connect Logistics invoices in Barnet, follow these steps. The required file format for import is **Traditional Format with GST (.ord file)**. Since the .ord file is not human-readable, you’ll also need the **PDF version** of the invoice to confirm totals, including GST and deposits.

**Step 1: Retrieve the Invoice from LiquorConnect**

1. Log in to [liquorconnect.com](https://www.liquorconnect.com/).
2. Navigate to **Ordering>Closed/Final Closed**.
3. Click the **Web ID#** of the invoice you wish to import.
4. Sort by **Status** to check for any yellow-highlighted products (indicating substitute CSPC numbers).
5. If substitutes are listed, add the new CSPC# to the **Alt Barcode/SKU** table in \<Product Maintenance> before importing.

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2Fr1hKf2XTDfOrzIefV0iE%2F0.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FtU4W3eoyIzbvbzF4cGnM%2F1.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FaP5lahnbpcDTKvPiY9ac%2F2.png?alt=media)

**Step 2: Export the Invoice**

1. Click “Export”.

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FAx9VdRUj3QMo6HuAQUrR%2F3.png?alt=media)

2. Select **Traditional Export with GST**.

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2Fd0bAPXeTRCTK3nBnzYcL%2F4.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FPZBqpW7dZpdvlgzhGxKj%2F5.png?alt=media)

3. The .ord file will save to your Downloads folder. (Optional: move to a dedicated folder for organization.)

The file looks like this when you open it in Notepad:

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2F5dAqkyFmOMTf9IE2YwLn%2F6.png?alt=media)

To verify the totals:

* Go to **Downloads>Invoices**.
* Click the invoice to view the **PDF** version.
* Save or reference the PDF to compare totals—Invoice number is in the top right, total details in the bottom right.

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2Fmr8B6daitJVrWU9WpJaH%2F7.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FRJY5ikaVUs95DduMLRiQ%2F8.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2Fs91qVLdRD57rI1XFJyKm%2F9.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2Fu37qdQozG5A0heolYn2d%2F10.png?alt=media)

**Step 3: Import into Barnet**

1. Go to **Inventory>Receiving Invoices**.
2. Click the green **+ New** button and select **Receiving Invoice**.
3. Search and select the appropriate **vendor**.
4. Click the green **Import** button, then **Import Invoice**.
5. Use **Choose File** to upload the .ord file.
6. Wait for processing, then click “Continue” and “Import” once the file is ready.

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FVDc1MBubHQw8n6PR86Jo%2F11.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2F0b2vt4wPUWNNIjRFMOyb%2F12.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FEd3F4z87G77A9TRCnOUD%2F13.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FzbDkz66TvOU3j1adipZb%2F14.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FkSyQj58iftJWjKWlgmop%2F15.png?alt=media)

**Step 4: Product Setup (If Required)**

If the invoice contains new SKUs:

* A setup window will open automatically.
* Details such as CSPC, barcode, name, Units/Case, Units/Pack, and Deposit will auto-fill.
* **You must assign a Category and Unit of Measure (Size)**.
* Hover over product names to see full descriptions.
* Adjust product names and pricing as needed for clarity or shelf label formatting.
* Use the **Deposit amount** as a clue for product sizing, if uncertain.

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FCMfNS1yx24cX3u1xnWVI%2F16.png?alt=media)

**Step 5: Review and Finalize the Invoice**

1. Once all products are set up, the invoice will load in full.
2. Verify the **Order Total** and **Deposit Total** match the PDF.
   * Small GST rounding differences are common.
   * Deposit total should match exactly.
3. If totals are correct, click the blue **Save Invoice** button. *\*If totals do not match, reference the troubleshooting section at the end of this document*

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2Fc2nrs16XmyrxoC2p21r7%2F17.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FQmOeVIhaMkrFavYbHqGk%2F18.png?alt=media)

**Cost and Pricing Adjustments**

* If SKU costs have changed, a prompt will ask if you wish to update the Product Table.
  * Click “Apply” to update all.
  * Or uncheck specific SKUs to selectively apply changes.
* You’ll also be prompted to activate new selling prices.
  * Choose “Yes” to review suggestions now, or “No” to activate them later via **Products>New Prices Activation**.

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FtkqY2kzndHdZo8inHlRz%2F19.png?alt=media)

![](https://1547179311-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgxlSIIMuIqFC3w3MtCp7%2Fuploads%2FbbMfaj80LBwwIE82sUe2%2F20.png?alt=media)

**Troubleshooting**

**Deposit Doesn’t Match?**

This usually indicates:

* Incorrect or missing deposit values.
* Incorrect Units/Case or Units/Pack configuration.

**Solution:**

* Review products within the Receiving screen.
* Compare with the CSV export of the Connect invoice.
* Export Barnet Receiving to Excel for side-by-side comparison using formulas if needed.

**GST Discrepancies?**

If GST is significantly off:

* Verify product **Category settings**, as these control GST.
* Common causes include:
  * Misclassified non-alcoholic SKUs.
  * Incorrect setup of the Liquor Connect Order Charge SKU.

**Correction Workflow:**

1. Fix product details in \<Product Maintenance>.
2. Delete the Receiving entry.
3. Re-import the invoice after all corrections are made to ensure accurate future imports.

If you encounter balancing issues caused by incorrect SKU setup, refer to the knowledge base document **"Setup for Receiving AB Invoices"**. Using the **.csv file with GST** option may help resolve these discrepancies.