Better recording of mileage?

Hi folks,

I’m starting to do a lot of local mileage (short trips) in the course of a new venture. I’m currently claiming per the Business mileage expense KB article, but that method of entry is pretty tedious - especially once you’re doing lots of small trips against different invoices:

  • Date
  • Reason
  • Relevant invoice
  • Miles
  • Rate
  • Total

For each journey.

There surely has to be an easier or more efficient way of recording this. How are other people dealing with this stuff?

If everyone is actually doing all this manually each time, is there perhaps appetite among users and QF staff for adding some functionality to invoices, such that mileage could be added there, multiplied by a rate set in the user’s settings (or just from HMRC), and added to an automatically generated purchase linking back to that invoice? It could then be paid automatically if there is only one Director’s Loan Account, etc.

Thanks in advance for any tips or comments.

I record my journeys on a spreadsheet and then do two transactions per year in quickfile. i.e Sept & March for each 6 month accumalated milelage.

Rob

That’s a sensible halfway house in some respects, but it does still involve capturing and duplicating details manually for each journey, which are already in the related invoices - so recording them in a spreadsheet doesn’t seem to me to be much different to recording them as line irems in a purchase invoice - they’re both separated from the actual invoice to which the incurred costs relate …