A Microsoft Excel tool to help a user calculate Foreign Per Diem travel expenses using “Per Diem Rates” methodology. See U.S. Department of State: Office of Allowances: Foreign Per Diem Rates for additional background information.
- Enable secure connection when opening the Excel file to connect to Allocation of M&IE Rates to Be Used in Making Deductions from the M&IE Allowance Webpage Table.
- User inputs the start and end dates of the trip (red highlight on F3 and F4).
- Follow the instructions above each column to fill out the table.
foreign-per-diem-calculator-for-usa-based-institutions © 2022 by Philip Bachas-Daunert is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International