2014 Per Diem Worksheet

Online spreadsheet where you enter in the dates you left/returned home and it calculates the days away, your total standard meal allowance, and the amount you can actually claim on your schedule A or C:
https://docs.google.com/spreadsheets/d/16QSBxxG0rp5K0JvvtFlNOHLPW6xezLjH_dFQskDOkXc/edit#gid=0

 

The white boxes can be edited by anyone (might not let you if you're on a mobile), but I haven't found a way to turn off those grey stripes while maintaining the cell protection they denote. The end user can manually click view & uncheck "protected cells."

Good idea, changed

When google sheets calculates the days, it comes up 1 day short: 1/31/14 - 1/1/14 = 30 -- not 31. But like you mention, if you left on 1/1 and returned 1/31 that would be 30.5 days due to the two 75% days, so I actually add 0.5 instead of 1 (using a simple IF qualifier to ensure there was an entry for those cells):

+0.5*IF(B8>B6,1,0)


I then add the 0.25 if you were away from home on either the beginning or end date (eg you were on the road during new years):

+0.25*IF(B7="y",1,0) +0.25*IF(B9="y",1,0)

Yep -- there should be a note to the right explaining that F4 is the number you enter into Turbo Tax (because TurboTax multiplies by 80%). F5 is 80% of F4 -- which is what you put into your schedule A or C if you're not using TurboTax...

 

What I'd really like is for it to only have 1 data entry box until data is entered, at which point it would automatically create another entry box.

 

Here is where you enter per diem in Turbo Tax:


Note that it asks for the expense (the full amount), not the deduction (the 80%). If you were to use the "other meals and entertainment" field, for example, it would be 50% instead of 80%


https://ttlc.intuit.com/questions/2...-my-department-of-transportation-dot-per-diem