Posted by Mung/CA on 11/16/05 2:48pm
Msg #77015

Anybody care to share their mileage log?

I have been trying to create a simple mileage log on Word but am getting frustrated. Does anybody out there have a good one that they're willing to share? Thanks!

Reply by srnotary_CA on 11/16/05 2:49pm
Msg #77017

I do mine in excel unfortunately it is on laptop and hubby has that LOL

Reply by srnotary_CA on 11/16/05 2:52pm
Msg #77019

Sorry hit post before I was done

Reply by srnotary_CA on 11/16/05 2:53pm
Msg #77021

Re: Sorry hit post before I was done/ did it again

At the top I put beginning and ending mileage then down the sides I put the date. you can use excel to subtract the mileage so you have a total column as well after each entry. Hope this helps.

Reply by cmd_NH on 11/16/05 3:06pm
Msg #77026

I do mine in excel also...

Column 1: Date
Column 2: Description
Column 3: Beginning Mileage
Column 4: Ending Mileage
Column 5: Formula for #4-#3= total miles
Column 6: IRS rates for mileage
Column 7: Formula for #5 X #6 = total dollars

At the bottom of column 5 and column 6 is the totals for the page, which I then bring forward to the next page to keep running totals.

Reply by cmd_NH on 11/16/05 3:11pm
Msg #77030

Oops! I don't bring the totals forward. I set up to print header line on each page. That way I can print out at the end of the year and it automatically keeps a running total. Sorry about that.

Reply by srnotary_CA on 11/16/05 3:17pm
Msg #77032

I haven't pu all that in mine guess I should lol.

Reply by cmd_NH on 11/16/05 3:27pm
Msg #77034

Covers your butt with the IRS if audited! And if you use the standard mileage rate on tax return, lets you keep track of deduction amount throughout the year!!!

Reply by Roger_OH on 11/16/05 3:52pm
Msg #77038

You can get one at Staples or OfficeMax n/m

Reply by Sandee on 11/16/05 6:04pm
Msg #77058

What about setting your trip mileage upon leaving and note it when you arrive and just double it for return trip.

Reply by SignerCA on 11/16/05 6:12pm
Msg #77063

IRS rate is at $.485 until end of year, right?

Reply by cmd_NH on 11/16/05 6:14pm
Msg #77064

Re: IRS rate is at $.485 until end of year, right?

yes $.485 is right.

Reply by Paul_IL on 11/17/05 2:03am
Msg #77127

Rate is .485 from Sept to end of the year NM