Freight Forwarder Bank Reconciliation: Every Line Counts

The finance team at a freight forwarder handling 400 shipments a month processes well over a thousand bank entries across local-currency and USD accounts. Some of those entries are credits from clients, which may cover a single invoice, three invoices bundled into one deposit, or a partial invoice with tax withholdings deducted. Others are debits to carriers, port terminals, overseas agents, government port fees and taxes. Until every entry has been identified and linked to the corresponding shipment in the system, the balance on the bank screen is one number and the forwarder’s actual financial position is another. Bank reconciliation turns the first into the second, and in freight forwarding that work is more complex than in nearly any other service business of the same size.

A forwarder’s bank statement has more counterparties per line than most service businesses

A law firm receives from clients and pays service providers. A trucking company collects freight and pays fuel, tolls and maintenance. A freight forwarder receives from importers and exporters, pays carriers in USD, pays terminals in local currency, pays overseas agents in dollars or euros, remits government port charges, advances customs clearance expenses for the customs broker and receives reimbursements from the same broker days later. Each shipment can generate five to fifteen distinct bank transactions, spread across accounts and currencies.

That counterparty count makes bank reconciliation at a forwarder a different job from what it is elsewhere. In a business with one counterparty per transaction, the analyst opens the statement, finds the credit, matches it to the invoice and moves on. At a freight forwarder, the same credit may be partially tied to two invoices from different shipments, with the importer having deducted income tax from one and social contributions from the other, and the remaining difference may be a set-off against a returned invoice from the prior month. Untangling that is what consumes the hours.

On the debit side, the same pattern holds. Carrier payments go through foreign exchange contracts, often in batches that cover multiple bills of lading. Terminal payments leave by bank slip, one per tax invoice, and the terminal may have split storage and handling charges into separate documents. In Brazil, the AFRMM (a federal port charge on ocean freight) is debited by the tax authority directly from the account linked to the shipment in Siscomex, and the amount may differ from what the operator calculated because the tax base uses the freight value on the CE Mercante filing, which does not always match the negotiated rate.

For the analyst reconciling the statement, every entry demands a decision: which shipment it belongs to, which document to write off, and whether the gap between the expected amount and the actual amount is a tax withholding, an exchange-rate difference, a data-entry error or an incorrect charge. At a forwarder running 400 shipments, that decision cycle repeats hundreds of times a week.

Withholding taxes make the credit not match the invoice

Brazilian law requires the buyer of a service to withhold taxes at the source when the provider is a legal entity and the service falls under Law 10,833/2003 and Normative Instruction RFB 1,234/2012. For freight forwarders, this means a share of clients deposits the invoice amount minus income tax (1.5%), CSLL (1%), PIS (0.65%) and COFINS (3%), totaling 6.15% withheld on the taxable service base. The invoice read BRL 10,000; the credit in the bank is BRL 9,385. If the analyst does not identify the withholding, the credit sits unmatched, and the shipment shows as overdue in accounts receivable.

The difficulty grows because withholdings do not always apply to the full invoice amount. International freight itself receives different tax treatment from local charges and pass-through costs. A forwarder that bills ocean freight (exempt or zero-rated for PIS and COFINS on imports under Brazilian law), local charges (subject to PIS and COFINS) and warehousing pass-throughs (which may or may not form part of the base) on a single invoice delivers a document with different withholding bases for each tax. The client’s tax department withholds on whatever base it considers correct. The resulting bank credit can diverge from the forwarder’s calculation by tens or hundreds of reais, and each divergence must be investigated before the shipment can be closed.

In our experience with freight forwarders in Brazil, reconciling withholdings consumes between 20% and 30% of the total bank reconciliation time on the receivables side. The most frequent cause of divergence is insufficient detail on the invoice: when the forwarder issues an invoice without clearly separating the tax bases, the client withholds on the full amount. A previous post on this blog described how returned invoices delay collections. Incorrect withholding produces a similar effect: the shipment stays open until the forwarder’s finance team and the client’s tax team agree on the correct amount.

On the USD account, every payment carries two values

A freight forwarder handling ocean imports pays carriers and overseas agents in dollars. Each payment goes through a foreign exchange contract with the bank, and the BRL value depends on the rate negotiated on the closing date. The cost recorded in the system sits in USD, booked at the quote-date rate or the central bank’s PTAX rate on the shipment date. The actual BRL outflow is a different number, set by the FX contract rate.

The gap between those two values is the exchange-rate variance on the shipment. A previous post explained how the margin shifts as the exchange rate moves between quoting, invoicing and settlement. In bank reconciliation, the effect is operational: the debit on the BRL account (the FX contract settlement) does not correspond directly to any single invoice, because the bank typically settles multiple contracts in a single batch. The analyst needs to open the FX settlement notice, identify which contracts were settled, link each contract to the carrier’s bill of lading or invoice, and record the exchange-rate variance as a separate line on the shipment.

When the forwarder holds a foreign-currency account abroad (account type 4131, authorized by Brazil’s central bank for foreign trade companies), the problem looks different. Payments leave the USD account directly, with no per-transaction FX contract. The BRL remittance that funds the dollar account happens at different times, and exchange-rate variance accrues on the account balance as a financial result for the company rather than tying to a specific shipment. Reconciling that account requires tracking the USD balance, remittances, payments and the rate on each operation, at a frequency that does not allow backlogs to build.

Late reconciliation pushes the close and hides your cash position

A freight forwarder that reconciles its bank statement once a week works for five days on a balance that may be wrong. Client credits covering invoices from three different shipments sit as “unidentified deposits.” FX debits that paid four carriers sit as “unclassified outflows.” The management system, meanwhile, shows accounts receivable as open and accounts payable as pending, as though none of those payments had happened.

The finance manager then makes payment decisions looking at two sets of numbers that do not talk to each other. The bank balance shows enough cash to pay the carrier; the system shows the client has not paid yet. Or the reverse: the system shows the invoice as paid (because someone wrote it off manually without checking the difference), while the bank shows the credited amount is lower, due to withholding or a partial deposit. Both situations lead to wrong decisions: paying a supplier with cash that belongs to another shipment, or chasing a client who already paid.

The monthly financial close, which already takes ten to fifteen business days at mid-size forwarders, depends directly on bank reconciliation being current. As long as statement entries remain unmatched in the system, the book balance does not agree with the bank balance, and the close cannot finish. Every extra day is a day the owner operates on estimated margin.

Reconciling the hardest items first shortens the cycle

Bank reconciliation time drops when the analyst tackles entries in order of difficulty rather than scrolling through the statement top to bottom.

The first group to resolve is partial and bundled credits. The importer who deposited BRL 47,200 covering three invoices from three shipments needs to be split into three partial write-offs in the system, each for the exact amount. When the forwarder issues a separate payment slip for each invoice, the work shrinks because each credit matches one invoice. When the client bundles payments, the analyst needs the deposit receipt or remittance advice to distribute the amount. Requesting that advice at the time of payment, as a standing procedure, shortens reconciliation by days.

The second group is withholdings. Identifying the type of withholding (income tax, CSLL, PIS, COFINS) and applying it to the right shipment means consulting the original invoice and the tax rules. When the system records the invoice with the taxable base broken out by tax, the analyst compares the credit received with the expected net amount and the system calculates the difference as withholding. Without that breakdown, every invoice becomes a case to solve.

The third group is foreign-currency debits. FX contracts settled in batch need to be opened and linked to shipments. The analyst who does this on the settlement day resolves it in minutes; the one who accumulates it until month-end resolves it in hours, because volume multiplies and context is lost.

What remains after those three groups is exceptions: unidentified credits (deposits with no reference), unexpected bank debits (fees, tax on FX, reversals) and rounding differences of a few cents. Once the first three groups are cleared, that residual is usually less than 5% of entries and resolves quickly.

How Tier2 Cargo links every bank entry to the shipment

Tier2 Cargo records every shipment with its costs and revenues, in multiple currencies, from the quote through settlement. When a client credit hits the bank, the finance team matches the receipt to the invoice inside the system, and Tier2 Cargo automatically calculates whether there is a difference due to withholding, a partial deposit or a bundled payment. The exchange-rate variance between the recorded cost and the actual payment is allocated to the shipment as a separate line, and the realized margin updates accordingly.

The system’s 60-plus reports include aging of open receivables, the accounts receivable and payable position by shipment and by client, and the reconciliation between book balance and bank balance. The finance team that reconciles daily inside the system sees the real cash position at any moment, and month-end close depends only on confirming that every entry in the period is matched.

Learn about Tier2 Cargo or get in touch.

Frequently Asked Questions

What is bank reconciliation at a freight forwarder?

It is the process of matching every credit and debit on the bank statement to the financial records of freight shipments in the system. The analyst verifies that each client credit corresponds to an issued invoice and that each debit corresponds to an authorized payment to a carrier, terminal or overseas agent, accounting for tax withholdings and exchange-rate variances.

How often should a freight forwarder reconcile its bank statement?

Daily. Forwarders that reconcile only at the end of the week or the month accumulate hundreds of pending entries, which delays the financial close and hides the true cash position. Daily reconciliation catches discrepancies on the same day they appear.

Why is the amount received from a client less than the invoice?

In most cases the client withheld taxes at the source under local law. For freight forwarding services in Brazil, withholdings can include income tax, CSLL, PIS and COFINS, totaling up to 6.15% on the taxable service base. The forwarder needs to identify which tax was withheld to record the correct write-off and claim the tax credit.

Bank reconciliation at a freight forwarder is a job of classification and linkage: every dollar or real that enters or leaves the bank must be tied to a shipment, an invoice and a counterparty. Done daily, the month closes in days. Left to pile up, it closes in weeks, and in the meantime the team operates without knowing how much of the cash is actually theirs.