Dynamic Expense Field Filtering lets administrators control which Expense Field items are visible to specific teams and users. This ensures users see only relevant options when creating expenses.
Prerequisites
- You are an administrator in SVB T&E.
- At least one Expense Field exists.
- Expense Field items have been configured.
- Team Fields and Employees have been configured.
Configure Sub Item Visibility
Use sub item visibility to control which Employees or Team Fields can see specific sub items within an Expense Field.
For example, if your organization uses a Project Expense Field that contains Project Alpha, Project Beta, and Project Gamma. You can assign Project Alpha and Project Beta to the Marketing team and Project Gamma to the Finance team.
- Navigate to Company Settings, by clicking the gear icon in the top right corner.
- In the left navigation menu, select Expense Fields.
- Select the Edit button next to the Expense Field you want to configure.
- Under Field Visibility, select Everyone or Specified (Team Fields).
Check Add sub item visibility.
*Please Note: If you do not check Add sub item visibility, each sub item follows the parent Expense Field visibility setting.
- Select the sub item visibility type:
- User: Assign visibility to individual employees.
- Team Field: Assign visibility to Team Fields.
- Select Save.
A Sub Item Visibility (User) or Sub Item Visibility (Team Field) column displays on the Expense Field.
- Select the Edit button next to the sub-item you want to configure.
- From the dropdown list, select one or more users or Team Fields that should have access to the sub item.
*Please Note: If you do not select any users or Team Fields for a sub item, the sub item follows the parent Expense Field visibility setting.
- Select Save.
Only the selected users or Team Fields can view the sub item when creating an expense.
Import Visibility Assignments
Use a CSV file to create or update Expense Field item visibility assignments in bulk.
First complete the sub item visibility setup before downloading the CSV template. This ensures that the correct template downloads.
Download the CSV Template
- After enabling the sub item visibility on your desired expense field on the Expense Field page of Company Settings,
- Select Upload Template arrow icon.
- Select Download template.
The CSV template will download to your device
Upload Visibility Assignments
- Open the CSV file.
- Enter your values and ensure all required columns are complete.
- Select Upload CSV for the desired Expense Field.
- Drag your CSV file into the upload area or select CHOOSE A FILE.
- Review the details in the Update Your Items window.
- Select Preview changes to review the changes.
- Optional: Check the box to deactivate existing items that are not included in the CSV.
- Select Apply.
- Select CONFIRM MY CHANGES.
The system validates the file and uploads the items to the applicable columns.
*Please Note: Use CSV uploads when you're managing a large number of Expense Field items.