Freight Forwarder Bank Reconciliation: Days Lost

A mid-sized freight forwarder in Brazil handling 300 import and export shipments per month issues 400 to 600 invoices to clients, pays 200 to 400 vendor documents to carriers, port terminals, customs brokers and overseas agents, and collects all of it through bank slips (boletos), instant payments (PIX), wire transfers and foreign exchange remittances. Each payment method shows up on the bank statement in a different format, with different identifiers, in different currencies and on different dates. The finance team spends days each month cross-referencing the statement against the system to figure out who deposited what, why the amount does not match and where the gap is. What should be a verification exercise turns into an investigation.

Every payment method lands on the statement differently

The boleto (a registered bank slip widely used in Brazil) is the most traceable instrument. The bank generates a return file (CNAB 240 or CNAB 400) containing the reference number for each receivable, the payment date and the amount paid. If the forwarder uses this return file for automatic write-offs, reconciliation comes down to handling exceptions: slips paid for the wrong amount, cancelled slips that still appear in the file, and slips from different clients with identical amounts that the system may match incorrectly when the only reconciliation key is the value.

PIX, Brazil’s instant payment system, sped up collections but complicated reconciliation. According to the Central Bank of Brazil, PIX accounted for 55.2% of all payment transactions in the country in H1 2026, up 19.4% year over year. The money hits the account in seconds, which helps cash flow. PIX arrives on the statement with the payer’s name and, when available, a transaction identifier (TxID), but with no reference to the invoice being paid. When an importer pays three invoices at once via PIX and rounds the amount, the finance team receives a single credit and must figure out which invoices it covers. At a forwarder receiving 80 to 150 PIX payments per month from different clients, this identification work is daily and manual.

Domestic wire transfers (TED or TEF) behave like PIX in terms of identification: they land with the sender’s name and originating bank but no invoice reference. The difference is that wires tend to come from larger clients who pay consolidated amounts covering several shipments at once. The finance team receives BRL 87,432.16 from a trading company and must open the client’s email, request the allocation spreadsheet and write off each invoice one by one.

Foreign exchange remittances to pay carriers and overseas agents work on a different logic entirely. The forwarder closes an FX contract with the bank, in BRL, to remit a value in USD. The bank debits the account in BRL at the contract’s exchange rate, which may be the PTAX (the Central Bank’s daily reference rate) or a negotiated rate. The statement shows a debit in reais, the FX contract number and the beneficiary’s name abroad. None of these fields match the carrier’s invoice number or the shipment number in the system. Reconciliation requires an intermediate step: linking the FX contract to the shipment and to the vendor’s document.

The number of entries is a multiple of the number of shipments

A typical ocean import shipment generates, on the revenue side, one to three invoices to the client: freight, local charges and, where applicable, customs clearance or insurance fees. On the cost side, the same shipment generates payments to the carrier, the port terminal, the customs broker and the overseas agent, each with a different due date, currency and payment method. A single shipment can produce six to eight bank entries between inflows and outflows.

At a forwarder processing 300 shipments per month, the number of bank entries that the finance team must reconcile falls between 1,800 and 2,400 per month, counting both revenue and expenses. That number climbs when there are partial payments (the client pays half now and half in 30 days), invoice returns (the invoice is rejected and reissued at a different amount, creating two entries where there should be one), and late-payment interest on overdue slips.

The finance team at a mid-sized forwarder ends up spending three to five business days per month on bank reconciliation alone. The post on the freight forwarder’s month-end close showed that closing the full month typically consumes the first week of the following month. Bank reconciliation is one of the heaviest items on that calendar.

Unidentified payments lock up accounts receivable

The most common case in a forwarder’s reconciliation is a payment that hits the account without enough identification to write off the correct receivable. This happens when an importer pays via PIX without scanning the boleto’s QR code, when a holding company wires funds from its parent entity’s tax ID (different from the importer registered as a client), or when an overseas agent sends a payment with an internal reference that does not match the Brazilian forwarder’s shipment number.

Until the payment is identified, it sits as an unclassified credit in the bank account while the corresponding receivable stays open. The accounts receivable balance in the system shows higher than the clients’ actual debt, and the delinquency report includes receivables that have already been paid but not written off. The forwarder’s owner looks at the report and sees 8% overdue when the real number may be 5%. Any credit decision made on that basis, whether blocking a new shipment or renegotiating terms, starts from the wrong information.

Working with freight forwarders in Brazil, we find that unidentified payments account for 10% to 20% of total collections, depending on the client mix and the payment methods each client uses. Clients who pay by registered boleto generate less identification work. Clients who pay by PIX with rounded amounts or by consolidated wire generate more.

The USD account multiplies the work

A Brazilian freight forwarder operates in at least two currencies: it collects from clients in BRL and pays carriers and overseas agents in USD. Bank reconciliation therefore happens across two accounts, under two sets of rules, with an additional complication: the exchange rate variance between the moment the cost was recorded in the system and the moment the payment left the account.

When the forwarder records a shipment with an ocean freight cost of USD 2,500, the system converts that to BRL at the PTAX on the recording date, say BRL 5.50, resulting in BRL 13,750.00. Weeks later, when the finance team closes the FX contract to pay the carrier, the PTAX may be at BRL 5.62. The debit leaves the account at BRL 14,050.00. The BRL 300.00 difference is FX variance and requires its own accounting entry. If the forwarder has 100 shipments per month with USD costs, that is 100 FX differences to calculate, post and reconcile.

The post on FX variance in freight shipments explained how margin shifts between the quote and settlement. In bank reconciliation, the problem surfaces from a different angle: the BRL statement shows one amount, the system shows another, and the gap must be explained line by line. Without a system that records the exchange rate at each stage (at shipment creation, at invoicing and at settlement), reconciling the USD account becomes a retroactive reconstruction exercise that depends on spreadsheets.

Late boletos with interest break automatic write-offs

When an importer pays a boleto after the due date, the bank adds interest and a penalty to the original amount. A BRL 12,000.00 slip paid five days late, with a 2% penalty and 1% monthly interest (pro rata), arrives on the statement at BRL 12,260.00. The return file shows the amount paid, but the receivable in the system is still BRL 12,000.00. The automatic write-off by exact match fails because the numbers differ.

The finance team must verify that the difference corresponds to the contractual late charges, book the interest income separately (because interest received is financial revenue with its own tax treatment), and write off the original receivable at face value. This work is repetitive and predictable but requires manual intervention for every occurrence. At a forwarder where 15% to 25% of slips are paid late, depending on the client portfolio, the number of slips requiring manual treatment lands between 60 and 150 per month.

Something similar happens in reverse: when the forwarder pays a vendor late and the vendor charges interest on the next invoice, the forwarder must separate freight cost from financial expense so that per-shipment profit is not distorted.

Pending reconciliation delays the month-end close

Every unreconciled bank entry is an accounting open item. The bank statement balance must match the general ledger cash account, which in turn reflects the sum of collections written off in accounts receivable and payments written off in accounts payable. When reconciliation is incomplete, these three balances diverge.

That divergence can take several forms: credits on the statement that have not been matched to any receivable (unidentified payment), debits on the statement that do not correspond to any recorded payment (bank fee, IOF tax on FX contracts, boleto processing fee), or penny differences accumulated over the month from FX rounding. Each of these gaps must be investigated and posted before the month can be closed.

Many forwarders close the month with pending reconciliation items and carry them into the next month. The list grows. After two or three months, the volume of aged items makes retroactive reconciliation far harder because the memory of who paid what has faded. The post on accounts payable described how vendor payment terms set the pace of operations. In reconciliation, the same principle holds: the longer an entry sits unreconciled, the more expensive it becomes to find out what happened.

Daily reconciliation for PIX and wire transfers, and next-day processing for boleto return files, reduces the backlog and lets the month-end close focus on genuine exceptions rather than reconstructing the entire month.

How Tier2 Cargo organizes reconciliation by shipment

Financial entries in Tier2 Cargo are linked to the shipment from the start. Every invoice issued, every cost recorded and every payment received or made is tied to the shipment, the vendor or client, and the original currency. When the bank’s return file enters the system, the write-off matches by the boleto’s reference number, and any difference between the amount paid and the receivable amount is automatically treated as interest, penalty or discount according to the configuration.

For foreign exchange, the system records the rate at three points: at shipment creation, at invoicing and at settlement. The difference between the recorded rate and the actual payment rate generates an FX variance entry linked to the shipment, with no spreadsheet required. The result is that per-shipment profit reflects the real cost, including the FX effect.

See how Tier2 Cargo works or get in touch.

The next step is to measure the problem

Before changing any tool, it is worth measuring: how many bank entries the finance team reconciles per month, how many sit unidentified for more than two business days, and how many pending reconciliation items have accumulated over the past three months. Those three numbers show where the time is going and how much of the delinquency in the report is real.