...------------------------------------------------- Monthly Galliard Procedure Closely follow the order of the following steps. The order of the steps is critical. 1. Log onto the U.S. Bank website (itcportal.usbank.com). Go to Statements and download the latest monthly statement (available 4 to 6 days after month end). 2. Open Galliard spreadsheet and Save As “Galliard MM-YYYY”. 3. Go to Performance in the CFIF Performance spreadsheet and copy values from columns I through J on Performance tab. 4. Manually enter fees paid during the month in cells C6- C9 and fees accrued in cells E6-E9. Refer to Fees in the CFIF Performance spreadsheet. 5. Go to Cash Detail. Use the U.S. Bank statement to manually enter the cash transaction detail for the month. Do not enter any value in column E as this column is automated. 6. Go to Trades and manually enter trade information. 7. Go to Securities Detail and update column E (price) and column B (date). Find prices for column in E in the US Bank statement. Add any new securities and delete securities that were sold. Tip: To make it easy to update column E, copy over the prices you see on the statement as it is in column G. For example, price might be 98.604. Once you fill in all the prices, type 100 in any empty cell and copy it. Select prices in column G, then Alt E S and divide by. This will divide your prices by 100. You can copy these values in column E. This avoids you manually dividing...
Words: 271 - Pages: 2