Daily Checklist

Chisholm & Dames Investment Advisors, Inc. (c) 2012

Post Files

1. Download TIAA-CREF files from the previous day
   1. Login to http://tiaa-cref.org
   2. Click "Client Data Download"
   3. Click "Download Current File"
   4. Expand files to "C:\portfoliocenter-data\tiaa-cref-exports"
   5. Confirm receipt of TIAA-CREF files: (eg. on 2012/10/26)
      • AD121024.SEC
      • AD121024.PRI
      • AD121024.POS
      • AD121024.TRN
   6. Move current .zip file to "C:\portfoliocenter-data\tiaa-cref exports\archives"
   7. Run Fidelity converter program (fidoconvert.py)
2. Confirm receipt of Supplemental Price download: (eg. on 2012/10/26)
   • fi102512.pri
3. Confirm receipt of Fidelity files: (eg. on 2012/10/26)
   • fi102512.acc
   • fi102512.bal
   • fi102512.nam
   • fi102512.pos
   • fi102512.pri
   • fi102512.sec
   • fi102512.trn
4. Open and review Securities
   • Clean up names:
     • If interest rate is > 0% simplify it
       • 0.4500000% -> 0.45%
       • 5.014243% -> 5+%
     • Remove date from title
     • Move any geographical location to comment
     • Expand common abbreviations
   • Lookup CUSIP for further info (http://fixedincome.fidelity.com, etc.)
5. Save any changes
6. Post Securities
7. Open and review Prices
   • Search for anomalies:
     • Sort by Status (look for Error)
     • Sort by Price High (verify indexes and other top performers)
     • Sort by Price Low (verify the usual zeroes, make sure no other securities are missing price)
     • Sort by Type (verify Indexes prices received from supplemental downloads)
8. Save any changes
9. Post Prices
10. Open and review Portfolios
    • Ignore all Update status portfolios
    • Post any Pending status (new account) portfolios
      • Open "Null Entry Prevention/New Accounts" view in Data Manager, and enter data
11. Save any changes
12. Post Portfolios (confirm update overwrite dialog that opens)
13. Confirm no Position files are listed
14. Open and review Transactions *Sort by Activity: - Block or confirm Journals - Confirm Receipt of Securities as new assets - Block Corporate Actions (CA): Splits, Mergers, ROP, Return... - Use Transaction Writer to write CA substitutes - Review and research any warnings or errors
15. Post Transactions
16. Open and run Share Reconciliation Report (Share Rec)
    • Use approprate date
    • Choose portfolio set: Reconcilers (Open Accounts, Customers, No External Holdings)
17. Resolve Quantity Difference issues