topic Re: K-1 PDFs reader in Alteryx Designer Desktop Discussions

K-1 PDFs reader

Taxautomation — Wed, 15 May 2024 14:57:38 GMT

Hi, I am an Alteryx noob. Does anyone work in Tax and know if Alteryx can read K-1s in PDF and report the line item with it's respective character? For example, see line 6a ordinary dividends and 9a long term capital gain and bring each amount.

I know this is a long shot if I wanted to get the information from the footnotes, but since the face of the K-1 is the same, I thought there could be a good opportunity for automation?

Re: K-1 PDFs reader

apathetichell — Wed, 15 May 2024 20:37:37 GMT

Are we talking taxpackagesupport generated k1s or scanned in that someone receives? I'm curious about the taxpackagesupports ones now so if I get a chance I'll write something up. (ie native pdfs or scanned pdfs)

Re: K-1 PDFs reader

Taxautomation — Thu, 13 Jun 2024 15:11:47 GMT

Hey, these are individual K-1s not in a package. Some do come with the state K-1s attached as well but for the most part they are individual files from different partnerships we are invested in. Please let me know if you think of something.

Apologies for the late reply.

Re: K-1 PDFs reader

apathetichell — Fri, 14 Jun 2024 13:28:23 GMT

All good - taxpackagesupport is the primary provider of k1s for mlps. I tried to read in one via Python and wasn't thrilled with the results (ie it would require more parsing/transformation than I wanted to do) - perhaps check out some of Alteryx's internal intelligent suite pdf tools.