---
title: "Palletline: self bill and billing comparison"
description: "How to import sales and purchase self bills from Palletline and compare the costs"
url: https://help.qargo.com/us/articles/203780-palletline-self-bill-and-billing-comparison
locale: us
updated: 2024-10-24
---

# Palletline: self bill and billing comparison

## Introduction {#h_7e710d9b36}

Both of the following can be downloaded from Contrado:

-   Sales self bill

    ![](https://help.qargo.com/media/28848f749620-image.png)

-   Purchase self bill

    ![](https://help.qargo.com/media/2b75600be0be-image.png)


Next, download the self bill by clicking the save button and selecting the Excel format (make sure to select **xlsx**):

![](https://help.qargo.com/media/86528bbd5096-image.png)

![](https://help.qargo.com/media/6e08d794069b-image.png)

![](https://help.qargo.com/media/c5d520a4cd2a-image.png)

## Sales self bill {#h_09200df4ff}

Open the Excel file and click filter:

![](https://help.qargo.com/media/403eeff87e2d-image.png)

Then filter on column Q and make sure to **deselect** the following:

-   Depot
-   (Blanks)
-   DeliverySupplement
-   DeliveryDepotCover

![](https://help.qargo.com/media/ca9883e431ba-image.png)

Next, select all the charges in column P and make sure to change the format to **General**:

![](https://help.qargo.com/media/93ebd993c83f-image.png)

Then create a new invoice in Qargo by clicking **Create invoice:**

![](https://help.qargo.com/media/ab22a1f704b3-image.png)

Select **Palletline** as the customer and click **Upload spreadsheet:**

![](https://help.qargo.com/media/bd80e7c65cc9-image.png)

Select everything in the Excel sheet (after filtering!), copy it and then paste it into Qargo:

![](https://help.qargo.com/media/079364dec166-image.png)

Then select reference column: A and charge amount column: P

![](https://help.qargo.com/media/f81deb4a9a3e-image.png)

Finally, click save. Qargo automatically compares the self bill with the amounts in Qargo.


## Related articles

- [PN - UPN: Self bill and billing comparison](https://help.qargo.com/us/articles/199672-pn-upn-self-bill-and-billing-comparison.md)
- [Invoices – Create a contract carrier self-bill from loads](https://help.qargo.com/us/articles/133825-invoices-create-a-contract-carrier-self-bill-from-loads.md)
- [Invoices: Create a carrier invoice from an existing billing proposal.](https://help.qargo.com/us/articles/133824-invoices-create-a-carrier-invoice-from-an-existing-billing-proposal.md)
- [See everything with a Contrado label that is not going to palletline](https://help.qargo.com/us/articles/142100-see-everything-with-a-contrado-label-that-is-not-going-to-palletline.md)
- [Trunk scanning](https://help.qargo.com/us/articles/141347-trunk-scanning.md)
