Invoice Reconciliation

Question

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 · Answer

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".

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded