Clearing & Forwarding, Bonded Warehouse (CFS) & Customs Tariff ERP: Manifest Sync, Demurrage Detention Alerts, and Container Yard Slot Tracking

For Clearing & Forwarding (C&F) agencies, Container Freight Stations (CFS), and customs bonded warehouses handling imports and transit cargo through Mombasa, Nairobi ICD, JKIA, and regional border posts (Malaba, Busia, Namanga, Taveta/Holili), a single missed milestone on a Bill of Lading (B/L) can wipe out the agency fee on an entire consignment. When Vessel ETA changes, IDF/customs entry lodging, KEBS/Kentrade agency releases, port storage free-days, and shipping-line empty container return deadlines are tracked across WhatsApp groups and spreadsheets, firms lose millions annually to port storage penalties, shipping-line container demurrage/detention, and unrecovered third-party disbursements.

We build custom Clearing & Forwarding, Container Freight Station (CFS) & Bonded Warehouse ERP Systems that track every consignment from pre-alert and Bill of Lading ingestion through HS-code tariff duty estimation, customs entry workflow, container yard 3D slot mapping, and automated disbursement-locked client invoicing.

1. Where C&F Agencies and Bonded Warehouses Bleed Margin

• Port Storage & Shipping Line Free-Day Expiration: Every import container has two ticking clocks: port/ICD free storage days (typically 4 days for domestic cargo, 9–15 days for transit cargo) and shipping-line container demurrage/detention free days (From discharge until the empty container is dropped back at the appointed depot and the Equipment Interchange Receipt / EIR is uploaded). Missing an empty-return deadline by 5 days triggers USD $75–$150/day penalties per TEU/FEU.
• Unbilled Disbursement Leakage (Agency Pass-Through Costs): Declaration clerks and field runners pay out dozens of disbursements per file—shipping line delivery order (DO) fees, port handling, verification stripping/restuffing, agency permits, and shunting transport. If a runner pays a fee via M-Pesa or petty cash and forgets to attach it to the job file before the final invoice is raised, the C&F agency absorbs that cost out of its own commission.
• Customs Bonded Warehouse Bond-Liability Drift: Bonded warehouses operate under a strict KRA Customs Bond ceiling (e.g., KES 500M general bond). Every Ex-Warehouse Home Use (`EX-4`) or Re-Export (`EX-3`) entry must acquit the corresponding Warehousing Entry (`IM-7`) by exact tariff line, quantity, CIF value, and duty liability before the statutory warehousing period expires.

2. Consignment-Locked Disbursement & Duty Estimation Engine

In our C&F ERP, no operational disbursement (Delivery Order fee, port charges, verification labor, or truck shunting advance) can be paid out unless it is linked to an active ConsignmentFile and classified as either Recoverable Client Disbursement or Agency Cost. When the file reaches final invoicing, the billing engine automatically pulls 100% of recoverable disbursements onto the client's statement alongside the agreed agency clearing tariff:

# Python / Django: Customs Duty Calculator & Bonded Warehouse Acquittal Guard
from decimal import Decimal
from django.db import transaction
from django.core.exceptions import ValidationError

class CustomsTariffCalculator:
    IDF_RATE = Decimal("0.025")   # 2.5% Import Declaration Fee
    RDL_RATE = Decimal("0.020")   # 2.0% Railway Development Levy
    VAT_RATE = Decimal("0.160")   # 16.0% Value Added Tax

    @classmethod
    def compute_import_taxes(
        cls,
        cif_value_kes: Decimal,
        import_duty_rate: Decimal,
        excise_duty_rate: Decimal = Decimal("0.00"),
    ) -> dict:
        import_duty = cif_value_kes * import_duty_rate
        idf_fee = cif_value_kes * cls.IDF_RATE
        rdl_levy = cif_value_kes * cls.RDL_RATE
        excise_value = cif_value_kes + import_duty
        excise_duty = excise_value * excise_duty_rate
        vat_taxable_value = cif_value_kes + import_duty + excise_duty
        vat_amount = vat_taxable_value * cls.VAT_RATE
        total_taxes = import_duty + excise_duty + vat_amount + idf_fee + rdl_levy
        return {
            "cif_kes": round(cif_value_kes, 2),
            "import_duty_kes": round(import_duty, 2),
            "excise_duty_kes": round(excise_duty, 2),
            "vat_kes": round(vat_amount, 2),
            "idf_kes": round(idf_fee, 2),
            "rdl_kes": round(rdl_levy, 2),
            "total_customs_taxes_kes": round(total_taxes, 2),
        }