This article is intended for: Admins
Use this article for: exporting data to provide to the Data Onboarding team.
After reading this article, you should be able to: Export a data from Black Mountain with the required fields/columns to supply the Data Onboarding team with the needed data for the onboarding process.
Learn how to export data from Black Mountain to be used during the data onboarding process and data updates.
Note: Some Black Mountain clients may have different system functionalities. If these instructions do not apply to your system, Senior Data Advisors can collaborate with users to identify an alternative report that meets their needs.
Black Mountain Software Data Export Instructions
The following instructions will provide you with budget, actuals, and your chart of accounts segment information for data onboarding.
- From the Reports menu, go to Budget Reports, and select Export to ClearGov.
- Enter the applicable Accounting Period. The period entered will affect the amounts displayed in columns G, H, and I of the CLIENT_UPDATE_FINANCIALS.CSV file.
- Enter the Year From-To that should be included in your export file, i.e., the CLIENT_UPDATE_FINANCIALS.CSV file. Select the OK button to start the export process.
- The files will begin exporting, and you will see this progress window.
- Select OK in the confirmation message that appears for each file.
- The following three files will be automatically exported to the C:\BMSfiles folder and can be provided for data onboarding:
- CLIENTNAME_UPDATE_FINANCIALS.CSV
- CLIENTNAME_Expense_segments.CSV
- CLIENT NAME_Revenue_segments.CSV
Have more questions or need assistance?
Submit a Request