# Invoice Reconciliation
URL: https://support.starshipit.com/articles/11469376267151-invoice-reconciliation
Canonical: https://support.starshipit.com/articles/11469376267151-invoice-reconciliation
Markdown: https://support.starshipit.com/articles/11469376267151-invoice-reconciliation.md
Updated: 2026-02-09

> 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.

The Invoice Reconciliation feature simplifies invoice checking by allowing you to upload courier invoices directly into Starshipit. It compares the shipping costs quoted by Starshipit with those charged by your courier, quickly highlighting any discrepancies. Starshipit supports all couriers and CSV invoice formats, provided your file contains a tracking number.

<!-- callout:info -->
Currently only supported in Classic UI.
<!-- /callout -->

## Benefits

| Benefit | Description |
|---------|-------------|
| Time-saving | Automates the reconciliation process, reducing manual effort |
| Accuracy | Provides a clear breakdown of discrepancies between quoted and invoiced shipping prices |
| Transparency | Enhances cost management by offering detailed insights into shipping costs |

## How it works

### 1. Upload your invoice

1. In Classic UI, navigate to **Analytics** > **Reports** > then select the **Invoice Reconciliation** section.
2. Upload your courier invoice in CSV format.
3. In the **Tracking Number Column** field, enter the exact column name from your CSV file that contains tracking numbers (case-sensitive).
4. (Optional) Tick **Include Child Accounts** if you manage multiple accounts and want to include their orders in the reconciliation.

### 2. Matching and report generation

Starshipit matches each tracking number from your uploaded invoice with orders in your Starshipit account.

When a match is found, Starshipit generates a new report based on your original invoice, appending additional details:

| Field | Description |
|-------|-------------|
| SSI_ConsignmentId | Unique shipment ID from Starshipit |
| SSI_AccountId | Starshipit account ID associated with the shipment |
| SSI_AccountName | Name of the Starshipit account associated with the shipment |
| SSI_Weight | Weight of the shipment declared in Starshipit |
| SSI_Dimensions | Dimensions of the shipments declared in Starshipit |
| SSI_ShippingPricePaid | The price paid for shipping on checkout |
| SSI_EstimatedShippingPrice | The estimated quoted shipping price from the carrier API when you printed the order in Starshipit |
| SSI_Margin | Any margin set in Starshipit through Customise Rates settings |
| SSI_Discrepancy | Difference between the price paid for shipping at checkout and the estimated shipping cost |

## FAQs

<!-- faq:start -->

<!-- faq:question -->What invoice formats does Starshipit support?<!-- /faq:question -->

Starshipit supports CSV formats from all couriers, as long as the file includes a tracking number column.

<!-- faq:question -->How does Starshipit match invoice data to orders?<!-- /faq:question -->

Starshipit uses the tracking numbers from your CSV invoice to find matching orders within your account.

<!-- faq:question -->What happens if my tracking number column name isn't found?<!-- /faq:question -->

Ensure the column name you entered matches exactly (case-sensitive). If Starshipit can't find it, the report won't generate, and you'll see an error.

<!-- faq:question -->What if some tracking numbers don't match orders in my account?<!-- /faq:question -->

The report will still generate, but unmatched entries will leave Starshipit-specific fields blank.

<!-- faq:end -->
