Invoice Reconciliation

[Fortena5C34]

The invoice reconciliation process I have to do typically involves matching the amounts on the invoice in pdf form with the corresponding accounting printout also in Pdf form before I pay. Identifying any discrepancies or errors that need to be resolved. Once any discrepancies or errors are identified, they can be investigated and resolved through communication with the vendor or supplier.

I must manually match the Name, IBAN Number, Invoice Number, and amount on two different Pdf documents. What can be done to make this task quicker? it normally takes up 3 hours

Eg

So I would have one Pdf with a list of 100 bookings.

and on the other side, I would have 100 Pdfs for each invoice

any suggestions?

[try67]

It's extremely difficult to give any advice without seeing the actual files involved and getting a better understanding of how they are structured. If they contain "real" text in a fairly consistent manner then it should be possible to automate this task, either using a script (although it's pushing it for that much data) or a stand-alone tool, and produce a report about any discrepancies found. This will require the development of a custom-made tool, at any rate. It's not something you'd find off the shelf.

If you're interested in hiring a professional to create it for you (if possible), feel free to contact me privately by clicking my user-name and then on "Send a Message".

[Fortena5C34]

I was thinking Microsoft co-pilot could extract the data from the pdf's involved in the task as they are always in one drive and pull it into an excel sheet and then use formulas. It would say no and list the mistakes. I think building the system would cost a lot of money.

[Fortena5C34]

How much would that cost?

[try67]

I can't answer that before seeing the actual files. Please contact me privately to discuss it further.