Skip to content

Which shippers are paying slower than they used to?

Join QuickBooks Online receivables to your Tai load export. See each shipper's days to pay against its own pattern, and what its short pays were billed for.

Open Querri

What you'll need

Querri (Free trial) to join the exports and run the checks

QuickBooks Online and a Tai load export: Step 1 says what each adds

Your collections rules: so every shipper is measured the same way

Need help?

If you have any questions, you can request a demo or email our team.

Before we begin

The aging report tells you how old the money is. It takes more work to see who has changed. A large shipper can slow down by two weeks while nearly all of its balance still sits in Current. The payments are in QuickBooks and the loads behind them are in the TMS, so connecting a slower shipper to the charges it is holding back has meant exports, lookups and a lot of patience.

This playbook ages the receivables, compares every shipper's days to pay with its own history, and matches each short pay to the load it was billed for.

How it works:

  • • Upload the Tai export and connect QuickBooks
  • • Age receivables and list short pays
  • • Compare each shipper with its own pattern
  • • See what the short pays were billed for
  • • Build the weekly receivables view

Follow the steps

Open Querri →
1 Step 1:

Upload the Tai export and connect QuickBooks

Two systems, one project:

  • •

    QuickBooks Online: invoices, payments, credit memos, the A/R Aging Detail and each customer's terms.

  • •

    Tai load export (or your TMS load report): the load behind each invoice: lane, line haul, fuel and every accessorial charge.

QuickBooks Online connects directly and syncs on a schedule. The Tai export comes in as a file; upload next week's over the old one and every view rebuilds.

Tip: Pull at least 15 months of invoices and payments, so every shipper has a full year of history to compare against.

  • QuickBooks receivables
  • Tai load export
Querri One project
2 Step 2:

Age open receivables and list short-paid invoices

Start where the collections meeting starts, then find the invoices paid but not in full:

Prompt

"Age our open receivables as of November 1 and work out DSO. Then list the invoices shippers paid in October but not in full, once counting every cent and once ignoring differences of $50 or less."

DSO is 42 days and 92% of the money is current or under 30 days late. The aging looks calm. The $50 rule cuts October's short pays from 35 to 22.

Age open receivables and list short-paid invoices
Aging bucketInvoicesOpen
Current2,938$4,940,130
1 to 30 days842$1,418,322
31 to 90 days251$407,792
Over 90 days136$151,539
Total4,167$6,917,783

Open receivables on November 1, 2026, by aging bucket.

3 Step 3:

Compare each shipper's days to pay with its own pattern

Hold every shipper against its own last 12 months, not against the company average:

Prompt

"For every shipper with at least 20 invoices paid in October, compare October's average days to pay with its own average over the 12 months before. Flag anyone 5 or more days slower."

The company barely moved, 41.2 days to 41.7. Three shippers are 5 or more days slower. Tarrowby Foods is 14 days slower and owes the most, almost all of it still current.

Compare each shipper's days to pay with its own pattern
ShipperUsualOctoberChange
Tarrowby Foods43.657.6+14.0
Lindham Merchandise38.549.4+10.9
Quincrest Retail Group38.043.7+5.7
Company41.241.7+0.5

Average days to pay, invoices closed in October 2026 against the 12 months before.

4 Step 4:

See what the short-paid dollars were billed for

Follow each short pay to its load through the load number on the invoice:

Prompt

"Match every open short pay over $50 to its Tai load through the load number on the invoice. Which charge does the missing amount equal: line haul, fuel, detention or lumper?"

13 of Tarrowby's 14 short pays equal the detention charge on the load, to the cent, all on Fresno to Denver. No other shipper's short pays match detention.

See what the short-paid dollars were billed for
ShipperShort paysOpenEqual to detention
Tarrowby Foods14$3,75313
Pellham Home Goods5$1,8450
Hollstead Farms3$7630
All shippers38$11,50913

Open short pays over $50 on November 1, 2026, from every payment month.

5 Step 5:

Build the weekly receivables view for the controller

Four numbers for Monday, and the calls to make first.

The narrative Querri writes:

Receivables look steady in total, but the largest balance belongs to a shipper that has slowed by two weeks and is short paying the detention billed on one lane.

What you can create or export:

  • The call list, to Excel, CSV or Google Sheets
  • A live dashboard that refreshes with each QuickBooks sync
  • A presentation for the weekly finance meeting, to PDF or PowerPoint
Build the weekly receivables view for the controller
ShipperDays to payOpen
Tarrowby Foods57.6 (usual 43.6)$498,670
Lindham Merchandise49.4 (usual 38.5)$25,531
Quincrest Retail Group43.7 (usual 38.0)$22,647

The call list, week of November 2, 2026.

See which shippers have changed before their invoices reach 60 days.

Try it on your own data
Querri for logistics finance See how Querri helps brokerage finance teams follow every load from delivered to paid, on numbers the TMS and the books agree on. See Querri for finance

See Querri for the whole brokerage

Tips for a collections call that starts with the facts

Measure each shipper against itself

The company's average days to pay moved half a day. One shipper moved 14. Compare every account with its own history and the change stands out weeks before the aging does.

Match short pays by load, not by name

The load number on the invoice ties QuickBooks to the TMS even when the customer names differ. Then the short pay tells you which charge is in dispute.

Teach Querri your rules once. Every answer after that follows them.

What counts as a short pay, how days to pay is measured, what slower means: say each rule once and Querri applies it to every question on that data.

Show me how

Say it in chat

Settle a rule in conversation and the Librarian records it as a fact under Facts & Rules, attached to the table it governs. Every later question on that data applies it, whoever asks, and every view built afterwards carries it.

Prompt

"A short pay is an invoice with a payment applied and more than $50 still open. Save that as a rule for the QuickBooks invoices table."

Or bring the document that already says it

Upload your credit and collections policy like any other file. Querri files a From a document card in the Inbox with the statements it found, each with its page and exact words; tick the ones to keep and they become facts. The rules this playbook depends on:

  • Short pay: a payment applied and more than $50 still open
  • Days to pay: invoice date to the last payment or credit memo that closed it
  • Usual pace: the shipper's own average over the prior 12 months
  • Paying slower: 5 or more days above the usual pace, with 20 or more payments
  • DSO: open receivables over the last 12 months of invoicing, times 365
  • Matching: QuickBooks to Tai through the load number in the invoice memo
Prompt

"Read our credit and collections policy and propose the rules it states about payment terms, short pays and when an account goes on hold. I'll review them in the Inbox."

Where the rules reach

A rule is attached to the data, not to one person's chat, so it follows the data everywhere:

  • • Every question asked in chat, by anyone on the accounting team
  • • Every view the Librarian builds on that data
  • • Every step of a project, including the code it writes
  • • Dashboards and scheduled runs, each time they refresh
  • • Claude and ChatGPT, when they ask Querri

You stay in control

Every rule is listed under Facts & Rules next to the data it governs, where you can edit or remove it. Rules from a document wait for your tick in the Inbox, and a Worth remembering card is how Querri offers one it noticed itself. Workspaces and roles decide who can change what. Company-wide rules go in Settings → Customize; the Library is where the rest lives.

The payoff on Monday

The collections call starts with the shipper that changed, the lane, and the charge in question. Changing the $50 rule is a sentence.

Frequently asked questions

What counts as a short pay?
An invoice with at least one payment applied and money still open. At a $0 tolerance, October has 35. Ignore differences of $50 or less and it's 22, the ones worth a call.
How is days to pay measured?
From the invoice date to the last payment or credit memo that closed it, counted in the month it closed. Open invoices don't count yet, so a shipper that stops paying shows up in aging first and here once it pays.
Why compare a shipper with itself?
Because terms and habits differ. A shipper on Net 45 that always pays in 44 days is fine at 44. The same shipper at 57 has changed, even though most of its balance is still current.
Why only shippers with 20 or more October payments?
A handful of payments can swing an average by a week. Twenty keeps the comparison steady. Change the threshold in one sentence if your book is smaller.
How do QuickBooks invoices match Tai loads?
Through the load number in the invoice memo, not the customer name. About 14% of customer names are spelled differently in the two systems, so a name match would drop shippers without saying so. Here all 38 short pays matched a load.
Does a slower shipper mean a dispute?
Not on its own. Here the short pays line up with detention on one lane, which is a good reason to call. Lindham Merchandise is slower too, with no short pays at all, so that call is about pace.
Do I need a TMS connector?
No. Upload the Tai load export as a file. Upload next week's export over the old one and every view built on it rebuilds. QuickBooks Online connects directly and syncs on a schedule.
Does Querri change anything in QuickBooks?
No. It reads a copy of the data and never writes back to your books.
How often should this run?
Weekly, before the collections meeting, on a schedule. A shipper that slows down shows up the week it happens, not when its invoices reach 60 days.