Working with PortfolioCenter Transactions
Entering complete and accurate transaction data into PortfolioCenter is vital to having accurate reports and billing statements. While most transactions may come from Direct Interfaces and Data Aggregators, there may be times when you need to review, edit, or even enter transactions manually. This section offers documents that guide you through entering, editing, and managing transactions once they are in the database.
Examples Using Specific Wizards
- Using the Account Transfer Wizard
- Using the Cost Basis Reset Wizard
- Using the Income Reclassification Wizard
- Using the Global Cancel Wizard
- Using the Global Delete Wizard
- Using the Transaction Writer to Generate Management Fee Transactions
Corporate Action Wizards and Information
Corporate actions, such as mergers or spin-offs, can sometimes be intricate transactions to enter. We provide some data for you in our Corporate Actions Center. However, if you do not see what you need there, review the documents below to get help researching and entering the data using the Transaction Writer Wizards.
Identifying and Researching Actions
- Tips for Researching Corporate Actions
- Identifying Corporate Action Transactions in your Interface
- Understanding the Transactions after a Cash/Stock Merger
- Corporate Action FAQs
- Corporate Action Terminology
Entering Actions
Getting Started with the Cost Basis Reconciliation
SPT provides a cost basis reconciliation report to compare cost basis in PortfolioCenter with that of custodians that provide the data in their file downloads. To make it easy for you to follow the steps required to get started with cost basis reconciliation, the documents in this section have been placed in the order you should use them. For additional news and resources for ongoing cost basis requirements, visit our cost basis legislation section.
- Determine the taxable accounts to narrow your scope.
- Verify the default matching methods used in each account in PortfolioCenter matches the account setting at the custodians.
- If you have not already done so, upgrade to the most recent version of PortfolioCenter to get the latest enhancements.
- Run the cost basis reconciliation report to determine the securities with cost basis discrepancies.
- If the cost basis information from the custodian is incorrect, work with the custodian to update cost basis. In most cases, only cost basis for uncovered securities or newly transferred accounts can be updated at the custodian. For instructions on how to export cost basis data to custodians, contact the custodian directly.
- Review the common reasons that cost basis can become unreconciled to begin identifying why cost basis discrepancies appear on your report. For help with possible issues, see the section below on Troubleshooting Cost Basis in PortfolioCenter.
- Incorporate the cost basis reconciliation process into your daily operations.
- Determine how your firm will use cost basis and refine your reconciliation approach.
Understanding Cost Basis in PortfolioCenter
- How Matching Methods Affect the Cost Basis Calculation
- Cost Basis Terminology
- Cost Basis Usage Profiles
- Understanding the Realized Gains and Losses Report
- Understanding the Unrealized Gains and Losses Report
- Comparing Cost Basis and Cash Invested
- Establishing Matching Methods
- Creating a Taxable Smart Set
- Producing a Cost Basis File
- Managing Cost Basis to Display on Holding Reports Only
- Managing Cost Basis to Support Tax Efficient Trading
Troubleshooting Cost Basis in PortfolioCenter
- Reconciling Your Cost Basis Data
- Troubleshooting Cost Basis Reconciliation Issues Checklist
- Troubleshooting Cost Basis Reconciliation Issues: Incorrectly Mapped Symbols
- Troubleshooting Cost Basis Reconciliation Issues: Matching Method Discrepancies
- Finding Trade Lots with Zero Cost Basis
- Finding Matching Methods using the Transaction Export in the PortfolioCenter Export Wizard
- Producing a Cost Basis File
- Generating Reports to Troubleshoot Cost Basis Reconciliation Issues
Adjusting Cost Basis
- Entering Historical Cost Basis
- Entering Transactions to Account for Wholly Replaced Position Wash Sales in PortfolioCenter
- Handling Partial Wash Sales Series: One Initial Trade Lot
- Using the Income Reclassification Wizard
- Using the Cost Basis Reset Wizard
- Resetting the Historical Accounting Method for Mutual Funds
- Best Practices for Bifurcating Average Cost Basis for Mutual Funds
- Best Practices for Mass Updating the Cost Basis Accounting Method
- Maintaining and Exhausting Bifurcated Average Cost Positions
- Updating Cost Basis Reset Wizard Transactions after Backdated Transactions have been Posted
Manually Entering Special Transactions
- Income Types for Transactions in PortfolioCenter
- Expense Types for Transaction in PortfolioCenter
- Understanding Reduce Net and Reduce Gross for Expense
- Editing User Defined Expense Classifications
- Qualified and Non-Qualified Income in PortfolioCenter
Entering Transactions for Uncommon Events
- Best Practices for Accounting for a Transfer of Assets
- Entering Transactions to Account for Wholly Replaced Position Wash Sales in PortfolioCenter
- Handling Partial Wash Sales Series: One Initial Trade Lot
- Entering Transactions for Alternative Investments
- Entering Historical Cost Basis
- Deciding How to Handle Initial Position
- Best Practices for Closing Accounts in PortfolioCenter