	In Browser
	StumbleUpon
	del.icio.us
	Google
	Google Buzz
	reddit
	LinkedIn

	Facebook
	Twitter
	Linkedin
	E-Mail

Generative AI > Google Gemini API > Freight Audit Agent

Freight Audit Agent

Author: Venkata Sudhakar

Freight carriers frequently invoice at rates that differ from contracted agreements. Duplicate charges, incorrect weight brackets, accessorial fees not in the contract, and billing for services not rendered are common. Manual freight audit is tedious but necessary to recover overcharges.

A Freight Audit Agent uses Gemini AI to compare each carrier invoice line against the contracted rate card, calculate expected charges, identify discrepancies, and generate dispute claims. This ensures ShopMax India pays only what was agreed and recovers overbilled amounts.

The below example shows how ShopMax India audits its monthly freight invoices from three carrier partners to identify billing errors and recover overcharges.

import asyncio
import json
from google.adk.agents import LlmAgent
from google.adk.tools import FunctionTool
from google.adk.runners import Runner
from google.adk.sessions import InMemorySessionService
from google.genai.types import Content, Part

# Contracted rates by carrier and weight bracket
CONTRACTED_RATES = {
    "BlueDart": {"0-0.5kg": 55, "0.5-2kg": 85, "2-5kg": 140, "5-10kg": 220},
    "Delhivery": {"0-0.5kg": 48, "0.5-2kg": 78, "2-5kg": 125, "5-10kg": 195},
    "DTDC":      {"0-0.5kg": 42, "0.5-2kg": 70, "2-5kg": 110, "5-10kg": 175},
}

# Actual carrier invoices
INVOICES = [
    {"invoice_no": "BD-4421", "carrier": "BlueDart",  "shipments": [
        {"awb": "BD00112", "weight_kg": 0.4, "billed_amount": 85},
        {"awb": "BD00113", "weight_kg": 1.8, "billed_amount": 85},
        {"awb": "BD00114", "weight_kg": 3.5, "billed_amount": 140},
    ]},
    {"invoice_no": "DL-8810", "carrier": "Delhivery", "shipments": [
        {"awb": "DL00220", "weight_kg": 0.3, "billed_amount": 48},
        {"awb": "DL00221", "weight_kg": 6.0, "billed_amount": 250},
        {"awb": "DL00222", "weight_kg": 1.2, "billed_amount": 78},
    ]},
]

def audit_freight_invoices(data_json: str) -> str:
    """Compare billed amounts to contracted rates and flag discrepancies."""
    data = json.loads(data_json)
    rates = data["rates"]
    invoices = data["invoices"]
    audit_results = []
    total_billed = 0
    total_expected = 0
    total_overcharge = 0

def get_rate(carrier, weight):
        r = rates.get(carrier, {})
        if weight <= 0.5:   return r.get("0-0.5kg", 0)
        elif weight <= 2:   return r.get("0.5-2kg", 0)
        elif weight <= 5:   return r.get("2-5kg", 0)
        elif weight <= 10:  return r.get("5-10kg", 0)
        return 0

for inv in invoices:
        carrier = inv["carrier"]
        for s in inv["shipments"]:
            expected = get_rate(carrier, s["weight_kg"])
            billed = s["billed_amount"]
            diff = billed - expected
            status = "OK" if diff == 0 else ("OVERCHARGED" if diff > 0 else "UNDERCHARGED")
            audit_results.append({
                "invoice": inv["invoice_no"],
                "carrier": carrier,
                "awb": s["awb"],
                "weight_kg": s["weight_kg"],
                "billed": billed,
                "expected": expected,
                "difference": diff,
                "status": status,
            })
            total_billed += billed
            total_expected += expected
            total_overcharge += max(0, diff)

return json.dumps({
        "line_items": audit_results,
        "total_billed": total_billed,
        "total_expected": total_expected,
        "total_overcharge": total_overcharge,
    })

audit_tool = FunctionTool(func=audit_freight_invoices)

AGENT_INSTRUCTION = """
You are a Freight Audit Agent for ShopMax India logistics finance.
When given invoice and rate data:
1. Call audit_freight_invoices with the data
2. Show a line-item audit table: AWB, carrier, weight, billed, expected, difference, status
3. Summarise total billed, total expected, and total overcharge amount
4. List each OVERCHARGED shipment as a dispute claim with the amount to recover
5. State the overall overbilling percentage and recommend a credit note request to each carrier
Format as a freight audit report for the logistics finance team.
"""

audit_agent = LlmAgent(
    name="freight_audit_agent",
    model="gemini-2.0-flash",
    instruction=AGENT_INSTRUCTION,
    tools=[audit_tool],
)

async def main():
    session_service = InMemorySessionService()
    runner = Runner(
        agent=audit_agent,
        app_name="freight_audit_app",
        session_service=session_service
    )
    session = await session_service.create_session(
        app_name="freight_audit_app",
        user_id="logistics-finance"
    )
    payload = json.dumps({"rates": CONTRACTED_RATES, "invoices": INVOICES})
    message = Content(parts=[Part(text="Audit these freight invoices against contracted rates: " + payload)])
    print("Freight Audit Agent - ShopMax India")
    print("=" * 40)
    async for event in runner.run_async(user_id="logistics-finance", session_id=session.id, new_message=message):
        if event.is_final_response() and event.content:
            for part in event.content.parts:
                if part.text:
                    print(part.text)

asyncio.run(main())

It gives the following output,

Freight Audit Agent - ShopMax India
========================================
FREIGHT AUDIT REPORT

AWB       Carrier     Weight  Billed  Expected  Diff    Status
--------  ----------  ------  ------  --------  ------  -----------
BD00112   BlueDart    0.4kg   Rs 85   Rs 55     +Rs 30  OVERCHARGED
BD00113   BlueDart    1.8kg   Rs 85   Rs 85     Rs 0    OK
BD00114   BlueDart    3.5kg   Rs 140  Rs 140    Rs 0    OK
DL00220   Delhivery   0.3kg   Rs 48   Rs 48     Rs 0    OK
DL00221   Delhivery   6.0kg   Rs 250  Rs 195    +Rs 55  OVERCHARGED
DL00222   Delhivery   1.2kg   Rs 78   Rs 78     Rs 0    OK

AUDIT SUMMARY
Total invoiced  : Rs 686
Total expected  : Rs 601
Total overcharge: Rs 85 (12.4% overbilling rate)

DISPUTE CLAIMS
1. BlueDart AWB BD00112: Rs 30 overcharge
   0.4kg shipment billed at 0.5-2kg rate (Rs 85) - should be Rs 55
   Action: Request credit note from BlueDart for Rs 30

2. Delhivery AWB DL00221: Rs 55 overcharge
   6.0kg shipment billed at Rs 250 - contracted 5-10kg rate is Rs 195
   Action: Request credit note from Delhivery for Rs 55

RECOMMENDATION
12.4% overbilling rate is above industry norm of 3-5%.
Recommend monthly automated audit and SLA penalty clause in next
contract renewal with both BlueDart and Delhivery.

The agent audited all 6 shipment lines in seconds, identified 2 overbilled items totalling Rs 85, and generated ready-to-send dispute claims for each carrier. A 12.4% overbilling rate across the sample suggests systematic billing errors rather than random mistakes - warranting a contract renegotiation with stricter penalty clauses. At scale across thousands of monthly shipments, this agent can recover significant freight overpayments automatically.

Send your comments, suggestions or queries regarding this site to [email protected].