{"id":4922,"date":"2014-03-28T18:57:07","date_gmt":"2014-03-28T18:57:07","guid":{"rendered":"https:\/\/www.investintech.com\/resources\/blog\/?p=4922"},"modified":"2018-12-24T12:37:40","modified_gmt":"2018-12-24T12:37:40","slug":"calculating-taxes-excel-pdf","status":"publish","type":"post","link":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html","title":{"rendered":"3 Tips On How To Use Excel For Calculating Taxes From PDF Data"},"content":{"rendered":"<h6 style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4931 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg\" alt=\"Calculating-Taxes-Excel\" width=\"640\" height=\"480\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg 640w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1-300x225.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/> Photo Credit: <a href=\"http:\/\/www.flickr.com\/photos\/gonzalo_ar\/4080754733\/\" target=\"_blank\" rel=\"nofollow\" class=\"broken_link\">gonzalo_ar<\/a> via <a href=\"http:\/\/photopin.com\" target=\"_blank\" rel=\"nofollow\" class=\"broken_link\">photopin<\/a> <a href=\"http:\/\/creativecommons.org\/licenses\/by-nc-sa\/2.0\/\" target=\"_blank\" rel=\"nofollow\">cc<\/a><\/h6>\n<p>Tax season rolls around every year and with it comes the head ache of getting organized. It means digging up year old statements and revisiting your ledgers, which is a daunting task in itself. Even worse, if you\u2019re a procrastinator, it may mean the added stress of finding walk-in tax centres booked solid, forcing you to take the DIY approach.<\/p>\n<p>Admittedly, doing taxes yourself can be risky. But user-friendly tax software and speedy e-filing methods are incentive enough to make the attempt. Getting the numbers right is what matters most.\u00a0 For that, there\u2019s Microsoft Excel, one of the handiest tools for calculating and dealing with complex data.<\/p>\n<p>If it\u2019s your first time doing your taxes online, we\u2019ve got a few important pointers that can make working with taxes and Excel easier for you.<\/p>\n<h2><b>1. Insert, Adjust And Calculate Your Tax Data In Spreadsheets\u00a0<\/b><\/h2>\n<h6 style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4934 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Tax-Calculator.jpg\" alt=\"Tax Calculator\" width=\"640\" height=\"427\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Tax-Calculator.jpg 640w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Tax-Calculator-300x200.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/>Photo Credit: <a href=\"http:\/\/www.flickr.com\/photos\/franganillo\/3676227162\/\" target=\"_blank\" rel=\"nofollow\" class=\"broken_link\">Jorge Franganillo<\/a> via <a href=\"http:\/\/photopin.com\" target=\"_blank\" rel=\"nofollow\" class=\"broken_link\">photopin<\/a> <a href=\"http:\/\/creativecommons.org\/licenses\/by\/2.0\/\" target=\"_blank\" rel=\"nofollow\">cc<\/a><\/h6>\n<p>First off, to calculate your income taxes, you first need to calculate your taxable income. To do this, convert your financial data into Excel so you can work in your applicable deductions, credits, and exclusions using <a href=\"https:\/\/www.investintech.com\/resources\/articles\/excelcheatsheet\/\">Excel formulas and functions<\/a>. They can seem scary and complicated, but once you get the hang of them, they are invaluable!<\/p>\n<p>Second, because<b> <\/b>all invoices and tax deductible receipts are different, you want to <b>ensure that your converted data is properly adjusted and laid out. <\/b>\u00a0If you\u2019re calculating your federal income tax using tables in Excel, your results depend on where the data is placed. Thus, correctly inserting disparate data from the start will help prevent major calculation errors.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4936 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Able2Extract-Excel-Preview-Panel.jpg\" alt=\"Able2Extract Excel Preview Panel\" width=\"640\" height=\"400\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Able2Extract-Excel-Preview-Panel.jpg 640w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Able2Extract-Excel-Preview-Panel-300x187.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/> A <a href=\"https:\/\/www.investintech.com\/pdf-to-excel\/\">custom PDF to Excel conversion<\/a> though can fix the alignment of cells and their data just where you need them. Able2Extract lets you manually move the row and column lines and even give you a preview of how the data will look in your spreadsheet.<\/p>\n<h2><b>2. Use Separate Worksheets For Data Calculations <\/b><\/h2>\n<p>Every tax filing is different and depending on your situation you may need to use supplemental tax forms and schedules. You may also need other tools, like updated <a href=\"https:\/\/turbotax.intuit.com\/tax-tools\/tax-tips\/General-Tax-Tips\/Video--What-are-Tax-Tables-\/INF14266.html\" target=\"_blank\" rel=\"nofollow\" class=\"broken_link\">tax tables<\/a> or the tax computation worksheet from the <a href=\"https:\/\/www.irs.gov\/pub\/irs-pdf\/i1040gi.pdf\" target=\"_blank\" rel=\"nofollow\">1040 US tax return instructions<\/a>. \u00a0So consolidating your data where needed can be an efficient way to stay organized.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4937 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Naming-Excel-Worksheets.png\" alt=\"Excel Worksheet Names\" width=\"853\" height=\"91\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Naming-Excel-Worksheets.png 853w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Naming-Excel-Worksheets-300x32.png 300w\" sizes=\"auto, (max-width: 853px) 100vw, 853px\" \/><\/p>\n<p>Every tax form, calculation, or schedule requires special attention. Consequently, you may want to <b>use<\/b> <b>separate worksheets for different schedules or forms. <\/b>This way you can set each one up with defined formulas for calculating specific data.<\/p>\n<p>This has a lot of convenient benefits. Each year, you can go back to the same worksheet and just drop your updated numbers in. If you need numbers from different PDF statements, you can convert the relevant data into the same worksheet using Able2Extract.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4939 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Save-Custom-Excel-Template.png\" alt=\"Able2Extract Custom Excel Template\" width=\"640\" height=\"400\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Save-Custom-Excel-Template.png 640w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Save-Custom-Excel-Template-300x187.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/>Moreover, its custom Excel template feature, you can set up your Excel conversion once, save it as a template (seen above), and use it on next year\u2019s PDF statements, which, more than likely, will be formatted with the same layout.<\/p>\n<h2><b>3. Keep Data Formatting Consistent\u00a0<\/b><\/h2>\n<h6 style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4940 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Data-Format.jpg\" alt=\"Consistent Data Formatting\" width=\"640\" height=\"427\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Data-Format.jpg 640w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Data-Format-300x200.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/>Photo Credit: <a href=\"http:\/\/www.flickr.com\/photos\/franganillo\/3678747186\/\" target=\"_blank\" rel=\"nofollow\" class=\"broken_link\">Jorge Franganillo<\/a> via <a href=\"http:\/\/photopin.com\" target=\"_blank\" rel=\"nofollow\" class=\"broken_link\">photopin<\/a> <a href=\"http:\/\/creativecommons.org\/licenses\/by\/2.0\/\" target=\"_blank\" rel=\"nofollow\">cc<\/a><\/h6>\n<p>If you use different Excel formatting due to language and cultural preferences (commas for decimals or pound signs instead of dollar signs, for instance), you should make sure that all notations are consistent to avoid misinterpretation. Fortunately,\u00a0Microsoft Excel is highly specialized in formatting and manipulating data.<\/p>\n<p>To fix the formatting in Excel, you can use the <b>Sort &amp; Filter<\/b> and <b>Data Tools<\/b> section in the <b>Data tab<\/b> or the <b>Numbers<\/b> and <b>Editing<\/b> sections in the <b>Home tab<\/b>. \u00a0To do this even more efficiently, reformat your PDF data even before it even reaches the spreadsheet. With PDF receipts and records, you can <b>change the notation and formatting during the PDF to Excel conversion. \u00a0<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4941 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Excel-Conversion-Parameters.png\" alt=\"Able2Extract Excel Conversion Parameters\" width=\"496\" height=\"358\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Excel-Conversion-Parameters.png 496w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Excel-Conversion-Parameters-300x216.png 300w\" sizes=\"auto, (max-width: 496px) 100vw, 496px\" \/><\/p>\n<p>Using the MS Excel conversion parameters in Able2Extract will adjust your data to fit the format you want to use in your spreadsheet, like whether or not to replicate the fonts from the PDF. Retain the dollar sign as a separate symbol, use European continental settings, or treat rows as columns and vice versa.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Photo Credit: gonzalo_ar via photopin cc Tax season rolls around every year and with it comes the head ache of getting organized. It means digging up year old statements and revisiting your ledgers, which is a daunting task in itself. Even worse, if you\u2019re a procrastinator, it may mean the added stress of finding walk-in &#8230; <a title=\"3 Tips On How To Use Excel For Calculating Taxes From PDF Data\" class=\"read-more\" href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html\" aria-label=\"More on 3 Tips On How To Use Excel For Calculating Taxes From PDF Data\">Continue reading \u2192<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,332],"tags":[50,232,136,45,95,135,32,85,290,116,138,59,122],"class_list":["post-4922","post","type-post","status-publish","format-standard","hentry","category-investintech-tips","category-tech-tips-tutorials","tag-able2extract","tag-data-analysis","tag-finance","tag-ms-excel","tag-ms-office","tag-pdf-conversion","tag-pdf-file","tag-pdf-to-excel","tag-personal-finance","tag-spreadsheets","tag-taxes","tag-tips","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>3 Tips On How To Use Excel For Calculating Taxes From PDF Data<\/title>\n<meta name=\"description\" content=\"Some handy tips on how to calculate taxes in Microsoft Excel with financial data from your PDF documents.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 Tips On How To Use Excel For Calculating Taxes From PDF Data\" \/>\n<meta property=\"og:description\" content=\"Some handy tips on how to calculate taxes in Microsoft Excel with financial data from your PDF documents.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html\" \/>\n<meta property=\"og:site_name\" content=\"PDF Blog | Investintech PDF Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2014-03-28T18:57:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-24T12:37:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg\" \/>\n<meta name=\"author\" content=\"Reena\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@able2extract\" \/>\n<meta name=\"twitter:site\" content=\"@able2extract\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html\"},\"author\":{\"name\":\"Reena\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409\"},\"headline\":\"3 Tips On How To Use Excel For Calculating Taxes From PDF Data\",\"datePublished\":\"2014-03-28T18:57:07+00:00\",\"dateModified\":\"2018-12-24T12:37:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html\"},\"wordCount\":698,\"publisher\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg\",\"keywords\":[\"Able2Extract\",\"data analysis\",\"finance\",\"MS Excel\",\"MS Office\",\"PDF conversion\",\"pdf file\",\"PDF to Excel\",\"personal finance\",\"spreadsheets\",\"taxes\",\"tips\",\"tutorial\"],\"articleSection\":[\"Investintech Tips\",\"Tech Tips and Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html\",\"name\":\"3 Tips On How To Use Excel For Calculating Taxes From PDF Data\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg\",\"datePublished\":\"2014-03-28T18:57:07+00:00\",\"dateModified\":\"2018-12-24T12:37:40+00:00\",\"description\":\"Some handy tips on how to calculate taxes in Microsoft Excel with financial data from your PDF documents.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#primaryimage\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg\",\"contentUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg\",\"width\":640,\"height\":480,\"caption\":\"Calculating Taxes In Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.investintech.com\/resources\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3 Tips On How To Use Excel For Calculating Taxes From PDF Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#website\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/\",\"name\":\"PDF Blog | Investintech PDF Solutions\",\"description\":\"Everything PDF\",\"publisher\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.investintech.com\/resources\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\",\"name\":\"PDF Blog | Investintech PDF Solutions\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp\",\"contentUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp\",\"width\":270,\"height\":40,\"caption\":\"PDF Blog | Investintech PDF Solutions\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/able2extract\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409\",\"name\":\"Reena\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g\",\"caption\":\"Reena\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"3 Tips On How To Use Excel For Calculating Taxes From PDF Data","description":"Some handy tips on how to calculate taxes in Microsoft Excel with financial data from your PDF documents.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html","og_locale":"en_US","og_type":"article","og_title":"3 Tips On How To Use Excel For Calculating Taxes From PDF Data","og_description":"Some handy tips on how to calculate taxes in Microsoft Excel with financial data from your PDF documents.","og_url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html","og_site_name":"PDF Blog | Investintech PDF Solutions","article_published_time":"2014-03-28T18:57:07+00:00","article_modified_time":"2018-12-24T12:37:40+00:00","og_image":[{"url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg","type":"","width":"","height":""}],"author":"Reena","twitter_card":"summary_large_image","twitter_creator":"@able2extract","twitter_site":"@able2extract","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#article","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html"},"author":{"name":"Reena","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409"},"headline":"3 Tips On How To Use Excel For Calculating Taxes From PDF Data","datePublished":"2014-03-28T18:57:07+00:00","dateModified":"2018-12-24T12:37:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html"},"wordCount":698,"publisher":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg","keywords":["Able2Extract","data analysis","finance","MS Excel","MS Office","PDF conversion","pdf file","PDF to Excel","personal finance","spreadsheets","taxes","tips","tutorial"],"articleSection":["Investintech Tips","Tech Tips and Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html","url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html","name":"3 Tips On How To Use Excel For Calculating Taxes From PDF Data","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#primaryimage"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg","datePublished":"2014-03-28T18:57:07+00:00","dateModified":"2018-12-24T12:37:40+00:00","description":"Some handy tips on how to calculate taxes in Microsoft Excel with financial data from your PDF documents.","breadcrumb":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#primaryimage","url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg","contentUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2014\/03\/Calculating-Taxes-Excel1.jpg","width":640,"height":480,"caption":"Calculating Taxes In Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/4922-calculating-taxes-excel-pdf.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.investintech.com\/resources\/blog\/"},{"@type":"ListItem","position":2,"name":"3 Tips On How To Use Excel For Calculating Taxes From PDF Data"}]},{"@type":"WebSite","@id":"https:\/\/www.investintech.com\/resources\/blog\/#website","url":"https:\/\/www.investintech.com\/resources\/blog\/","name":"PDF Blog | Investintech PDF Solutions","description":"Everything PDF","publisher":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.investintech.com\/resources\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization","name":"PDF Blog | Investintech PDF Solutions","url":"https:\/\/www.investintech.com\/resources\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp","contentUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp","width":270,"height":40,"caption":"PDF Blog | Investintech PDF Solutions"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/able2extract"]},{"@type":"Person","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409","name":"Reena","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g","caption":"Reena"}}]}},"_links":{"self":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/4922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/comments?post=4922"}],"version-history":[{"count":25,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/4922\/revisions"}],"predecessor-version":[{"id":8969,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/4922\/revisions\/8969"}],"wp:attachment":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/media?parent=4922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/categories?post=4922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/tags?post=4922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}