Laytime Calculation Preparation Checklist: Make Every Input Traceable

Key takeaways

• Separate contract rules, observed events and analyst assumptions.
• Reconcile the cargo quantity and time references before calculating.
• Show alternative treatments for unresolved issues instead of hiding them in formulas.

Build the rule sheet from the actual agreement

Collect the charter form, recap, riders and incorporated documents. Identify the provisions governing the allowance, commencement, exclusions, completion and any arrangements connecting loading and discharge. Record the exact source location for each rule in a separate preparation sheet.

BIMCO's published laytime definitions distinguish several commonly used expressions and are intended to apply when incorporated. Check whether the parties adopted them and which provisions are relevant rather than importing familiar definitions automatically. BIMCO definitions document.

Ask the authorised reviewer to resolve material ambiguity. The analyst can explain how different readings affect the structure of the calculation, but should not bury an interpretation in a cell label. A rule sheet makes the reasoning visible before anyone debates the final balance.

Keep a separate field for internal planning assumptions. Estimated handling productivity or a voyage budget may be useful background, but neither should enter the contractual allowance unless it is actually part of the agreed basis.

Reconcile quantities and units before using them

Determine which quantity source the agreement requires. The relevant figure may need to be taken from a specified document or determined through an agreed process. Collect the supporting document and record its version rather than selecting whichever figure appears first in the voyage folder.

Check units and labels carefully. A cargo account can contain several quantities for different purposes, and their apparent similarity does not make them interchangeable. Record the measurement basis and any unresolved discrepancy. If a conversion is needed, make the method explicit and obtain appropriate review.

Where loading and discharge documents differ, preserve the difference and ask which figure applies to each part of the calculation. Do not overwrite the source data to make the workbook look consistent. The preparation objective is a transparent chain from document to input, including the reason an input was selected.

Construct one chronology from several records

Use the statement of facts as an organising document, then connect material entries to notices, ship records, terminal reports and relevant correspondence. Check that arrival, notice transmission, inspections, cargo work and completion are described consistently. Identify omissions before breaking the chronology into counting intervals.

Adopt a clear time reference and retain original timestamps. An interval crossing midnight must carry both dates. If records use different clocks, document any conversion separately. This protects the workbook from an apparently small formatting change that alters the underlying duration.

Resolve overlaps and gaps explicitly. Two recorded interruptions may occur at the same time; adding both durations could double count the period. A gap between entries is not proof that operations continued or stopped. Ask for supporting information and mark any remaining uncertainty.

Use a calculation-readiness table

Use the table before entering the final formulas. An item may be ready for a provisional calculation while still requiring a formal decision. Label that status clearly so the provisional result is not circulated as an agreed account.

The table also supports efficient review. A senior reviewer can focus on unresolved commencement or exclusion questions rather than checking every undisputed timestamp again. This division of work improves the quality of judgment without reducing the traceability of the underlying data.

Design the workbook to expose assumptions

Separate source data, rule selections and calculated output. Give each interval a start, end, factual description, source reference and treatment explanation. Where an interval is split because a contractual condition changes, explain the boundary rather than leaving the reader to infer it from the numbers.

Use formulas that a second analyst can inspect and reproduce. Avoid unexplained manual adjustments in the final balance. If an agreed commercial adjustment is applied, show it separately from the time calculation and retain the approval supporting it.

For disputed events, prepare clearly labelled alternatives. Changing a single assumption should produce a traceable alternative result without modifying the historical data. This helps parties discuss the actual point of disagreement instead of arguing over two opaque totals generated from different hidden premises.

Before release, have another person check the chronology, source links and treatment logic. Arithmetic validation matters, but a spreadsheet can be mathematically correct and commercially wrong if it uses the wrong completion event or an unsupported allowance input.

Fictional case: overlapping stoppage descriptions

In this fictional case, a loading record shows a weather interruption and a conveyor problem covering part of the same period. The first draft workbook subtracts both entries in full because they appear as separate lines in the agent's report.

The preparer reconstructs the timeline and identifies the overlap. The revised chronology preserves both reported causes but divides time into non-overlapping intervals. The reviewer then considers the agreed wording and evidence for each interval; the analyst does not assume that either description automatically establishes an exclusion.

The final working file shows the source entries, the interval structure and any unresolved treatment. It prevents duplicate arithmetic while leaving the contractual question available for proper review. That is the difference between cleaning data responsibly and deciding entitlement through spreadsheet design.

Common mistakes

The most consequential mistakes often precede the arithmetic: using an unapproved recap, selecting the wrong cargo quantity or assuming the notice commencement rule from another fixture. Verify those inputs before polishing the output.

Other problems include mixing time references, subtracting overlapping interruptions twice and using departure as completion without checking the agreement. Avoid hiding disputed treatment in a formula. A visible assumption may invite a question, but it also gives reviewers a clear route to resolve it.

Where Zeaclub fits

Zeaclub supports agentic, AI-assisted operations with a human in control.

Zeaclub provides a multi-party shared workspace for owners, charterers, brokers and port agents.

Explore Zeaclub

Visit the Zeaclub website