Will the software take a column of dollar amounts and put it into an excel spreadsheet automatically?
Yes. It is possible to do that. Just type PDF in the page bellow to get a template that reads a PDF.
Also, in this link bellow there is a tutorial about Excel:
It is just a matter of connecting the dots.
Hope that helps.