Per Diem - GSA M&IE
Is there an automated method of adding my Meals and Incidental Expense from the GSA Schedule?
Expensify is so innovative, so I must be missing something and just doing it the hard way- right now I'm doing Add Expense, Multiple Tab, then hand keying what I look up on the GSA website for the zip code or city I'm in that day. Would be nice to have it pick up the zip code of the hotel and add the per diem. Across 45 weeks of travel of travel a year in a dozen or two cities later and that's a lot of potential for error from my data entry.
We're usually Per Diem on the GSA schedule, for some locations we use SOW negotiated rates - so a policy specific template of rates would be fine by me - I can download them from GSA and add there if needed.
Answers
-
Conor Pendergrast Expensify Success Coach - Admin, Expensify Team, Expensify Student Ambassador Posts: 175 Expensify TeamHey @Miko505 , great to hear from you! We introduced Per Diem rates last year, which will allow a company to add Per Diem rates to their policy, and then as an employee you can create Per Diem claims.
Similar to you, we found that very few of our customers use the true GSA schedule of Per Diem rates, so instead of pre-populating with rates that wouldn't be used, you can import your rates via spreadsheet.
I'd recommend taking a look at our Geographical Per Diem documentation, which includes spreadsheets you can download to modify for your use-case that can then be re-uploaded into Expensify. Per Diem is available to any customers using a Control policy, and you can set this up via your policy -> Per Diem.
I'd also love to hear from other customers who are using Per Diem in Expensify!
All the best,
Conor
-
The ability to add bulk per diem rates, say those downloaded from GSA works great BUT the problem is there is no ability to replace old rates with new, or delete old rates in bulk before uploading new rates. I can manipulate the downloaded rates from GSA to make importable, but it is a HUGE pain to manually delete all the old rates one by one to upload new ones.
-
Yes would also need automatically adding per diem rates from GSA, best if Expensify would get them straight from GSA site (Concur and Certify know how to do this, so cannot be that hard).... and please add ways to 'delete' tags, and bulk 'delete' rates if it cannot automatically update them !!! That's a killer for us as non-for-profit... as we have to use GSA rates because of governmental funding.
-
A way to bulk delete existing rates is a must. I just clicked the red X 670 times and it sucked out loud.
Attached is the GSA FY19 per diem rates spreadsheet, with a little magic to create a decent name field. Just import using Column I for names, J for currency, and H for the rate. For whatever reason, mine wouldn't import line 1 cleanly, so you may have to enter that one manually, but it provides all the locale specific rates with a name formatted as:STATE, City (County) Start and End Month
-
We use the true GSA rates. Please add this feature.
