We’ve greatly simplified the process of importing transaction spreadsheets from your brokerage into AdjustedCostBase.ca!\u00a0 We now offer a library of settings templates to choose from.\u00a0 Easily select and load the pre-configured settings template for your brokerage:<\/p>\n All you need to do is simply upload your unmodified transaction spreadsheet and confirm your transactions.<\/p>\n We have the settings templates for the following brokerages available:<\/p>\n Pro Tip:<\/b> Don’t see your brokerage? Let us know<\/a> and we\u2019ll build a template for it. You can also save your own custom templates for a truly personalized experience.<\/p>\n Data formats provided by brokerages are as varied as they are messy.\u00a0 Our spreadsheet import functionality is powerful enough to handle a wide variety of formats to get your data imported cleanly into AdjustedCostBase.ca.<\/p>\n In addition, our duplicate transaction detection functionality has been improved.\u00a0 No need to worry about uploading overlapping datasets or accidentally uploading the same spreadsheet twice – duplicate transactions will be detected and excluded automatically.<\/p>\n (Available for all AdjustedCostBase.ca users)<\/em><\/p>\n Whether you want to test a “what-if” strategy or transition to a new tax year, our new management tools give you total control.<\/p>\n Our new Portfolio Rollover \/ Duplication<\/em> functionality enables you to either carryover balances from one portfolio to another, or duplicate all of the transactions in a portfolio.\u00a0 This functionality can be accessed via the “Manage Portfolios” link (next to the drop-down portfolio selection field).<\/p>\n Carry over your ACB and share balances to a new portfolio without cluttering it with years of old transaction history. Perfect for starting a “Fresh Start” portfolio for 2026.<\/p>\n The Rollover Portfolio<\/em> operation enables you to carry over existing ACB and share balances from one portfolio into another.\u00a0 You can choose either the latest ACB and share balances, or choose to carry forward the closing ACB and share balances from a particular date.<\/p>\n With this operation, no transactions will be copied from the source portfolio to the destination portfolio.\u00a0 Rather, the initial ACB and share balances will be applied as a starting point in the destination portfolio.\u00a0 The system will apply the initial ACB and share balances before processing your transactions.<\/p>\n The operation can be useful when you want to separate your transactions into a different portfolio after a certain point in time.<\/p>\n If you update the source portfolio after performing the Rollover Portfolio operation, the new ACB and share balances will not be automatically reflected in the destination portfolio (the state of the destination portfolio will remain the same).\u00a0 However, you can perform the Rollover Portfolio operation again at any point to carry forward the latest ACB and share balances.<\/p>\n Create an exact 1:1 clone of your existing portfolio to test different tax scenarios without affecting your primary data.<\/p>\n This operation enables all transactions in the source portfolio to be copied into the destination portfolio.\u00a0 This results in the destination portfolio being identical to the source portfolio.\u00a0 This operation can only be performed if there aren’t any existing transactions in the destination portfolio.<\/p>\n Any subsequent changes you make to the source portfolio following the Duplicate Portfolio operation will not be reflected in the destination portfolio.<\/p>\n (Available for AdjustedCostBase.ca Premium users)<\/em><\/p>\n The T3 Preview tool can be found via the “Tools” link on the top blue menu bar.<\/p>\n Waiting for official T3 slips from brokerages can feel like watching paint dry. While official slips often arrive at the very last minute, the underlying data for ETFs and Trusts is usually available 6\u20138 weeks earlier.<\/b><\/p>\n This tool enables you to preview your T3 tax data earlier in the tax season if you own any ETFs, income trusts or other funds structured as a publicly-traded trust.<\/p>\n With the T3 Preview Tool, you can:<\/p>\n Validate your data:<\/b> Cross-reference your records against brokerage-reported numbers.<\/p>\n<\/li>\n File early:<\/b> If you\u2019re expecting a refund, don’t wait for the mail\u2014get your numbers ready in February.<\/p>\n<\/li>\n Granular detail:<\/b> See a full breakdown of Eligible Dividends, Capital Gains, and Foreign Income on a per-asset and per-distribution basis.<\/p>\n<\/li>\n<\/ul>\n To use this tool you must first complete the following:<\/p>\n You can choose which funds you would like to include in the report.\u00a0 You’ll only be able to include funds that had a positive share balance for at least one point in the tax year, and for which you’ve completed the process of importing return of capital and phantom distribution data.<\/p>\n Here is an example report:<\/p>\n![\"\"](\"https:\/\/www.adjustedcostbase.ca\/blog\/wp-content\/uploads\/spreadsheet_import_image.png\")
<\/a><\/p>\nNew: One-Click Brokerage Templates<\/h4>\n
<\/a><\/p>\n\n
Portfolio Duplication and Rollover<\/u><\/h2>\n
<\/a><\/p>\nRollover Portfolio<\/h4>\n
Duplicate Portfolio<\/h4>\n
T3 Preview Tool<\/u><\/h2>\n
<\/a><\/p>\nBeat the March 31st Deadline<\/b><\/h4>\n
\n
\n