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
- Vessel Name
- Voyage Number
- Terminal / Shore Facility
- Cargo Product
- 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
- Shore Figure Basis
- Density Reference Method
- Reference Temperature (°C)
- 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
- Ship Quantity Unit
- Ship Density
- Ship Temperature (°C)
- 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
- Shore Quantity Unit
- Shore Density
- Shore Temperature (°C)
- 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
- Variance Unit
- Variance Percentage
- Is the variance within tolerance?
- 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
- Reviewer Role
- 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.
- Signature
How to use this template
- 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.
- 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.
- 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.
- Capture meter ID, start and end readings, average flow rate, flow unit, and metering notes so the dynamic flow record supports the reconciliation result.
- Calculate the variance value, variance percentage, and tolerance status, then classify the cause and write a concise explanation that references the supporting evidence.
- 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:
Common use cases
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.
Related templates
Go deeper on the topic
-
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 —...
-
See how connected 1:1 tracking, employee audit history, and LMS completion records turn scattered processes into verifiable workforce documentation.
-
MangoApps Shifts & Schedules unifies frontline scheduling, time, and leave management in one native platform for faster, simpler operations.
-
See how bank branch managers use MangoApps scheduling to fill shifts, communicate policy updates, and eliminate last-minute coverage chaos.
-
See how customers use MangoApps Projects Module to collaborate, track progress, and share knowledge across teams.
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.