3 Replies Latest reply on Oct 17, 2014 2:03 AM by Indus Accounting

    How well does converting a PDF Bank Statement to Excel work?

    salsalam Level 1

      It's time to do taxes, and I'd love to save myself some time.  I noticed the PDF to Excel conversion for 20/year.  I'm tempted, but it's hard for me to believe that it really works well, especially for a bank statement.

        • 1. Re: How well does converting a PDF Bank Statement to Excel work?
          markerline Level 4

          If your financial institution offers online banking there is a good chance you can download an Excel version of your bank statement(s).  You may have to do each month one at a time but there will be no loss in conversion as it is already in Excel format.  There may be other formats too such as Comma-Delimited and perhaps Quicken or some other financial software compatibility version.

          • 2. Re: How well does converting a PDF Bank Statement to Excel work?
            dave_m_k Adobe Employee

            Good day,


            As markerline suggested, your financial institution may already offer an Excel-ready version of your statements.


            But to your questions, the results I've seen have been mixed.  The quality of the output of the ExportPDF service is directly related to the quality of the input.  Many bank statements don't contain a lot of actual formatting information within the PDF file itself.  As we state in our FAQ:

            Adobe ExportPDF is capable of exporting high quality information, but the quality of your Word or Excel document depends on the quality of the PDF file you start with. For instance, if your PDF file was originally authored in Microsoft Word or Excel and converted to PDF using the PDFMaker functionality of Adobe Acrobat®, your PDF file contains a rich set of information that can be captured by Adobe ExportPDF. This includes relative positioning of tables, images, and even multi-column text, as well as page, paragraph, and font attributes.


            If your PDF file was originally authored using simpler PDF generation methods, such as “print to PDF” or “scan to PDF” options, Adobe ExportPDF will convert any recognizable text and then use sophisticated conversion intelligence to preserve as much of the page layout as possible.


            I've bolded the key information in that passage.  If you subscribe to the service and you don't find it's meeting your need, you can return your purchase within 30 days for a full refund.


            Kind regards,

            • 3. Re: How well does converting a PDF Bank Statement to Excel work?
              Indus Accounting Level 1

              Hi David,


              I came across a software which helped me great deal when exporting pdf bank statements to excel. It saves a lot of time when you perform bank reconciliation


              Smartrex(OCR) is the web based solution making it only Online Bank Statement Extraction software in the market which extract information convert bank statements to Excel, PDF and CSV