---
title: "Invoices: create a contract carrier billing proposal from a spreadsheet."
description: "Learn how to create billing proposals from contract carrier spreadsheets in Qargo by pasting data, matching loads and charges, validating results, and converting proposals into carrier invoices."
url: https://help.qargo.com/us/articles/529676-invoices-create-a-contract-carrier-billing-proposal-from-a-spreadsheet
locale: us
updated: 2026-01-20
---

# Invoices: create a contract carrier billing proposal from a spreadsheet.

[![](https://help.qargo.com/media/75ec7aa74361-1ca69eb1-f09f-46a3-a007-851f9e3ec5f1.png)](https://rousing-seal.clueso.site/share/adc9b804-29cf-4403-a538-cb11b27c50ce)

## Introduction {#h_65e078c5f5}

Managing carrier invoices from contract carriers efficiently is vital in transportation operations. Qargo offers flexible options for handling these invoices, whether they arrive as spreadsheets containing charges and costs or as more traditional invoice files. This article explains how to process information and generate a billing proposal using spreadsheet data.

A common use case for this feature is when contract carriers submit large volumes of charges in a spreadsheet. Transportation companies then need to quickly reconcile, validate, and convert these charges into official carrier invoices in Qargo.

* * *

## Key terminology {#h_57b5f39c8a}

-   **Carrier invoice**: An invoice received from a supplier or contract carrier requesting payment for goods or services provided.
-   **Billing proposal**: A preliminary document summarizing charges and loads, which can be reviewed, modified, and converted into a carrier invoice.
-   **Spreadsheet template**: A predefined table format provided by Qargo, into which contract carrier charges are pasted for reconciliation.
-   **Reference number/load reference**: A unique identifier for each transportation job or load, used to match contract carrier charges with orders in Qargo.
-   **Scan and match**: The Qargo feature for matching spreadsheet data to existing records using specified columns (such as reference number and charge amount).
-   **Self-bill**: An automated invoice generated and sent to a contract carrier, often used when the company prepares invoices on the supplier's behalf.

* * *

## Summary overview {#h_390a2ef4a0}

For **carrier invoices**, the "Upload spreadsheet" flow works as a **paste-into-the-grid** flow, rather than an actual upload of a .csv/.xlsx file

### Steps {#h_9dd1a3a08c}

1.  Go to **Carrier invoices** and start creating a new draft billing proposal.
2.  Choose the option to **upload spreadsheet** / **add data from spreadsheet**.
3.  In the supplier's spreadsheet, select the table range (including headers) and **copy** it.
4.  Click in the template grid in Qargo and **paste** (Ctrl/Cmd + V).
5.  Select the columns Qargo should use for matching, at minimum:

    -   the **job/order reference** column, and
    -   the **charge/cost amount** column
6.  Review the matches and resolve any unmatched lines.
7.  Save the billing proposal.

### Good to know {#h_a6f1cae45a}

-   The **minimum required info** for matching is "job reference + charges/costs".
-   Avoid **empty lines** in the pasted data, as they can cause issues when saving.

### Workflow steps {#h_c4e0ebc3da}

1.  **Navigate to carrier invoices** Go to the main menu and select **Invoices > Carrier invoice**.

    ![](https://help.qargo.com/media/1067adb63e03-Navigate-to-PI.png)

2.  **Create a new carrier invoice** Click **Create carrier invoice** and choose the **Draft billing proposal** option.

    ![](https://help.qargo.com/media/57222c15855a-Create-new-PI.png)

3.  **Obtain and prepare the spreadsheet template** When prompted, copy the contract carrier charge data into the provided spreadsheet template. Either entire tables or specific rows can be copied, depending on the data structure.

    ![](https://help.qargo.com/media/e2d5dacf7343-Scan-spreadsheet.png)

4.  **Specify the data structure** Indicate whether the first row is a header by turning on the relevant toggle. This helps the system handle columns correctly during scanning.

    ![](https://help.qargo.com/media/7958c250810f-specify-data.png)

5.  **Identify the matching criteria** Select the columns that contain the reference number (for example, **Load reference**) and the charge amount. These are used to match spreadsheet lines to jobs in Qargo.

    ![](https://help.qargo.com/media/4023e4e2c3b5-set-columns.png)

    ![](https://help.qargo.com/media/ce3bb516e90c-set-columns2.png)

6.  **Filter relevant columns** Use the toggle to show only the necessary columns for easier validation.

    ![](https://help.qargo.com/media/501f10f88dee-Filter-columns.png)

7.  **Complete the required details** Fill in the additional fields marked as required, such as payment terms, purchase reference, and company.

    ![](https://help.qargo.com/media/662e2a706569-required-details.png)

    ![](https://help.qargo.com/media/6043a47acee6-required-details2.png)

    ![](https://help.qargo.com/media/a98f64ebaa40-required-details-3.png)

8.  **Validate matches and create the billing proposal** Review how Qargo matches the spreadsheet data with its records, shown in a matching summary. Confirm and save to create a draft billing proposal.

    ![](https://help.qargo.com/media/8e56c0c5ed83-validate-matches.png)

9.  **Review and adjust** Check that all loads and charges are correct. Add any missing charges if needed, then finalize the draft.

10.  **Take next actions** From the draft proposal, actions such as creating a self-bill, uploading invoice documents, or sending the proposal for approval can be performed.

     ![](https://help.qargo.com/media/f9d6a8f386b3-draft-proposal.png)

11.  **Convert to invoice** When ready, convert the billing proposal into a carrier invoice. Supporting documents can also be uploaded and attached to the invoice.

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


### Handling a charge discrepancy {#h_6f851e06d1}

-   A **charge discrepancy** is shown on the individual row.

    -   An alert shows the amount of the discrepancy between the system and the submitted document.

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

-   Click the _copy icon_ to copy the charge submitted on the document

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

-   Click the _discrepancy icon_ to create the discrepancy against the document.

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

-   A **subtotal/total discrepancy** is shown for the full amount available.

-   The _'Accept'_ option automatically copies over the charges submitted by the contract carrier.

    -   Use this option when the cost value is 0.
-   When a charge does not match, use the _'Create dispute charge'_ option to keep the original charge amount.

    -   The disputed value is separated out for validation.

::embed{src="https://www.loom.com/embed/32197c7152a84300a41e29d8110aca5f"}

* * *

### Additional use case examples {#h_d7ad30ee6c}

-   A carrier receives a consolidated end-of-month spreadsheet from a contract carrier covering dozens of individual loads. With the scan and match feature, all loads are checked against Qargo orders. This ensures there are no missing or duplicate charges before the carrier invoice is confirmed.
-   A finance team processes a contract carrier's emailed spreadsheet with custom rates and surcharges. The team quickly pastes this data into the Qargo template, uses the matching summary to validate charges, and then attaches the scanned supplier invoice directly for audit purposes.
-   When a contract carrier submits an incorrect invoice, operations staff first create a billing proposal to review and correct the amounts before moving to formal billing. This reduces disputes and improves payment timing.

This structured workflow in Qargo streamlines carrier invoice handling, reduces the risk of manual errors, and speeds up payment cycles with contract carriers.


## Related articles

- [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)
- [Invoices: create a carrier invoice from a contract carrier invoice](https://help.qargo.com/us/articles/285485-invoices-create-a-carrier-invoice-from-a-contract-carrier-invoice.md)
- [Invoices – Create carrier invoice from loads](https://help.qargo.com/us/articles/285482-invoices-create-carrier-invoice-from-loads.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 an invoice from a customer self-bill](https://help.qargo.com/us/articles/171889-invoices-create-an-invoice-from-a-customer-self-bill.md)
