Freight Audit12 minBack to blog11 August 2026

    Digitizing Freight Tariffs

    How PDF and Excel Become an Auditable Tariff Model

    Freight tariffs consist of tables, zones, weight classes and surcharge formulas. Learn how PDF and Excel tariffs are converted into machine-readable rules for automated freight auditing.

    Digitizing Freight Tariffs: How PDF and Excel Become an Auditable Tariff Model

    Freight tariffs in companies often already exist in digital form: as PDFs, Excel files, Word documents or combinations of multiple appendices, tables and emails.

    Even so, that does not make them machine-readable. For automated freight invoice auditing, it is not enough for a computer to be able to read the text of a tariff document. The system has to understand how the individual rules combine to produce the correct price for a specific shipment.

    That is what tariff digitization actually means: turning a document into a calculable tariff model.

    What does “digitizing freight tariffs” mean?

    Digitizing a freight tariff does not simply mean scanning a paper document or converting a PDF file into text. A digitized tariff must be structured in such a way that the system can automatically calculate, for a specific shipment:

    • which base tariff applies
    • which lane or zone is relevant
    • which weight class applies
    • which surcharges are charged
    • which discounts apply
    • which ancillary services are added
    • which special conditions must be taken into account

    Only then can software answer the question: “What should this shipment have cost according to the contract?”

    ShipCheck therefore converts tariff information such as base rates, weight and zone matrices, fuel formulas, toll logic and ancillary service prices into a machine-readable contract model.

    Why freight tariffs are particularly difficult to digitize

    A freight tariff is rarely just a two-column table. In practice, numerous dependencies may come together, for example: lane × weight × service × tariff period × surcharge × special condition.

    There are also different forms of representation. A tariff may contain, for example:

    • a price matrix in the Excel tab “Tariffs”
    • a separate zone mapping
    • a fuel escalation clause in a PDF
    • toll costs in an appendix
    • special conditions in footnotes
    • a discount in an email
    • different validity periods

    That is exactly why ShipCheck describes tariff structures as one of the most complex areas of logistics: weight classes, zones, surcharges, indices and special conditions have to be combined into a consistent calculation logic.

    A tariff document is not yet a tariff model

    This distinction is crucial. Suppose a PDF states: “For shipments from 501 to 1,000 kg in Zone 4, base rate X applies. In addition, the current fuel surcharge according to the agreed index is charged.”

    A person can read this rule. For automated auditing, however, it has to become structured logic:

    • Determine the shipment weight.
    • Determine the destination zone.
    • Select the correct weight bracket.
    • Load the applicable base rate.
    • Determine the fuel index valid for the billing period.
    • Calculate the surcharge.
    • Add any other ancillary costs where applicable.
    • Calculate the contractual expected costs.

    This is the difference between document recognition and tariff digitization. The first task asks: “What is written in the document?” The second asks: “How must the calculation be performed based on this information?”

    Which components of a freight tariff need to be digitized?

    The rules required depend on the relevant transport model. Typically, they may include:

    Base tariffs

    The actual freight basis for a shipment.

    Lanes and zones

    Prices can depend on origin and destination regions or specific lanes.

    Weight classes

    Many tariffs change depending on actual or chargeable weight.

    Fuel formulas

    Variable surcharges can be linked to indices, reference values and defined calculation periods.

    Tolls

    Toll costs can also be calculated according to contractually defined rules.

    Ancillary services

    Additional services have to be represented together with their respective prices and conditions.

    Discounts and special conditions

    A tariff model also has to represent exceptions. This combination is exactly what makes digitization demanding.

    Why simply reading PDF or Excel files is not enough

    Modern AI can read and structure documents very quickly. This solves a substantial part of the problem – but not all of it. A tariff document can be ambiguous. For example:

    • A footnote changes only a specific tariff bracket.
    • A discount applies only to base freight.
    • A surcharge applies only on certain lanes.
    • Two tables have different validity periods.
    • An exception overrides a general rule.

    A system that merely recognizes tables can misinterpret such relationships. The result may be digitized, but mathematically wrong. In automated freight auditing, an incorrect tariff model is particularly critical: a tariff digitized incorrectly can cause thousands of invoice line items to be systematically assessed incorrectly.

    How AI can be used in tariff digitization

    AI is particularly well suited to the first part of the process. It can, for example:

    • extract information from PDF, Excel or Word documents
    • recognize tables
    • categorize tariff components
    • structure rules and relationships
    • standardize different formats

    ShipCheck describes the process as follows:

    • The customer uploads the tariff – for example as a PDF, Excel or Word document.
    • ShipCheck’s AI reads and structures the information.
    • A calculable tariff model is created from the document.
    • A tariff specialist reviews and supplements the model.
    • Invoices can then be audited against it automatically.
    Digitization of freight tariffs in ShipCheck
    PDF, Excel and Word tariffs are converted into a calculable tariff model.

    The decisive point lies between steps 3 and 4. Speed is not the same thing as accuracy.

    Why human-in-the-loop makes sense for freight tariffs

    At ShipCheck, tariff digitization is therefore not left entirely to AI. After the automated structuring process, the digitized tariff model is reviewed and approved by a tariff specialist from the HDS team.

    This approach follows a simple principle: AI for speed. Humans for the final specialist check.

    This division of work is also explicitly described in ShipCheck’s broader communication: AI handles, among other things, the rapid digitization of invoices, shipment data and complex tariffs; people review digitized tariffs and approve audit rules.

    This matters particularly with complex contracts. An AI error in an individual data record is different from an error in the underlying tariff logic. An incorrect data record may affect one shipment. An incorrect tariff rule can affect every subsequent audit.

    From the digitized tariff to automated freight invoice auditing

    Once the tariff is available as a calculable model, it can be used as the basis for freight auditing. The contractual expected costs can then be calculated for every shipment. The system can determine, for example:

    • which tariff applies
    • which weight bracket applies
    • which zone applies
    • which fuel surcharge applies
    • which toll rule is relevant
    • which ancillary services are permitted
    • which discounts must be taken into account

    The result is then compared with the amount actually invoiced. ShipCheck performs this comparison at invoice-line-item level and can also account for dynamic surcharges.

    Tariff digitization is therefore not an isolated document task. It is the technical prerequisite for automating freight invoice auditing at all.

    Why the tariff version matters

    A tariff is also rarely valid indefinitely. Prices and conditions change, for example due to:

    • new contract periods
    • new fuel indices
    • toll changes
    • adjusted weight brackets
    • new discounts
    • changed surcharges

    A robust digital tariff logic must therefore account for which tariff version applies to which period. An invoice from March must not automatically be checked against a tariff that only became valid in July. That sounds obvious. In manually maintained models, however, this versioning logic creates additional work.

    Typical errors when digitizing freight tariffs

    Typical errorWhat happens
    Tables read correctly, interpreted incorrectlyThe numbers are correct, but the zone or weight-class assignment is wrong.
    Footnotes are overlookedIn complex tariff structures, decisive rules may be located outside the main table.
    Validity periods are missingA new tariff overwrites an older one even though older invoices still need to be audited against the previous version.
    Surcharge logic is oversimplifiedA fuel or toll formula is treated as a fixed percentage even though it is dynamic.
    Special conditions are missingIndividual discounts or exceptions are not incorporated into the tariff model.
    Documents are not connectedThe main contract, tariff matrix and amendments are processed separately even though together they form the pricing logic.

    What is the difference between OCR and tariff digitization?

    OCR or document recognition essentially answers: “Which characters, numbers and tables are contained in this document?” Tariff digitization goes one step further: “Which mathematical and contractual rules follow from this information for calculating a specific shipment?”

    That makes tariff digitization a considerably more demanding task. A tariff model must not only store information. It must be able to apply it.

    Which documents can be used for tariff digitization?

    In practice, freight tariffs exist in different formats. These can include:

    • PDF
    • Excel
    • Word
    • tariff appendices
    • individual tables
    • contract documents

    ShipCheck explicitly describes a workflow in which tariffs can be uploaded regardless of whether they are, for example, a PDF from an email attachment, an Excel file with multiple tabs or a Word document with extensive footnotes. The objective is always the same: heterogeneous documents are turned into a single, consistent, calculable tariff logic.

    When is automated tariff digitization worthwhile?

    Not every company necessarily needs specialized software for this. If, for example, there is only one very simple tariff, few shipments are handled, hardly any changes occur and manual checking remains manageable, an in-house Excel solution can be completely sufficient.

    Automated tariff digitization becomes particularly relevant when:

    • multiple carriers are used
    • several tariff structures exist in parallel
    • tariffs contain many zones and weight brackets
    • variable surcharges have to be considered
    • tariffs are updated regularly
    • large volumes of invoices are to be audited automatically

    The problem is then less about entering a tariff once. It is about continuously maintaining reliable tariff logic.

    Tariff digitization and market benchmarking are not the same thing

    A clear distinction is important here as well. A digitized tariff model answers: “Which conditions did we agree contractually?” It does not automatically answer: “Are these conditions good in the current market?”

    For freight invoice auditing, the digitized contract is the reference. Assessing market competitiveness, by contrast, requires external comparison data. HDS uses, among other things, real offers and tariffs from ongoing and completed projects for this purpose.

    LevelGuiding question
    Tariff digitizationWhat was agreed and how can it be calculated?
    Market benchmarkingHow good are these conditions compared with the current market?

    This distinction prevents a common misconception: perfectly digitized tariff logic does not automatically make a tariff economically attractive.

    What role does tariff digitization play in freight cost management?

    Once tariff logic has been structured, it can become much more than a document repository. It becomes the basis for:

    • automated freight invoice auditing
    • expected-vs.-actual comparisons
    • identification of recurring variances
    • claims
    • tariff analyses
    • ongoing freight cost controlling

    This turns a tariff document into an operational data model. That is where the real value of digitization lies.

    Conclusion: A digital tariff is not a PDF – it is calculation logic

    Freight tariffs today often already exist as digital documents. But that does not mean they can automatically be processed. For automated freight invoice auditing, a system has to understand which rules apply, how they relate to one another, which shipment they apply to and how the correct price is derived from them.

    Only when tables, footnotes, zones, weight rules and surcharge formulas have been turned into a calculable model has the tariff truly been digitized. AI can accelerate this process considerably. With complex tariff structures, however, specialist review remains important.

    The goal is not to read a freight tariff faster. The goal is to calculate it reliably.

    Frequently asked questions

    What does digitizing freight tariffs mean?

    It means converting tariff documents into a structured, machine-readable model that can automatically calculate the contractual cost of a specific shipment.

    Is a PDF already a digitized freight tariff?

    Not in the sense required for automated freight auditing. Although a PDF is stored digitally, its tariff rules first have to be structured as calculable logic.

    Which information needs to be digitized from a freight tariff?

    This can include base tariffs, lanes, zones, weight classes, fuel and toll logic, ancillary services, discounts and special conditions.

    Can AI digitize freight tariffs automatically?

    AI can extract tariff information from documents and convert it into structured rules. With complex tariffs, specialist review is useful to avoid misinterpretation of tables, exceptions or contractual logic.

    Why is OCR not sufficient for freight tariffs?

    OCR recognizes the contents of a document. For freight auditing, the system additionally has to understand how this information is connected mathematically and contractually.

    Which file formats can be digitized?

    Tariff information can be contained in PDF, Excel and Word documents, for example. The decisive point is not the original format, but whether a consistent tariff logic can be created from it.

    What happens after tariff digitization?

    The digitized tariff can be used as a reference for automated freight invoice auditing. The software calculates the expected cost of a shipment and compares it with the invoiced cost.

    Is tariff digitization the same as freight cost benchmarking?

    No. Tariff digitization represents the contractually agreed conditions. Benchmarking examines whether those conditions are attractive compared with the current market.