On UPN, you can download both the self bills and the cost invoices:

You need to make sure that you download the excel files:

When you download a self bill invoice, then you get an excel file with the following information:

Make sure to put the amount column to format number:

So that it appears as below:

You then need to go to invoices and press create invoice:

Then click on upload spreadsheet:

You can then copy paste the data from the spreadsheet on the right side and then select:

See example below:

At the bottom left, you get an overview of the references that were not found:

You can click on the search icon to search for this reference, you need to correct the reference in the order so that we can find it with the matching and then press rescan spreadsheet.

You can then save the invoice which will create the invoice that you can send to UPN.

You also have a functionality that allows you to easily correct all the amounts in Qargo with the correct amounts from the CSV file.

UPN cost invoices can be uploaded into Qargo and matched against consignments using the UPN consignment barcode as the matching reference.

1. NAVIGATE to Invoices in Qargo and select Create invoice.

2. SELECT Upload spreadsheet and paste the data from the UPN cost invoice file.

3. CONFIGURE the matching fields:

- Customer: UPN

- Reference column: Con No. (the UPN consignment barcode column in the file)

- Charge amount: the relevant amount column

4. REVIEW matched and unmatched lines. Any references not found will appear at the bottom left — use the search icon to locate the correct order and correct the reference if needed.

5. SAVE the invoice once all lines are matched.