Back |
|
Intra-Group Flows
See Automatic Matching in Action: A Flow Disrupts a Match See Automatic Matching in Action: Receipts and Transfers Enable Automatic Matching for One Group |
Marking intra-group flows allows you to exclude flows between accounts within a group from reporting metrics. You have two options for handling intra-group flows: automatic matching and manual flagging. You can choose which method you want to use at the group level, so you can have some groups with automatic matching and others that you'll manually flag.
Automatic Matching With automatic matching, transactions—deposits, withdrawals, receipts, and transfers—for a specific security within a group must match and net to zero for a given day to be excluded as an intra-group flow. If there are any additional transactions for the given security, the intra-group flows for that security on that day will not match. Tamarac Reporting will not match transaction-by-transaction for contributions. For more information, see Automatic Matching Examples.
At the end of the Tamarac Reporting sync.
When the Intra-Group Flows data set is uploaded if you manually flag intra-group flows.
When the Reporting Group Information data set is uploaded with the Intra-Group Flow Auto Matching Enabled field included if you enable intra-group flows using a bulk upload.
Manual Flagging For times when Tamarac's automatic intra-group flows matching doesn't catch a flow, or if you prefer to designate flows specifically, you can identify intra-group flow transactions manually with upload data sets. For more information, see Manually Flag Intra-Group Flows.
Once enabled, intra-group flows cannot be disabled. The values on your existing reports will probably change, so it's important to discuss this feature with your service team before requesting it.
To request this feature, please contact your Tamarac service team.
Your firm must turn on intra-group flows if you want to use the enhanced performance calculation.
The setting on the Capital Flows and Summary reports to include intra-group flows drives the inflows and outflows figures, allowing you to see true outside money coming into the group and money moving out of the group.
In reports that have it, the Net contribution data point always includes intra-group flows because:
If intra-group flows do not net to zero, the difference really is entering or exiting the group.
If intra-group flows net to zero, the impact on net contribution would be 0 whether they are included or not.
Tamarac can automatically match intra-group flows that occur on the same day, as long as they aren't contributions and they don't include securities that were traded at another time that day.
You can turn on automatic matching of intra-group flows in two ways:
Enable Automatic Matching at the Group Level.The Edit Group dialog works best when enabling this feature for a small number of groups.
Enable Automatic Matching in Bulk with an Upload Data Set.If you plan to make the changes to several groups at once, it's best to use an upload data set.
In the following example, the flows listed for one day include two matches, but there is one flow that disrupts automatic matching, which results in an inability to identify the intra-group flow.
Account # | Amount |
---|---|
1234-4321 | $99.14 |
6789-9876 | $150.26 |
9632-2369 | $(150.26) |
6789-9876 | $280,000.00 |
5432-2345 | $(280,000.00) |
Total : $99.14 |
In this example, there's no match for the flow of $99.14, so:
The net of transactions for this group is not 0.
No transactions for this security are recognized as intra-group.
For receipts and transfers, the security, amount, and date must match to be considered as an intra-group transaction.
For example, if Dennis Roberts deposits and then withdraws $50 on the same day, or if he transfers 10 shares of IBM and receives 10 shares of IBM, this will be considered an intra-group flow.
Roberts Household (Group)
Dennis (Single) deposits $100 on 1/1/2012
Kate (Single) withdraws $100 on 1/1/2012
Roberts Household (Group)
Dennis (Single) deposits $100 on 1/1/2012
Kate (Single) withdraws $100 on 1/1/2012
Steven (Single) deposits $50 on 1/1/2012
You can turn on automatic matching for one single group if you don't want it turned on for all groups. For more information, see Enable Automatic Intra-Group Flows Matching in a Group.
If you want to turn on automatic intra-group flows matching for many groups at one time, you can use bulk uploading. For more information, see Enable Automatic Intra-Group Flows Matching with Upload.
Sometimes Tamarac's automatic flagging might miss some flows—for example, if the flow included securities that were traded at a different time that day or if the matching flow occurred on a different day. In those cases, you can manually flag transactions as having intra-group flows for Tamarac to match up.
For steps on how to manually flag intra-group flows, see Workflow: Manually Flag Intra-Group Flows