What You'll Learn: This article is for Editors using Personnel Budgeting. It explains what you need to know to update Account IDs, split percentages, and benefit options for many vacant positions with one upload.
When to Read This: Read this article after you add your vacant positions.
Update how vacant position costs are allocated across many vacancies at once. For example, you can move the Overtime for every police vacancy to a grant-funded account with a single upload. The import works the same way as the allocation import for filled positions.
There are 3 steps to import vacant position allocations. Select the step below to navigate directly to that section.
Prefer to see it done?
Select Next to move through the guide below. You can also zoom in and out of the image by selecting the Magnifying Glass in the bottom right-hand corner. You can view the full guide by selecting the External Link icon.
Step-By-Step Instructions
Step 1: Download the Template
The template comes filled in with your current vacancies and their allocations, so you only change what you need.
- Navigate to your Personnel Budget and select the Positions tab, then the Vacant Positions sub-tab.
- Select the Import button.
- Select the Import Vacant Position Allocations option.
- Select the Import Data button.
- Download the ClearGov Vacant Position Allocation Template in Step 1.
Note: Vacant positions must already exist in your Personnel Budget to update their allocations. To add new vacancies, review the article: Personnel Budgeting - Add Vacant Positions.
Step 2: Update the Template
Edit the Account IDs, split percentages, and benefit options for each vacancy you want to change.
- Update the Account ID for each wage, additional pay, or benefit you want to change. Enter Account IDs exactly as they appear in the Financials Tool.
- Update the benefit options as needed. Enter each option name exactly as it appears in your Data Model Manager.
- To split an allocation, add another row for the same vacancy with a different Account ID and percentage. Make sure the splits for each item total 100%.
- Save the file as a CSV to your computer.
Pro Tip: Sort or filter the template by job title in your spreadsheet application to update the same item for many vacancies at once.
Step 3: Upload and Review
In Personnel Budgeting, select the Import Vacant Position Allocations button. Upload your completed file, then fix any error cells that are highlighted red.
- Return to the import menu and upload your completed CSV file.
- Review any reported errors, correct them in your file, and upload it again.
- Open a vacancy to confirm the new allocations on its details page.
Ready to Learn More?
- Check out the article: Personnel Budgeting - Import Filled Position Allocations
- Check out the article: Personnel Budgeting - Manage Missing Allocations for Vacant Positions
- Check out the article: Personnel Budgeting - Navigate the Vacancy Details Page
Have more questions or need assistance?
Submit a Request