convert bank of america statements PDF to Excel not working properly

Hi,.
If the conversion lacks precision with Adobe, you can use an online bank statement converter.

After spending an entire day trying to figure this out and thinking there was an issue with my system fonts, I found a work around.

I'm on a mac but I imagine the equivalent steps would work on a PC.

I open my bank statement as a pdf and take a screen shot (command+shift+4) of just the sections I want (my Bank of America statement has sections with logos, etc.) and save those to my desktop. I then open each one in Preview or your image viewer and export them as a pdf, giving each one a name like Feb page1, Feb page 2, etc, so I know the correct order they appeared on the statement. I then combine the new pdfs in Acrobat, making sure pages are turned the same way and in the correct order. Then take the new combined file pdf and export it as an excel file...voila, works like a charm and saved so much time.

Best,

George

Conversion to Excel (or Word) frequently depends upon how the PDF file is created. You will have better luck with a PDF created from with Excel using the Acrobat Ribbon than one created from a print to PDF from the same version of Excel.

Hi laurenl76524681 ,

Would like to inform you that on exporting the  PDF file to excel this is an expected behavior, as PDF is of different structure & excel is having row-column structure.

Also Export PDF helps in converting the file with less complexity .

Would suggest you to try Acrobat Pro DC (use Trial version) to check whether the conversion is taking with out any discrepancy .

Regards,

Yatharth