Industry

How freight brokers apply shipper payments in QuickBooks

Shippers pay dozens of loads in one ACH, often through a freight payment company. How brokers apply those payments and short pays in QuickBooks.

By RemitClear8 min read

A shipper's payables team pays eighteen loads in one ACH. The remittance arrives separately, lists several of the loads only by the shipper's own references, and two lines are short: a detention charge nobody approved and a fuel surcharge worked out from a different week's diesel price. In QuickBooks that becomes one Receive Payment per customer, recorded against the shipper even when a freight payment company sent the money, with each load ticked at what was actually paid. Until someone does that, every one of those invoices is still open.

Why shipper payments are slow to apply

A brokerage invoices every load separately and gets paid in batches. Shipper payables teams run weekly or monthly payment cycles, so one ACH or check can cover dozens of loads, invoiced weeks apart. The detail of what it covers travels on its own, as an email from the payables team, a PDF or spreadsheet from a supplier portal, or a stub stapled to the check.

The references on a shipper's remittance rarely line up with QuickBooks. Shippers quote what's in their own system: a purchase order, the bill of lading or PRO number, a shipment ID, and sometimes your load number. Larger shippers often hand freight bill audit and payment to a third party too, such as Cass Information Systems or U.S. Bank Freight Payment, so the deposit arrives under the payment company's name rather than the shipper's. Its remittance lists the shipper's references, with an audit code next to any line it adjusted, and nothing on the bank line tells QuickBooks which customer the money belongs to.

Get every remittance to one inbox

Before anything can be applied, someone has to find the remittance. In a brokerage it tends to land wherever an address was typed into a shipper's vendor setup form: the AR mailbox, a sales rep's inbox, or the owner's email from the day the account opened. Portal remittances don't arrive at all until someone logs in and downloads them.

A single AR address fixes most of that. Give it to every shipper as the remittance contact when you update their vendor records, and forward remittance emails from personal inboxes to it. Keep a list of portal logins with the days each shipper usually pays, so the downloads happen on a schedule rather than when a balance starts to look overdue.

Make the load number findable in QuickBooks

Most brokerage TMS platforms push customer invoices into QuickBooks, but they differ on which number lands where. Open one synced invoice and check whether the QuickBooks invoice number is your load number or the TMS's own sequence. Then check whether the load number, PO or bill of lading number appears in the invoice's message or memo field.

  • Invoice number is the load number. A remittance quoting load numbers can be worked straight from the Receive Payment screen, using Find by invoice no.
  • Load number only in a memo field. Each line has to be looked up before it can be applied, which is where most of the time goes.
  • PO kept in a custom field. Receive Payment can't search a custom field, so if shippers quote their PO, carry it into the invoice message as well.

When you raise it with whoever maintains the TMS sync, ask for the load number to be the QuickBooks invoice number, and for the shipper's PO or bill of lading number to go in the invoice message. Every later step depends on finding the invoice a remittance line refers to.

What's different about applying a shipper payment

The mechanics are the ordinary Receive Payment screen, covered step by step in our guide to applying a customer payment to multiple invoices in QuickBooks Online. Three choices on it are specific to brokerage:

  • The customer is the shipper. Record the payment against the shipper and its invoices even when the deposit came from its freight payment company.
  • The shipper's payment number goes in Reference no. It's the number its payables team will ask about if they query a load.
  • The remittance is attached to the payment. Whoever picks up a short-paid load later can see what the shipper said.

Enter the amount received before ticking anything and QuickBooks picks invoices for you, usually the oldest, so clear those and tick the loads the remittance names. A remittance that pays loads billed to more than one of your customers, such as a parent company paying for its divisions, needs a separate payment for each customer, grouped onto one deposit. Our guide to one payment across several customer accounts walks through that case.

Shippers overpay as well: a rebilled invoice paid twice, or a load paid by both the shipper and its payment company. Check that an invoice isn't already paid before applying anything. When the amount received is more than the invoices you apply, QuickBooks keeps the excess on the customer as a credit, which you apply to their next invoice or refund once you've agreed it with them, as the unapplied payments guide explains.

Short pays on accessorials, fuel and audits

Apply what was paid, never the invoice total. The load's invoice stays open for the difference, which keeps it in your AR aging where collections can see it. Then work out why it's short. In freight the usual reasons are an accessorial the shipper didn't approve (detention, layover, a lumper charge, a truck order not used, or TONU), a fuel surcharge calculated from a different week or table, an old rate still sitting in the shipper's system, or an adjustment made by its freight audit company.

Illustrative example. A shipper pays $41,276.40 for eighteen loads. Sixteen match their invoices to the cent. The line for load 1048213 is $185.00 short because detention wasn't approved, and load 1048227 is $64.10 short on fuel surcharge. Enter $41,276.40 as the amount received, apply sixteen invoices in full and the two short loads at what was paid, and $249.10 stays open across those two invoices.

Each reason needs its own evidence. Detention needs arrival and departure times and whatever the rate confirmation says about free time, a lumper charge needs the receipt, and a rate dispute needs the signed rate confirmation. Shipper contracts often set a dispute window, so the claim is easier to win while the load is recent.

A load missing from the remittance altogether is a different problem. It usually means the shipper or its audit company rejected the invoice or never received it, often for a missing proof of delivery, so check its status in their portal before chasing the payment.

Short pays add up over a month, a lumper charge cut on one load and a detention line on another. A weekly look at invoices with small open balances, sorted by shipper, shows which shipper and which charge keeps getting cut, and that's the conversation to have with the shipper's transportation team rather than its payables desk.

Close the balance only once you know what it is. A credit memo coded to an adjustment account keeps the reasons visible in your reports, and your accountant will have a view on which accounts to use. A contested amount stays open. Our guide to short-paid invoices in QuickBooks Online covers the credit memo and write-off steps.

If you run more than one company

Plenty of brokerages sit alongside a trucking company or a warehousing business, and shippers don't always keep the two straight, so a payment for one company's loads can land in the other's bank account. The payment still belongs in the company that issued the invoice, and the cash then has to be settled between the two, usually by a transfer or a due-to and due-from entry your accountant sets up.

Intuit Enterprise Suite puts those companies under one login with consolidated reporting, but a customer payment is still applied in one entity at a time, against that entity's invoices. See how RemitClear works with Intuit Enterprise Suite across entities.

Where RemitClear fits

RemitClear reads the remittance, whether it's a PDF, a spreadsheet or CSV export from a shipper's portal, or the body of an email, and matches each line against your open invoices. Matching handles exact, partial, and prefix-based invoice numbers, and it can find an invoice through the reference in its memo or message field. It then creates the Receive Payment, one per customer, with the remittance attached. Each QuickBooks Online company or Intuit Enterprise Suite entity connects once, under one login, and gets its own forwarding address, so each AR inbox can forward straight to it.

When every line on a remittance matches its own invoice number, the total agrees to the cent and every invoice settles exactly, it can post on its own once you switch automatic posting on. A short-paid load, a line found only through a memo reference or a line this entity's invoices can't settle holds the remittance in the review queue, with the original document beside the match, so a person decides before anything posts. See how it works for freight brokers on QuickBooks.

Frequently asked questions

How do freight brokers record a short-paid load in QuickBooks?

Record the payment on the Receive Payment screen with the amount the shipper actually paid, and apply that amount to the load's invoice so the difference stays open. Then find out why it was short. If you accept the cut, close the balance with a credit memo coded to an adjustment account. If you're disputing it, leave it open and send the shipper the rate confirmation, receipts or detention times.

Can QuickBooks match a shipper payment by load number?

QuickBooks finds invoices on the Receive Payment screen by invoice number. If your TMS uses the load number as the QuickBooks invoice number, a remittance that lists load numbers lines up directly. If the load number is only in the invoice memo, each line has to be looked up first, so ask for the TMS sync to use the load number as the invoice number and put the shipper's PO in the invoice message. RemitClear also reads the invoice memo fields, and a match found that way waits for review rather than posting automatically.

Who is the customer when a freight payment company pays the invoice?

The shipper is still the customer. A freight audit and payment company pays your invoices on the shipper's behalf, so record the payment against the shipper and its invoices in QuickBooks, even though the deposit shows the payment company's name. Keep its remittance with the payment, because any adjustment it made is listed there.

Why is a load missing from a shipper's remittance?

Usually because the shipper or its freight audit company rejected the invoice or never received it, often for a missing proof of delivery. Check the invoice's status in the shipper's portal before chasing the payment.

Does RemitClear work with Intuit Enterprise Suite for a brokerage with several entities?

Yes. Each Intuit Enterprise Suite entity connects to RemitClear on its own, under one login, with its own forwarding address. A remittance is matched against the invoices of the entity it was sent to, and a line it can't settle there waits for review instead of posting.

See It On Your Own Remittances

Bring a shipper remittance to the demo

Send us a remittance from one of your shippers. We'll show its loads matched to your QuickBooks invoices, the short pays held for review, and the payment posted.

We can use example remittances, or yours if you'd like.

We'll use your email to arrange your demo. Privacy Policy

Read verified RemitClear reviews on G2 (opens in a new tab)
See all reviews