Project Description:
We have a bank statement in PDF format that Morgan Stanley provides monthly. There are a few pages in this document that have about 10 different Credit Card statements/transactions that we need to bring into CSV (Excel) in a standardized format.
We will need this to be automated because it will happen monthly.
Ideally, the script will be able to find the first credit card, and extract the transactions into an Excel file and save that file to disk with the last 4 digits of the CC as filename. For each CC statement found within the PDF, a new Excel file will be created.
There are multiple credit cards per page, in 2-column format. See attachment.
Once you can give it to us in separate file, we will handle what we need (bringing that into Access to convert it into IIF for Quickbooks).
** Please explain your expertise, and how you intend to do this. I'm a programmer, so you can talk technical.
