Accounting Procedures Handbook

PENSION/BENEFITS 17.3 TRUST AND AGENCY FUNDS 3. Adjust print range for quarterly reporting. 4. Repeat for County Plan. Combined Summary 1. Add column to spreadsheet for current quarter and hide columns to display 8 most recent quarters; 2. Link General account and Disbursement account total to respective sheet; 3. Enter Investment manager’s balance; 4. Revise print range for quarterly reporting; 5. Repeat for County Plan. Benchmark Analysis 1. Retrieve Aetna/Aetna benchmark revised.xls; 2. Copy & insert date ranges for new data; 3. Enter Index returns and portfolio returns by date range; 4. Revise print range for quarterly reporting; 5. Repeat for County Plan. Quarterly report package 1. Print final pages of each schedule – see attached cover sheet; 2. Retrieve MS Word Aetna/notice {YYMM} encl.doc 3. Revise and save as new document 4. Copy sets for 9 trustees, Comptroller and any meeting guests C. Aetna Retirement Plan- Wire Transfers to Aetna Accounts The purpose of this activity is to transfer funds from the BANK OF NEW YORK custodial account to the Aetna General (Regular) account or SA 174 for post 2/1/98 retirees. 1. Funds must be transferred to account SA 174 to maintain a two-month escrow or to fund a retiree’s lump sum distribution. a. Aetna customer service personnel may fax a letter re: an estimated deficit. b. Month end statements will confirm the deficit 2. Funds must be transferred to the General account due to the annuity allocation being less than the General Account balance at month end. a. Aetna customer service personnel may fax a letter re: an estimated deficit. b. Month end statements will confirm the deficit. 3. Request for funding SA 174; a. Retrieve the last letter in Word Aetna\BANK OF NEW YORK\sa174{YYMM}.doc. Wire instructions are accurate unless revised. b. Change date, amount requested by Aetna and amount determined to be transferred, e.g., rounding. Save letter with “save-as” prompt. c. Print, sign & fax letter to BANK OF NEW YORK Custody Services asper letter. Make copy for file. d. Mail signed original with copy of Aetna fax on reverse e. Email letter to Croft-Leominster, Inc. 4. Request for funding General Account; a. Retrieve the last letter in Word Aetna\Bank of New York\sa174{YYMM}GA.doc. Wire instructions are accurate unless revised. b. Change date, amount requested by Aetna and amount determined to be transferred,