Profit/Loss by Vehicle Report

Location

REPORTS > Fleet Reports > Financial

Purpose

The Profit/Loss by Vehicle Report provides the profit or loss of each vehicle. This is calculated by taking the revenue generated by rental agreements, less the costs for labor, parts, and depreciation.

For the active fleet, depreciation is calculated dynamically using the acquisition cost, acquisition date, and depreciation rate. For SOLD vehicles, the accumulated depreciation value is reported.

Options

Sort Within Model By – The report is divided by vehicle model, and each model can be sorted by unit number, by net revenue, or by class.

Report Accrued Income – Accrued income from currently-open contracts can be excluded from the report or calculated through either the report end date or through the contract’s due back date.

Include Sold Cars – Check this box to include vehicles that have been moved to the Sold Vehicles table.

Pro-Rate Revenue to Report Range – Check this box to only include a contract’s revenue that was produced during the report range.

Print Summary Only – If this box is checked, a summary for each vehicle model will be printed.

Data Selection

The vehicles are selected by the following rules:

• The vehicle’s unit number is within the selected range.
• The vehicle’s owning location is selected in the reporting list boxes.
• The vehicle’s product is selected reporting list boxes.
• Vehicles are selected from both the current fleet, and from the sold fleet when the "Include Sold Cars" option is selected.

The contracts are selected by the following rules:

• The contract is closed and its report date is within the selected range.
• The contract’s report location is selected in the reporting lists.
• The contract’s product is selected.