{"id":26865,"date":"2021-10-27T15:56:26","date_gmt":"2021-10-27T19:56:26","guid":{"rendered":"https:\/\/wealthica.com\/blog\/?p=26865"},"modified":"2021-10-27T15:56:26","modified_gmt":"2021-10-27T19:56:26","slug":"dividend-tracking-spreadsheet-and-app","status":"publish","type":"post","link":"https:\/\/wealthica.com\/blog\/dividend-tracking-spreadsheet-and-app\/","title":{"rendered":"Dividend Tracking was Never that Easy!"},"content":{"rendered":"\r\n<p><strong>Dividend tracking is not a very fun activity. But it sure is necessary if you want to be certain that your investments make sense and you\u2019re heading in the right direction.<\/strong><\/p>\r\n\r\n\r\n\r\n<p>Indeed, tracking your dividends can be done through many trading platforms today. But if this isn\u2019t as customizable as you\u2019d like or you simply have more than one brokerage account, you probably need to do it on your own.<\/p>\r\n\r\n\r\n\r\n<p>Now, when I say \u201con your own\u201d, I only half-mean that. <strong>If you don\u2019t want to spend so much time, there are dividend tracking apps out there that will cut the work by more than half.<\/strong> These are basically apps you can use to track your dividend portfolio\u2019s performance and adjust your positions as necessary.<\/p>\r\n\r\n\r\n\r\n<p>If, on the other hand, you want to go old-school and track your dividends on your own using a spreadsheet, there are ways you can go about it too. There is also the option to save a lot of time by using a pre-made but still customizable spreadsheet.<\/p>\r\n\r\n\r\n\r\n<p>Let\u2019s take a look at each way and you can be the judge of what option fits you best&#8230;<\/p>\r\n\r\n\r\n\r\n<div id=\"rtoc-mokuji-wrapper\" class=\"rtoc-mokuji-content frame2 preset1 animation-fade rtoc_open default\" data-id=\"26865\" data-theme=\"Kicker Child\">\n\t\t\t<div id=\"rtoc-mokuji-title\" class=\" rtoc_left\">\n\t\t\t<button class=\"rtoc_open_close rtoc_open\"><\/button>\n\t\t\t<span>Contents<\/span>\n\t\t\t<\/div><ol class=\"rtoc-mokuji decimal_ol level-1\"><li class=\"rtoc-item\"><a href=\"#rtoc-1\">The Completely Manual Way to Dividend Tracking<\/a><\/li><li class=\"rtoc-item\"><a href=\"#rtoc-2\">The Semi-Manual Way to Dividend Tracking<\/a><\/li><li class=\"rtoc-item\"><a href=\"#rtoc-3\">The Automatic Way to Dividend Tracking<\/a><\/li><li class=\"rtoc-item\"><a href=\"#rtoc-4\">Effortlessly start tracking your dividends<\/a><\/li><li class=\"rtoc-item\"><a href=\"#rtoc-5\">Ready to Start Tracking Your Dividends?<\/a><\/li><li class=\"rtoc-item\"><a href=\"#rtoc-6\">Start tracking your dividends<\/a><\/li><\/ol><\/div><h2 id=\"rtoc-1\"  class=\"wp-block-heading\">The Completely Manual Way to Dividend Tracking<\/h2>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full is-resized\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2020\/02\/export-questrade-transactions-1.png\" alt=\"Export to Spreadsheet\" class=\"wp-image-16939\" width=\"841\" height=\"263\" srcset=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2020\/02\/export-questrade-transactions-1.png 598w, https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2020\/02\/export-questrade-transactions-1-300x94.png 300w\" sizes=\"(max-width: 841px) 100vw, 841px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Tracking your dividends the old-school way is not for all. Period. But if you have the time and enthusiasm for it, I think it\u2019s worth it.<\/p>\r\n\r\n\r\n\r\n<p><strong>First, because creating your own spreadsheet is very flexible.<\/strong> This way, you can customize everything and only set the information that matters to you most; not to mention setting the order that information is going to be presented in.<\/p>\r\n\r\n\r\n\r\n<p>Second, it is simply fun to do it this way!<\/p>\r\n\r\n\r\n\r\n<p><strong>If these reasons are enough for you, then I suggest you take a look at <a href=\"https:\/\/www.tawcan.com\/step-step-guide-make-google-spreadsheet-dividend-portfolio-template\/\" rel=\"noopener\">this guide<\/a> that shows you how to use Google Sheets and GoogleFinance to create an amazing spreadsheet from scratch.<\/strong><\/p>\r\n\r\n\r\n\r\n<p><strong>If, however, you are a Microsoft Excel guy, <\/strong><a href=\"https:\/\/investsomemoney.com\/create-an-amazing-dividend-tracking-spreadsheet-excel\/\" rel=\"noopener\"><strong>this guide<\/strong><\/a><strong> will serve you well.<\/strong><\/p>\r\n\r\n\r\n\r\n<p>But if you don\u2019t have the time or energy to spare, then you can either use <strong><a href=\"https:\/\/wealthica.com\/export-to-spreadsheet\/\">Wealthica<\/a><\/strong> to export your dividends to a spreadsheet (If you are using Wealthsimple, read <a href=\"https:\/\/wealthica.com\/blog\/wealthsimple-api-export\/\" data-type=\"URL\" data-id=\"https:\/\/wealthica.com\/blog\/wealthsimple-api-export\/\">how to export your Wealthsimple data to Google Sheets<\/a> &#8212; If you are using Questrade, read <a href=\"https:\/\/wealthica.com\/blog\/questrade-api-export-google-sheets\/\">how to export your Questrade data to Google Sheets<\/a>) or try the semi-manual way to do this yourself&#8230;<\/p>\r\n\r\n\r\n\r\n<h2 id=\"rtoc-2\"  class=\"wp-block-heading\">The Semi-Manual Way to Dividend Tracking<\/h2>\r\n\r\n\r\n\r\n<p>As I said, creating a dividend tracking spreadsheet from scratch isn\u2019t for everyone.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/10\/Dividend-Transactions.png\" alt=\"Dividend Tracking was Never that Easy!\"\/><\/figure>\r\n\r\n\r\n\r\n<p>But that\u2019s OK because there are countless pre-made customizable spreadsheets out there that will only require you to enter some values.<\/p>\r\n\r\n\r\n\r\n<p>Let\u2019s take a look at two of them:<\/p>\r\n\r\n\r\n\r\n<h4 class=\"wp-block-heading\" style=\"text-align:left;\">\ud83d\udcdd<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1_S2Y_SZX4wOmEENCi_1WCvQfNRnh9oD8mB3rpJL5s9w\/edit#gid=1857259220\" target=\"_blank\" rel=\"noreferrer noopener\">Invest Some Money Spreadsheet<\/a><\/h4>\r\n\r\n\r\n\r\n<p>I think I needed to start with this spreadsheet first because unlike most ones out there, this is exclusively focused on dividend tracking. And this is what you\u2019re here for in the first place.<\/p>\r\n\r\n\r\n\r\n<p>The first thing you will notice here is that this is a very minimalistic spreadsheet. And this makes sense because a dividend tracking spreadsheet only requires a few key values to help you efficiently track your dividends<\/p>\r\n\r\n\r\n\r\n<p>You can also automate this step by using <a href=\"https:\/\/wealthica.com\/export-to-spreadsheet\/\" data-type=\"URL\" data-id=\"https:\/\/wealthica.com\/export-to-spreadsheet\/\">Wealthica&#8217;s spreadsheet export feature<\/a>. You can first export your data from Wealthica to a spreadsheet and link this spreadsheet with the dividend tracking sheet.<\/p>\r\n\r\n\r\n\r\n<p>All in all, if you are looking for something to get started with quickly and you don\u2019t require too many bells and whistles, this spreadsheet is for you.<\/p>\r\n\r\n\r\n\r\n<h4 class=\"wp-block-heading\" style=\"text-align:left;\">\ud83d\udcdd<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1Thxed4_ROQWCIBE26bbbCKEIsihOLAJzAwPWJh2RQAU\/edit#gid=0\" target=\"_blank\" rel=\"noreferrer noopener\">Public Stock Dividend Tracker<\/a><\/h4>\r\n\r\n\r\n\r\n<p>Here\u2019s another dividend tracking spreadsheet that is mostly focused on dividend tracking.<\/p>\r\n\r\n\r\n\r\n<p>This spreadsheet is simple to use and it has the most relevant columns you\u2019re going to need. The only thing that is required on your part is to enter some values.<\/p>\r\n\r\n\r\n\r\n<p>The other thing that I like about this spreadsheet is that it has a dividend income pie <em>and<\/em> chart! No better way to identify the sources of your dividend income and how it has changed over time\u2026<\/p>\r\n\r\n\r\n\r\n<p>Again, you can automate this step by using Wealthica&#8217;s <a href=\"https:\/\/wealthica.com\/export-to-spreadsheet\/\" data-type=\"URL\" data-id=\"https:\/\/wealthica.com\/export-to-spreadsheet\/\">spreadsheet export<\/a> feature. You can first export your data from Wealthica to a spreadsheet and link this spreadsheet with the dividend tracking sheet.<\/p>\r\n\r\n\r\n\r\n<h2 id=\"rtoc-3\"  class=\"wp-block-heading\">The Automatic Way to Dividend Tracking<\/h2>\r\n\r\n\r\n\r\n<p>Is customizing a spreadsheet to your liking too much work for you? Do you want something more user-friendly to track your dividends? Enter the world of dividend tracking apps!<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/10\/Detailed-dividend-report.png\" alt=\"Dividend Tracking was Never that Easy! (2)\"\/><\/figure>\r\n\r\n\r\n\r\n<p><strong>Simply put, a dividend tracking app is going to do what a spreadsheet does and more in a simplified (but sophisticated at the same time) manner.<\/strong> Let me explain&#8230;<\/p>\r\n\r\n\r\n\r\n<p>Dividend investors are not exempt from the need to track everything from capital appreciation to dividends along with having a complete picture of their finances in one place.<\/p>\r\n\r\n\r\n\r\n<p><strong>If you just want to track your dividends and be done with it, you can simply pick a tool that\u2019s made just for this like <\/strong><a href=\"https:\/\/www.dividend.com\/\" rel=\"noopener\"><strong>dividend.com<\/strong><\/a><strong> or <\/strong><a href=\"https:\/\/trackyourdividends.com\/\" rel=\"noopener\"><strong>Track Your Dividends<\/strong><\/a><strong>.<\/strong><\/p>\r\n\r\n\r\n\r\n<p>But what about tracking everything from cash to capital appreciation and real estate assets? What about being able to connect all of your bank, brokerage, and <a href=\"https:\/\/wealthica.com\/blog\/crypto-tracking-feature\/\">crypto<\/a> exchange accounts in one place?<\/p>\r\n\r\n\r\n\r\n<p><strong>Well, if you want to have your cake and eat it too, I suggest you take a look at our <\/strong><a href=\"https:\/\/wealthica.com\/blog\/wealthica-vs-mint\/\"><strong>net worth tracker<\/strong><\/a><strong>, Wealthica. It is designed to track everything that constitutes your investment and overall financial situation by allowing you to securely link all of your financial institution accounts in one place!<\/strong><\/p>\r\n\r\n\r\n\r\n<p>And the best thing? <a href=\"https:\/\/wealthica.com\/blog\/why-is-wealthica-free\/\">It\u2019s <strong>free <\/strong>to use!<\/a><\/p>\r\n\r\n\r\n\r\n<p>You might think that a dividend tracking app wrapped inside a net worth tracker is not going to provide the same value as a dividend tracking spreadsheet. I understand that skepticism, but here are a few reasons that this isn\u2019t the case with Wealthica:<\/p>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\"><li><strong>It lets you see all of the dividend transactions from all your brokerage accounts in one place<\/strong><br><figure class=\"wp-block-image size-large responsive\"><\/li><li><strong>It gives you the ability to create different groups for your portfolios, so you can easily track all of the different accounts of your family members<\/strong><br><figure class=\"wp-block-image size-large responsive\"><\/li><li><strong>It will provide you with income reports<\/strong><br><figure class=\"wp-block-image size-large responsive\"><\/li><li><strong>And it will also give you detailed reports about the dividends that were paid to you<\/strong><br><br><figure class=\"wp-block-image size-large responsive\"><\/li><\/ol>\r\n\r\n\r\n\r\n<p>In other words, Wealthica is as much for people who need to get the complete financial picture as for dividend investors who want a reliable way to track their dividends like yourself.<\/p>\r\n\r\n\r\n\r\n<h2 id=\"rtoc-4\"  style=\"padding-bottom:0px;\">Effortlessly start tracking your dividends<\/h2>\r\n<p style=\"text-align:center; margin-top:0px; padding-top:0px;\">\r\nWealthica: The simplest way to track your dividends.\r\n<\/p>\r\n\r\n<p style=\"text-align:center;\">\r\n<a href=\"https:\/\/app.wealthica.com\/sign-up\" class=\"myButton\">Signup for a Free Wealthica Account Now<\/a>\r\n\r\n<style type=\"text\/css\">\r\n.myButton {\r\n\tbackground-color:#48285f;\r\n\tborder-radius:6px;\r\n\tborder:1px solid #48285f;\r\n\tdisplay:inline-block;\r\n\tcursor:pointer;\r\n\tcolor:#ffffff !important;\r\n    Font-style:normal !important;\r\n\tfont-family:Arial;\r\n\tfont-size:17px;\r\n\tfont-weight:bold;\r\n\tpadding:16px 31px;\r\n\ttext-decoration:none;\r\n}\r\n.myButton:hover {\r\n\tbackground-color:#48285f;\r\n}\r\n.myButton:active {\r\n\tposition:relative;\r\n\ttop:1px;\r\n}\r\n<\/style>\r\n<\/p>\r\n\r\n\r\n\r\n<h2 id=\"rtoc-5\"  class=\"wp-block-heading\">Ready to Start Tracking Your Dividends?<\/h2>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/wealthica.com\/blog\/wp-content\/uploads\/2021\/10\/Income-reports.png\" alt=\"Dividend Tracking was Never that Easy! (3)\"\/><\/figure>\r\n\r\n\r\n\r\n<p>As you may already have realized by now, there are 3 most distinct ways of tracking your dividend portfolio:<\/p>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\"><li><strong>Creating a dividend tracking spreadsheet from scratch and track the things that are most important to you<\/strong><strong><br><\/strong><\/li><li><strong>Using a premade spreadsheet that will only require giving it some values from you<\/strong><strong><br><\/strong><\/li><li><strong>Taking advantage of the technology that is out there and tracking your dividends using a dividend tracking app<\/strong><\/li><\/ol>\r\n\r\n\r\n\r\n<p>As I told you, creating a custom spreadsheet is only a good idea if you\u2019re either passionate about this stuff or you have at least enough time to spare.<\/p>\r\n\r\n\r\n\r\n<p>In most cases, if you\u2019re a spreadsheet guy and you\u2019re at least a little bit familiar with using one, then a premade dividend tracking spreadsheet is going to do wonders for you.<\/p>\r\n\r\n\r\n\r\n<p><strong>If, however, you\u2019re not the DIY type or you simply don\u2019t want to mess with any spreadsheet, a dividend tracking app will serve you well.<\/strong><\/p>\r\n\r\n\r\n\r\n<p>And not to mention that many apps like these have reached the point where they can do even more if you want them to. Wealthica is one of them and it\u2019s ideal if you also care to include your other assets and income sources into your financial picture.<\/p>\r\n\r\n\r\n\r\n<h2 id=\"rtoc-6\"  style=\"padding-bottom:0px;\">Start tracking your dividends<\/h2>\r\n<p style=\"text-align:center; margin-top:0px; padding-top:0px;\">\r\nWealthica: The simplest way to track your dividends.\r\n<\/p>\r\n\r\n<p style=\"text-align:center;\">\r\n<a href=\"https:\/\/app.wealthica.com\/sign-up\" class=\"myButton\">Signup for a Free Wealthica Account Now<\/a>\r\n\r\n<style type=\"text\/css\">\r\n.myButton {\r\n\tbackground-color:#48285f;\r\n\tborder-radius:6px;\r\n\tborder:1px solid #48285f;\r\n\tdisplay:inline-block;\r\n\tcursor:pointer;\r\n\tcolor:#ffffff !important;\r\n    Font-style:normal !important;\r\n\tfont-family:Arial;\r\n\tfont-size:17px;\r\n\tfont-weight:bold;\r\n\tpadding:16px 31px;\r\n\ttext-decoration:none;\r\n}\r\n.myButton:hover {\r\n\tbackground-color:#48285f;\r\n}\r\n.myButton:active {\r\n\tposition:relative;\r\n\ttop:1px;\r\n}\r\n<\/style>\r\n<\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/app.wealthica.com\/sign-up\"><strong>Sign up for a free account and start tracking your dividends in a simplified manner today!<\/strong><\/a><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Dividend Tracking shouldn\u2019t be hard. Either a well-made dividend tracking spreadsheet or a dividend tracking app is enough to start tracking your dividends.<\/p>\n","protected":false},"author":13,"featured_media":26503,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[14],"tags":[2386,2385,2395,2391,684],"class_list":["post-26865","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-investing","tag-dividend-portfolio","tag-dividend-tracker","tag-dividend-tracking","tag-investing","tag-wealthica"],"acf":[],"_links":{"self":[{"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/posts\/26865","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/comments?post=26865"}],"version-history":[{"count":22,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/posts\/26865\/revisions"}],"predecessor-version":[{"id":27695,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/posts\/26865\/revisions\/27695"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/media\/26503"}],"wp:attachment":[{"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/media?parent=26865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/categories?post=26865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wealthica.com\/blog\/wp-json\/wp\/v2\/tags?post=26865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}