Logistics ERP Consultant, USA

How a US shipment file turns into revenue and cost

Take an ocean import handled door to door. The forwarder quotes using a carrier contract rate plus origin charges from an overseas agent, the importer accepts, and a file is opened. The advance security filing for ocean cargo is made, the container sails, and the broker prepares the entry. At arrival there are terminal charges, possibly exam fees, then drayage to a warehouse or the importer's dock. Every one of those steps produces a buy cost, and most produce a sell charge.

The trouble in many US firms is that the file lives in forwarding or brokerage software while the ledger lives in QuickBooks or a mid-market accounting package. Charges are rekeyed, invoices go out before drayage and terminal bills arrive, and gross profit per file is only visible once someone reconciles by hand.

I write these flows down service line by service line through process mapping, then agree a simple rule set: which system creates the customer invoice, which one holds vendor bills, when expected cost is accrued and what happens when the actual bill differs. The logistics ERP overview covers the general model; this page focuses on how it plays out for American operators.

Duty advances and other money that is not yours

A customs broker often pays duties and fees on an importer's behalf, either directly or by arranging payment through the client's own account. Forwarders do something similar with ocean freight collected from a consignee and paid on to a carrier. Treated as revenue, these amounts inflate the top line and distort margin. Treated loosely, they become unrecovered cash that no one owns.

The ERP design needs a few clear rules:

• advances posted to a recoverable balance per client, separate from service income
• disbursement lines on invoices that show the pass-through clearly to the importer
• credit limits that include unrecovered advances, not just unpaid service fees
• aging that separates duty advances from brokerage and forwarding fees
• a review step before a new entry is filed for a client who is over limit

Whether duty is paid through the broker or directly by the importer depends on the arrangement and current CBP processes, so I document what your firm actually does rather than assume. Your CPA should confirm how pass-through amounts are presented in the financial statements. I then test the design with a file where duty, a fee and an exam charge all hit the same invoice.

3PL contracts, warehouse billing and foreign-trade zones

Contract logistics in the US is billed in many small pieces. One client pays per pallet position per month, another per carton received, per order picked and per label printed, with minimum monthly charges and special project fees on top. The warehouse management system knows what happened. The ERP has to turn that activity into an accurate invoice without a coordinator assembling it in a spreadsheet.

I build a billing catalog per client during requirements gathering: the billable events, the unit of measure, the rate, any tiers or minimums and the evidence a client may ask for. Then we decide whether the WMS rates the activity and passes priced lines to the ERP, or passes raw activity for the ERP to rate. Both work; mixing the two does not.

Some 3PLs also operate warehouses inside a foreign-trade zone, where goods can be held with duty deferred until they enter US commerce. Zone inventory control and reporting are specialist territory, usually handled in dedicated software that zone operators approve. The ERP's job is to bill the zone services and keep client inventory off your own balance sheet. More on the storage side sits in ERP for warehousing.

Sales tax, entities and agents abroad

Sales tax touches US logistics less than it touches product businesses, because many freight and transportation services are not taxable in most states. Less is not never, though. Delivery charges bundled with a taxable sale, some warehousing or fulfillment services and certain handling fees can be treated differently from one state to the next, so I list every charge code and ask your tax advisor to classify it before tax rules are configured. The classification is their call; my part is a tax setup that applies it the same way on every invoice.

Entity structure matters too. Many groups keep a brokerage company, a forwarding company and sometimes a trucking or warehouse company under common ownership, invoicing each other for shared work. Intercompany charges should be generated from the job, not posted by memory at month end.

Finally, the overseas agent network. Agents in Asia, Europe and Latin America bill you and are billed by you, often in their own currency, under profit-share arrangements agreed by email years ago. I document each arrangement, design a statement and netting routine and make sure exchange differences land in the right accounts. For a broader currency design, see multi-currency ERP.

Replacing QuickBooks around the freight system

The typical US pattern I see is specialist forwarding or brokerage software that the operations team likes, sitting next to an accounting package that finance has outgrown. Replacing the operational system is rarely the first move. More often the question is which ERP should sit behind it, how charges and invoices flow across, and whether the warehouse side needs its own WMS.

During vendor selection I give each shortlisted option the same scripted week: a consolidation with several house bills, a brokerage entry with a duty advance, a 3PL billing run with a minimum charge, a late drayage bill that differs from the accrual and an agent statement to net and settle. Vendors that handle that week on screen tell you more than any feature list.

For migration, the priorities are open files with accrued costs, unrecovered advances, open agent balances by currency and active client rate cards. I work remotely across US time zones, holding live sessions when your East and West Coast teams overlap and using recorded walkthroughs for warehouse staff on shifts. The US ERP consultant page and the US hub explain how I engage more generally.