Recording Trucking Settlements in QuickBooks When Only the Net Deposits
How to book gross pay and carrier deductions from trucking settlements in QuickBooks, so income and expenses stay accurate when only the net hits the bank.
Owner-operators leased onto a carrier face a common bookkeeping puzzle. The settlement shows gross pay, a list of deductions, and a net check. Only the net ever reaches the checking account. If you record just the deposit, the books understate revenue and miss real expenses.
Here is how we recommend handling it in QuickBooks and QuickBooks Online.
Why the net deposit alone is not enough
The net check is the only bank transaction, but it is not the whole story. The gross line is your income. Fuel, insurance, escrow, maintenance, and plate deductions are real costs, even though the carrier paid them on the driver’s behalf. Booking only the net hides both the true revenue and the deductions, which distorts profit reports and any per-mile analysis.
The cleanest method: record the settlement as an invoice or journal entry
Two approaches work well.
Option 1: Invoice plus deduction lines. Create an invoice for the gross amount using income accounts such as Freight Revenue or Accessorial Income. Then enter the deductions as negative lines mapped to their proper expense accounts, for example Fuel Expense, Truck Insurance, or Escrow Receivable. The invoice total equals the net deposit. Receive payment against it and match the deposit in bank feeds. This keeps everything on one document that mirrors the settlement.
Option 2: A single journal entry per settlement. Debit the gross to an income-clearing setup, or more simply: credit Gross Freight Income for the gross, debit each deduction to its expense or asset account, and debit Cash for the net. The debits and credits balance, and the net ties exactly to the bank deposit.
How to structure the journal entry
A typical weekly entry looks like this:
- Debit: Checking, for the net amount
- Debit: Fuel Expense, for the fuel deduction
- Debit: Insurance Expense, for the insurance deduction
- Debit: Escrow Receivable, for escrow withheld
- Credit: Freight Income, for the gross
The debits must always equal the gross. If they do not, a deduction is missing or miscategorized.
Handling escrow correctly
Escrow withheld by the carrier is not an expense. It is the driver’s money held by the carrier, so book it to an other current asset account such as Carrier Escrow Receivable. When the carrier releases escrow, apply the payment against that asset. Deducted maintenance and fuel, by contrast, are genuine expenses in the period they are withheld.
Practical tips
Enter settlements weekly, not in batches, so each entry matches one statement. Keep the settlement PDF attached to the transaction for audit support. Reconcile the escrow balance against the carrier’s periodic escrow statement. If the client later moves to QuickBooks Desktop or needs historical cleanup, our guide to converting and migrating QuickBooks data covers what carries over.
Set up a memorized or recurring journal entry template with the standard deduction accounts. Each week you only plug in the amounts, which cuts errors and keeps the chart of accounts consistent across settlements.