Help · Sales
Client profitability for a 3PL
Client profitability shows what each warehouse client brings in each month against the space and the labour it takes, what is left once those are paid for, and which way it is going. Open it from Warehouse clients (Client profitability, at the foot of the page) or search for it. It is for Owners, Administrators and Operations admins, and any role your organization gives it to.
What a client's month is made of
Revenue is sorted into kinds:
- Storage, handling, pick and pack, and accessorials: the client's activity charges for the month, each sorted by its charge code. Receiving on a rate card counts as handling; kitting, labeling and accessorials count as accessorials.
- Freight markup: what the client is billed for postage over what it cost, and the margin on freight loads delivered in the month.
- Minimum top-ups: when the month's charges come to less than the minimum monthly charge on the client's rate card, the difference.
A code that is on no rate card shows as Not sorted, under Charge codes not sorted. Choose its kind there once, and every month counts it that way.
Space is the pallet positions the client stored, from the daily measures you import from your WMS, averaged over the days measured. Labour is the hours you enter for the client's month, or else the hours on time entries against the client.
Margin
Margin is the revenue less the space at its building's cost per pallet position, and the hours at its building's labour rate. ContactRoll shows a margin only when it has what it needs:
- The client has a main building (Settings › Warehouses).
- The building's monthly cost is entered (Client profitability › By building).
- Pallet counts were imported for the month.
With no hours for the month, the margin is shown as before labour. Revenue per pallet position and per hour are shown either way.
Trend
Each client's trend is worked out from its last six months that had something in them: up or down when revenue moves by 2% of its average a month or more, otherwise steady. With fewer than three months, it says too few months. It is arithmetic, not a forecast.
Clients below their minimum
Below their minimum lists the clients whose month came to less than their minimum monthly charge, with the charges and the top-up. In the current month, the figures are so far.
By building
By building shows each building's pallet positions in use (your own count for the building where you entered one, otherwise the sum of its clients'), the revenue of the clients it serves, its whole monthly cost, what its empty positions cost, its clients' labour, and its margin. Revenue from clients with no building is shown under the table.
Download
Each view downloads as a CSV file or a PDF, for whoever may download reports. A client's own page downloads its twelve months.
Didn’t find what you needed? Ask us on the help center: the form is at the foot of its page, and the people who build ContactRoll answer.