Reservation Cost Breakdown
- Andrew Finch
Summary/Use Case
Report Summary
The Reservation Cost Breakdown Report provides a detailed breakdown of reservation costs, including charges for mileage, fuel, cleaning, class rate, late fees, and cancellations. This report helps fleet managers track and analyze reservation expenses by facility, customer, or department, ensuring accurate cost allocation and budgeting.
Use Case
Monitor vehicle reservation costs to ensure accurate billing
Identify trends in reservation expenses across different customers or departments
Analyze the impact of cancellations and late fees on overall costs
Support budgeting and cost control for fleet management
Ensure accurate financial reporting and accountability for vehicle usage
Location: Where to Find it
Reports > RTA Standard Reports > Motor Pool > Reservation Cost Breakdown
Data Filter Prompts
You will be prompted for filtering of the Data to specify and narrow down the data that will be pulled. See Data Filter List Below for Options.
Parameter List
Parameter Name | Value (Default) | Value (Notes) |
|---|---|---|
Please select Customer or Department for grouping (None to skip grouping) | Customer | Allows grouping by Customer or Department If None is selected, Customer and Department groupings/sorts will be ignored and will move to sorting by Vehicle |
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default) | Value (Notes) |
|---|---|---|---|---|
Facility | Is Between | 1 to 99999 | 1 to 99999 | Represents the full range of facilities |
Return Date | Is Between | Start Date - End Date | First to Last Day of Previous Month | Default range represents a one-year period leading up to the report date |
Include 0=Not Deleted Reservations and 1=Deleted Reservations | Is One Of | 0, 1 | 0, 1 | Includes both deleted and non-deleted reservations |
Report Output and Data Elements
Report Output
The Reservation Cost Breakdown Report provides a structured summary of reservation costs per facility. The report includes individual reservation details along with subtotaled costs grouped by department or customer. Key data points include mileage, fuel, cleaning fees, class rates, late fees, and total costs. The report also provides totals for each category at different grouping levels.
*If Customer / Department grouping IS included
*If Customer / Department grouping IS NOT included
Report Data Elements
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Vehicle | Identifies the reserved vehicle |
2 | Res # | Reservation number assigned to the booking |
3 | Deleted Reservation | Indicates if the reservation was deleted (Yes/No) |
4 | Rate Description | Describes the rate applied to the reservation (e.g., Daily, SUV Rental) |
5 | Return Date | The date and time when the vehicle was returned |
6 | Mileage | Mileage cost associated with the reservation |
7 | Fuel | Fuel charges applied to the reservation |
8 | Cleaning | Cleaning fees charged for the reservation |
9 | Reservation Class Rate | Base rate for the reservation class |
10 | Late | Late fees incurred for the reservation |
11 | Cancellation | Cancellation fees incurred for the reservation |
12 | Total | The total cost for the reservation |