Captools/net Documentation

Auxiliary Records

Auxiliary Records

Previous topic Next topic  

Auxiliary Records

Previous topic Next topic  

There are four auxiliary tables which contain records which support Professional and higher functions as follows:

 

 

Reconciliations

 

These records, functional at Pro and Enterprise levels, provide a comparison between the Captools/net data and data imported from broker/dealers or custodians.  This allows you to quickly identify any discrepancies requiring resolution.  Reconciliation records are typically generated automatically upon import of custodian data and are updated whenever the applicable Captools/net portfolio data is modified.  Manual entry of data is generally not required other than perhaps completing missing price information.  More detail on these records is provided in the topic Data Reconciliation.

 

Cost Reconciliation - Starting in 2011, U.S. law requires custodians to report cost basis information on Form 1099 provided to the Internal Revenue Service.  Accordingly, many custodians commenced providing investment advisors with files containing cost basis information.   This takes the form of the cost record for existing open lots, and/or the cost record for closing transactions, i.e. realized gains cost.  Captools/net makes provision for importing these records and comparing them versus the costs tracking in Captools/net.  More detail on these records is provided in the topic Cost Reconciliation.

 

 

Allocations

 

Allocation records, functional at Pro and Enterprise levels, provide a means for you to define investment allocations for investment styles and then use these to generate proposed trades for the accounts assigned those investment styles. These records generally require manual maintenance at whatever frequency you choose to use to rebalance your client portfolios.  More details on these records and on rebalancing portfolios is found in the appendix topic Portfolio Rebalancing.

 

 

Fee Rates

 

Fee rate records, functional at Pro and Enterprise levels, permit you to define the rates used in computing the management fees for your periodic client billing.  These records require manual maintenance, but only when you add or modify a fee rate.  More detail on these records is found in the appendix topic Management Fees/Billing.

 

 

Interest Rates

 

These records, functional only for Enterprise licensees who have opted for B/D features, are used to periodically compute and generate interest transactions on credit or debit cash balances within client accounts.  These records require manual maintenance, but only when you add or modify a rate.  More detail on these records is fund in the appendix topic Credit/Debit Interest.