Skip to content

What commission does each rep earn on this month's loads?

Join Tai invoice history to QuickBooks Online and your commission plan. Pay commission only on loads the books have invoiced, with every rebill applied in the month it's dated.

Open Querri

What you'll need

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

A Tai export, QuickBooks Online and your commission plan: Step 1 says what each adds

Your commission rules: so every rep is paid the same way

Free resources

Start your free trial here →

Sample data sets

Synthetic data for a made-up freight brokerage. Not real shipper data.

Need help?

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

Before we begin

Commission looks like a multiplication. The hard part is the base: which loads count this month, and what happens when a load billed last month is rebilled this one. The TMS knows the loads and the rebills, the accounting system knows what was actually invoiced, and the rates live in a spreadsheet, so the statement usually takes days and still draws questions.

This playbook pays on loads the books confirm, applies each rebill in the month it's dated, and builds a statement per rep that adds up to payroll.

How it works:

  • • Upload the Tai exports and connect QuickBooks
  • • Find the loads first invoiced this month
  • • Apply this month's rebills
  • • Calculate commission at each plan rate
  • • Build a statement for each rep

Follow the steps

Open Querri →
1 Step 1:

Upload the Tai exports and connect QuickBooks

Three sources, one project:

  • •

    Tai load export and invoice history (or your TMS reports): each load's rep and net revenue, and every original invoice and rebill with its date and reason.

  • •

    QuickBooks Online: the invoices the books actually hold, each naming its loads in the memo.

  • •

    Commission plan (Excel): each rep's team and commission rate.

QuickBooks Online connects directly and syncs on a schedule. The Tai exports come in as files; upload next month's over the old ones and every view rebuilds.

Tip: Include six months of invoice history, so each rep's usual month of rebills is there to compare with.

  • Tai loads and invoice history
  • QuickBooks invoices
  • Commission plan
Querri One project
2 Step 2:

Find the loads first invoiced this month

Start with the loads Tai invoiced, then check the books agree:

Prompt

"Which loads were first invoiced in October in Tai, and does QuickBooks have an invoice for each? Hold out any that don't."

Tai first invoiced 2,937 loads in October. 40 of them have no QuickBooks invoice, $9,575 of net revenue. They're held out until the books catch up.

Find the loads first invoiced this month
LoadsCountNet revenue
Invoiced in Tai2,937$700,014
No QuickBooks invoice, held out40$9,575
Confirmed2,897$690,439

Loads first invoiced in October 2026.

3 Step 3:

Apply rebill changes dated in the month

A rebill counts in the month it's dated, whatever month the load was first billed:

Prompt

"Which rebills are dated October, and how does each rep's October rebill change compare with their usual month?"

62 rebills dated October take $12,670 off net revenue. Jordan Vey's three rate corrections, $3,420, are more than twelve times his usual month, and all three are on loads first invoiced in September.

Apply rebill changes dated in the month
RepOctober rebillsOctober changeUsual month
Jordan Vey3-$3,420-$274
Tessa Morrow12-$2,230-$535
Nadia Brook6-$1,620-$444
Grant Ellery4-$1,100-$97
All reps62-$12,670

Rebills dated October 2026, by rep, against the April to September monthly average.

4 Step 4:

Calculate each rep's commission at their plan rate

Confirmed net revenue plus the month's rebills, times each rep's rate:

Prompt

"Work out October commission for each rep: net revenue on confirmed loads plus October rebill changes, times their plan rate."

Commissionable net revenue is $677,769 and commission is $76,386.66: $51,659 for Regional at 12% and $24,728 for National accounts at 10%. Jordan Vey's rebills take $410.40 off his.

Calculate each rep's commission at their plan rate
RepRateCommissionableCommission
Luis Ortega12%$95,351$11,442.10
Tessa Morrow10%$88,723$8,872.29
Theo Barnes12%$63,835$7,660.22
Kendra Hale12%$52,162$6,259.48
Jordan Vey12%$17,943$2,153.16
All 14 reps$677,769$76,386.66

October 2026 commission, four largest and Jordan Vey.

5 Step 5:

Build the commission statement for each rep

Four numbers for payroll, and a statement every rep can check.

The narrative Querri writes:

October commission is $76,386.66. Paying from the Tai invoice report alone would have paid $1,072.39 more, all on loads the books never invoiced.

What you can create or export:

Build the commission statement for each rep
RepCommissionableCommission
Luis Ortega$95,350.85$11,442.10
Tessa Morrow$88,722.94$8,872.29
Grant Ellery$31,126.84$3,112.68
Jordan Vey$17,942.96$2,153.16
All 14 reps$677,768.96$76,386.66

Commission statement, October 2026 (four of 14 reps shown).

Send commission statements that add up the first time.

Try it on your own data
Querri for freight sales See how Querri helps brokerage sales teams put the CRM and the TMS in the same conversation, from rep activity to loads and margin. See Querri for sales

See Querri for the whole brokerage

Tips for a commission run nobody has to redo

Pay on what the books confirm

A load the TMS calls invoiced may not be in the accounting system yet. Pay when both agree, and the held loads pay next month without a correction.

Put rebills in the month they happen

Reopening last month's statement for a rebill makes every number move. Apply the change in the month it's dated and each statement stays closed.

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

Which loads count, when a rebill applies, what each rep's rate is: 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 load earns commission only when it was first invoiced in Tai in the month and QuickBooks has an invoice for it. Save that as a rule for the Tai invoice history."

Or bring the document that already says it

Upload your commission plan document 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:

  • This month's loads: first invoiced in Tai in the month, plus earlier held loads QuickBooks confirms this month
  • Confirmed: a QuickBooks invoice names the load
  • Rebills: counted in the month they're dated
  • Commissionable: original invoice net revenue of confirmed loads plus the month's rebills
  • Rate: from the commission plan, by rep
  • Jordy Vey in Tai is Jordan Vey
Prompt

"Read our commission plan and propose the rules it states about rates, timing, rebills and clawbacks. 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 in sales operations
  • • 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 payday

Every rep gets a statement that ties to payroll, with held loads and rebills shown, not argued about. Changing a rate is a sentence.

Frequently asked questions

Which loads earn commission this month?
Loads first invoiced in Tai during the month that also have a QuickBooks invoice, plus loads held in an earlier month that QuickBooks invoices this month. A load Tai invoiced and QuickBooks hasn't is held until it is.
How are rebills handled?
A rebill changes net revenue in the month it's dated, even when the load was first invoiced earlier. October's 62 rebills come to -$12,670.
What is commissionable net revenue?
Net revenue on confirmed loads plus the month's rebill changes. Customer total less carrier total, from Tai.
Why does Tai say Jordy Vey?
Tai lists Jordan Vey as Jordy Vey. Say once that they're the same person and every commission run uses it, so his loads and rate line up.
What happens to the held-out loads?
They pay commission in the month QuickBooks invoices them. Nothing is lost; it lands in the right month.
Do I need a TMS connector?
No. Upload the Tai exports as files. Upload next month's over the old ones and every view rebuilds. QuickBooks Online connects directly and syncs on a schedule.
Does Querri change anything in QuickBooks or payroll?
No. It reads a copy of the data and never writes back. The statement is yours to send.
How often should this run?
Monthly, after the close, on a schedule. A mid-month run shows each rep where they stand.