Methodology & Reference

TPP Data Standards Guide

How TCA Profitability Program members submit data — raw general ledger detail in, every allocation and distribution handled in MapLedger, all mapping managed by KSM Transport Advisors so every member's results are built on the same definitions.

Data Standard GuideTCA Profitability ProgramStandard Chart of Accounts685 accounts

Truckload Carriers AssociationTCA Profitability ProgramData collection & mapping powered byMapLedger

Administered by KSM Transport Advisors on behalf of the Truckload Carriers Association.

The TCA Profitability Program compares members to each other and to themselves, month after month. That only works if every member's numbers mean the same thing. This guide is the reference for how TPP data is submitted, mapped and allocated: your general ledger is translated into the TPP Standard Chart of Accounts inside MapLedger, where every standard account carries three pieces of information at once — what the dollar is (account category), how the freight moved (operating group), and who performed the work (labor / capacity group).

Standard Accounts
685
Operating Groups
5
Labor Groups
7
Account Categories
27

Raw GL Data Is the Standard

The single most important rule in this guide.

Send your general ledger exactly as it stands.

Raw, unaltered GL data is the preferred — and expected — method of reporting for TPP. Submit the full trial balance at your own account level, every month, in the same format each month. Do not pre-allocate, pre-split, summarize, reclassify or restate anything to fit the standard. Every allocation and distribution is handled in MapLedger, after the data arrives.

This is deliberate. When members adjust their own data before sending it, two things break at once: the submission no longer ties to the financial statements it came from, and no two members are doing the arithmetic the same way. Keeping the raw ledger as the single source of truth means every number in TPP can be traced back to a specific GL account in a specific month — and every transformation applied on the way to a result is a visible, documented rule rather than an assumption buried in a spreadsheet.

Your raw GLTMS operational statsMapLedger mappingAllocation & distributionTPP results & benchmarks

What to send

  • Full trial balance at your own GL account level — every account, including zero-balance accounts
  • Account number and account description, unchanged month to month
  • Monthly net activity (not year-to-date), for every period in the program year
  • Balance sheet accounts as well as P&L — they support accrual and prepaid review
  • Operational statistics from your TMS (see below), not hand-keyed summaries
  • A new export each month in the same layout, so the mapping keeps working

What not to do

  • Do not allocate costs across divisions, fleets or capacity types before sending
  • Do not split a single GL account into pieces — MapLedger does that, by rule
  • Do not roll accounts up into categories or map them to the standard yourself
  • Do not restate prior months to smooth a result; use a documented MapLedger adjustment instead
  • Do not rename or renumber accounts mid-year without telling us — it breaks the mapping
  • Do not exclude accounts you think are irrelevant; let the mapping decide
Why the raw ledger wins

A mapped raw ledger can always be re-run — a new allocation driver, a corrected rule, or a restated operating group can be applied to every historical month at once. Pre-allocated data cannot be unwound. Once the split is baked into the submission, the detail behind it is gone for good.

KSM Transport Advisors Manages the Mapping

Members do not map their own accounts. KSM Transport Advisors builds and maintains every mapping assignment and every allocation rule in MapLedger on your behalf, and reviews them each period as part of administering the program. That is what makes the data credible: the standard is applied the same way, by the same team, across every member in the peer group.

  1. 1

    You submit the raw ledger and TMS extracts

    The same export each month. Your work ends when the file is delivered.

  2. 2

    KSMTA maps every account to the TPP standard

    Each of your GL accounts is assigned to a standard account — category, operating group and labor group — using the mapping guidance published in the account listings below.

  3. 3

    KSMTA builds and documents the allocation rules

    Where an account spans capacity types or operating modes, we define the allocation method and the driver behind it. Every rule is recorded, named, and reviewable.

  4. 4

    You review and confirm

    Mappings and allocation rules are walked through with your team before results are published. Questions, exceptions and corrections come back to us — not into the source data.

  5. 5

    Results are produced and benchmarked

    Mapped, allocated results flow into TPP reporting and the FreightMarks benchmark ranges, where like-for-like comparison depends on everyone being mapped to the same definitions.

Operational Statistics from Your TMS

Financial data alone cannot be allocated. Splitting a shared account between Company Fleet and Owner Operator, or between OTR and Dedicated, requires a measure of how much work each group actually did in that month. Those measures are the 9xxx statistical accounts in the standard chart of accounts — and we pull them straight from your TMS, from the same order and segment extracts that feed FreightMath.

That matters because hand-keyed statistics are the weakest link in most benchmarking programs: they are estimated, submitted late, rounded, and impossible to audit. A TMS extract is none of those things. It is load-level, it is reproducible, and it can be sliced by capacity type and operating group exactly the way the allocation needs it.

9xxx

Miles

Total miles driven, empty miles, and total costing miles — by capacity type and operating group. The primary driver for variable cost allocation.

9xxx

Load & stop counts

Load count by operating group. The per-load denominator for brokerage and accessorial benchmarks, where per-mile means little.

9xxx

Equipment counts

Tractor and trailer counts, both plated and observed in operation, by capacity type — the driver behind fixed equipment and insurance allocation.

9xxx

Headcount

Driver, non-driver and maintenance technician counts — active, observed and departed — supporting per-head cost ratios and turnover measures.

9xxx

Hours under power

Tractor hours derived from segment timestamps. The driver used to distribute overhead to the work that actually consumed it.

9xxx

Terminals & other

Terminal count, excess insurance policy limits, and other structural measures used to normalize facility and insurance costs.

Already a FreightMath client?
The TMS order and segment extracts that feed the Segment Level Costing engine supply the same statistics TPP needs. There is no second data pull and no separate statistics worksheet to maintain.

Three-Segment Account Numbering

Every account in the TPP Standard Chart of Accounts uses a three-segment numbering convention. This structure enables precise cost allocation by simultaneously capturing the nature of the account, the operating mode, and the capacity type responsible.

Segment 1

Account Category

Identifies the financial nature of the account: revenue type, expense category, asset class, or statistical metric.

4xxx Revenue5xxx Direct Operating6xxx Equipment & Insurance7xxx Overhead9xxx Statistics
Segment 2

Operating Group

Identifies the operating mode or division. Enables segmented P&L and benchmarking by service type.

100 OTR200 Local300 Dedicated400 Brokerage000 General
Segment 3

Labor / Capacity Group

Identifies the capacity type responsible for the revenue or cost. Critical for separating asset-based and non-asset economics.

100 Company Driver200 Owner Operator300 Lease Purchase400 Brokerage500 Non Driver600 Maintenance000 General

Two Dimensions of Segmentation

The standard COA segments financial data along two independent axes. Together, they create a matrix that isolates profitability at the intersection of how you operate and who is performing the work.

Capacity Types (Labor Groups)

Who operates the equipment and delivers the freight.

Segment 3: 100

Company Driver

Company-owned equipment operated by employed drivers. Full cost visibility across wages, fuel, maintenance, and equipment.

Segment 3: 200

Owner Operator

Independent contractors providing their own tractor. Costs primarily flow through Purchased Transportation settlements.

Segment 3: 300

Lease Purchase

Operators leasing equipment through the carrier's lease-purchase program. Hybrid cost profile between Company and OO.

Segment 3: 400

Brokerage

Non-asset freight moved through third-party carriers. Revenue and purchased transportation captured separately from asset operations.

Operating Groups (Modes)

How the freight is moved — the service type and operating model.

Segment 2: 100

OTR (Over-the-Road)

Long-haul, irregular route freight operations. Typically the largest revenue segment for truckload carriers.

Segment 2: 200

Local

Short-haul and regional operations. Higher stop frequency, lower miles per load, different cost dynamics.

Segment 2: 300

Dedicated

Contract-dedicated fleet operations for specific customers. Predictable revenue, distinct equipment and driver pools.

Segment 2: 400

Brokerage

Non-asset logistics and freight brokerage. Measured per load rather than per mile.

How GL Accounts Are Mapped

Direct first, ratio second, percentage last.

Every one of your GL accounts is assigned to a standard account in MapLedger. Where your ledger already separates revenue and expense by capacity type and operating mode, that assignment is one-to-one and nothing is allocated at all. Where a single account spans more than one group, MapLedger applies a secondary allocation method to distribute the value. The three methods are applied in strict order of preference.

Preferred

Direct Allocation (1:1)

One GL account maps to exactly one standard account. Nothing is split, estimated or spread — the dollar lands where it belongs because the ledger already said so. This is the preferred method and the goal for every account we can get there.

Example: A GL account for Owner Operator Settlements — OTR maps directly to 5200-100-200. No driver, no percentage, no assumption.

Where your chart of accounts does not yet separate capacity type or operating group, adding that detail in your own GL is the single highest-value change you can make — it converts an allocated number into a direct one.

When direct is not possible

Ratio Allocation

Distributes an account dynamically using operational statistics recorded by capacity type or operating group — such as dispatch miles or tractor counts, taken from your TMS. The split recalculates every month from actual operating data.

Example: A single Linehaul Revenue — Trucking account is split between Company Fleet and Owner Operator in proportion to each group's share of dispatch miles for the period.

Last resort

Percentage Allocation

Applies a fixed percentage split to an account each month. Used only when no operating statistic is available and the cost does not correlate to a measurable driver.

Example: Workers Compensation expense that is not split in the GL is allocated 90% to Drivers and 10% to Non-Drivers / Maintenance personnel.

MethodPreferenceWhat drives the splitRecalculates monthlyUse when
Direct (1:1)PreferredNothing — no splitn/aYour GL already separates capacity type and operating group
RatioSecondTMS operational statistics (miles, loads, counts, hours)YesOne account spans groups and a measurable driver exists
PercentageLast resortA fixed, documented percentageNoNo statistic correlates to the cost
Allocation methods in order of preference. KSMTA selects and documents the method for every account that needs one.
Allocation happens in MapLedger — never in your submission

If your GL cannot separate a cost, send it unsplit. A ratio or percentage rule applied in MapLedger is visible, named, reviewable and re-runnable across every historical month. The same split applied inside a submission is invisible, unrepeatable, and impossible to audit.

Standard Account Listings

All 685 accounts grouped by sub-category with full segmentation detail. Use the search and filters to find specific accounts, or expand groups to browse. Groups that carry mapping guidance show what to map into them, what to keep out, and how the group is segmented. This is the reference KSMTA works from when mapping your ledger — members are welcome to read along, but no action is required here.

Cost typeRevenueVariableOverheadBalance SheetMetricOperating groupOTRLocalDedicatedBrokerageGeneral
685 of 685 accounts

Revenue

4xxx accounts — linehaul, fuel surcharge, accessorial, and other operating revenue.

All base revenue per mile, per load, order, shipment or flat rate.

Map These Expenses / Items → Target Accounts
  • Base linehaul revenue (per mile, per load, per order, flat rate)
    4000-100-100Linehaul Revenue - OTR - Company Driver
    4000-100-200Linehaul Revenue - OTR - Owner Operator
    4000-100-300Linehaul Revenue - OTR - Lease Purchase
    4000-200-100Linehaul Revenue - Local - Company Driver
    4000-200-200Linehaul Revenue - Local - Owner Operator
    4000-200-300Linehaul Revenue - Local - Lease Purchase
    4000-300-100Linehaul Revenue - Dedicated - Company Driver
    4000-300-200Linehaul Revenue - Dedicated - Owner Operator
    4000-300-300Linehaul Revenue - Dedicated - Lease Purchase
    4000-400-400Brokerage Revenue - Gross
Do Not Map Here
  • Fuel Surcharge Revenue
  • Accessorial Revenue

Segmented By: Capacity Type (Company Fleet, Owner Operator, Lease Purchase, Brokerage) and Operating Group (OTR, Local, Dedicated)

Account #DescriptionOperating GroupLabor GroupCost Type
4000-100-100Linehaul Revenue - OTR - Company DriverOTRCompany DriverRevenue
4000-100-200Linehaul Revenue - OTR - Owner OperatorOTROwner OperatorRevenue
4000-100-300Linehaul Revenue - OTR - Lease PurchaseOTRLease PurchaseRevenue
4000-200-100Linehaul Revenue - Local - Company DriverLocalCompany DriverRevenue
4000-200-200Linehaul Revenue - Local - Owner OperatorLocalOwner OperatorRevenue
4000-200-300Linehaul Revenue - Local - Lease PurchaseLocalLease PurchaseRevenue
4000-300-100Linehaul Revenue - Dedicated - Company DriverDedicatedCompany DriverRevenue
4000-300-200Linehaul Revenue - Dedicated - Owner OperatorDedicatedOwner OperatorRevenue
4000-300-300Linehaul Revenue - Dedicated - Lease PurchaseDedicatedLease PurchaseRevenue
4000-400-400Brokerage Revenue - GrossBrokerageBrokerageRevenue

Expenses

5xxx–7xxx accounts — direct operating (variable), equipment and insurance, and overhead, plus non-operating items.

Balance Sheet

1xxx–3xxx accounts — assets, liabilities, and equity.

Statistics

9xxx accounts — operating metrics (miles, loads, counts) that drive ratio allocation and per-unit benchmarks.

Spreading Large, Infrequent Costs

TPP compares members month by month. When a large annual or semi-annual cost is expensed in the single month it was paid — instead of being prepaid and amortized, or accrued — that month's operating ratio spikes and the other eleven look better than they really are. MapLedger Adjustments spread those costs across the months they actually cover, without changing the GL data you submitted.

Accruals come first

The best fix is in your own books: record annual payments to a prepaid account (for example 1105-000-000 Prepaid Insurance or 1110-000-000 Prepaid Licenses & Permits) and amortize them monthly, or accrue known costs as they are incurred. Adjustments are used only where that has not been done — for historical periods, or for costs your accounting system expenses when paid.

Common candidates for adjustment

Costs that are often paid once or twice a year but benefit every month of the period.

CostTypical patternStandard accounts
Insurance premiums & down paymentsAnnual or semi-annual premium, policy audits and true-ups6000 · 6005 · 6010 · 6020 · 7215
Workers compensation auditsYear-end audit premium adjustment5080 · 5310 · 6030
Plate / IRP licensingAnnual fleet renewal in one month6170
Heavy Vehicle Use Tax (Form 2290)Paid annually; covers July – June6200
UCR & operating authorityAnnual registration6180 · 6190
Property taxesAnnual or semi-annual bill7050
Audit & tax preparation feesBilled once a year7320
Annual software licenses & subscriptionsPaid upfront for 12 months6310 · 6315 · 7360
Annual retention or safety bonusesPaid once, earned all year6250
Year-end depreciation catch-upsFull-year true-up booked in month 126110 · 6140 · 7385 – 7405

Two ways to adjust

Rules are saved per entity and re-applied automatically every month they are in effect. KSMTA creates and documents them; members raise the need and review the result.

Recommended for a known amount

Manual Rule

Applies an explicit amount to a source account for each month between a Start month and an optional Expiration month.

  • Delta adds to or subtracts from the raw GL value.
  • Override replaces the raw value entirely — only used when the account holds nothing but the cost being spread.
  • Notes are required. What the cost is and why it is being spread, so TCA and KSMTA reviewers can follow it.
For recurring patterns across history

Auto-Variance Rule

Detects month-over-month spikes and smooths them automatically using threshold bands.

  • Centered moving average (recommended) replaces each month with the average of a window centered on it — a 12-month window is 6 back + current + 5 forward. This is how an annual amount is amortized evenly.
  • Spike redistribution (advanced) shaves spikes toward a trailing baseline — prior month, prior 3- or 6-month average, or same month last year — and spreads the excess across the band window.
  • Each band sets a Min / Max swing (in % or $), a Spread in months, and how many months fall Before and After the spike. Bands are checked top to bottom; the first match wins.

Worked example: annual plate renewal

A member pays a $72,000 IRP renewal in January 2026 and expenses it to 6170-100-000 Licensing - OTR. Two manual Delta rules spread it evenly at $6,000 per month and net to zero for the year.

Rule 1IRP renewal 2026 — remove from January

Manual · Delta · −66,000 · Jan 2026 – Jan 2026 · source 6170-100-000

Rule 2IRP renewal 2026 — spread Feb – Dec

Manual · Delta · +6,000 · Feb 2026 – Dec 2026 · source 6170-100-000

Check: −66,000 + (11 × 6,000) = 0 · Annual total still ties to the GL: $72,000

Licensing expense by month: raw GL shows $72,000 in January and $0 in every other month; adjusted in MapLedger shows $6,000 every month.$0k$20k$40k$60k$80kJFMAMJJASOND$72k$6k every month
Raw GL Adjusted in MapLedger

Good practice

  • Spread over the period the cost actually covers — HVUT over July – June, not the calendar year
  • Design manual rules to net to zero across the period so annual totals still tie to the financial statements
  • Name rules clearly (cost, year, action) and scope them to the specific source accounts involved
  • Review raw vs. adjusted values and the effect on operating ratio before relying on the results
  • Set an expiration month so a one-year spread does not carry into the next year

Do not adjust

  • True seasonality — winter fuel, peak-season volume, weather-driven maintenance
  • Revenue or statistical accounts (miles, loads, counts)
  • Costs already prepaid and amortized, or accrued, in the GL
  • Claims and accident events, to make a month look better
Important notes

Adjustments never change your imported GL data. MapLedger keeps the raw value and the adjusted value side by side, and shows a notice while adjusted values are recalculating after a rule is saved.

With a centered moving average, the most recent months have no forward months yet, so the window is shorter at the edge of the data. Those months update as new months load — a manual rule is the right choice when a fixed, final spread is needed.

Not sure whether a cost should be adjusted? Raise it with the KSM Transport Advisors TPP team rather than changing the submission.

Industry Performance Ranges

Reference ranges for key cost and revenue metrics across the truckload industry, derived from the FreightMarks carrier database maintained by KSM Transport Advisors and expressed per mile and as a percentage of total revenue. Use them as a reasonableness check — a result well outside a range usually points to a mapping or timing issue rather than a performance one.

FreightMarks

Driver Compensation — Company Fleet

MetricRange
Driver Wages per Mile$0.42 – $0.91
Driver Wages % of Revenue23% – 42%
Benefits & Payroll Tax per Mile$0.06 – $0.18
Benefits & Payroll Tax % of Rev2.0% – 17%
FreightMarks

Purchased Transportation

MetricRange
Owner Operator per Mile$1.40 – $2.10
Owner Operator % of Revenue63% – 85%
Lease Purchase per Mile$1.00 – $1.60
Lease Purchase % of Revenue51% – 70%
OO Benefits & Incentives per Mile$0.02 – $0.09
FreightMarks

Fuel Expense

MetricRange
Company Fleet per Mile$0.30 – $0.55
Company Fleet % of Revenue15% – 25%
Reefer Fuel per Total Mile$0.01 – $0.04
FreightMarks

Maintenance

MetricRange
Tractor — Company Fleet per Mile$0.11 – $0.26
Tractor — CF % of Revenue2.5% – 10%
Trailer per Mile$0.02 – $0.50
Wages & Overhead per Mile$0.02 – $0.50
FreightMarks

Equipment & Insurance

MetricRange
Tractor Fixed per Mile$0.31 – $0.48
Tractor Fixed % of Revenue15% – 28%
Trailer Fixed per Mile$0.02 – $0.50
Insurance — CF per Mile$0.04 – $0.21
Insurance — CF % of Revenue3% – 7.9%
FreightMarks

General & Overhead

MetricRange
Non-Driver Wages per Mile$0.12 – $0.19
Non-Driver Wages % of Revenue4% – 10%
Fixed Overhead per Mile$0.12 – $0.19
Fixed Overhead % of Revenue4% – 10%
Variable Driving per Mile$0.01 – $0.03
FreightMarks

Brokerage

MetricRange
Insurance per Load$10 – $43
Insurance % of Revenue1% – 2.5%
Non-Driver Wages per Load$50 – $100
Non-Driver Wages % of Revenue4% – 10%
Fixed Overhead per Load$50 – $100
FreightMarks

Tolls, Agents, Recruiting & Other

MetricRange
Toll Expense per Mile$0.002 – $0.02
Agent Commissions per Mile$0.002 – $0.02
Recruiting & Retention per Mile$0.002 – $0.02
Lumper / Load-Unload per Mile$0.002 – $0.02
Permits & Escorts per Mile$0.002 – $0.02
Related references
Terms used throughout this standard are defined in the FreightMath Glossary. The carrier-facing version of this standard — 550 accounts, without the TPP survey extensions — is the MapLedger Data Standard.

TPP Data Standards Guide · TCA Profitability Program℠ is a service mark of the Truckload Carriers Association · Data collection and mapping powered by MapLedger, administered by KSM Transport Advisors.