Importing ADP payroll extracts to Beancount

64 views
Skip to first unread message

soubra

unread,
Oct 22, 2020, 3:28:07 PM10/22/20
to Beancount
Hi everyone, 

I tried posting this question on reddit but I'm rarely successful getting any responses. 

Anyone here has had any luck importing ADP info into Beancount?

I am trying to get a breakdown of my corporate salary, and current firm uses ADP. 

Any help is appreciated.

Thank you,

soubra

Red S

unread,
Oct 23, 2020, 2:26:57 AM10/23/20
to Beancount
Long ago, I had to download data from ADP. Now, it's a different provider. Both had/have the same problem: no obvious way to export data to csv/ofx or anything other than pdf.

PDFs are a mess with automation. I use pdftotext, followed by a simple python parser/importer to get payroll data into Beancount. These days, I use Tabula based on a recommendation by Martin. The cool thing is, templates for pdfs can be saved and scripted. Now, things "just work" in automation 80% of the time once I go through the pain of downloading each paycheck separately.

I know you were looking for an ADP specific solution, but I thought I'd share my experience that it's not too much effort to cook up your own importer if you're unable to find an existing solution. Good luck!

soubra rohlfs

unread,
Oct 24, 2020, 11:14:19 AM10/24/20
to bean...@googlegroups.com
Thank you for sharing your experience. I guess you are correct, I’ll just have to deal with the pain for now.

Thanks again!

soubra

On Oct 23, 2020, at 02:26, Red S <redst...@gmail.com> wrote:


--
You received this message because you are subscribed to a topic in the Google Groups "Beancount" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/beancount/drvhmEfdTnA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to beancount+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/5d642860-3f1e-4723-b5b6-cd4c3af7838co%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages