Guides

Invoice Pricing

View extracted invoice prices alongside packing data on the shipment page.

2 min read

Overview

When invoice documents are attached to a shipment, Trackberry extracts pricing data and displays it directly in the packing details table. This gives you a unified view of packing data and costs without switching between documents.

How It Works

Trackberry automatically matches invoice line items to packing lines based on produce variety, calibre, and pack format. When a match is found, two additional columns appear in the packing details table:

Column Description
Unit Price Price per box, shown in the invoice's currency (e.g. $12.50, €15.75)
Line Total Unit price × number of boxes for that packing line

A summary row at the bottom of the table shows the total value across all matched lines.

What Gets Matched

Trackberry uses a smart matching algorithm to pair invoice items with packing lines. It matches on:

  • Produce variety
  • Calibre / size count
  • Pack format

If a packing line has no matching invoice item, the price columns remain blank for that row. This can happen when the invoice uses different naming conventions or when not all items are invoiced.

Invoice Total Check

Trackberry includes an automated quality check that compares the sum of matched invoice line items against the declared total on the invoice document. This catches extraction errors where prices, quantities, or line items may have been misread.

The check uses a 1% tolerance to account for rounding differences between per-line totals and the document's grand total.

Result Condition
Pass Line items sum within 1% of the declared total
Fail Difference exceeds 1% — shows both amounts and the percentage gap
Skipped No invoice line items or no declared total found

Enable or disable this check in Settings > Checks. See the Quality Checks guide for more on configuring checks.

Tips

  • Invoice prices appear automatically — no configuration needed beyond uploading the invoice document
  • Multiple currencies are supported; each invoice uses the currency detected from the document
  • Make sure invoice documents are processed before reviewing pricing data on the shipment page
Tags: invoices pricing costs line items