SMONIK SOLUTIONS FOR FUND ADMINISTRATORS
Goal:
SMART dashboards that consolidate reporting across clients; a rules-based recon configuration process to allow specific rules and tolerances for each client; and the ability to post entries to your accounting system based on recon exceptions are just a few of the advantages of using Smonik as your data management and reconciliation platform.

Challenge:
Fund Administrators are challenged to process reconciliations for cash, positions, dividends, interest, P&L, GL accounts, etc. for many clients. How do you know if all reconciliations are completed for a given day? How do you know if you have any risk issues with a given client? Did you receive all the required broker/custodian files for a particular day? Is your current reconciliation system constrained? Maybe it doesn’t handle derivatives very well?

Smonik Solutions for Fund Administrators:
These are all challenges Fund Administrators face every day... and Smonik solves these issues!
Click on an icon to learn more:
 
 
 
 
 
 
Download Broker/Custodian Data Files
Standardize/Normalize Data
Reconcilliation
Management Reporting
  • User controls data management using intuitive user interface. No developmnet required.
  • Smonik allows the user to normalize data to meet any standard format or integration with accounting system or other repoting database
  • Map and transform any Excel, CSV, Text Delimited (Pipe Delimited), Fixed Position, XML, and PDF file formats.
  • Data can be extracted from structured and unstructured PDF documents such as capital statements, capital call notices, and distribution notices.
  • Ability to view life-cycle of data before and after applying filters and translations.
  • Smonik allows the user to normalize data to meet any standard format or integration with accounting system or other repoting database
  • Map and transform any Excel, CSV, Text Delimited (Pipe Delimited), Fixed Position, XML, and PDF file formats.
  • Data can be extracted from structured and unstructured PDF documents such as capital statements, capital call notices, and distribution notices.
  • Ability to view life-cycle of data before and after applying filters and translations.
  • User controls data management using intuitive user interface. No developmnet required.
  • Map and transform any Excel, CSV, Text Delimited (Pipe Delimited), Fixed Position, XML, and PDF file formats.
  • Data can be extracted from structured and unstructured PDF documents such as capital statements, capital call notices, and distribution notices.
  • Ability to view life-cycle of data before and after applying filters and translations.
  • User controls data management using intuitive user interface. No developmnet required.
  • Smonik allows the user to normalize data to meet any standard format or integration with accounting system or other repoting database
  • Data can be extracted from structured and unstructured PDF documents such as capital statements, capital call notices, and distribution notices.
  • Ability to view life-cycle of data before and after applying filters and translations.








Fund Administrators - FAQ


How do you retrieve broker/custodian data for reconciliation?

Broker/custodian data files can be scheduled to be automatically retrieved. The user can setup a recurring schedule, and a few other file parameters, and the file watcher service will check the FTP site, website or email inbox every 2 minutes for the specified file. Once files are captured any user-defined filters or translations are applied before the data is automatically loaded to recon.



What if my scheduled file does not come in?

If, for some reason, the scheduled file is not received the user will see an “Error” appear on the Control Center dashboard. Once the reason for the non-delivery is known, and resolved, the file can easily be rescheduled simply by selecting “Reschedule”.



Can I configure the workflow to view reconciliations and exceptions by client, fund, broker, or by asset type?

Yes. The Recon Status view and the Break Details view are configurable to view all aspects of a recon (including matched and unmatched items) with filtering and grouping the way the user wants to see them. Within the Recon Configuration screens the user can setup which fields are available for filtering and grouping.



Are you able to restrict a user to only view data for a specific client?

Yes. Permissions can be set to allow specific users to only have access to the client's data for whom they are responsible.



Am I able to view data before and after filters and translations are applied?

Yes. From within the Control Center dashboard the user can open data files both before and after any filters and/or translations are applied. User can see a 360o view of their data.



Most of my reconciliations have zero breaks. Is there a way to hide those so I don’t have to waste time reviewing recons with no exceptions?

On the Recon Status screen (in the top right corner) there is a checkbox “Hide Zero Breaks:”. When selected, the recons with zero breaks will be hidden from the list of recons below. Alternatively, the user can sort by any column header. By sorting the “Outstanding Breaks” column in descending order the recons with the most breaks will display at the top of the list.



Is there a way to “lock” the recon once all breaks for a given day have been researched and resolved and/or notated or approved?

By selecting the “Review” or “Sign-Off” button on the far right of the Recon Status screen not only does it show who (based on Windows ID) Reviewed or Signed-Off, but it also locks the recon and does not allow any additional changes unless the Review or Sign-Off is removed. In addition, a user can then right-click on the Review/Sign-Off button and add a any notes or attach files to support the recon.



Can data be exported to Excel?

Data can be exported to Excel (with or without header rows) or PDF from either the Recon Status screen or the Break Details screen.



If I know an exception is going to exist for some period of time, how do I handle it in Smonik? I do not want to have to address the same break every day.

For situations where the user knows a break is going to exist for a period of time, the user can “Approve” the break and assign a date the approval will be effective until. For example, a break exists on the cash recon and I know the broker is not going to process their side of the transaction for two weeks. I can approve the break on the Break Details screen and assign the approval until a date two weeks out. Every day until then the break will appear in an “Approved” status with no need to research it over and over again. If not cleared by the end date of the approval, it will revert to a break status.



Does a user have the ability to manage (e.g. notate or approve) the same exception across numerous clients/funds?

Yes. Due to the various ways users can view data, a user can apply notes, approvals, etc. to any group of recon exceptions. By selecting the “Show All” button on the Recon Status screen the user can then filter for any group of exceptions and apply any of the break management functions.



Will Smonik Recon match one-to-many and many-to-many transactions?

Reconciliations can be configured to allow for exact matches (one-to-one,) one-to-many matches, many-to-many matches, and/or matches within a specified tolerance. Not only can the user define which of these match types to allow, you can also control the order of how these matches occur.



Can you apply tolerances when matching items?

Smonik has extensive tolerance settings which can be set at the most granular level. For instance, if you are reconciling cash transactions you could set a tolerance for each currency, or a separate tolerance for each currency by broker.



How does Smonik address the issue of security identifiers not matching? If I have a derivative where my internal identifier is not the same as the broker’s identifier?

There are two methods of resolving this issue. One is to use the cross-reference functionality to associate the internal identifier with the broker’s identifier. Once the position is added to the cross-reference database (which is a simple right-click function), they will forever be associated. The alternative is to attempt to re-create the internal identifier using the data sent in the broker file. Although this is dependent on the data sent from the broker, this can usually be accomplished through the use of advanced translations.



Does Smonik track Aged Breaks?

Smonik does track the number of days an exception item is aged and displays this on the Break Details screen. We also provide Aged Break dashboards and reports.



Can a user configure different views in the Break Details screen?

By selecting the “Arrange Columns” icon on the Break Details screen the user can modify and/or create any view. Move columns or add/delete columns to provide the specific view desired. Once a view is named, it can then be saved and made available for anyone to see, or only available to the user who created it. A user may create one view for a position recon, another for cash recons and maybe a specific view for Forward Currency Contracts.



How does Smonik handle “As-of” recons for Hedge funds?

Smonik includes functionality to perform an “As-of” recon. For example, a hedge fund or fund administrator performs cash and position reconciliations daily. Upon reaching month-end, they must continue to perform the daily recons but also set aside the recon for the last day of the month and update it. The recons for the last day are copied to a month-end version, which is then maintained separate from the daily version. Any notes, approvals, etc. from the daily recons are carried forward to the month-end version.



Is Smonik capable of handling large volumes of data (positions and/or transactions)?

Smonik is designed to handle large volumes of data. Our data retrieval, ETL (Extract, Transform, Load) and Reconciliation components are capable of processing over 1 million transactions, end-to-end, in minutes.



Can the user customize dashboards or reports to meet their needs?

Users can create their own customized reports and dashboards or, if more complex reports/dashboards are required, Smonik can develop them usually in a few days and at minimal cost.



If there is a position break, which also causes a cash break, can the user manage the breaks as one instance, seeing as they are due to the same transaction?

Yes. Smonik allows the user to address breaks, caused by the same security or same event, across multiple recons. The user only has to enter details such as notes or approvals once and they will be applied across the various impacted recons.



What if the broker/custodian changes the format of the file they send?

File formatting and mapping changes are easy to accommodate in Smonik. Because we put all of the ETL components in the User Interface, the user can quickly make any necessary updates to mapping data from broker/custodian files. Smonik staff will also support any changes required.