Fuel Card Import Formatting/Examples in Pro

Tips and Tricks for importing fuel expenses in Pro:

Make sure to download the Sample file. You will click on Expenses in the top black navigation bar, then click Import Fuel Expenses. Files can be uploaded from a CSV (spreadsheet) only.

Examples for formatting:

Date: 1/4/2016

Amount:  164.18, or $164.18

Description: Anything can be entered into this column

Truck Number: Enter the truck number exactly as it appears in the Truck Number list in your account. (you can go to Settings, then Units to check) Don't enter the truck type or the make/model unless it's part of the truck number.

Gallons: 1500 (do not use a comma)

Odometer: 353422 OR 353,422 (with or without a comma)

State: SC or South Carolina (abbreviated or spelled out)

Also: Make sure to have the header in the first column. (date, amount, description, truck_number, gallons, odometer, state)