Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Industry guides

Cold-storage billing: reconcile pallet days before approving the invoice

Match storage invoices to pallet movements, billing boundaries and agreed minimums, while keeping physical occupancy separate from chargeable storage.

By Institution5 minute readPublished View sources
In this guide

Reconstruct the charge from movements and the agreement

A cold-storage invoice should be explainable from the stock held, the time it occupied space and the customer's agreed charging rules. Start with the warehouse movement record and the contract. The invoice's closing pallet count is insufficient when goods arrived, left or changed storage conditions during the month.

Keep physical occupancy and billable occupancy separate. A warehouse may hold 80 physical pallets on a day while an agreement charges for 100 reserved positions, a minimum storage period or a different unit such as weight. Those can be valid commercial arrangements, but the invoice needs to show which rule produced the amount. An internal consolidation of pallets should not silently change the charging unit.

The UNEP and International Institute of Refrigeration cold-storage brief describes the operating role of refrigerated warehouses and their energy demands. It does not prescribe a universal storage tariff. The financial review here uses the actual agreement and movement evidence; any rates in the example are hypothetical.

References: UNEP and International Institute of Refrigeration: Cold storage and refrigerated warehouses

Define the clock and the unit

Confirm when storage begins and ends: physical receipt, completed put-away, release authorization, loading or departure. Identify the timezone and treatment of partial days. If the contract bills calendar days, establish whether the arrival and departure dates count. A calculation based on elapsed hours can disagree with a valid calendar-day rule even when both systems hold the same timestamps.

Document what counts as a pallet. Mixed pallets, oversized loads, stacked pallets and partially picked stock can require different commercial treatment. Retain the original inbound identifier and every split or merge so a reviewer can follow the relationship between the customer's stock and the invoice quantity. If a provider bills reserved positions, reconcile the reservation schedule separately from actual units held.

Map additional services to their own events. Receiving, dispatch, blast freezing, picking, relabeling, temperature-specific handling and emergency access may have separate rates. Check the agreement for the trigger and minimum charge for each service. Do not convert an unexplained fee into storage days merely to force the invoice total to match.

Build a daily quantity bridge

For each storage class, start with the prior day's closing units, add accepted receipts and subtract eligible dispatches. Then record any approved unit conversion or correction. Preserve the event timestamps behind the daily total. A monthly summary is useful for reporting, while the event log is what explains a disputed day.

Use stock status carefully. Goods on quality hold may still occupy refrigerated space, so their storage cost can continue even though the business cannot sell them. A dispatch instruction does not necessarily remove physical occupancy if the carrier has not collected the goods. Conversely, a late system update should not create extra billable days if evidence shows the goods departed earlier and the agreement ends billing at departure.

Reconcile the opening and closing quantities to the warehouse's stock statement. Investigate differences before evaluating rates. If ten pallets are missing from the movement history, a correct rate calculation on the incomplete population still gives the wrong invoice. Assign each unresolved movement to the warehouse or customer owner who can supply the evidence.

Calculate an illustrative month

Assume a 30-day month and a hypothetical agreement charging $1.40 per pallet per calendar day. It counts pallets present at the end of each day, with no minimum reservation or partial-day charge. There are 40 pallets for days 1 through 10, 55 for days 11 through 20 and 25 for days 21 through 30. Chargeable occupancy is 400 plus 550 plus 250, or 1,200 pallet days.

The storage charge is therefore $1,680. Using the closing balance of 25 pallets for the whole month would produce only $1,050 and miss $630. Using the peak balance of 55 for all 30 days would produce $2,310 and overstate the same charge by $630. Both shortcuts discard the timing that the contract requires.

Now assume the signed agreement instead contains a 50-position daily minimum. The billable quantities become 50, 55 and 50 for the three intervals, producing 1,550 position days and a $2,170 storage charge. The physical occupancy still totals 1,200 pallet days. Keep both measures so purchasing can see the cost of reserved capacity while accounting can reproduce the invoice.

Calculate an illustrative month
Illustrative intervalPhysical palletsDaysPhysical pallet days
Days 1 to 104010400
Days 11 to 205510550
Days 21 to 302510250
Total301,200

Resolve exceptions without losing the original record

When a movement is wrong, preserve the original event, the corrected event, the evidence and the approver. A correction may affect both inventory and a prior invoice. Ask the provider to identify the credit or supplementary charge explicitly instead of silently changing an older stock statement that has already supported a closed period.

Review boundary events such as a late-night receipt, a load collected after the month's final cutoff or pallets moved between temperature zones. The source timestamp, operational event and billing rule must all refer to the same event. If the agreement is unclear, obtain a written clarification for future invoices and resolve the current disagreement through the agreed commercial process.

Separate commercial disputes from physical discrepancies. The warehouse can accurately report 60 pallets while the parties disagree over whether a minimum charge applies. Finance should retain the supported inventory record, record the disputed invoice component and ask the appropriate reviewer how to treat it. Altering stock quantities to represent a pricing dispute corrupts the warehouse reconciliation.

Use the reconciliation in the next storage negotiation

A few months of daily occupancy can show whether the business regularly pays for unused reserved positions, receives frequent handling charges or creates costly peaks through purchasing decisions. Compare the invoice with the operation that caused it. A low headline pallet-day rate may be less attractive once minimums and repeated handling are included.

Before changing providers or reducing reserved capacity, consider the service needed at the actual peak, product requirements, receiving windows and the availability of alternative space. The cost review should support those choices, not encourage unsafe storage or an inventory move the operating team cannot execute.

Close each invoice review with the quantity bridge, rate version, additional-service events, approved exceptions and evidence of any credit. That package allows the next reviewer to trace the bill without rebuilding the month from emails, and gives procurement an accurate record of what the storage arrangement costs under the business's real delivery pattern.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.