Help · Sales
Import any WMS file, and reconcile a client's billing
Your warehouse management system (WMS) exports its own columns. ContactRoll reads that file as it is: you say once, for each client, which column holds what, and ContactRoll keeps it. ContactRoll is the CRM beside your WMS, never the WMS: it keeps no stock.
Map a client's file once
- Open the client's company page and find Client operations.
- Under Import any WMS file, choose what the file holds: activity charges, daily measures, or receipts (what was expected against what was received).
- Choose the CSV file your WMS exported.
- For each field, choose the column that holds it. ContactRoll guesses from the column names; check each one.
- Say how the file writes a day: 2026-11-03, 11/03/2026 (month first) or 03/11/2026 (day first).
- For charges, you can translate the WMS's words for a charge into your price line's code, one a line, for example Pallet In = 3PL-RCV-PLT.
- Choose Save the mapping. The next file for this client is read the same way.
If the file is in ContactRoll's own columns, such as Date, Charge code, Qty, Rate and Reference, you don't need to choose each one. Choose the file, then press Use ContactRoll's own columns: that becomes the client's mapping, and any translations of charge names it had stay.
Preview, then import
Choose Preview to see what an import would do: how many rows would be taken, the first rows as they would be taken, and each row that would not be, by its line in the file and why. A preview changes nothing.
Choose Import to take the rows. A charge is priced by the WMS's own rate where the file gives one, otherwise by the client's rate card, otherwise by your price book.
Running a file again charges nothing twice
Each charge keeps its row id from the WMS. A row taken before is skipped, and the import says how many were skipped. So you can run the same file again after fixing the mapping, or import a longer export of the same month: only the new rows are charged.
If your WMS's file has no row id column, ContactRoll makes one from each row's day, code, quantity and rate, and its place among identical rows, so the same export run again still takes nothing twice.
If the WMS now says something different about a row taken before, such as another quantity, that row isn't taken again: the import says so by its line. Correct it with a credit note or a new row.
A day's measures imported again replace that day.
Reconcile a month before you invoice
Under Billing reconciliation on the client's Client operations, choose a month. You see each activity's quantity and amount from the WMS, what is on an invoice, and what is not invoiced yet.
Each invoice of the client's activity in that month is checked against its activity. ContactRoll says when:
- charges in the invoice's days came in after the invoice was made, and are on no invoice;
- the month's minimum monthly charge no longer matches: the month's charges now leave a different top-up than the invoice carries;
- a line doesn't match the activity behind it.
The minimum monthly charge, the month's charges and the top-up are shown together. The same differences are shown on the draft invoice above Issue the invoice, so you read them before it goes out. Issuing isn't blocked: you decide.
An invoice holds 200 lines. If a client's days would need more, ContactRoll says so and makes nothing: invoice fewer days at a time.
Warehouse clients shows every client's month: what the WMS says, what is invoiced, what isn't, and how many differences there are.
Reconciliation is for whoever makes invoices. Mapping charges is too; mapping daily measures and receipts is for whoever may change the client.
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.