Skip to main content
Administrator Guide
Last Updated: 2023-06-23
Concept: Effective Dating for Expense Rate Tables

Concept: Effective Dating for Expense Rate Tables

The effective date for an expense rate table is the date that you configure on the rate table for an expense item. You can create effective-dated rate changes without creating new expense items and expense rate tables. Workday sets all expense rate tables created before the effective dating feature release with the effective date of 1900-01-01.
Workday uses the expense rate table based on either:
  • The transaction date of the expense report line.
  • The start date of the spend authorization.
You can use an expense item such as mileage from year to year when you create an expense rate table with a new effective date. Each version of an expense rate table must always have the same criteria such as a list of travel cities for per diem rates.
You don't have to maintain multiple versions of expense items when you add an effective date on an expense rate table. When workers create or edit an expense report, they can specify an expense item and Workday determines the correct reimbursement rate based on the transaction date. If you copy an expense rate table, you must link the rate table to its own expense item because you can only use an expense rate table once for each expense item.
Workday displays a history of your updates on the
Effective Date History
tab of the
View Expense Rate Table
report.

Example: Hotel Rates

Global Modern Services uses the GSA hotel rates and in some cities the GSA rate changes during the year. The hotel rate for Paris is 250 EUR from 2014-10-01 to 2015-05-31. As of 2015-06-01, the rate goes up to 300 EUR and then the rate goes back to 250 EUR beginning 2015-09-01.
The administrator accesses the
Edit Expense Rate Table
task and selects the
International Hotel Rates by City
expense rate table and specifies a new
Effective Date
to create a new version of the rate table with the effective date 2015-09-01.