Loading...
operations

Cargo Quantity Ship vs Shore Reconciliation Worksheet

Use this worksheet to reconcile liquefied gas cargo quantities between ship and shore using observed figures, density, temperature, and meter readings. It helps you document variance, explain differences, and capture approval in one place.

Trusted by frontline teams 15 years of frontline software AI customization in seconds

Built for: Maritime Shipping · Oil And Gas Terminals · Lng And Lpg Operations · Port Operations

Overview

This worksheet is for reconciling liquefied gas cargo quantities when the ship figure and shore figure do not match exactly. It gives you a structured place to record the reconciliation date, vessel and voyage details, terminal name, cargo product, transfer reference, measurement basis, ship-side calculations, shore-side calculations, dynamic flow and metering data, variance analysis, and final approval.

Use it when you need a defensible comparison of observed quantity against corrected quantity, especially where density, temperature, and meter readings affect the final number. The template is useful for LNG, LPG, and other liquefied gas transfers where custody-transfer records, terminal logs, and vessel records must be aligned. It is also helpful when a discrepancy needs a documented cause category, such as meter drift, temperature difference, or calculation basis mismatch.

Do not use this worksheet as a generic delivery form or for transfers that do not require reconciliation detail. It is not the right fit when you only need a simple receipt, when no ship-shore comparison is required, or when the cargo type does not rely on correction factors and metering logic. Keep the form focused on the figures that matter, and avoid adding unrelated fields that slow down completion or create unnecessary PII exposure.

Standards & compliance context

  • If the worksheet is used in a regulated custody-transfer process, keep the measurement basis and supporting documents aligned with the applicable terminal or marine procedure.
  • Limit collection to the minimum necessary operational data and avoid adding unrelated PII, consistent with data minimization principles.
  • If the form is shared across organizations, preserve an audit trail showing who reviewed the figures, what was approved, and when the approval occurred.
  • For public-facing or shared digital forms, ensure the interface meets WCAG 2.1 AA expectations for labels, validation, and keyboard access.
  • If the worksheet is adapted for safety or incident follow-up, use clear attestation language so the reviewer understands what they are confirming.

General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.

What's inside this template

Reconciliation Overview

This section anchors the record to one transfer event so the ship, shore, and approval details all point to the same cargo movement.

  • Reconciliation Date (required)
  • Vessel Name (required)
  • Voyage Number
  • Terminal / Shore Facility (required)
  • Cargo Product (required)
  • Transfer / Bill of Lading Reference

Measurement Basis

This section matters because ship and shore figures are only comparable when the same density, temperature, and measurement standard are used.

  • Ship Figure Basis (required)
  • Shore Figure Basis (required)
  • Density Reference Method (required)
  • Reference Temperature (°C) (required)
  • Measurement Standard / Procedure

Ship Figure

This section captures the vessel-side observed quantity and correction inputs that explain how the ship figure was calculated.

  • Ship Observed Quantity (required)
  • Ship Quantity Unit (required)
  • Ship Density (required)
  • Ship Temperature (°C) (required)
  • Ship Correction Factor
  • Ship Calculation Notes

Shore Figure

This section records the terminal-side observed quantity and calculation notes so the shore figure can be checked against the ship record.

  • Shore Observed Quantity (required)
  • Shore Quantity Unit (required)
  • Shore Density (required)
  • Shore Temperature (°C) (required)
  • Shore Correction Factor
  • Shore Calculation Notes

Dynamic Flow and Metering

This section matters when meter readings and flow data are part of the reconciliation and need to support the final quantity.

  • Meter ID / Tag
  • Meter Start Reading
  • Meter End Reading
  • Average Flow Rate
  • Flow Rate Unit
  • Metering Notes

Variance Analysis

This section turns the difference between ship and shore into a documented result with a cause category and tolerance status.

  • Variance Value (required)
  • Variance Unit (required)
  • Variance Percentage
  • Is the variance within tolerance? (required)
  • Likely Cause Category
  • Variance Explanation

Review, Attestation, and Approval

This section creates the audit trail by showing who reviewed the reconciliation, what they confirmed, and when it was approved.

  • Supporting Documents
  • Reviewer Name (required)
  • Reviewer Role (required)
  • I confirm the ship and shore figures were reviewed using the available measurement records and that this submission is accurate to the best of my knowledge. (required)
  • Signature (required)

How to use this template

  1. Enter the reconciliation date, vessel name, voyage number, terminal name, cargo product, and transfer reference so the record is tied to one specific transfer event.
  2. Select the ship figure basis, shore figure basis, density reference method, temperature reference, and measurement standard before entering any quantities so both sides are compared on the same basis.
  3. Record the ship observed quantity, unit, density, temperature, correction factor, and calculation notes, then repeat the same process for the shore figures using the matching field types.
  4. Capture meter ID, start and end readings, average flow rate, flow unit, and metering notes so the dynamic flow record supports the reconciliation result.
  5. Calculate the variance value, variance percentage, and tolerance status, then classify the cause and write a concise explanation that references the supporting evidence.
  6. Attach the relevant documents, complete the reviewer attestation, and collect the approval signature after confirming the figures and explanation are internally consistent.

Best practices

  • Use the same measurement standard for both ship and shore figures before you compare any values.
  • Choose field types that match the data, such as numeric inputs for quantities and date pickers for the reconciliation date.
  • Record density and temperature at the time of transfer, not from a later estimate or a different cargo condition.
  • Keep the variance explanation specific by naming the likely cause category and the evidence that supports it.
  • Attach meter logs, ship records, and shore records while the transfer is still fresh so the audit trail stays complete.
  • Mark only the fields that are truly required, and use progressive disclosure for notes or exception details that apply only in certain cases.
  • Review units carefully, because mixing tonnes, cubic meters, and other units without conversion is a common source of false variance.

What this template typically catches

Issues teams running this template most often surface in practice:

Ship and shore figures are entered using different units, which makes the variance look larger or smaller than it really is.
Density reference method or temperature reference is left blank, so the correction factor cannot be verified later.
Meter start and end readings are reversed or copied incorrectly, which breaks the flow calculation.
Variance is marked within tolerance without documenting the tolerance basis or the reason for the difference.
The explanation field is too vague, such as 'measurement difference,' and does not identify the actual cause category.
Supporting documents are missing or attached after approval, leaving the reconciliation record incomplete.
Calculation notes are skipped even when the cargo required a correction factor or dynamic flow adjustment.

Common use cases

LNG Terminal Operations Lead
A terminal lead uses the worksheet after unloading LNG to compare vessel figures against shore meter results. The form captures density, temperature, and meter readings so the team can close the transfer with a documented variance explanation.
LPG Vessel Cargo Officer
A cargo officer completes the ship section during discharge and shares the record with the terminal for reconciliation. The worksheet helps align the ship calculation notes with the shore basis before final approval.
Port Metering Supervisor
A metering supervisor reviews start and end readings, average flow rate, and correction factors when the transfer result is outside the expected range. The variance analysis section gives a structured place to classify the cause and attach evidence.
Marine Audit and Compliance Reviewer
An internal reviewer checks whether the reconciliation record includes the right measurement standard, supporting documents, and attestation. The approval section creates a clear audit trail for later review.

Frequently asked questions

When should this worksheet be used?

Use it after a liquefied gas transfer when ship and shore figures do not match exactly, or when your terminal requires a formal reconciliation record. It is also useful for routine custody-transfer documentation, even when variance is within tolerance. If you only need a simple delivery receipt, this template is more detailed than necessary.

Who should complete the ship and shore sections?

The ship-side figures are typically completed by the vessel operator or cargo officer, while the shore-side figures are completed by terminal operations or metering personnel. A reviewer should then compare the two sets of figures and confirm the variance explanation. The approval section gives you a clear audit trail of who reviewed the reconciliation.

How often is this worksheet filled out?

It is usually completed for each cargo transfer, voyage, or terminal receipt where quantity reconciliation is required. Some operators also use it during exception handling when a meter issue, temperature shift, or density discrepancy needs investigation. If your process is recurring, this template can be cloned and reused as a standard transfer record.

What kinds of measurements does it capture?

The template captures observed quantity, unit, density, temperature, correction factors, meter start and end readings, and average flow rate. Those fields support a side-by-side comparison of ship and shore figures using the same measurement basis. That makes it easier to explain whether the variance comes from measurement method, conversion basis, or transfer conditions.

What are the most common mistakes when using it?

A common mistake is comparing ship and shore figures without confirming the same measurement standard, temperature reference, or density reference method. Another is leaving the variance explanation too vague, which makes later review difficult. It also helps to attach supporting documents at the time of review rather than after the transfer record is closed.

Can this worksheet be customized for different terminals or cargo products?

Yes. You can add terminal-specific fields, product-specific density references, or extra approval steps if your operating procedure requires them. Keep the form focused on the data you actually use, and avoid adding fields that do not affect reconciliation decisions.

How does this compare with ad hoc spreadsheets or email threads?

An ad hoc spreadsheet can track numbers, but it often misses the structured comparison, variance categorization, and approval trail needed for repeatable review. This template gives you a consistent field layout, clearer validation, and a single place for supporting documents and attestation. That reduces back-and-forth when ship and shore figures need to be explained.

What should be attached in supporting documents?

Attach the meter ticket, ship ullage or sounding records, shore meter logs, density reports, temperature logs, and any transfer notes that explain exceptions. Only include documents that are relevant to the reconciliation so the record stays focused and easier to review. If your process handles sensitive operational data, limit access to authorized personnel.

Go deeper on the topic

Related concepts
  • A standard operating procedure (SOP) is a documented, step-by-step procedure for a repeatable task — the written version of "how we do this here." Good SOPs...
  • Workforce management (WFM) is the operational discipline of getting the right employees, with the right skills, in the right place, at the right time — and...
  • A daily huddle is a brief (10–15 minute) standing meeting held at the start of a shift or workday to align the team on priorities, surface issues, and...
  • A deskless worker is any employee whose job happens without a desk, a company laptop, or a fixed workstation. They're roughly 80% of the global workforce —...
Related guides

Ready to use this template?

Get started with MangoApps and use Cargo Quantity Ship vs Shore Reconciliation Worksheet with your team — pricing built for small business.

Ask AI Product Advisor

Hi! I'm the MangoApps Product Advisor. I can help you with:

  • Understanding our 40+ workplace apps
  • Finding the right solution for your needs
  • Answering questions about pricing and features
  • Pointing you to free tools you can try right now

What would you like to know?