Consignment Note Register · Auto Report

Hire Vehicle Profit Ledger

Upload a CN Dump Register export, or pull a date range straight from the API. Pick a party, and this page finds the columns itself, applies the rule below, and totals it up by HM No.

Profit = Billing − Costing
Billing = Basic Freight + Detention + Other Charges + SuppBill Amt.
Costing = Extra Cost of LR + Hire HC
Negative-profit HM No. groups are excluded

Drop your CN Register workbook here, or click to browse

.xlsx · processed entirely in your browser — nothing is uploaded anywhere

Party (Billing Party)

Report Type

Negative Profit

Profit % Filter (optional)

Qualifying CNs

—

HM No. Groups

—

Total Billing without tax

—

Total Costing

—

Profit %

—

Excluded (Negative)

—

Net Profit

—

Hire Vehicle Only

Filter applied: Vehicle Type = "Hire Vehicle" and Bill No is not blank. HM No. groups with a negative Profit (Costing > Billing) are also excluded from the table, totals, and the downloaded report — see the "Excluded (Negative)" figure above for how many and how much that removed. Profit % = Profit ÷ Billing × 100.

Profit by Load Type

Load Type	CN Count	Billing without tax	Costing	Profit	Profit %

Profit by Party

Party	CN Count	Billing without tax	Costing	Profit	Profit %