{"id":1130,"date":"2016-05-14T14:03:25","date_gmt":"2016-05-14T18:03:25","guid":{"rendered":"http:\/\/www.adjustedcostbase.ca\/blog\/?p=1130"},"modified":"2022-10-14T10:21:47","modified_gmt":"2022-10-14T14:21:47","slug":"importing-transactions-from-a-spreadsheet","status":"publish","type":"post","link":"https:\/\/www.adjustedcostbase.ca\/blog\/importing-transactions-from-a-spreadsheet\/","title":{"rendered":"Importing Transactions Into AdjustedCostBase.ca from a Spreadsheet"},"content":{"rendered":"

AdjustedCostBase.ca provides a feature to premium subscribers allowing transactions to be uploaded in bulk from a spreadsheet into the ACB calculation engine.\u00a0 Accepted file formats include Microsoft Excel (both .xls and .xlsx files) as well as CSV (.csv comma-separated value files).<\/p>\n

This feature is only available to AdjustedCostBase.ca Premium<\/strong> subscribers.\u00a0 The cost of the enhanced service is $49\/year.\u00a0 The basic features of AdjustedCostBase.ca remain completely free for Canadian investors.<\/p><\/blockquote>\n

This feature can be extremely useful if you have transactions in a spreadsheet file that you’ve exported from your brokerage account or if you prefer to compile a list of transactions using Excel or other spreadsheet software.\u00a0 By uploading the data using this feature, you can potentially save many hours of time and avoid data entry errors.<\/p>\n

This feature can be accessed after logging into AdjustedCostBase.ca by following the “Import Transactions from Spreadsheet” link found on most pages, including the home page and new transaction page:<\/p>\n

\"Import<\/a><\/p>\n

After following the link you’ll be brought to this form:<\/p>\n

\"Import<\/a><\/p>\n

From here you’ll be able to configure the format for the spreadsheet you wish to upload.\u00a0 The columns included in the spreadsheet as well as the column ordering can be customized in a wide variety of ways.\u00a0 The default column configuration includes the following 6 required columns:<\/p>\n

\n\r\n
Security<\/strong><\/td>\nThe name of the security, which must match an existing security that you've already added to your account.<\/td>\n<\/tr>\n\r\n
Date<\/strong><\/td>\nThe date for each transaction. When uploading an Excel spreadsheet (either .xls or .xlsx format) the date column should be formatted using any of Excel\u2019s built-in date formats.\u00a0 When uploading a CSV file, the date column must be in \u201cMM\/DD\/YYYY\u201d format.<\/td>\n<\/tr>\n\r\n
Transaction Type<\/strong><\/td>\nThe transaction type in each row must be set to one of the following supported values: \"Buy\", \"Sell\", \"Return of Capital\", \"Capital Gains Dividend\", \"Reinvested Dividend\" or \"Reinvested Capital Gains Dividend\".<\/td>\n<\/tr>\n\r\n
Amount<\/strong><\/td>\nThe dollar amount of the transaction, assumed by default to be the total amount (as opposed to a per share amount).<\/td>\n<\/tr>\n\r\n
Shares<\/strong><\/td>\nThe number of shares acquired or sold, applicable only to \"Buy\", \"Sell\" and \"Reinvested Dividend\" transactions.<\/td>\n<\/tr>\n\r\n
Commission<\/strong><\/td>\nThe total commission amount for the transaction, applicable only for \"Buy\" and \"Sell\" transactions.<\/td>\n<\/tr>\n<\/tbody><\/table><\/div>\n

In addition, you can specify the following optional columns:<\/p>\n

\n\r\n
Total or Per Share<\/strong><\/td>\nThe value should be either \"Total\" or \"Per Share\" to specify whether a transaction amount is a total amount or per share amount (if this column isn't used the amount will be assumed to be the total amount).<\/td>\n<\/tr>\n\r\n
Memo<\/strong><\/td>\nAny free text that you wish to add as a memo for the transaction.<\/td>\n<\/tr>\n\r\n
Price in Foreign Currency?<\/strong><\/td>\nIndicates whether or not the value in the amount column is in a foreign currency, with the following acceptable values: \"Yes\"\/\"Y\"\/\"No\"\/\"N\".<\/td>\n<\/tr>\n\r\n
Exchange Rate?<\/strong><\/td>\nThe exchange rate applicable for the transaction, entered as the number of units of foreign currency equal to CAD$1.00.\u00a0 Alternatively, one of the following currency codes: \"USD\", \"EUR\", \"JPY\", \"GBP\", \"AUD\", \"CHF\" or \"CNY\". If a currency code is inputted, the exchange rate value reported by the Bank of Canada for the transaction's date will be used.<\/td>\n<\/tr>\n\r\n
Commission in Foreign Currency?<\/strong><\/td>\nIndicates whether or not the value in the commission column is in a foreign currency, with the following acceptable values: \"Yes\"\/\"Y\"\/\"No\"\/\"N\".<\/td>\n<\/tr>\n<\/tbody><\/table><\/div>\n

By default, transactions with the same dates for the same security will be imported in the order in which they appear in the spreadsheet (top to bottom), but you can reorder<\/a> them at any time after the import.<\/p>\n

You should check off the option “Ignore Header Row” if the spreadsheet you’re uploading includes a header row.\u00a0 If this option is set, the first row of the spreadsheet will be ignored during the import process.<\/p>\n

A maximum of 500 transactions may be uploaded at a time.\u00a0 If you need to upload more transactions at once you’ll need to break your spreadsheet into multiple files.<\/p>\n

To demonstrate this feature, let’s assume that you have the following Excel spreadsheet:<\/p>\n

<\/a><\/p>\n

Once the spreadsheet is ready to be uploaded, follow the “Import Transactions from Spreadsheet” link on AdjustedCostBase.ca, and configure the form as follows to match the columns and column ordering in the spreadsheet:<\/p>\n

<\/a><\/p>\n

Also ensure that “Ignore Header Row” is checked because the spreadsheet includes a header row.\u00a0 Next, hit the browse button to find the spreadsheet file on your local hard drive.\u00a0 Finally, hit the “Import Transactions” button.\u00a0 The transactions will not be added immediately, and you’ll have a chance to review all the data before committing the transactions.\u00a0 Review this information carefully to ensure its accuracy.<\/p>\n

<\/a><\/p>\n

You may also see errors if there are invalid entries in the spreadsheet.\u00a0 The error messages should be detailed enough to help you identify and fix the errors, at which point you can try re-uploading the spreadsheet.<\/p>\n

Once your transactions have been successfully imported, you’ll be brought to a confirmation page showing the list of imported transactions:<\/p>\n

<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

AdjustedCostBase.ca provides a feature to premium subscribers allowing transactions to be uploaded in bulk from a spreadsheet into the ACB calculation engine.\u00a0 Accepted file formats include Microsoft Excel (both .xls and .xlsx files) as well as CSV (.csv comma-separated value files). This feature is only available to AdjustedCostBase.ca Premium subscribers.\u00a0 The cost of the enhanced […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1130","post","type-post","status-publish","format-standard","hentry","category-adjustedcostbase-ca-site-help"],"_links":{"self":[{"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/posts\/1130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/comments?post=1130"}],"version-history":[{"count":26,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/posts\/1130\/revisions"}],"predecessor-version":[{"id":1425,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/posts\/1130\/revisions\/1425"}],"wp:attachment":[{"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/media?parent=1130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/categories?post=1130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.adjustedcostbase.ca\/blog\/wp-json\/wp\/v2\/tags?post=1130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}