Trip logs that fill themselves from fuel invoices

At the end of the month one invoice arrives from the fuel network – Neste, Circle K or Fleet Union – and it contains the entire month of fuel: dozens or hundreds of individual fills, each with a date, a time, a card, a station, litres and a price. Your accountant needs a handful of merged lines out of all that. Your fleet manager needs the exact opposite – every fill on its own, so trip logs can be completed and litres compared against consumption norms. Until now the second job meant opening the same PDF again and retyping it by hand.

Is a trip log actually required?

Lithuanian law does not name the trip log as the required document. A company sets its own rules for how fuel consumption is recorded, on documents signed by the people responsible – trip logs, fuel write-off records or consumption reports all qualify. What is deductible is the fuel actually used for the business, within the consumption norm the company has set for the vehicle. Whichever form you pick, the work underneath is the same: its figures have to agree with the fuel invoices. So the real question is rarely whether to keep them – it is how many hours a month they cost, and whether the numbers reconcile.

One invoice, hundreds of separate fills

When a fuel invoice arrives in Ezura it is read at two levels. Accounting keeps exactly what it needs – merged lines with VAT and dimensions, like any other invoice. Alongside that, every individual fill is kept as its own record:

• •date and exact time
• •the fuel card, and through it the vehicle and the driver
• •station and country
• •product, litres and price per litre
• •odometer reading, when the invoice carries one

The accountant's workflow does not change by a single step: line-merging rules, review and export into your accounting system all behave exactly as before. There is simply a second view alongside it that did not exist at all before.

That second view has an organisational side too. A fleet manager can pull up one vehicle's fills for a chosen period themselves – no asking the accountant to forward an invoice PDF, no waiting for the month to be closed. The accountant, in turn, stops fielding questions about who fuelled what and when. Two people stop working through the same PDF for two different reasons.

Fills land in the trip log on their own

Open an empty trip log for the month and that vehicle's fills from the invoices are already in it, with dates and litres. The driver or manager adds the kilometres and the route instead of harvesting fuel data out of a PDF. If the log has already been started, nothing is rewritten behind anyone's back: a button appears above the table – “Load fills from invoices”, with a count of how many are still missing – and a person decides.

A hand-typed entry is never duplicated. If somebody already wrote down that day's fill with rounded litres, the invoice data attaches to the existing entry instead of creating a second one. Correction rows – where the station first charges a quantity and then reverses it – stay marked as corrections rather than turning into a meaningless extra fill in the log.

When the log and the invoice disagree

The interesting part starts when the numbers do not match. Next to the litres entered in the log you also see the litres billed on invoices, and the gap is highlighted. That surfaces three things at once: a fill nobody wrote into the log; litres recorded in the log that no invoice supports; and a vehicle whose consumption drifts consistently away from its norm. Previously all of that showed up at year end, or during an inspection, or never.

What you need to prepare

• •your vehicle list and fuel cards – which card belongs to which car
• •the fuel network invoices arriving by email, like every other invoice
• •nothing else: no fuel-network portal access and no separate fleet program

Unmapped cards are not lost – their fills are kept and connect to the vehicle once the card is finally assigned. A completed month can be printed to PDF as a trip sheet, in the form you would normally hand over when asked to justify fuel costs.

What changes in practice

• •Trip logs take minutes instead of an evening spent with a PDF
• •Fuel costs are backed by documents that agree with the invoices
• •Litre discrepancies show up the same month, not a year later
• •The accountant's workflow is untouched – merged lines, as always