🔍
Trucking fuel savings tracker V2 in Google Sheets with a phone form: a fuel expense dashboard comparing pump price and discount price, prices by truck stop, and monthly fuel spend. Receipts can be uploaded from a phone.
Trucking fuel savings tracker V1 and V2 compared, with a video tutorial in the description: both have mobile data entry, Google Sheets and Forms, automatic processing, a reconciliation workspace and overview; only V2 adds fuel expense reports and the fuel dashboard.
Works like an app: an icon on the phone's home screen opens the fuel receipt form.
Share the Google Form so others can log fuel purchases and upload receipts; entries fill in a shared Google Sheet.
Snap the receipt: log fuel purchases and upload receipts from any device; the data syncs to Google Sheets and receipts are saved to Google Drive for reconciliation later.
Receipts are archived in Google Drive automatically, organized by fuel type, with a link to each receipt in the sheet.
Fuel financial reports: monthly, quarterly and annual expense reports by fuel type, with amounts paid, gallons, savings and average prices.
Snap the receipt: log fuel purchases and upload receipts from a phone, tablet or computer; the data syncs to Google Sheets.
Fuel expense reconciliation workspace: enter the fuel card statement's net charge and reference number to compare totals; each line shows reconciled, unreconciled or discrepancy.
Know your savings: estimated savings per gallon, total advertised savings, and confirmed savings for each transaction, with counts of transactions and unreconciled transactions.
Fuel reconciliation overview: filter by week, month, quarter or year; confirmed savings, pending transactions and discrepancies are shown.
Fuel expense dashboard filters: year, quarter, month and fuel type.
Fuel expense dashboard: total and net fuel costs, discounts, gallons, miles per gallon and cost per mile, a quarterly analysis, reconciliation status, average net price by truck stop, price trends, and net fuel spend by month and quarter.
A two-step process: upload fuel receipts, then enter the net charge from the fuel card statement; the spreadsheet does the rest of the calculations.
  1. Trucking fuel savings tracker V2 in Google Sheets with a phone form: a fuel expense dashboard comparing pump price and discount price, prices by truck stop, and monthly fuel spend. Receipts can be uploaded from a phone.
  2. Trucking fuel savings tracker V1 and V2 compared, with a video tutorial in the description: both have mobile data entry, Google Sheets and Forms, automatic processing, a reconciliation workspace and overview; only V2 adds fuel expense reports and the fuel dashboard.
  3. Works like an app: an icon on the phone's home screen opens the fuel receipt form.
  4. Share the Google Form so others can log fuel purchases and upload receipts; entries fill in a shared Google Sheet.
  5. Snap the receipt: log fuel purchases and upload receipts from any device; the data syncs to Google Sheets and receipts are saved to Google Drive for reconciliation later.
  6. Receipts are archived in Google Drive automatically, organized by fuel type, with a link to each receipt in the sheet.
  7. Fuel financial reports: monthly, quarterly and annual expense reports by fuel type, with amounts paid, gallons, savings and average prices.
  8. Snap the receipt: log fuel purchases and upload receipts from a phone, tablet or computer; the data syncs to Google Sheets.
  9. Fuel expense reconciliation workspace: enter the fuel card statement's net charge and reference number to compare totals; each line shows reconciled, unreconciled or discrepancy.
  10. Know your savings: estimated savings per gallon, total advertised savings, and confirmed savings for each transaction, with counts of transactions and unreconciled transactions.
  11. Fuel reconciliation overview: filter by week, month, quarter or year; confirmed savings, pending transactions and discrepancies are shown.
  12. Fuel expense dashboard filters: year, quarter, month and fuel type.
  13. Fuel expense dashboard: total and net fuel costs, discounts, gallons, miles per gallon and cost per mile, a quarterly analysis, reconciliation status, average net price by truck stop, price trends, and net fuel spend by month and quarter.
  14. A two-step process: upload fuel receipts, then enter the net charge from the fuel card statement; the spreadsheet does the rest of the calculations.

Trucking Business

Trucking Fuel Savings Tracker V2 with Phone Form

$27.99

Digital Download
  • Instant download after payment
  • No sales tax, no hidden fees
  • Excel and/or Google Sheets files
How does it work?

Check out the Youtube video on how to use it below.

What will I get?

You will receive 1 PDF instruction guide on how to save the Google Sheet and Form.  This template is exclusively compatible with Google Sheets ONLY.

How will I get the files?

Once your payment is successfully processed, you will receive instant access to download links for your digital product. A confirmation email will also be sent with downloadable links.

Returns & Exchanges?

These are digital products and sales are final. If a template does not work as described, you may report the issue within 7 days of purchase and may be eligible for a refund under the Terms of Service.

About this template

This trucking fuel expense tracker works in Google Sheets. It is the Trucking Fuel Savings Tracker V2 with Phone Form, designed by a licensed CPA.

What is in the trucking fuel expense tracker

The template includes a fuel expense dashboard comparing pump price and discount price, prices by truck stop, and monthly fuel spend.

Who uses it

Owner-operators, small fleets and their bookkeepers. See all trucking bookkeeping spreadsheets.

What you receive

One PDF guide with the link to the Google Sheets file and the steps to save it to your Google Drive. It works in Google Sheets only.

How does it work?

Check out the Youtube video on how to use it here:

Reviews

Reviews

There are no reviews yet.

Be the first to review “Trucking Fuel Savings Tracker V2 with Phone Form”

Your email address will not be published. Required fields are marked *

You may also like