Month-End Close: Where Forwarders Lose Margin

The month-end close at a mid-sized freight forwarder in Brazil typically takes ten to fifteen business days after the period ends. In a company processing 300 to 500 shipments per month, the finance team needs to verify, shipment by shipment, whether all costs have arrived, whether each invoice was issued at the correct amount, and whether the exchange rate used for billing matches the rate at the time of payment. Until that review is done, the owner works with a provisional margin figure, and pricing, credit, and investment decisions stay on hold.

The delay happens because real margin on each shipment only becomes final when the last cost is settled. In ocean freight, that last cost might be the overseas agent’s invoice, which arrives 30 to 45 days after sailing, or a retroactive demurrage adjustment from the carrier. Until every cost is posted, the margin in the system is an estimate, and the month-end result is a sum of estimates.

Quote, billing, and settlement: three margins that should match

Profit on a freight shipment passes through three stages, and each one produces a different number.

At the quoting stage, the forwarder estimates costs based on carrier rate sheets, terminal charges, and the day’s exchange rate, then applies the desired margin. This is the number the sales team presents to the customer and the one the owner uses to decide whether the business is worth taking.

At billing, the operator invoices the customer at the agreed amounts. If a surcharge increased between the quote and the sailing (a GRI or PSS from the carrier), or if the exchange rate moved from BRL 5.10 to BRL 5.20, the invoiced amount may not have kept up with the cost increase. The billed margin already diverges from the quoted margin.

At settlement, all actual costs enter the shipment record: the carrier’s invoice with the effective freight and surcharges, terminal handling and storage charges, the payment to the overseas agent, the AFRMM (Brazil’s Merchant Marine Renewal Fund contribution, collected at the CE Mercante registration), and any demurrage or detention charges. The realized margin appears at this point, and the gap between it and the quoted margin is where the forwarder’s money leaks.

In our experience with freight forwarders in Brazil, the difference between quoted and realized margin ranges from 5% to 15% of gross profit on ocean import shipments. For a forwarder billing BRL 2 million per month in services, that can mean BRL 15,000 to BRL 45,000 per month that the owner thought was profit but that, at settlement, turns out to have leaked along the way.

Costs that arrive after billing change the shipment result

An ocean import shipment involves, on average, 8 to 15 cost lines: base freight, carrier surcharges, origin THC, destination THC or terminal handling, BL fee, ISPS, storage, terminal release fee, insurance, inland trucking, AFRMM, plus any demurrage and detention charges. Each of these lines comes from a different vendor, with its own invoicing timeline and currency.

The carrier invoices freight and surcharges in US dollars, usually within 15 days of the vessel’s departure. The terminal charges handling and storage in local currency, with invoices that can arrive weeks after cargo release. The overseas agent sends origin cost invoices in US dollars, on a timeline that ranges from 15 to 45 days depending on the agreement between the parties. If the shipment generated demurrage, the carrier’s charge can take 30 to 60 days to arrive, sometimes landing in the month after the close.

On closing day, a portion of the month’s shipments still have outstanding costs. The finance team must decide between closing the month with an estimated accrual, subject to correction, or holding the close until the costs arrive. Both options carry a price: the wrong accrual distorts the result; the delayed close delays decisions.

Every cost that arrives after the customer has been invoiced is margin that shrinks without anyone having decided it would shrink. When the forwarder bills the customer based on the quote and then receives a carrier invoice with an unexpected surcharge, the difference comes out of the shipment’s margin. When volumes are high and the per-shipment deviations are small, they go unnoticed until the monthly total shows a result lower than expected.

Exchange rate between quote and payment: the variation the owner misses

Brazilian freight forwarders operate in two currencies. Costs with carriers and overseas agents are denominated in US dollars. Customer billing is in Brazilian reais. The Central Bank’s PTAX rate is the reference for conversion, but the PTAX date at quoting, the PTAX date at billing, and the PTAX date at payment to the vendor rarely coincide.

In September 2026, the PTAX sell rate sits in the range of BRL 5.15 to BRL 5.18. A three-centavo variation looks small, but on a shipment with USD 8,000 in freight and surcharge costs, three centavos per dollar amounts to BRL 240. For a forwarder processing 400 shipments per month, even if only half carry meaningful FX exposure, the accumulated variation can reach BRL 48,000 in the month, a figure that in many mid-sized forwarders equals one full-time operator’s worth of margin.

The problem deepens when the gap between quote and payment is long. A quote issued in July at BRL 5.10 that results in a carrier payment in September at BRL 5.18 transfers the entire variation to the shipment’s margin. If the forwarder billed the customer at the quote’s exchange rate, the difference stays with the forwarder.

The most common practice among Brazilian forwarders is to bill the customer at the PTAX on the invoice date and pay the carrier at the PTAX on the remittance date. That gap typically spans 5 to 20 days, and the FX exposure during that window belongs to the forwarder. Forward contracts reduce the risk, but most mid-sized forwarders do not hedge each shipment individually, because the cost per hedge does not justify itself on a per-shipment basis.

Manual cost reconciliation delays the close and hides errors

At many freight forwarders, cost reconciliation still means comparing the vendor invoice against the original quote or the shipment spreadsheet. The operator or finance analyst opens the shipment, checks line by line whether the recorded cost matches the received invoice, marks what has been paid, and flags what is pending. When shipment volumes are small, the method works. At 200 or 300 shipments per month, the manual review consumes days of the close cycle and lets through errors that, individually, look trivial but that in aggregate erode margin.

Three errors show up most often when manual reconciliation is the only check. An unbilled charge is a cost the forwarder paid to the carrier or terminal that never appeared on the customer invoice, either because it was absent from the quote or because it was posted to the shipment after billing. A duplicate cost is the same vendor invoice posted twice to the shipment, which happens when the original arrives by email and then surfaces again on a carrier payment portal. A wrong exchange rate is when the system recorded the cost in dollars at one PTAX rate and the payment was made at another, and nobody checked the difference.

Bank reconciliation, which cross-references actual payments against accounting entries, is another time-consuming step. A freight forwarder receives and pays dozens of transactions per day, and when a single remittance to a carrier covers multiple shipments, the finance team needs to open the remittance and allocate the amount across the corresponding shipments. Without that allocation, the per-shipment result is wrong, and the margin report by customer or trade lane loses its reliability.

Time spent manually reviewing shipments stretches the close. And every error that slips through is margin the owner does not know was lost.

How Tier2 Cargo tracks margin at each stage of the shipment

These three margin stages are built into the Tier2 Cargo workflow. At quoting, the system records the projected margin with the exchange rate and costs at that moment. As the shipment progresses and vendor invoices come in, the margin updates: the forwarder sees, shipment by shipment, the difference between what was quoted, what was billed to the customer, and what was actually paid. At settlement, the final number appears alongside the projection, and the gap between the two is visible before the month-end close.

Tier2 Cargo captures the exchange rate at three points: the shipment date, the invoice date, and the settlement date. The FX variation between those points appears in the shipment result without the finance team needing to calculate it manually. The margin report by customer, trade lane, or operator reflects actual costs, allocated shipment by shipment, with over 60 reports available for the close.

See how it works or get in touch.

The month-end close gets faster when the finance team moves from checking to reviewing. With each shipment already showing updated margin as costs come in, the close becomes about verifying exceptions rather than reconstructing the month’s result. Count how many shipments from last month still had outstanding costs on closing day. That number is the size of the problem, and reducing it is the first step toward closing the month with a figure the owner trusts.