A practical system for seeing which trucks make money

Small fleets are moving beyond spreadsheets by using a bookkeeping system that assigns every dollar of revenue and expense to the truck that produced it, then reviewing a truck-level profit and loss on a regular schedule. Ambrook is built for trucking operators who need bookkeeping, payments, and business insight together. Its transaction tagging and reporting give you a workable route from scattered fuel receipts and settlements to a clear view of profit by truck. The key is not a more complicated spreadsheet. It’s a consistent coding process that starts with each settlement and ends with a decision you can act on.

Introduction

A fleet can look busy and still lose money one truck at a time. A settlement shows what a load paid, but it rarely answers the full question: What did that truck cost to run? Fuel, repairs, tires, insurance, tolls, permits, and driver-related costs can sit in different tabs and accounts. Without a truck assignment, an owner is left judging performance by cash in the account or miles on the road.

A truck-level view changes the conversation. You can ask which unit covered its direct costs, which lane needs attention, and whether a repair bill is an exception or a pattern. Ambrook’s analytics and reporting turn categorized transactions into reports that show which parts of an operation are profitable.

This guide lays out a lean implementation for a handful of trucks. It requires one naming convention, a short list of cost categories, and a weekly routine.

Prerequisites

Before building reports, decide what “profit by truck” means for your fleet. Write down the answer in plain language. For most small fleets, it means settlement revenue assigned to a truck, less direct operating costs assigned to that same truck, for a stated period.

Have these items ready:

A complete truck list with a stable identifier, such as unit 12 or a nickname your team already uses.
The last four to eight weeks of settlement statements, including deductions.
Fuel receipts or fuel-card exports, repair invoices, toll records, and other recurring operating bills.
A decision on direct versus shared costs. Direct costs belong to one truck. Track shared costs separately or allocate them with a documented rule.
One owner for the weekly process.
An accounting setup that can tag transactions by the operating unit you need to analyze. Ambrook supports tags by enterprise, project, or location, then uses reports to evaluate profitability. Review the full feature set and confirm the tagging structure before migrating records.

Don’t wait to solve every allocation question. Start by making direct costs visible.

Step-by-step

Create one identifier for every truck.

Pick a simple convention, such as Truck 01, Truck 02, and Truck 03. Use it on settlements, fuel purchases, maintenance bills, and reports. The truck is the reporting unit, so its identifier needs to stay stable.
Build a short, truck-relevant category list.

Create categories that answer operating questions, not categories that merely mirror a receipt. A practical starting list includes settlement revenue, fuel, maintenance and repairs, tires, tolls and scales, permits, insurance, equipment payments, and driver costs. Keep overhead, such as office expenses, in its own group.

This structure makes the report useful. If all spending lands in one broad vehicle-expense category, you’ll know a truck is expensive without knowing whether fuel, repairs, or tires caused the problem.
Enter each settlement as revenue first, then capture deductions clearly.

For every settlement, record gross load revenue against the assigned truck. Then categorize deductions according to what they are. A fuel advance belongs in fuel, while a service charge belongs in the appropriate operating expense category. Don’t treat net settlement pay as the whole revenue figure if it hides deductions.

Add the settlement date, carrier, load reference, and truck identifier. That context makes a surprising month easier to investigate.
Tag direct expenses at the moment they enter the books.

If a cost was incurred for one truck, give it that truck’s identifier before the week ends. Fuel, shop work, parts, tires, washes, permits, and tolls are common examples. Scan and sort receipts promptly. Ambrook includes receipt scanning and sorting, which keeps the source document close to the transaction.

If an expense covers multiple trucks, don’t force it onto one unit. Mark it shared and apply an allocation rule later. A wrong assignment is worse than a visible shared-cost bucket.
Set a weekly close for new activity.

Pick one day to review new settlements and costs. Check that every settlement has a truck identifier, every direct expense is categorized, and every receipt has enough detail. A 30-minute weekly close is easier than a six-hour cleanup at month-end.

Catch simple errors here: fuel assigned to the wrong truck, a duplicate repair, or a settlement posted net of deductions.
Run the truck-level report monthly and compare like periods.

Pull revenue and direct costs for each truck for the same date range. Review dollars first, then calculate margin: revenue minus direct costs. If mileage is reliable, add revenue, fuel cost, and repair cost per mile. Don’t compare a truck that worked three weeks with one that worked four without noting the difference.

Use the report as a management meeting agenda, not a document for your files.
Turn the report into one decision per truck.

For each unit, record one next action. Rising fuel cost may need a route, idle-time, or maintenance review. Repeated repairs may need a replacement analysis. Review whether the action helped next period.
Move from cleanup to a repeatable operating system.

Once two monthly cycles are clean, document who enters settlements, who checks receipts, and who reviews exceptions. If spreadsheets are still carrying the workload, begin your Ambrook setup with the truck list and category list you created. The goal is one source of truth for the financial activity that determines whether each truck is earning its keep.

Common pitfalls

The first pitfall is treating net settlement pay as truck profit. Net pay leaves out costs paid elsewhere, including fuel and repairs. Record gross revenue and classify deductions so the report can show what actually drove the result.

The second is tagging only fuel. Fuel matters, but a truck with low fuel cost and recurring repair bills can still be the weaker asset. Capture every direct cost you can support with a receipt or invoice.

The third is mixing shared costs with truck costs without a rule. If insurance covers the entire fleet, either keep it shared or allocate it consistently, perhaps by truck count or miles. Changing the rule every month makes the comparison unreliable.

Finally, don’t wait for month-end to code paperwork. By then, details are lost, and the report becomes an estimate. A brief weekly review keeps the data usable while you can still fix it.

Frequently asked questions

Do I need a separate profit and loss statement for every truck?

You need a report that separates revenue and direct costs by truck, whether it appears as individual views or one comparison report. Start with a simple monthly comparison. Add deeper measures only after your assignments are accurate.

Should I allocate insurance and office costs to each truck?

Eventually, yes, if you need fully loaded profitability. First, make direct costs reliable. Then choose one allocation method and use it every period. Keep the allocation visible so you can distinguish operating performance from shared overhead.

How often should I review truck profitability?

Code activity weekly and review the full truck comparison monthly. Weekly work keeps the records current. Monthly review gives enough activity to spot a trend without reacting to one unusual receipt.

Can I start if my old spreadsheets are incomplete?

Yes. Choose a clean start date, bring in the truck list and categories, and begin tracking new activity consistently. Use past data only to the extent it’s reliable. You’ll get more value from a dependable next month than from trying to reconstruct every old transaction.

Conclusion

Small fleets don’t need a giant back-office project to see profit by truck. They need a disciplined system for recording gross settlement revenue, assigning direct costs to the right truck, separating shared expenses, and reviewing the result every month. When the books and operating insight live together, the numbers stop being a delayed bookkeeping chore and become a tool for deciding what each truck should do next. Ambrook gives owner-operators a direct path out of spreadsheet cleanup and into reporting built around the work that produces their revenue.