Effective dating financial field values

Keeping financial field values up to date is important for ensuring accurate spend reporting. Providing clear timelines for when a value applies helps run business operations smoothly.

By effective dating a financial field value, as a program office user, you assign a specific date on which a particular value becomes effective using the Data Import tool. For example, you might want to set the effective date to match the engagement’s start date if your financial field value was configured after the engagement started or correct a misconfigured value.

After your updates are processed, corrections are automatically applied to the timesheets associated with the updated engagements.

Steps

To effective date financial field values, complete these steps.

Create a template that you can use with the Import Data tool.
1. Open a new Microsoft Excel file.
2. Add these columns to your template:
  - Field Reference ID
  - Value Reference ID
  - Engagement ID/Person ID
  - Change Effective Date
  - Change End Date
3. To populate the template, add your values as a separate entry, for example, one row for each financial field that you want to effective date.
4. Save the populated template.
Log in to Professional.
From the left navigation, go to Home and select Import Data.
In the Data object field, select Engagement (Retroactive Change).
In the Note field, enter a description of your import to help you find it faster in the import monitoring logs.
Select Continue and upload the business site template.
Follow the instructions in the Bulk add WORKERS page to confirm the column headers row and mapping of the fields.
Optional: To review any potential errors, turn on the Only show rows with problems toggle in the review section. If errors exist, you can hover over each error to view advice on resolving it. After you resolve the errors, select Continue.
Optional: You can verify your changes by reviewing the details of any engagements you have modified.