JMata806
New Member
- Joined
- May 26, 2021
- Messages
- 12
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
My accounting clerk is going through invoices.
We recently acquired several hundred invoices from a company for 50 jackets.
Rather than simply invoice us for the 50 jackets they sent 50 individual invoices for each unique member and customer who purchased one.
Now we ate through this without issue going over each on at a time, but to save my clerk some time I was curious for future invoices that are similar in nature.
Is there a way to extract data from them and put them into a single spreadsheet.
Now I have done some power query before, but the issue here is the invoices are in a unique design.
I've included and example as a pdf. Bob's Invoice
Now normally I can convert tables or adjust rows without issue but since the "design" is kinda all over the place it makes it difficult to split the tables than merge all into a single spreadsheet for mutiple PDF's stored in the folder.
Am I just making this harder then it needs to be or should we just stick to doing these by hand?
As always your help is greatly appreciated!
We recently acquired several hundred invoices from a company for 50 jackets.
Rather than simply invoice us for the 50 jackets they sent 50 individual invoices for each unique member and customer who purchased one.
Now we ate through this without issue going over each on at a time, but to save my clerk some time I was curious for future invoices that are similar in nature.
Is there a way to extract data from them and put them into a single spreadsheet.
Now I have done some power query before, but the issue here is the invoices are in a unique design.
I've included and example as a pdf. Bob's Invoice
Now normally I can convert tables or adjust rows without issue but since the "design" is kinda all over the place it makes it difficult to split the tables than merge all into a single spreadsheet for mutiple PDF's stored in the folder.
Am I just making this harder then it needs to be or should we just stick to doing these by hand?
As always your help is greatly appreciated!