Summary: Audit Reports/Data Extracts
In addition to the reports listed below, in most cases if there is a grid in the application user interface, the contents thereof can be exported to “Excel”, “Word”, “CSV”, “TXT” or “HTM” formats. Examples include the “Fund Holdings” page and all maintenance library pages.
Archive
You can view the details of data that has been imported to Arc Suite on some previous date via the “Archive” page. Such data will have been imported either via secure FTP as part of an automated dataload operation or through a manual data import from various application pages. The type of load, date/time and details of files are all available in the archive record.
On-screen, Excel, Word, CSV, TXT, HTM
Attribute Usage Report
You can produce a listing of the fund(s), fund group(s) or complex(es) with which attributes in the system are assigned by running the Attribute Usage Report.
ArcReporting > Reporting Workspace > Reports > Attribute Usage Report
Excel
Batch N-SAR Output
You can generate Excel output for multiple N-SAR calculation sheets at once for a specified account period via the “Batch N-SAR Output” page. The output file can subsequently be imported into the FundSuite ComFiler application.
ArcReporting > Reporting Workspace > Production Utilities > Batch N-SAR Output
Excel
Calculation Sheet Account Mapping Audit Report
This report allows you to export the calculations sheet(s) in a given financial workbook to Excel format and see the direct link whereby each line item is mapped, up to 5 levels.
ArcReporting > Reporting Workspace > Financials > Financial Workbook > “Calculation Sheets” tab
Excel
Calculation Sheet Audit Report
You can generate a listing of all changes made to calculation sheets associated with a given complex or a specific workbook template by running the Calculation Sheet Audit Report.
ArcReporting > Administration > Reports > Calculation Sheet Audit Report
Excel
Calculation Sheet Circular Reference Audit Report
This report returns the details and location of any circular reference that may exist in the calculation sheet(s) of a given financial workbook. Ideally, this report will not return any results.
ArcReporting > Reporting Workspace > Financials > Financial Workbook > “Calculation Sheets” tab
Excel
Calculation Sheet Structure Report
This report is a listing in Excel format of all elements that exist in all calculation sheets associated with a given financial workbook. This report differs from the Calculation Sheet Account Mapping Audit Report in that the report does not contain fund values; it is used to check the setup of the calculation sheets.
ArcReporting > Reporting Workspace > Financials > Financial Workbook > “Calculation Sheets” tab
Excel
Class Balances Audit Report
You can generate a listing of all changes made to values in the “Class Balances” tab of the “Financial Workbook” page by running the Class Balances Audit Report. The report displays the beginning and ending balance of each field, the date/time of the change and user that made the change. This information can be useful in determining the impact of a change by identifying output that may need to be regenerated after a change is made.
ArcFiling > Filings Workspace > Reports > Class Balances Audit Report
ArcReporting > Reporting Workspace > Reports > Class Balances Audit Report
On-screen, Excel, Word, CSV, TXT, HTM
Event Log
The system “Event Log” page allows you to search the system to determine what events, such as user log-ins, user log-outs, project component edits, etc., have occurred within your environment during a specific time frame.
Search results indicate the event code, the date the event occurred, the product in which the event occurred, the name of the user who triggered the event, and any relevant event details.
Environment Administration > Audit Reports > Event Log
On-screen, Excel, Word, CSV, TXT, HTM
Financial Statement Footnote Assignment Audit Report
You can generate a listing of all changes made to financial statement footnote assignments associated with a given fund group and financial workbook template by running the Financial Statement Footnote Assignment Audit Report.
ArcReporting > Reporting Workspace > Reports > Financial Statement Footnote Assignment Audit Report
Excel
Financial Statement Mapping Audit Report
This report allows you to export financial statements to Excel format, and displays the direct link whereby each line item is mapped. The report looks through the calculation sheet(s) and trial balance and displays the underlying values that created an ending balance on a given statement.
ArcReporting > Reporting Workspace > Financials > Financial Workbook
Excel
Financial Statement Template Audit Report
You can generate a listing of all changes made to financial statement templates associated with a given complex or a specific workbook template by running the Financial Statement Template Audit Report.
ArcReporting > Administration > Reports > Financial Statement Template Audit Report
Excel
Financial Statement Template Output Settings Audit Report
You can generate a listing of all changes made to the output settings a given financial statement by running the Financial Statement Template Output Settings Audit Report.
ArcReporting > Administration > Reports > Financial Statement Template Output Settings Audit Report
Excel
Financial Statement Template Usage Report
You can produce a listing of the fund(s) and project(s) in which financial statement templates meeting specified criteria are included by running the Financial Statement Template Usage Report. This report allows you to determine any projects that may need to be regenerated after a change is made.
ArcReporting > Reporting Workspace > Reports > Financial Statement Template Usage Report
On-screen, Excel, Word, CSV, TXT, HTM
Financial Workbook Consolidation Report
This report displays the underlying details of calculation sheet line items that consolidate values in a parent/child relationship.
ArcReporting > Reporting Workspace > Financials > Financial Workbook > “Calculation Sheets” tab
Excel
Financial Workbook Extract
This feature allows you to extract the trial balances, class balances, fund data points, supplemental data, calculation sheets and general ledger transactions of a given financial workbook to a file of Excel format. This is the main report users of Arc Suite send to auditors for financial statement backup.
ArcReporting > Reporting Workspace > Financials > Financial Workbook
Excel
Footnote Libraries Audit Report
You can generate a listing of all additions and changes associated with financial or portfolio footnote text meeting specified criteria (e.g., complex, account period, footnote name, etc.) by running the Footnote Libraries Audit Report. The report displays the date/time of edits, the name of the editing user, and the before and after text. This information can be useful in determining the impact of a change by identifying output that may need to be regenerated after a change is made.
ArcReporting > Reporting Workspace > Financials > Footnote Libraries Audit Report
ArcReporting > Reporting Workspace > Portfolio > Footnote Libraries Audit Report
On-screen, Excel, Word, CSV, TXT, HTM
Fund Data Points Audit Report
You can generate a listing of all changes made to values via the “Fund Data Points” tab of the “Financial Workbook” page by running the Fund Data Points Audit Report. The report displays the beginning and ending balance of each field, the date/time of the change and user that made the change. This information can be useful in determining the impact of a change by identifying output that may need to be regenerated after a change is made.
ArcFiling > Filings Workspace > Reports > Fund Data Points Audit Report
ArcReporting > Reporting Workspace > Reports > Fund Data Points Audit Report
On-screen, Excel, Word, CSV, TXT, HTM
General Ledger Transactions
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.
ArcReporting > Reporting Workspace > Financials > General Ledger Transactions
On-screen, Excel, Word, CSV, TXT, HTM
Global Holdings Review
The “Global Holdings Review” page allows you to easily view the funds that hold a security record within the current or other complexes in your Arc Suite environment.
ArcFiling > Filings Workspace > Reports > Global Holdings Review
ArcReporting > Reporting Workspace > Reports > Global Holdings Review
On-screen, Excel, Word, CSV, TXT, HTM
Historical Data Audit Report
You can generate a listing of all changes made to historical data values via the “History” tab of the “Financial Workbook” page by running the Historical Data Audit Report.
ArcReporting > Reporting Workspace > Reports > Historical Data Audit Report
Excel
Holdings Breakout Report
You can generate a report of holdings associated with a specified complex, fund group, fund and/or account period by running the Holdings Breakout Report. Information in the report can be grouped by up to three category type levels, and display up to three numeric field values for each security/category. The customized report(s) generated can be used for internal checks and for auditors.
ArcReporting > Reporting Workspace > Reports > Holdings Breakout Report
Excel
Holdings Data Extract
You can export holdings-related information from Arc Suite for one or more complexes and a for a specified account period to Excel format via the “Holdings Data Extract” page. The resulting file(s) will be in a format that can be used for import to either Arc Suite or the FundSuite SX application, depending on the options you specify.
ArcFiling > Filings Workspace > Production Utilities > Holdings Data Extract
ArcReporting > Reporting Workspace > Production Utilities > Holdings Data Extract
Excel
Missing Output Settings Report
You can generate a listing of all portfolio statement template line items in a given project that have no defined output settings by running the Missing Output Settings Report. Missing output settings could lead to output and footing issues.
You can generate a listing of all portfolio and/or financial statement template line items in a given project that have no defined output settings by running the Missing Output Settings Report. Missing output settings could lead to output and footing issues.
You can also generate this report for a specific project via the “Output Settings” tab of the “Project” page.
ArcFiling > Filings Workspace > Reports > Missing Output Settings Report
ArcReporting > Reporting Workspace > Reports > Missing Output Settings Report
Excel
New Securities Report
The “New Securities Report” page allows you to search the system to identify new securities in a given security library for a specified account period (i.e., securities that have never been held by the library used by the specified fund(s) for an account period prior to the one being viewed).
ArcFiling > Flings Workspace > Reports > New Securities Report
ArcReporting > Reporting Workspace > Reports > New Securities Report
Excel, Word, “PDF”
Non-Participating Accounts
The “Non-Participating Accounts” page allows you to view all general ledger accounts (and associated balances) not mapped to any items in the financial workbook template associated with a specified fund and account period.
ArcReporting > Reporting Workspace > Financials > Non-Participating Accounts
On-screen, Excel, Word, CSV, TXT, HTM
Portfolio Statement Template Audit Report
You can generate a listing of all changes made to a given portfolio statement template by running the Portfolio Statement Template Audit Report.
ArcFiling > Administration > Reports > Portfolio Statement Template Audit Report
ArcReporting > Administration > Reports > Portfolio Statement Template Audit Report
Excel
Portfolio Statement Template Output Settings Audit Report
You can generate a listing of all changes made to the output settings a given portfolio statement by running the Portfolio Statement Template Output Settings Audit Report.
ArcFiling > Administration > Reports > Portfolio Statement Template Output Settings Audit Report
ArcReporting > Administration > Reports > Portfolio Statement Template Output Settings Audit Report
Excel
Portfolio Statement Template Usage Report
You can produce a listing of the fund(s) and project(s) in which portfolio statement templates meeting specified criteria are included by running the Portfolio Statement Template Usage Report. This report allows you to determine any projects that may need to be regenerated after a change is made.
ArcFiling > Filings Workspace > Reports > Portfolio Statement Template Usage Report
ArcReporting > Reporting Workspace > Reports > Portfolio Statement Template Usage Report
On-screen, Excel, Word, CSV, TXT, HTM
Project Component Unlinking Audit Report
You can generate a listing of all changes made to the linked/unlinked state of components in a given project by running the Project Component Unlinking Audit Report. The report displays the editing user, date/time, and content that was linked/unlinked.
ArcReporting > Reporting Workspace > Reports > Project Component Unlinking Audit Report
On-screen, Excel, Word, CSV, TXT, HTM
Project Excel Export
You can export data from Arc Suite for one or more project items to Excel format via the “Project Excel Export” page. The resulting file will contain one worksheet tab for each item that was selected for export.
You can also export any project table by right-clicking it in the Project Content pane of the “Project” page and choosing Export To Excel from the context menu that displays.
ArcFiling > Filings Workspace > Production Utilities > Project Excel Export
ArcReporting > Reporting Workspace > Production Utilities > Project Excel Export
Excel
Project Locking Audit Report
You can generate a listing of all changes made to the locked/unlocked state of components in a given project by running the Project Locking Audit Report. The report displays the editing user, date/time, and content that was locked/unlocked.
ArcFiling > Filings Workspace > Reports > Project Locking Audit Report
ArcReporting > Reporting Workspace > Reports > Project Locking Audit Report
On-screen, Excel, Word, CSV, TXT, HTM
Project Output Validation Report
This report performs checksums of all totals within portfolio and financial statement tables in a given project and displays any totals that do not match the sum of their components.
ArcReporting > Reporting Workspace > Document Assembly > Project > “Output Management” tab
Excel
Project Template Audit Report
You can generate a listing of all changes made to a given project template by running the Project Template Audit Report.
ArcFiling > Administration > Reports > Project Template Audit Report
ArcReporting > Administration > Reports > Project Template Audit Report
Excel
Reference Data Report
This report lists the underlying data used during custom preprocessing against the last loaded values (numeric, text and categorization).
This report only works with custom preprocessors that have been configured to use the report. It must then be deployed to the database.
ArcFiling > Filings Workspace > Reports > Report Library > Reference Data Report
ArcReporting > Reporting Workspace > Reports > Report Library > Reference Data Report
Excel, Word, “PDF”
Role Information Report
This report details all user rights assigned to each user role defined in Arc Suite.
ArcFiling > Filings Workspace > Reports > Report Library > Role Information Report
ArcReporting > Reporting Workspace > Reports > Report Library > Role Information Report
Excel, Word, “PDF”
Same Security Prior Period Report
The “Same Security Prior Period Report” page allows you to compare security library and category library information (caption, descriptions, categories, footnotes, etc.) from two different account periods. Any differences in the library information between the two selected time periods are displayed in this exceptions report.
ArcFiling > Filings Workspace > Reports > Same Security Prior Period Report
ArcReporting > Reporting Workspace > Reports > Same Security Prior Period Report
Excel, Word, “PDF”
Securities Audit Report
The “Securities Audit Report” page allows you to search the system to identify changes that have occurred with regard to holdings data within a specific time frame.
Search results indicate when securities were added to the database and if security’s balance or categorization was added or updated. You can see the dates and times of any such edits, the name of the editing user for each, before and after values (as applicable) and the names of the libraries and funds with which the securities and security balances are associated.
The “Securities Audit Report” page allows you to search the system to identify changes that have occurred with regard to holdings data within a specific time frame.
Search results indicate when securities were added to the database, if security’s balance or categorization was added or updated and when footnote attachments were added or removed from a given security. You can see the dates and times of any such edits, the name of the editing user for each, before and after values (as applicable) and the names of the libraries and funds with which the securities and security balances are associated.
ArcFiling > Filings Workspace > Reports > Securities Audit Report
ArcReporting > Reporting Workspace > Reports > Securities Audit Report
On-screen, Excel, Word, CSV, TXT, HTM
Supplemental Data Audit Report
You can generate a listing of all changes made to values in the “Supplemental Data” tab of the “Financial Workbook” page by running the Supplemental Data Audit Report. The report displays the beginning and ending balance of each field, the date/time of the change and user that made the change. This information can be useful in determining the impact of a change by identifying output that may need to be regenerated after a change is made.
ArcReporting > Reporting Workspace > Reports > Supplemental Data Audit Report
On-screen, Excel, Word, CSV, TXT, HTM
Tabular Data Template Output Settings Audit Report
You can generate a listing of all changes made to the output settings a given set of tabular data by running the Tabular Data Template Output Settings Audit Report.
ArcFiling > Administration > Reports > Tabular Data Template Output Settings Audit Report
ArcReporting > Administration > Reports > Tabular Data Template Output Settings Audit Report
Excel
Tabular Data Template Usage Report
You can produce a listing of the fund(s) and project(s) in which tabular data templates meeting specified criteria are included by running the Tabular Data Template Usage Report. This report allows you to determine any projects that may need to be regenerated after a change is made.
ArcFiling > Filings Workspace > Reports > Tabular Data Template Usage Report
ArcReporting > Reporting Workspace > Reports > Tabular Data Template Usage Report
On-screen, Excel, Word, CSV, TXT, HTM
Text Libraries Extract
This feature allows users to export all text snippets in a given text library to a file in Word format.
ArcFiling > Filings Workspace > Text > Text Libraries
ArcReporting > Reporting Workspace > Text > Text Libraries
Word
Text Snippet Audit Report
You can generate a listing of all additions and changes associated with text snippets meeting specified criteria (e.g., complex, account period, snippet name, etc.) by running the Text Snippet Audit Report. The report displays the date/time of edits, the name of the editing user, and the before and after text. This information can be useful in determining the impact of a change by identifying output that may need to be regenerated after a change is made.
ArcFiling > Filings Workspace > Text > Text Snippet Audit Report
ArcReporting > Reporting Workspace > Text > Text Snippet Audit Report
On-screen, Excel, Word, CSV, TXT, HTM
Text Snippet Usage Report
You can generate a listing of all funds and projects where snippets meeting specified criteria (e.g., complex, account period, snippet name, etc.) are being used by running the Text Snippet Usage Report. This information can be useful in determining the impact of a change by identifying the documents that may need to be regenerated after a change is made.
ArcFiling > Filings Workspace > Text > Text Snippet Usage Report
ArcReporting > Reporting Workspace > Text > Text Snippet Usage Report
On-screen, Excel, Word, CSV, TXT, HTM
Trial Balance Definitions Audit Report
You can generate a listing of all changes made to trial balance definitions (mostly general ledger account mappings) in a given financial workbook template by running the Trial Balance Definitions Audit Report.
ArcReporting > Administration > Reports > Trial Balance Definitions Audit Report
Excel
User Audit Reports
The “User Audit Reports” page allows you to search the system to identify changes that have occurred with regard to user account information, user complex access rights, assigned roles and business units within a specific time frame.
Search results indicate the dates and times of any such edits, the name of the editing user for each, before and after values (as applicable), etc.
Environment Administration > Audit Reports > User Audit Reports
On-screen, Excel, Word, CSV, TXT, HTM
User Information Report
This report details all current users and the complex(es) and role(s) assigned to each.
ArcFiling > Filings Workspace > Reports > Report Library > User Information Report
ArcReporting > Reporting Workspace > Reports > Report Library > User Information Report
Excel, Word, “PDF”