← Back to guides
ImportVista · Guides · Demurrage

Demurrage and Detention: How to Track Free Days in Excel

Learn how to organize free days, demurrage, detention and container deadlines in Excel to reduce avoidable logistics costs.
October 03, 2026 1 min read
Demurrage and Free Days Tracker Excel dashboard by ImportVista

Demurrage and detention costs often arise because a container stays too long at the terminal or is returned after the equipment free-time period. The exact rules vary by carrier, terminal, equipment and contract, so the first step is to record the official free days for each shipment.

Key dates to track

  • Arrival or discharge date
  • Terminal free-time start
  • Last free day at the terminal
  • Terminal exit date
  • Equipment free-time start
  • Empty-container return deadline
  • Actual empty return date

Build a simple Excel control

Use one row per container and calculate the last free day from the agreed free-time allowance. Add status fields such as OK, due soon and in cost, plus estimated daily charges when available.

The ImportVista Demurrage & Free Days Tracker is designed for this workflow, including deadline control and estimated charges.

Why this matters

A centralized view helps logistics teams identify containers that need action before costs start. It also creates a useful historical record for reviewing recurring issues by carrier, terminal or operation.

For broader control across shipments, quotations, landed cost and documentation, see the ImportVista PRO Pack.

Always verify official free-time rules and tariff scales for each shipment.

1LearnUnderstand the workflow in this guide
2TryUse a free tool first
3PROMove it into a reusable template
See use case: 20 imports/month →
Logistics resources

Get new guides and free logistics tools

Only import, export, freight and Excel content. Unsubscribe at any time.

Put the guide into practice

Use Excel tools built for real logistics operations.

Shipment tracking, landed cost, freight quotes, documentation and free days in ready-to-use templates.

Can I try ImportVista before buying?+

Yes. ImportVista offers free online calculators and Excel resources so you can test the workflow before moving to a PRO template.

Do the templates connect automatically to carriers or ERP systems?+

No. Standard templates use the data you enter in Excel. Carrier APIs, ERP, TMS and external automations are separate projects.

Is it a subscription?+

No. Standard templates and packs are one-time purchases; any product with different terms states them clearly on its product page.