Closed Fuel Transactions by Facility and Vehicle

Summary/Use Case

Report Summary

The Closed Fuel Transactions by Facility and Vehicle report provides detailed information on fuel transactions, organized by facility and vehicle. This report is beneficial for fleet managers to monitor fuel costs, usage, and transactions over a specific period, enabling effective fuel expense management.

Use Case

  • Track fuel usage and expenses by vehicle and facility to manage fuel budgets.

  • Identify vehicles with higher fuel consumption for potential maintenance or optimization.

  • Audit fuel transaction history for any discrepancies or unusual usage patterns.

  • Allocate fuel expenses accurately to departments or facilities based on recorded usage.

Location: Where to Find It

Reports > RTA Standard Reports > Fuel > Closed Fuel Transactions by Facility and Vehicle

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.

Data Filter List

image-20241112-224349.png

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Facility

Is Between

1 to 99999

1 to 1

Date Range

Is Between

Any Date Range

First Day and Last Day of Previous Month

Vehicle

Is Between

blank to zzzzzzzzz

blank to zzzzzzzzz

Report Output and Data Elements

Once the Closed Fuel Transactions by Facility and Vehicle report runs, it displays a detailed list of fuel transactions organized by facility and vehicle. Key data points include transaction date, vehicle odometer reading, cost per gallon, and total transaction cost. Each facility has a totals page summarizing metrics such as transaction count, miles, fuel quantity, and total cost, broken down by usage, drops, and transfers.

Report Output

image-20241112-224413.png

Report Output - Facility Totals Page

image-20241112-224444.png

Report Data Elements

Column Number

Column Title

Data Notes

1

Transaction Number

Unique identifier for each fuel transaction.

2

Date

Date of the fuel transaction.

3

Tank

Tank number associated with the transaction.

4

Pump

Pump number used for the transaction.

5

Fuel Type

Type of fuel used (e.g., NTBL, U for unleaded).

6

Tax

Tax applied to the fuel transaction.

7

State

Location state where the transaction occurred.

8

Odometer

Vehicle odometer reading at the time of transaction.

9

Cost Type

Type of cost associated (Fuel, Oil, etc.).

10

$ / Gallon

Cost per gallon of fuel.

11

Miles

Miles traveled, if applicable.

12

Quantity

Quantity of fuel purchased.

13

Total Cost

Total cost of the transaction.