Case study · Fleet & fuel

Fuel card cost tracking

A live fuel cost dashboard for a services company running eleven fuel cards. Weekly invoices go in; spend by driver, vehicle, card and month comes out — with every line checked against the invoice, and wrongly keyed registrations caught automatically.

Client
Services company
Fuel cards
11
Invoices loaded
40 weekly
Built as
Web dashboard
Fuel cost dashboard: net cost for the financial year to date with VAT, gross, fill-ups, litres, average price per litre and cards used, above a table of cost by card with each employee, usual vehicle, fills, fuel, card charges and last used
Names, vehicle registrations, card and account numbers have been changed.
The challenge

Paying the fuel bill without knowing where it went

Fuel card invoices arrived every week as a list of transactions. The total was easy to pay; working out who spent what, on which vehicle, and whether it was reasonable meant hours in a spreadsheet — so mostly it didn’t happen.

What we built

Every litre, every card, every invoice — in one place

Year, month or week at a glance

Net, VAT and gross spend, fill-ups, litres and average price per litre for any period, with unleaded and diesel split out.

By driver, vehicle or card

Switch between employee, vehicle and card views. Unused cards stay visible, carrying their share of the account charges.

Month by month

Stacked monthly spend against the average full month, with part periods faded until their invoice arrives — plus a small chart per driver on the same scale.

Registrations corrected

Costs are allocated by card, so a mistyped registration at the pump is flagged against the right vehicle instead of creating a phantom one.

Checked against the invoice

Each invoice is reconciled line by line, with a clear “Lines match invoice” check and totals for net, VAT and gross.

Gaps spotted automatically

Missing invoices are listed, so the team knows exactly which week and month will change once it’s added.

Month by month stacked bar chart of unleaded, diesel and card charges against the average full month, and small monthly charts of fuel spend for three employees on the same scale
Names, vehicle registrations, card and account numbers have been changed.
Transactions for August with date, time, employee, vehicle, site, product, litres, price per litre and net cost; two lines flag a registration keyed wrongly at the pump
Each fill-up is allocated by card. Where the registration was keyed wrongly at the pump, it’s flagged and the correct vehicle is used. Names, vehicle registrations, card and account numbers have been changed.
Invoice reconciliation table showing five weekly invoices with net, VAT and gross, each marked lines match invoice, above data notes explaining how costs are assigned and listing a missing invoice
Names, vehicle registrations, card and account numbers have been changed.
How it works

Invoices in, answers out

  1. 1

    Load the invoices

    Weekly fuel card invoices are imported as they arrive — the whole history in one go at the start.

  2. 2

    Allocate by card

    Every line is assigned to the card, its driver and their usual vehicle, with account charges shared fairly.

  3. 3

    Check and flag

    Totals are reconciled to each invoice, wrong registrations flagged and missing weeks listed.

  4. 4

    Look it up

    Pick any year, month or week and drill from the total down to a single fill-up.

Want this for your fleet?

Get the same dashboard

Losing sight of what your fleet costs?

Tell us how you track fuel, mileage or vehicle costs today. We’ll talk through what a dashboard like this could show you. We reply within one working day.

hello@jntechnology.co.uk Portland House, Belmont Business Park, Durham DH1 1TW

By sending, you agree we can use your details to reply to your enquiry. We never share them.