Pallet Exposure

See every pallet you're owed, and what it's costing you.

Pallet Exposure shows the pallets still out with your customers, grouped by customer and site, with an estimate of the hire cost building up. Use it to chase long-outstanding pallets before they turn into a bill.

Where to find it: Financial → Pallet Exposure

Pallet Exposure dashboard

This screen is read-only. It's built from the pallet movements recorded on your bookings.


Filter the view

Filter

Options

Customer / Customer Site

One customer, then one of their sites.

Provider

CHEP, LOSCAM or Other.

Pallet Type

Standard Wood, Standard Plastic, Half Pallet or Quarter Pallet.

Status

Outstanding (default), Returned, At Risk or All.

Date Range

The period to report on.

Read the summary cards

Card

What it shows

Total Outstanding

Pallets still out, across all active contracts.

Active Sites

Sites holding at least one of your pallets.

Est. Exposure

The estimated hire cost of the outstanding pallets, in NZD.

Oldest Outstanding

How long the oldest pallet has been out. The card turns red when it passes the long-term threshold (30 days by default).

Drill into a site

The Site-Level Breakdown shows one row per customer site, with the provider and pallet type, quantity and net outstanding, the oldest date and days outstanding, estimated exposure and status.

  1. Click the arrow at the start of a row.

  2. Contributing Movements opens, listing each booking ID, movement type, quantity, date and responsible party.

  3. Click a booking ID to open the booking.

Use Export CSV or Download Report (top right of the table) to share the list or work through it offline.

Chase the red ones first. Rows marked Long-term have passed the threshold and are the most likely to cost you.


How exposure is worked out

Measure

How it's calculated

Days outstanding

From the movement date to the return date, or to today if not yet returned. The start day isn't counted.

Net outstanding

Pallets dropped off minus pallets returned. If this is zero or less, exposure is zero.

Est. exposure

Net outstanding × the rate × billable days (or chargeable weeks for weekly rates). Free days come off first.

Rates come from your pallet rate card, set up by your administrator in Admin → Pallet Rate Cards. Rate changes apply going forward only; past exposure isn't recalculated.

It's an estimate. Exposure is a guide to help you recover pallets. It doesn't create invoice lines. If there's no active rate card, exposure shows as unavailable.

Good to know

  • You can invoice a booking while pallets are still out. Invoicing locks the commercial fields, but you can still record pallet returns.

  • Exposure keeps building until net outstanding reaches zero, whatever the booking status.

  • Partial returns reduce exposure in proportion. Fully returned pallets show zero.

  • Long-term status is based on time only, not on the cost.


Related

  • Bookings: where pallet movements are recorded.

  • Financial: how pallets, fuel, surcharges and billing fit together.


Need a hand? Email support@icos-tms.com or call 0800 001 668 (ext 3).

Feedback received!

Error submitting feedback, please try again later