What You'll Learn: This article is intended for Editors in Operational Budgeting. It explains what you need to know to import a CSV file with monthly values into the Worksheet.
When to Read This: During an import of updated statistics for accounts and itemizations through CSV.
There are 4 main steps to importing. Select any of the steps below to navigate directly to that section.
- Start the Process
- Select the Data Source
- Fill out the Template
- Import Values and Itemizations
Navigate to the Import Template
If you use ClearGov’s monthly budgeting feature, importing a CSV file makes updating monthly values quick and effortless. You can export your current monthly figures from the Worksheet, make bulk adjustments in Excel, and upload the file back into the Worksheet, saving you from editing accounts one by one.
- Navigate to the Operational Budgeting Worksheet and select the Import button.
- Choose CSV File - Monthly Values.
- Select Continue to Next Step button.
Data Source - Download a Template
Select to download a pre-filled or empty template. The pre-filled template will be populated with the monthly data from the Operational Budgeting Worksheet.
Fill out the Template
Adjust values in the pre-filled template or complete the empty template. The columns in the template will correspond to the Worksheet.
The template below is an example:
Import Columns
- Account ID - Must be entered exactly as it appears in the Worksheet. New accounts cannot be added via this import; they must be submitted through the ClearGov Data Request Form.
- Account Description - Must be entered exactly as how it appears in your ClearGov Data. If you are using the row for an itemization, you can leave the Account Description blank.
- Itemization Description - Itemization Description is only used for itemizations.
- FYXX In Progress Annual Shape - The name of your Shape (template) e.g. Winter Utilities Peak. Note: If a shape is displayed, only an annual value needs to be entered.
- FYXX In Progress Value - The account level budget statistic in the yellow, In Progress column of the Worksheet.
- FYXX In Progress [month] - The account level budget statistic (monthly value) that contributes to the annual total.
Preview the Import
In the Import screen, you can edit directly into the import wizard by typing or copy and pasting columns or rows of data. Hover over any yellow highlight to view additional information.
Submit the Import
Select the Submit button to complete the process!
- Once the import is complete, you can navigate back to the Worksheet to locate the updated accounts, itemizations, and budget statistics.
- Lastly, select the Save button to save this version of the Operational Budget. Note: Saving will remove the Revert ability.
Note: If you import into an open request round, completing the approval process will save the imported values. Or you can choose to save a version in an open round, but be aware that it saves a version of all in-progress values.
Additional Resources:
Looking for additional information about importing into the Operational Budgeting Worksheet?
Check out our other training articles:
- Training article: Import Personnel Budgeting to Operational
- Training article: Import Capital Budgeting to Operational
- Training article: Import from the Onboarding Tool
Have more questions or need assistance?
Submit a Request