This article contains steps for entering fund history for each GLID for any date prior to your Balance System Start Date by using an import. Clients in the implementation process can also use this import type during the onboarding process to reset beginning values.

What can be updated via a Fund History Import?

• Historical Gift History

• Market Value or Units History (the historical unit price needs to be populated too) 

• Investment Activity History (Income, Realized Gain/Losses, Unrealized Gain/Losses, Investment Fees)
• Book Value History
• Pledge History
• Spending Bucket History
• Non-Unitized Asset History

Import Instructions

1. Navigate to Import/Export on the left side panel in your database.

2. Select 'Create new import' button towards the top right corner of the page.

   

    
3. Select the "Fund History" import type from the drop down and click the Continue button.
4. Download the template for the import by clicking the 'Download Fund History template' button.

   

   Note: You need to download a new template the first time you use this import in the Balance V4 platform. Please do not alter the headers at all or you will get an error about header formatting. 

5. Populate the template with your updates. You only need to populate the Post Date, GLID, and the corrected value(s) in the appropriate column(s). 

6. Once you've completed your template, save locally and use the Browse button to select the file to be uploaded. Once the file has been selected, click on Upload to bring that file into Balance. Your changes will appear in a view only table. Click Approve Import to commit your additions/updates. 
    

   

    

7. A confirmation box will pop-up, click 'Yes, approve import' to continue.

   

    

8. You will then receive confirmation indicating the import was approved.
    

   

    

Resetting Beginning Values (Implementation)

You can use the Fund History import to correct values that were previously loaded during the implementation process. You can update as many GLIDs as you'd like with this template, and as few as one. You only need to populate the Post Date, GLID, and the corrected value(s) in the appropriate column(s). 

Items to Note:

• Post Date must be your System Start Date.
• You must re-open all periods back to your System Start Date.
• If you are changing beginning balances as of your start date (a locked historical date) and the overall market value of your pool is also changing, you MUST first import your new pool market values using the Investment Manager History Import. If you have the manager module, then update your Manager beginning balances using the Investment Manager History import. If the overall market value of your pool as of your load date does not change (just changes between funds) then you do not need to first upload the Pool History or Manager History imports. 

 

Import Errors

Any records that are corrupt or have no matching GLID number in Balance will generate an error. The error message will indicate the reason the file did not load successfully. You can Download the error list and click Show/Hide rows to see the error details. Follow the instructions in the interface to correct the error. The user will have to fix these errors and upload the file again. The import only processes when there are no errors as it is committing the entire file.