Compare with fuellings

Follow

Compare with fuellings is simple report, what shows fuel expenses together with actual fuellings, when expenses stay into 30-minute window compared with fuellings.

Requirements

  • Vehicle must have some fuel sensor support
  • User must insert fuellings into expenses module with system type *FUEL
  • make sure that fuelling time is correct

How it works

Report generator takes list of fuellings, and tries to take expense records next to them, where expense type is *FUEL and it's timestamp is maximum 15 minute earlier or 15 minute later. If no expense matches with fuelling time, expense data is left empty.

Overview

Report contains following columns:

  • date of fuelling
  • time of fuelling
  • vehicle name
  • amount of expense, if available
  • sum of expense, if available
  • amount of real fuelling, from sensor or CAN
  • difference in litres: fuelling minus expense
  • difference %, calculated like that:
    difference = (fuelling - expense) / expense * 100

Troubleshooting

  • There is no data: make sure that vehicle has fuellings in fuel report
  • there is no expense data: make sure that expenses have type *Fuel and their timestamp is not earlier or later than 15 minute compared with fuelling. If you want to see all fuellings and expenses, you need to use Fuel report with expenses instead.

See also

Was this article helpful?
0 out of 0 found this helpful