How to enter odometer and litres to calulate diesel rebate
Options
Cathi P
Member Posts: 19 ✭
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!
There must be an easier way to do this!
0
Comments
-
Hi Cathi,
Thank you for your question.
I hope you are enjoying the trial version of Reckon Accounts.
To enter Odomoteter and liters to calculate diesel rebate, You will have to enter it through Enter Vehicle Mileage... option which is only available in Reckon Accounts Pro and above.
To do that, Go to Company > Enter Vehicle Mileage
Here you have the option to enter the Odometer data, Item link and assign Vehicle and Customer to it.
We hope above help you.
Thanks.
Palak0 -
Hi Palak,
I've had a look at that too, and have set up all my vehicles to use that, but then noticed there is nowhere for me to input my litres used.
As the diesel rebate requires me to enter a $ figure, based on the total litres purchased/used for the time period, this is a must have.
The odometer is not necessary for the calculation, but helps ensure nothing has been doubled up or missed, and is required as a part of our record keeping, even though it is not submitted.
At the moment, I can only see a number of different places that different bits of information can be entered, but nowhere that I can enter the whole lot in one transaction.
(I am using the "Pro" version of Accounts Hosted, as I generally access from a Mac, and am not on a trial version)
Any other ideas?0 -
Hi Cathi,
Thank you for your response.
in this case you should try to calculate through Unit of Measure.
To do that, Go to Lists > U/M set List
in case if you can not see under list then it might be inactive
You can activate from Edit > Preferences > Items & Inventory > Company Preferences and tick Enable units of Measure please
Thanks
Palak0 -
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
2
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 63 About Reckon Community