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
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.
Click the arrow at the start of a row.
Contributing Movements opens, listing each booking ID, movement type, quantity, date and responsible party.
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).