Have you ever spent your day dreaming about what you would do to enhance a report or wonder about what functionality other people might be interested in? No? Oh. Well, we do. And here’s 3 new enhancements we have been working on!
Report to List Label Values
Yes, there is already a standard report referred to as the List Label Values report provided by Advent. It is in APX under Tools >Listings >List Label Values. Hey, Axys user! Don’t worry. You should have it too! Axys Reports > Custom > Any Report… and enter find.rep > Ok.
You know what’s great about this report? You can run this and get each portfolios definition of a label in one view. You know what stinks about this report? You can only run it for one label at a time. There is a report floating around out there that will let you define up to five labels in one run, but I needed to run the report twice to get the full address (Name1, Name2, Address 1, Address 2, State, City and Zip – that would be 6 labels.) As you have probably guessed, our report will let you define more than 1 label. You can define up to 10!
And Axys users – you can even pick if you want to pull labels from the Performance file instead of the client file! Awesome! Unless you wanted to specify which Performance file. That’s a no-go. And I know you’ve guessed it again! Our report will let you specify from which Performance file to pull the label.
Another issue I had with the report was that numerical labels (#) didn’t display decimals so we provided the option to show numerical labels with no decimals or to 2 or 3 decimals.
Everything else is just added on goodness!
- Optionally include or ignore Closed files
- Optionally sort the output Ascending or Descending based on a label (and it doesn’t even have to be one of the labels being displayed!)
- Optionally Display All Labels, Only Labels that are defined or only Labels that are undefined
Asset Transfer Report
If you Transfer assets between portfolios, you are probably already aware of reports available that do this. Most transfer reports will transfer the entire portfolio. But what if you only want to transfer part of a portfolio? Or what if you want to transfer the portfolio to multiple portfolios and keep track of cost basis? APX has a pretty fancy report with some nice options (xferpos.rep), but we still took it a little further including:
- Transfer partial assets or the entire portfolio either off the system, to another portfolio or to multiple portfolios
- Option to transfer with or without cost basis and options to choose the closing method
- Ti/to or li/lo option
- Partial transfers can be done in several ways. Either a set % of the original portfolio, or the report will run through each holding for you to select how much to transfer (by % or # of shares), or if you know the asset(s), you can specify the exact assets or an asset type set (by % or #)
- No exporting/importing or external files needed
Cost Basis Reconciliation Adjustment Report
This report was designed to assist with Cost Basis Reconciliation by matching the tax lot position file to the custodial file with a more expansive comparison. Although the standard Reconciliation Report (sipos30) does cost lot comparisons and in APX has an option to post ‘ac’ transactions, I often would still have a lot of ‘breaks’ on my report that were considered acceptable or a good match.
With our enhanced report, you can set tolerances on cost or a # of days on the cost date. You can also optionally ignore the cost date and only do a comparison on the cost. And you have the option to Ignore type in those cases where you might have the security set up different than what shows in the position file. The report does a more extensive comparison of each client lot to every lot in the positional file to find a match. The remaining unmatched lots can optionally be adjusted to match the custodian and adjustments can be posted as an ‘ac’ or as li/lo transaction to reestablish the positions.
By allowing the tolerances, this report provides an easy way to correct and update your cost basis and produces a cleaner reconciliation report to help you get through the very tedious tasks of cost basis as painlessly as possible. But I’m not here to reinvent the wheel. I’ll leave that to the rest of the CES team. I’m just here to make your life better.