Set up an expense mileage rates table
Sparkrock Impact includes mileage rate functionality that automates how mileage rates are applied to distance-based expenses. When this functionality is enabled and set up, Sparkrock Impact automatically selects the correct mileage rate based on the Expense Date on the expense and the mileage rate table on the Expense Mileage Rates page of the associated expense type.
For example, Sparkrock Impact calculates the Gross Direct Unit Cost by matching the Expense Date on the expense to the corresponding date range in the mileage rate table of the associated expense type, and then uses the applicable Mileage Rate value divided by 100.
If mileage rate table records have overlapping dates, Sparkrock Impact selects the rate with the nearest From Date before the Expense Date and verifies that the Expense Date is before the To Date.
If no effective mileage rate exists for the Expense Date, Sparkrock Impact displays an error message.
To view the expense mileage rates table for an expense type
Select Search (Alt+Q)
, enter expense types, and then choose the related link.The Expense Types page opens.
Select the expense type for which you want to view the expense mileage rates table, and then on the action bar, choose View.
The Expense Type Card page opens.
On the action bar, choose Prices > Mileage Rate List.
The Expense Mileage Rates page opens.
To add an expense mileage rate record to the expense mileage rates table for an expense type
Select Search (Alt+Q)
, enter expense types, and then choose the related link.The Expense Types page opens.
Select the expense type for which you want to add an expense mileage rates table record, and then on the action bar, choose View.
The Expense Type Card page opens.
On the action bar, choose Prices > Mileage Rate List.
The Expense Mileage Rates page opens.
Choose New.
A new row appears.
Specify values for fields as necessary.
To edit an expense mileage rate record to the expense mileage rates table for an expense type
Select Search (Alt+Q)
, enter expense types, and then choose the related link.The Expense Types page opens.
Select the expense type for which you want to edit an expense mileage rates table record, and then on the action bar, choose View.
The Expense Type Card page opens.
On the action bar, choose Prices > Mileage Rate List.
The Expense Mileage Rates page opens.
Choose Edit List.
Update values for fields as necessary.
To delete an expense mileage rate record from the expense mileage rates table for an expense type
Select Search (Alt+Q)
, enter expense types, and then choose the related link.The Expense Types page opens.
Select the expense type for which you want to delete an expense mileage rates table record, and then on the action bar, choose View.
The Expense Type Card page opens.
On the action bar, choose Prices > Mileage Rate List.
The Expense Mileage Rates page opens.
Select the record that you want to delete, and then choose Delete.
A dialog box appears that displays the following text:
Go ahead and delete?
To proceed, choose Yes.
Related information
Feedback
To send feedback about this page, select the following link: