nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Way to get around the mileage tracker?

Barbara Acosta

I find the Quicken mileage tracker burdensome and instead am using an Excel spreadsheet to track my mileage. What is the best and easiest way to enter this info into Quicken so it shows up in Schedule E? I'd like to just enter the monetary amount somewhere once a month. All of the details including odometer readings are already in Excel.

Find more posts tagged with

Rental Property

Accepted answers

NotACPA

" but it makes you input your odometer reading at start and end of the trip. "

No it doesn't ... just put in the Mileage as calculated in Excel. I NEVER input odometer readings, and I use the Mileage Tracker all the time.

All comments

NotACPA

How about inputting a single Monthly transaction into the Mileage tracker that summarizes your Excel data?

Barbara Acosta

Actually, I thought of that, but it makes you input your odometer reading at start and end of the trip. Since I drive other places during the month, that won't work. So now I thought, what if I create a cash account. Then I would enter 2 transactions: the first to 'add' cash back into the account, the second to withdraw it using the automobile expense attached to Schedule E. It looks like that will work, but let me know if you think of something more elegant!

NotACPA

" but it makes you input your odometer reading at start and end of the trip. "

No it doesn't ... just put in the Mileage as calculated in Excel. I NEVER input odometer readings, and I use the Mileage Tracker all the time.

Barbara Acosta

Oh ha ha! Thanks. Perfect