We are very pleased to introduce the “Universal Upload” to goalgamiPro to improve your efficiency and offer you more flexibility using the tool. This utility offers the ability to upload excel and csv files of any format to add holdings to your accounts. Rather than conform to a specific file format, you can quickly and easily upload a file to import your account holdings.
Using the Universal Upload
The “Universal Upload” feature allows you to upload holdings to an account that has already been created. So, start by making sure that you have an account set up. Do this by selecting “Add Account” on the Household Details page.
Figure 1: Set up Account
2. Once you have set up your account(s), you are ready to upload holdings. Select the “Import” dropdown on the Household Details page. You will be given different options- select the “Holdings from File Upload” item.
Figure 2: Import Holdings from File Upload
3. This brings you to select “Generalized Upload”. A set of instructions will be presented to you. These outline different rules that are applied in the upload process. We also offer a template for you to use. This is for convenience as you do not need to follow any template.
On this step, simply select the file that you would like to upload from your computer by select ‘browse’.
A few important things to note: First, make sure you include headers to each column. This allows the system to determine the purpose of each column automatically. It also makes it easier for you to organize as you upload.
The only two required fields are Symbols and Shares. We obviously need these to determine the holding and the value. We use the previous day close to calculate the value. We do accept values for the Account number or name, Cost Basis and Purchase date. As stated earlier, the account name or number must match an existing account to be uploaded. Cost Basis and Purchase date are not needed for Retirement Accounts. For Brokerage Accounts, if no Cost Basis is entered, a default Cost Basis of $0.00 will be used and todays date as the purchase date.
Important Note: Indicate a Cash position by using the symbol $CASH in the symbol column."
Figure 3: Select File
4. Once you have selected a file and continued forward, all of your content will be loaded into the Universal Upload. On this step, you let the system know what each column means. We ask you to select from the following (* denotes a required column):
- Account Name
- Account Number
- Cost Basis
- Exclude- note, if the column is not selected, we will automatically exclude.
The system will have already mapped the column to its best guess based on your header rows. You may always change by using the dropdown.
Once you have selected the correct rows, hit ‘Next’. If you made a mistake with the upload and need to add another column or row, hit ‘Go Back’ to return to the previous step.
Figure 4: Map Columns
5. Step 3 asks you to validate your accounts. On this step, you map the account(s) that were loaded to accounts that have already been created.
In the example used, we did not indicate an “Account Name”, so the system is alerting me that it imported three rows, but has no name (Figure 5). To continue, you must map to an existing account using the dropdown. Had I elected to import multiple accounts, I would have imported an account name or number (in order to distinguish the accounts). It would appear as we see on Figure 6.
Figure 5: Account Validation (Single Account)
Figure 6: Account Validation (Multiple Accounts)
6. Finally, we reach the holdings validation. This step will only appear if you have an invalid holding. You are notified here of invalid securities. If the security appears in red, then it will not be imported. You must correct it manually by selecting edit from the Household .
Once you select ‘Import’, all of your holdings will be imported to the selected account. Note that these holdings will over