Customer Accounting Report

Summary/Use Case

Report Summary

The Customer Accounting Report (ROD) provides a detailed breakdown of costs associated with customer vehicles and work orders, organized by facility and customer. This report allows fleet managers to analyze and summarize expenses across multiple cost categories, such as labor, parts, and other specific charges, facilitating improved budgeting and cost control based on the closed work order date.

Use Case

Track and manage total repair costs for customer vehicles by department and facility.
Analyze expenses by individual cost categories (e.g., parts, labor, tires) for accurate billing.
Identify high-cost repairs or customers with significant outstanding balances.
Assist in end-of-month or quarterly financial reporting with itemized and totalled data.
Support customer billing accuracy by validating detailed costs per work order.

Location: Where to Find It

Reports > RTA Standard Reports > Work Order > Customer Accounting Report (ROD)

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)
Totals Only	False
Summary	False

Data Filter List

Filter Name	Recommended Filter Condition(s)	Value (Options)	Value (Default)	Value (Notes)
Work Order Facility	Equal To	Facility ID numbers	1	Filter specific facility records.
WO Closed Date Range	Is Between	Any date range	10/01/2024 - 10/31/2024	Date range allows filtering by closed work order dates.
Customer Number	Is Between	" " - zzzzzzzzz	" " - zzzzzzzzz	Represents all possible customer numbers.

Report Output and Data Elements

The "Customer Accounting Report (ROD)" displays a detailed breakdown by customer, vehicle, and work order. The report includes costs by various categories such as parts, tires, labor, and other charges, along with totals for each category. Totals are provided at the vehicle, type, and customer levels, enabling a summary of costs for each grouping. The report is sorted in the following order:

Customer Number (Ascending)
Vehicle Class (Ascending)
Vehicle (Ascending)
Work Order End Date (Ascending)
Work Order Number (Ascending)

Report Output

Report Data Elements

Column Number	Column Title	Data Notes
1	Vehicle	Vehicle ID associated with the work order.
2	Work Order	Unique identifier for each work order.
3	Opened	Date the work order was opened.
4	Closed	Date the work order was closed.
5	Parts	Cost of parts used in the work order.
6	Tires	Cost of tires associated with the work order.
7	Labor	Cost of labor performed for the work order.
8	Outside	Costs for external services related to the work order.
9	Supplies	Cost of additional supplies used.
10	Taxes	Taxes applied to the work order costs.
11	Misc	Miscellaneous expenses linked to the work order.
12	Damage	Cost of damage repairs (if any) associated with the work.
13	Total	Sum of all costs for that particular work order.