Free Axys report
Aggregate Purchase and Sale Report with Gain/Loss
Displays purchase, sale, short sale, short cover, return of capital, capital adjustment, and principal paydown transactions with the original price and realized gain or loss.
August 2020: corrected formatting when showing the security symbol and lumping closing transactions.
- Runs on
- Axys
- Category
- Transactions
- Updated in Portal+
- November 2025
- Cost
- Free with registration
When you run it
What the report asks for
These settings come from the report's dialog box. Options can vary with your Axys version and configuration.
- Portfolio or group
- Start date, with an optional end date
- Reporting currency
- Lump closing transactions
- Lump all transactions by security
- Show capital adjustments, returns of capital, and principal paydowns
- Show purchased and sold accrued interest
- Show security symbol
Where it fits
Transactions in Axys
Transaction reports trace what moved in and out of accounts over a period. They are the first place to look when reconciling, answering a client question, or preparing for an audit.
This version is written for Axys.
Getting the report
Free for Axys users, through Portal+.
- 01
Register
Complete the free registration form with your firm and the portfolio system you use.
- 02
CSSI confirms your account
CSSI reviews the request and sends what you need to sign in to Portal+.
- 03
Download and install
Download the report from the Web Reports page in Portal+, which includes installation instructions for Axys and APX.
Each version runs through the end of the calendar year. Download the current version from Portal+ each January.
Axys and APX environments vary. Test the output with your own data before using the report in a production workflow.
Related reports
More transactions reports
- AxysBank Notification Letter, Management StyleWhen run for an unconsolidated group, creates a single management style report showing trades for every member of the group.
- AxysCash Activity Between Two DatesEnter two dates and a portfolio or group to see every li, lo, dp, wd, ti, and to cash transaction between them, with total contributions, total withdrawals, and net activity.
- AxysMissing Cost Information, Management StyleA management style variation of Advent's List Missing Cost Basis report.
- AxysPurchase and Sale Report with Gain/LossSimilar to the standard Purchase and Sale report, with original cost and gain/loss for sell transactions.
- AxysPurchase and Sale Report, Management StyleA management style version of CSSI's Purchase and Sale report that can be filtered to a security type or symbol.
- AxysPurchase and Sale Report, Single SecurityAn alternate-format, management style version of CSSI's Purchase and Sale report that can be filtered to a security type or symbol.
Need something different?
Get a version built around your firm's data.
CSSI's consulting team handles report development for Axys and APX, from modifying a Replang report to building SSRS report packages.
