Surface Pro (2017) vs Surface Pro 4
I am trying to find a more efficient way of keying in supplier invoices into Quickbooks.
I have a third party app that allows me to load a daily file of revenue but I have been unable to convince our largest suppliers that they should be providing me a file instead of pdf invoices.
Is there any software out there that will take the pdf file and drop the key elements of the invoice into a spreadsheet for me to upload into my accounting software?
Thanks in advance
Now why would you want to do all that when entering a supplier bill into QuickBooks is so easy?
I think it is highly unlikely that you will find any software to read a PDF and export particular data into a spreadsheet. For a start, each PDF is going to be laid out differently.
Abbyy Fine Reader 9.0 says it can do this in its help files. As I haven't used pdf>Excel before, I conducted a quick test with a Yokohama tyre size table and it did quite a good job in putting all the table data into a spreadsheet.
While any decent OCR program will be able to read data in a table, and save it to Word or Excel, none of them are going to be able to interpret what the data means and place it in a particular cell of a spreadsheet.
In order for QuickBooks to import data from a spreadsheet, all data has to be in the right place. There's no OCR program that can do that for you, especially as the source PDF files will differ when reading varying styles of invoices from supliers.
Thanks guys for your comments.....
I had a feeling this was going to be a long shot!
I had originally reached out to my vendors to ask them to send me a report as apposed to the physical invoices but it was a no go.... its frustrating as we accomodate many of our customers with custom invoicing methods.... its all data so cant understand why it is (sending a report)so difficult.
We are a small company ($15M) and until recently I had an assistant who entered these for me... now its just little old me and I am getting a little bogged down with over 150 supplier invoices a day, not to mention managing everything else financial.
Oh well, it is what it is...
This thread is now locked and can not be replied to.