# Reconcile shipping invoices
URL: https://support.starshipit.com/articles/11469376267151-reconcile-shipping-invoices
Canonical: https://support.starshipit.com/articles/11469376267151-reconcile-shipping-invoices
Markdown: https://support.starshipit.com/articles/11469376267151-reconcile-shipping-invoices.md
Updated: 2026-10-03

> For the complete documentation index, see [llms.txt](https://support.starshipit.com/llms.txt).

> Learn how to use Invoice Reconciliation to compare courier invoices with Starshipit shipping costs.

Upload a courier invoice in Classic UI to add Starshipit's recorded shipment and shipping-cost details to your CSV. Use the combined file to compare the courier's charges with your Starshipit records.

## Before you begin

- Use **Classic UI**. Invoice Reconciliation is available there; if its tab is missing, contact Starshipit Support for help with access.
- Prepare a CSV with a header row and a column containing package tracking numbers. Each file can contain up to 5,000 rows, including the header.
- Include at least one invoice row that matches a shipment in your account or an included child account. A report will not download if none of the tracking numbers match.

## Upload and generate the report

1. Go to **Analytics > Reports** and select **Invoice Reconciliation**.
2. Upload your courier invoice CSV.
3. Enter the heading of the column containing tracking numbers in **Tracking Number Column**. For example, enter `Tracking Number` if that is your CSV heading. Capitalisation does not affect matching.
4. Select **Include child accounts in report** if you want to match shipments from your child accounts as well.
5. Click **Generate** and open the downloaded CSV.

The downloaded file keeps your original invoice columns and adds columns beginning with `SSI_`. Check that matched rows contain Starshipit details before comparing costs. If only some rows match, unmatched rows remain in the file with blank `SSI_` fields.

## Review the shipment details

Use these columns to check which shipment and account each invoice row matched. This is particularly useful when reconciling invoices across child accounts.

| Field | What it shows |
| --- | --- |
| `SSI_ConsignmentId` | Starshipit shipment ID. |
| `SSI_AccountId` | Account ID associated with the shipment. |
| `SSI_AccountName` | Name of the account associated with the shipment. |
| `SSI_Weight` | Total shipment weight recorded in Starshipit. |
| `SSI_Dimensions` | Length × width × height of the shipment's first package. |

## Compare the shipping costs

Compare the courier's billed charges in your original invoice columns with the shipping costs added by Starshipit.

| Field | What it shows |
| --- | --- |
| `SSI_ShippingPricePaid` | Shipping amount paid by the customer at checkout, as recorded on the shipment. |
| `SSI_EstimatedShippingPrice` | Estimated shipping cost recorded on the shipment in Starshipit. |
| `SSI_Margin` | Custom margin recorded on the shipment. |
| `SSI_Discrepancy` | `SSI_EstimatedShippingPrice` minus `SSI_ShippingPricePaid`. |

A positive `SSI_Discrepancy` means the recorded shipping cost is higher than the amount the customer paid; a negative value means the customer paid more. This field does not calculate the difference between the courier's invoice charge and the estimate. Compare those amounts using your original invoice columns.

## Troubleshooting

| Problem | What to do |
| --- | --- |
| Starshipit cannot find the tracking number column | Check that **Tracking Number Column** contains the heading from your CSV, rather than a column letter or a tracking number. If you leave it blank, Starshipit looks for `Article No.`. |
| No orders are found | Check that you selected the package tracking number column and uploaded the invoice to the correct account. Select **Include child accounts in report** if the shipments belong to your child accounts. |
| Some rows have blank Starshipit fields | Check those tracking numbers against the packages in your account. The report keeps unmatched invoice rows so you can review them separately. |
| The file has too many rows | Split the invoice into files of no more than 5,000 rows each, including a header row in every file. |