Managing Complexes and Other Entities

Intro

Users with appropriate rights can add fund complexes, fund groups, classes and series to the Arc Suite database, as well as edit their associated properties, via the “Funds” page.

Funds, classes and series can also be added to the database on this page.

Certain functionality in this application area requires you to have one or more . For more information about any given right (i.e., what functionality it governs, etc.), please see the “Available User Rights” topic.

Tasks

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Funds” item.

      “Funds” page
    3. Select any existing complex from the left pane of the page, and then click the “Add Sibling” button at lower-left of the left pane of the page (if there are no existing complexes in your database, simply click the “Add Sibling” button).
    4. Specify a “Complex Name”, “Complex Legal Name” and a “Complex Code” for the new complex in the detail pane at right of the page.

    5. Designate the “Default Language” for the complex.

      1. Abbreviation Libraries ArcReporting only)
      2. Category Libraries
      3. Financial Workbook Templates, “Financial Statement Templates” tab (ArcReporting only)
      4. Footnote Libraries - General Ledger (ArcReporting only)
      5. Footnote Libraries - Holdings
      6. Portfolio Statement Templates
      7. Project Templates
      8. Security Libraries
      9. Tabular Data Templates
      10. Text Libraries
    6. Select the “Active” check box option.

    7. Click the “Save” button at lower-right of the page.

      A “Default fund group” item is automatically created in association with each new complex created.

      “Funds” page (default fund group addition for new complexes)

      The “Fund Group Name” of the new fund group item, as well as its associated “Description” and “Fund Group Code”, can be edited in the detail pane at right of the page.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Funds” item.

      “Funds” page
    3. Select any existing complex from the left pane of the page, and then click the “Add Child” button at lower-left of the left pane of the page.
    4. Specify a “Fund Group Name”, “Description” and a “Fund Group Code” for the new fund group in the detail pane at right of the page.

    5. Click the “Save” button at lower-right of the page.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Funds” item.

      “Funds” page
    3. Select any existing complex from the left pane of the page to reveal the fund group(s) contained therein.

    4. Select any existing fund group, and then click the “Add Child” at lower-left of the left pane of the page.
      “Funds” page, new fund addition

    5. Provide all information pertaining to the new fund on the “Fund” at right of the page.
      “Funds” page, “Fund” tab

    6. Click the “Fund Information” at right of the page, select the “Active” check box option, and then specify an inception date for the fund.
      “Funds” page, “Fund Information” tab

    7. Click the “Ancillary Fund Information” at right of the page, and then specify the desired fund-specific text for each ancillary fund information record.
      “Funds” page, “Ancillary Fund Information” tab

      Ancillary fund information data points are defined via the “Ancillary Fund Information” page.

    8. Click the “Fund Types” at right of the page, and then drag-and-drop the appropriate fund type(s) from the right pane to the left.
      “Funds” page, “Fund Types” tab

    9. Click the “Attributes” at right of the page, and then add one or more attributes in association with the fund using the “Add” button at lower-left of the tab.
      “Funds” page, “Attributes” tab

    10. Click the “Filings Info” at right of the page.
      “Funds” page, “Filings Info” tab
      1. Specify the “Securities Act File Number” for filings in the corresponding text box.
      2. Use the “Category” drop-down list to specify the category associated with the fund.

    11. Click the “Accountants” at right of the page.
      “Funds” page, “Accountants” tab
      1. Drag the accountant(s) to be associated with the fund from the “Available Accountants” pane at right of the tab to the “Assigned Accountants” pane at left.

    12. Click the “Advisers” at right of the page.
      “Funds” page, “Advisers” tab
      1. Drag the adviser(s) to be associated with the fund from the “Available Advisers” pane at right of the tab to the “Assigned Advisers” pane at left.

    13. Click the “Administrators” at right of the page.
      “Funds” page, “Administrators” tab
      1. Drag the administrator(s) to be associated with the fund from the “Available Administrators” pane at right of the tab to the “Assigned Administrators” pane at left.

    14. Click the “Agents” at right of the page.
      “Funds” page, “Agents” tab
      1. Drag the agent(s) to be associated with the fund from the “Available Agents” pane at right of the tab to the “Assigned Agents” pane at left.

    15. Click the “Sub-Advisers” at right of the page.
      “Funds” page, “Sub-Advisers” tab
      1. Drag the sub-adviser(s) to be associated with the fund from the “Available Sub-Advisers” pane at right of the tab to the “Assigned Sub-Advisers” pane at left.

    16. Click the “Fund Relationship Types” at right of the page, and then drag-and-drop the appropriate relationship type(s) from the right pane to the left.
      “Funds” page, “Fund Relationship Types” tab

    17. Click the “Save” button at lower-right of the page.

    As an alternative to manually entering fund information one record at a time via the associated application page, you can import multiple fund records at once using an Excel (XLS) source file. Follow these steps to do so:

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Funds” item.

      “Funds” page

    3. Click the “Get import template” at lower-right of the pane where existing items are listed to retrieve an Excel import file template.
      “Funds” page, “Get Import Template” dialogue
      1. Select the “Fund” option.

      2. Click the “Accept” button at lower-right of the dialogue.

        “File Download” dialogue (Funds data import)
        1. Click the “Open” button to open the template within Microsoft Excel.
        2. Or, click the “Save” button, and then specify a local or network directory in which to store the template.
    4. Use Excel’s “Save As...” command to create your data import file, giving it a unique and meaningful name (e.g., “FundImport_20101231.xls”).
    5. Populate your new file with information for as many fund records as you’d like to import, and then save it (see the “Funds Import File Structure” table for specifics).

    6. Click the “Import data” at lower-right of the pane where existing items are listed to import data contained in your Excel source file.
      “Funds” page, “Import Data” dialogue
      1. Select the “Fund” option.

      2. Click the “Accept” button at lower-right of the dialogue.

        “Funds Import” dialogue

        1. Select your import file using the “Browse” at right of the “File” field.
          “Funds Import” dialogue, import file and options selection

        2. Specify the you’d like to use.

          1. Specify whether only new records in your file should be imported to the database, or whether any records it has that match existing database records should also be imported.

            Existing records will be overwritten by those contained in your file if you choose the latter option!

        3. Click the “Preview” button at lower-right of the “Options” section.

        4. Click the “Accept” button at lower-right of the dialogue.

    You can go to the dataload “Archive” page at any time to see the result of the import process by clicking the corresponding “View Details” link.

    1. Expand the ArcFiling “N-MFP” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcFiling” from the .
        Landing page components list (ArcFiling)

      3. Click the “Filings Workspace” at lower-left of the screen.
        “Filings Workspace” tab

      4. Click the “N-MFP” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        •

          1. Click the “[Select Date]” text or “»” symbol.

            Selection bar: date selection component

          2. Click the “[Select Complex]” text or “»” symbol.

            Selection bar: complex selection component

            If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

            Selection bar: fund group selection component

            Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

            Selection bar: “All Fund Groups” selection option

            If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

            Selection bar: fund selection component

            Alternatively, you can specify “All Funds”.

            Selection bar: “All Funds” selection option

            If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          Selection bar: selection complete
          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        •

          1. Click the selection button at upper-left of the window.

            Selection button

            If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

            Selection button auto-expansion by selected date
          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

    2. Click the “Fund Information” item.

      “Fund Information” page
    3. To add or modify a value associated with the selected fund, simply type in the corresponding field.

    4. Click the “Save” button at lower-right of the page.

    Fund balance information can be loaded utilizing the secure FTP site process. See the “Transferring Load Files via Secure FTP” topic for details on using this method.

    Be sure to select and upload the source data to the FundBalance for the type of source file you’re using in the FTP directory for your respective environment.
    FTP client (“FundBalance” load file drop folder)

    As an alternative to manually entering fund balance information one record at a time via the associated application page or using the secure FTP load process, you can import multiple fund records at once, along with their associated information, using an Excel (XLS) source file. Follow these steps to do so:

    1. Expand the ArcFiling “N-MFP” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcFiling” from the .
        Landing page components list (ArcFiling)

      3. Click the “Filings Workspace” at lower-left of the screen.
        “Filings Workspace” tab

      4. Click the “N-MFP” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        •

          1. Click the “[Select Date]” text or “»” symbol.

            Selection bar: date selection component

          2. Click the “[Select Complex]” text or “»” symbol.

            Selection bar: complex selection component

            If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

            Selection bar: fund group selection component

            Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

            Selection bar: “All Fund Groups” selection option

            If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

            Selection bar: fund selection component

            Alternatively, you can specify “All Funds”.

            Selection bar: “All Funds” selection option

            If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          Selection bar: selection complete
          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        •

          1. Click the selection button at upper-left of the window.

            Selection button

            If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

            Selection button auto-expansion by selected date
          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

    2. Expand the ArcReporting “Financials” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcReporting” from the .
        Landing page components list (ArcReporting)

      3. Click the “Reporting Workspace” at lower-left of the screen.
        “Reporting Workspace” tab

      4. Click the “Financials” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        •

          1. Click the “[Select Date]” text or “»” symbol.

            Selection bar: date selection component

          2. Click the “[Select Complex]” text or “»” symbol.

            Selection bar: complex selection component

            If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

            Selection bar: fund group selection component

            Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

            Selection bar: “All Fund Groups” selection option

            If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

            Selection bar: fund selection component

            Alternatively, you can specify “All Funds”.

            Selection bar: “All Funds” selection option

            If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          Selection bar: selection complete
          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        •

          1. Click the selection button at upper-left of the window.

            Selection button

            If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

            Selection button auto-expansion by selected date
          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

    3. Click the “Fund Information” item.

      “Fund Information” page

    4. Click the “Financial Workbook” item.

      “Financial Workbook” page

    5. Click the “Fund Data Points” .
      “Financial Workbook” page, “Fund Data Points” tab

    6. Click the “Get import template” at lower-right of the pane where existing items are listed to retrieve an Excel import file template.
      “File Download” dialogue (Fund Information data import)
      1. Click the “Open” button to open the template within Microsoft Excel.
      2. Or, click the “Save” button, and then specify a local or network directory in which to store the template.
    7. Use Excel’s “Save As...” command to create your data import file, giving it a unique and meaningful name (e.g., “FundInformationImport_20101231.xls”).
    8. Populate your new file with information for as many exchange rate records as you’d like to import, and then save it (see the “Fund Information Import File Structure” table for specifics).

    9. Click the “Import data” at lower-right of the pane where existing items are listed to import data contained in your Excel source file.
      “Fund Information Import” dialogue

      1. Select your import file using the “Browse” at right of the “File” field.
        “Fund Information Import” dialogue (import file and options selection)

      2. Specify the you’d like to use.

        1. Specify whether only new records in your file should be imported to the database, or whether any records it has that match existing database records should also be imported.

          Existing records will be overwritten by those contained in your file if you choose the latter option!

      3. Click the “Preview” button at lower-right of the “Options” section.

      4. Click the “Accept” button at lower-right of the dialogue.

    You can go to the dataload “Archive” page at any time to see the result of the import process by clicking the corresponding “View Details” link.

    The system automatically rejects any import that contains one or more records associated with a “Closed” account period.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Funds” item.

      “Funds” page
    3. Select any existing complex from the left pane of the page to reveal the fund group(s) contained therein.
    4. Select any existing fund group to reveal the fund(s) contained therein.

    5. Select any existing fund, and then click the “Add Child” button at lower-left of the left pane of the page.

      “Funds” page (class addition)

    6. Provide all information pertaining to the new class in the detail pane at right of the page.

      “Funds” page, “Class” detail pane

      • To activate a class, the “Minimum Initial Investment” field must have a value greater than the default value of “0”.

        To prevent an inactive or closed class of shares from displaying on-screen or in output, regardless of its “Minimum Initial Investment” value, simply clear the “Active” check box for the selected class.

      • The combination of the “Close Date” field value and the “Active” check box setting controls what data displays in project preview and output for each fund and class in a given complex:

        Close Date Active Preview/Output Behavior
        Is within current reporting period Yes Financial data will be displayed
        Is within current reporting period No Financial data will not be displayed
        Is prior to current reporting period Yes Financial data will be displayed
        Is prior to current reporting period No Financial data will not be displayed
        Not provided Yes Financial data will be displayed
        Not provided No Financial data will not be displayed

        If the “Suppress classes closed during the current account period” check box on the “Classes” sub-tab of the “Financial Workbook Templates” page is selected, any class in the financial workbook with a close date prior to the project’s account period will be suppressed, even if the class is marked as “Active” on the “Funds” page.

    7. Click the “Save” button at lower-right of the page.

    As an alternative to manually entering class information one record at a time via the associated application page, you can import multiple class records at once using an Excel (XLSX) source file. Follow these steps to do so:

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Funds” item.

      “Funds” page

    3. Click the “Get import template” at lower-right of the pane where existing items are listed to retrieve an Excel import file template.
      “Get Import Template” dialogue
      1. Select the “Class” option.

      2. Click the “Accept” button at lower-right of the dialogue.

        “File Download” dialogue (Classes data import)
        1. Click the “Open” button to open the template within Microsoft Excel.
        2. Or, click the “Save” button, and then specify a local or network directory in which to store the template.
    4. Use Excel’s “Save As...” command to create your data import file, giving it a unique and meaningful name (e.g., “ClassImport_20181231.xlsx”).
    5. Populate your new file with information for as many class records as you’d like to import, and then save it (see the “Classes Import File Structure” table for specifics).

    6. Click the “Import data” at lower-right of the pane where existing items are listed to import data contained in your Excel source file.
      “Funds” page, “Import Data” dialogue
      1. Select the “Class” option.

      2. Click the “Accept” button at lower-right of the dialogue.

        “Classes Import” dialogue

        1. Select your import file using the “Browse” at right of the “File” field.
          “Classes Import” dialogue (import file and options selection)

        2. Specify the you’d like to use.

          1. Specify whether only new records in your file should be imported to the database, or whether any records it has that match existing database records should also be imported.

            Existing records will be overwritten by those contained in your file if you choose the latter option!

        3. Click the “Preview” button at lower-right of the “Options” section.

        4. Click the “Accept” button at lower-right of the dialogue.

    You can go to the dataload “Archive” page at any time to see the result of the import process by clicking the corresponding “View Details” link.

    1. Expand the ArcFiling “N-MFP” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcFiling” from the .
        Landing page components list (ArcFiling)

      3. Click the “Filings Workspace” at lower-left of the screen.
        “Filings Workspace” tab

      4. Click the “N-MFP” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        •

          1. Click the “[Select Date]” text or “»” symbol.

            Selection bar: date selection component

          2. Click the “[Select Complex]” text or “»” symbol.

            Selection bar: complex selection component

            If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

            Selection bar: fund group selection component

            Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

            Selection bar: “All Fund Groups” selection option

            If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

            Selection bar: fund selection component

            Alternatively, you can specify “All Funds”.

            Selection bar: “All Funds” selection option

            If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          Selection bar: selection complete
          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        •

          1. Click the selection button at upper-left of the window.

            Selection button

            If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

            Selection button auto-expansion by selected date
          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

    2. Click the “Class Information” item.

      “Class Information” page
    3. To add or modify a class-level value, simply type in its corresponding field.

    4. Click the “Save” button at lower-right of the page.

    Class balance information can be loaded utilizing the secure FTP site process. See the “Transferring Load Files via Secure FTP” topic for details on using this method.

    Be sure to select and upload the source data to the ClassBalance for the type of source file you’re using in the FTP directory for your respective environment.
    FTP client (“ClassBalance” load file drop folder)

    As an alternative to manually entering class information one record at a time via the associated application page or using the secure FTP load process, you can import multiple class records at once, along with their associated information, using an Excel (XLS) source file. Follow these steps to do so:

    1. Expand the ArcFiling “N-MFP” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcFiling” from the .
        Landing page components list (ArcFiling)

      3. Click the “Filings Workspace” at lower-left of the screen.
        “Filings Workspace” tab

      4. Click the “N-MFP” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        •

          1. Click the “[Select Date]” text or “»” symbol.

            Selection bar: date selection component

          2. Click the “[Select Complex]” text or “»” symbol.

            Selection bar: complex selection component

            If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

            Selection bar: fund group selection component

            Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

            Selection bar: “All Fund Groups” selection option

            If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

            Selection bar: fund selection component

            Alternatively, you can specify “All Funds”.

            Selection bar: “All Funds” selection option

            If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          Selection bar: selection complete
          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        •

          1. Click the selection button at upper-left of the window.

            Selection button

            If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

            Selection button auto-expansion by selected date
          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

    2. Expand the ArcReporting “Financials” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “ArcReporting” from the .
        Landing page components list (ArcReporting)

      3. Click the “Reporting Workspace” at lower-left of the screen.
        “Reporting Workspace” tab

      4. Click the “Financials” menu to view available items.

        If the “Account Period”, “Complex” and “Fund” relevant to the data you wish to view are not currently selected, choose them using the either selection button at upper-left of the screen or the selection bar across the top of the window.

        •

          1. Click the “[Select Date]” text or “»” symbol.

            Selection bar: date selection component

          2. Click the “[Select Complex]” text or “»” symbol.

            Selection bar: complex selection component

            If only one complex is available based on the specified date, the complex is automatically chosen.

          3. Click the “[Select Group]” text or “»” symbol.

            Selection bar: fund group selection component

            Alternatively, you can specify “All Fund Groups”, which automatically fills in “All Funds” in the step below. Some pages in Arc Suite (e.g., “Fund Holdings”), allow you to view information for more than one fund simultaneously. If a page does not support multiple fund display, then no information displays when “All Fund Groups » All Funds” is specified.

            Selection bar: “All Fund Groups” selection option

            If only one fund group is available based on the specified complex, the group is automatically chosen.

          4. Click the “[Select Fund]” text or “»” symbol.

            Selection bar: fund selection component

            Alternatively, you can specify “All Funds”.

            Selection bar: “All Funds” selection option

            If only one fund is available based on the specified group, the fund is automatically chosen.

          When all elements of the fund selection bar are specified, you have several options available in terms of viewing different sets of data for open pages.

          Selection bar: selection complete
          • Change the specified date. The list of dates is filtered for active projects for the specified fund. Changing the date refreshes the data for all open pages.
          • Change the complex. Changing the complex resets the group, and you’ll need to return to Step 3 above.
          • Change the group. Changing the group resets the fund, and you’ll need to return to Step 4 above.
          • Change the fund. Changing the fund refreshes the data for all open pages.
          • Reset the fund selection bar. Click the “Reset” button at any time to return to Step 1 above.

        •

          1. Click the selection button at upper-left of the window.

            Selection button

            If an account period has already been specified via the fund selection bar (see above), the list under the fund selection button automatically expands that date.

            Selection button auto-expansion by selected date
          2. Click the arrow at left of the desired account period to display the available complex(es) and associated fund group(s) and fund(s).
          3. Specify the “Complex”, “Fund Group” and “Fund” relevant to the project you wish to view.

    3. Click the “Class Information” item.

      “Class Information” page

    4. Click the “Financial Workbook” item.

      “Financial Workbook” page

    5. Click the “Class Balances” .
      “Financial Workbook” page, “Class Balances” tab

    6. Click the “Get import template” at lower-right of the pane where existing items are listed to retrieve an Excel import file template.
      “File Download” dialogue (Class Information data import)
      1. Click the “Open” button to open the template within Microsoft Excel.
      2. Or, click the “Save” button, and then specify a local or network directory in which to store the template.
    7. Use Excel’s “Save As...” command to create your data import file, giving it a unique and meaningful name (e.g., “ClassInformationImport_20101231.xls”).
    8. Populate your new file with information for as many exchange rate records as you’d like to import, and then save it (see the “Class Information Import File Structure” table for specifics).

    9. Click the “Import data” at lower-right of the pane where existing items are listed to import data contained in your Excel source file.
      “Class Information Import” dialogue

      1. Select your import file using the “Browse” button at right of the “field” field.

      2. Click the “Options” to specify which class information properties (if any) to overwrite with values contained in the source file.
        “Class Information Import” dialogue, “Options” tab

        1. Select the “Overwrite values with blanks” check box at the top of the tab to stipulate that a blank value in the data source file will overwrite existing values in the database for any fields whose corresponding “overwrite” check box is selected; if the check box is cleared, blank values that may exist in the data source file will not overwrite existing values in the database.

        • When the check box for any given property is selected, data from the source file for that property will be loaded, even if the source file contains a zero or blank value.

        • For both automated FTP and manual push-button imports, any fields that are absent from the data source file will effectively have their corresponding check box cleared, regardless of the check box’s status on the application user interface.

        You can use the “Select all” or “Clear all” links to quickly select/clear the check boxes.

      3. Click the “Process” to specify whether or not you wish to preview data in the source file before importing.

        1. Preview data before it imports:

          1. Click the “Process” at left of the tab.
            “Class Information Import” dialogue, “Process” tab
            1. Review information for each record included in the import file via the grid of the “Process” tab.

            2. Click the “Errors” to read any information provided for specific rows in the data import source file.
              “Class Information Import” dialogue, “Errors” tab

            3. Click the “Accept” button or “Reject” button at lower-right of the “Process” tab when you’re ready to import the data.

        2. Import data without preview:

          1. Click the “Process” button at left of the tab.

        • Only one file can be imported and processed at a time.

        • The system automatically rejects any import that contains one or more records associated with a “Closed” account period.

    You can go to the dataload “Archive” page at any time to see the result of the import process by clicking the corresponding “View Details” link.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Funds” item.

      “Funds” page
    3. Select any existing complex from the left pane of the page to reveal the fund group(s) contained therein.
    4. Select any existing fund group to reveal the fund(s) contained therein.
    5. Select any existing fund to reveal the class(es) contained therein.
    6. Select any existing class, and then click the “Add Child” button at lower-left of the left pane of the page.
    7. Provide all information pertaining to the new series in the detail pane at right of the page.

    8. Click the “Save” button at lower-right of the page.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Funds” item.

      “Funds” page
    3. Select the desired complex from the listing pane at left of the page to reveal the entities contained therein, and then select the desired fund.

    4. Review and edit information for the selected fund in the “Fund” pane at right of the page.

    5. Click the “Save” button at lower-right of the page if any updates were made.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Fund Types” item.

      “Fund Types” page

    3. Click the “Add” button at lower-right of the page.

    4. Specify a “Name” and a “Description” for the new fund type in the “Detail” pane at right of the page.

    5. Click the “Save” button at lower-right of the page.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Fund Types” item.

      “Fund Types” page

    3. Select the desired item from the “Listing” pane at left of the page.

    4. Review and edit information for the item in the “Detail” pane at right of the page, or directly in the cells of the “Listing” pane at left of the page.

    5. Click the “Save” button at lower-right of the page if any updates were made.

    A listing of records, with certain associated information, can be exported from the application database to any of several different file formats (DOC, HTM, XML, etc.). Follow the steps below to perform a data export.

    1. Click the “Export data” at lower-right of the pane where existing items are listed to export data from the grid.

      1. Select the next to the file format to which you’d like the data saved.

        •  .XML

        •  .DOC

        •  .CSV

        •  .HTM

        •  .TXT

      2. Click the “Accept” button at lower-right of the dialogue.

        1. Specify a local or network directory in which to store the file, and provide a “File name”.
        2. Click the “Save” button.

Creating Complexes and Fund Groups