Hi ALL.

I don’t know if this is possible but I will start by asking here. I work at a manufacturing plant. We sell items and also take returns from the stores. We have large chain stores that pay with one check for 100’s of invoices at once. Currently the accounts receivable dept manually matches up the invoice number and amount in our accounting system to the invoice number and dollar amount on the statement that is sent with the check.
She has a printed .pdf that she goes line by line comparing the invoice the chain paid for then finds it in our accounting system to mark as paid. When the price paid does not match the price on the invoice, she needs to figure out why.
I have asked the field rep to ask others in the same business how they do this process. He has not got any answer for me.
My next step is trying to find a way to automate some of this since I can’t find any other way to do it. One thought is to scan the pdf to convert to an excel file. Then see if I can get help to create an excel VB script that will compare the invoice number and dollar amount form the statement showing what it is paying to an excel file that has my invoices information then have it mark off any invoice numbers and dollar amount that match then flag any that do not match.
Anywhere the amount if different than the invoice amount in our system needs to be addressed.

Does anyone have any ideas how this can be automated? I welcome good ideas or anyone telling me why my idea wont work. I don’t want to work on this and realize it does not help.
Thanks ALL