Icon

Vehicle Invoices - Locating Vehicle Information

By Rose Gomez

In this guide, we'll learn how to efficiently use a vehicle spreadsheet to determine the department ownership of a vehicle based on its invoice. This process is essential for managing vehicle allocations across public and private sectors, as well as for financial tracking. By understanding how to navigate and utilize the spreadsheet, you can streamline the identification process and ensure accurate record-keeping.

Let's get started

When you encounter a vehicle invoice, use the vehicle spreadsheet to identify the department to which the vehicle belongs.

1
This invoice is for a vehicle. We need to note the vehicle information on the invoice.
Step #1: This invoice is for a vehicle. We need to note the vehicle information on the invoice.
2
Open File Explorer
Step #2: Open File Explorer

Public, private.

3
Click on "Public (P)"
Step #3: Click on "Public (P)"

And then facilities. Vehicles. Vehicle invoice.

4
Double-click on "Facilities"
Step #4: Double-click on "Facilities"

5
Double-click on "Vehicles"
Step #5: Double-click on "Vehicles"
6
Double-click on "( UPDATED 4-28-25 )" Jesse updates this spreadsheet often, always open the most recent copy.
Step #6: Double-click on "( UPDATED 4-28-25 )" Jesse updates this spreadsheet often, always open the most recent copy.
7
Use CTRL + F to find the license plate number - Only search for the number, leave out the PF
Step #7: Use CTRL + F to find the license plate number - Only search for the number, leave out the PF
8
Click here
Step #8: Click here

9
The license plate number is found on the invoice "PF48389"
Step #9: The license plate number is found on the invoice "PF48389"

10
Type "48389 + Enter"

11
Click "T" to add a text box
Step #11: Click "T" to add a text box
12
Drag to create text box
Step #12: Drag to create text box
13
Type "VEH # 257"
14
Type "Ctrl + Enter"
15
Type "DEPT 6"
16
Type "Ctrl + Enter"
17
Type "DAKOTA ALEGRE + Enter"
18
We have added notes so that the invoice can be quickly entered to the correct department.
Step #18: We have added notes so that the invoice can be quickly entered to the correct department.
19
Click on "Push To Queue"
Step #19: Click on "Push To Queue"
20
Click on "Rose Gomez's Queue" and change to OCR
Step #20: Click on "Rose Gomez's Queue" and change to OCR
21
Type "o + Enter"
22
Click on "OK"
Step #22: Click on "OK"
23
Click on "Yes" to save document changes. Hitting "No" will remove the notes we just made.
Step #23: Click on "Yes" to save document changes. Hitting "No" will remove the notes we just made.