Clearwater Sample Accounting Reports for GSAM
Clearwater Sample Reports
Current as of August 2013
AccounCng GAAP ReporCng
The Balance Sheet by Posi4on Report lists all securiCes held in the account on the selected report date. The report gives relevant security informaCon like book value, unrealized gain/loss, accrued interest etc. Fields can be added or removed from all account reports using intuiCve report wriCng tools. This report sums all tax lot informaCon and presets the informaCon at the security (cusip) level. GAAP reports are also available for clients with mulC-‐currency porWolios (called GAAP FX reports). GAAP FX reports break out unrealized gain/loss by market and security.
The Balance Sheet by Lot report lists all securiCes held in the account as of the date selected. This report provides relevant security informaCon including book value, unrealized gain/loss and accrued interest. Fields can be added or removed from all accounCng reports using intuiCve report wriCng tools. This report displays informaCon at the tax-‐lot level.
The Trading Ac4vity report keeps track of account acCvity over a given period of Cme. This report includes acCvity that affects posiCons such as buys, sells, transfers, maturity, etc.
The Transac4on Detail report shows all acCvity that took place in the account over the period including coupons, dividends, buys, sells, transfers, etc.
The Income Detail Report displays all securiCes held during the reporCng period whether they are sCll held in the account or not. This report provides detail at the tax-‐ lot level and displays all income informaCon for each security.
The Interest Income report shows the income earned through interest. The report provides the beginning and ending balance of accrued interest for the period, income payments received and purchased and sold accrued for the period.
The Amor4za4on/Accre4on report shows the income earned through amorCzaCon/accreCon for all securiCes in the porWolio.
The Realized Gain/Loss report shows the realized gains and losses for securiCes that were disposed of (sold, matured transferred out, etc.).
The FAS 157 report allows users with authorizaCon to make fair value level changes. SecuriCes are designated as level 1, level 2 and level 3. The top half of the report shows the market value and security types for each pricing level. The boLom secCon shows the securiCes designated as level 1, level 2, level 3 or Unspecified.
The GAAP Roll Forward report offers the opportunity to ensure that the change from beginning balance to ending balance for market values and book values can be explained by an account’s acCvity.
The Impairment report contains a matrix summarizing securiCes by type that have been impaired for less than 12 months, greater than or equal to 12 months and total market value of those posiCons. The table at the top of the screen can be used to automate quarterly impairment disclosure requirements. Below this summary, investors can expand the impaired Cme periods to view specific securiCes. AddiConally, this report displays securiCes that lack sufficient data for categorizaCon (such as data not charted prior to the security’s purchase) as well as securiCes held and transferred into a given account. It is up to an authorized user to set up securiCes that are considered impaired.
The MMF Accrual report shows the cumulaCve daily accrued interest for the selected period. By default the report is grouped by each fund held in the account and can be expanded to display the daily accrual informaCon for each fund. Important fields include daily mil rate, accrued interest balance and market value + accrued. The report also includes daily, 7 day and 30 day yield.
AccounCng General Ledger
The Financials Report allows clients to view summary level balance sheet informaCon for the beginning and end of the period selected and income statement informaCon for the period selected.
The Trial Balance Report displays the beginning balances, ending balances and acCvity for each account. The report also offers drill-‐down funcConality that allows the user to access detailed informaCon to support balances efficiently.
The Ac4vity Detail Report provides a view into the general ledger entries as they relate to a single GL account. Clients can use this report to see all acCviCes that have impacted the balance of a single GL account for the given period.
The Entry Summary Report provides a view into the general ledger entries as they relate to a single type of acCvity. Clients can use this report to see what and by how much all GL accounts were affected by a given acCvity
The Entry Detail provides the same view into GL entries as Entry Summary, but provides it at the security level view. This would primarily be used when looking into quesCons from the Entry Summary report or for audit support.
The Entry File Report provides a file that is designed to facilitate uploading journal entries into an accounCng system. This report will provide an Excel file that provides the details needed to book the journal entries for the period in a format that should be most useful in creaCng an upload file.
The Balance Sheet by Lot allows clients to view a snapshot of all posiCons held in the account as of a specified date, providing the columns that are relevant to the client’s GL structure.
The GL Income Detail report allows clients to view the lot-‐level detail behind the Income statement numbers provided on the Financials Report.
The GL Interest Income report allows clients to view the lot-‐level detail behind all applicable types of interest income that are used in their GL accounts.
The GL Amor4za4on/Accre4on report allows clients to view the lot-‐level detail behind the amorCzaCon expense and accreCon income in a tabular format.
The GL Realized Gain/Loss report allows clients to view the lot-‐level detail behind all applicable types of realized gains and losses that are used in their GL accounts.
Statements
The Statement Manager tool allows users to create an unlimited number of custom statement templates. A “statement” is a collecCon of Clearwater reports, including custom, user-‐created reports, that can be grouped together and downloaded in a specified format.
The Statement Download tool allows users to select statement templates and formats, as well as the account(s) and date range for which a statement should be prepared. Users should iniCally create a statement template in the Statement Management tool before downloading.
Other
Users have the ability to customize and organize their report dropdown menu through the Report Manager. Reports available in the user’s menu dropdown are listed within the “Menu” page on the right. Reports available to the user but not included in the menu dropdown are listed within the “Available Reports” pane on the leD.
Flexible Report opCons are easy-‐to-‐use and included in nearly every report. To modify a report, simply right click on the column headers. Columns can be sorted ascending or descending. Columns can also be renamed. To reorder a column, simply click on the column header and drag the column to the desired locaCon.
Users can Filter Reports to only display user-‐defined data. To filter a report, right click on a column header and select “Edit Filter”. Users can filter by one or more columns. “Match All” requires that a security saCsfies all condiCons whereas “Match Any” will return any security saCsfying at least one condiCon.
Adding/Removing columns make it easy to view the columns you prefer. To add a column, simply right click on the column header and select the “Add Column” opCon to bring up a tool displaying available fields. Users can browse available fields or search by typing into the search box. Removing a column is as simple as right clicking on the appropriate column and choosing the “Remove Column” opCon.
The Column Manager provides the ability to add or delete mulCple columns at once. Simply right click on the column header and a pop up will appear. The right pane shows all columns currently visible in the report and the leD pane shows all columns available to add. Simply drag and drop columns unCl you have the desired combinaCon.
Reports exported in PDF will have certain columns automaCcally stacked to accommodate the width of a PDF document. The Configure PDF opCon allows the user to configure the PDF layout of user-‐created reports. Columns can be removed from the report enCrely or stacked in a more logical fashion.
AddiConal Report Flexibility includes Grouping, Ungrouping and Sor4ng by Groups. To group by a parCcular column, right click on the desired column and select “Group by” opCon. MulCple groupings can also be applied by clicking “Edit Advanced Grouping”. Note also that grouped reports can be exported to show Summary-‐ Only data. Grouped reports show a single row for each group. ExporCng summary-‐only data leaves the data collapsed in the export, showing summary-‐only informaCon that is useful for high-‐level porWolio views.
The Custom Data Manager enables clients to add custom security-‐level data to Clearwater. With appropriate permissions, users can add new columns of security data at the idenCfier level, to enable adding client-‐defined data points into reports, earmarking securiCes to indicate securiCes out on loan, and displaying modified classificaCons, for example.
The Fair Value Level Manager enables users with the proper permissions to assign general FAS 157 (ASC 820) levels for all Security Types that they would like to designate. This will classify all current securiCes, as well as future purchases to the Level designaCon. Users can override their FAS 157 levels with the new “Override” buLon on the FAS 157 Disclosure report.
Clearwater provides each client with the funcConality to administer their own account access to individual users through the Account Access page. Authorized Administrators will be able to grant and restrict user access to their Clearwater accounts.
The General Ledger (GL) Wizard guides users through the process of selng up a customized general ledger on the Clearwater system. The goal of the Wizard is to align Clearwater’s general ledger reports with your actual GL. Through making a variety of general ledger elecCons, users can control the data and format of the GL reports, located in the Clearwater AccounCng Module.
Thank You www.clearwater-‐analyCcs.com
Current as of August 2013
AccounCng GAAP ReporCng
The Balance Sheet by Posi4on Report lists all securiCes held in the account on the selected report date. The report gives relevant security informaCon like book value, unrealized gain/loss, accrued interest etc. Fields can be added or removed from all account reports using intuiCve report wriCng tools. This report sums all tax lot informaCon and presets the informaCon at the security (cusip) level. GAAP reports are also available for clients with mulC-‐currency porWolios (called GAAP FX reports). GAAP FX reports break out unrealized gain/loss by market and security.
The Balance Sheet by Lot report lists all securiCes held in the account as of the date selected. This report provides relevant security informaCon including book value, unrealized gain/loss and accrued interest. Fields can be added or removed from all accounCng reports using intuiCve report wriCng tools. This report displays informaCon at the tax-‐lot level.
The Trading Ac4vity report keeps track of account acCvity over a given period of Cme. This report includes acCvity that affects posiCons such as buys, sells, transfers, maturity, etc.
The Transac4on Detail report shows all acCvity that took place in the account over the period including coupons, dividends, buys, sells, transfers, etc.
The Income Detail Report displays all securiCes held during the reporCng period whether they are sCll held in the account or not. This report provides detail at the tax-‐ lot level and displays all income informaCon for each security.
The Interest Income report shows the income earned through interest. The report provides the beginning and ending balance of accrued interest for the period, income payments received and purchased and sold accrued for the period.
The Amor4za4on/Accre4on report shows the income earned through amorCzaCon/accreCon for all securiCes in the porWolio.
The Realized Gain/Loss report shows the realized gains and losses for securiCes that were disposed of (sold, matured transferred out, etc.).
The FAS 157 report allows users with authorizaCon to make fair value level changes. SecuriCes are designated as level 1, level 2 and level 3. The top half of the report shows the market value and security types for each pricing level. The boLom secCon shows the securiCes designated as level 1, level 2, level 3 or Unspecified.
The GAAP Roll Forward report offers the opportunity to ensure that the change from beginning balance to ending balance for market values and book values can be explained by an account’s acCvity.
The Impairment report contains a matrix summarizing securiCes by type that have been impaired for less than 12 months, greater than or equal to 12 months and total market value of those posiCons. The table at the top of the screen can be used to automate quarterly impairment disclosure requirements. Below this summary, investors can expand the impaired Cme periods to view specific securiCes. AddiConally, this report displays securiCes that lack sufficient data for categorizaCon (such as data not charted prior to the security’s purchase) as well as securiCes held and transferred into a given account. It is up to an authorized user to set up securiCes that are considered impaired.
The MMF Accrual report shows the cumulaCve daily accrued interest for the selected period. By default the report is grouped by each fund held in the account and can be expanded to display the daily accrual informaCon for each fund. Important fields include daily mil rate, accrued interest balance and market value + accrued. The report also includes daily, 7 day and 30 day yield.
AccounCng General Ledger
The Financials Report allows clients to view summary level balance sheet informaCon for the beginning and end of the period selected and income statement informaCon for the period selected.
The Trial Balance Report displays the beginning balances, ending balances and acCvity for each account. The report also offers drill-‐down funcConality that allows the user to access detailed informaCon to support balances efficiently.
The Ac4vity Detail Report provides a view into the general ledger entries as they relate to a single GL account. Clients can use this report to see all acCviCes that have impacted the balance of a single GL account for the given period.
The Entry Summary Report provides a view into the general ledger entries as they relate to a single type of acCvity. Clients can use this report to see what and by how much all GL accounts were affected by a given acCvity
The Entry Detail provides the same view into GL entries as Entry Summary, but provides it at the security level view. This would primarily be used when looking into quesCons from the Entry Summary report or for audit support.
The Entry File Report provides a file that is designed to facilitate uploading journal entries into an accounCng system. This report will provide an Excel file that provides the details needed to book the journal entries for the period in a format that should be most useful in creaCng an upload file.
The Balance Sheet by Lot allows clients to view a snapshot of all posiCons held in the account as of a specified date, providing the columns that are relevant to the client’s GL structure.
The GL Income Detail report allows clients to view the lot-‐level detail behind the Income statement numbers provided on the Financials Report.
The GL Interest Income report allows clients to view the lot-‐level detail behind all applicable types of interest income that are used in their GL accounts.
The GL Amor4za4on/Accre4on report allows clients to view the lot-‐level detail behind the amorCzaCon expense and accreCon income in a tabular format.
The GL Realized Gain/Loss report allows clients to view the lot-‐level detail behind all applicable types of realized gains and losses that are used in their GL accounts.
Statements
The Statement Manager tool allows users to create an unlimited number of custom statement templates. A “statement” is a collecCon of Clearwater reports, including custom, user-‐created reports, that can be grouped together and downloaded in a specified format.
The Statement Download tool allows users to select statement templates and formats, as well as the account(s) and date range for which a statement should be prepared. Users should iniCally create a statement template in the Statement Management tool before downloading.
Other
Users have the ability to customize and organize their report dropdown menu through the Report Manager. Reports available in the user’s menu dropdown are listed within the “Menu” page on the right. Reports available to the user but not included in the menu dropdown are listed within the “Available Reports” pane on the leD.
Flexible Report opCons are easy-‐to-‐use and included in nearly every report. To modify a report, simply right click on the column headers. Columns can be sorted ascending or descending. Columns can also be renamed. To reorder a column, simply click on the column header and drag the column to the desired locaCon.
Users can Filter Reports to only display user-‐defined data. To filter a report, right click on a column header and select “Edit Filter”. Users can filter by one or more columns. “Match All” requires that a security saCsfies all condiCons whereas “Match Any” will return any security saCsfying at least one condiCon.
Adding/Removing columns make it easy to view the columns you prefer. To add a column, simply right click on the column header and select the “Add Column” opCon to bring up a tool displaying available fields. Users can browse available fields or search by typing into the search box. Removing a column is as simple as right clicking on the appropriate column and choosing the “Remove Column” opCon.
The Column Manager provides the ability to add or delete mulCple columns at once. Simply right click on the column header and a pop up will appear. The right pane shows all columns currently visible in the report and the leD pane shows all columns available to add. Simply drag and drop columns unCl you have the desired combinaCon.
Reports exported in PDF will have certain columns automaCcally stacked to accommodate the width of a PDF document. The Configure PDF opCon allows the user to configure the PDF layout of user-‐created reports. Columns can be removed from the report enCrely or stacked in a more logical fashion.
AddiConal Report Flexibility includes Grouping, Ungrouping and Sor4ng by Groups. To group by a parCcular column, right click on the desired column and select “Group by” opCon. MulCple groupings can also be applied by clicking “Edit Advanced Grouping”. Note also that grouped reports can be exported to show Summary-‐ Only data. Grouped reports show a single row for each group. ExporCng summary-‐only data leaves the data collapsed in the export, showing summary-‐only informaCon that is useful for high-‐level porWolio views.
The Custom Data Manager enables clients to add custom security-‐level data to Clearwater. With appropriate permissions, users can add new columns of security data at the idenCfier level, to enable adding client-‐defined data points into reports, earmarking securiCes to indicate securiCes out on loan, and displaying modified classificaCons, for example.
The Fair Value Level Manager enables users with the proper permissions to assign general FAS 157 (ASC 820) levels for all Security Types that they would like to designate. This will classify all current securiCes, as well as future purchases to the Level designaCon. Users can override their FAS 157 levels with the new “Override” buLon on the FAS 157 Disclosure report.
Clearwater provides each client with the funcConality to administer their own account access to individual users through the Account Access page. Authorized Administrators will be able to grant and restrict user access to their Clearwater accounts.
The General Ledger (GL) Wizard guides users through the process of selng up a customized general ledger on the Clearwater system. The goal of the Wizard is to align Clearwater’s general ledger reports with your actual GL. Through making a variety of general ledger elecCons, users can control the data and format of the GL reports, located in the Clearwater AccounCng Module.
Thank You www.clearwater-‐analyCcs.com
