Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO
Quicken H&B Mileage rate problem (all versions)

Mileage rates not properly handled in Quicken H&B 2018, and have been overlooked now for this and prior versions for past 10 years. ESPECIALLY if the user has a non-standard Windows time format (or other than mm/dd/yyyy).
I'm using a format of yyyy-mm-dd (looks better in a file listing sorted by date) and always have to find the latest "MileRate.txt" file and edit it myself. Not only for the latest mileage rates (yet another common problem) but also listing them per my Windows format. I'm hoping Quicken can take a few minutes and finally resolve this as its annoying to have to find this method seemingly every time there is an update.
Until such time, here's the method for those who must do as I do:
- In Win10 "File Explorer", go to folder "C:\ProgramData\Intuit\Quicken\Inet\Common\Localweb\Biz" (note this folder changed as of Quicken 2018 as it was "C:\ProgramData\Intuit\Quicken\Inet\Common\Localweb\Biz" prior).
- Open the file "MileRate.txt" in Notepad/etc.
- Add or modify line entries to match your date setting in Windows. In my case the line for Biz2018 miles is "2018-01-01 0.545" for most others (Windows default) its "01/01/2018 0.545"
- See http://www.gsa.gov/mileage for latest rates
I'm using a format of yyyy-mm-dd (looks better in a file listing sorted by date) and always have to find the latest "MileRate.txt" file and edit it myself. Not only for the latest mileage rates (yet another common problem) but also listing them per my Windows format. I'm hoping Quicken can take a few minutes and finally resolve this as its annoying to have to find this method seemingly every time there is an update.
Until such time, here's the method for those who must do as I do:
- In Win10 "File Explorer", go to folder "C:\ProgramData\Intuit\Quicken\Inet\Common\Localweb\Biz" (note this folder changed as of Quicken 2018 as it was "C:\ProgramData\Intuit\Quicken\Inet\Common\Localweb\Biz" prior).
- Open the file "MileRate.txt" in Notepad/etc.
- Add or modify line entries to match your date setting in Windows. In my case the line for Biz2018 miles is "2018-01-01 0.545" for most others (Windows default) its "01/01/2018 0.545"
- See http://www.gsa.gov/mileage for latest rates
0
This discussion has been closed.
Comments
The code reading milerate.txt into Quicken should read it correctly as delivered, in mm/dd/yyyy format, regardless of the date format your computer uses.
There should be no need for the customer to have to edit milerate.txt to make the tables work if the customer's computer uses a different date format.
Hello, Quicken programmers, are you listening?
About the file paths ... you made a typo. Your text should read:
"C:\ProgramData\Quicken\Inet\Common\Localweb\Biz" (note this
folder changed as of Quicken 2018 as it was
"C:\ProgramData\Intuit\Quicken\Inet\Common\Localweb\Biz" prior).
I what I was getting at is that the updated mileage numbers always lag (from what I have seen on the posts on here), and as such they should make it something that the user can override if need be.
C:\ProgramData\Quicken\Inet\Common\Localweb\Biz
(note that Quicken is no longer a subfolder of Intuit)
But yeah, us millions of users (read lots of $$$) on something sacred to lots of biz users (the mileage) should not have to be the experts here. I say, as a programmer myself, this should be a 10min fix for a good Quicken engineer.
For Quicken users (probably all versions of Quicken with mileage support), It is recommended to make your own copy of the "MileRate.txt" file and keep that updated so you can easily copy it over the next useless updated file until they get this right.
Now running Quicken Windows Subscription, Home & Business
Retired "Certified Information Systems Auditor" & Bank Audit VP
Now running Quicken Windows Subscription, Home & Business
Retired "Certified Information Systems Auditor" & Bank Audit VP
[rant redacted]
Now running Quicken Windows Subscription, Home & Business
Retired "Certified Information Systems Auditor" & Bank Audit VP
And, I have been keeping a copy of the MileRate.txt file to suit my needs for probably close to 10 years (seems ridiculous to put that in writing for an app used by millions, no?).
For those who must resort to this same nonsense (having to keep ur own file updated & copy over the Q updated version), you simply need to have the line show the date format you have in Windows. Following example for YYYY-MM-DD format (a few lines):
2017-01-01 0.535
2018-01-01 0.545
2019-01-01 0.580