Allocating Investment Revenue / Expenses to Funds

Each quarter, when the Investment summary is received from Genus, complete the following steps to allocate Investment earnings and fees to the applicable funds (Long-Term DAFs, specific Programs / Projects, and Operations):

  1. Open the prior month investment worksheet
  2. Save As: “YYYY-MM Investment Allocation” in Box
  3. Edit the worksheet to include the new month’s information:
    • Enter the Investment Management Fee amounts from the monthly Genus Statement
    • Enter any Unrealized/Realized Gains and Losses from the monthly Genus Statement
    • Enter any Investment Income from the quarterly Genus Statement
  4. Run the NetSuite Saved Search “MakeWay Legacy Fund Balances (Investment Allocation) for the date range ending the previous period:
    • Enter the Legacy Fund Balances
    • Calculate the The Foundation Long-Term portion of investment based on the total portfolio
  5. Save the worksheet
  6. Open tab “CSV – Monthly Fees & OH”
    • Copy tab to a new workbook
      • Right click tab > Move or Copy
      • Select (new book) from the “To Book” dropdown
      • Click “Create a Copy”
      • Click “OK” and a new workbook will open
    • Save As: “YYYY-MM Investment Fees & OH.csv”
      • Type = “CSV (comma delimited)”
  7. Open tab “CSV – Quarterly Income”
    • Repeat Step 6
  8. Open tab “CSV – Realized Gains”
    • Repeat Step 6
  9. Once the files are saved, open NetSuite
  10. Navigate to “Setup > Import/Export > Saved CSV Imports”
  11. Select Saved CSV Import “EW – Investment Allocation Entries”
  12. Follow the standard import process:
    1. Scan and Upload CSV – Browse and select CSV file
    2. Import Options – No change
    3. File Mapping – No change
    4. Field Mapping – No change
    5. Save Mapping & Start Import – Click the down arrow and “Run”
  13. Click “View Import Status”
    • Sort by Date (highest to lowest), if necessary, to bring your import to the top of the list
    • Refresh the report until the Status = Complete
    • Review the Message, it should be “1 of 1 records imported successfully”
      • If the import is NOT successful, download the “CSV Response”, correct the error, and start again at Step 10
    • If the Import is successful, review the Journal Entries
      • Financial > Other > Make Journal Entries > List
      • View the Journal Entries you imported
    • Submit the Journal Entry to the Assistant Controller for posting