How to enter odometer and litres to calulate diesel rebate

  • 1
  • Question
  • Updated 6 years ago
  • Answered
I'm after some suggestions for an easy way to enter and use Accounts to help me calculate the diesel rebate. Previously I've noted date, odometer and litres in the description field against the expense account in my Bills. I'm currently trialling using Items, which at least allows me to input the litres, but has no odometer field. Obviously in both cases, I still need to run a report and export to excel to tally the figures. That is what causes the difficulty, since I'm working with 5 vehicles (classes) and often some of the dates export as text causing all sorts of problems with sorting correctly.

There must be an easier way to do this!
Photo of Cathi P

Cathi P

  • 452 Points 250 badge 2x thumb

Posted 6 years ago

  • 1
Photo of SusanR

SusanR, Accredited Partner

  • 1,938 Points 1k badge 2x thumb
Official Response
Hi Cathi,

I think this will give you the result you are asking.

Using the Enter Vehicle Mileage feature, navigate to Mileage Rates at the top of this window and record your rebate rate.

Then, enter a Vehicle and use the Total Kilometres field to record the litres.  Save this transaction.

From the Enter Vehicle Mileage feature window, click Mileage Reports, then Mileage by Vehicle Detail.

You can then modify the report to change the name and memorise the report to generate each reporting period and save with your BAS supporting documentation.

You can also export the report to Microsoft Excel if you would prefer to change some of the column headings.

I hope this helps.

Sue