Viewing General Ledger Account Transactions

Intro

The “General Ledger Transactions” page displays transactions made against general ledger accounts, as determined by user-specified search criteria. Transactional information such as the before and after account balance, editing user, memo, date/time, etc. is shown in the report. Transactions are sorted by date/time by default, but you can group, sort or filter search results by any field in the results grid.

You can also reverse selected account adjustments using the “Reverse Batch” functionality also available 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 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.

    2. Click the “General Ledger Transactions” item.

      “General Ledger Transactions” page

      To easily view transactions that are specific to accounts in a particular financial workbook, just click the “View General Ledger Transactions” link on the “Financial Workbook” page to open the “General Ledger Transactions” page.

    3. Set for the transaction(s) you wish to view.
      1. To filter out any reversed or reversal transactions from the results grid, select the “Exclude reversed/reversal transactions in search results” check box.
      • At least one search filter must be set before the “Search” button at right of the “Search Criteria” section becomes enabled.
      • Complexes available for selection in the “Complex” drop-down list are limited to those to which you have been granted access via the “Users” page.

    4. Click the “Search” button at right of the “Search Criteria” section.

    5. To create an opposite journal entry for each adjustment in a given transaction batch, select a row in the results grid that represents an account adjustment in that batch, and then click the “Create Opposite Entry” at lower-right of the page.

      1. Specify a “Memo” for the entry in the corresponding text box on the dialogue.

        The default value of the text box is the “Memo” value of the transaction that was selected in the grid before clicking the “Create Opposite Entry” link.

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

    6. To reverse all transactions in a given batch, select a row in the results grid that represents an account adjustment in that batch for an open account period, and then click the “Reverse Batch” at lower-right of the page.
      1. If desired, specify a “Memo” for the entry in the corresponding text box on the dialogue.

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

    You can sort, group and filter information in a grid through in order to find what you’re looking for more easily.
    (sample grid)

    1. Filtering: You can filter the items presented in a grid by using the “Filter” at the top of any column.
      1. To remove any particular column filter, click the “Filter” button at the top of that column, and then click the “Clear Filter” button on the filter criteria dialogue that displays.

      2. To remove all column filters for the grid at once, click the “Clear all filters” button at upper-left of the grid.

        The “Clear all filters” button is not available on all Arc Suite grids.

        • The “Clear all filters” button is not available on all Arc Suite grids.
        • Column filtering only affects the rows that have been loaded in the grid. If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), be sure all available rows have been loaded if you expect column filtering to affect all securities in the data set.
    2. Sorting: You can sort items in a grid by clicking any column header. Once sorted, the column header will change color and indicate whether the list is sorted in ascending or descending order.

    3. Grouping: In some grids, the items can be grouped in the display by selecting a column header, and then dragging it into the of a grid.
      1. To expand or collapse a grouping, click the buttons, respectively, at left of the grouping row in the grid.

      2. To remove a grouping, hover your cursor over the grouping box, and then click the “Remove” that displays on its right.
        Application grid grouping removal
    4. Grid Splitting: Grids feature a vertical splitter bar, which you can grab and move over the line dividing any two columns. As you scroll horizontally to see more columns of data, the columns to the left of the splitter bar are “frozen” in view.

    5. Pagination: Some grids feature a “Rows Per Page” spinner control at lower-left, which you can use to specify the maximum number of records/rows to display in the grid at once. If the number of records in the database meeting the specified criteria exceeds the specified “Rows Per Page” value, a set of navigation controls at lower-right of the grid is enabled to allow access to the records in successive grid “pages”.

      If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), the value specified for the associated “FundHoldingsGridPageSize” setting will determine the upper limit of the “Rows Per Page” spinner control, as well as how many rows are loaded at once to the grid.

    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.

    1. 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.

    2. Click the “General Ledger Transactions” item.

      “General Ledger Transactions” page

      To easily view transactions that are specific to accounts in a particular financial workbook, just click the “View General Ledger Transactions” link on the “Financial Workbook” page to open the “General Ledger Transactions” page.

    3. Set criteria for the transaction(s) you wish to view.

      • At least one search filter must be set before the “Search” button at right of the “Search Criteria” section becomes enabled.
      • Complexes available for selection in the “Complex” drop-down list are limited to those to which you have been granted access via the “Users” page.

    4. Click the “Search” button at right of the “Search Criteria” section.

    5. Select (click once with the left mouse button) any row in the grid that represents an account adjustment within the transaction batch you wish to reverse.

      Transaction batches for closed account periods cannot be reversed. Consequently, the “Reverse Batch” link is disabled when a row representing an account adjustment for a closed account period is selected.

    6. Click the “Reverse Batch” link at lower-right of the page.

      The “Reverse Batch” link may be used only one time against any given batch. If you click the link when a batch of either “Reversed” or “Reversal” is selected in the results grid, you will be prompted with the option to create an “opposite entry”, instead.

    7. Click the “OK” button on the message dialogue.

      “Reverse Batch” dialogue

    8. Click the “Accept” button on the dialogue to effect the reversal of the selected transaction batch.

      Clicking the “Cancel” button on the dialogue causes it to close, and for no reversal of adjustments to be made.

      • An opposite journal entry for each adjustment in the batch is created and booked.

        • The adjustment made is of the opposite type (i.e., a debit becomes a credit, and a credit becomes a debit).
        • The “Transaction Source” value for each entry is set to “Reverse”.
        • The “Editing User” value for each entry is set to the name of the user who performed the reversal.
      • A new batch number is created and associated with each new journal entry made.

      • The following information is placed in the “Memo” field for the new batch:

        “Reversed Batch #<Batch Number of reversed batch> : <Memo text of reversed batch>[: <Reversal memo text (if provided)>]”

        “Reversed Batch #1: As of trade: As of trade was canceled.”

      • The “Reversed/Reversal” value of the original (reversed) batch is set to “Reversed”.
      • The “Reversed/Reversal” value of the new (reversal) batch is set to “Reversal”.
      • The results grid of the “General Ledger Transactions” page refreshes so that the new batch and associated entries display in the grid (assuming they meet the specified “Search Criteria”).
      • The “Status” of the financial workbook associated with the fund and account period is set to “Not Calculated”.

    You can sort, group and filter information in a grid through in order to find what you’re looking for more easily.
    (sample grid)

    1. Filtering: You can filter the items presented in a grid by using the “Filter” at the top of any column.
      1. To remove any particular column filter, click the “Filter” button at the top of that column, and then click the “Clear Filter” button on the filter criteria dialogue that displays.

      2. To remove all column filters for the grid at once, click the “Clear all filters” button at upper-left of the grid.

        The “Clear all filters” button is not available on all Arc Suite grids.

        • The “Clear all filters” button is not available on all Arc Suite grids.
        • Column filtering only affects the rows that have been loaded in the grid. If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), be sure all available rows have been loaded if you expect column filtering to affect all securities in the data set.
    2. Sorting: You can sort items in a grid by clicking any column header. Once sorted, the column header will change color and indicate whether the list is sorted in ascending or descending order.

    3. Grouping: In some grids, the items can be grouped in the display by selecting a column header, and then dragging it into the of a grid.
      1. To expand or collapse a grouping, click the buttons, respectively, at left of the grouping row in the grid.

      2. To remove a grouping, hover your cursor over the grouping box, and then click the “Remove” that displays on its right.
        Application grid grouping removal
    4. Grid Splitting: Grids feature a vertical splitter bar, which you can grab and move over the line dividing any two columns. As you scroll horizontally to see more columns of data, the columns to the left of the splitter bar are “frozen” in view.

    5. Pagination: Some grids feature a “Rows Per Page” spinner control at lower-left, which you can use to specify the maximum number of records/rows to display in the grid at once. If the number of records in the database meeting the specified criteria exceeds the specified “Rows Per Page” value, a set of navigation controls at lower-right of the grid is enabled to allow access to the records in successive grid “pages”.

      If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), the value specified for the associated “FundHoldingsGridPageSize” setting will determine the upper limit of the “Rows Per Page” spinner control, as well as how many rows are loaded at once to the grid.

    1. 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.

    2. Click the “General Ledger Transactions” item.

      “General Ledger Transactions” page

      To easily view transactions that are specific to accounts in a particular financial workbook, just click the “View General Ledger Transactions” link on the “Financial Workbook” page to open the “General Ledger Transactions” page.

    3. Set criteria for the transaction(s) you wish to view.

      • At least one search filter must be set before the “Search” button at right of the “Search Criteria” section becomes enabled.
      • Complexes available for selection in the “Complex” drop-down list are limited to those to which you have been granted access via the “Users” page.

    4. Click the “Search” button at right of the “Search Criteria” section.

    5. Select (click once with the left mouse button) any row in the grid that represents an account adjustment within the transaction batch you wish to create an opposite entry.

    6. Click the “Create Opposite Entry” link at lower-right of the page.

      “Create Opposite Entry” dialogue

    7. Click the “Accept” button on the dialogue to effect the creation of an opposite entry of the selected transaction batch.

      Clicking the “Cancel” button on the dialogue causes it to close, and no new entry is made.

      • An opposite journal entry for each adjustment in the batch is created and booked.

        • The adjustment made is of the opposite type (i.e., a debit becomes a credit, and a credit becomes a debit).
        • The “Transaction Source” value for each entry is set to “Manual Entry”.
        • The “Editing User” value for each entry sets to the name of the user who made the entry.
      • A new batch number is created and associated with each new journal entry made.
      • The text entered in the “Memo” multi-line text box is placed in the “Memo” field for the new batch.
      • The “Reversed/Reversal” value of the new batch is <blank> (i.e., no value is set).
      • The “Status” of the financial workbook associated with the fund and account period is set to “Not Calculated”.
      • The results grid of the “General Ledger Transactions” page refreshes so that the new batch and associated entries display in the grid (assuming they meet the specified “Search Criteria”).
      • The “Status” of the financial workbook associated with the fund and account period of the batch is set to “Not Calculated”.

    You can sort, group and filter information in a grid through in order to find what you’re looking for more easily.
    (sample grid)

    1. Filtering: You can filter the items presented in a grid by using the “Filter” at the top of any column.
      1. To remove any particular column filter, click the “Filter” button at the top of that column, and then click the “Clear Filter” button on the filter criteria dialogue that displays.

      2. To remove all column filters for the grid at once, click the “Clear all filters” button at upper-left of the grid.

        The “Clear all filters” button is not available on all Arc Suite grids.

        • The “Clear all filters” button is not available on all Arc Suite grids.
        • Column filtering only affects the rows that have been loaded in the grid. If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), be sure all available rows have been loaded if you expect column filtering to affect all securities in the data set.
    2. Sorting: You can sort items in a grid by clicking any column header. Once sorted, the column header will change color and indicate whether the list is sorted in ascending or descending order.

    3. Grouping: In some grids, the items can be grouped in the display by selecting a column header, and then dragging it into the of a grid.
      1. To expand or collapse a grouping, click the buttons, respectively, at left of the grouping row in the grid.

      2. To remove a grouping, hover your cursor over the grouping box, and then click the “Remove” that displays on its right.
        Application grid grouping removal
    4. Grid Splitting: Grids feature a vertical splitter bar, which you can grab and move over the line dividing any two columns. As you scroll horizontally to see more columns of data, the columns to the left of the splitter bar are “frozen” in view.

    5. Pagination: Some grids feature a “Rows Per Page” spinner control at lower-left, which you can use to specify the maximum number of records/rows to display in the grid at once. If the number of records in the database meeting the specified criteria exceeds the specified “Rows Per Page” value, a set of navigation controls at lower-right of the grid is enabled to allow access to the records in successive grid “pages”.

      If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), the value specified for the associated “FundHoldingsGridPageSize” setting will determine the upper limit of the “Rows Per Page” spinner control, as well as how many rows are loaded at once to the grid.

  • General ledger transaction 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 GLTransactions for the type of source file you’re using in the FTP directory for your respective environment.
      FTP client (“GLTransactions” load file drop folder)

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

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

    1. 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.

    2. Click the “Financial Workbook” item.

      “Financial Workbook” page
    3. Click any tab in the workbook that represents a working trial balance.

    4. 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 (General Ledger Transactions 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.
    5. Use Excel’s “Save As...” command to create your data import file, giving it a unique and meaningful name (e.g., “GeneralLedgerTransactionsImport_20131231.xls”).
    6. Populate your new file with information for as many transaction records as you’d like to import, and then save it (see the “General Ledger Transactions Import File Structure” table for specifics).

    7. Click the “Import data” at lower-right of the pane where existing items are listed to import data contained in your Excel source file.
      “General Ledger Transactions Import” dialogue
      1. Select your import file using the “Browse” button at right of the “File” field.

      2. 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.
            “General Ledger Transactions 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.
              “General Ledger Transactions 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.

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

        • 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 “Process” link.

    1. Expand the ArcFiling “Production Utilities” .

      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 “Production Utilities” menu to view available items.

    2. Expand the ArcReporting “Production Utilities” .

      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 “Production Utilities” menu to view available items.

    3. Click the “Dataload Status” item.

      “Dataload Status” widget
    4. Use the “Funds to view” drop-down list to specify the scope of dataload information displayed.
    5. Expand the grid groupings to see the status of any data import for a specific fund.
    • A fund displays in the dashboard grid when it is part of a project that is associated with the account period specified in the “Fund Selection” bar.
    • You cannot not rearrange columns in the grid.
    • Arc Suite does not remember user-specified grid settings, such as column width and filters, once the current session has ended.

    • Searching/Filtering

      • Data returned in the dashboard’s results grid is based on the specific complex and account period designated in the “Fund Selection” bar.
      • Data in the results grid may be narrowed further, if desired, through use of the grid’s column header filter functionality.
      • By default, load information is displayed for the fund(s) to which you have been granted access (this is determined by the complex(es) assigned via the “Users” page in the “Environment Administration” area).

    • Auto-Refresh

      • The results grid refreshes automatically after 3 minutes, or if you manually refresh the page by clicking the “Refresh” button at the top of the widget.

        • If you change the “Fund Selection” bar settings, the page does not automatically refresh; you must manually refresh the page.
      • Each results grid refresh generates a date and time stamp of when the refresh occurred.

    • Grouping

      • The default grouping of data in the results grid for the specified account period is by “Complex” (ascending), then by “Fund Group” (ascending).
      • The default view has all groupings collapsed.
      • You can expand a grouping by clicking on its horizontal grouping bar in the grid.

    • Visual Indicators

      • Each grouping in the grid displays fields for all the possible dataloads/imports, along with a visual indicator of the status of each.

        • Red () indicates that no funds in the group have successfully loaded data.
        • Yellow () indicates that some funds in the group have successfully loaded data.
        • Green () indicates that all funds in the group have successfully loaded data.

      • Expanding the grouping to the fund level provides you with a view of dataload status for the funds.

        • Red () indicates that the fund has not successfully loaded data.
        • Green () indicates that the fund has successfully loaded data.

    • Export

      • Data in the dashboard grid is exportable in all standard output types (.xml, .csv, .txt, .doc, .htm).
      • Clicking the “Export data” button at lower-right of the widget allows you to choose the desired output type and save the file to a local or network drive.

    A project contains 2 funds (“Cash Reserves Money Market” and “U.S. Treasury Money Market”) for the 05/31/2012 account period.

    • Prior to importing/loading any data, the dashboard displays a status that effectively indicates, “No funds in the group have successfully loaded data”.

      “Dataload Status” widget (no funds loaded)

    • After loading Holdings and Repo Collateral data for the “Cash Reserves Money Market” fund, the dashboard displays a “Loaded” indicator for those imports for that fund.

      “Dataload Status” widget (“Loaded” indicator display)

      • Money Market Complex (level)

        • Fund Information, Class Information, GL Balances, GL Transactions indicate no funds in the complex have data loaded for the respective imports ().
        • Holdings and Repo Collateral indicate some funds have successfully loaded data for the respective imports ().

      • Money Market Fund Group (level)

        • Fund Information, Class Information, GL Balances, GL Transactions indicate no funds in the complex have data loaded for the respective imports ().
        • Holdings and Repo Collateral indicate some funds have successfully loaded data for the respective imports ().

      • Cash Reserves Money Market Fund (level)

        • Fund Information, Class Information, GL Balances, GL Transactions indicate no funds in the complex have data loaded for the respective imports ().
        • Holdings and Repo Collateral indicate Cash Reserves Money Market Fund has successfully loaded data for the respective imports ().

      • U.S. Treasury Reserves Money Market Fund (level)

        • Fund Information, Class Information, GL Balances, GL Transactions indicate no funds in the complex have data loaded for the respective imports ().
        • Holdings and Repo Collateral indicate U.S. Treasury Reserves Money Market Fund has not successfully loaded data for the respective imports ().

    • After loading data for all imports for both the “Cash Reserves Money Market” and “U.S. Treasury Money Market” funds, the dashboard displays a “Loaded” indicator for those imports for those funds.

      “Dataload Status” widget (“Loaded” indicator display)

      If these funds were included in a project in ArcReporting and the GL Balances and GL Transactions data were loaded, the corresponding status indicators would also be green ()

    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.

    You can sort, group and filter information in a grid through in order to find what you’re looking for more easily.
    (sample grid)

    1. Filtering: You can filter the items presented in a grid by using the “Filter” at the top of any column.
      1. To remove any particular column filter, click the “Filter” button at the top of that column, and then click the “Clear Filter” button on the filter criteria dialogue that displays.

      2. To remove all column filters for the grid at once, click the “Clear all filters” button at upper-left of the grid.

        The “Clear all filters” button is not available on all Arc Suite grids.

        • The “Clear all filters” button is not available on all Arc Suite grids.
        • Column filtering only affects the rows that have been loaded in the grid. If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), be sure all available rows have been loaded if you expect column filtering to affect all securities in the data set.
    2. Sorting: You can sort items in a grid by clicking any column header. Once sorted, the column header will change color and indicate whether the list is sorted in ascending or descending order.

    3. Grouping: In some grids, the items can be grouped in the display by selecting a column header, and then dragging it into the of a grid.
      1. To expand or collapse a grouping, click the buttons, respectively, at left of the grouping row in the grid.

      2. To remove a grouping, hover your cursor over the grouping box, and then click the “Remove” that displays on its right.
        Application grid grouping removal
    4. Grid Splitting: Grids feature a vertical splitter bar, which you can grab and move over the line dividing any two columns. As you scroll horizontally to see more columns of data, the columns to the left of the splitter bar are “frozen” in view.

    5. Pagination: Some grids feature a “Rows Per Page” spinner control at lower-left, which you can use to specify the maximum number of records/rows to display in the grid at once. If the number of records in the database meeting the specified criteria exceeds the specified “Rows Per Page” value, a set of navigation controls at lower-right of the grid is enabled to allow access to the records in successive grid “pages”.

      If grid pagination functionality is enabled for the “Holdings” tab of the “Fund Holdings” page (via the “FundHoldingsGridPagination” system setting), the value specified for the associated “FundHoldingsGridPageSize” setting will determine the upper limit of the “Rows Per Page” spinner control, as well as how many rows are loaded at once to the grid.

  • Various user interfaces (pages) within Arc Suite allow you to view and edit the values of data points that have been loaded into the database and/or mapped in the output settings for portfolio and financial statements.

    The information in the tables below serves as a cross reference between data points that are loaded and/or mapped and the respective user interfaces that allow for viewing/editing of the data point values. The tables also denote which data points are shared by ArcFiling and ArcReporting and demonstrate if the data points are referenced differently between the two products.

    • Fund Data Points ()
      Fund Data Point Name ArcReporting User Interface ArcFiling User Interface Environment Administration User Interface
      7-day gross yield (as of the month end) Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > 7-day Gross Yield Filings Workspace > N-MFP > Fund Information > Item A.19 - 7-day gross yield (as of the month end) (ArcFiling or ArcReporting)
      Abbreviation (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Fund Information tab > Abbreviation
      CIK (Environment Administration) Filings Workspace > N-MFP > Part A: Fund/Class Setup > CIK Number of Registrant Environment Administration > Settings > Funds > Fund > CIK
      Close Date (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Fund Information tab > Close Date
      Currency Code (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Fund Information tab > Currency Code
      Dollar Weighted Average Life Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Dollar Weighted Average Life Filings Workspace > N-MFP > Fund Information > Item A.12 - Dollar Weighted Average Life (ArcFiling or ArcReporting)
      Dollar Weighted Average Maturity Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Dollar Weighted Average Maturity Filings Workspace > N-MFP > Fund Information > Item A.11 - Dollar Weighted Average Maturity (ArcFiling or ArcReporting)
      EDGAR Series Identifier (Environment Administration) Filings Workspace > N-MFP > Part A: Fund/Class Setup > EDGAR Series Identifier Environment Administration > Settings > Funds > Fund > EDGAR Series Identifier
      Fund Code (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Fund Code
      Fund Display Name 1 (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Fund Display Name 1
      Fund Display Name 2 (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Fund Display Name 2
      Fund Legal Name (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Fund Legal Name
      Fund Name (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Fund Name
      Inception Date (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Fund Information tab > Inception Date
      Legal Entity (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Legal Entity
      Net value of other assets Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Value of Other Assets Filings Workspace > N-MFP > Fund Information > Item A.14.c (ArcFiling or ArcReporting)
      Net value of other liabilities Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Value of Other Liabilities Filings Workspace > N-MFP > Fund Information > Item A.15 (ArcFiling or ArcReporting)
      Net value of the series Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Net Assets Filings Workspace > N-MFP > Fund Information > Item A.16 (ArcFiling or ArcReporting)
      N-MFP Category (ArcFiling) Filings Workspace > N-MFP > Part A: Fund/Class Setup > Item A.10 - Category (ArcFiling)
      Securities Act File Number (Environment Administration) Filings Workspace > N-MFP > Part A: Fund/Class Setup > Item A.1 - Securities Act File Number Environment Administration > Settings > Funds > Fund > Filings Info > Securities Act File Number
      Total value of portfolio securities at amortized cost Reporting Workspace > Financials > Financial Workbook > Fund Data Points tab > Value of Total Investments Filings Workspace > N-MFP > Fund Information > Item A.14.b.i (ArcFiling or ArcReporting)

    • Class Data Points ()
      Class Data Point Name ArcReporting User Interface ArcFiling User Interface Environment Administration User Interface
      1 Year Expense Ratio Reporting Workspace > Financials > Financial Workbook > Class Balances tab > 1 Year Expense Ratio (ArcReporting) (ArcReporting)
      6 Month Expense Ratio Reporting Workspace > Financials > Financial Workbook > Class Balances tab > 6 Month Expense Ratio (ArcReporting) (ArcReporting)
      7-day net yield (shown as %) Reporting Workspace > Financials > Financial Workbook > Class Balances tab > 7-day net yield (Show as %) Filings Workspace > N-MFP > Class Information > Item B.7 - 7-day net yield (show as %) (ArcFiling or ArcReporting)
      Average Net Assets - 1 Year Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Average Net Assets - 1 Year (ArcReporting) (ArcReporting)
      Average Net Assets - 6 Months Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Average Net Assets - 6 Months (ArcReporting) (ArcReporting)
      Base Class (Environment Administration) (Environment Administration) Environment Administration > Settings > Base Classes > Base Class Name
      Class Display Name 1 (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Class Display Name 1
      Class Display Name 2 (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Class Display Name 2
      Class Name (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Class Name
      CUSIP (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > CUSIP
      Description (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Description
      Distributions in Excess of Net Investment Income Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Distributions in Excess of Net Investment Income (ArcReporting) (ArcReporting)
      Dividends Reinvested Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Dividends Reinvested (ArcReporting) (ArcReporting)
      Dividends Reinvested - Shares Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Dividends Reinvested - Shares (ArcReporting) (ArcReporting)
      EDGAR Class Identifier (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > EDGAR Class Identifier
      Expense Cap Percentage (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Expense Cap Percentage
      Gross Redemptions Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Gross Redemptions Filings Workspace > N-MFP > Class Information > Item B.6.f.ii - Gross Redemptions (ArcFiling or ArcReporting)
      Gross Subscriptions (Including dividend reinvest) Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Gross Subscriptions (Including dividend reinvest) Filings Workspace > N-MFP > Class Information > Item B.6.f.i - Gross Subscriptions (Including dividend reinvest) (ArcFiling or ArcReporting)
      Inception Date (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Inception Date
      Load Code (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Load Code(s)
      Maximum Back End Load (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Maximum Back End Load
      Maximum Front End Load (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Maximum Front End Load
      Minimum Initial Investment (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Minimum Initial Investment
      NAV Reporting Workspace > Financials > Financial Workbook > Class Balances tab > NAV Filings Workspace > N-MFP > Class Information > Item B.5 - NAV (ArcFiling or ArcReporting)
      Net Assets of the Class Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Net Assets of the Class Filings Workspace > N-MFP > Class Information > Item B.3 - Net Assets of the Class (ArcFiling or ArcReporting)
      Net Investment Income Distributed Per Share Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Net Investment Income Distributed Per Share (ArcReporting) (ArcReporting)
      Net Shareholder activity for the month Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Net Shareholder activity for the month Filings Workspace > N-MFP > Class Information > Net Shareholder activity for the month (ArcFiling or ArcReporting)
      Par Value (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Par Value
      POP (Public Offering Price) Reporting Workspace > Financials > Financial Workbook > Class Balances tab > POP (Public Offering Price) (ArcReporting) (ArcReporting)
      Prospectus Ratio (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Prospectus Ratio
      Realized Gains Distributed Per Share Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Realized Gains Distributed Per Share (ArcReporting) (ArcReporting)
      Redemption Fee (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Redemption Fee
      Redemptions Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Redemptions (ArcReporting) (ArcReporting)
      Redemptions - Exchanges Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Redemptions - Exchanges (ArcReporting) (ArcReporting)
      Redemptions - Exchanges - Shares Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Redemptions - Exchanges - Shares (ArcReporting) (ArcReporting)
      Redemptions - Shares Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Redemptions - Shares (ArcReporting) (ArcReporting)
      Security Class (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Security Class
      SEDOL (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > SEDOL
      Shares Outstanding Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Shares Outstanding (ArcReporting) (ArcReporting)
      Subscriptions Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Subscriptions (ArcReporting) (ArcReporting)
      Subscriptions - Exchanges Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Subscriptions - Exchanges (ArcReporting) (ArcReporting)
      Subscriptions - Exchanges - Shares Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Subscriptions - Exchanges - Shares (ArcReporting) (ArcReporting)
      Subscriptions - Shares Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Subscriptions - Shares (ArcReporting) (ArcReporting)
      Ticker (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Ticker
      Total Return - 1 Month Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 1 Month (ArcReporting) (ArcReporting)
      Total Return - 1 Year Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 1 Year (ArcReporting) (ArcReporting)
      Total Return - 2 Year Annualized Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 2 Year Annualized (ArcReporting) (ArcReporting)
      Total Return - 2 Year Cumulative Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 2 Year Cumulative (ArcReporting) (ArcReporting)
      Total Return - 3 Month Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 3 Month (ArcReporting) (ArcReporting)
      Total Return - 3 Year Annualized Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 3 Year Annualized (ArcReporting) (ArcReporting)
      Total Return - 3 Year Cumulative Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 3 Year Cumulative (ArcReporting) (ArcReporting)
      Total Return - 4 Year Annualized Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 4 Year Annualized (ArcReporting) (ArcReporting)
      Total Return - 4 Year Cumulative Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 4 Year Cumulative (ArcReporting) (ArcReporting)
      Total Return - 5 Year Annualized Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 5 Year Annualized (ArcReporting) (ArcReporting)
      Total Return - 5 Year Cumulative Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 5 Year Cumulative (ArcReporting) (ArcReporting)
      Total Return - 6 Month Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 6 Month (ArcReporting) (ArcReporting)
      Total Return - 6 Year Annualized Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 6 Year Annualized (ArcReporting) (ArcReporting)
      Total Return - 6 Year Cumulative Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 6 Year Cumulative (ArcReporting) (ArcReporting)
      Total Return - 7 Year Annualized Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 7 Year Annualized (ArcReporting) (ArcReporting)
      Total Return - 7 Year Cumulative Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 7 Year Cumulative (ArcReporting) (ArcReporting)
      Total Return - 8 Year Annualized Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 8 Year Annualized (ArcReporting) (ArcReporting)
      Total Return - 8 Year Cumulative Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 8 Year Cumulative (ArcReporting) (ArcReporting)
      Total Return - 9 Month Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 9 Month (ArcReporting) (ArcReporting)
      Total Return - 9 Year Annualized Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 9 Year Annualized (ArcReporting) (ArcReporting)
      Total Return - 9 Year Cumulative Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 9 Year Cumulative (ArcReporting) (ArcReporting)
      Total Return - 10 Year Annualized Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 10 Year Annualized (ArcReporting) (ArcReporting)
      Total Return - 10 Year Cumulative Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - 10 Year Cumulative (ArcReporting) (ArcReporting)
      Total Return - Since Inception Annualized Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - Since Inception Annualized (ArcReporting) (ArcReporting)
      Total Return - Since Inception Cumulative Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Total Return - Since Inception Cumulative (ArcReporting) (ArcReporting)
      Transfer Agent Code (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Class > Transfer Agent Code
      Turnover % Reporting Workspace > Financials > Financial Workbook > Class Balances tab > Turnover % (ArcReporting) (ArcReporting)

    • Holdings Data Points ()
      Holdings Data Point Name ArcReporting User Interface ArcFiling User Interface Environment Administration User Interface
      144A Reporting Workspace > Portfolio > Fund Holdings > 144A (ArcReporting) (ArcReporting)
      Account Period (Environment Administration) (Environment Administration) Environment Administration > Settings > Account Periods > Period End
      Accrued Interest Reporting Workspace > Portfolio > Fund Holdings > Accrued Interest (ArcReporting) (ArcReporting)
      Affiliated Reporting Workspace > Portfolio > Fund Holdings > Affiliated (ArcReporting) (ArcReporting)
      AM Best Credit Rating Reporting Workspace > Portfolio > Fund Holdings > AMBest Credit Rating Filings Workspace > N-MFP > Fund Holdings > Item C.10 - AMBest Credit Rating (ArcFiling or ArcReporting)
      Balance Instance Reporting Workspace > Portfolio > Fund Holdings > Balance Instance Filings Workspace > N-MFP > Fund Holdings > Balance Instance (ArcFiling or ArcReporting)
      Base Currency Bought Reporting Workspace > Portfolio > Fund Holdings > Currency Bought - Base (ArcReporting) (ArcReporting)
      Base Currency Sold Reporting Workspace > Portfolio > Fund Holdings > Currency Sold - Base (ArcReporting) (ArcReporting)
      Base Unit Price Reporting Workspace > Portfolio > Fund Holdings > Unit Price - Base (ArcReporting) (ArcReporting)
      Bought Reporting Workspace > Portfolio > Fund Holdings > Bought (ArcReporting) (ArcReporting)
      Caption

      Administration > Reporting Libraries > Security/Investment Master > Security Name

      Reporting Workspace > Portfolio > Fund Holdings > Caption

      Administration > Filing Libraries > Security/Investment Master > Security Name

      Filings Workspace > N-MFP > Fund Holdings > Item C.2 - Title of Issue

      		 (ArcFiling or ArcReporting)
      Category Caption Reporting Workspace > Portfolio > Fund Holdings > All Categories Assigned to the Fund Filings Workspace > N-MFP > Fund Holdings > Item C.6 - Category of Investment (ArcFiling or ArcReporting)
      Category Notes N/A Filings Workspace > N-MFP > Fund Holdings > Item C.6 - Description N/A
      CIK Reporting Workspace > Portfolio > Fund Holdings > Issuer CIK Filings Workspace > N-MFP > Fund Holdings > Item C.1 - Name of the Issuer (ArcFiling or ArcReporting)
      Class Reporting Workspace > Portfolio > Fund Holdings > Class (ArcReporting) (ArcReporting)
      Collateral Reporting Workspace > Portfolio > Fund Holdings > Collateral (ArcReporting) (ArcReporting)
      Collateral Reporting Workspace > Portfolio > Fund Holdings > Fully Collateralized Repo (ArcReporting) (ArcReporting)
      Commitments Reporting Workspace > Portfolio > Fund Holdings > Commitments (ArcReporting) (ArcReporting)
      Contract Rate Reporting Workspace > Portfolio > Fund Holdings > Contract Rate (ArcReporting) (ArcReporting)
      Cost Reporting Workspace > Portfolio > Fund Holdings > Cost (ArcReporting) (ArcReporting)
      Counterparty Reporting Workspace > Portfolio > Fund Holdings > Counterparty (ArcReporting) (ArcReporting)
      Coupon Rate Reporting Workspace > Portfolio > Fund Holdings > Coupon Filings Workspace > N-MFP > Fund Holdings > Item C.2 - Coupon (ArcFiling or ArcReporting)
      Coupon Rate Type Reporting Workspace > Portfolio > Fund Holdings > Coupon Rate Type (ArcReporting) (ArcReporting)
      Currency Code Reporting Workspace > Portfolio > Fund Holdings > Currency Code (ArcReporting) (ArcReporting)
      Currency Code Purchased Reporting Workspace > Portfolio > Fund Holdings > Currency Code Purchased (ArcReporting) (ArcReporting)
      Currency Code Sold Reporting Workspace > Portfolio > Fund Holdings > Currency Code Sold (ArcReporting) (ArcReporting)
      CUSIP

      Administration > Reporting Libraries > Security Libraries > Security Captions tab > CUSIP

      Reporting Workspace > Portfolio > Fund Holdings > CUSIP

      Administration > Filing Libraries > Security Libraries > Security Captions tab > CUSIP

      Filings Workspace > N-MFP > Fund Holdings > Item C.3 - CUSIP

      		 (ArcFiling or ArcReporting)
      Custom Identifier

      Administration > Reporting Libraries > Security Libraries > Security Captions tab > Custom Identifier

      Administration > Security Libraries > Security Captions tab > Custom Identifier

      Reporting Workspace > Portfolio > Fund Holdings > Custom Identifier

      Filings Workspace > N-MFP > Fund Holdings > Item C.5.c - Other Unique Identifier

      		 (ArcFiling or ArcReporting)
      Day To Maturity Reporting Workspace > Portfolio > Fund Holdings > Days To Maturity (ArcReporting) (ArcReporting)
      DBRS Credit Rating Reporting Workspace > Portfolio > Fund Holdings > DBRS Credit Rating Filings Workspace > N-MFP > Fund Holdings > Item C.10 - DBRS Credit Rating (ArcFiling or ArcReporting)
      DemandFeatureIssuerNRSROList (ArcFiling) Filings Workspace > N-MFP > Fund Holdings > Item C.14.e - Designated NRSRO for Demand Feature(s) or provider(s) (ArcFiling )
      DemandFeatureIssuerNRSRORatingList (ArcFiling) Filings Workspace > N-MFP > Fund Holdings > Item C.14.e - Rating for each Designated NRSRO (ArcFiling)
      DemandFeatureList (ArcFiling) Filings Workspace > N-MFP > Fund Holdings > Item C.14.a - Demand Feature Issuer(s) (ArcFiling)
      Description 01 Reporting Workspace > Portfolio > Fund Holdings > Description 1 (ArcReporting) (ArcReporting)
      Description 02 Reporting Workspace > Portfolio > Fund Holdings > Description 2 (ArcReporting) (ArcReporting)
      Description 03 Reporting Workspace > Portfolio > Fund Holdings > Description 3 (ArcReporting) (ArcReporting)
      Description 04 Reporting Workspace > Portfolio > Fund Holdings > Description 4 (ArcReporting) (ArcReporting)
      Description 05 Reporting Workspace > Portfolio > Fund Holdings > Description 5 (ArcReporting) (ArcReporting)
      Description 06 Reporting Workspace > Portfolio > Fund Holdings > Description 6 (ArcReporting) (ArcReporting)
      Description 07 Reporting Workspace > Portfolio > Fund Holdings > Description 7 (ArcReporting) (ArcReporting)
      Description 08 Reporting Workspace > Portfolio > Fund Holdings > Description 8 (ArcReporting) (ArcReporting)
      Description 09 Reporting Workspace > Portfolio > Fund Holdings > Description 9 (ArcReporting) (ArcReporting)
      Description 10 Reporting Workspace > Portfolio > Fund Holdings > Description 10 (ArcReporting) (ArcReporting)
      Display On Condensed Reporting Workspace > Portfolio > Fund Holdings > Display On Condensed (ArcReporting) (ArcReporting)
      Egan Jones Credit Rating Reporting Workspace > Portfolio > Fund Holdings > Egan Jones Credit Rating Filings Workspace > N-MFP > Fund Holdings > Item C.10 - Egan Jones Credit Rating (ArcFiling or ArcReporting)
      EnhancementProviderList (ArcFiling) Filings Workspace > N-MFP > Fund Holdings > Item C.16.a - Identity of enhancement provider(s) (ArcFiling)
      EnhancementProviderNRSROList (ArcFiling) Filings Workspace > N-MFP > Fund Holdings > Item C.16.d - Designated NRSRO for the enhancement(s) or provider(s) (ArcFiling)
      EnhancementProviderNRSRORatingList (ArcFiling) Filings Workspace > N-MFP > Fund Holdings > Item C.16.d - Rating for each Designated NRSRO (ArcFiling)
      EnhancementTypeList (ArcFiling) Filings Workspace > N-MFP > Fund Holdings > Item C.16.b - Type of enhancement(s) (ArcFiling)
      Exchange Rate Reporting Workspace > Portfolio > Fund Holdings > Exchange Rate (ArcReporting) (ArcReporting)
      Expiration Date Reporting Workspace > Portfolio > Fund Holdings > Expiration Date (ArcReporting) (ArcReporting)
      Fair Value Level Reporting Workspace > Portfolio > Fund Holdings > Fair Value Level (ArcReporting) (ArcReporting)
      Fair Value Type Reporting Workspace > Portfolio > Fund Holdings > Fair Value Type (ArcReporting) (ArcReporting)
      Fair Valued Reporting Workspace > Portfolio > Fund Holdings > Fair Valued (ArcReporting) (ArcReporting)
      Final Legal Maturity Date Reporting Workspace > Portfolio > Fund Holdings > Final Legal Maturity Date Filings Workspace > N-MFP > Fund Holdings > Item C.12 - Maturity Date (WAL) (ArcFiling or ArcReporting)
      Fitch Credit Rating Reporting Workspace > Portfolio > Fund Holdings > Fitch Credit Rating Filings Workspace > N-MFP > Fund Holdings > Item C.10 - Fitch Credit Rating (ArcFiling or ArcReporting)
      Fixed Interest Reporting Workspace > Portfolio > Fund Holdings > Fixed Interest (ArcReporting) (ArcReporting)
      Floating Interest Reporting Workspace > Portfolio > Fund Holdings > Floating Interest (ArcReporting) (ArcReporting)
      Fund Code (Environment Administration) (Environment Administration) Environment Administration > Settings > Funds > Fund > Fund Code
      GuarantorList (ArcFiling) Filings Workspace > N-MFP > Fund Holdings > Item C.15.a - Identity of guarantor(s) (ArcFiling)
      GuarantorNRSROList (ArcFiling) Filings Workspace > N-MFP > Fund Holdings > Item C.15.c - Designated NRSRO for the guarantor(s) (ArcFiling)
      GuarantorNRSRORatingList (ArcFiling) Filings Workspace > N-MFP > Fund Holdings > Item C.15.c - Rating for each Designated NRSRO (ArcFiling)
      Has Demand Feature Reporting Workspace > Portfolio > Fund Holdings > Has Demand Feature Filings Workspace > N-MFP > Fund Holdings > Item C.14 - Security has Demand Feature (ArcFiling or ArcReporting)
      Has Enhancement Reporting Workspace > Portfolio > Fund Holdings > Has Enhancement Filings Workspace > N-MFP > Fund Holdings > Item C.16 - Security have any enhancements (ArcFiling or ArcReporting)
      Has Guarantee Reporting Workspace > Portfolio > Fund Holdings > Has Guarantee Filings Workspace > N-MFP > Fund Holdings > Item C.15 - Security has a guarantee (ArcFiling or ArcReporting)
      Illiquid Security Reporting Workspace > Portfolio > Fund Holdings > Illiquid Security Filings Workspace > N-MFP > Fund Holdings > Item C.23 - Illiquid Security (ArcFiling or ArcReporting)
      In Default Reporting Workspace > Portfolio > Fund Holdings > In Default (ArcReporting) (ArcReporting)
      Investment Type

      Administration > Reporting Libraries > Security/Investment Master > Investment Type

      Reporting Workspace > Portfolio > Fund Holdings > Investment Type

      		 Administration > Filing Libraries > Security/Investment Master > Investment Type (ArcFiling or ArcReporting)
      ISIN

      Administration > Reporting Libraries > Security Libraries > Security Captions tab > ISIN

      Reporting Workspace > Portfolio > Fund Holdings > ISIN

      		 Administration > Filing Libraries > Security Libraries > Security Captions tab > ISIN (ArcFiling or ArcReporting)
      Issuer Reporting Workspace > Portfolio > Fund Holdings > Issuer Caption (ArcReporting) (ArcReporting)
      JCR Credit Rating Reporting Workspace > Portfolio > Fund Holdings > JCR Credit Rating Filings Workspace > N-MFP > Fund Holdings > Item C.10 - JCR Credit Rating (ArcFiling or ArcReporting)
      LACE Credit Rating Reporting Workspace > Portfolio > Fund Holdings > Kroll Credit Rating (FKA LACE) Filings Workspace > N-MFP > Fund Holdings > Item C.10 - Kroll Credit Rating (FKA LACE) (ArcFiling or ArcReporting)
      Language Code Reporting Workspace > Portfolio > Fund Holdings > Language (ArcReporting) (ArcReporting)
      Local Cross Trade Reporting Workspace > Portfolio > Fund Holdings > Local Cross Trade (ArcReporting) (ArcReporting)
      Local Currency Bought Reporting Workspace > Portfolio > Fund Holdings > Currency Bought - Local (ArcReporting) (ArcReporting)
      Local Currency Sold Reporting Workspace > Portfolio > Fund Holdings > Currency Sold - Local (ArcReporting) (ArcReporting)
      Local Unit Price Reporting Workspace > Portfolio > Fund Holdings > Unit Price - Local (ArcReporting) (ArcReporting)
      Market Value Reporting Workspace > Portfolio > Fund Holdings > Market Value (ArcReporting) (ArcReporting)
      Market Value Ask Reporting Workspace > Portfolio > Fund Holdings > Market Value Ask (ArcReporting) (ArcReporting)
      Market Value Bid Reporting Workspace > Portfolio > Fund Holdings > Market Value Bid (ArcReporting) (ArcReporting)
      Master Identifier Administration > Reporting Libraries > Security/Investment Master > Master Identifier

      Administration > Filing Libraries > Security/Investment Master > Master Identifier

      Filings Workspace > N-MFP > Fund Holdings > Master Identifier

      		 (ArcFiling or ArcReporting)
      Maturity Date Reporting Workspace > Portfolio > Fund Holdings > Maturity Date Filings Workspace > N-MFP > Fund Holdings > Item C.11 - Maturity Date (WAM) (ArcFiling or ArcReporting)
      Moodys Credit Rating Reporting Workspace > Portfolio > Fund Holdings > Moody’s Credit Rating Filings Workspace > N-MFP > Fund Holdings > Item C.10 - Moody’s Credit Rating (ArcFiling or ArcReporting)
      Multiplier Reporting Workspace > Portfolio > Fund Holdings > Multiplier (ArcReporting) (ArcReporting)
      NMFP Notes Reporting Workspace > Portfolio > Fund Holdings > Explanatory Notes Filings Workspace > N-MFP > Fund Holdings > Item C.24 - Explanatory Notes (ArcFiling or ArcReporting)
      Non Income Reporting Workspace > Portfolio > Fund Holdings > Non Income (ArcReporting) (ArcReporting)
      Notional Amount Reporting Workspace > Portfolio > Fund Holdings > Notional Amount (ArcReporting) (ArcReporting)
      On Loan Reporting Workspace > Portfolio > Fund Holdings > On Loan (ArcReporting) (ArcReporting)
      Option Premium Reporting Workspace > Portfolio > Fund Holdings > Option Premium (ArcReporting) (ArcReporting)
      Other Credit Rating 1 Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 1 (ArcReporting) (ArcReporting)
      Other Credit Rating 2 Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 2 (ArcReporting) (ArcReporting)
      Other Credit Rating 3 Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 3 (ArcReporting) (ArcReporting)
      Other Credit Rating 4 Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 4 (ArcReporting) (ArcReporting)
      Other Credit Rating 5 Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 5 (ArcReporting) (ArcReporting)
      Other Credit Rating 6 Reporting Workspace > Portfolio > Fund Holdings > Other Credit Rating 6 (ArcReporting) (ArcReporting)
      Pay Type Reporting Workspace > Portfolio > Fund Holdings > Pay Type (ArcReporting) (ArcReporting)
      Perpetual Reporting Workspace > Portfolio > Fund Holdings > Perpetual (ArcReporting) (ArcReporting)
      Position Type Reporting Workspace > Portfolio > Fund Holdings > Position Type (ArcReporting) (ArcReporting)
      Proceeds Reporting Workspace > Portfolio > Fund Holdings > Proceeds (ArcReporting) (ArcReporting)
      Purchase Amount Base Reporting Workspace > Portfolio > Fund Holdings > Purchase Amount Base (ArcReporting) (ArcReporting)
      Purchase Amount Local Reporting Workspace > Portfolio > Fund Holdings > Purchase Amount Local (ArcReporting) (ArcReporting)
      Purchase Cost Reporting Workspace > Portfolio > Fund Holdings > Purchase Cost (ArcReporting) (ArcReporting)
      R&I Credit Rating Reporting Workspace > Portfolio > Fund Holdings > R&I Credit Rating (ArcReporting) (ArcReporting)
      Realpoint Credit Rating Reporting Workspace > Portfolio > Fund Holdings > Morningstar Credit Rating (FKA Realpoint) Filings Workspace > N-MFP > Fund Holdings > Item C.10 - Morningstar Credit Rating (FKA Realpoint) (ArcFiling or ArcReporting)
      Receive Type Reporting Workspace > Portfolio > Fund Holdings > Receive Type (ArcReporting) (ArcReporting)
      Repo Used For Diversification Reporting Workspace > Portfolio > Fund Holdings > Is Repo Used for Diversification Filings Workspace > N-MFP > Fund Holdings > Item C.7 - Is Repo Used for Diversification (ArcFiling or ArcReporting)
      Reset Date Reporting Workspace > Portfolio > Fund Holdings > Reset Date (ArcReporting) (ArcReporting)
      Restricted Reporting Workspace > Portfolio > Fund Holdings > Restricted (ArcReporting) (ArcReporting)
      S&P Credit Rating Reporting Workspace > Portfolio > Fund Holdings > S&P Credit Rating Filings Workspace > N-MFP > Fund Holdings > Item C.10 - S&P Credit Rating (ArcFiling or ArcReporting)
      Security Rating Reporting Workspace > Portfolio > Fund Holdings > Security Rating (ArcReporting) (ArcReporting)
      SEDOL

      Administration > Reporting Libraries > Security Libraries > Security Captions tab > SEDOL

      Reporting Workspace > Portfolio > Fund Holdings > SEDOL

      		 Administration > Filing Libraries > Security Libraries > Security Captions tab > SEDOL (ArcFiling or ArcReporting)
      Series Reporting Workspace > Portfolio > Fund Holdings > Series (ArcReporting) (ArcReporting)
      Shares Reporting Workspace > Portfolio > Fund Holdings > Shares (ArcReporting) (ArcReporting)
      Short Term Debt Reporting Workspace > Portfolio > Fund Holdings > Short-Term Debt (ArcReporting) (ArcReporting)
      Sold Reporting Workspace > Portfolio > Fund Holdings > Sold (ArcReporting) (ArcReporting)
      Sold Amount Base Reporting Workspace > Portfolio > Fund Holdings > Sold Amount Base (ArcReporting) (ArcReporting)
      Sold Amount Local Reporting Workspace > Portfolio > Fund Holdings > Sold Amount Local (ArcReporting) (ArcReporting)
      Source Reporting Workspace > Portfolio > Fund Holdings > Security Balance Source (ArcReporting) (ArcReporting)
      Step-up Bond Reporting Workspace > Portfolio > Fund Holdings > Step-up Bond (ArcReporting) (ArcReporting)
      Strike Price Reporting Workspace > Portfolio > Fund Holdings > Strike Price (ArcReporting) (ArcReporting)
      Strips Reporting Workspace > Portfolio > Fund Holdings > Strips (ArcReporting) (ArcReporting)
      TBA Description Reporting Workspace > Portfolio > Fund Holdings > TBA Description (ArcReporting) (ArcReporting)
      Unrealized Value Reporting Workspace > Portfolio > Fund Holdings > Unrealized (ArcReporting) (ArcReporting)
      Valoren

      Administration > Reporting Libraries > Security Libraries > Security Captions tab > Valoren

      Reporting Workspace > Portfolio > Fund Holdings > Valoren

      		 Administration > Filing Libraries > Security Libraries > Security Captions tab > Valoren (ArcFiling or ArcReporting)
      Variable Rate Reporting Workspace > Portfolio > Fund Holdings > Variable Rate (ArcReporting) (ArcReporting)
      Werkpapier

      Administration > Reporting Libraries > Security Libraries > Security Captions tab > Werkpapier

      Reporting Workspace > Portfolio > Fund Holdings > Werkpapier

      		 Administration > Filing Libraries > Security Libraries > Security Captions tab > Werkpapier (ArcFiling or ArcReporting)
      When-Issued Reporting Workspace > Portfolio > Fund Holdings > When-Issued (ArcReporting) (ArcReporting)
      Yield Reporting Workspace > Portfolio > Fund Holdings > Yield Filings Workspace > N-MFP > Fund Holdings > Item C.17 - Yield (ArcFiling or ArcReporting)
      Yield Date Reporting Workspace > Portfolio > Fund Holdings > Yield Date (ArcReporting) (ArcReporting)
      Zero Coupon Reporting Workspace > Portfolio > Fund Holdings > Zero Coupon (ArcReporting) (ArcReporting)

    1. Expand the ArcFiling “Dataload” .

      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 “Administration” at lower-left of the screen.
        “Administration” tab

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

    2. Expand the ArcReporting “Dataload” .

      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 “Administration” at lower-left of the screen.
        “Administration” tab

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

    3. Click the “Archive” item.

      “Archive” page

    4. Specify to filter the list of archived data load batches.
      1. Use the “From Date” and “To Date” calendar controls to set the date range within which to search (by default, dates in these fields are set to the current date).
      2. You can also narrow search results by load batch “Status” (i.e., “Accepted”, “Accepted with Errors/Warnings” or “Awaiting Processing” or “Rejected”).
      3. You may also filter the list of resulting load batch records by “Load Type” using the corresponding drop-down list.

    5. Click the “Search” button at right of the “Search Criteria” section.

      • Times displayed in the results grid are in Coordinated Universal Time (UTC).

      • Each load batch displays a “Status”, whose possible are as follows:

        • Denotes a batch that was automatically accepted or manually accepted by a user, using the “Accept” button on the data import dialogue.
        • Denotes a batch that was automatically accepted or manually accepted by a user, using the “Accept” button on the data import dialogue, but which contained one or more errors or warnings with regard to data contained in the batch.
        • Denotes a batch that has been submitted by a user, but for which another batch of the same load type awaits acceptance/rejection.

        • Load types to which this status (types which support multiple FTP and/or push-button import file queuing) are as follows:
          • Attributes
          • Class Information
          • Fund Information
          • Holdings
          • N-MFP (XML)
          • Repo Collateral Information

        • Denotes a batch that was either manually rejected by a user, using the “Reject” button on the data import dialogue, or automatically “Rejected” during the data load process due to invalid file structure, or some other error.

          For Holdings data imports, it is possible for a file to have a portion of its data loaded, but still be in a “Rejected” state. As data is migrated into the production database, the system will process the data in logical units: Security Captions, Security Balances, Security Categorization, etc. If, for example, step 9 of 10 encounters an error, then data from steps 1-8 will be retained, and the load will enter a “Rejected” state.

    6. Click the “View Details” link at right of the load batch record whose information you wish to view.

      “Archive” page, “Details” tab
      • The “View Details” link is disabled for any load batch with a “Status” of “Awaiting Processing” (a batch that has been submitted by a user, but for which another batch of the same load type awaits acceptance/rejection by a user).
      • Times displayed in the “Batch Details” section at the top of the page are in Coordinated Universal Time (UTC).

      1. Click the “Errors/Warnings/Info” tab to read any information provided for specific rows in the data source file.

        “Archive” page, “Errors/Warnings/Info” tab
        • Warnings represent issues that should be reviewed/verified prior to loading data, but that will not prevent the records from being loaded.
        • Errors denote conditions that must be corrected before data can be successfully loaded into Arc Suite.
        • Times displayed in the “Batch Details” section at the top of the page are in Coordinated Universal Time (UTC).

    1. Expand the ArcFiling “Dataload” .

      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 “Administration” at lower-left of the screen.
        “Administration” tab

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

    2. Expand the ArcReporting “Dataload” .

      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 “Administration” at lower-left of the screen.
        “Administration” tab

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

    3. Click the “Data Purge” item.

      “Data Purge” page

    4. Select for the data to be purged.
      1. Set the “Balance Data Type” to either “Holdings” or “Repo Collateral”“General Ledger” via the corresponding drop-down list.

      2. Use the “Complex” drop-down list to select the complex with which the fund(s) containing the portfolio or financial data are associated.

      3. Specify a balance type, or leave the default selection of “[All]”, via the “Balance Type” drop-down list.
      4. Specify an account period, or leave the default selection of “[All]”, via the “Account Period” drop-down list.

    5. Click the “Search” button at right of the “Search Criteria” section.

    6. Select the check box to the left of the data record(s) you wish to purge.

      In the results grid, the check box and the entire row are disabled for any records associated with a closed account period.

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

    7. Click the “Purge” at lower-right of the page to initiate the data purge.

      1. Click the “Accept” button at lower-right of the dialogue to carry out the data purge operation.

        This action is irreversible once complete!

        Balance data that is associated with the fund(s) and account periods(s) represented by the selected rows in the results grid will be purged entirely from the database.

      2. Click the “Cancel” button at lower-right of the dialogue to cancel the data purge action.

Reviewing the General Ledger Transaction Report